Data Manager

Raghuveer

*********@*******.***, 508-***-****

PROFESSIONAL SUMMARY

* + years of IT industry with substantial experience in providing information management consulting services on Informatica Power Center, Data Integration, Business Intelligence Applications, and Decision-making Support Systems.

Proven Ability in various phases of Data Warehousing and Business Intelligence Lifecycle including Requirement gathering, Analysis, Design, development, Performance Tuning, enhancement, and deep technical support of ETLs and building the Enterprise Reporting architecture.

Excellent experience working with software design, various technologies like Data Warehousing, UML (Use Case, Activity, State Chart, and Class Diagram), Business Intelligence, Data Marts concepts.

Extensively worked on data warehousing tools including ETL process using different components of Informatica Power Center like Designer, Workflow Manager, Workflow Monitor and Repository Manager. Oracle 9.x/8.x/7.x, MS Access ’97/2000.

Excellent knowledge of Data Warehouse Architecture, Star Schema, Snowflake Schema, Fact & Dimensional tables.

Extensively worked with Informatica Designer to create mappings using Expression, Router, Lookup (Connected and Unconnected), Source Qualifier, Aggregator, expression, Update Strategy, and other transformations.

Experience in full life cycle implementations in Data Warehouse area from designing Logical and Physical Data Models involving Star and Snowflake schemas.

Experience in Informatica Cloud, Informatica Data Quality (IDQ), Power Center, Data Cleansing, Data profiling, Data quality measurement and Data validation processing.

Load and Extract from multiple cloud applications and Legacy applications.

Strong experience with Informatica tools- like source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Task developer, WorkletDesigner, WorkflowManager and WorkflowMonitor.

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

Experience in MDM Hub configurations - Data modeling, Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director.

Experience in defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.

Experience with Data Warehousing and Data Modelling techniques.

Good knowledge Informatica Data Integration Hub.

Experience with ODI (ELT) and XML data integration.

Experienced on various databases like Oracle 11g/10g, MS-SQL Server, and Teradata.

Experience in Tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.

Experience in Collecting and transforming data from heterogeneous data sources like Transactional Databases, Flat files, MS Excel, XML, etc. into the central data warehouse.

Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Experience developing Complex mapping using various transformations available in Mapping Designer also in setting up groups, users, permission for Informatica user in Repository Manager.

Expertise in implementing complex business rules by creating reusable transformations, Mappings & Mapplets

Strong understanding of Data warehousing, Dimension Modeling, and RDBMS concepts.

Experience in writing Complex SQL queries, stored procedures and functions using PL/SQL Programming.

Database Design and Development using Oracle, Teradata, and SQL Server on Windows, and UNIX platforms.

Experience on working with both SDLC, Agile Methodologies.

Worked in complete Software Development Life Cycle (SDLC) Implementation from Requirement gathering, analysis, data modeling, design, testing, debugging, implementation, post-implementationsupport, and maintenance.

TECHNICAL PROFICIENCIES:

•Databases: Oracle 11g/10g/9i, Teradata, DB2, MS SQL Server 2000/2005, MS Access.

•Languages: SQL, PL/SQL, Shell Scripting, XML, HTML, Java script, C#.

•Operating Systems: Unix/Linux, Windows.

•ETL Data Integration Tools: Informatica Power Center / Power Mart 9.x/8.x/7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administration Console), Informatica Cloud, Informatica MDM, Informatica Data Integration Hub, Power Connect for ERP and Mainframes, Power Exchange.

•Tools: Toad, SQL*Loader, SQL Server Management Studio, Cognos, Tableau, VNC client, Putty, Teradata SQL Assistant, Eclipse, Control M,Autosys, Visual Studio, Erwin 4.5/4.0.

PROFESSIONAL EXPERIENCE:

Wells Fargo, Charlotte, NCAugust2016 – Present.

Role: Sr. ETL InformaticaDeveloper

Responsibilities:

Participated in Design/Business meetings and created high-level design document, low-level design document and technical design document.

Worked with DBA team for creating data models as per the business requirement.

Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data.

Implemented Batch Termination process of customers having multiple LOB’s.

Worked with various sources like flat files, xml, Oracle, Teradata, SQL Server to extract, transform and load the datainto Data marts and Data warehouse.

Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, reusable transformations, sessions, workflows, Fast Load and M Load.

Extensively worked on generating SOAP/REST requests to communicate with web services.

Created database objects like tables, views, synonyms and indexes.

Writing pre and post processing scripts for the ETL process.

Worked on PL/SQL stored procedures, packages, functions and triggers.

Experience with ODI for batch and real time data integration.

Involved in creating autosys jobs (Jil files) for DE and DR loads.

Performing code reviews & testing the ETL code.

Responsible for codedeployment to higher environments for QA, UAT and Production.

BCBSA, Chicago, ILJanuary2015 – July 2016

Role: ETL Informatica Developer

Responsibilities:

Participated in the Design meetings and created High-Level design document as well as a low-level design document.

Responsible for Informatica,Analyzed the Source System and involved in designing the ETL data load.

Providing input for changes in the Transparency Data Mart, Performing data analysis and working with DBA in designing tables in the Data Marts based on reporting needs.

Writing stored procedures to perform certain unique tasks that are complex to be implemented within Informatica Power Center.

