Manager Developer

Deepti Sharma

Cell: 661-***-****

Email: ********.***@*****.***

Professional Summary

. A result driven professional with 7+ years of experience in software

development including data warehousing, ETL using Informatica, Oracle,

SQL Server, Windows server, UNIX and Informix.

. 5+ years of experience in Data Analysis, Data profiling and Data

cleansing.

. Strong educational background specialized in Computer Science and

Business Administration.

. Proficient in Informatica development using Power center including

Source Analyzer, Target Designer, Transformation Developer, Mapplet,

Mapping, Task Developer, Worklet Designer, Workflow Designer, reusable

and non-reusable transformations, reusable and non-reusable sessions,

email tasks, commands and Informatica Monitor.

. Extensively worked on developing and debugging Informatica mappings,

mapplets, sessions and workflows

. Implementation of full lifecycle in Data warehouses and Business Data

marts with Star Schemas, Snowflake Schemas, SCD & Dimensional Model.

. Worked on Performance Tuning Informatica Targets, Sources, mappings

and sessions

. Outstanding communication and interpersonal skills, ability to learn

quickly, good analytical reasoning and high compliance to new

technologies and tools

. Self-motivated team player with excellent technical and problem

solving skills.

. Self-starter and quick-learner with ability to work independently.

. Expertise in doing Unit Testing, Integration Testing, System Testing

and Data Validation for Informatica Mappings

Technical skills

ETL Tools: InformaticaPowerCenter/Powermart 9.0/8.6/8.5/8.1/8.0

(Designer, Workflow Manager, Workflow Monitor,

Repository manager and Informatica Server), IDQ,

PowerExchange

Databases: Oracle 10g/9i/8i,Peoplesoft, MS-SQL Server 2000/5/8,

Informix, DB2, Teradata, Sybase

Database Tools: TOAD, SQL plus, SQL Developer, SQL Navigator, Rapid

SQL, SQL Server Management Studio

Packages: Lotus Notes, Sharepoint, MS -Word/

Excel/Powerpoint/Outlook/ Visio

Operating System: WIN 95/98/NT/2000/XP/7/8, UNIX, Linux, AIX, HP-UX,

MS-DOS

Unix Tools: WinSCP, HP FTP Client, Humming Bird, Exceed, Putty

Text Editors: UltraEdit, Notepad++, Textpad, Editplus

Scheduling Tools: Autosys, DAC

Other Tools: Clearcase, Clearquest, Dart, Doors, Remedy, Jira

Education

> Informatica Certified Training on Powercenter 9.x Level 1 Developer.

> Master's in Business Management (Human Resources) from Guru Jambeshwar

University, Hisar (Haryana) Sep 2004 - Mar, 2007.

> Master's in Science (Computer Science) from Maharishi Dayanand

University, Rohtak (Haryana) from Sept 2001- Oct 2004.

> Post Graduate Diploma in Computer Science from Maharishi Dayanand

University, Rohtak (Haryana) from Sept 2001- Oct 2003.

> Bachelor's degree in Bachelor of Business Administration from Punjabi

University Patiala (Punjab) from Sept 1998 - July, 2001.

Professional Experience

Sr. Informatica Consultant

April 2012 - Current

Freddie Mac, McLean VA

Freddie Mac is one of the biggest financial firm which provide liquidity,

stability and affordability to the U.S. housing market. Currently I am

working as a Sr.Informatica Consultant and worked on many different

projects here. I worked on Financial Data Mart, Financial Data Warehouse,

Accounting Sub Ledger, Expense Planning & Financial Forecasting, Expense

Reporting project. I am playing a key role in implementing end to end

project starting from requirement gathering, analysis, providing LOE,

designing the ETL process, developing the mappings, unit and integration

testing, supporting SIT, UAT and PROD as well as all the required

documentation including requirements, mapping, design, implementation and

deployment. Below are all the project details and my role in it.

Job Responsibilities:

* Meeting with business on regular intervals and making sure that all

the requirements are met and providing weekly status update on

progress.

* Also meeting with testing team to make sure that they completely

understand the requirements and design for Audit process.

* Developed Informatica mappings to load staging tables. These staging

tables were source to E-Business Suite (an oracle developed product).

* Extensively used all the Informatica transformations like source

qualifier, expression, router, normalizer, filter and lookups.

* Extensive documentation was created like Design doc, Business

requirement Specifications, Unit Test Results Doc, Deployment plan

etc.

* Also mentored other team developers and tech leads who were new to

Informatica ETL tool.

* Created many mappings, sessions, workflows, source qualifier queries

and many reusable transformations which loaded the data into FDW.

* Created design and maintenance document to help other teams in

understanding this project.

* Provided SIT, UAT and Production support to other teams and developed

good relations with them.

* Use Informatica parameter files for defining mapping variables,

workflow variables, FTP connections and relational connections.

* Interact with the vendor and set up the SFTP connection to the

vendor's ftp site for transferring extracted files.

* Used FTP services to retrieve Flat Files from the external sources and

RDBMS sources.

* Used Exceed and Humming Bird tools to move the files from local

directory to ftp and sftp sites.

* Gather requirements from business and do the initial analysis.

* Provide the Level of Effort (Time to Complete) for ETL development and

unit testing.

* Extensively worked in Mapping Designer, Workflow Manager, Informatica

Monitor and Repository Manager.

* Imported Source and Targets, created XML files for deployment and

deployment plans.

Environment: Powercenter 8.1/8.6, Versioning, Solaris 10, SQL

Developer, Exceed,

Hummingbird FTP Client, SFTP, Clearcase, Clearquest, Peoplesoft 10,

DAC Scheduler,

Hyperion 11, Oracle 10g, SQL Developer, Flat Files, MS-Visio, MS-

