SUMMARY:

• Over nine years of IT expertise in various BI initiatives and client - server applications, this involves requirement gathering, system analysis, development, testing activities, and complete project life cycle development.
• Over six years of expertise in data warehousing solutions, which involves various phases like requirement gathering, modeling, design, development, testing and implementation and excellent solutions to the complex projects
• He has experience and rich knowledge on ETL tools like Confidential InfoSphere DataStage, and Oracle Data Integrator (ODI), and Databases like (Oracle, DB2, Teradata).
• Over nine years of extensive interaction with the database provided rich knowledge on Architecture of various databases like Oracle, DB2, and Teradata and ability to optimize the query to the best possible execution.
• Over two years of expertise in the client-server application’s development for banking domain laid foundation on the business insight.
• He worked as ETL architect with client to build Confidential standards and Methodologies and ETL templates.
• He developed automation tools to reduce the development time and improve the standardization and increased time to concentrate on business.
• He has been selected as solution provider for the problems like performance tuning, recovery solutions and more complex problems.
• Projects execution using common architecture to develop data warehousing solutions. hese 9+ years of experience provides knowledge and methods to understand and switch over to new tool in no-time and in his ISDW project he switched to Oracle Data Integrator ELT tool.
• Confidential certified WebSphere Developer

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

ETL Specialist

Responsibilities:

• Worked as ETL specialist to develop a process to automate ODI interface generation using mapping document.
• Reverse engineered Unix shell script and SQL scripts to mapping document.
• Trained three resources on ETL processing and data warehousing concepts and ODI.
• Successfully reverse engineered and developed two large data mart.

Confidential, Philadelphia, PA

ETL Architect

Responsibilities:

• Worked as ETL Architect to develop Process and Re-Usable components.
• Actively involved in code reviews and guiding the developers for quality and timely deliverables.
• Successfully knowledge transitioned to other team members on the common architecture of ETL.
• Coordinating with Confidential for any issues related to datastage.
• Helping team to build quick solution on some of the subject area to meet the deadline.

Confidential, Boise, ID

ETL Architect

Responsibilities:

• Worked as ETL Architect to develop Process and Re-Usable components.
• Developed ETL framework along with other ETL Architects.
• Developed ETL templates for various layers in DW and various types of table.
• Developed few tools/ process in place to reduce the development activity time and to increase the time for business process concentration.
• Actively involved in code reviews and guiding the developers for quality and timely deliverables.
• Successfully knowledge transitioned to other team members on the common architecture of ETL.

Confidential, Minneapolis, MN

ETL Architect & Tech Lead

Responsibilities:

• Worked and guided the team for analysis, design and testing phases of the project.
• Built this DW using the common architecture for the ETL.
• Created data model using the CA Erwin for this data warehousing.
• Actively involved in code reviews and guiding the developers for quality and timely deliverables.
• Extensively worked in the performance tuning and pro jection of resource utilization.
• Worked extensively on Datastage EE 7.5 (Parallel Extender).
• Actively involved in the implementation planning and support turn over.
• Involved in the knowledge transition to the other team members on the common architecture of ETL.

Confidential, Minneapolis, MN

ETL Consultant

Responsibilities:

• Provided quick SQL formatted analysis to help the business team to come up with the requirement for various analysis related to long term Confidential analysis.
• Created data model using the CA Erwin for this data warehousing.
• Designed quick source to Confidential mapping for analytic purpose.
• Worked on various analysis from various systems to ensure understanding of the data.
• Worked extensively on Datastage EE 7.5 (Parallel Extender).
• Involved in the process definition for identifying the areas to be analyzed.
• Good understanding on Confidential technology.
• Worked closely with the Essbase developer to ensure the timely and quality deliverables.
• Involved in the shell scripting for jobs execution and wrapper shell scripts

Confidential, Minneapolis, MN

ETL Consultant

Responsibilities:

• Provided quick SQL formatted analysis to help Confidential team to identify the source table and column they needed.
• Worked with the team to ensure the design is scalable and optimized to minimum resource utilization.
• Part of the reviewing team member for the ETL jobs and validating mapping of source to Confidential mappings.
• Worked as SME (Subject Matter Expert) of Analytical Data Warehouse side for Confidential team.

Confidential, Minneapolis, MN

ETL Architect

Responsibilities:

• Part of team to decide on interface strategy between ATG and IM visualizer and java stored procedure.
• Provided various solution and its pros and cons and suggested best of those solutions as Java stored procedure to ensure dynamic summarization will be handled smooth and as quick as possible.
• Delivered ETL mapping and piece of java stored procedure, which is the first and far most need of the project
• Worked extensively on Datastage EE 7.5 (Parallel Extender).
• Actively involved in performing code reviews and guiding the developers for quality and timely deliverables.
• Extensively worked in the performance tuning of the Java stored procedure for query optimization.
• Involved in the shell scripting for jobs execution and wrapper shell scripts

Confidential

ETL Architect & Developer

Responsibilities:

• Actively involved in team to define common file format of all source system and file format between systems like Experian, Tandem, and ETL.
• Designed source to Confidential mapping in compliance with all business rules in Datastage.
• Extracted data from various data sources like DB2 UDB, Files and Oracle using Datastage.
• Actively involved in performing code reviews and guiding the developers for quality and timely deliverables.
• Worked extensively on Datastage EE 7.5 (Parallel Extender).
• Extensively worked in the performance tuning of the mappings, ETL standards and processes.
• Part of the team who schedules extraction and load processes and monitor sessions using Control-M scheduler .
• Involved in the shell scripting for jobs execution and wrapper shell scripts.
• Actively involved in the implementation planning and support turn over.

Confidential

ETL Developer

Responsibilities:

• Member of the tool selection committee to decide for this interface.
• Actively involved in the analyzing, design and development phases of the project.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Datastage.
• Creating Datastage mappings to generate the XML interfaces file between Confidential and Service Bench.
• Complete automation of daily data extracts procedures.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Managed the metadata associated with the ETL processes used to extract the data.

Confidential

Developer

Responsibilities:

• Involved in collection of request for change and enhancements from the users, the change was then converted into the database structure if required using Erwin.
• Worked closely with the end users and user decision makers to create the system frame work for the track changes.
• Day to day coordination with the off-shore team regarding the track changes and status of the same.
• Creating PL/SQL Stored Proc for the track changes.
• Unit testing for the Oracle Stored PL/SQL Packages.
• Performance tuning for Oracle Stored PL/SQL Packages.

Confidential

Developer

Responsibilities:

• Involved in the high level & low level design for the above said replication model.
• Converting existing Pro*C DB2 procedures into Oracle Stored PL/SQL Packages.
• Prepared test cases for Oracle Stored PL/SQL Packages & DB2 Database triggers.
• Unit testing for the Oracle Stored PL/SQL Packages & DB2 Database triggers.
• Performance tuning for Oracle Stored PL/SQL Packages.
• Offshore support for UAT.

Confidential

Team Lead

Responsibilities:

• Developing system framework in consultation with Functional Experts and domain specialists using Microsoft office tools.
• GUI design and Reports design using Developer 2000, defining Database objects with a view to deliver maximum user friendliness.
• Providing support for the UAT and after implementation.
• Coordinating with remote users for their accessibility and problems.
• Scheduling and task identification for the implementation.
• Maintenance of the system (solution to the problem and enhancements).
• Basic DBA activities.