SUMMARY

• Around 10 years of total IT experience in Development, Maintenance, support & upgrade of Enterprise Data Warehouses, Data marts, BIG data Hadoop Enterprise application & Infrastructure components.
• Having 7 + years of experience in Development of ETL jobs and providing solutions in Banking and Financial Services using IBM Information Server DataStage( Certified in 9.1) 11.5/11.3/9.1/ 8.5/7.5px, DB2 9.7, DB2 11.3 (BLU), Oracle
• Experience in developing complex SQLs and troubleshooting performance issues
• Exposure to Full Lifecycle (SDLC) of Data Warehouse project including Dimensional Data Modeling, ETL Logic & Reporting.
• Experience in Datastage Development, Enhancement, Support and migration projects.
• Strong experience in creating complex Datastage parallel/Server jobs, Job Sequences and apply transformations
• Expert knowledge in Datastage best practices and in designing Datastage jobs for optimal performance
• Extensively used different Datastage parallel stages like Aggregator, Sort, Filter, Join, lookup Transformer & Copy etc are used to accomplish the transformation logic
• Extensive experience in ETL tools like IBM Data Stage, MS SSIS and acceptable knowledge on Informatica.
• Experience in creating complex SSIS packages using proper control, data flow elements, variables and expressions.
• Good knowledge of Relational Database Management systems with experience in Database design and programming (stored procedures) using SQL Server.
• Excellent experience with scheduling tools like Autosys, TWS and Control - M.
• Strong experience in Unix/Linux environment and scripting.
• Strong SQL development experience with SQL, PL/SQL using databases including HDFS, DB2, Vertica, Teradata, Oracle10g, 11g and MS SQL Server 2012.
• Good experience in Production Support, attending production calls, troubleshooting the application and resolving the issues.
• Extensive experience in interacting with client and cross functional teams to gather requirements.
• Good experience in Application programs using Oracle, PL/SQL Packages, Procedures, Functions and Database Triggers.
• Expertise in Dynamic SQL, Exception handling and error logging.
• Comprehensive experience in gathering and analyzing Functional & Technical requirements from different Business Users & Teams.
• Well versed with the data warehousing concepts Star schema, Snowflake star schema. Proven Technical and Business Documentation experience with large proposals. Strong time management and project coordination skills with simultaneous projects. ­
• Solid experience in writing test plans, test cases, managing/ tracking development defects.
• Excellent interpersonal and communication skills, creative, technically competent and result oriented with problem solving and leadership skills.
• Effective interaction with the client-side IT team (SMEs & Business Users) to establish the customer relationship.
• Coordinating with release management team to provide Postproduction support in resolving residual defects.
• Experience in both On-site and Onsite/Offshore engagement Models.

TECHNICAL SKILLS

Big Data Ecosystem: Hadoop, MapReduce, HDFS, Hive, Impala

Cloud: AWS S3

Scripting Languages: Shell, Perl scripting

ETL Tools: Infosphere Datastage 11.5/11.3/9.1/ 8.5/7.5, MS SSIS 2008

Database: Oracle, DB2, MS SQL Server, Teradata, My Sql, and Vertica

O/S: Windows, Linux and AIX.

SQL Tools: TOAD, Oracle SQL Developer

Scheduler Tool: AutoSys, TWS and Control-M

Programming Languages: C and C++

PROFESSIONAL EXPERIENCE

Confidential, Delaware

Senior Datastage Consultant

Responsibilities:

