SUMMARY

• Around 10 years of profound IT experience in Design, Development and Implementation of Relational Database and Data Warehousing Systems using IBM DataStage (v8.1, 8.5, 8.7, 9.1, 11.5 and Ascential DataStage v7.5) Client - Server environment.
• Proficient in all stages of SDLC (Software Development Life Cycle).
• Analyze the Functional requirements, Mapping document and translate them into Technical Design specification.
• Understand the E3 Framework how Confidential process ETL operations
• Create and maintain Technical design, ETL mapping document, Production migration and support documents.
• Create highly scalable ETL design mappings for data integration and transformation from various source systems including ACH, Banctec, ECTO, FileServ, Optima, Vector, Zelle Systems.
• ETL Mappings using IBM Infosphere DataStage and load data into the Netezza / Hadoop.
• Unit Test, Code Review, Performance tune to make sure project specific requirements and SLA’s are satisfied.
• Prepared a Tableau Dashboard for EMMA Application as per the client needed
• Support and Troubleshoot failures in Production environment and provide immediate resolution without impacting the Business users.
• Ensure the whole IBM Infosphere DataStage jobs runs without any issues while read / write data to source & target systems.
• Validate the functional requirements by verifying the data displayed in business reports is as expected and matches with the source data loaded thru IBM Infosphere DataStage Job.
• Perform various data related operations in ESDA database using Workbench / Aginity.
• Extracting the data from AWS S3 buckets, Text files, JSON using Snowflake
• Create and cloning databases, tables as needed using Snowflake

TECHNICAL SKILLS

Tools: & Utilities: IBM Infosphere Datastage (11.5,9.1 & 8X & 7X), TABLEAU, Bigdata Concepts (HDFS, Hive, Sqoop)

RDBMS: DB211.1, SQL Server 2016, Oracle 18c, Netezza

Cloud DWH: Snowflake, Salesforce, AWS (Usage of S3 Buckets)

Languages: SQL, PL SQL, Unix Shell

Tools: & Utilities: Microsoft Visio, HP Quality Center, TOAD, AQT, FileZilla, WinSCP, Harvest (Version Control), Putty, SOAP UI, SVN Tortoise, ESP, Aginity

Scheduling Tools: TWS (Tivoli Work Scheduler), ESP, Control-M

Operating Systems: Unix, Linux and Windows

PROFESSIONAL EXPERIENCE

Confidential

ETL DataStage Developer

Responsibilities:

• Analyze the Functional requirements, Mapping document and translate them into Technical Design specification.
• Create and maintain Technical design, ETL mapping document, Production migration and support documents.
• Create highly scalable ETL design mappings for data integration and transformation from various source systems including ACH, Banctec, ECTO, FileServ, Optima, Vector, Zelle.
• ETL Mappings using IBM Infosphere DataStage and load data into the Netezza /Hadoop.
• Unit Test, Code Review, Performance tune to make sure project specific requirements and SLA’s are satisfied.
• Prepared a dashboard using Tableau as per client needed
• In order to prepare the dashboard applied multiple filters by using the measures and metrics
• Prepared different dashboards as per the requirement and showed up maximum information in a single place with featured labels and content.
• To organize the main dash board and child dashboard applied navigation concepts
• Applied all calculations with unique values and also validate through SME’s.
• Validate the functional requirements by verifying the data displayed in business reports is as expected and matches with the source data loaded thru IBM Infosphere DataStage Job.
• Perform various data related operations in EMMA using Workbench / Aginity.
• Extracting the data using Snowflake from S3 Buckets, JSON files, text files.

Environment: IBM Infosphere DataStage 11.5, Windows XP, Netezza, Unix, Service NOW, Tableau, WinSCP, Putty, Control-M (Scheduling)

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Analyze the Functional requirements, Mapping document and translate them into Technical Design specification.
• Create and maintain Technical design, ETL mapping document, Production migration and support documents.
• Create highly scalable ETL design mappings for data integration and transformation from various source systems including Client, Marketer, Policy and Transaction Systems.
• ETL Mappings using IBM Infosphere DataStage and load data into the Salesforce / Oracle application.
• Unit Test, Code Review, Performance tune to make sure project specific requirements and SLA’s are satisfied.
• Create Unix script and Visio Flow diagrams for the ESP scheduler to schedule the scripts /sequences.
• Support and Troubleshoot failures in Production environment and provide immediate resolution without impacting the Business users.
• Ensure the all IBM Infosphere DataStage jobs runs without any issue and read / write data to source & target systems / applications.
• Validate the functional requirements by verifying the data displayed in business reports is as expected and matches with the source data loaded thru IBM Infosphere DataStage Job.
• Perform various data related operations in ESDA database using Workbench / Toad.
• Co-ordinate and work with multiple teams to make sure all the dependencies are aligned during implementation and migration

