Deepika Madineni

Ph: 404-***-****

g8lz5v@r.postjobfree.com

________________________________________

Experience Summary:

• Total 8+ years of experience in analysis, design, modeling, development, implementation and testing of Client/Server and Data warehouse applications using Oracle, MS SQL server on Windows and UNIX platforms.

• Involved in various projects in analysis and design in Sales, Public Safety, Finance, Pharmaceuticals and Services Industries.

• 6 Years of experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center (8.6/8.1/7.x/6.x/5.x), SSIS 2008/2005, Data Warehouse Builder, Kimball methodology, Autosys, Data Stage, OLTP, OLAP, Business Objects. Experience in Installation, Configuration and Administration of Informatica Power center 7.x/6.x and Power Mart 5.x/6.x Client, Java, Server in Windows and UNIX.

• Experience in developing and monitoring SSIS Packages. Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user funyctions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity. Experience in Change Data Capture (CDC).

• 4 years of Data Analysis experience in User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.

• 4 years of experience in evaluating different OLAP tools like Business Objects XIR2/6.5/5.1 for cross functionality of OLTP and data warehousing applications.

• 6 years of experience with Relational Databases like Oracle 11g/10g/9i/8i, DB2, VSAM, MS SQL Server 2005/2000, SQL Plus and formats like flat-files, COBOL files and XML files.

• Strong technical exposure with good degree or competence in interacting with business users to analyze the business process and requirements, transforming requirements into screens, designing objects, documenting and rolling out the deliverables.

• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts.

• Excellent interpersonal and communication skills, and in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools : Informatica Power Center 8.6/8.1/7.x/6.x/5.x., Informatica

PowerMart 4.7, Power Exchange MQ, Power Connect,

DWB, SSIS 2008/2005/2000, Kimball Methodology, Appworx,

Informatica, metadata manager, Metadata exchange,

Data Profiling, Data Cleansing, Ascential Data stage 7.5/7.5.1/6.0

Data Modeling : Erwin 7.1.2/4.5, Toad, Star Schema, Snowflake Schema.

Reporting Tools : Business Objects XIR2/6.5/5.1

RDBMS : Oracle 10g/9i/8i, DB2, VSAM, Web

log, Teradata V2R5, MS SQL Server, 2005/2000, Analytics,

T-SQL, MS Access, Sybase, SQL Plus.

Languages : PL/SQL, SQL, SRMW, C, C++, C#, VB,

JAVA SCRIPT.

Packages : Microsoft Office 2003/2007.

Operating Systems : UNIX, AIX, DOS, OS/2, Windows NT/95/98/2000/XP/Vista.

EDUCATION:

