Candidates About

 

Mamta Manuja 

Professional Summary:

Ø  ETL Consultant with 10 years of experience in domains like Health Care, Banking, Financial Services, Healthcare, Manufacturing, Telecommunications and Food Safety. 

Ø  Involved in various phases of IT projects in planning and designing Data Warehouse applications, gathering business requirements, analysis, development, testing and implementation encompassing SDLC and agile methodology.

Ø  Proficient in performance tuning of processes, optimizing database queries, data manipulation and population using SQL, PL/SQL and Utilities in Oracle 10g/11g/12c, Teradata [6.x, 12.x, 13.x, 14.x].

Ø  Designed and developed data marts, tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for extracting data from source system.

Ø  Extracted data from heterogeneous sources like Oracle, SQL Server, Teradata, DB2 and Flat files.

Ø  Interacted with business users to understand the requirements and supporting data quality issues and resolution.

Ø  Experience in creating source to target mapping documents.

Ø  Hands on experience in tuning Informatica ETL mappings using PushDown Optimization, Pipeline Partitioning, Mapping Re-design.

Ø  Sound knowledge of logical and Physical Data Model design process in Star Schema and Snowflake Schema, 3NF.

Ø  Well versed and worked on models implementing slowly changing dimensions i.e. type 1, 2 and 3.

Ø  Working knowledge of Data Modelling Tools like Power designer and Erwin.

Ø  Well versed in UNIX shell scripting, scheduling cron jobs. Developed Bourne/Korn shell scripts to support ETL process and to achieve various automation tasks.

Ø  Proficient in architectural diagrams, logic flowcharts, data maps, maintenance and operation support processes, detailed documentation of the technical design, unit test cases and test data creation.

Ø  Strong communication, presentation and interpersonal skills with excellent problem solving capabilities, manage multiple tasks.

Ø  Support various teams for business technical requests and manage new change requests apart from ongoing operation job monitoring and quick fixes.

Ø  Experience in offshore/onsite model with operation and on call support.

Technical Skills

Databases	Teradata 14.x, Oracle 10g/11g/12c, Sybase, SQL Server
ETL	Informatica 9.1/9.6, PowerExchange, Data Stage 7.5
BI/APPLICATION/Tools	SAP Business Objects, Hyperion, HP Quality Center 10
Languages	SQL, PL/SQL, BASE SAS 9, Java
Operating System	UNIX,LINUX, Windows
Data Modeling	ERWIN 7.3, Power Designer 16.5

Certifications:

·         Advanced Teradata Certified Professional V2R5 - 2009

·         Sun Certified Java Professional - 2005

Education:

·         BS in Engineering (Electronics and Telecommunication)

 

Professional Experience:

NATIONAL INSTITUTE OF HEALTH (NIH): Bethesda                                                                                Jul 2014 – Present
Senior Operations Analyst

NATIONAL INSTITUTE OF HEALTH (NIH): The NVISION data warehouse is an integrated system that pulls data from various institute centers like Clinical center, Cancer research, Lung and Heart Institute etc. The database resides in Oracle and sources its information from other databases like SQL Server, Oracle, Flat Files and Web Services.

·         Worked with the Business Analyst to understand the requirements and convert it into technical solution Created variety of documents per the standards of organization.

·         Assisted DBA’s in trouble shooting when comes to performance optimization, suggested creating indexes to improve performance.

• Created ETL design documents and mapping between source and target including transformations.
• Developed PL/SQL procedures, Functions, Triggers and Packages to implement the changes in different modules.
• Developed PL/SQL packages for generating various feeds from Oracle database using UTL_FILE utility in the client's secure data transmission server.
• Performed monitoring of ETL extraction routine and implemented a new design saving execution time from 8 hours to 2 hours.
• Developed views and materialized views which require complex joins and optimized the existing queries.

·         Developed variety of Informatica ETL mappings sourcing its information from the Databases, Flat Files & Web services. Used transformations like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy, Joiner, SQL Transformation, Procedure, XML Transformation.

·         Build mappings to pull and process data from the internal webservice.

·         Worked on tuning the existing ETL mappings to reduce the load window and bring it within the SLA provided by customer.  Implemented ETL tuning techniques like Pushdown Optimization, Partition Methods, SQL override, re-design of the existing mapping /Workflow.

·         Created/modified Oracle packages and procedures for CRs.  Modified exception handling routine making use of autonomous transactions.

·         Optimized oracle queries by analyzing explain plan and using hints wherever necessary.

·         Wrote variety of Oracle stored procedures and packages to assist the ETL process that involved web services call using SOAP, extensively used oracle tuning techniques like FORALL, bulk collect and materialized views.

·         Assisted Team lead in the Physical data modelling for the new enhancements in existing system

·         Modified the existing Unix Shell Scripts to incorporate the changes per the new requirements.

 

Tools/Utilities:  Informatica 9.1, SQL Server 2008, Oracle 11g, SAS 9,Linux, Unix, Power Designer, BCP utility, VB Script

 

 

