SUMMARY

• Working as Senior ETL Consultant in Scrum/Agile Development Model for Ab Initio - Talend conversion
• 14+ years of experience in Data warehousing, end to end ETL implementations, data integration, data migration, data ingestion and data analysis projects
• 14+ years of experience of Data Warehouse Design, Development, Testing, Deployment and Production support.
• 12+ years of expertise in writing complex SQL queries, performance tuning and worked on different databases (Oracle, DB2, SQL Server, Teradata and Netezza)
• 10+ years of experience in InfoSphere IBM DataStage 11.5/9.1/8.5/7.5
• 10+ years of experience in Unix Shell Scripting and 5+ of PL/SQL development
• 4+ years of experience Netezza and 2+ in Oracle Exadata
• 3+ years in Talend DI/ Data Mapper / Big Data / Apache Spark (v6.4.1) and 1 year experience in Ab Initio
• 2+ years in Big Data, Hadoop, HDFS, Hive, AWS for processing huge volumes of data
• Experience in on-shore/off-shore model and L1/L2/L3 model
• Implementing Complex ETL Solutions with the help of ETL tools like DataStage, Talend and Ab Initio
• Experience in tuning and troubleshooting performance issues in ETL processing
• Solutions driver with excellent analytical and troubleshooting skills
• Worked on Regulatory reporting applications (Basel III, CCAR and Liquidity reporting) for Confidential and Deutsche Bank
• Defined and Implemented ITIL Best Practices for Production Support, Incident, Problem and Change Management
• Experience of providing technical innovative solutions as per business requirements. Bridging the gap between business and technology and End to End Implementation of Business Requests
• ETL Process automation using Shell scripting and Control M
• Worked on PL/SQL procedures, functions and packages, NZSQL procedures, TSQL procedures
• Lead onshore/off shore development/support team in Deutsche and Confidential regulatory reporting projects
• Lead IT repatriation Program for Deutsche Bank from Planning to successful Implementation
• Worked on Data Modelling and designed Star and Snowflake schema
• Working Knowledge of R, Python and Machine Learning

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere DataStage v11.5/9.1/8.5/7.5, Talend 6.4.1, Ab Initio

Programming: SQL, PL/SQL, Unix shell scripting, NZPLSQL, T-SQL

Tools: Oracle SQL Developer, TOAD, Aginity Workbench, iCEDQ

RDBMS/Utilities: Oracle 9i/11g, Netezza 7.2, DB2, Teradata, Hive, Hue, IBM MDM, Talend MDM, Hadoop, GIT, Jenkins

OS, Platforms: Windows 2000/XP/7, Unix, Linux, IBM InfoSphere BigInsights, Cloudera CDH 5.5, Amazon EMR 5.8

Scheduling Tools: Control M, Unix Cron, DBArtos, DataStage Scheduler, Oozie

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

Senior ETL (Talend / Ab Initio) Consultant

Responsibilities:

• Working on technical design, development, testing, deployment and Support of ETL processes using Talend
• Developed complex ETL mappings using the Talend DI, Talend Data Mapper and Talend Big Data tools
• Handled EBCDIC, XML, CSV files using Talend and Performance tuning of the Talend jobs
• Data Extraction and Loading using Oracle and AS400 components and its performance tuning
• Unit Testing and Comparison with Ab Initio by updating and execution of Ab initio Graphs
• Created Bigdata/ Apache Spark jobs for performance improvements for processing huge volume of data
• Unix Scripting for Talend jobs and creation of plan for ESP scheduler
• Documentation of changes and support in QA cycles and production.
• Working on of TAC and GIT/Stash and Working in AGILE environment.

Environment Talend DI, Talend Data Mapper, Talend Big Data /Spark (6.4.1), Oracle 11g, Oracle PL/SQL Developer, SQL, Unix shell scripting, Ab Initio, GIT, Stash, TAC, Cloudera

Confidential, Springfield, MO

Senior ETL Consultant

Responsibilities:

• Interacted with business to ensure that their business requirements are understood and documented correctly for Marketing Campaign and Cabela’s Merger
• Working on Data warehouse which is built on Netezza appliance
• Working on technical design, development, testing, deployment and Support of ETL processes using DataStage and QualityStage(v11.5) and Netezza 7.2 as database
• Develop different data stage jobs using Netezza connector stage to write data to database
• Develop different data stage jobs to extract data using Netezza connector stage, Hierarchical XML and SCD stage
• Develop/ update of existing Netezza procedures and functions as per business requirements
• Development of Unix shell scripts to automate the ETL process.
• Analysis, troubleshooting, re-creation and diagnosis of business-critical incidents along with RCA
• Created Talend DI ETL jobs for Marketing Module

