Saritha Gande
ac8yfs@r.postjobfree.com
Minneapolis, MN
Professional Summary:
* ***** ** ** ********** in different Software applications.
* ***** ** **** ********** with Informatica Power Center and SQL Queries.
Involved in all phases of Data warehousing projects including Requirement Analysis, Development, Unit testing and Implementation for end-to-end IT solution offerings.
Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
Good understanding of Data warehousing concepts.
Proficiency in Data Analysis, handling complex Query building and performance tuning.
Expertise in extracting and analysing data from existing data stores using Power Center and performing ad-hoc queries against warehouse
Using mapplet, reusable transformation and mapping parameter extensively in the mappings.
Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
Experience in Performance Tuning by using Row Transformations, Block and Unblock Transformations.
Creating different types of mappings by using different types of transformations in Informatica.
Have excellent analytical, problem solving, communications, and interpersonal skills with ability to interact with individuals at all levels and ability to lead and take challenges.
To utilize my skills and knowledge to enhance the organization growth as well as my professional growth, this will yield success individually and as a team, to work in a quality driven environment
Believe in Teamwork, Sincerity, Hard work, eager to accept challenging Assignments and ability to work in a fast-paced, collaborative environment.
Technical Skills:
Operating Systems
Windows XP/7/10
Databases
SQL, Oracle, DB2
ETL Tools
Informatica Power Center 9.6
Reporting Tool
SQL Server, MS Office
Other Tools
HP Service Manager, Quality Center
Languages
SQL, C, Cobol, Mainframe
Educational Profile:
Course
Year
College/University
Aggregate
Master Of Pharmacy
2012
University college of pharmaceutical sciences, Kakatiya University
72.5%
Bachelor Of Pharmacy
2010
Vaagdevi institute of pharmaceutical sciences, Warangal
83.3%
Diploma in Pharmacy
2007
Govt. Polytechnic for Women, Warangal
84%
XII
2005
Gems junior college, Karimnagar
88.7%
X
2003
Jawahar Navodaya Vidyalaya, Choppadandi
80%
Project Details:
Project Name
DWH Reporting System
Client
Arvik Systems
Duration
Feb 2012 to Feb 2015
Role
Team Member
Project Specific Skills
Informatica 9.6, Oracle
Location
Hyderabad, India
Project Description:
DWH Reporting System is the storage house of all types of data in Arvik Systems. The data warehouse keeps all the information about the different department. The warehouse system involved with both full loading and incremental loading.
Role and Responsibilities:
Involved in loading data into data warehouse system.
Data Loaded from tables and flat files into target database and cleaned data using appropriate business rules.
Worked on Informatica power center tool-source analyzer, target ware house designer, Mapping designer and workflow manager.
Implemented joiner, expression, aggregator, sorter, rank, lookup and update strategy etc to create different types mappings
Implemented mapping variables and parameters in mappings.
Generated reusable transformations, mapplets and used them extensively in mappings.
Bottleneck handling, unit testing also done.
Use of target load order and constraint base load ordering in this project, created parallel, sequential processing and control flow of data.
Environment: Informatica 9.6, Oracle, SQL server, HP Service Manager, Quality Center and Microsoft Office.