SUMMARY

• 12 + Years of experience in diversified fields of IT in Designing and developing End - To-End Data Warehousing/ETL/Integration/Mapping solution as ETL Designer for Data warehousing and Business Intelligence for various Clients involving complete SDLC.
• Hands-on DWH designing in implementing best practices in Data Modeling, Data Architecture, Data Quality and Data Profiling with strong client needs assessment talents.
• A leader with mentoring capabilities for DWBI development professionals, Data Modelers and teh proven ability to function as a respected "thought leader" among peer groups inside and outside teh enterprise.
• Having experience in System Analysis, Design and Development in teh fields of data Warehousing, Data Integration and Migration using IBM Infosphere DataStage(11.3), Quality stage, SSIS, SAP BOXI, Oracle, SQL Server, Teradata, DB2, SQL and Shell script.
• Extensive experience on Agile unified process for teh project deliveries and extensive work experience on data modeling for ETL projects.
• Good experience in diversified domains like Banking, Manufacturing, Telecom, Insurance, Inventory and Retail along with technical certifications in ETL from IBM.
• Very good in customer facing and requirements gathering and experienced with high level and Low Level Designs (HLD & LLD) documents.
• Well exposure with functional point analysis while Estimation, Planning and Design in DataStage platform with Implementation.

PROFESSIONAL EXPERIENCE

Infosphere Datastage Developer

Confidential

Responsibilities:

• Involved in teh business requirements gathering and to Analyze source system data to determine ETL solution that will meet business requirements by using Infosphere.
• Involved in Technical Land scape review meetings. Participated in ETL frame work designing and Patterns, Conceptual data modeling, Physical data modeling and Physical design
• Involved in architecture definition document, HLD and LLD design and mapping documents and Proof of concepts.
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and clients.
• Ensure that source to target transformations maintain data integrity and Code-Reviews & Testing.
• Implemented oracle Exadata’s hybrid Columnar compression to save storage space.
• Used Exadata Smart Flash cache and Logging techniques to effectively to speed up teh retrieval of teh data
• Liaise with customers on an ongoing basis with excellent project management skills.

Environment: IBM InfoSphere Datastage 8.1, Oracle Exadata, XML, QlikView and Linux.

Infosphere Datastage Developer

Confidential

Responsibilities:

• Estimate teh resources and participants needed to achieve project goals. Set and Work continually to manage project expectations with onshore-people.
• Ensuring support for leading solution design and proposal presentations for Effective Module Design
• Involved in scalability and performance related design aspects in Database, ETL and Reporting
• Involved in teh business requirements gathering and to analyze source system data to determine ETL solution that will meet business requirements by using Infosphere.
• Extracted data from SAP and implemented SAP IDoc extract and IDoc Load stages.
• Used SAP ABAP and BAPI stages and configured IDoc cleaning and archiving.
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and clients.
• Ensure that source to target transformations maintain data integrity and Code-Reviews & Testing.
• Involved in scalability and performance related design aspects in Database, ETL and Reporting
• Liaise with customers on an ongoing basis with excelent project management skills. Estimate teh resources and participants needed to achieve project goals. Set and Work continually to manage project expectations with onshore-people.
• Ensuring support for pre-sales, leading solution design and proposal presentations for Effective Module Design.

Environment: IBM InfoSphere Datastage 11.3, Quality stage, SAP, SQL Server, XML, QlikView and Linux.

ETL/BI Leader

Confidential

Responsibilities:

• Involved with teh Architecture team to Analyze source system data to determine ETL solution that will meet business requirements by using Infosphere.
• Inovled in creating teh Roadmap for teh MLR ETL structure.
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and clients.
• Ensure that source to target transformations maintain data integrity.
• Liaise with customers on an ongoing basis. Estimate teh resources and participants needed to achieve project goals. Set and Work continually to manage project expectations with onshore-people.
• Involved in architecture definition document and design documents.

Environment: IBM InfoSphere Datastage 8.5, Quality Stage 8.5 Oracle, COGNOS, Business Process server.

ETL Technical Leader

Confidential

Responsibilities:

• Involved in teh Architecture team to Analyze source system data to determine ETL solution that will meet business requirements by using Infosphere.
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and clients.
• Ensure that source to target transformations maintain data integrity.Manage SQL Agent Jobs and other daily processes to ensure availability.
• Performed performance tuning and optimization. Direct and manage project development from beginning to end.
• Reviewed designs, code, and documentation for WIP25DW and Developed project standards and processes.
• Liaise with customers on an ongoing basis. Estimate teh resources and participants needed to achieve project goals. Set and continually manage project expectations with team members.
• Involved in architecture definition document, Macro and Micro design documents.

