SUMMARY:

• Highly motivated, quality minded Data Warehouse analyst, Data Analysis and developer having a total of 10 years of experience.
• Over 6+ years of experience in using IBM InfoSphere DataStage 11.5/9.1/8.7/8.5/7.5 for ETL (Extraction, Transformation and Loading) of data from multiple source database systems to Data Warehouses
• Over 3+ years of experience in using Informatica Power Center/Power Mart 9.6 for ETL (Extraction, Transformation and Loading) of data from multiple source database systems to Data Warehouses
• InfoSphere DataStage, Quality Stage and ISTQB Certified
• Certified in Pharma Management in TCS
• Experience in implementing Data Warehouses, Relational databases and application development using IBM Datastage, Informatica, Oracle, SQL Server
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions in Informatica .
• Hands on experience in tuning Parallel Job, SQL, identifying and resolving performance bottlenecks in various levels like sources, targets, SQL query in DataStage .
• Experience in using stages, Standardization, Scrubbing, Matching and Survivorship rules using QualityStage.
• Experience in designing parallel jobs using various stages like Transformer, Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Complex flat file, Modify, Aggregator, XML.
• Experience in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Excellent knowledge of data warehouse architectures, concepts and technologies on Star Schema and Snowflakes Schema methodologies .
• Support real - time operations and up-to-the-minute decision making with intelligent, implemented change data capture (CDC) by using Informatica/Datastage..
• Experienced in 24/7 Production Support and resolved the issues on time.
• In depth understanding in data modeling, E ntity-Relationship mod eking, slowly changed dimensions modeling .
• Experience in integrating web methods, Salesforce and PeopleSoft with DataStage/Informatica and importing data from above Sources.
• Proficiency in data warehousing techniques for Slowly Changing dimension phenomenon, Surrogate key assignment and change data capture (CDC).
• Experience in Full Life Cycle Implementation of Data warehouses .
• Responsible to Create and Schedule Jobs in Production environment using Control-M,Autosys to Continue support for production issues
• Excellent Experience with databases, writing queries and stored procedures using Oracle, DB2, MySQL, SQL Server databases, SQL,Netezza,Teradata and PL/SQL.
• Experience in Teradata Load Utilities like Fast load, Multiload etc
• Experience in RDBMS Design, SQL, PL/SQL and Unix Shell and internals Programming.
• Experience in Agile, V and Water Fall Methodologies Model
• Performed lead, supportive and sharing roles with strong communicative and interpersonal skills in team-tasks.
• Excellent communication skills, quick learner, highly motivated, ability to work independently and in team.
• At ease in high stress environments requiring superior ability to effectively handle multi-task levels of responsibility.
• A good team player with excellent communication and interpersonal skills. Mentored Junior Members in the Team

TECHNICAL SKILLS:

ETL Tools: Informatica, DataStage and ODI

Databases: Oracle 7.2/8i/9i/10g, Main frames, SQL Server 6.5/7.0/2000, DB2,Teradata,Netezza

Languages: SQL, PL/SQL,Shell Scripting

Operating Systems: Windows 95/98/NT/2000/XP, UNIX

Packages: MS Office (MS Access, MS Excel, MS Power Point, MS Word)

Scheduling Tool: Control-M,TWS,Autosys

Others Tool:: VMware, Quality center, TFS, Clear Case, HP Service Manager, Clear Quest, Visual Source Safe, Putty, ControlM, RTC

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

Tech Lead

Responsibilities:

• Working with business users and business analyst for requirements gathering and business analysis
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart
• Involved in extensive development of the mappings and the functional specifications.
• Worked with Data Modeler to create Data Model.
• Worked with Architect to help in data discovery and data profiling.
• Extensively used DataStage integrated with Sales force, PeopleSoft, web services and targets
• Created reusable jobs to and load data from Db2,Oracle database
• Developed complex jobs using different stages like Joiner, Filter, Transformer, Aggregate, Sort, Lookup, CDC etc.
• Perform unit testing, Integration and System testing of ETL jobs
• Designing and Develop sequence for the loading strategy of data warehouse
• Performance Tuning of Datastage jobs and SQL query.
• Pulled data from different sources like Oracle, SQL Server, DB2
• Schedule the job using Control­M scheduling tools
• Deployment of Code into Production and QA Environment

