Project Manager Sql Server

Venkat Contact:732-***-****

Sr. Consultant- Informatica (ETL)

Summary:

> Have 14 years of experience in implementation and supporting post

Production of Data warehousing and Data migration Projects.

> Strong experience in implementing Data warehousing/Data migration

techniques from the scratch Using ETL tools such as Informatica

9.1/8.6/7.3 and BODI/BODS/BODQ which involves source code

customization, testing, debugging and maintenance of complex systems.

> Worked 5 years in Europe as an SAP Data Migration specialist.

> Rich experience in huge SAP Data Migration projects from End to end

using ETL implementations.

> Experience in Oracle, DB2, and Teradata databases and extensively

worked in Autosys,UNIX, SQL, PL/SQL programming.

> Individual contributor to the Project as a Technical member.

> Knowledge on Performance Tuning in Informatica.

> Performed short and long term strategic business activities - by

developing, enhancing and maintaining operational information and

models.

> Good experience in supporting complex Financial Warehouse systems.

> Conduct impact assessment and determine size of effort based on

requirements.

> Thorough understanding of Software Development Life Cycle (SDLC),

involved in various phases - Requirements, Analysis/Design,

Development and implementation.

> Worked on performance tuning in huge volumes of data warehouse

systems.

> Good understanding of Business Processes and Data warehousing

Concepts.

> Perform as an active, leading role in shaping and enhancing overall

ETL Informatica architecture.

> Quick learner with a desire to work in a team oriented environment.

> Experience in Onsite-Offshore model.

> Proven technical leader in large and complex data intensive solutions.

> Effectively communicate with Business Users and Stakeholders.

> Expertise in ETL activities like Data Extraction, Data Modeling, and

Loading (Full/Delta upload).

Skill Set:

Data warehouse : ETL (Informatica 9.1, 8.6, SAP BO DI XI),DAC

Language : C, C++, Java, SQL, PL/SQL,LSMW

Databases : Teradata,DB2,SQL Server 2000/2005, Oracle

8i/9i/10g, MySQL, MS Access

Operating Systems: Windows family, UNIX

Certification : Informatica Certified Developer

Professional Experience:

OptumRx Scalability&NHI

January 2012 - Dec 2013

Sr.ETL Consultant&Business Analyst

Environment: Informatica V 9.1/8.6, Sql server 2008, Teradata, DB2, UNIX

shell scripts.

Responsibilities:

. Individual contributor to the Project as a Technical member.

. Involved in developing shell scripts, PL/SQL Procedures for the

applications.

. Understanding the design and verifying its Business logics as per

requirements.

. Developing Mappings as per given design, and raising issues where ever

problem arises.

. Unit Testing the ETL's with test data and Involved in peer reviews.

. Worked on most of transformations and implemented complex mappings.

. Responsible for resolving and/or driving the resolution to issues and

risks through evaluation of differing opinions to negotiate resolution

and priority.

. Optimizing performance for session taking huge data and amount.

. Code changes and Coding new programs - Enhancements.

. Direct interaction with client through status calls and emails at all

stages.

. Performed post Load QA checks and trend analysis on the production data.

. Defined and explored various operational solutions for implementation of

new business requirements without impacting the existing architecture

standards.

. Identify opportunities for further enhancements and refinements to the

ETL standards and processes.

. Responsible for preparing Functional and ETL Technical design documents.

. Effectively managed a list of issues and risks, identifying owner,

priority, timelines, and other relevant information.

. Conducted training and presentations to the business stakeholders on

various development and operational processes, applications and new value

add initiatives.

. Created Work Orders/Prompts for various Light enhancements and have been

responsible for successful implementation of the enhancements.

. Created SOWs, BRDs and Functional specification and design documents for

various projects and well versed with the processes.

. Handled complex Claim process system Enterprise Data Mart (EDM).

. Utilized my strong domain knowledge in Healthcare and compliance data

needs to finalize the solutions for various projects.

. Ensures high quality, adherence to standards and best practices, high

performance, and scalable, repeatable processes and deliverables.

. Improved performance of ETL Operations by recommending appropriate

techniques and streamlining the process.

. Integrated UHCP Medico system business successfully into existing EDM

data warehouse.

. Responsible for various requirement implementations and sign off from

various end business users, technical and QA team.

. Given inputs for the architectural changes for the existing book of

business while integrating the UHCP.

. Effectively managed a list of issues and risks, identifying owner,

priority, timelines, and other relevant information.

Clinical Management Program (CMP)

Sep 2011 - Jan 2012

ETL Architect

Environment: Informatica V8.6, Sql server 2008, Teradata, DB2,

Microstrategy.

Responsibilities:

. Handling complex Facts and Dimension table loads.

. Closely monitoring UAT phase and responds to users very quickly in

case of any issues.

. Identify opportunities for further enhancements and refinements to the

ETL standards and processes.

. Responsible for preparing Functional and ETL Technical design

documents.

. Ensures high quality, adherence to standards and best practices, high

performance, and scalable, repeatable processes and deliverables.

. Collect the weekly Status reports on the developments of the project

and cascade them to High level management.

. Effectively communicate with Business Users and Stakeholders.

. Created documentation for technical and supports point of view.

. Contributes to project success by providing technical leadership on

assigned projects.

. Analyze application and data integration problems, provide

alternatives and recommend corrective action

Fox Film Corporation, LA

Dec 2009 - Sep2011

Sr.ETL Consultant

Environment: Informatica V8.6, Sql server 2005, Teradata, DB2, UNIX shell

