Candidates About

 

Shruthi Molagavalli

Professional Summary:

• 7+ years in the information technology and wide range of experience in Software development, Project management, Data Integration, Master Data Management(MDM) andInformatica Data Quality(IDQ).
• Strong Data warehousing experience using Informatica Power Center 10.1/ 9.6/9.0/8.6/8.0/7 (Source

Analyzer, Repository Manager, Mapping Designer, Mapplets, Transformations, Workflow Manager, Task Developer),IDQ 10.1/9.5, Power Connect for ETL, OLTP, OLAP, Data Mining, scheduling tool.Worked with heterogeneous source systems like flat files, RDBMS, DWH, parameterizing variables.

·         Involved in driving complex discussions with business analyst and systems architect to determine the solution.

·         Worked on deployment document preparation and assistance to deployment team while migration.

·         Converted the business rules into technical specifications for ETL process for populating Fact and Dimension table of data warehouse.

·         Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.

·         Data modelling knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques.

·         Created mappings for various sources like DB2, Oracle, and flat files to load and integrate details to warehouse.

·         Installing and Configuring of Informatica MDM Hub Console, Hub Store, Cleanse and Match Server, Address Doctor, Informatica Power Center applications.

·         Scheduled jobs and automated the workload using the Autosys Job Scheduler, Control-M Job Scheduler and Informatica Scheduler.

·         Strong Knowledge of Hadoop and Hive and Hive's analytical functions.

·         Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM  Hub implementation.

·         Created IDQ mappings to make data standardized and validated.

·         Expertise in Data Warehousing with variety of Data manipulating skills like Data Migration, Data Modeling, Data Profiling, Data Cleansing and Data Validation.

·         Worked on Oracle PL/SQL programming, Stored Procedures, Creating Triggers and Sequence Generator on the Target Table.

·         Worked in a production support role of processing daily, weekly and monthly loads in datastage based upon the business requirements.

·         Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling

·         Scheduled the ETL jobs daily. Weekly and monthly based on the business requirement in Autosys.

·         Experience in integration of Heterogeneous data sources like Oracle, SQL Server 2005/2008, DB2,XML Files, Flat Files  into staging area as well as from homogenous sources.

·         Performed Unit testing for the mappings developed.

·         Scheduled jobs and automated the workload using the Autosys Job Scheduler, Control-M Job Scheduler and Informatica Scheduler.

·         Experience in Dimensional Modeling (Erwin), Star / Snowflake Schema, Fact / Dimension Tables, Business Process Analysis, Production support, Data cleansing, Data analysis and Performance tuning of sources, targets, mappings sessions and SQL’s.

·         Worked on AS400 system (Main frame files).

·         Cleansed, labeled and fix data gaps with IDQ.

·         Experienced in UNIX work environment, File Transfers, Job Scheduling and Error Handling.

·         Scheduled sessions and batches on the Informatica server using Informatica Workflow manager.

·         Performed application systems development tasks which include working with users to define system needs, analyzing, designing and developing applications to meet user needs.

·         Provided technical support for very complex, highly critical mapping designs. Plan and coordinate tests, resolve production problems, identify opportunities to improve the performance.

·         Tuned the Performance for ETL jobs by tuning the SQL used in Transformations and fine-tuning the database.

·         Determined alternate solutions with risk analysis and identified opportunities to improve availability and advance business initiatives.

·         Hands on experience in resolving the production issues in 24/7 environment.

·         Worked on deploying the product in development environment and exposing the application to rigorous testing via functional, performance and user acceptance testing in test environments.

·         Reviewed the code developed by co-team members.

·         Experience with Sales, Retail, HealthCare, Financial and Banking Domains.

 

TECHNICAL SKILLS:

Data Warehousing:      Informatica Power Center 10.1/9.6/9.5/9.0/8.6,Informatica Analyst, OLAP, OLTP, ETL,Autosys,

                                         Tidal, Informatica Data Quality 10.1/9.5,Data Cleansing, Data Profiling.

Tools & Utilities:       Informatica PowerCenter, Informatica MDM, Informatica Data Director(IDD),SAP Business Objects, Toad, Autosys,Control-  M,Putty, Datastage,SQL Developer, Tableau, Qlikview,Tidal,SERVICE NOW,AWS,Hadoop2.0,Hive 2.0

Databases:                     Teradata, Oracle 11g/10g/9i, MS SQL Server 2008/2005

Operating Systems:      Linux, UNIX, Windows, Sun Solaris 2.x,AS400

Languages/Web:           SQL, PL/SQL, UNIX,C, JAVA,PERL

 

Education:

• Bachelors of Engineering from Jawaharlal Nehru Technological University, India.

 

 

 

 

Professional Experience:

 

