PARDHA GANDI ETL Informatica Developer

813-***-**** / accg8r@r.postjobfree.com

SUMMARY:

Over 8 years of Experience in various facets of working on IT Technical and

•

Functional, with Four years of experience in Design, Development and

Implementation of Data warehouses as an ETL Developer. Rest all Experience as

in taken biggest challenging role on business operations as Business Analyst and

as ERP Sales & Marketing, Business Development, Key Account Management

and Team Management.

Four years of strong Data Warehousing experience using Informatica Power

•

Center 9.1/8.6 (Workflow Manager, Workflow Monitor, Repository Manager,

Source Analyzer, Mapping Designer, Mapplet Designer, Transformation

developer), Data mart, ETL, OLAP, OLTP.

Worked closely with the Business Analyst, Data Modelers and Data warehouse

•

Architects in determining the exact business rules and functionalities required for

the delivery of the work articles

Involved in all phases of the SDLC process starting with Requirements Analysis,

•

Technical Analysis, Design, Build, Test, Deploy and Production support.

Strong understanding of Extraction Transformation and Loading (ETL) Process.

•

Dimensional Data Modeling of Star

Extensive Knowledge of

•

Schema/Snowflake and Relational database concepts.

Extensive Experience in creating Tasks, Sessions, Worklets and Workflows in

•

Workflow manager/designer.

Extensive experience with Data Extraction, Transformation, and Loading (ETL)

•

from disparate Data sources like Multiple Relational Databases. Worked on

integrating data from flat files, CSV files into a common reporting and analytical

Data Model.

Extensive Knowledge in design and implementation of SCD slowly changing

•

dimensions types (1, 2)

Pardha Page: 1/7

• Experience in performance tuning of Informatica Sources, Targets, Mappings

and Sessions.

Analyzed, Designed and Implemented different stages of Data Warehouse.

•

Designed and developed complex mappings, from varied transformation logic like

•

Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer,

Sequence Generator, Router, Filter, Expression, Aggregator, Joiner and Update

Strategy.

Involved in Test Planning and execution for various Test Phases: Unit Test,

•

System and User Acceptance Testing.

Extensive experience with Oracle 11g/10g, SQL, Constraints, Views.

•

Involved in jobs scheduling, monitoring and production support in a 24/7.

•

Excellent communication, interpersonal, analytical and presentation skills. Flexible

•

to adopt the working environment.

Ability to excel and succeed in diverse environment and projects with strong

•

determination, dedication and inclination towards customer satisfaction.

Pardha Page: 2/7

TECHNICAL SKILLS:

Informatica Power Center 9.1/8.6 (Repository Manager, Designer, Server

ETL

manager, Work Flow Monitor, Work Flow Manager), Data mart, ETL,

OLTP, OLAP.

Physical Modeling, Logical Modeling, Relational Modeling, Dimensional

Data Modeling

Modeling (Star Schema, Snow Flake, FACT, Dimensions), Entities,

Attributes, ER Diagrams

Oracle 11g/10g/9i, MS SQL Server 2012/2008, SQL *Loader, Quest TOAD.

Databases

tools

Windows Server 2012/2008/2003, Windows 7 & XP, UNIX.

Environment

Ms Visio, MS Office Suite, Enterprise Architect, Sugar CRM.

Others &

Informatica Scheduler, DAC and Crontab

Scheduling

tools

PROFESSIONAL EXPERIENCE:

Informatica Developer Jan

2013 – Present

EYEMED Luxottica, Cincinnati, OH

Project: The EyeMed Data Warehouse project aims to build an integrated data warehouse

for EyeMed which would address the organization’s Business reporting and analytics

requirements. EyeMed aims to develop Informatica mappings to perform ETL process from

different legacy heterogeneous systems (AS400, Sales force, Client crosswalk etc) and

Facets to hpX data model at specified interval in the target system as Oracle. These ETL

codes will help who have Informatica as their technology stack. On top of this hpX Data