Tech Lead

Responsibilities:

• Involved in extensive development of the mappings and the functional specifications.
• The project involved developing mappings for moving data from Database and Flat files to Staging Area (STG) to Datawarehouse
• Created Mapping specifications and testing specifications according to the requirement
• Created reusable jobs to extract and load data from Db2,Oracle database
• Developed complex jobs using different stages like Joiner, Filter, Transformer, Aggregate, Sort, Lookup, CDC etc.
• Developed re-usable jobs in datastage like In-synch jobs, Data loads from DB to dataset and unstructured stage to Dataset or sequential file
• Very efficient Error Handling Strategies were used to document the error handling in the jobs. Standard Error-Codes and Error-Descriptions were used.
• Perform unit testing, Integration and System testing of ETL jobs
• Designing and Develop sequence for the loading strategy of data warehouse
• Performance Tuning of Datastage jobs and SQL query.
• Pulled data from different sources like Oracle, SQL Server, DB2
• Schedule the job using Control­M scheduling tools
• Deployment of Code into Production and QA Environment

Tech Lead

Responsibilities:

• Involved in extensive development of the mappings and the functional specifications.
• The project involved developing mappings for moving data from XML and Flat files to Staging Area (STG) and then to Data Warehouse (DWH) and then to Data Mart.
• The data to the warehouse was moved in a Normalized fashion while the Data Mart Involved dimensionally modeled data.
• Created Mapping specifications and testing specifications according to the requirement
• Created reusable jobs to extract and load data from Oracle and Netezza database
• Developed complex mappings using different transformations like Joiner, Filter, Normalizer, Aggregate, Rank, Lookup, Routers, Update Strategies etc.
• Developed Mapplets, and Reusable lookup transformation that were frequently used.
• Developed complex jobs using different stages like Joiner, Filter, Transformer, Aggregate, Sort, Lookup, CDC etc.
• Used XML parser and Generator transformations to parse the XML Documents.
• Developed re-usable jobs in datastage like In-synch jobs, Data loads from DB to dataset and unstructured stage to Dataset or sequential file
• Very efficient Error Handling Strategies were used to document the error handling in the jobs. Standard Error-Codes and Error-Descriptions were used.
• Extensively used DataStage integrated with Sales force,PeopleSoft, web services and SAP R/3 sources and targets
• Pulled data from different sources like Oracle, SQL Server, DB2, Siebel application database (Oracle)
• Extensively used Version Control to control the flow of mappings with checkout/check in procedures
• Extracted Data from Oracle, XML and Flat File source systems.
• Identify test cases for unit testing of the jobs.
• Creating Test cases for Unit Test, UAT to check the data quality
• Involved in on call Production Support and resolved the issues on time.
• Applied performance-tuning logic to optimize session performance
• Closely worked with the Project Lead and the QA Team to do the Testing of the mappings.
• Extensively worked on PL/SQL and SQL tuning.
• Developed UNIX shell scripts for pre and post session processes
• Migration of the Code from Development to QA/PROD.

Environment: InfoSphere Datastage/Informatica, ODI XML, Sales Force,PeopleSoft, Putty,, VMware, Oracle 10g, Netezza, SQL server 2005, DB2, PL/SQL,Toad, UNIX, Windows 2003,Control-M

Module Lead

Responsibilities:

