SUMMARY

• Over 15 years of Data Warehousing experience in the areas of ETL design and Development. Involved in complete Software Development life - cycle (SDLC) of various projects, including Requirements gathering, System Designing, Data modeling, and ETL design, development, Production Enhancements, Support and Maintenance.
• Designed technical processes as a Team Lead by using internal modeling and working with analytical teams to gather requirements and create specifications.
• Hands on experience in Importing and exporting data from different sources like mainframe, DB2 into Hadoop using data ingestion tool like IIS Datastage.
• Data Lineage and business Lineage reports produce through IBM Information Governance Catalog.
• Current area of working is in Hadoop, Talend Bigdata, Datastage, DB2 z/OS and DB2.
• Coded programs used in testing, implementing and building client databases and process flows using IBM Infosphere (DataStage), Informatica, Business Objects 5.1.2/XI R2,OBIEE, Oracle, DB2.
• 14 years of experience in Information Technology with a broad range of computer expertise, analytical skills, backend database applications and ETL Architecture and Business Intelligence (DW) applications.
• Managed all aspects of the SDLC process - requirement analysis, time estimates, functional specification, design, development, testing, packaging, and support/maintenance.
• Proficient in both Waterfall and Agile development methodologies.
• Proficient in analysis, design, development of Database Management Systems using ORACLE 11g/10g/8.x/7.x.
• Experienced in PL/SQL and TOAD.
• Hands on knowledge in UNIX/Linux shell scripting, job scheduling in CRON, Autosys, Control-M and TWS.
• Hands on experience in implementing business logic in Oracle using Stored Procedures, Functions, Packages, Views, materialized views, function based indexes and Triggers, Dynamic SQL, ad-hoc reporting usingSQL.
• Experienced in Oracle Database Design and ETL with IBM Infosphere (DataStage), Talend and Informatica.
• Mentored, coached, cross-trained junior developers by providing domain knowledge, design advice.
• Proven ability in defining goals, coordinating teams and achieving results.

TECHNICAL SKILLS:

ETL Tools: IBM Information server 11.5/9.1, IBM Information server /8.x, DataStage 7.5 and Informatica Power Center 8.X, Talend Studio 6.4

OLAP/DSS tools: Business Objects 5.1.2/XI R2 and OBIEE.

RDBMS: Oracle 11g/8.x, DB2 UDB, DB2 Mainframe, MS SQL Server 7.0, DB2, MS Access.

Modeling Tools: ERwin7.1, Visio

Scheduling Tools: Autosys, Control-M and TWS.

Version Control Tools: IBM Rational Clearcase, Serena, DataStage, Niku.

O/S: IBM (AIX) and UNIX, Windows NT, Windows 95/98/2000

Software Package: Microsoft office 2013, Ultraedit, Advance Query Tool, Toad, Beyond Compare 3, IBM Rational Quest, JIRA, Service now and HP- Sitescope.

Management: Team Lead, Project Management, Agile, Waterfall, SDLC process

PROFESSIONAL EXPERIENCE:

Confidential

Senior Architect

Responsibilities:

• Designing and development of IIS DataStage 9.1/11.5 code and scheduling packages to transfer the batch data to BO and Tableau environment.
• Ingest data into Hadoop/HDFS from different data sources using Datastage 11.5 and Talend ETL.
• Design Talend generic ETL mapping to load data into Hive tables/partition tables.
• Lead the team in the design and delivery of data validation rules with IIS DataStage for loading data into warehouse.
• Designed and developed Shell scripts, scheduling mechanism to support daily batch loads.
• Worked with deployment team to deploy the code in different environments(QA,UAT,PRE-PROD,PROD)
• Extensively used TWS for scheduling the DataStage Jobs.
• Mentor and challenge junior and other team members, while growing the technical, functional and leadership skills
• Participated PoCs on Data integration use cases using Talend with Big Data.

Confidential, Boston, MA

