SUMMARY:

• Having over 8 years of professional experience in all phases of the Software Development Life Cycle (SDLC) including Requirement Gathering, Analysis, Design, Development, Implementation and Maintenance of Medium to Large Enterprise applications in Data ware house environment like ETL by using IBM Data Info sphere.
• Extensive experience on designing and developing jobs by using IBM InfoSphere Data Stage (Ver9.1/8/7/6/5.1)
• Experienced in using parallel processing Infrastructure using Data Stage Parallel Extender and highly proficient in Data Stage server engine.
• Excellent experience working with Oracle, Teradata, PL/SQL and writing stored procedures.
• Strong in writing UNIX shell scripts that are required for the process control mechanisms and unit testing.
• Experience in job Sequencer to specify a sequence of server jobs to run. Worked and extracted data from various database sources like Oracle, DB2, Sequential files and Flat files
• Involved in all the stages of Software Development Life Cycle.
• Proven track record in troubleshooting of Data Stage jobs and addressing UAT and production issues like performance tuning and enhancement.
• Worked on Data Stage production job scheduling process using the Autosys tool
• Experience in Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical data modeling.
• Excellent knowledge of studying the data dependencies using Metadata of Data Stage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables and star schema modeling.
• Knowledge in design and implementation of Star Schema and Snowflake Schema.
• Experience in writing, testing, and implementation of the triggers, procedures, functions at Database level and form level using PL/SQL.
• Strong understanding of business processes & interface with IT.
• Strong writing and documentation skills for the management, development and control of documentation.
• Excellent track record as a leader and team player with effective communication skills.
• Effective in cross - functional and global environments to manage multiple tasks & assignments concurrently.
• Multilingual, highly organized, detail-oriented professional with strong technical skills.

WORK EXPERIENCE:

Sr. DataStage Developer

Confidential, Tampa, FL

Responsibilities:

• Worked on complete life cycle of Design, Development, maintenance and documenting conversion process.
• Involved in the technical development delivery strategy packages which include technical design, development and testing phase
• Developed data transfer strategy from various legacy data sources.
• Used Datastage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Extensively worked with DataStage Active and Passive Stages for Data Staging and Data Transformation
• Extracted data from Oracle 11g and loaded into staging area, and performed transformation rules and loaded it into ODS.
• Worked extensively on different types of stages like Sequential file, ODBC, Connectors, Aggregator, Transformer, Filter, Merge, Join, Lookup, Sort, and Containers (Server, Parallel) for developing jobs.
• Implemented PL/SQL scripts in accordance with the necessary business rules and procedures and to support the reports by retrieving the data from Warranty data repository
• Created views on actual tables and to eliminate the complexity of the large queries. Created various indexes on tables to improve the performance by eliminating the full table scans.
• Worked on UNIX shell scripts for automation and effective implementation of the requirement.
• Involved in Performance Tuning of source, target, mappings and sessions.
• Used Autosys Scheduling tool to Schedule the jobs.
• Designed jobs for type 2 history maintenance.
• Designed ETL generic jobs to extract data from multiple sources and load into data warehouse
• Designed sequencers to run jobs upon receiving certain number of files and send emails upon not satisfying the conditions, archiving the files after procession, creating audit records with source and target counts.
• Co-ordination with offshore for development of Data stage jobs.

Environment: IBM Infosphere Data stage 11.5/9.1, UNIX-AIX, Rapid Sql DB2, Sql Server, Quality Control and Clear Quest.

Data Stage Developer

Confidential, NJ

Responsibilities:

• Design and develop DI (Data integration) code using IBM Data stage v9.1.
• Strategically implemented slowly changing dimensions with hybrid data needs like multiple SCD types in one table or requirement
• Design and develop UNIX shell scripts for process report, error validations, and control entries.
• Worked on integration jobs between IBM Data stage and IBM Quality stage.
• Interact with third Party systems on behalf of Data integration team and work with them to resolve their queries.
• Worked on Adhoc request tickets raised on a daily basis on service now.
• Debug and enhance Data quality process using IBM Quality stage v9.1.
• Process Daily file processing operation on Test region as required by the client and work root cause analysis.
• Prepare Unit test cases and Unit test case document for the same.
• Involve in code review and peer review and suggested for enhancements and performance.
• Identifying processes which may be enhanced or tuned to reduce cost and improve customer satisfaction.
• Support various Production activities on ISL (Interface Surface Layer), CFP (Common Financial Platform), Pay go system, Interface Layers.

Environment: IBM Information Server 9.1, IBM Data stage 9.1, Linux, Sybase, Service Now, Autosys, Service Desk.

Associate Consultant

Confidential, CA

