RaviTeja ALS

 Used the:
• IBM WebSphere DataStage designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• DataStage Director and its run-time engine for testing and debugging its components, and monitoring the resulting executable versions
 Independently performed complex troubleshooting, root-cause analysis and solution development
 Retrieved the source data from of Oracle tables, Sequential files, web services
 Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application

Projects Handled:
Project Title: HSBC
Team: HDW (Household Data Warehouse)
Methodology: Waterfall
Client: HSBC North American Holdings
Location: Capgemini, Offshore
Team Size: 18
Duration: Feb 2016 - Present
Environment: Data stage, UNIX, Control-M, WINSCP, DB2, Teradata

About Client: HSBC Bank USA, National Association, an American subsidiary of UK-based HSBC Holdings plc, is a bank with its operational head office in New York City and its nominal head office in McLean, Virginia (as designated on its charter). HSBC Bank USA, N.A. is a national bank chartered under the National Bank Act, and thus is regulated by the Office of the Comptroller of the Currency (OCC), a part of the U.S. Department of the Treasury.

Project Description: The objective of HDW is basically to have an in-house management of customer data to support the Bank’s Revenue and Deposit Growth strategy; Creating a Central accessible data store in HSBC for deposit account and transaction data, with supporting customer-level data, to improve our informational capabilities in terms of more frequent, more detailed information to ultimately drive deposit growth. This is envisioned as Central Enterprise Data warehouse for HBUS PFS Data.

Key Deliverables as Team Member/Developer/Support:
 Monitoring all data stage jobs and providing production support to all
 Used CONTROL-M job Scheduler to schedule the Datastage jobs to run the daily jobs and weekly jobs
 Successfully written UNIX shell script to handle automation of daily batch
 Worked on various stages viz. transformer, aggregator, lookup, join, merge, remove duplicates, funnel filter stages etc.
 Automated the process of data stage jobs
 Involved in implementing all jobs in production for all newly changed jobs to improve performance

Project Title: Capital One Financial - CRS Data warehouse
Client: Capital One
Methodology: Agile
Location: Capgemini, Offshore
Team Size: 22
Duration: Jun 2013 - Feb 2016
Environment: Data Stage, UNIX, Db2 Control-M

About Client: Capital One Financial Corporation is a U.S.-based bank holding company specialized in credit cards, home loans, auto loans, banking and savings products. When measured in terms of total assets and deposits, Capital One is the eighth largest bank holding company in the United States.

Project Description: The Project is of team - 22 @ offshore. This Project involves creation of the feeds for Customer Account, Customer Suppression and Internal Fraud analytics data COF Marketing decisions and reporting. It majorly involves integrating the existing Cards and Retail services for North America Data Warehouse Applications into existing Capital One CDW and PDW environment app art from migrating the data from HSBC Owned servers to COF Owned servers which involved some changes to the existing system. It is also used to interpret claims processing and to respond to customer inquiries regarding claims processing.

Key Deliverables for Production Support and Enhancements:
Resolved abends and updated the resolution in the repository
Ensured adherence to the SLA standards
Executed adhoc tasks if assigned
Shared consolidated reports and logs with client on daily basis
Generated various weekly and monthly reports
Provided operational support to all production practices on holidays and weekends
Worked on ADHOC tasks on DATASTAGE