scripts, Autosys, OBIEE, and JAVA.

Responsibilities:

. Responsible for preparing ETL enhancement design documents.

. Handling complex financial applications like E1 (Enterprise one),

Atlas.

. Monitoring daily running production jobs and responds to users very

quickly in case of any issues.

. Identify opportunities for further enhancements and refinements to the

ETL standards and processes.

. Ensures high quality, adherence to standards and best practices, high

performance, and scalable, repeatable processes and deliverables.

. Perform monthly extracts from dataware house and results will be sent

to finance team for analyzing.

. Ensured 100% SLA's are met.

. Working on performance tuning in order to finish all running

production jobs in time.

. Collect the weekly reports on the developments of the project.

. Understanding the new functional and Technical Specifications and

identifying measures, dimensions.

. Effectively communicate with Business Users and Stakeholders.

. Created documentation for technical and supports point of view.

. Lead the team. Responsible for Cross Training ETL and BI

. Contributes to project success by providing technical leadership on

assigned projects.

. Provide input and recommendations on design/technical issues to

Project Manager/Senior Managers.

. Develop mappings with performance, accuracy and efficiency to achieve

operational objectives.

. Analyze application and data integration problems, provide

alternatives and recommend corrective actions.

. Understanding new requirements of projects, preparing Functional

Specs, Technical Specs, Impact analysis, Customization, creating Test

cases & sign offs.

INSIGHT (IATA),Switzerland.

Feb 2009- Dec 2009

Data Migration Lead

Environment: SAP R3,Business objects XI V3.1 (BODI,BODS,BODQ), Sql server

2005.

Responsibilities:

. Actively involved in requirement gathering, gap analysis, Design and

implementation.

. Responsible for preparing ETL design documents.

. Evaluates and recommends ETL solutions to meet user needs.

. Ability to define and implement approaches to load and extract data

from data sources.

. Identify opportunities for further enhancements and refinements to the

ETL standards and processes.

. Work with technical teams on the technical issues of SAP BO DI tool.

. Transform all the business requirements into successful data loading

process.

. Building trust with Quality of deliverables and Managing expectations

with consistency

. Transparency with the IATA team and raise the issues + be part of the

solution

. Proactively manage a realistic balance between innovation and

delivery.

. Take personal responsibility while delivering the complex data

objects.

Globe, Nestle Italy, France, UK, Germany, Netherlands, Spain, and Swiss

July 2004 - Jan 2009

ETL Technical Lead

Environment: Informatica 7.x, Sql server 2005, DB2, SAP, LSMW

Responsibilities:

. Handled all the responsibilities very effectively in the fields of all

data conversion (IDB, ETL, DQT, and LSMW) areas.

. Designed FS, TS for the complex objects for which data is coming from

the various legacy systems.

. Coordinated with the offshore team and as well as local client team

for all the necessary actions.

. Anticipated peak workloads and managed very well without any issues

. Managed and coordinated very well for the complex changes in the

objects so that they will not impact the project plans.

. Planning, analyzing and defining high-level software strategies and

solutions through business, functional and technical expertise.

. Supervising the design and implementation of analyses that will

identify requirements Related to people, processes and technology.

. Implementing or supervising the implementation of the technical

infrastructure

. Integrating technical and application components.

. Designing the framework of a technical infrastructure.

. Supervising the designing, coding and testing of program modules.

. Supervising the maintenance, repair and tuning of applications;

directing user support activities; managing preventive maintenance

activities.

. As an experienced person in the Nestle France went to the Spain,

Netherlands, Italy markets for assistance during their critical phases

of the projects.

Globe,Nestle Brazil

Oct 2003-June 2004

Senior developer

Environment: Informatica 7.x, DB2,LSMW,Sql server 2005

Responsibilities:

. Developed complex ETL mappings and delivered in time.

. Coordinating with client as a market coordinator for smooth delivery

of UK & UP objects and this involved leading the team in a knowledge

transfer from client site, setting up the process for trouble shooting

the problems in developmental activity.

. Involved in the first 24x7 operations for the Support Services for UK

& UP market.

. Planning the 24x7 operations by leveraging the existing resources

helped streamline the support operations and provide an integrated

approach to supporting the ETL.

MMEI Data warehouse, Abudhabi,UAE.

June 2000 - Oct 2003

ETL Consultant

Environment: Informatica 7.x, Sql server 2005.

Responsibilities:

. Developed SALES DATAMART

. Extracted data from Flat files and Oracle Database using Informatica

. Worked on Informatica -Source Analyzer, Data warehousing designer,

Mapping Designer & Mapplet, and Transformations using most of the

available transformations

. Dealt with the slowly changing dimensions.

. Designed and developed complex aggregate, join, look up transformation

rules (business rules) to generate consolidated (fact/summary) data

identified by dimensions, using Informatica ETL tool.

. Maintained stored definitions, transformation rules and targets

definitions using Informatica repository manager.

. Scheduled and monitored transformation processes using Informatica

Server Manager.

. Communicated project status and escalated issues to management

. Projects:

. A. Material Management System

. B. Fuel Management System

. C. Soft Wheel, Hospital Information System & Soft Cuisine and F. Life

. Worked on Developer 2000, SQL&PL/SQL on UNIX, Windows platforms

. Involved in development activities like designing various consolidated

inventory reports using Reports 4.5.

. Involved in automating the processing of the transaction made at fuel

depots of South Central railways.

[pic]

Contact this candidate