Reported defined data quality KPIs and targets. And ensures that service level agreements are met and escalate whenever required.

Collaborate with the Enterprise Architecture teams (data integration, data architecture, business intelligence) to develop and deliver MDM solutions.

Worked on Informatica MDM Hub Console development.

Worked on defining measurable metrics and the minimal required attributes for each domain or subject area to support a robust & successful deployment of a MDM platform.

Define requirements for data matching and merging rules, survivorship criteria and data stewardship workflows that can be deployed in the endorsed MDM tool.

Configure landing and staging tables.

Performing code reviews & testing the ETL code that has modified in connection with this conversion process.

Worked on Oracle 10g, 11g databases, Interfaces.

Worked on testing, debugging, and troubleshooting with Power Center.

Analyze and document high level business requirements.

Worked on SSIS and SSRS.

Respond to customer and Business partner requests in a timely manner.

Worked on Repository Manager, Mapping Designer & Mapplet Designer, Workflow Manager and Monitor.

Created detailed Reports that lists out the customer information and the conduct details for all File connect and Renewal Customers.

Created Informatica maps using various transformations like SAP BAPI/ RFC SAP IDOCs transformations, Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, stored procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router.

Worked closely with load team for Data load into SAP (Direct Load Method/ LSMW/ BAPI).

Worked on PL/SQL stored procedures, packages, functions, and triggers.

Interaction with the Development and QA Team for the Release operations based on the Migration Documents.

Developed complex mapping to meet customer desired result (Data Integration work), mapping in Informatica to load the data from various sources.

Worked on different applications, performed SQL query tuning, optimization for the better performance.

Load the necessary reference data in the data mart. Designed the threshold as per the NCCT business team.

Designed the ETL to persist all the rejected cost detail records with multiple error codes.

Created stored procedures, tables, views, synonyms, and test data in Oracle.

Walgreens, Lincolnshire, IL February2014– December 2014

Role: ETL Developer.

Responsibilities:

Served as the point person on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on project status and issues.

Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, and reusable transformations, Pushdown Optimization, Batch Audit Process, Fast Load and M Load.

Integrated data from the various source system Such as CSV files, MS SQL Server, Teradata, Oracle, etc.

Represent the business unit's needs and objectives within BI and with our IT suppliers.

Discuss and understand the reporting requirement with Business Partner.

Teamed up with Enterprise Information Quality & Governance Office and business data stewards to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and quality of the data.

Worked on testing, debugging, and troubleshooting with Power Center.

Worked on implementation of optimal solution in DW space using DW standard methodologies

Create generic sequence jobs that handle migration of data for different modules.

Increased productivity through implementation of custom Programming solutions aimed at reducing time spent running manual processes, troubleshooting, and error resolution.

Controlled all file transfer with all clients, including all Inbound/outbound data exchanges, management of layouts and data dictionaries, and all financial files.

Worked on different applications, performed SQL query tuning, optimization for the better performance.

SEI Investment, NY April 2012 – December2013

Role: ETL Developer.

Responsibilities:

Participated in discussions with management team to better understand the business requirements.

Created BR and MD Documents.

Worked on Linux shell scripting.

Developed the ETL Mappings with complex transformations.

Worked on testing, debugging, and troubleshooting with Power Center.

Developed complex mapping to meet customer’s desired result (data integration work), mapping in Informatica to load the data from various sources.

Involved in development and maintenance of the data warehouse for reporting.

Involved in full life cycle of the business objects reporting application.

Worked on creating data models for ODS, EDW and Data Marts.

Worked on functions using PL/SQL and T-SQL.

Responded to customer and business partner requests in a timely manner.

Handled large volumes of data in production environments.

Worked on different applications, performed SQL query tuning and optimization for better performance.

Helped testing team to develop test scripts as well as did dry-run test and regression testing.

Troubleshot the loading failure cases, including database problems.

Prepared Documents like Technical Design Document (MD Documents), Production Support Document and Deployment Document.

Used Microsoft SQL Server Management Studio 2008 R2 to run SQL queries and validate the data in warehouse and mapping.

Extensively involved in testing by writing QA procedures for testing the target data against source data.

Intelli Group, Hyd, India.February 2010– March2012

Role: ETL Developer/Trainee

Responsibilities:

Participated in discussion with management team to better understand the business requirements.

Created HDD and LDD.

Analysis of source data and schema.

Worked with Oracle 10g and 11g databases and interfaces.

Design and Development of ETLs using Informatica Power Center to Collect Data from infrastructure Monitoring applications.

Populating the daily Fact tables and aggregated data into Weekly and Monthly Fact tables.

Worked on the SQL Developer and TOAD for the developing the PL/SQL code.

Experience in using Import and Export for Data backups.

Applied query Tuning and performance by using the explain plan for SQL query optimization

Created Complex Mappings using Informatica transformations like Expression, aggregator, Update strategy, Stored Procedure and lookup.

Created Mapplets and reusable transformations.

Implementing change requests for ETLs and Reports.

Troubleshooting and providing technical support to ETLs and Reports.

Prepared Documents like Technical Design Doc(MD DOCUMENTS), Production Support Doc, and Deployment Doc.

Maintained both development and production environments, monitoring the load jobs, checking the error log files for regular loads.

Contact this candidate