SUMMARY:

• ETL Tools (DataStage, Informatica), Reporting Tool (Business Objects 6.5) 10 years experience
• 10 years of experience in IT Industry, in Data warehouse Tools DataStage (6 years), Informatica (4 years) and experience in BO (~1year).
• Strong Skills on ETL (IBM Infosphere DataStage and Informatica).
• Certified IBM Infosphere DataStage Developer for version 8.5
• About 6 years of ETL tool experience using IBM Information Server, DataStage and QualityStage 8.x, Ascential DataStage 7.x/6.0 in designing, developing, testing and maintaining jobs using Designer, Manager, Director, and Administrator.
• Experienced in troubleshooting of DS jobs and addressing production issues like performance tuning and fixing the data issues.
• Excellent knowledge of studying the data dependencies using Metadata of DataStage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs.
• Experience in integration of various data sources with Multiple Relational Databases RDBM systems Oracle, Teradata, Sybase, SQL Server, MS Access & DB2.
• Worked on integrating data from flat files, COBOL files and XML files.
• Expertise in delivering DWBI solution using Waterfall, Agile methodologies (Scrum )
• Experience in different phases of DWBI projects such as Requirements gathering, Analysis, Design, Development, Testing, Implementation/Deployment, Production Support and Documentation, along with cross team communication and Knowledge Transfer activities.
• Experience in making Proof of concepts and solution architecture.
• Experience in ETL & DB performance tuning, designing and developing highly scalable systems that will handle very large volumes of data globally.
• Experience in working on leading DBs like - Teradata 12, Oracle 9i/10g, Sql Sever
• Expertise in working on Unix/Linux Platforms & Unix Shell scripting
• Excellent Analytical and problem solving skills.
• Self-motivated, adaptive to new technologies, team player with good interpersonal and communication skills.
• Excellent Team leading and people management skills.
• Experienced in Project Management, leading, planning, managing priorities, scoping & estimation for large projects/programs.
• Experienced in managing project communications within in teams, across teams and higher management, delivery status tracking.
• Excellent communication and interpersonal skills with the ability to work in a team as well as individually.

TECHNICAL SKILLS:

ETL Tools: DataStage (7.1, 7.5.1, 8.1, 8.5)

OLAP Software: Business Objects 6.5

Operating System: Windows 2000/NT, UNIX AIX5.3

Databases: Oracle 9i, 10g

Programming Languages: SQL, PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential

Stage Designer & Lead

Responsibilities:

• Understand the existing system and gather the requirements and get it sing-off from customer.
• Prepare High Level Design Document and Low Level document for the project
• Supporting the team during the Design phase.
• Involved in development of complex jobs
• Reviewed the jobs developed by the team members
• Involve in Scrum call to update the customer on project status on daily basis.
• Prepared the Mapping sheet between sources to targets,
• Extensive hands on experience on design and developing Parallel and server jobs.
• Extensively worked on building datastage jobs using various stages like Oracle Connector, Funnel, Transformer stage, Sequential file stage, LookUp, Join and Peek Stages.
• Extensively used Sort, Merge, Aggregator, Peek, DataSet and Remove Duplicates stages.
• Involved in the migration of DataStage jobs from development to QA and then to production environment.
• Created shared containers to use in multiple jobs.
• Imported and exported Repositories across DataStage projects using datastage designer.
• Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence.

Confidential

DataStage Designer & Lead

Responsibilities:

• Understand the existing system and gather the requirements and get it sing-off from customer.
• Prepare High Level Document and Low Level document for the project
• Supporting the team during the Design phase.
• Involved in development for complex jobs
• Reviewed the jobs developed by the team members
• Involve in Scrum call to update the customer on project status on daily basis.
• Developer role:
• Designed Mappings between sources to operational staging targets, using StarSchema, Implemented logic for Slowly Changing Dimensions(SCD)
• Extensive hand on experience on design and developing Parallel and server jobs.
• Extensively worked on building datastage jobs using various stages like Oracle Connector, Funnel, Transformer stage, Sequential file stage, LookUp, Join,Change capture stage,Modify stage and Peek Stages.
• Extensively used Sort, Merge, Aggregator, Peek, DataSet and Remove Duplicates stages.
• Involved in the migration of DataStage jobs from development to QA and then to production environment.
• Created shared containers to use in multiple jobs.
• Imported and exported Repositories across DataStage projects using datastage designer.
• Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence.