Office.

ETL Consultant December 2010 to March 2012

CDPHP, Albany NY

Capital District Physicians Health Plan (CDPHP) is an upstate based

healthcare insurance company which is providing quality coverage and top-

rated health plans to thousands of families for more than 30 years. I

worked there as an ETL/Informatica Developer and was extensively involved

in building the EDW (Enterprise Data Warehouse) from their OLTP Facets

System including some flatfiles from various vendors into centralized

warehouse using ETL tool Informatica.

Job Responsibilities:

. Collection of requirements from business users and analyzed based on

the requirements

. Extensively work in designing and developing complex Informatica mappings

using expressions, aggregators, filters, lookup and source qualifiers to

ensure movement of the data between various applications.

. Involved in creating the business requirement documents, mapping

documents, deployment and implementation plans.

. Create mappings involving various transformations like joiner,

aggregator, lookup, sequence generator, stored procedure, update

strategy, filter and router transformations to implement business

logic

. Extensively use mapplets and worklets to prevent redundancy of

transformation usage and maintainability

. Use different tasks like Session, Command, Decision, Email in the

workflow

. Perform unit and regression testing, troubleshooting and bug fixing in

development and QA environments

. Used source files and scripts using FTP client tools WinSCP and HP

FTP.

. Work on Informatica Debugger to debug the mapping

. Worked with star schema, Type I SCD, Type II SCD, Facts, Dimensions

etc.

. Provide knowledge transfer to the production support team.

. Gather business needs and do the initial analysis.

. Monitored the vendor files on FTP sites to make sure that they are

delivered timely and correctly using standards.

. Provide the Level of Effort (Time to Complete) for ETL development and

unit testing

. Design and develop the ETL process and make sure that data is loaded

into database.

. Create mappings, sessions, workflows, source qualifier queries and

many reusable transformations which loads the data into FDW.

. Provide SIT, UAT and Production support to other teams and develop

good relations with them.

. Play a key role in helping operations support team to understand about

all the FDW process and their functionality.

. Extensively work in Mapping Designer, Workflow Manager, Informatica

Monitor and Repository Manager and mentor other junior developers as

needed.

. Import Sources and Targets from different sources including relational

and non-relational.

. Make sure that new ETL jobs are in the scheduler and validate that

jobs are run as per the schedule.

. Also make sure that users are able to see the as expected else work

with them to resolve reporting or ETL issues.

Environment: Powercenter 8.0/8.1/8.6, Versioning, IBM AIX 5.0, Oracle

10g, SQL Nav, Toad, Putty, HP Reflection, HP FTP Client, FTP, SFTP,

Ultraedit, Admin Console, RTM, IBM Clearquest online tracking tool,

Remedy.

Software Developer June 2007 to September 2010

Matrid Technologies, Chandigarh

Matrid Technologies takes many different projects from various different

clients and build in-house applications specifically designed and developed

as per the requirements. I was involved in designing the front end as well

as in writing the background programming for their clients.

Job Responsibilities:

* Involved in Coding programs, Generating Reports using Data Reports,

User interface design and Class modules using Visual Basic in Budget

and Contract Management system.

* Led a team of designers for designing and developing interactive Web

Sites using Dream weaver, Fireworks, Front Page and Adobe Photoshop.

* Designed and optimized graphics for corporate client sites.

* Coordinated Quality Assurance procedures including testing and

debugging of code.

* Write HTML, JavaScript, Tables, Frames and Graphics.

* Installed Shopping Carts using CGI scripts.

* Administer Internet e-mail accounts for corporate clients.

* Responsible for training staff to provide technical support.

* Lead team of up to 8 junior developers in various projects involving

development, testing, debugging, and maintenance of dynamic and

secure websites and web-based applications, including widgets,

templates, and microsites

* Worked on ASP.NET, JavaScript, AJAX, XML, J2EE, and other front-end

and middle-tier technologies and standards, as well as content

management system.

* Tool care of third-party content integration and migration project

involving architecture, design, implementation, and testing of

integrated web applications on aggressive timeline. Successful project

was completed on time and under budget.

* Worked on technical, design, business, and editorial staff to create

applications and pages.

* Researched industry trends, and assist with development and promotion

of coding best practices within team and industry.

* Developed original e-commerce website and Web applications,

encompassing design, coding, testing, and maintenance for the company.

* Also worked in SQL Server and Oracle database and written SQL/PLSQL

code.

* Designed and developed web applications and user interface for various

municipal departments. Projects ranged from Flash-interactive

microsites to advertisements.

* Mentored interns and managed scheduling on semester-by-semester basis.

* Assisted in software development and customization projects using open

source tools.

* Gathered requirements and specifications for enhancements to websites.

* Built, tested, and implemented user interface applications.

* Assisted with product development projects.

* Integrated UI with large backend applications.

* Aided in writing technical documents for website enhancements and

updates.

* Helped develop and maintain plans and schedules for site redesign and

relaunch.

Environment: MS-Office, VC++ 5.0, VB, Oracle Developer 2000,Microsoft SQL

Server, HTML, DHTML, Adobe Photoshop, Macromedia Flash,TCP/IP, FoxPro,

Windows Operating Systems, Microsoft Access, Microsoft Visual Interdev 6.0,

Front Page 98, DHTML, IIS 4.0, ASP, VB Script, JAVA Script, Macromedia

Dreamweaver 2.0, Oracle 7.x/8.x, Microsoft SQL Server 6.0/6.5/7.0, Teradata

12, Microsoft Access 7.0, DB2,Microsoft Windows 95, NT 3.51/4.0,

Server/Workstation MS - DOS, UNIX.

[pic]

Contact this candidate