SUMMARY

• Over 10 years of dynamic career reflecting pioneering experience in the field of Information Technology as a DataStage & Informatica ETL Developer in Data Warehousing and Client/Server technologies, with strong understanding in all phases of SDLC involving Requirement gathering, Business analysis, Application Design, Data Modeling, Development, Implementations and Testing of Database business systems.
• Strong skills in IBM - DataStage 9.1/8.5/8.1/7.5, Informatica PowerCenter 9.1, SQL Programming, IBM DB2, PL/SQL, Debugging, Performance tuning and Shell Scripting.
• Proficient in ETL Tools like DataStage 9.1/8.5/8.1/7.5, Informatica PowerCenter 9.1/7.1
• Expertise in gathering requirements from BA and users, writing low level design and technical specification documents, project development and implementation into production.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Efficient in Analyzing, Designing, Developing, and maintaining highly complex ETL processes.
• Experience with industry standard methodologies like waterfall, Agile within the software development life cycle.
• Developed Parallel jobs using various stages like Join, Merge, Lookup, Surrogate key, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems.
• Experience in integration of various data sources which include Oracle, SQL Server, Sybase, XML,CSV files, Fixed length files and Sequential files.
• Expertise in Data stage issue resolution, debugging and performance tuning.
• Involved in daily interactions with the Business to understand their requirements and acted in filling the gaps in the mapping in critical projects.
• Having experience in leading a team of people (Onsite and offshore) during the Project life cycle.
• Expertise in Oracle SQL queries.
• Proficient in UNIX korn Shell Scripting.
• Worked extensively on XML Input and XML Output Stages using the IBM MQ's.
• Worked extensively to replicate the real time messages from source to target systems and also parsed the XML's like Mxml to other formats.
• Coded complex SQL to load data into Foundation/Aggregate tables.
• Having knowledge on the Cognos reporting tool.
• Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.
• Experience in providing the scripts to the production team for easy execution of the jobs and maintenance.
• Experience on Defect tracking tools like JIRA.
• Setting up Defect calls for tracking and closing the defects.
• Proficient Experience in Production fixes and implementation of complex projects.
• Expertise in scheduling the Datastage jobs in the Control M environment.
• Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new cutting edge technologies.
• Excellent experience in elevating successful code to production.
• Highly motivated and adaptive with the ability to grasp things quickly.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.

TECHNICAL SKILLS

ETL Tools: IBM Web sphere Datastage v9.1, 8.7,8.5, 8.0, Designer, AdministratorDirector, Manager, Parallel Extender and Informatica 9.1/7.1

Database Systems: Oracle 9i, 10g,11g, DB2,Sybase, Teradata, Netezza

Operating System: Windows family, UNIX

Reporting Tool: Cognos 10.2

Query Tools: SQL developer, TOAD

Documentation Tools: MS Office Tools

Languages: SQL, PL/SQL, Shell Scripting

Scheduling Tools: Control-M v6.4, 8.0, Crontab

Version Control: Clearcase, SVN

Change Management: BMC Remedy v7.5

Message Queues: IBM MQ

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Datastage Developer

Responsibilities:

• Interacted with End users to understand the business requirements.
• Prepared the required application design documents based on functionality requirements.
• Designed the ETL processes using DataStage to load data from Oracle, DB2 UDB & Flat Files.
• Day-to-day responsibilities include data profile, design, develop and build ETL programs.
• Involved in business meetings to understand the Claims, Confidential t, Subscriber, Pharmacy and Enrollees data.
• Implemented dimensional model (logical and physical) data model in existing architecture using Erwin.
• Experience in leading a team of people (Onsite and offshore) during the Project life cycle.
• Developed Parallel jobs using Parallel stages like: Pivot, Join, Lookup, Sort, Transformer Funnel, Remove Duplicates, Aggregator, Datasets, Sequential Files, Filter,Oracle OCI and ODBC stages.
• Developed the reconciliation jobs to match the record counts in source system with the target data.
• Implemented complex mappings such as Slowly Changing Dimensions with Change data Capture (CDC) stage.
• Designed and developed the jobs for extracting, transforming, integrating, and loading data using DataStage Designer.
• Worked extensively on XML Input and XML Output Stages.
• Extensively worked on Error Handling.
• Good understanding Data Warehouse concepts and Star Schema and Snowflake Schema models techniques.
• Responsible for Unit test and integration testing, Data Validations and preparing test plans and test cases.
• Used theDataStageDirector to run, monitor, and test jobs on development and to obtain the performance statistics.
• Used Control M scheduling tool to schedule and define dependency across the DataStage jobs in project.

Environment: IBM Infosphere Datastage 9.1, Oracle 11g, Control M, PM4 Services, MQ Services and Linux

Confidential, Miami

Sr. Datastage Developer

Responsibilities:

• ETL tool - IBM InfoSphereDataStageis used to develop processes for extracting, cleansing, Transforming and loading data into data warehouse database.
• Worked closely with Business Analysts (BA) and Business/End users to understand the requirements and to write the technical specs.
• Day-to-day responsibilities include data profile, design, develop and build ETL programs.
• Responsible to create Source to Target mappings.
• Developed and supported the Extraction, Transformation and Load process (ETL) to build data warehouse from disparate data sources usingDataStageParallel jobs.
• Extensively worked onDataStageDesigner to develop Parallel jobs to extract data, clean, transform and load the target system.
• Developed the reconciliation jobs to match the record counts in source system with the target data.
• Experience in design and develop sequential jobs to schedule and run multiple jobs, define checkpoints and to build restart ability.
• Implemented complex mappings such as Slowly Changing Dimensions with Change data Capture (CDC) stage.
• Used DataStage Parallel Extender stages namely Sequential, Lookup, Change Capture, Funnel, Transformer Stage, Column Export stage and Row Generator stages in accomplishing the ETL Coding.
• Designed and developed the jobs for extracting, transforming, integrating, and loading data using DataStage Designer.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Developed DataStage job sequences used the User Activity Variables, Job Activity, Execute Command, Loop Activity, and Terminate.
• Used DataStage Director and its run-time engine to monitor the running jobs.
• Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: IBM Infosphere Datastage 9.1, Oracle 11g, UNIX, Oracle SQL Developer

Confidential, NY

Senior Application Developer

Responsibilities:

• Leading a team of people (Onsite and offshore) during the Project life cycle.
• Involved building Data stage low level design end to end data transformations for Financial Markets.
• Maintaining and evolving financial data warehouse for different needs in the organization.
• Building Analytical reports for better business decision making on financial products.
• Managed Data stage environments. (DEV, UAT & Production).
• Perform requirement analysis with the business users.
• Involved in unit testing and Code reviews of the jobs.
• Involved in Performance Tuning of Jobs using Performance Statistics.
• Preparing Technical docs like Analysis, High Level Design docs.
• Involved in the production implementation and post implementation support issues
• Understanding the Requirement Specifications.
• Designed Transformation Specs (Stage, Dimension & Fact tables) for the current system.
• Developed parallel jobs with the collection of all Oracle stages and processing stages like Join, XML input, XML transformer, Merge, Funnel, Change Capture, Aggregator, Transformer, Sort, Remove Duplicates, Filter and Look-up stages.
• Used Job parameter sets for file paths, database etc.
• Extracted data from Sequential files, DB's, XML's & loaded into staging area.

Environment: IBM Infosphere Datastage 8.5, Oracle 11g, Control M, PM4 Services and MQJ Explorer, and Linux

Confidential, NY

Senior Application Developer

Responsibilities:

• Understanding the Requirement Specifications.
• Designed Transformation Specs (Stage, Dimension & Fact tables) for the current system.
• Developed parallel jobs with the collection of all Oracle stages and processing stages like Join, XML input, XML transformer, Merge, Funnel, Change Capture, Aggregator, Transformer, Sort, Remove Duplicates, Filter and Look-up stages.
• Used Job parameter sets for file paths, database etc.
• Extracted data from Sequential files, DB's, XML's & loaded into staging area.
• Involved in preparing the documents like technical specs, test cases, test results, control-m and operational documents.
• Created job sequencers of dependency jobs and batches.
• Tuned jobsacross sources, targetsfor better performance.
• Performed Import and Export of jobs in the process of migration from Development to SIT and Production.
• Maintained standards for naming conventions and Quality.
• Used the Change Remedy to raise the CR's and to present in the Pre-Cab and Cab to get the approval for the production deployment.
• Used Share point to upload docs & maintain version control.
• Used the Clear case to upload the production release code.
• Used JIRA to track issues raised by the users and testing teams.
• Used Control M to schedule the jobs both online and batch jobs.

Environment: IBM Infosphere Datastage 8.5, Oracle 11g, Control M, PM4 Services and MQJ Explorer, and Linux

Confidential

Software Engineer

Responsibilities:

• Developed parallel jobs with the collection of all Oracle stages and processing stages like Join, Merge, Funnel, Change Capture, Aggregator, Transformer, Sort, Remove Dups, Filter and Look-up stages.
• Used Job parameters for file paths etc.
• Used DB Connection pool for DB user name, password etc.
• Extracted data from sequential files & loaded into staging area.
• Prepared the test cases and test results.
• Created job sequencers of dependency jobs and batches.
• Tuned jobsacross sources, targetsfor better performance.
• Maintained standards for naming conventions and Quality.
• Used the Star Team to upload the documents and maintain the version control

Environment: Data Stage Parallel/Server 8.0, Teradata, Windows XP and Unix.

Confidential

Software Engineer

Responsibilities:

• Understanding the Requirement Specifications.
• Extensively involved in ETL development.
• Designed Transformation Specs (Stage, Dimension & Fact tables) for the current system
• Involved in development of Stage, Dimension & fact tables mappings using Connected/Unconnected LKP's, EXP, UPD Strategy, Filter, Router, AGG, Joiner, Normalize Transformations.
• Using ETL Process to Extract, Transform and Load the data into stage area and data warehouse.
• Using Transformations to clean the data from staging area as per the data warehouse requirements
• Creating Mapplets and using in mapping.
• Identified and tracked the slowly changing dimension tables, heterogeneous Sources and determined the hierarchies in dimensions.

Environment: Informatica 7.1, Teradata, Windows XP