• Involved in Requirements gathering meetings to understand the data flow, frequency of data loads and create mapping documents
• Analyzing business requirements and business rules, designing technical specifications, test cases for the solution provided, create high and low-level design documents.
• Designed and developed POC’s while providing possible solutions to meet business requirements or enhancements
• Acted as the lead developer for creating a reusable framework for inbound and outbound interfaces
• SME for pass through framework to build a process to automate transmission of files to/from ERICA, this includes setting up audit and control tables
• Lead the creation, including design and development of reconciliation process for the files from/to ERICA
• Lead the project initiation of automating jobs’ execution using Autosys and deployed over 5K jobs.
• Used Autosys to schedule the Datastage ETL batch jobs on a daily, weekly and monthly basis which included creations of Jil’s (File watcher, Command & Box jobs), creating & modifying existing Calendars
• Providing in-house Autosys training for cross functional teams on best practices and standard naming conventions.
• Serving as a fully proficient technical resource when issues arise and be able to pin point the issue and triage the issues for onshore/offshore teams to fix.
• Design and develop Datastage jobs for Extracting, Transforming and Load processes and Master Sequences to meet complex business requirements.
• Develop common code ( shared containers) for reusability by extracting data from database tables for the given input values and providing return values, which can be used by multiple interfaces
• Develop Job streams (sequences) for regular processing, reprocessing for corrected data while creating target data for downstream business users
• As a Code Reviewer, involved in code review sessions and recommended possible job modifications to enhance job performance and to meet design standards.
• Supporting business users during User Acceptance Test.
• Executing and coordinating the Performance tests and Business line testing.
• Working on the Performance Tuning of the Datastage jobs.
• Coordinate with the downstream consumers of the application, understand the issue or requirement gap and make the necessary changes in the high/low level documents to bridge the gap. This also includes identifying the bug which is resulting in the issue and working with the offshore team to fix the issue and get it deployed to right environment at the earliest without impacting the delivery timings.

Confidential

Datastage Consultant

Responsibilities:

• Active Participation in the design analysis of the enterprise data warehouse and building various data marts.
• Interaction with architects, database analysts, SME teams and business users regarding procedures which support the efficient design of structures at a warehouse level.
• Reviewed the BRD/FRD and created Technical Design document and Provided Efforts Estimation based on the complexity of the deliverables.
• Served as a key point of contact for technical aspects related to Datastage solutions and ETL Team.
• Design and Development of Datastage jobs on Data Warehouse and Operational Data Store. Involvement in Analysis, Design and Development phases of the project
• Created Autosys jobs to schedule the jobs
• Designed and developed tables, views and created indexes, sequences and constraints in Database.
• Supported technical teams involved with database issues and operations.
• Coordinate with the Infrastructure teams to configure the Autosys Jobs in production environment
• Delivery of enhancements requested for complex Job changing with design alterations to both Jobs & sequencers.

Confidential

Datastage Consultant

Responsibilities:

• Interaction with architects, database analysts, SME teams and business users regarding procedures which support the efficient design of structures at a warehouse level.
• Reviewed the BRD/FRD and created Technical Design document and Provided Efforts Estimation based on the complexity of the deliverables.
• Actively resolving UAT issues to achieve sign-off as per the schedule and providing post production support.
• Serves as a key point of contact for technical aspects related to ETL solutions and managing ETL Team.
• Interact with architects, database & ETL teams to Identify, understand and define data requirements and data models for reporting.
• Design and Development of ETL on Data Warehouse and Operational Data Store. Involvement in Analysis, Design and Development phases of the project
• Delivery of enhancements requested for complex Job changing with design alterations to both Jobs & sequencers.
• Coordinate with the Infrastructure teams to configure the TWS Jobs
• Preparing process related documents and delivery documents.

Confidential

ETL Developer

Responsibilities:

• Draw a flow diagram for the process.
• Analyzing metadata from input files.
• Interact with architects, database & ETL teams to Identify, understand and define data requirements and data models for reporting.
• Design SSIS packages to populate data from various data sources
• Created complex SSIS packages using proper control and data flow elements.
• Designed and developed data base tables to store client data.
• Using SSIS migrating data from operational database to warehouse database.
• Created indexes, sequences, constraints and snapshots.
• Scheduling jobs through Control-M
• Tuning the existing stored procedures.
• Developed Application programs using Oracle, PL/SQL Packages, Procedures, Functions and Database Triggers.
• Developed stored procedures and made enhancements to older code which was having performance issue and enhanced legacy code to rectify.
• Interacted with end users to prepare system requirements.
• Involved in Implementation and production Support of the system.
• Coordinate with the Infrastructure teams to configure the Control-M Jobs