• Involved in extensive development of the mappings and the functional specifications.
• The project involved developing mappings for moving data from XML and Flat files to Staging Area (STG) and then to Data Warehouse (DWH) and then to Data Mart.
• The data to the warehouse was moved in a Normalized fashion while the Data Mart Involved dimensionally modeled data.
• Created Mapping specifications and testing specifications according to the requirement
• Developed complex jobs using different stages like Joiner, Filter, Transformer, Aggregate, Sort, Lookup, CDC etc.
• Performance tuning of datastage jobs.
• Developed re-usable jobs in datastage like In-synch jobs, Data loads from DB to dataset and unstructured stage to Dataset or sequential file
• Very efficient Error Handling Strategies were used to document the error handling in the jobs. Standard Error-Codes and Error-Descriptions were used.
• Extensively used DataStage integrated with Sales force, web services and SAP R/3 sources and targets
• Pulled data from different sources like Oracle, SQL Server, DB2, Siebel application database (Oracle)
• Extensively used Version Control to control the flow of mappings with checkout/check in procedures
• Extracted Data from Oracle, XML and Flat File source systems.
• Identify test cases for unit testing of the jobs.
• Creating Test cases for Unit Test, UAT to check the data quality
• Involved in on call Production Support and resolved the issues on time.
• Applied performance-tuning logic to optimize session performance
• Closely worked with the Project Lead and the QA Team to do the Testing of the mappings.
• Extensively worked on PL/SQL and SQL tuning.
• Developed UNIX shell scripts for pre and post session processes
• Migration of the Code from Development to QA/PROD.

Environment: InfoSphere Datastage/Informatica, XML, Sales Force, Putty,, VMware, Oracle 10g,Teradata, Toad, UNIX, Windows 2003

Datastage Developer

Responsibilities:

• Understand Business requirements and convert them into Low level Design.
• Enhance Datastage ETL Jobs for better turnaround time.
• Utilize in-depth knowledge of Technical experience in Info Sphere Datastage and other leading-edge technology like Oracle database in conjunction with industry and business skills to deliver support to customer.
• Using Best coding standards
• Perform unit testing and prepare Test Results Document
• Strong in Test Methodologies, Test Planning and Test Team management,Preparing Testing strategy for the validation of data migrated.
• Excellent exposure in Defect Logging, Defect Tracking and Bug Reporting activities
• Deployment of Code into Production and QA Environment
• Understanding the release requirements and developing test scenarios for the system testing.
• Design of Complex Datastage Jobs to cater business requirements.
• Designing and Develop sequence for the loading strategy of data warehouse.

Environment: InfoSphere Datastage, XML, Putty, Autosys, VMware, Oracle 10g, SQL, DB2, PL/SQL, Toad, UNIX, Windows 2003

Datastage Developer

Responsibilities:

• Executed multiple roles and responsibilities - designer, developer and tester in this project which started with scratch. Provided good opportunity to get and hands-on on all phases of software life cycle.
• Creating Use Case Diagrams for depicting Data Analysis and Data Transfer .
• Gathered requirement from Functional analyst and prepared Detail level Technical design document showing every technical details of code design.
• Developed code and unit tested it. Later on supported the code for any further issue..
• Initiated review process team for reviewing code/ documentations and quality Improvement.
• Create Test scenario for Unit testing of an interface and for Integration testing.
• Presented Technical design documents to clients and onsite team .
• Created multiple Technical documents on exploring InfoSphere DataStage functionality.
• Led sessions to new developers on the tool and provided technical assistance.
• As a technical designer/module lead, coordinated with developer in implementing the requirement with good quality and Ensured that development is performed as per requirements
• Became part of Test team when Interfaces moved to QA and Coordinated with QA team to create multiple scenarios for Integration testing. Communicate activities/progress to project leads and managers.
• Focused on maintaining correct versions of code and to take backup of project level code and other mandatory script files on regular basis.

Environment: InfoSphere Datastage, Putty,, VMware, Oracle 10g, SQL

Tester

Responsibilities:

• Functional, Regression, Ad-hoc testing. Usability tests etc.
• Organize training for new team member, monitor progress, reviews.
• Preparing Test Cases for new features added.
• Preparation of new test cases by combining the use tests sent by the client and some exploratory testing at our end as a new feature is implemented.
• Bug reporting and tracking
• Understanding and analysis of Business requirements
• Understanding the Functional and technical specifications of the application
• Involved in Configuration Management and Version Control
• Performing a Smoke Test and qualifying the build for thorough Testing
• Business requirements.

Environment: Clear case, HP Quality Centre