Bank of America ,Newyork , NY                                                                                                                                                                          Jul’16-Till Date

Description: Bank of America is an American multinational banking and financial services corporation .BOA Reg W Team focused on dealing with increased Reg W requirements. Help existing resources in ongoing reviews of business activity. Provide guidance on enhancing current processes and procedures to manage Reg W exposure within the Equities.

Tools:                                    Informatica10.1/9.5.1,InformaticaDataQuality10.1/9.5,Toad,Autosys,InformaticaMDM, Informatica Data Director(IDD),Tableau,AWS

Operating system:          Windows XP/Win 7/Win 8, LINUX and UNIX.

Database:                            Oracle 9i, Oracle 10g,Teradata

Responsibilities:

 

• Gathering requirements from the Data Modelers and understanding the design from the technical analysis provided.
•  Analyzing the technical documentation and concluding the design of the ETL loads.
• Extracting the data from the Relational Databases, Flat files using ETL process.
• Triggering the various scripts for Validating and forwarding the source flat files for extraction.
• Developing the ETL mappings according to the loads for Stage and Reporting.
• Worked on data profiling & various data quality rules development using Informatica Data Quality.
• Building mappings, workflows in a cost effective manner.
• Worked on all phases of data warehouse development life-cycle, ETL design and implementation, and support of new and existing applications.
• Designed Hive tables to load data to and from external files.
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, reporting and monitoring capabilities.
• Involved in analyzing business requirements and translating requirements into functional and technical design specifications.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Worked on building Hive and mapreduce scripts.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping.
• Designed data architecture for the project with cloud computing environment using Amazon Web Services AWS for hosting the databases.
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
•  Worked on data cleansing and standardization using Cleanse Adapter’s in Informatica MDM.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Support true ad hoc query by having predictable and consistent query performance for all queries and no requirement for known query workloads or precomputation of aggregates or summaries using tableau.
• Captured data error records corrected and loaded into target system.
• Implemented efficient and effective performance tuning procedures.
• Used Address validator transformation in IDQ and passed the partial address and populated the full address in the target table.
• Resolving performance issues by understanding the bottles necks at various levels and tuning them for better performance.
• Resolving productions issues for any scheduled jobs failures and reporting issues to the concerned teams.
• Documenting the Cut over plans, Design documents and Run books for the Production support teams.

 

Target Retail Store, Minneapolis, MN

Minneapolis, MN                                                                                                                                                         Dec’15-Jul’16

Informatica Developer

Description: Target Corporation is the discount retailer which carries hard lines, soft lines (clothing), and groceries, mostly non-perishable. The development of data warehouse is inextricably linked to the business needs of an enterprise. Target has a need for analytical data warehouse to improve the decision making. The data warehousing project for this organization involve source data from different departments like finance, sales and marketing. Currently we have been involved in this project, with consolidating the company’s data from different operational sources, data marts and then transforming and loading it into a centralized data warehouse for various strategic business reports.

Tools:                                    Informatica 9.5.1, Toad, Informatica Data Quality, Autosys,Qlikview

Operating system:          Windows XP/Win 7/Win 8, LINUX and UNIX,AS400

Database:                            SQL Server, Oracle,Teradata

Responsibilities:

• Extracting the data from the Relational Databases, Flat files using ETL process.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• Thorough Validation on source data and the load in the dimension and fact tables.
• Developed new Informatica mappings and workflows based on specifications.
• Extensively used XML transformation to generate target XML files.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Implemented Type 2 Slowly Changing Dimensions to maintain the historical data in sales Data mart as per the business requirements.
• Worked on development of metric dashboards via Tableau data at varying levels of complexity.
• Created IDQ mappings to make data standardized and validated.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
•  Worked on migration of master data present in Vendor Master,Location/Stores and pricing files  from legacy AS400 system.
• Cleansed, labeled and fix data gaps with IDQ.
• Design and build Qlikview business intelligence data models and user interfaces. 
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Building mappings, workflows in a cost effective manner.
• Worked on all phases of data warehouse development life-cycle, ETL design and implementation, and support of new and existing applications.
• Involved in analyzing business requirements and translating requirements into functional and technical design specifications
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Captured data error records corrected and loaded into target system.
• Implemented efficient and effective performance tuning procedures.

 

Medwin Group, Kinnelon, NJ                                                                                                                          May’15           -Dec’15                                                                                 

Informatica Developer

Description: Healthcare Data Mart was developed for Medwin Healthcare to project their Services, Goals, available resources and suggestions. It provides a report of the current and future financial situation/needs based on the information received from the Data Warehouse

Tools:                                    Informatica 9.5.1, Toad, Autosys

Operating system:          Windows XP/Win 7/Win 8, LINUX and UNIX.

Database:                            SQL Server, Oracle

Responsibilities:

·         Understanding business needs and implement the same into a functional database design.

·          Participated in requirements gathering.

·         Involved in all the phases of SDLC.

·         Developed new Informatica mappings and workflows based on specifications.

·          Developed Batch Processing, Source and Target Reconciliation.

·          Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, and Update Strategy. Developed various Ad-hoc mappings for various business needs.

·         Performed extraction, transformation and loading of data from RDBMS tables, Flat Files into Oracle in accordance with requirements and specifications.

·         Experience in using Normalizer transformation for normalizing the XML source data.

·         Extensively used XML Parser transformation to generate target XML files.

·          Developed and tested all the backend programs, Error Handling Strategies and update processes.

·         Provided technical support for very complex, highly critical mapping designs. Plan and coordinate tests, to resolve production issues.

·         Developed UNIX Shellscripts to automate applications, Schedule jobs,develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.

·         Involved in  Analyzing Source system and designing low level design for the mappings.

·         Involved Data loading Sequence and Populated Data into Staging area and Warehouse with Business Rules.

·         Developing the transformation logic, Identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.

·         Involved in the Development of Informatica mappings and also tuned them for better performance.

·         Fixed invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.

·         Implement performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.

·         Used most of the Transformations such as Source Qualifier, Joiner, Expression, Aggregator, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator while designing mappings.

·         Prepared Unit test cases for the mappings.        

 

Marks and Spencer, Chennai, India                                                                                                                         Nov’12-May’15                                            

Informatica Developer

Description: Marks and Spencer is a major British multinational retailer which specializes in the selling of clothing, home products and luxury food products. Marks & Spencer was having its data (Product, Customer and Sales information) in Legacy systems and was difficult to integrate product customer and sales data across different databases to get a holistic view of its business. To accomplish this task the company integrated relational and non-relational data across different business units into enterprise Data Warehouse, where managers across the company can access a single repository for customer and sales information and perform ad-hoc analysis and generate analytic reports.

Tools:                                    Informatica 8.6.1, SQL Developer, Control-M, Informatica MDM,Tidal

Operating system:          Windows XP/Win 7/Win 8, LINUX and UNIX.

Database:                            SQL Server, Oracle

Responsibilities:

• Involved in analyzing business requirements and translating requirements into functional and technical design specifications.
• Created different Transformations for loading the data into target like Source Qualifier, joiner transformation, Update Strategy, Lookup transformation, Rank transformations, Expressions, Aggregator and Sequence Generator.

·         Worked with Power Center- Designer tool in developing mappings and Mapplets to extract product, customer and sales and load the data from flat files and load to the Data Warehouse.

·         Determine alternate solutions with risk analysis and identified opportunities to improve availability and advance business initiatives.

·         Worked on scheduling jobs using tidal Scheduling tool.

·         Worked on Informatica MDM Hub configurations  - Data modelling  & Data Mappings (Landing , staging and Base Objects) , Data validation , Match and Merge rules , writing and customizing user exits.

·         Created reusable transformations and Mapplet to use in multiple mappings.

·         Used Informatica repository manager to backup and migrate metadata in development, test and production environments.

·         Used various lookup caches like Static, Dynamic, and Persistent in Lookup transformation to identify by the incremental data relevant ETL process.

·         Created mappings for various sources like DB2, Oracle, and flat files to load and integrate details to warehouse.

·         Created staging tables to do validations against data before loading data into original fact and dimension tables.

·         Tuned the Performance for ETL jobs by tuning the SQL used in Transformations and fine-tuning the database.

·         Scheduled the ETL jobs daily. Weekly and monthly based on the business requirement in Autosys.

 

GE Capital, Hyderabad, India                                                                                                                         Jun’11-Nov’12

Description: GE Capital is a leading global financial services business. It offers a wide range of financial products and services to more than 100 million consumers, retailers and commercial customers around the globe including health care, manufacturing,fleetmanagement,communications,construction,energy,aviation, infrastructure and equipment, as well as many others. Sales Datamart is being used to provide BI capabilities.

Tools:                                    Informatica 8.1.1, SQL Developer, Control-M

Operating system:          Windows XP/Win 7, LINUX and UNIX.

Database:                            SQL Server , Oracle 

Responsibilities:

·         Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.

·         Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.

·         Involved into source code review, the mappings created by my team members.

·         Involved in deployment document and assisted to deployment team while migration.

·         Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions.

·         Creating Unit test cases for the Informatica mappings.

·         Developed the automated and scheduled load processes using Control-m scheduler.

·         Created Folders using Informatica PowerCenter Repository Manager to store Source, Target, Transformations,

Mapplets and Mappings Meta Data Information..

·         Implemented Type 2 Slowly Changing Dimensions to maintain the historical data in Data mart as per the business requirements.

<