Responsibilities:

• Used the Data Stage Designer Datastage v.9.1 to develop jobs to extract, transform and load data from various source systems into the Data Warehouse.
• Created user defined routines and transform functions (in DataStage Manager) to carry out the complex data cleaning and data transformations in the transformer stage.
• Extensively used Batch Control for incremental extract and load of the Data Warehouse.
• Extensively used the Transformer Stage, Sequential File Stage, Hash file Stage, ODBC Stage, Link Stage, and Link Collector Stage for job design.
• Extensively worked on Job Sequencers for automation of the various ETL processes.
• Used DataStage Director for executing jobs, analyzing logs and scheduling the job sequencers for regular population of the data warehouse.
• Used DataStage Manager for importing metadata from repository and creating new table definitions and sequential file definitions.
• Was involved in full integration test of all jobs within each sequence before migrating the jobs and sequencers from the Development environment to the QA environment, and from the QA environment to the Production environment.
• Performed code reviews of the developed jobs and fixed the identified defects in the jobs.
• Participated in reviews of data modeling and business requirement analysis and assisted with defining requirements.
• Assisted other Data stage developers with design and development recommendations.

Environment: Data Stage 9.1 and Ascential Data Stage 9.1v; Financial Warehouse, Oracle 9i.

Sr.ETL Developer / BI Analyst

Confidential, Chicago, IL

Responsibilities:

• Finalized the scope, data requirements, assumptions with Data Architect and Information architect as part of joint architecture discussions
• Had a very deep understanding source systems nature, data content, most possible atomic transactions
• Reviewed the data model with Information architect and shared the all finding including column naming conventions, null, data types and other data structure related comments
• Analyzed source systems in depth and formulate ETL business rules along with BA lead/BA team
• Created best practices, coding standards for ETL development team coding tasks and performance tuning techniques
• Validated all documentation being prepared by ETL team including technical specification, data flow diagrams, production operations note and other system documentations
• Created logical data mapping along with slowly changing requirements for each business requirements along with data purging and other data maintenance needs
• Strategically implemented slowly changing dimensions with hybrid data needs like multiple SCD types in one table or requirement
• Set up test environment data for various data scenarios so that ETL developers can validate all possible scenarios in given time constraints
• Initiated and finalized usage of external scheduler for ETL jobs execution overnight as part of daily night batches, weekly night batches, contingency batches
• Loaded historical & late arriving source data retaining integrity of source data and also making sure of existing data especially loading facts and dimension tables.

Environment: Data stage 8.1, Sql server management studio, Warranty Data warehouse.

ETL Developer

Confidential, Chicago, IL

Responsibilities:

• Involved in Business meetings to understand the utilization of Warranty services to identify additional opportunities for warranty claim overpayment recoveries. Use findings to recover overpayments and to prevent future similar overpayments.
• Worked on the data stage to create and send standardized Vendor Claim, Member, Provider and TPL files to the warranty on a regular basis
• Extensively used DataStage Director for monitoring and debugging of the jobs and Sequences. Used DataStage Manager to Import and Export DataStage components and Import table definitions from source databases
• Extensively worked on the Sybase stored procedures and Oracle packages for extracting the Complex Claims and Member data from the source and used them for data stage jobs for efficient results.
• Involved in critical multiple instance data stage jobs which will send the outbound files for different Lob's (line of business) at the same time and monitored the jobs accordingly.
• Extensively used Parallel Stages like Join, Merge, Lookup, Filter, Aggregator, Modify, Copy, Sort, Funnel, Change Data Capture, Remove Duplicates, Surrogate key Generator, Row Generator, Column Generator, and Peek for development and de-bugging purpose.

Environment: Datastage8.1, Sql server, UNIX.

BI Analyst

Confidential

Responsibilities:

• Development of Report as per Functional document.
• Created List and Chart Reports.
• Involved in Report testing.
• Prepared the test cases as per functionality.
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Used Dimensional functions to build crosstab reports from cube datasource.
• Built several reports in Report Studio and Analysis Studio based on cubes published to Cognos Server.
• Created Dashboards by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.

Environment: Cognos10.2, Report studio, query studio, Sql server.

BI Analyst

Confidential

Responsibilities:

• Migrated Reports from Actuate reports to Cognos.
• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.
• Built Power Play Reports in Report Studio and Analysis Studio based on cubes published to Load Server.
• Used Dimensional functions to build crosstab reports from cube datasource.
• Built several reports in Report Studio and Analysis Studio based on cubes published to Cognos Server.
• Involved in Report testing. Prepared the test cases as per functionality.

Environment: Cognos 8.4, Query studio, DB2 Teradata.