R Vanaja Mobile No: +* (***)-(***)-****

DataStage Developer adxxgv@r.postjobfree.com

PROFESSIONAL SUMMARY ::

Overall, 8 years of career reflecting worked experience in Design, Development, testing and Production support and maintenance of ETL application projects.

Extensive experience in IBM InfoSphere Data Stage 8.7, 9.1, 11.5 and 11.7.

Worked on DataStage components like DataStage Designer, DataStage Director and Datastage Administrator.

Designed complex DataStage jobs, Sequences and tuned them for better performance.

Expert in Unit Testing.

Extensive Knowledge on Data warehousing Methodologies.

Good Knowledge in writing SQL queries in Oracle Database.

Experienced in Unix Environment, File transfers.

Experienced in UNIX commands according to the business requirements and maintaining the files.

Good Domain Knowledge in Finance and Retail Banking.

Solid Knowledge on using DataStage Third Party Tools.

Testing and setting up the Peer reviews for each of the modules to minimize the Development errors.

Experienced in SDLC Agile methodology of Data Warehouse Life Cycle.

Capable to work individually as well in the team.

Reliably meets demanding deadlines and targets working under pressure.

Flexible to get adapted to new environment.

Have knowledge in working with snowflake.

TECHNICAL SKILLS: -

ETL Tools : IBM Infosphere DataStage 8.7/9.1/11.5/11.7.

Operating Systems : Windows & AIX

Reporting Tools : Tableau

Database : DB2, Oracle, SQL

Third Party Tools : Putty, VSS, MS Visio, Tivoli.

Scripting languages : UNIX Shell Scripting

ACADEMICS :

Master of Technology in Computer Science from JNTUH.

WORK EXPERIENCE :

Working in Slk Software Solutions, Bangalore from October 2016 to till date.

Worked in Zensar Technologies, Hyderabad from – Nov 2012 to October 2016.

HANDS ON PROJECTS :

Project #4 (Jan 2019- Present)

Title : Consumer DWBI

Client : Fifth Third Bank

Organization: SLK Software Solutions

Environment : DataStage 11.7, Oracle 10g, UNIX, Windows

Role : DataStage Developer

Team size : 4

Designation : Senior Software-Engineer

Project Description:

Fifth Third Bank is an international financial institution headquarters in Cincinnati, Ohio. FTB has the total assets of $142 billion; FTB provides banking products and services for personnel and business needs. It provides personal banking products and services include checking accounts, savings accounts, preferred programs, credit cards, debit cards, real life rewards, reloadable prepaid cards, cash banking mortgages, equity lines and loans, auto financing, personal lines of credit and loans, CDs, IRAs, investments, insurance strategies, planning center, internet banking and online bill payment, mobile banking, overdraft coverage, early access and identity theft protection.

NGSSA is an application for Fifth Third Bank Employees, through these application employees can fulfill the goals based on their roles on monthly, quarterly, and yearly basis based on the threshold limit of goal value, to be paid employee’s incentives.

Responsibilities:

Working as onshore coordinator.

Gathering requirements from business and analyze on impact on our application, communicate with client and team.

Coordinating with offshore team and client about the code changes, business impact.

Developed ETL jobs and ETL process using DataStage.

Implemented the Purging through ETL jobs.

Involved with development of ETL process flows to transform data from multiple sources into common Staging area and then loaded them to the target Warehouse Database.

Integrated sources from Flat files and Databases.

Creating Staging designs and analyzing source data.

Implemented best practices of ETL.

Involved in performance tuning and Unit testing.

Used the Shell Scripts for running the session.

Created DataStage Sequencers to run Batch jobs.

Used various stages like DB2 Connector, Transformer, sequential file, Dataset, row generator, aggregator, copy and change capture Stages.

Implemented UNIX scripts for delete the files.

Project #3 : (March 2017 – Dec 2018)

Title : PPC

Client : Fifth Third Bank

Organization: SLK Software Solutions

Environment : DataStage 9.1, Oracle 10g, UNIX, Windows

Role : DataStage Developer

Team size : 2

Designation : Software-Engineer

Project Description:

Fifth Third Bank is an international financial institution headquarters in Cincinnati, Ohio. FTB has the total assets of $142 billion; FTB provides banking products and services for personnel and business needs. It provides personal banking products and services include checking accounts, savings accounts, preferred programs, credit cards, debit cards, real life rewards, reloadable prepaid cards, cash banking mortgages, equity lines and loans, auto financing, personal lines of credit and loans, CDs, IRAs, investments, insurance strategies, planning center, internet banking and online bill payment, mobile banking, overdraft coverage, early access and identity theft protection.

PPC is an application for FTB customers, through these application customers can pay their loans for third party banks by weekly basis, when they reach the threshold limit. Customer’s all

Debit card transactions store in PPC app.

Responsibilities:

Developed ETL jobs and ETL process using DataStage.

Implemented the Purging through ETL jobs.

Involved with development of ETL process flows to transform data from multiple sources into common Staging area and then loaded them to the target Warehouse Database.

Integrated sources from Flat files and Databases.

Creating Staging designs and analyzing source data.

Implemented best practices of ETL.

Involved in performance tuning and Unit testing.

Used the Shell Scripts for running the session.

Created DataStage Sequencers to run Batch jobs.

Used various stages like DB2 Connector, Transformer, sequential file, Dataset, row generator, aggregator, copy and change capture Stages.

Implemented UNIX scripts for delete the files.

Project #2 : (Oct 2016 – Feb 2017)

Title : P2P

Client : Fifth Third Bank

Organization: SLK Software Solutions

Environment : DataStage 9.1, Oracle 10g, UNIX, Windows

Role : DataStage Developer

Team size : 4

Designation : Software-Engineer

Project Description:

Fifth Third Bank is an international financial institution headquarters in Cincinnati, Ohio. FTB has the total assets of $142 billion; FTB provides banking products and services for personnel and business needs. Its personal banking products and services include checking accounts, savings accounts, preferred programs, credit cards, debit cards, real life rewards, reloadable prepaid cards, cash banking mortgages, equity lines and loans, auto financing, personal lines of credit and loans, CDs, IRAs, investments, insurance strategies, planning center, internet banking and online bill payment, mobile banking, overdraft coverage, early access and identity theft protection.

Person-to-person payments, customers will be able to send, receive and request money to virtually with anyone with a U.S bank account as long as the sender has the recipient’s registered email address and phone number.

Responsibilities:

Developed ETL jobs and ETL process using DataStage.

Involved with development of ETL process flows to transform data from multiple sources into common Staging area and then loaded them to the target Warehouse Database.

Integrated sources from Flat files and Databases.

Creating Staging designs and analyzing source data.

Implemented best practices of ETL.

Involved in performance tuning and Unit testing.

Used the Shell Scripts for running the session.

Created DataStage Sequencers to run Batch jobs.

Used Lookup and Transformer Stages.

Project #1 : (Sep 2015 – Oct 2016)

Title : Building Reference Dataflow.

Client : CNB

Organization: Zensar Technologies

Environment : Oracle 10g, UNIX, Windows, DataStage 9.1

Role : DataStage Developer

Team size : 9

Designation : Associate engineer

Project Description:

City National Bank is an American financial institution Headquarter in California. CNB has the total assets of $35 billion; it offers a full complement of banking, trust and investment services through 75 offices.

City National Bank would like to develop and execute an enterprise-wide Reference Data strategy for BASEL, CNB Critical Elements to improve the efficiency of their regulatory compliance, promote understanding of their data landscape, and improve data confidence for a variety of roles within the organization. In addition, reference data should be maintained in such a way as to provide an historical view of data as it occurred at the time the transaction was loaded.

Responsibilities:

Developed ETL jobs and ETL process using DataStage.

Involved with development of ETL process flows to transform data from multiple sources into common Staging area and then loaded them to the target Warehouse Database.

Integrated sources from Flat files and Databases.

Creating Staging designs and analyzing source data.

Implemented best practices of ETL.

Involved in performance tuning and Unit testing.

Used the Shell Scripts for running the session.

Created DataStage Sequencers to run Batch jobs.

Used Lookup and Transformer Stages.

Contact this candidate