Manager Sql Server
Resume:
SAVITA RAJPUT Mobile: 404-***-****
Email:*******.******@*****.*** Informatica ETL Developer
PROFESSIONAL SUMMARY:
Almost 5 years of IT experience in Informatica PowerCenter tool, ETL Tools, DB2, Oracle and
UNIX, data warehouse, database and business intelligence experience.
Four years of experience in Informatica PowerCenter.
•
Nearly One years of experience in Informatica cloud.
•
Worked on all phases of development lifecycle from business requirements analysis,
•
Application Design, Data Modeling, and Development, testing, documentation,
implementation and support.
Exceptional background in analysis, design, development, customization, and
•
implementation and testing of software applications and products.
Demonstrated expertise utilizing ETL tools, Informatica, and RDBM systems like SQL
•
Servers, Oracle, DB2 and SAP database.
Excellent technical and analytical skills with clear understanding of design goals of ER
•
modeling for OLTP and dimension modeling for OLAP.
Team player with excellent communication and problem solving skills.
•
Effective leadership skills with good written and verbal communication, self motivated.
•
Quick learner with excellent communication and presentation skills and has ability to
•
interrelate with people at all levels.
Possess strong work ethic and team spirit.
•
TECHNICAL SKILLS:
ETL Tools Languages
Informatica PowerCenter 9.x/8x SQL, PL/SQL,UNIX shell scripts,
(Source Analyzer, Data Visual Basic 6.0, COBOL, Perl, C,
Warehousing Designer, Mapping C++
Designer), Informatica cloud,
Informatica power exchange
Databases Operating Systems
Oracle 9i/10g, Microsoft SQL Windows 2003 Server, Unix\Linux,
Server 2000/2005, Microsoft Windows 9x/NT/2000/ME/XP
Access, Flat file systems, MYSQL,
Page 1 of 7
SAVITA RAJPUT Mobile: 404-***-****
Email:*******.******@*****.*** Informatica ETL Developer
DB2, SQL*Plus, Microsoft
Access, SAP database
Software
Microsoft Office Suite
CERTIFICATION:
• Have completed following internal Accenture certifications –
BI – DW Concepts
BI – Informatica BI Tools
TRAINING:
Completed Greenfield Training with Accenture in October 2009.
•
Attended Informatica PowerCenter Training program from Accenture.
•
Completed BI DW Concepts training from Accenture.
•
Completed BI Informatica BI Tools training from Accenture.
•
WORK EXPERIENCE:
Nov 2013 – Present
Client – Sallie Mae, Fishers, IN, USA
Project Name OPSYS
Role – Senior Programmer
Sallie Mae is a publicly traded U.S. corporation, whose operations are originating, servicing, and
collecting on student loans. It has different application for each servicing. The OPSYS is an
abbreviation for Private Credit Operational Systems .OPSYS is an Informatica application running
on top of an oracle database. In this application, we extract data from different source systems ( like
Oracle, MS SQL Server, Text Files, DB2 and mainframes) and load it to target database.
Role Descriptions
Responsible for requirement gathering and analysis.
•
Page 2 of 7
SAVITA RAJPUT Mobile: 404-***-****
Email:*******.******@*****.*** Informatica ETL Developer
Responsible for High level and low level technical specification documents.
•
Extracted data from various heterogeneous sources like Oracle, MS SQL Server, DB2, Text
•
Files, Fixed Length EBCDIC datasets,Variable length EBCDIC datasets(through Power
Exchange) and loaded into datamarts using Informatica and power exchange.
Used FTP and secured SFTP for the data transmission Protocols.
•
Extensively used various active and passive transformations like Filter Transformation,
•
Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner
Transformation, and Look up Transformation, Update Strategy Transformation, Sequence
Generator Transformation, Rank Transformation, and Aggregator Transformation.
Responsible for best practices like naming Conventions, Performance tuning, and Error
•
Handling
Solid Expertise in using both Connected and Unconnected Lookup transformations
•
Responsible for implementing Incremental Loading mappings using Mapping Variables and
•
Parameter Files.
Used Update Strategy DD_INSERT, DD_DELETE, DD_UPDATE, DD_REJECT to insert,
•
delete, update and reject the items based on the requirement.
Worked with Session Logs and Workflow Logs for Error handling and Troubleshooting in all
•
environment.
Responsible for converting Dos .bat files to Linux .sh files.
•
Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager), MS
SQL Server, TOAD, SQL, PL/SQL, Windows XP, Linux, Informatica Power exchange
Jan 2012 – Oct 2013
Client Ordusion Global Business Services, GA, USA
Project Name gCurv Enterprise Sustainably Performance Managements
Role Senior Software Programmer
gCurv performance management system aid organizations to develop and implement key
performance metrics that provide business insights, supports operational excellence process, and
contribute to business success. gCurv's affordable cloud based sustainability software platform
provides carbon management centric performance management system that allows simple to
acquire energy and resource data tool. For developing this product real time data from operational
source system was extracted, transformed and loaded into data warehouse Using Informatica
Power Center Tools.
Role Descriptions
Responsible for Requirement Gathering Analysis and End user Meetings
•
Page 3 of 7
SAVITA RAJPUT Mobile: 404-***-****
Email:*******.******@*****.*** Informatica ETL Developer
Responsible for Business Requirement Documents BRD's and converting Functional
•
Requirements into Technical Specifications.
Extracted data from various heterogeneous sources like Oracle, SQL Server, and Flat Files
•
and loaded into datamars using Informatica.
Extensively used various active and passive transformations like Filter Transformation,
•
Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner
Transformation, and Look up Transformation, Update Strategy Transformation, Sequence
Generator Transformation, Rank Transformation, and Aggregator Transformation.
Responsible for best practices like naming Conventions, Performance tuning, and Error
•
Handling
Responsible for maintain data quality and data consistency before loading into ODS.
•
Responsible for Performance Tuning at the Source level, Target level, Mapping Level and
•
Session Level
Solid Expertise in using both Connected and Unconnected Lookup transformations
•
Developed Re usable Transformations, and Re Usable Mapplets
•
Developed mapping for multiple source files load to target using Indirect option.
•
Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
•
Responsible for implementing Incremental Loading mappings using Mapping Variables and
•
Parameter Files
Responsible for determining the bottlenecks and fixing the bottlenecks with performance
•
tuning.
Used Update Strategy DD_INSERT, DD_DELETE, DD_UPDATE, AND DD_REJECT to
•
insert, delete, update and reject the items based on the requirement
Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in all
•
environment
Environment: Informatica Power Center (Repository Manager, Designer, Workflow Manager), MS
SQL Server, TOAD, SQL, PL/SQL, Windows XP, UNIX
April 2011 – Nov 2011
Accenture
Client Devon Energy
Project Name Devon Enterprise Data Warehouse (EDW)
Role Senior Software Programmer
Devon Energy Corporation is a leading independent natural gas and oil exploration and production
company. Devon's operations are focused onshore in the United States and Canada. This project
focuses on creating an enterprise data warehouse for synching and collecting data at one place
Page 4 of 7
SAVITA RAJPUT Mobile: 404-***-****
Email:*******.******@*****.*** Informatica ETL Developer
from the different subsystems to help management with reporting and giving an end to end picture
of the business. The data is collected from SQL Server 2000/2005, SAP database and Oracle
database.
Role Descriptions
Involved in Business Analysis and Requirements collection.
•
Involved in the Dimensional Data Modeling and populating the business rules using
•
mappings into the Repository for Data management
Created and designed source to target mapping for SQL Server, Oracle and SAP database
•
using PowerCenter.
Worked on Informatica PowerCenter 8x tool – Source Analyzer, Data warehousing
•
designer, Mapping Designer, Mapplet & Transformations.
Various kinds of the transformations were used to implement simple and complex business
•
logic. Transformations used were: connected & unconnected lookups, expressions, source
qualifier, aggregators, filters, sequence generator, normalizer etc.
Created and configured workflows, sessions to transport the data to target warehouse
•
Oracle tables using Informatica Workflow Manager.
Mapplets and Reusable Transformations were used to prevent redundancy of
•
transformation usage and maintainability.
Troubleshoot problems by checking sessions and error logs.
•
Generated PL/SQL and Shell scripts for scheduling periodic load processes.
•
Prepared Unit test case documents
•
Have performed Peer Reviews within the project.
•
Environment: Informatica Power Center 8x (Repository Manager, Designer, Workflow Manager),
SQL server 2000, Oracle 9i, Windows 2000, UNIX, TOAD, SAP database.
Nov 2010 March 2011
Accenture
Client name Duke –Energy
Project Name Athena
Role Senior Software Developer
Project Description –
Duke Energy’s mission is to provide reliable, affordable and clean energy to customers. Duke
Energy is developing innovative renewable power projects to serve its own customers as well as
other utilities, businesses and communities throughout the United States. Athena project focuses on
implementing a supported and well documented toolset to support business processes, increase
standardization of load forecasting business processes across the Southeast and Midwest,
Page 5 of 7
SAVITA RAJPUT Mobile: 404-***-****
Email:*******.******@*****.*** Informatica ETL Developer
standardize and improve data management processes (i.e. sources, retrieval, storage, backup and
archival).
Role Description –
• Involved in Business Analysis and Requirements collection.
• Involved in the Dimensional Data Modeling and populating the business rules using
mappings into the Repository for Data management
• Created and designed source to target mapping for SQL Server, Oracle and SAP database
using PowerCenter.
• Worked on Informatica PowerCenter 8x tool – Source Analyzer, Data warehousing
designer, Mapping Designer, Mapplet & Transformations.
• Various kinds of the transformations were used to implement simple and complex business
logic. Transformations used were: connected & unconnected lookups, expressions, source
qualifier, aggregators, filters, sequence generator, normalizer etc.
• Created and configured workflows, sessions to transport the data to target warehouse
Oracle tables using Informatica Workflow Manager.
• Mapplets and Reusable Transformations were used to prevent redundancy of
transformation usage and maintainability.
• Troubleshoot problems by checking sessions and error logs.
• Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Prepared Unit test case documents
• Have performed Peer Reviews within the project.
Environment: Informatica Power Center 8x (Repository Manager, Designer, Workflow Manager),
SQL server 2000, Windows 2000, Flat files.
Nov 2009 – Oct 2010
Accenture
Client Name Dupont
Role Software Developer
Project Description -
DuPont is a large chemical giant based out of Wilmington, Delaware, USA, operating in more than 70 countries
offering a wide range of innovative products and services for markets including agriculture, nutrition,
electronics, communications, safety and protection, home and construction, transportation and apparel.
Role Description –
Extensively worked on Informatica to extract data from flat files and Oracle, and to load the
•
data into the target database.
Page 6 of 7
SAVITA RAJPUT Mobile: 404-***-****
Email:*******.******@*****.*** Informatica ETL Developer
Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as
•
well as the tuning of the sessions.
Scheduled to automate the update processes and Informatica Workflows.
•
Tuned SQL queries for better performance.
•
Used Informatica as a Data Cleansing tool to correct the data before loading into the
•
staging area.
Helped team in understanding the business level requirements and guiding technically to
•
provide good optimized code and resolve the issues quicker than usual.
Environment: Informatica Power Center 8x (Repository Manager, Designer, Workflow
Manager), DB2, Oracle 9i, Windows 2000, UNIX, Shell Scripting, TOAD, SAP database.
August 2009 – October 2009
Accenture GreenField Training – Informatica BI Tools.
Industrial Project Work Experience:
March 2008 April 2009
APT Web Solutions
Developer
Worked on internship project for a company called APT Web Solutions on web project in
VB.NET, ASP.NET, SQL Server.
EDUCATION:
Bachelors of Science with Mathematics & Computer Science, Agra University, India
•
Master of Computer Application, Banasthali University, India
•
Page 7 of 7
Contact this candidate