Warehouse BI Reporting team creates different reports for end users. The project is split into

two releases and each release is divided into multiple phases.

Responsibilities:

• Interacted with Business Users, Business Analyst and source system owners to

gather the Requirements and Business logics.

• Designed, implemented, documented ETL processes completely based on best data

warehousing practices and standards.

• Based on the requirements created Functional design documents and Technical

design specification documents for each ETL Process.

Pardha Page: 3/7

and

• Designed, developed Informatica mappings, enabling the extract, transport

loading of the data into EDW.

• Responsible for creating mappings as per technical design documents.

• Developed mappings in Informatica to load the data from various sources into the

Data Warehouse, using different transformations like Joiner, Aggregator, Update

Strategy, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier

• Created various Mapplets in designer using Informatica Power Center Mapplet

Designer

• Implemented performance tuning logic on Targets, Sources, mappings, sessions to

provide maximum efficiency and performance

• Tested data integrity among various sources, targets and performance related issues.

• Involved in Unit and System testing of developed mapping

• Created Test script and Test case document.

Environment: Informatica Power Center 9.1, Oracle, 11g/10g, SQL Server 2008, SQL*Plus,

TOAD, Windows Server 2008, UNIX AIX.

Informatica Developer Jul 2011

– Dec 2012

Farmers Insurance, Inc. Woodland Hills, CA

Project: Farmers Insurance is one of the leading companies in the nation for the auto and

property insurance with more than 10 million policyholders. The Insurance Data warehousing

project was developed in an effort to streamline the entire process of Insurance and to keep

track of various financials on a daily, weekly, monthly basis. Claims, Premium, Loss and

Contracts were some of the modules we were basically dealing. The Source systems were

heterogeneous Oracle, Flat File, Siebel and SQL server with the target system as Oracle. As

a ETL Informatica developer my main responsibilities were involved in SDLC of Data

warehouse, Performance Tuning, Error Handling, and implementation of best practices.

Responsibilities:

• Responsible for Evaluation, Analysis, Design, Development and Delivery of Interfaces

(ETL) using Informatica.

• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping

Designer.

• Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup,

Update Strategy, and Sequence Generator.

• Created reusable transformations.

• Creating data mappings to extract data from different source Databases, transform

the data using ETL Informatica Transformations then load to Oracle data warehouse.

Defined Target Load Order Plan and Constraint based loading for loading data

correctly into different Target Tables.

Pardha Page: 4/7

• Code walkthrough with Developers & Client teams.

• Setting up of Unit / Integrated testing of interfaces (ETL) & documentation.

• Implement the Database components (Stored procedures). Alter the existing stored

procedures as per design.

• Created effective Test Cases and did Unit and Integration Testing to ensure the

successful execution of data loading process.

• Provide support to QA testing team to clarify changes and resolve testing issues or

bugs.

• Scheduled Sessions and Batches on the Informatica Server using Informatica Server

Manager/Workflow Manager.

• Responsible for Production support, Performance tuning and Batch monitoring

activity.

Environment: Informatica Power Center 8.6, Oracle, 11g/10g, SQL Server 2008, SQL*Plus,

TOAD, Windows Server 2008, UNIX.

ETL Developer May 2010 – Jun

2011

Morgan Stanley, New York

Project: Order Management System was responsible for handling and maintaining the

Order related information regarding the clients and connectivity information to equities and

Futures markets. The Order management application was responsible for holding existing

client as well as old and new client connectivity and order flow data.

Responsibilities:

• Participated in design and development reviews

• Developed Informatica Mappings, Sessions, Workflows, UNIX Shell Scripts to extract,

validate, transform data according to the business rules

• Translated the business requirements into Informatica mappings/sessions/workflows

• Developed complex MLOAD scripts to load data from existing Edward source tables to

Stage Tables

• Developed Mappings that extract and load the data to Data Warehouse and monitored

the Daily, Weekly, Monthly and Quarterly Loads

• Executed Pre and Post session commands on Source and Target database using

