Project Design

[pic] Durga Daparti

************@*****.***

***

*** ****

PROFESSIONAL SUMMARY

> 9 years of IT experience in Software Design, Development and

Implementation of Packaged Data Warehousing solutions with Informatica

PowerCenter 9.5.1/9.1.0/8.6.1/8.1.1, Informatica Cloud, Oracle

9i/10g/11g, SQL Server, DB2, Teradata, Unix and Windows XP/7.

> Very Good exposure in Data Warehouse Architecture and Data Warehousing &

Business Intelligence concepts.

> Experience in gathering and analyzing business needs and converting them

into technical solutions.

> Experience in System analysis and design.

> Worked in a Scrum Agile model, participated in 6 sprints and SDLC models.

> Experience in debugging, troubleshooting and performance tuning of

Informatica mappings.

> Performed Data Profiling and Data Quality as a Data Analyst.

> Knowledge of working with flat files in Unix environment.

> Involved in five full E2E projects using Informatica tools.

> Good exposure on Insurance, Mortgage and Online Gaming domains.

> Experience in creating documentations like Source - Target Mapping, High

level and low level design documents (i.e. functional and technical

design documents) and Production Support documents.

> Excellent team spirit and ability to quickly adapt different project

environments with impressive communication skills.

> Informatica Certified.

> Oracle Certified Associate.

educational qualification

> Bachelor of Technology in Computer Science & Engineering from

J.N.Technological University, India.

Experience SUMMARY

Shinewell Technologies

Jun 2014 - Present

As Senior Systems Analyst

IVY Comptech

Apr 2012 - May 2014

As Systems Analyst

Deloitte

Jun 2010 - Mar 2012

As Consultant - Technology

Accenture

Mar 2006 - May 2010

As Senior Software Engineer

Skill set

ETL Tools : Informatica PowerCenter 9.5.1/9.1.0/8.x and

Informatica Cloud

Other Tools & Utilities : Erwin 3.5.2/4.0, Autosys, TOAD, SQL

Developer, SQL Assistant and WinCvs

Databases : Oracle 9i/10g/11g, Teradata 12.0/13.0, SQL Server

and DB2

Operating Systems : Windows XP/7, Linux and Unix (AIX, HP-UX and

Sun OS)

PROJECT EXPERIENCE

Project #1

Project Title : EDI Loan

Client : FannieMae, USA.

Duration : Oct 2014 - Present

Role : ETL Designer & Senior Systems Analyst

Description : FannieMae, Federal National Mortgage Association (FNMA)

is a government sponsored enterprise and has been publicly traded company.

The corporation's purpose is to expand the secondary mortgage market by

securitizing mortgages in the form of mortgage backed securities (MBS),

allowing lenders to reinvest their assets into more lending and in effect

increasing the number of lenders in the mortgage market by reducing the

reliance on locally based saving and loan associations.

As part of EDI Loan, we process loan data, borrower details in to the

Warehouse. This data is being used as input to the downstream applications.

Responsibilities:

. Meeting with business/users/Ops team to understand the business/data

needs and gathering requirements along with Business Analyst and creating

the High level and Low level technical design documents.

. Participated in Data profiling using Informatica profile and based on the

data, identified the required source data to be populated to meet the

Business requirements.

. Involved in complete source system analysis of Loan and participated in

design of secondary sources of Loan.

. Suggested Error handling process for Primary sources of Loan to reduce

the processing time and database I/O.

. Accepting the business critical issues and providing the optimal

solutions.

. Involved in creating the complex mappings using Informatica and

performance tuning of the mappings.

. Unit testing of the mappings to ensure the code meeting BRD and capturing

the unit test results.

. Error Handling in ETL process, and coming up with process for calculating

the ETL load audit statistics.

. Participated in peer reviews and mentoring the team.

. Involved in Integration test and supported system testing phases.

. Scheduling code and test plans walkthrough meetings to ensure compliance

with project specification.

Project #2

Project Title : Party Poker.com; bwin.com

Client : Bwin.party, Gibraltor, Europe.

Duration : Apr 2012 - May 2014

Role : ETL Designer & Systems Analyst

Description : Bwin.party is the world's leading listed online gaming

company. The Group offers a variety of games through an integrated Party-

branded platform and through a number of secondary brands; the key gaming

sites include PartyPoker.com, bwin.com, PartyCasino.com, PartyBets.com,

PartyBingo.com, Partygammon.com.

Responsibilities:

. Involved in complete analysis and design of Affiliates, ARA data process

