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