Environment: IBM InfoSphere DataStage and QualityStage(v11.5), Netezza 7.2, Aginity Workbench, SQL, Unix shell scripting, Talend DI 6.3, IBM MDM

Confidential, Stamford, CT

Senior ETL Consultant

Responsibilities:

• Interacted with client operations to ensure that their data requirements are understood
• Worked on the development of Talend and DataStage during the migration
• Used Validation, Checksum, Reconciliation techniques in testing source(Netezza) and targets (Red Shift)
• Used Amazon EMR to process the data into Hadoop
• Ensuring that data is successfully migrated to new database by different automated methods
• Responsible for writing detailed SQL queries to analyze current system requirement or create new functionality for development of tool using Hadoop to enhance the performance
• Created a job to load data into Talend MDM
• Creation of procedure and function in PL/SQL and TSQL for new feature for iCEDQ
• Analysis, troubleshooting, and diagnosis of business-critical incidents along with RCA
• Shouldering the role of Technical Subject Matter Expertise for regulatory reporting applications
• Worked in ITIL Environment and instrumental part in setting up standard processes
• Develop Talend DI/ Big Data jobs for reference Data loading
• Written Hive queries for data analysis to meet the business requirements.
• Creating Hive tables and working on them using Hive QL.
• Importing and exporting data into HDFS and Hive using Talend.
• Creating PoCs using Control M, DataStage, Talend for better system performance

Environment: Oracle Exadata, SQL, PL/SQL, Netezza, Aginity Workbench, PL/SQL Developer, Unix shell scripting, DataStage 9.1, Talend DI 6.3, Cloudera CDH 5.5, Bigdata, Hadoop, Hive, Hue

Confidential

Senior ETL Consultant Specialist

Responsibilities:

• Worked on design of Data Model and designed Data model for regulatory reporting
• Technical SME for handling critical issues and business user queries
• Mainly worked on Data Analysis and how issues are reported by the Business/Sites
• Analysis, troubleshooting, re-creation and diagnosis of business-critical incidents along with RCA
• Develop different data stage components like Funnel, Transformer, Sort, join, Lookup, Merge, Filter, Change Capture, Aggregator, Copy, Pivot, Remove Duplicates, Surrogate Key, Dataset and Sequential File etc.
• Develop different data stage jobs using Netezza connector stage to write data to database
• Integrated Big Data Components in DataStage and created jobs using DB2, Oracle connector stages
• Created DataStage jobs to read and write data from Hadoop
• Create PL/SQL procedures, functions and packages and trained different teams on Datastage DB2 and PL/SQL
• Worked on technical design, development, testing, deployment and Support of ETL processes using DataStage
• Design, build plans, resource allocation done for the task and reviews
• Develop different data stage components like Funnel, Transformer, Sort, join, Lookup, Merge, Filter, Change Capture, Aggregator, Copy, Pivot, Remove Duplicates, Surrogate Key, Dataset and Sequential File etc.
• For system improvements and change requests, handled team of 7-8 persons
• Worked on implementation of Business change requests end to end.

Environment: DataStage v7.5, 8.5, Unix Shell Scripting, Ctrl-M, SQL, PL/SQL, Unix Shell, QlikView, DB2, Oracle, Teradata

Confidential

ETL Developer

Responsibilities:

• Analyze and design ETL solutions for new requirements and Production issues.
• Interact with business users and understand the requirements, and analyze and come up with optimal technology solutions to business requirements
• Design, Develop, & Implement various ETL solutions using DataStage ETL tool
• Hands on development experience ETL processes to acquire and load data from internal and external sources
• Conduct technical impact analysis and work estimate for new tasks, system improvements and bug fixes
• Write high level and low-level design documents, Documents of understanding, Conduct peer code review
• Liaison between the business team (Business Analysts), Development team & Management.
• Creation stored packages, procedures, functions and triggers.
• Design, Development, Testing unit and Integration testing of PL/SQL packages
• Worked on SQL Loader to load the huge data in database and worked on performance issues while migration
• Performed source analysis and target analysis, and prepared data mapping and process flow documents.
• Analysis of the specifications provided by the clients
• Design, Development, Unit Testing and Integration testing of DB packages, PL/SQL programming.
• Basic GUI development using Oracle forms 6i and reports 6i
• Appreciation by Clients on resolving key issues in switch bill and reporting

Environment: SQL, PL/SQL, Oracle 8i/9i, TOAD, PLSQL Developer, Oracle Forms 6i, reports