Shell scripting

• Experienced in Trouble shooting and Performance Tuning of sessions

• Worked with System owners to resolve source data issues and refine transformation

rules

• Ensured performance metrics are met and tracked

• Provided Production Support and Maintenance for all the applications with the ETL

process

Pardha Page: 5/7

the

• Involved in review of the code and enhancements for better optimization of

Informatica mappings, sessions and workflows

Environment: Informatica 8.6, UNIX scripting, MS SQL server 2008, Oracle 10g, TOAD,

SQL.

Jr. Business Analyst Jan

2008 – Apr 2010

Luxottica, Gurugoan, India

Project: This Sun Dial Application is a retail Desktop application for their Sun Glass Hut

retail stores. They are implementing this application in Australia and New Zealand, in Sun

Glass Hut, ILORI. This project is to enhance the Additions and Change Requests in Existing

Application which we got for customers.

Responsibilities:

• Identified and validated high potential business opportunities for stakeholders and

developed customized business strategies that are aligned with corporate strategic

objectives.

• Gathered Business Requirements, analyze data/workflows. Defined the scope,

financial projections and Cost/benefit analysis. Progressed from Problem Statement

to well documented Designs.

• Actively involved in validating the requirements and applying Agile Scrum throughout

the SDLC. Collaborated in the creation and updating the Requirements.

• Interviewed clients and defined functional and non functional requirements.

• Created URS User Requirement Specifications and FRS Functional Requirement

Specifications documents.

• Designed Use case and Activity diagrams using UML in Enterprise Architect.

• Reviewed and analyzed the Use cases and came up with System design and Test

plan Templates

• Worked as an Interface between the users and the different teams involved in the

application development for the better understanding of the business and IT

processes.

• Participated and co coordinated the System testing, regression testing of various

builds during integration, performance and User acceptance testing.

Environment: Ms Visio, MS Office Suite, Enterprise Architect, Rational Rose, Photoshop.

CRM ERP Sales and Marketing Jul 2005 – Dec

2007

BRIDLE IT SOLUTIONS, Hyderabad, India

Pardha Page: 6/7

Project: SchoolMATE is the show beginner of Bridle’s innovative product pipeline.

SchoolMATE empowers everyone in the Education Eco System with the advancement

towards the future in helping teachers, students and parents to have a better understanding.

It is a comprehensive automated ICT solution that process izes education, delivery and the

total environment. SchoolMATE [School Management AT Ease] is a CRM + ERP (Customer

Relationship Management + Enterprise Resource Planning) for Educational Institutions.

Responsibilities:

• Identifying prospects through lead generation and building a sales pipeline of

potentials. Prepared a detailed business plan for not to lose sight of my goals and

objectives. Identify crucial leads and executing through team.

• Delivering the presentations and Demonstrations, Monitoring and tracking daily Sales

statuses. Build extensive knowledge in selling ERP software products to large and

crucial clients.

• Expertise in the sales and marketing of IT products and Detailed in planning and

follow ups, Strong negotiation and pricing/Packaging strategies skills, problem

solving.

• Developed and Responding RFIs, RFQs, RFPs and SLAs. Prepared and submitted

agreement drafts & final proposals.

• Assist customers maximize strategic business value from company products to

provide them with vision of their end state solution and roadmap.

• Evaluate customer’s business requirements, needs and objectives and transform

same to company processes, solutions and modules being implemented.

• Ensure seamless transition through customer lifecycle working closely with presales,

Business Development professional, services and support teams.

• Lead design activities defining requirements, testing and provide direction to

customers and junior consultants.

• Engage in project coordinating, team leading and implementing ERP functional

consultation.

• Analyze and solve complex customer issues related to data and processes. Perform

daily activity reporting against plans and schedules.

Environment: MS Office Suite, Sugar CRM.

EDUCATION:

• Master of Science, Andhra University, AP India

• Bachelor of Science, Nagarjuna University, AP India

Pardha Page: 7/7

Contact this candidate