Bachelor of Technology, JNTU Hyderabad, India `

PROFESSIONAL EXPERIENCE:

Microsoft, Issaquah, WA Feb ’11 – Till Date

Role: ETL Consultant

Project: BI_Velocity

Microsoft is an American public multinational corporation headquartered in Redmond, Washington, USA

that develops, manufactures, licenses, and supports a wide range of products and services predominantly related

to computing through its various product divisions.

Velocity is a platform which offers significant cost reduction by providing Single Operational Data Store

and it distributes large volumes of data at the same time to meet the low latency requirements. This Operational

Data Store (ODS) will allow groups across Microsoft such as MS Operations, IT Operations, Global Market-ing

Organization (GMO) etc. to support online service offerings such as Azure, Office365, Live Meeting, CRM

Online etc. Examples of this include Partner fee payments, Azure customer over usage notifications and Denied

Party List (DPL) screening. Velocity will also provide data for value add activities like customer and predictive

analytics.

Responsibilities:

• Reviewed Functional Requirement Documents (FRD) and Technical Specifications Documents (TSD) and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.

• Used different Data Warehouse techniques like Star-Schema, Snowflake schema.

• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.

• Created Mapplets, reusable transformations and used them in different mappings.

• Involved in designing mappings using Mapping Parameters and Mapping Variables.

• Used Informatica Debugger for debugging mappings.

• Successfully Loaded Data into different targets from various source systems like Flat files, SQL Server into the target database SQL Server and Flat files.

• Created views, functions and stored procedures as per the requirements and debugged them.

• Created Dashboard reports using SSRS and deployed them to Report server.

• Created List Reports , Drill down reports and Chart reports.

• Involved in Unit testing of database objects such as views and Stored procedures.

• Worked with DSL Explorer to create Data packages, corresponding versions, .dsl files getting for schema changes.

• Developed SSIS packages for Full pulls and Delta pulls.

• Worked with Control Flow Tasks, Data Flow Tasks, Execute SQL Tasks, Script Tasks, Sequence Containers and different types of tasks while working with SSIS.

• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which

was extracted from different source systems according to the user requirements.

• Used Informatica Workflow Manager to create workflows.

• Workflow Monitor was used to monitor and run workflows.

• Involved in production support which also includes trouble shooting issues.

• Prepared ETL mapping specification document and Instructions document for Dashboard reports.

• Worked closely with testing team and assisted them in creating test cases.

• Used different Data Warehouse techniques like Star-Schema, Snowflake schema.

• Involved in designing mappings with Mapping Parameters and Mapping Variables.

• Worked with T-SQL queries to load data.

• Tuned SQL queries for better performance.

Environment: Informatica 9.0.1, SQL Server 2008, SSRS 2008, Kimball Methodology, SDLC, Windows 7.0, Beyond Compare 2.0, DSL Explorer, C#, BIDS, Visual Studio 2010(Team Explorer, Solution Explorer).

Multnomah County, Portland, OR April ’10 – Jan ’11

Role: ETL Developer Analyst

Project: DSS Justice

Multnomah County is Oregon’s most populous county with over 710,000 residents. Multnomah County is governed by a Board of four elected Commissioners and one Chair. More than 4,500 Multnomah County employees provide citizens a wide range of health and human services, public safety services and other government services. Assigned as a Developer Analyst to design, develop, and implement the ETL process to load the Products Data Mart, which helped generate Business Intelligence and Performance Management reports for the project DSS Justice.

Responsibilities:

• Performed business Analyst function, overseeing business requirements gathering and business analysis.

• As a Developer Analyst, Participated in Requirement Gathering, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.

• Solid knowledge of entire software development life cycle (SDLC) including analysis, design, development and testing of software applications

• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping & Mapplet Designer and Transformation Designer.

• Designed ETL mapping documents, various mappings with Transformation rules and complex mappings including Slowly Changing Dimensions.

• Worked with various types of transformations like Expression, Joiner, Filter, Sequence Generator, Aggregator, Look up, Update Strategy, Router.

• Used different Data Warehouse techniques like Star-Schema, Snowflake schema.

• Involved in designing mappings with Mapping Parameters and Mapping Variables.

• Designed the mappings with Target Load Planning and Constraint Base Load Ordering.

• Developed reusable business logics in the form of Mapplets and Reusable Transformations.

• Created Sessions, Reusable Worklets with sequential batch and parallel batch in Workflow Manager and scheduled the sessions to run at a specified frequency.

• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.

• Involved in identifying the bottlenecks in mappings and sessions.

• Created views used to pull data from different tables belonging to a new schema designed.

• Involved in Unit Testing and System Testing of the ETL Applications.

• Created Test cases, test scripts and Test plans based on BRDs.

• Provided Knowledge Transfer and created documentation on the design, development, implementation, daily loads and process flow of the mappings.

• Tuned SQL queries for better performance.

• Developed and optimized database structures, stored procedures, views and user-defined functions.

• Ran the job tasks and scheduled jobs using the UNIX scripts.

• Developed SSIS packages using different packages based on business requirements.

• Converted Informatica mappings into SSIS packages.

• Worked with DTS packages.

• Created complex Stored Procedures to create reports.

• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.

• Wrote complex queries and stored procedures to view and test data both in test and production environments.

• Worked with T-SQL queries to load data.

• Worked with SQL Server Reporting Services to create and develop reports.

• Migrated Crystal reports into SSRS.

• Analyzed data using Erwin tool.

• Extracted data from flat files and loaded into Oracle database.

• Fixed invalid Mappings, tested Stored Procedures and Functions.

• Worked on multiple projects simultaneously.

Environment: Informatica 8.1, SSIS 2008, DTS, DWB, Kimball Methodology, SDLC, ERWIN 4.5, Windows NT, Web log, Oracle 10g, SQL, PL/SQL, SQL Developer, XML, ODBC, TCP/IP, SQL Server 2008, SSRS 2008, Crystal Reports 10, Examdiff Pro, Textpad, Autosys, C#, Microsoft Excel, TOAD For Oracle, T-SQL, UNIX Sun Solaris, Oracle 10g, FTP, Analytics, Quality Center 9.0.

Burger King Corporation, Miami, FL Oct ’08 – March ‘10

Role: ETL Developer

Burger King is the second largest fast food hamburger chain in the world. The BURGER KING system operates more than 11,900 restaurants in all 50 states and in 73 countries and US territories worldwide. Approximately 90 percent of BURGER KING Restaurants are owned and operated by independent franchisees, many of them family-owned operations that have been in business for decades.

Responsibilities:

• Requirements gathering and business analysis.

• Participated in the discussions with the business solutions team in creating and implementing the plans for the designs like Flow Chart diagrams, ERD s, Conceptual and Logical Diagrams, and defining the terms on the needs of the project.

• Installed and configured Informatica Server and Power Center. Created Repository and User groups using Repository Manager.

• Developed informatica workflows to load data from various sources to ODS and then to Datamart. Written many logics to process the incoming data and route the erroneous data to the appropriate destinations.

• Wrote complex queries and stored procedures to view and test data both in test and production environments.

• Used different Data Warehouse techniques like Star-Schema, Snowflake schema.

• Involved in admin tasks like analyzing Table Space requirement, load balancing and Performance.

• Created different transformations for loading the data into SQL SERVER 2005 database E.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.

• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.

• Created complex mappings using Unconnected Lookup, Sorter, Source qualifier, Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

• Tuned SQL queries for better performance.

• Worked within a team to populate Type I and Type II slowly changing dimension customer tables from several flat files.

• Done vigorous unit and system testing on both test and production environments.

• Worked closely with QA team during the testing phase and fixed bugs that were reported.

• Worked with end users to define, maintain, implement, their reporting requirements.

• Developed ETL test cases based on testing results.

• Developed reports using Cognos tool.

• Ran the job tasks and scheduled jobs using the UNIX scripts. Used Ksh scripting and also GREP, PIPE, AWK commands.

• Worked with stored procedures, views and functions.

• Wrote many sql queries in the process of data loading.

• Maintained the change Log file and metadata documents for the further reference.

Environment: Informatica PowerCenter 8.6, SSIS 2005, Cognos 8.x,DB2, Kimbal Methodology, Data Stage, JDBC, Windows NT, SQL Server 2005, TOAD For Oracle, T-SQL, ANSI SQL, TOAD for SQL Server, Autosys, Oracle 9i.

Equi First Corporation, Charlotte NC Apr ’07 – Sep ‘08

Role: ETL Consultant

Equi First is one of the premier non-conforming wholesale mortgage lenders in the United States providing innovative mortgage products and fast closings to independent mortgage brokers throughout the country. Assigned as ETL Developer at EquiFirst to design, develop, and implement the ETL process to load the Products Data Mart, which helped generate Business Intelligence and Performance Management reports..

Responsibilities:

• Gathered requirements from Business users.

• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.

• Created complex mappings using Unconnected Lookup, Sorter, Source qualifier, Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.

• Used designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum performance.

• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings.

• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.

• Performed migration of mappings and workflows from Development to Test to perform the integration and system testing and to Production Servers.

• Participated in unit and system test process. Performed troubleshooting and providing resolutions to ETL issues.

• Experience in Application development and support in Production environment for troubleshooting. Give on-call support in production environment.

• Used Debugger wizard to debug the mappings and transformations to improve performance and resolve bottlenecks.

• Worked to build mappings and populate Type I and Type II slowly changing dimension customer tables from several flat files Database.

• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.

• Created Informatica mappings with T-SQL procedures to build business rules to load data.

• Created List Reports and Cross Tab Reports and Drill Through reports.

Environment: Informatica Power Center 8.6, T-SQL, SSIS 2008, SSRS, Inmon Methodology, ORACLE 9i, Business Objects 6.5, Teradata, UNIX Sun Solaris, PERL, MS SQL Server 2008, Web log, Data Stage, XML, ODBC, TCP/IP, Erwin 7.0, Windows XP, PL/SQL, WinSQL, MS excel.

Client : Aramark Uniform & Career Apparel Inc. (Boston, USA) July’06 – March’07

Role: ETL Consultant

ARAMARK Uniform and Career Apparel (AUCA) group is a division of the ARAMARK Corporation, the second largest Management Services Company in the U.S. It manages a wide variety of workplace clothing services from the design and direct marketing of uniforms, casual attire through catalogs, mail order etc. to the regular and laundering of work clothes.

Responsibilites:

• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.

• Analysis, Design and Development, testing and implementation of Informatica transformations and workflows for extracting the data from the multiple sources.

• Developed extraction mappings to load data from Source systems to ODS to Data Warehouse

• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy, Rank and Router transformations.

• Involved in Admin tasks like analyzing table space requirement, load balancing and performance.

• Used Informatica Administrator console for Admin activities such as starting/stopping server, upgrading repository etc.

• Used debugger to test the mapping and fixed the bugs.

• Created Logical and physical data models using ERWIN, for a data mart, to create OLAP reports.

• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.

• Used session partitions, dynamic cache memory, and index cache to improve the performance.

• Documented the mappings used in ETL processes.

• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.

• Wrote SQL, PL/SQL codes, stored procedures and packages.

• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.

• Extracted data from mainframe flat files into Oracle database.

• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.

Environment: Informatica Power Center 8.1, Datastage, Kimball Methodology, Appworx, Mainframes, Oracle 10g, DB2 UDB, MS SQL Server 2005, Teradata V2R5, Web log, UNIX, AIX, XML, Erwin 7.0, Windows NT 4.0, PL/SQL, TOAD for Oracle 9.1.2.

Client: Classic Foods Ltd, San Francisco, CA Oct’04 - June’06

Role: ETL Consultant

Classic Foods Ltd is in the business of manufacturing foods and beverages with factories all over the globe. This has many products with different Flavors and the product sale is through many channels like institutional and Dealership including North America, Africa, Asia Pacific and Europe. The product and sales data is kept at their respective branches and the data is collected from different OLTP systems in the form of Daily/weekly, monthly, quarterly and yearly basis for each sales region, factory or branch and manually collected at the corporate office for aggregating the data as per the report requirement.

Responsibilities:

• As a Member of Data warehousing team, oversaw the design, migration, front-end querying of reporting data

• Developed mappings to populate Reference data tables which provide codes and descriptions for dimension tables in the database.

• Designed Informatica ETL Mappings. Involved in major project to incorporate all corporate data warehouse staging data into a universal data schema.

• Responsible for mapping migration, metadata maintenance and Security using repository manager.

• Worked on Informatica tools –Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformation developer.

• Managed the privileges of users and folders using Repository Manager and used Informatica Administration Console for Admin activities such as starting / stopping server, upgrading the repository.

• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.

• Implemented efficient and effective performance tuning procedures.

• Fixed invalid Mapping’s, tested Stored Procedures and Functions, Unit Testing of Informatica Sessions, Workflows.

• Involved in designing the Worklet with sequential batch and parallel batch.

• Used debugger to test the mapping and fixed the bugs.

• Used session logs to debug sessions.

• Extensively used ETL to load data from flat files (COBOL/XML/excel/access).

• Good Knowledge in writing SQL queries and Tuning of the SQL.

• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.

• Used Cognos for reporting and modeling.

• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions.

Environment: Informatica 8.1, DWB, Appworx, Cognos 8.x, ORACLE 10g, SQL Server 2005, Web log, VSAM, JAVA SCRIPT, DB2, UNIX, AIX, Erwin 7.0, Windows Professional, PL/SQL, Ab Initio, MS Analytics, TOAD for Oracle 9.1.2.

ACCUMED Pharmaceuticals, Lawrenceville, New Jersey Jul ‘03 – Aug‘04

Data warehouse Analyst/Informatica Developer

ACCUMED is involved in the development and manufacturing of over the counter (OTC) products for a variety of gastrointestinal, cold, and oral care needs. Maintaining the data warehouse with all the data regarding the capsule compositions and capsule Name (Product Details), its sales per region.

Responsibilities:

• Worked with Business Analysts team in requirements gathering and preparing Functional specifications and technical specifications.

• Interact with end users and find out the reporting needs.

• Created standard abbreviation document for logical, physical, and dimensional models.

• Document logical, physical, relational and dimensional data models.

• Used Informatica power center for Extraction, Transformation, and Loading. Created mappings, Mapplet, sessions.

• Good knowledge in writing SQL queries for SQL override and tuning them for better performance.

• Created Repository and User groups Using Repository Manager.

• Assigned different permissions to users and user groups as admin.

• Analyzed the Specifications and identifying the source data needs to be moved to data warehouse.

• Used different Data Warehouse techniques like Star-Schema, Snowflake schema.

• Created SQL code from data model and co-ordinate with DBA to create database.

• Developed SQL Server applications, translate data and manage implementation to ensure successful execution of an application.

• Created reusable transformations inside a Mapplet.

• Created Stored Procedures for data transformation and processing business logic in the database

• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner.

• Created, launched & scheduled sessions. Involved in the Performance Tuning of Database and Informatica.

• Involved in the installation, configuration and administration of Informatica and Business Objects.

• Developed the Universes based on the star schema design. Developed complex reports for the Business community.

Environment: Informatica 7.1, Business Objects 6.5, XML, UML, Windows 2000, TOAD For Oracle, Oracle 9i, Sybase, MS SQL Server 2000.

Wipro Technologies, INDIA Jun ‘02 – Jun ‘03

Software Engineer

Wipro Technologies is the No.1 provider of integrated business, technology and process solutions on a global delivery platform. Wipro Technologies is a global services provider delivering technology-driven business solutions that meet the strategic objectives of our clients.

Responsibilities:

• Driving the technical design along with customer team, preparing design specs, functional specs, and other documents.

• Involved in all aspects of software development life cycle. This covers designing, coding, testing, implementing, deploying, and continued support of all projects owned by the team.

• Interact with business users as well as other members of IT outside of the team. Involved in preparation of specifications, development and testing of scripts.

• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.

• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.

• Produced SQL reports, data extraction and data loading scripts for various schemas.

• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.

• Involved in writing various PL/SQL stored procedures, functions and packages.

• Involved in performing extensive Back-End Testing by writing SQL queries to extract the data from SQL Database using Oracle.

Environment: Oracle 8i, Linux, DOS, OS/2, TOAD, SQL, PL/SQL, Software Development Life Cycle.

Contact this candidate