Profileimage by koushik janapareddi Consultant Specialist WTX /ITX   from Bangalore

koushik janapareddi

available

Last update: 22.11.2017

Consultant Specialist WTX /ITX

Graduation: B.tech
Hourly-/Daily rates: show
Languages: English (Limited professional)

Attachments

koushik_janapareddi.doc

Skills

  • IBM Certified Application Developer - WebSphere Transformation Extender v8.2 .
  • Well experienced in Oracle 8i/9i/10g/11g including PL/SQL programming and also shell scripting
  • Well experienced in Design Studio Components like Type Tree Designer, Map Designer, and Database Interface Designer
  • Well experienced in Design, Development and Testing of maps and Interface components integration using Mercator/Datastage TX.
  • Experience in using various Mercator Adaptors (File, Database, Sink etc.) as source and destination in data transformations (XML to Database, Database to flat file and database to XML, and vise-versa).
  • Worked on various message formats like xml, Flat files, delimited used by partner systems.
  • Well versed with connectivity with SFTP, C: D (Connect: Direct) .
  • Good Knowledge on ANSI X12, SWIFT,EDIFACT.
  • Worked on EDI transactions such as 855 , 857, 810 , 850 and 997 .
  • Implemented WTX migration projects as per HSBC Standards (Such as LINUX to Solaris movement)
  • Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Synonyms, Nested Tables and Collections.
  • Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
  • Coordinating with the developers and discussing the technical problems, reporting bugs and supporting the team in rectifying issues
  • Implementing project plans within deadlines and defining best practices for project support and documentation
  • Carrying out case / system / process study for project planning, scoping, estimation & tracking .
  • Strong abilities in testing, involving setting-up of test environment, creation of test scripts/cases, conducting manual testing, user acceptance testing, bug verifications and exploratory testing
  • Adept in analysing the user requirements and developing test procedures & test cases
  • An effective communicator with good analytical, planning, problem solving and time management
Utility Tools :
  • Individually Developed a utility using core WTX commands and properties which helped Production Support to find exact error  data and column details rather generic error message I,e “One or more inputs invalid ” .

Project history

Project Experience:
Project Title: GCS Project  
Client         : Baxter
Description:
       Baxter is a medical product manufacturing company which supplies across globe. JDE Application manages several information about suppliers, Customers etc . This data need to be accessed to marketing, sales, customer service users, manufacturing, finance, logistics & warehouse. These users view the contact information from within number of different applications (SIEBEL, WMS etc.) . The intent of this integration is to broadcast Address book updates to several applications either in EDI or XML format.
Responsibilities:
  • Drafting Business Requirement Specifications document that gives the detailed information about the requirements
  • Creating detailed process flow diagrams and updating the documents.
  • Created the maps, compiled and executed them locally (Windows XP) and server (Linux) as per requirement type trees and maps from scratch to meet the business requirements
  • Performed unit level testing and Integration level testing to confirm the client requirements.
  • Communicate the project status and work status effectively to management and client on a regular basis
Environment: WTX 8.4,ITX, Oracle 10g/11, SVN,Jenkins, Citrix Application. MQ , Cast Iron .
Project Title          :     Global Billing System.
Client                     :       HSBC
Description:
Global Billing System (GBS) is an automated billing solution used to bill the transactions carried out by the corporate customers. It has been deployed in 25 countries. It performs the following functions:
  • Receive the transactions from back office
  • Carry out the classification and aggregation of the transactions
  • Authorization of transactions / Rejections in case of problems
  • Rate and Bill the transactions
  • Carry out the accounting, payment and accrual operations
  • Generating Invoices in different delivery channels.
Responsibilities:
  • Drafting Business Requirement Specifications document that gives the detailed information about the requirements
  • Playing key resource as a Lead Consultant for development and deploying the application in Asia Pacific countries, EU countries and handled BAU requests for all regions.
  • Responsible for generating the type trees using XML DTDs, databases and building as per EDR provided by business.
  • Key resource in migration projects from Linux to Solaris.
  • Created the maps, compiled and executed them locally (Windows XP) and server (Linux) as per requirement type trees and maps from scratch to meet the business requirements
  • Coordinating in PL/SQL and maps code review and modification for the development of new requirements
  • Contacting Application Team, Vendors and clients to gather the information for migration and other requirements as per there regulatory
  • Developing code in shell scripting to work generic for multiple countries, this reduced lot of development efforts and helped in quick deployments in DEV/SAT/UAT/Live
  • Performed unit level testing and Integration level testing to confirm the client requirements.
  • Writing high quality and well documented code according to standards
  • Implemented NLS requirements in APAC countries (Chinese, Japan, Korea) as per regulatory change .
  • Communicate the project status and work status effectively to management and client on a regular basis
  • Engaged in handling the changes in complex scripts according to the database changes
  • Gave on call support, solved the user issues and made necessary changes
  • Resolved the Production Severity Issues in time and meeting the SLA
Environment: Ascential DatastageTX8.0, WTX8.2/8.4, Oracle 10g/11, MKS Integrity tool, Linux, Quality Center, shell scripting, RTC (Rational Team Concert).

Local Availability

Only available in these countries: India
Profileimage by koushik janapareddi Consultant Specialist WTX /ITX   from Bangalore Consultant Specialist WTX /ITX
Register