PROFESSIONAL SUMMARY:

• More than 7 years of IT experience in analysis, design, development, testing, data modeling, estimation, implementation,integration and maintenance of various Database Applications, operational as well as Datawarehousing applications.
• Started the Career with Confidential Ltd, currently leading the Data Integration team within Confidential, RI.
• Technical expertise in ETL (Extraction Transformation Loading - Informatica 7.x,8.x), Informatica Power Exchange, reporting(Business Objects 5.x,6.5, Business Objects XI R2).
• Well acquainted in the designing of Star, Snowflake models and use of Erwin to design the data model.
• On the database front, expert in Oracle 9i,10g, Teradata V2 R6, IBM DB2
• An Oracle Certified Associate (OCA), Business Objects Certified Professional (BOCP), Informatica Certified Designer and well conversant with CMM Level 5 quality procedures while executing the projects.
• Proven expertise in delivering the solutions in onsite / offshore model.
• 3.5 years of experience in leading the team.

PROFESSIONAL EXPERIENCE:

Confidential, PLANO, TX

Responsibilities:

• Lead the team of 9 people to deliver the various phases of datamart.
• Delievered the EDW first phase in Ralph Kimball methodology / EDW 2nd phase in Inmon methodology.
• Requirements gathering / analysis of the requirements.
• Creating the technical design document for various phases of the delivery.
• Designing the ETL Solutions in Informatica / Power Exchange /Shell scripting.
• Work Allocation among the team members, ensuring the development activities to happen as per the design.
• Presenting the technical design among the Client Technical Architect team and receiving the sign off.
• Designing the various technical solutions which were used Confidential organization level like CDC, Reconciliation between the source and primary staging, running the workflows as per the user input.
• Assisting the Consulting Group with the Pre Sales activities such as writing the documents of technical solutions for the prospective customer.

Confidential, Dallas, TX

Responsibilities:

• Designing the ETL Solutions from the OLTP tables as the source and storing the data in summary tables for reporting solutions using Informatica.
• Developing the BO Universe.
• Designing the dashboard reports to be called by the JAVA Web application.
• Using the BO SDK Classes and objects to setup a handshake between JAVA Web app and BO.
• Supporting the BO universe and reports in production.
• Designing the ETL solution using JDK framework to load the files in temp Oracle table.
• Gathering database design requirements, database volume calculation prior to project initiation.
• Creating the logical and physical data model using CA-Erwin.

Confidential, Compton, CA

Responsibilities:

• Development of universes and reports in BO XI R2 as per the discussion and meeting with the Users.
• Supporting and maintaining the BO reports in production environment and solving the daily production issues.
• Automating the existing manual processes in the reporting environment depending on other application processes such as kicking the various instances of the BO report on the completion of the ETL process.
• Supporting and maintaining the ETL code which includes modifying the existing Oracle packages and procedures.
• Loading the data from OFA files to Oracle 10g Warehouse using SQL Loader.
• Creating an automating Shell scripts to FTP the OFA Files to shared location.

Confidential

Responsibilities:

• Leading a team of 6 people and directly reporting EVP of Morgan Stanley for project tasks.
• Development of universes and reports in BO XI R2 with the auto sort and auto indentation implemented Confidential the report level, which will be validating the data loaded by the ETL Code.
• Automating the existing manual processes in ETL code(Informatica) in order to avoid any manual intervention during the production run, which included the development of shell scripts.
• Developing the views, SQL’s and procedures on ad-hoc basis in Teradata on Teradata SQL Assistant, Windows based tool, which are eventually called by Webservices.
• Developing the mappings to load the legacy data(DB2, VSAM files,Sybase) from various sources to Teradata through loaders (MLoad).
• Tuning the Informatica mappings to improve the running time.
• Performance tuning of the Teradata stored procedures by analyzing the explain plan of the queries.
• Used calculations, variables, sorting, drill down, slice and dice for creating Business Objects reports.
• Converting the full client DESKI reports to WEBI reports using Report Conversion tool.
• Creating the various project metrics documents to track the health and compliance of the project.

Confidential

Responsibilities:

• Leading a team of 4 people, code review before releasing to production.
• Designing data model using Erwin.
• Development of Informatica mappings and the shell scripts which on schedule ftp the files to the various applications team receiving the data and send them an email intimating them about the availability of the files.
• Constantly involved in many Change Requests Confidential the ETL(Informatica) side.
• ETL support during all phases: QA, SIT, UAT, Go Live and post production
• Supervision of all Migration Activities of all database objects from DEV
• Environment to Quality Assurance and finally to Production Environment
• Supervision of Testing of all objects in Production once the movement is complete
• Development of BO universes and reports.
• Performance tuning of the Oracle database queries used in the BO reports.
• Supporting the already existing BO reports in production.
• To make sure the already existing security Confidential supervisor level(Row level security) always hold true and report displays the data intended for the user depending upon his unique identifier.

Confidential

Responsibilities:

• Developed the universes and complex BO reports fetching the data from 2 universes simultaneously and linking the universes Confidential report end and using the complex output and input contexts to display the data as per the client requirement.
• Development of the Informatica mappings and the workflows to load the various fact and dimension tables
• Performance tuning of the Informatica mappings to improve the load time.
• Automating the existing Informatica ETL processes using parameter files.

Confidential

Responsibilities:

• As a team member, the job responsibilities included:
• Analysis of the specifications provided by the clients
• Design, Development & Supporting the BO reports in production
• Worked extensively Confidential the BO Reporting and Designer side.
• Single point of contact to the client for Reporting related activities.
• Handled complex BO reports including cascading prompts ; master detail reports and other complex features of BO.
• Involved in the designing of Informatica mappings and the shell scripts which ftp the files to the various applications team and emailing them about the success of the process.
• Informatica mapping performance tuning.