Environment: IBM Infosphere DataStage 11.5, Windows XP, Oracle, Unix, Service NOW, ESP, Putty

Confidential, Greenville, South Carolina

ETL Consultant

Responsibilities:

• Understand the requirements and document their expectations, handling the current process, modifying and created the jobs to the updated requirements, handle the load process to Salesforce Database.
• Extract the data using salesforce stages and loaded into salesforce database.
• Actively participating in SIT & UAT testing.
• Gathering multiple countries of sales data and prepare analysis of what data loaded into the tables and what are the countries are in queue which are ready to load in salesforce.
• Reporting to Client Manager about the files load status time-to-time.
• Clarify all the questions and answers of the Opportunity flow to Client manager.
• Prepared technical design / specification of data Extraction, Transformations.
• Maintaining requirement tracker which can help let the status to know everyone in team.
• Taking care end-to-end testing as per FSD requirements and validating data as per client need.
• Performed release management planning to ensure release are scheduling inline of existing process and the business deadlines.
• Performed Root Cause Analysis, ETL code fix /data fix for Data issues raised by the Salesforce team.

Environment: IBM Infosphere DataStage 11.5 & 8.7, Windows XP, Salesforce, Unix, Service NOW, Tivoli, FileZilla, SVN Tortoise, Putty

Confidential, Cincinnati, Ohio

ETL Consultant

Responsibilities:

• Understand the requirements and document their expectations, handling the current process, modifying and created the jobs to the updated requirements, handle the load process to data marts.
• Extract the data using salesforce stages and loaded into salesforce database.
• Provided a solution for ETL jobs from (‘. p’ progressive language) to SQL query language.
• Strong experience in writing DDL / DML statements.
• Prepared technical design / specification of data Extraction, Transformation and Loading.
• Built E2E ETL solutions beginning from data modeling till Production implantation.
• Worked closely with the ETL / DB Admin team to ensure that all Database / ETL objects and components are correctly migrated for the production deployment.
• Using SQL queries and pull the data from different tables and generate files as per FSD requirements.
• Taking care end-to-end testing as per FSD requirements and validating data as per client need.
• Worked for version and data migration Datastage jobs from 9.1 to 11.5
• Performed release management planning to ensure release are scheduling inline of existing process and the business deadlines.
• Performed Root Cause Analysis, ETL code fix /data fix for Data issues raised by the business in the data marts.
• Once data loaded into target database as per client requirement and then using SAP BO generate visualized reports for client need.
• Worked performance tuning at various levels of Target, Source for large datasets.
• Guiding peers and reviewing their code.
• Providing end to end support for UAT (User Acceptance Test) and production deployment.

Environment: IBM Infosphere DataStage 11.5 & 9.1, Windows XP, DB2, Unix, Site scope, Tivoli

Confidential

ETL Consultant

Responsibilities:

• Prepared technical design / specification of data Extraction, Transformation and Loading.
• Built E2E ETL solutions beginning from data modeling till Production implantation.
• Worked closely with the ETL / DB Admin team to ensure that all Database / ETL objects and components are correctly migrated for the Production deployment.
• Performed release management planning to ensure release are scheduling inline of existing process and the business deadlines.
• Extract real time data using XML stage with the help of web services
• Worked for version migration Datastage jobs from 8.5 to 9.1
• Performed Root Cause Analysis, ETL Code fix /data fix for Data issues raised by the business in the Data marts.
• Worked performance tuning at various levels Target, Source for large datasets.
• Guiding peers and reviewing their code
• Providing end to end support for UAT (User Acceptance Test) and Production deployment.

Environment: IBM Infosphere DataStage 8.5 & 9.1 Windows XP, DB2, Unix, Sitescope, Tivoli

Confidential

ETL Consultant

Responsibilities:

• Understanding the Technical design document and Source-To-Target mappings.
• Created jobs to extract the source from different sources.
• Created Jobs using various stages in data stage Designer.
• Analysis of Existing Source and Target System
• Analyzed the performance of the jobs and enhanced their performance.
• Designed the job using the stages like Aggregator, Transformer, Look-up, Filter, Remove Duplicate, Copy, Dataset, and Sequential file set.
• Involved in testing the developed codes, fixing defects if any and redoing the test and fix upon delivery to the client manager.
• Scheduled jobs using data stage Director.
• Monitored and validated the jobs using data stage Director.
• Involved guiding peers and reviewing their code.
• Provide support during implementation of projects

Environment: IBM Infosphere DataStage 8.5, Windows XP, Oracle 11g, Linux