US Department of Agriculture (USDA), DC -                                                                                        Mar 2013 – Jun 2014
Senior ETL Consultant

FOOD SAFETY & INSPECTION SERVICE (FSIS) department requires their 10 Systems from different databases like Sybase, SQL Server and ACCESS to be migrated/forklifted to Teradata Database for reporting purpose. Source System has variety of data like Unicode, xml, large data which is being successfully migrated to Teradata using TPT.

·         Involved in various aspects of s/w developmental activities needed as a part of Forklift project like design, build, testing and implementation.

·         Converted Oracle/Sybase/SQL Server DDLs to Teradata DDLs using data Modeling Tool like Power designer along with the use of VB scripts.

·         Performed variety of automation activities using Unix Shell Scripts for eg. generated Teradata Load scripts.

·         Designed and Created Database objects and Written PL/SQL for data extraction and transformation. 

·         Exported data from SQL Server and Sybase using BCP methodology.

·         Written appropriate code in conversion as per the requirement using TPT Scripts & Access Module and loaded data into Teradata.

·         Assisted in building the Teradata Environment for all the source systems that includes creating various Database objects, users, roles, imposing security on the data.

·         Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, updates strategy, lookup, sorter, Normalizer, sequence generator etc.

·         Worked on XSD and XML files generation through ETL processes.

·         Worked with Power Exchange Navigator to import the source tables from Mainframe DB2 and perform masking and update the respective Source tables.

·         Involved in the initial Capacity Planning of various Databases.

·         UNIX shell Scripts are created to automate the FTP processes for receiving and sending the files.

·         Converted Sybase SQL Code to Teradata SQL Code and applied Teradata provided optimization techniques to fine tune the same.

·         Involved in analysis and development of PL/SQL packages, stored procedures, functions and triggers.

·         Identified appropriate indexes, Performed Collect Stats diagnosis in order to provide optimized solution to Users.

·         Helped SAS users to generate reports from Teradata Database.

Tools/Utilities: Teradata SQL Assistant, Teradata Parallel Transport, Informatica 9.1, SAS 9,Linux, Unix, Power Designer, BCP utility, VB Script

 

JP Morgan Chase, Columbus, OH                                                                                                                 Nov 2011 - Oct 2012
Senior Informatica Developer

JP Morgan Chase launched IDR (Interim Data Repository) for analyzing the data that was fetched from various sources.  Once the data is rationalized by development team, business analysts evaluate the need and/or enhancement of new initiatives so as to bring in more value to business in long term.

·         Analyzed the business requirements and functional specifications

·         Used Informatica Power Center 9.1 for extraction, transformation and load (ETL) of data in the data warehouse. Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Filters, Expressions and Lookup, Update strategy and Sequence generator and Stored Procedure.

·         Parameterized the mappings and increased the re-usability.

·         Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation. 

·         Designed mappings/sessions to support easy restartability.

·         Designed mapping document, which is a guideline for ETL Coding following Standards for naming conventions and Best Practices were followed in mapping development.

·         Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations. 

·         Involved in promoting the folders (Using Folder Deployment, Export/Import features) from Development to Test and Test to Production Environment. 

·         Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.

·         Imported the source definition into source analyzer from oracle and for DB2, VSAM files used Informatica PowerExchange in the source analyzer.

·         Processed EBCDIC and ASCII file in Informatica Data Transformation

·         Troubleshooting & fixing the existing Teradata TPT load scripts.

·         Optimized the existing Teradata views and SQL queries.

·         Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the run time.

·         Sound Experience with Informatica Performance Tuning Options like Partitions, Optimizations.

·         Good exposure on UNIX shell scripts to invoke Oracle PL/SQL stored procedures, scheduling extract jobs, email notifications for job completion/abort status.

Tools/Utilities: Informatica 8.6, Informatica PowerExchange 8.6, Teradata SQL Assistant, BTEQ, MultiLoad, Fast Load, Teradata Parallel Transport, Oracle 10g, UNIX.

 

JP Morgan Chase, Wilmington, DE-                                                                                                             Jun 2010 – Oct 2011
ETL Lead (Migration from Oracle to Teradata)

The ADS data warehouse environment provides data to a number of financial applications which include credit cards information, reporting and analysis based upon the data collected from various systems of record. The ADS Re-platform project’s objective was to convert the ADS infrastructure and functionality which was resident on Oracle 10g to migrate to Teradata v13.0 RDBMS.

·         Involved in the physical design and creation of ETL Technical Design Document.

·         Converted Oracle packages to Teradata Stored Procedures.

·         Worked on Oracle PL/SQL packages to generate the flat files that are consumed by Informatica to load data into DW.

·         Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. 

·         Modified the existing ETL mappings and sessions in informatica to be able to load into Teradata.

·         Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.

·         Extensively worked under the UNIX Environment using Shell Scripts.

·         Developed strategies for Testing Team to perform data validation and data integrity check.

·         Interaction with the offshore team on a daily basis on the development activities.

