SUMMARY:

• 5 years and 10 months experience in Data Warehousing(ETL), Data Migration and Business Intelligence(reporting) at both offshore and onshore locations with prominent experience in Banking, Financial and Insurance domains. Has been involved in whole SDLC life cycle for various development and maintenance/enhancement projects and has worked on ETL job development, code migration/deployment, scheduling and production support etc.
• Worked extensively on IBM Datastage, Actuate erdPro and Actuate BIRT, PL - SQL, UNIX scripting and scheduling tools
• Expertise in Data Requirement Analysis, Design, Development of ETL process using IBM DataStage
• Extensively worked on various DataStage Stages like Transformer, Join, Lookup, Pivot, Merge, Sort, Filter, Aggregator, Copy, Remove duplicates, Funnel, Change capture, Data Set, Sequential File etc.
• Has been involved in whole SDLC life cycle for various development and maintenance/enhancement projects
• Has played various roles like developer, onsite coordinator, ETL designer etc.
• Experience in analysis, requirement gathering, design, development, deployment and testing of ETL jobs
• Strong knowledge of data warehousing concepts like schemas, data marts, data load, facts and dimensions etc.
• Understanding of business process and data models

TECHNICAL SKILLS:

Business Domain: Confidential Domain and Insurance Domain

Programming Languages: SQL and PL/SQL, Shell Scripting

Operating System: Windows 7/XP/2000, UNIX

Tools: /DB /Packages: DataStage 8.0/8.5, Actuate erdPro, BIRT, DB2, Oracle SQL, PL/SQL, AbInitio (Trained), QlikView(Trained), Khalix(Trained)

Technical Domain: Business Intelligence and Data Warehousing

PROFESSIONAL EXPERIENCE:

Confidential

ETL Consultant

Responsibilities:

• Member of AMIG’s project team and clearly understands and aligns with the development goals, project goals, deliverables and commitments
• Transforming and providing source data to agents in required formats using Datastage
• Responsible for developing new DataStage jobs, re-designing and simplification, performance tuning and upgrade activities
• Contributes to both DataStage development and Support activities
• Manage and control workload, maintain quality of deliverables, control schedule and cost for DataStage support
• Providing support to code deployment process
• Coordinates with both onsite and offshore team
• Support Guidewire Policy/Billing center issues

Tools: / Technologies Windows Server 2008, Infosphere DataStage 8.7, Oracle 11g, Putty, Control-M, SQL Developer, DB2

Confidential

Senior DataStage Developer

Responsibilities:

• Information Management Support (Inclusive of InfoSphere and Cognos BI)
• Commercial Portal support
• Healthcare Data Warehouse Support
• Member of Munich Re’s project team and clearly understands and aligns with the development goals, project goals, deliverables and commitments
• Contributes to both DataStage development and Support activities
• Manage and control workload, maintain quality of deliverables, control schedule and cost for DataStage support
• Responsible for DataStage jobs re-designing and simplification, performance tuning and upgrade activities
• Providing end to end support for Datastage ETL jobs
• Transforming and providing source data to ISyCl application based on client requirement
• Providing support to code deployment process

Tools: / Technologie Windows Server 2008, Infosphere DataStage 8.7, Oracle 11g, Putty, Control-M, SQL Developer, DB2

Confidential

Project Member

Responsibilities:

• Analyze the ETL sequence for the scope of Improvement
• Understanding the business reporting requirements
• Design and development of jobs for data load as per the requirement
• Verifying the loaded data through PL/SQL scripting
• Maintaining quality processes for the projects
• Applying appropriate Null Handling in the existing ETL jobs
• Involved in performance tuning activities
• Quality Center used as defect and requirement repository

Tools: / Technologies Windows XP, Datastage 8.5, Teradata v13, SQL Assistant

Confidential

Project Member

Responsibilities:

• Provide reporting solution.
• Design and maintain the schema for the underlying Data Warehouse.
• Implement Report and data level security across all dashboards to enable only the appropriate users to access the reports.
• Create a simple web-Interface to provide single point of access to all the Dashboards.
• Development of reports using Actuate8.
• Testing and Defect Analysis of the application.
• Deploying Code to UAT and Production
• Incident Tickets resolving
• Coordinate with Database and Actuate Reports
• Making the Metadata entries in the Database and monitoring them
• Attending regular team meeting to discuss the status of the work

Tools: / Technologies Windows XP, Actuate eRDPro, Unix, SVN, IBM DB2

Confidential

Project Member

Responsibilities:

• Development of reports using Actuate BIRT
• Testing and Defect Analysis of the application
• Deploying Code to production

Tools: / Technologies Windows 98/XP, Actuate BIRT, Oracle

Confidential

Project Member

Responsibilities:

• Generated dimension tables and fact table
• Tested all the dimensions and fact tables based on the requirement
• Having regular team meeting regarding the status of the work
• Maintaining the overall performance of the project

Tools: / Technologies IBM WebSphere DataStage Ver. 8.0, MS SQL-Server