Confidential

DataStage Designer & Lead Developer

Roles & Responsibilities: -

• Understand the existing system and gather the requirements and get it sing-off from customer.
• Prepare High Level Document and Low Level document for the project
• Supporting the team during the Design phase.
• Involved in development for complex jobs
• Reviewed the jobs developed by the team members
• Involve in Scrum call to update the customer on project status on daily basis.
• Involve in Scrum call to update the customer on project status on daily basis.
• Designed Mappings between sources to operational staging targets, using StarSchema, Implemented logic for Slowly Changing Dimensions(SCD)
• Extensive hand on experience on design and developing Parallel and server jobs.
• Extensively worked on building datastage jobs using various stages like Oracle Connector, Funnel, Transformer stage, Sequential file stage, LookUp, Join and Peek Stages.
• Extensively used Sort, Merge, Aggregator, Peek, DataSet and Remove Duplicates stages.
• Involved in the migration of DataStage jobs from development to QA and then to production environment.
• Created shared containers to use in multiple jobs.
• Imported and exported Repositories across DataStage projects using datastage designer.
• Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence.

Confidential

DataStage Designer & Developer

Responsibilities: -

• Understand the existing system and gather the requirements and get it sing-off from customer.
• Prepare High Level Document and Low Level document for the project
• Supporting the team during the Design phase.
• Involved in development for complex jobs
• Reviewed the jobs developed by the team members
• Involve in Scrum call to update the customer on project status on daily basis.
• Developer role:
• Involve in Scrum call to update the customer on project status on daily basis.
• Designed Mappings between sources to operational staging targets, using StarSchema, Implemented logic for Slowly Changing Dimensions(SCD)
• Extensive hand on experience on design and developing Parallel and server jobs.
• Extensively worked on building datastage jobs using various stages like Oracle Connector, Funnel, Transformer stage, Sequential file stage, LookUp, Join and Peek Stages.
• Extensively used Sort, Merge, Aggregator, Peek, DataSet and Remove Duplicates stages.
• Involved in the migration of DataStage jobs from development to QA and then to production environment.
• Created shared containers to use in multiple jobs.
• Imported and exported Repositories across DataStage projects using datastage designer.
• Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence.

Confidential

Sr.DataStage Developer

Responsibilities: -

• Designed DataStage jobs for the extraction, transformation and loading of data into the ODS and Data warehouses.
• Identified source systems, their connectivity, the related tables and fields and ensured that data was appropriate for mapping.
• Used Stage Variables, Transforms of DataStage Jobs.
• Worked with parallel job message handler for demoting or removing warning messages from the job log.
• Imported and exported repositories across different servers using DataStage Manager.
• Worked with Development teams dealing with production requirements.
• Improved job performance by gathering the performance statistics of the jobs in the production server using DataStage Director.
• Extensively used the Sequential File stage, Complex Flat File Stage, Modify, DataSet, Filter, Funnel, Join, Lookup, Merge, Copy, Aggregator, and Change Capture during ETL development.
• Loaded data in Siebel database.
• Simplified the existing transformer logic in the jobs to make them perform better.
• Worked on different partitioning methods (Round Robin, Entire, Hash by Field, Modulus and Range) and collection methods (Round Robin, Order and Sort Merge) in processing sequential data.
• Participated in the review of Technical, Business Transformation Requirements Documentation.
• Trouble-shoot the designed jobs using the DataStage Debugger.
• Created job sequences and job schedules to automate the ETL process using Autosys.
• Worked with DataStages Teradata connector, Teradata Enterprise and Teradata Multiload.
• Documented the changes made to the jobs, the comparative performances of the old and new jobs and the test plan that was used to test the jobs.
• Monitored and resolved the ticketing issues that arouse during the implementation of the jobs.
• Used UNIX shell scripts and commands to run the jobs.