Tools/Utilities: Informatica 8.6, Oracle 10g, Toad, Teradata SQL Assistant/Administrator, AIX UNIX, BTEQ, MultiLoad, FastLoad, Maestro Scheduler, HP Quality Center.

 

Amgen, Washington DC                                                                                                                                  Apr 2009 – May 2010
Teradata DI Consultant

Amgen is leader in biotechnology that develops, manufactures and delivers innovative human therapeutics.  The project aims at analyzing data from various health centers and hospitals so as to provide maximum benefits to people with minimal healthcare expenses.

·         Developed complex and highly-optimized SQLs looking up at core EDW in Third Normal Form to output at demoralized data mart requirements

·         Create and execute test plans for Unit, Integration, and System test phases

·         Worked closely with Project Managers, Business Analysts, BI Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements

·         Handled Source to Target Data Mapping, Technical Specs documentation, and ETL documentations such as Data Profiling, Data Mapping, and Programmer Specs conforming to internal guidelines

·         Developed UNIX shell scripts.

·         Assisted SIT/UAT testers in optimizing testing scripts and to ensure data accuracy and integrity.

·         Extensively worked on data Extraction, Transformation and loading from source to target system using Bteq, FastLoad and MultiLoad and Informatica.

·         Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (Oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.

·         Involved in writing scripts for loading data to target data Warehouse for Bteq, FastLoad and MultiLoad.

·         Did error handling and performance tuning in Teradata queries and utilities.

·         Involved in unit testing and preparing test cases. Involved in manual & functional testing and peer reviews.

Tools/Utilities: Teradata, SQL Assistant, Business Objects, AIX UNIX, BTEQ, MultiLoad, FastLoad,Informatica.

Bell Communications, Canada                                                                                                                   Mar 2008 to Mar 2009
Teradata DI Consultant

Bell Comm. is Canada's largest communications company, providing a comprehensive and innovative suite of broadband communication services to residential and business customers in Canada.

·         Analyzed business requirements, transformed data, and mapped source data from the source system to the Teradata Physical Data Model.

·         Developed Teradata Stored Procedures to load data from 3NF schema to Start Schema.

·         Worked with Teradata PMON, Teradata Admin and Teradata Manager to monitor the performance and tuned SQLs to help improve performance.

·         Optimizing Query Performance, Session Performance and Reliability.

·         Perform testing activities, verify & validate compiled data.

·         Understanding Business needs and implementing the same into a functional database design.

·         Worked closely with business analyst and analyze source data to develop the transformation logic.

·         Involved in unit testing and preparing test cases. Involved in manual & functional testing and peer reviews.

Tools/Utilities:  Teradata SQL Assistant, Teradata Manager, PMON, Teradata SQL Assistant, Teradata Administrator, Teradata Utilities (BTEQ, FastLoad, FastExport, MultiLoad Update/Insert/Delete/Upsert), ERwin Data Modeler.

 

Free scale Inc, Phoenix, AZ                                                                                                                           Oct 2006 to Feb 2008
Production Support Personnel

Free scale was experiencing performance issues due to huge data residing in Oracle DB.  So they initiated migration project from Oracle to Teradata.  The database and reporting tool were migrated to Teradata and Hyperion 9.2.  All major objects like ETL jobs and reports were also migrated to enhance performance.

·         Acquired knowledge on Teradata SQL Assistant, Teradata Administrator and Performance Monitor (PMON).

·         Involved in writing extraction scripts using SQL, BTEQ, Fast Export scripts.

·         Create and drop Databases, Profiles, Roles, Tables, Views, Indexes (Primary, Secondary, partitioned etc.), Triggers, Macros and stored procedures.

·         Data loading to Teradata tables using Fast load and Multi load scripts.

·         Created simple Data stage jobs.

·         Supported reporting tool like Brio & Hyperion.

·         Created Physical data model using Erwin Data modeling tool.

·         Provided 24/7 on call Prod support.

·         Scheduling and Monitoring of Jobs using Maestro Scheduler.

·         Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues, enhanced SQLs for performance tuning.

·         Rolled out documentation for the ETL Process and Data Profiling.

·         Supported the production implementation of the data warehouse, monitored jobs & fixed failed scripts

·         Supported throughout the lifecycle of project and was involved in Migration from Oracle to Teradata

Tools/Utilities: Oracle 10g, TOAD, DataStage 7.5, Teradata SQL Assistant, Teradata Administrator, Teradata Utilities (BTEQ, FastLoad, FastExport, MultiLoad Update/Insert/Delete/Upsert), ERwin Data Modeler, Maestro Job Scheduler,  Hyperion 9.2

 

Free scale Inc, Phoenix, AZ -                                                                                                                           Apr 2005 – Sep 2006
SAS Data log Developer

·         Converted SAS/STAT code into SAS/BASE to reduce SAS license cost.

·         Impact / Requirement Analysis of Service type request.

·         Preparation of detailed program specifications.

·         Coding and Unit Testing.

Tools/Utilities: Base SAS, SAS/AF, SAS/GRAPH, SAS/STAT, SAS/QC.