Environment: IBM InfoSphere Datastage 8.5, Oracle, Filenet, XML, Teradata, SQL server, GECS

BI/ETL Datastage Developer

Confidential

Responsibilities:

• Involved in complete SDLC application from requirement gathering to implementation.
• Technically mentoring teh team, Database model design and maintenance, Project milestones tracking and Report development
• Ensuring that teh design documents produced from teh requirements gathered was exactly wat teh business users had requested.
• Worked as technical lead for analysis design, implementation and support activities of application development and data warehouse
• Utilized IBM Data Stage Best Practices for ETL projects and enforcing coding standards and using STAR TEAM as an version control.
• Completed Data Stage administrative activities, including project setup and DS Job administrator, as well as user setup and administration at UNIX level.
• Developed a custom metadata repository for teh extensive metadata needs of teh organization Code migration planning and client support for UAT test.

Environment: IBM DataStage 7.5.2, Microstrategy, DB2, Starteam and AIX

ETL Leader

Confidential

Responsibilities:

• Designed and implemented teh Datastage jobs to pull teh data from Flat files to P2P database and Experienced with source data cleansing and profiling
• Segregating, mentoring and assigning teh tasks to ETL team, Creating and establishing teh control process to monitor load and un-loaded teh data into teh system.
• Strong knowledge in teh security-user role definition, code deployment process, back& restore activities, job scheduling and performance tuning process.
• Worked with Business objects report developer to generate enterprize wide reports and operational reports.
• Designed universes for billing and orders systems.Tuned Report Performance by creating objects and rewriting teh SQL for teh report variables at teh universe level and Implemented java SDK's to improve teh performance.
• Generated reports based on Fiscal week, Fiscal Month and Fiscal Year for data analysis purpose
• Automated Data Load Process of ETL to fit into batch window from various systems into data warehouse.
• Created Job Sequence design for entire set of jobs developed and Completed performance tuning jobs using various configurations by understanding its complexity during volume testing before moving to production.
• Took Initiation during teh time of Initial load and Wrote Maintenance scripts for sending Job status mails, Job failure notification mails and job duration mails for teh responsible persons.

Environment: Ascential DataStage 7.5.1A (PX), DB2, SAP BOXI and BODS, XML, PL/SQL, AIX, F-Secure SSH

ETL Designer

Confidential

Responsibilities:

• Worked on Provisioning domain to improve teh DS jobs runtimes and load times. Worked on Historical Loads, developed DataStage jobs for Historical Loads, reads teh extract files, loads to a Staging Tables and to Marts.
• Worked on loading static dimensional tables and repeaters on vRepair Domain.
• Modified vRepair Warehouse/Mart DS Jobs & Provisioning West Mart for performance tuning to improve teh runtimes & load times.
• Modified Monthly Load Jobs IVEW (East Line Counts) to teh run processes in parallel and creating multiple udb loads files parallely to cut down teh process time.
• Giving Production support extensively, Involving in running history update scripts.
• Manages issue and defect tracking, strong analysis and problem solving skills.

Environment: Ascential DataStage 7.5.2, DB2 UDB, PL/SQL, AIX, F-Secure SSH Client

ETL Admin and Developer and shell script developer

Confidential

Responsibilities:

• Designed and implemented teh Datastage jobs to pull teh data to Royalty database.
• Maintained, developed & implemented policies and procedures for ensuring security and integrity of teh data warehouse
• Developed solutions for complex logic by writing universe routines and contributed in unit testing, parameterization of Datastage jobs through parameter file.
• Took Initiation during teh time of Initial load, Contributed Performance tuning in teh production environment.
• Wrote Maintenance scripts for sending Job status mails, Job failure notification mails and job duration mails for teh responsible persons.
• Wrote duration report for all teh jobs and mail notifications manually if any job aborts.

Environment: DATASTAGE 6.0, SQL Server, XML, UNIX

Shell script developer and ETL Administrator

Confidential

Responsibilities:

• Installation of Datastage server. Stop/restart teh services of datastage on UNIX server.
• Configured teh Datastage server, and applying Datastage server security.
• Installed Siebel PACK 3.0.1 Patches and Tested DataStage Server with all Patches
• Moving all projects and their hash files to teh new server.
• Validate Data Source and Target Connectivity per each Project and writing shell scripts.
• Reviewing teh server resource management reports with customer.

Environment: Datastage 6.0, Sun solaris5.2.