Confidential

Sr. DataStage Developer

Responsibilities: -

• Involved in requirement gathering.
• Prepared Low Level Document for the project and various components of the project.
• Supporting the team with the Design. Trained the team members in related to the project
• Involved in development for Complex jobs(SCD,Siebel loaing,XML output,Webservice load)
• Reviewed the jobs developed by the team members
• Raised the Change request using HP service manager to move code to UAT and PROD.
• Involved in preparing the Weekly Task sheet and conducting the weekly meeting with client to update the work status.
• Prepared training documents.
• Conducted training sessions to fresher’s

Confidential

Consultant

Responsibilities: -

• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Created mappings and transformations and target tables.
• Used Workflow Manager to read data from sources, and write data to target databases, and manage sessions.
• Created data mappings to extract data from different source files, transform the data using Filter, Lookup, Update Strategy, Aggregator, Expression, Router, Joiner, Sorter, union Transformations and Mapplets and then load to data warehouse
• Involved in Taking the Back up of repositories and in creation of folders in Repository manager and import and export of tables from one repository to the other repositories.
• Prepared UTC, Dataflow diagrams,
• Prepared workflow documents, mapping documents
• Prepared training documents,

Confidential

Senior Software Developer

Responsibilities:

• Creating the Low level Design Document.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Created mappings and transformations and target tables.
• Used Workflow Manager to read data from sources, and write data to target databases, and manage sessions.
• Created data mappings to extract data from different source files, transform the data using Filter, Lookup, Update Strategy, Aggregator, Expression, Router, Joiner, Sorter, Rank Transformations and then load to data warehouse
• Involved in Taking the Back up of repositories and in creation of folders in Repository manager and import and export of tables from one repository to the other repositories.
• Prepared UTC, Dataflow diagrams,
• Prepared workflow documents, mapping documents
• Prepared training documents,
• Prepared Visio.

Confidential, Chicago, USA

Senior Software Developer

Responsibilities:

• Involved in Taking the Back up of repositories and in creation of folders in Repository manager and import and export of tables from one repository to the other repositories.
• Involved in creating mappings according to the requests.
• Involved in doing analysis for the Change and Support requests.
• Involved in testing of Informatica when oracle is upgraded.
• Involved in monthly activities like triggering the e-billing,
• Involved in creating reports in BO according to the requests.
• Involved in Daily and monthly Loads of data.

Confidential

Software Developer

Environment: Informatica 7.1, Business Object5.1, Oracle9i

Responsibilities:

• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Performed data cleansing and transformation using INFORMATICA.
• Created mappings, mapplets, and transformations and target tables.
• Used Workflow Manager to read data from sources, and write data to target databases, and manage sessions.
• Created data mappings to extract data from different source files, transform the data using Filter, Lookup, Update Strategy, Aggregator, Expression, Router, Joiner, Sorter, Rank Transformations and then load to data warehouseLoading facts and dimensions from source to target data warehouse.

Confidential

Software Developer

Environment: Informatica 6.0, Business Object5.1, Oracle8i

Responsibilities:

• Developed data Mappings between source systems and warehouse components.
• Used ETL Tool INFORMATICA for extraction, transformation, and loading in Data warehousing.
• Performed data cleansing and transformation using INFORMATICA.
• Created and monitored workflow tasks and sessions using informatica power center.
• Designed and developed expression, joiner, look up, filter, aggregator, update strategy transformation to generate consolidated data identified by dimensions using Informatica tool.

Confidential

Software Developer

Environment: Informatica 6.0, Oracle8i

Responsibilities:

• Involved in data analysis and data cleansing
• Involved in Data Extraction, Transformation and Loading (ETL process)
• Created mappings to extract from different source files, transform the data using Filter, Lookup, Update Strategy, Aggregator, Expression, Router, Joiner, Sorter, Rank Transformations and then load to data warehouse.
• Developed and tested mappings.
• Created sessions, database connections using Workflow Manager.