Technical Architect

Responsibilities:

• Designing Data model and exception frame work model in Erwin for NDW.
• Designing and development of IIS DataStage 8.5 code and scheduling packages to transfer the batch data to Cognos and sport fire environment. As well as providing detailed documentation and knowledge support to the Support team.
• Creating stories in RTC.
• Lead the team in the design and delivery of data validation rules with IIS DataStage for loading data into warehouse.
• Worked Closely with Product owner and Business Analyst to understand business rules and developed DataStage jobs.
• Designed and developed Shell scripts, scheduling mechanism to support daily batch loads.
• Developed balance reconciliations processes, point to point controls, capturing operational info for management dashboards.
• Worked with deployment team to deploy the code in different environments(QA,UAT,PRE-PROD,PROD)
• Extensively used Autosys for scheduling the DataStage Jobs.
• Mentor and challenge junior and other team members, while growing the technical, functional and leadership skills.

Confidential, Tampa, FL

Solutions Architect/ETL DataStage Developer

Responsibilities:

• Provide architecture solution to address the new initiatives around the DTCC GTR equity data requirements.
• Designing and overseeing development of highly complex IIS DataStage 8.5/9.1 code and Scheduling packages to transfer the batch data to Big Data environment. As well as providing detailed documentation and knowledge support to the RTB.
• Lead the team in the design and delivery of data validation rules with IIS DataStage for loading data into the GTR Equity Repository.
• Worked closely with Business Analyst to understand business rules and developed DataStage jobs.
• Designed and developed Shell scripts, scheduling mechanism to support daily batch loads.
• Developed balance reconciliations processes, point to point controls, capturing operational info for management dashboards.
• Worked with deployment team to deploy the code in different environments(QA,UAT,PRE-PROD,PROD)
• Extensively used Autosys and CRON for scheduling the DataStage Jobs.
• Mentor and challenge junior and other team members, while growing the technical, functional and leadership skills.

Confidential, Cincinnati, OH

Tech Lead/ETL DataStage/Informatica developer

Responsibilities:

• Provide architecture solution to address the new initiatives around the CRM Data Warehouse data requirements.
• Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.
• Supporting the 5/3rd team by setting up the Infrastructure, ramping up development and production support.
• Designing and overseeing development of highly complex IIS DataStage/Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.
• Lead the team in the design and delivery of data validation rules with IIS DataStage for loading data into the EDW.
• Worked closely with Business Analyst to understand business rules and developed DataStage and Informatica jobs.
• Designed and developed Shell scripts, TWS scheduling mechanism to support daily batch loads.
• Developed balance reconciliations processes, point to point controls, capturing operational info for management dashboards.

Confidential

Senior Software engineer

Responsibilities:

• Involved in creating entity relational and dimensional relation data models using Data modeling tool.
• Designing the target Schema definition and Extraction, Transformation and Loading (ETL) using DataStage.
• Mapping Data Items from Source System to the Target System.
• Preparing the mapping document source to target.
• Worked on programs for scheduling Data loading and transformation using DataStage from legacy system to Oracle using SQL* Loader and PL/SQL.
• Used DataStage director to monitor the job run statistics.
• Writing documentation form detail transaction data for operational dtatasource.
• Transformation including aggregation and summation construct from operational data source to Data warehouse.
• Involved in performance tuning of parallel Jobs using performance statistics.
• As per the Data Architect’s direction, created and executed the SCD Type 2 implementation on Dimensional data.
• Extensively worked with DataStage Shared Containers for reusing the Business functionality.
• Involved in Unit testing, System testing, Integration and performance Testing of the jobsParticipated in the meeting with Business Users and support Analyst for getting the more information and understanding of the Application.

Confidential

Software Engineer

Responsibilities:

• Working on ERP Package for Web based Institute Management System called e-School.
• Duties Include System Study, Installation, Users Interface Design, Website Design, Maintaining Website.