SUMMARY

• IBM certified Datastage solution developer with 9 years of career reflecting experience in data warehousing.
• Hands on experience on SQL Server Integration Services (SSIS).
• Currently working as a Programmer Analyst involved in requirements gathering, requirement documentation, Data profiling, ETL Solution design, Quality Assurance, Production implementation activities, Production support and performance tuning activities along with exposure to Datastage administration activities.
• Have extensive experience in ETL code development, testing and production turnovers of multiple projects for a retail datawarehouse. Also gained experience in test plan development, testing and results documentation, analyzing defects, bug fixing, analysis of existing ETL systems for performance tuning, online support of ETL applications.
• Experienced in ETL testing including creation of ETL test cases for Unit Testing, System Integration testing and co - ordination with the business users for User Acceptance Testing.
• Had handled ETL enhancement and migration projects, completely based on Agile Methodology. Also have very good experience across all stages of Software Development Life cycle including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing and have participated in project delivery activities and transition as well, with absolute priority of documentation along with the deliverables.
• Extensive experience in directly interacting with the business users and multiple third party vendors, including 2 years of onsite experience in TCS - Australia, and couple of months in Confidential - Germany.
• Have taken up multiple roles in the team as scrum master for an Agile project, lead developer and datastage consultant, technical lead in guiding the project team and subject matter expert involved in application consulting activities for further enhancements and performance tuning activities.
• Had worked across domains like Telecom, Retail and Manufacturing, and handled variety of projects including datawarehouse development from the scratch, design of datamarts, ETL migration and data migration.
• Reputation for quick learning ability, strong organization skills, excellent communication skills, dedicated teamwork and a good team mentor, ability to work under pressure to balance competing priorities and meet deadlines.

TECHNICAL SKILLS

OLAP: Datawarehousing, Data migration, Data Profiling.

TOOLS: IBM Information Server 11.3, MS BI SSIS, Informatica

Databases: Teradata 15.10, SQL Server 2012, Oracle 11g, DB2

Testing Tools: Microsoft Test Manager

Scheduling Tools: CA Scheduler, Autosys.

Version Control: Microsoft Team foundation server, IBM Information ServerManager, Accurev.

Operating System: Linux, Shell scripting.

SDLC: Agile, Waterfall

OTHER Tech: Webmethods 6.5, IBM MQ 6.0, Datastage TX 8.0

PROFESSIONAL EXPERIENCE

Confidential, MI

Solution Architect

Responsibilities:

• Perform business requirement gathering, provide estimates for ETL solution, data profiling, requirement and data mapping documentation, ETL solution design and quality assurance, ETL scheduling using CA workstation, Production Implementation and Production support.
• Quality assurance activities include building test cases and validating the test results to ensure data integrity in the data warehouse, as well monitor quality of deliverables from offshore team.
• Identify and periodically update best practices documentation to meet industry standards.
• Design and development generic framework items as reusable code components.
• Developed Teradata Parallel Transporter scripts for bulk data extraction and data loads.
• Proven track record in addressing production issues like performance tuning and enhancement.
• Collaborate with the SME team, to identify and resolve any data integrity issues.
• Experience in post-production validation and support during warranty period, preparation of transition document and handover to support team.
• Developed ETL workflows involving very high complex business logic.
• Created ESP code for scheduling ETL batches through CA Workstation.
• Co-ordinate with change management team, to deploy ETL package releases.
• Conducted datastage and process for new resources in the team.

Environment: IBM Information Server 11.3, MS BI SSIS, Teradata 15.10, SQL Server 2012, DB2, Sybase, Oracle, Linux, Microsoft Team Foundation Server, Microsoft test manager, CA Scheduler

Confidential

Senior Technical Specialist

Responsibilities:

• Involved in solution development and deployment for enhancing the capabilities of REACT data warehouse Quality assurance activities include building test cases and validating the test results to ensure data integrity in the data warehouse, as well monitor quality of deliverables from offshore team.
• Gained exposure to datastage job components upgrade and QualityStage migration.
• Clean focus on performance optimized solution, configuration management and documentation
• Worked on data analysis and bug fixes for existing data issues.
• Provided the client with a cost - effective solution for resolving the data protection issue of Confidential - Europe and thereby enabling the project team to be setup at offshore.

Environment: IBM Information Server 8.5, Teradata 14.00, SQL Server, Linux, Autosys, Accurev

Confidential

Datastage consultant

Responsibilities:

• Experience in high level estimation and project planning activities.
• Setup of datastage environment and configuration of datastage - SAP package.
• Designed the data migration tool as per the business requirements.
• Collaborated with the SAP functional and technical team for data validation.

Environment: IBM Information Server 8.5, Oracle, UNIX

Confidential

Senior Datastage developer

Responsibilities:

• Worked as an ETL developer in developing a customer data warehouse, right from the scratch for Hutchison using Datastage 7.x PX .Involved building a customer data warehouse using Inmon’s approach of denormalised data model, and an explicit metadata management system.
• Experience in complex data mapping rules and transformations, building staging, ODS and data warehouse layers.
• Project involved developing several reusable components and adopted several industry standards and best practices.
• Involved in enhancement initiatives and support of legacy datawarehouse systems. Experience in dealing with dimensional modeling, requirement gathering, and locating data quality issues, formulating new mapping rules, deployment and support of ETL functionalities.
• Scheduling and monitoring batch jobs, run time debugging, active delivery of critical business reports, coordinating with a large stack of external interfaces and teams, co-ordination with the database experts on data warehouse maintenance and also involved in house-keeping of ETL server.
• Have done various performance improvement activities in existing legacy ETL systems involving Oracle 9i, with query tuning activities, change of existing ETL design and tuning of datastage parameters for substantial performance improvement and load balancing in both application and database servers.
• Handled support and maintenance of entire ETL system of Confidential .
• Re-design of required ETL components and migration of existing customer data Warehouse systems of Hutchison to repoint to Teradata - Enterprise Wide Data warehouse of Confidential Hutchison Australia.
• Had developed a data migration tool using ETL functionalities, capable of interacting across difference source and target systems, for data migration from external MBB system to Confidential CRM and BRM systems, validating data quality rules, Complex transformations to suit the target systems.

Environment: IBM Information Server 8.1, Ascential Datastage 7.0, Ascential Datastage 7.5, Oracle, UNIX, Teradata 12.0, Teradata Utilities.

Confidential

Developer

Responsibilities:

• EDI data flows using Ascential DataStage TX 8.0 ( Earlier known as Mercator)
• Worked on proof of concept for integrating Datastage TX with IBM MQ 6.0
• Developed EDI Inbound and Outbound flows using webMethods 6.5
• Created flow services using Designer
• Accomplished B2B implementation through Trading Networks
• Worked on BPM and BAM capabilities of webMethods 7.1

Environment: Datastage TX, Webmethods, IBM MQ