and Involved in creating the complex mappings using Informatica and

Teradata queries.

. Participated in source system (Omniture, Net insight) analysis and came

up with solutions.

. Participated in Summary table analysis, designing the Summary tables.

. Suggested performance tuning of the mappings using Teradata queries and

Informatica.

. Built the Informatica mappings, sessions, workflows, and other various

reusable Informatica objects (mapplets & reusable transformations) as per

the defined logic in FDD and TDD.

. Error Handling in ETL process, and coming up with process for calculating

the ETL load audit statistics.

. Participated in UAT Support and Post Production Support.

. Preparing Release Notes, Ops Guide (Run Books), Deployment Plan and

Production transfer documents for each release in the application.

Project #3

Project Title : EXIGEN

Client : California State Auto Authority (CSAA), USA.

Duration : Jun 2010 - Mar 2012

Role : Module Lead & Senior ETL Developer

Description : CSAA (California State Auto Authority) offers a wide

array of automotive, travel, insurance and financial services. In North

America, AAA is a not-for-profit, fully tax-paying federation of 57 motor

clubs with million Members throughout the United States and Canada.

Responsibilities:

. Designing the ETL Process flow and framework.

. Involved in complete design of EXGN data process and in creating the

complex mappings using Informatica.

. Participated in source system (EXIGEN) analysis and came up with new

solutions.

. Participated in HELPER table analysis, which is a crucial part in EXGN

and taken the complete ownership in designing the HLPR tables and

creation of the Informatica objects.

. Creation of the Technical design documents and source to target mapping

documents.

. Creation of the re-usable objects in Informatica and updating the

Technical specs, where ever required.

. Built the Informatica mappings, sessions, workflows, and other various

reusable Informatica objects (mapplets & reusable transformations) as per

the defined logic in FDD and TDD.

. Preparing the unit test cases and capturing the unit test results.

. Participated in Integration test and given post production support.

. Fixing the defects and ensuring the code meeting the business

requirements.

. Participated and presented in Design discussion with

Architects/SMEs/DBAs.

. OnSite-OffShore coordination, participating in client interactions to

resolve any business logic issues/concerns, escalating any techno-

functional issues to the leads and ensuring about the task timelines and

quality.

Project #4

Project Title : Commercial Business Intelligence

Client : Farmers Insurance, USA.

Duration : Sep 2007 - May 2010

Role : ETL Lead Developer

Description : Farmers Insurance Group of Companies was founded in 1928

when Farmers Insurance Exchange, an automobile insurer, was formed.

Accenture is delivering a Business Intelligence solution for commercial

product line. Accenture successfully delivered modules TruckMoney, Claims,

BOP, CPP and Earned Premium.

Responsibilities:

. Understanding of the Business Requirements Documents (BRDs), interact

with client team(s) and come up with "High Level Design Phase"

deliverables like High Level Design Documents and High Level Test Cases.

. Making "Low Level Design Documents" by coordinating with Accenture onsite

and Farmers Client teams

. Creation of Mappings, sessions and workflows for Source to STGC, STGC to

FDRC and FDRC to CPDM.

. Involved in performance tuning and participated in peer reviews.

. Unit testing the ETL workflow & mappings - fixing the defects which came

out of unit testing and if needed, made modifications to the documents to

ensure that those are up to date as per the functionality in the system.

. Performed Earned Premium calculations and helped UAT team in creating the

UAT queries.

. Participated in fixing the defects from various other testing phases.

. Created RUN books for the production team knowledge base and provided KT

on Claims and BOP part to production team.

. Participated in providing the post production support.

. Conducted status review meetings with onsite service delivery manager as

an interface between the onsite and offshore teams.

Project #5

Project Title : Thrivent Financials - PACE

Client : Thrivent Financial for Lutherans, USA.

Duration : Mar 2006 - Aug 2007

Role : ETL Developer

Description : Thrivent Financial for Lutherans and its affiliates

offer a broad range of financial products and services including life

insurance, annuities, mutual funds, disability income insurance, bank

products and more.

Responsibilities:

. Analysis of functional specifications, mapping specifications, source and

target metadata.

. Developed the Informatica mappings, sessions, workflows, and other

various reusable Informatica objects (mapplets & reusable

transformations) as per the defined logic in FDD and TDD.

. Created test plans and maintained documentation of all changes to the

system.

. Conducted and participated in the peer reviews of LLDs, and Mapping

documents and got the sign-off from client to start construction phase.

. Participated in QA and UAT support, fixing the defects in testing phase

and post production support.

Contact this candidate