Manju Yadav

518-***-**** ● acsk34@r.postjobfree.com

PERSONAL SUMMARY: A highly motivated/self starter person who has a sense of ownership, willingness to learn, high degree of curiosity and desire to succeed with excellent organizational skills, has a good eye for detail. Quick learner with 5 years of experience in full lifecycle activities that include requirements analysis, design and development analysis and quality control plans to identify continuous improvements.

Currently looking for a suitable data analyst position for a company with opportunities to grow.

KEY QUALIFICATIONS

• 5 years of experience in Data warehousing and Informatica Development including Analysis, Design, Development, Implementation and Production Support.

• Proficiency in utilizing ETL tool Informatica Power Center 9.1/8.x for developing the Data warehouse loads with work experience focused in Data Integration as per client requirement.

• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager.

• Strong Experience in creating complex mapping using various Transformations such as Aggregator, Expression, Ranking, Router, Lookup, Filter, Joiner, Update Strategy transformations.

• Knowledge in Data warehousing methodology and its concepts.

• Experience in writing complex SQL queries involving multiple tables inner and outer joins.

• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications

• Effectively prepared and published various performance reports and presentations

• Strong numerical, interpretative, analytical and diagnostic skills

• Proven aptitude to use analytical and reporting tools

• Demonstrated ability to administer and recognize customers’ requirements and able find and procedure company data to hold up business decisions

• Able to deal effectively with unclear situations in short time frames

PROFESSIONAL EXPERIENCE

Company Name: m-AdCall Indore India (2013-2014)

Role: Informatica Developer

Responsibilities:

• Attend meetings and gathered business requirements.

• Develop Mapplets using corresponding Source, Targets and Transformations.

• Tune Informatica Mappings and Sessions for optimum performance.

• Solely responsible for IMS Data and converting those to require structure using Informatica.

• Develop and tune all the Affiliations received from IMS and other data sources using Informatica and

• Tested with high volume of data.

• Name containing duplicate rows which are deleted using aggregator.

• Use power exchange CDC which captures changes in the sources and loads those changes into the customer dimension.

• Assist in writing project documentation used Microsoft Visio for different diagrams.

Environment:

Informatica Power Center 8.6 (Repository Manger, Designer, Server Manager, Workflow Monitor, Workflow Manager), Power Exchange, Flat files, XML Files, Oracle 11g/10g, MS SQL, PL/SQL, Excel and Unix scripting, Windows 2007.

Company Name: Tata International Limited – Indore, India (2007-2011)

Role: Informatica Developer

Responsibilities:

• Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system.

• Created Tables, Indexes, Views, Triggers in Development and reviewed them with Data Architect.

• Performing data validation and cleansing the data before being loaded to the target tables

• Worked on Informatica PowerCenter tools-Designer (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets & Transformations), Repository Manager, Workflow Manager & Workflow Monitor

• Used Lookup, Aggregator, Joiner, Union, Expression, Filter, Update strategy, Sql and Normalizer, Router, Source Qualifier transformations to model various standardized business processes and implement business logic using Informatica

• Created Mapplets for loading reusable control table, configured tasks, workflows using workflow manager

• Created Workflow and Tasks to schedule the loads at required frequency using Workflow Manager, Workflow Monitor for the whole process

• Developed complex mappings using Lookups connected and unconnected, Rank, Sorter, Joiner, Aggregator, Filter, Router transformations to transform the data as per the target requirements

• Used Indexes in PL/SQL Packages in order to increase the performance

Environment:

Oracle 11g, Informatica Power Centre 9.1 (Informatica Designer, Repository Manager, Workflow manager, Workflow monitor), UNIX, Tools: Toad, MS-Visio and Microsoft office suite

Relevant Skills:

• Profound ability to guide and lead multi-disciplinary teams; Sales, Finance, Operations, Network Planning, Engineering, Project Management, Purchasing, Help Desk, Legal, and Regulatory Matters.

• Outstanding interpersonal and cooperation skills

• Excellent presentation, written and oral communication skills

• Team player and rapid learner with the aptitude to work in a fast paced environment

• Ability to prioritize and run multiple tasks simultaneously

COMPUTER EXPERTISE

Languages SQL, PL/SQL

RDBMS Oracle,MS Access, SQL Server

ETL Informatica Power Center Informatica Designer, OLTP, OLAP

Operating Systems Window, Unix, SAP PP, MM

MS Excel, Power point, Crystal Report

Experience with Data Warehousing

EDUCATION

SGSITS Institute of Technology, Indore, India

Bachelor’s degree in Electrical Engineering

Contact this candidate