Data Project
Resume:
NagaSai Suresh Kumar Maturi
******.******@*****.***
732-***-****(H) / 201-***-****(M)
http://www.linkedin.com/in/maturi14
SUMMARY
12+ years of professional experience covering all phases of the Software
Development Lifecycle; System Analysis; Systems Integration.
Extensive hands-on experience on ETL Strategies & ETL Architecture Design.
Working in ETL process consisting of data transformations, data sourcing,
mapping, and loading.
Having experience in ETL process using Informatica-Power Center for large
Database in production environment.
Have extensive hands on Experience on designing ETL-Data Architecture.
Design of ETL mappings & Tech Specifications.
He has in-depth knowledge on data warehousing concepts and methodologies.
Experience with different databases Oracle 8i/9i/10g, SQL Server 2000/2005
and DB2.
Extensive hands-on experience on SQL and PL/SQL.
Extensive hands-on experience on Unix Scripting.
Extensive hands-on experience on different sources such as Flat Files, DBs
and XML.
Extensive hands-on experience on Structured/Unstructured data management
Extensive hands on experience on Master Data management
Extensively worked on Performance Tuning.
Implemented slowly changing dimensions Type-1, Type-2, Type-3 and Hybrid
Dimensions and History on Facts.
Extensive hands-on experience on Informatica Administration, Installation
and upgrade 7.1.3?8.1.1 ?8.6.1?9.0.1.
Worked as ETL Developer, ETL designer, Informatica Technical lead and
Informatica Architect.
Worked with Clients like Nestle-Poland, GE Energy- Atlanta, S&P in New
York, AHM-NY.
Informatica Certified Professional (Designer, Administrator and
Consultant).
Tremendous experience in customer relationship management and addressing
customer issues.
Strong Team spirit and relationship management skills.
Outstanding communication and interpersonal skills, ability to learn
quickly, good analytical reasoning and high compliance to new technologies
and tools.
Technical Skills
DW Informatica 4.x/5.x/6.x/7.x/8.x/8.6.1/9.0.1, Informatica
PowerExchange for SAP
Business Objects 5.x/6.x, Cognos
RDBMS Oracle 8i/9i/10g, DB2, SQL Server 2000/2005/2008, Sybase
OS Windows 9.x/ NT/2000/XP, UNIX, MS-DOS
Languages C, Pascal and PL / SQL, C++, Java
Modeling Erwin 4.x
Tools Toad, Aqua Data Studio, Rapid SQL, Putty, Tidal
Web HTML, VBScript, JavaScript, ASP, XML
EDUCATION/CERTIFICATION
Master of Computer Applications, Nagarjuna University, India
Informatica Certified Designer, Administrator and Consultant
Six Sigma Corporate Training
EXPERIENCE
Informatica Dev Lead /Architect/ April 2012- March
2013
Idaho Power Company (Utility Company), Boise, ID
Enterprise Data Warehouse (EDW):
The EDW project will be focused on serving as a single point repository for
all reporting needs. In addition to the meter data from Phase-1, this
system shall store the customer and billing data from CIS+ and CR&B
system.CIS+ have 14 years history data of Customer Information and CRMB has
one year of Customer Information System and billing The EDW repository
shall contain both historical customer and billing data as well as ongoing
customer and billing data from CR&B
.
Technical Responsibilities:-
Designed ETL (Informatica) Architecture for The Enterprise Data Warehouse
Designed and implemented ABAC model for the project
Designed and implemented Informatica PowerExchange for SAP
Designed ETL Strategies.
Single point of contact for ETL work.
Studied the existing environment and accumulating the requirements by
querying the Clients on various aspects
Analyzing specifications for various applications enhancements for
compatibility within the system.
Developing ETL Design documents, data mapping documents and migration
document.
Documented the test cases and results for future understanding and
reference
Unit testing and integration testing
Managerial Responsibilities:-
Leading ETL technical team.
Leading ETL Development Team of onshore and off shore.
Day-to-day leadership in planning and executing activities
Environment: Oracle 10g, SQL Server, Informatica 9.x, Informatica
PowerExchange, Toad 8.x/9.x, Windows
Informatica Architect/ETL Data Architect Mar
11 - April 2012
Moore Capital Management (A Hedge Fund Company), New York, NY
Hub: Integrated all trading systems and market data into one centralized
and near to real time data ware house system which is having equities,
options, forex (FX), fx options, Fixed income which are Bonds, Bond
futures, swaps, swap options, and Credits (Cr) which are in the form of
xml, flat files and data bases
Risk Console: Risk console is a Risk analysis product which explores the
risk of each and every product and evaluates the risk for each and every
portfolio of funds
Technical Responsibilities:-
Designed ETL (Informatica) Architecture for Reporting Data Warehouse
Project
Designed ETL-Data Architecture for Capco data, portfolio management and
Risk Console
Designed ETL Strategies
Informatica Installation on UNIX and Informatica upgrade from 8.1.1 ?8.6.1
Informatica Administration
Optimizing / Tuning mappings for better performance and efficiency
Studied the existing environment and accumulating the requirements by
querying the Clients on various aspects
Analyzing specifications for various applications enhancements for
compatibility within the system.
Developing data mapping documents and migration document.
Generating ETL mappings, sessions, workflows using Informatica
Created reusable components (Mapplets, reusable Transformations, Tasks,
worklets)
Implemented Slowly changing dimensions Type-1, Type-2 and Hybrid
Dimensions
Involved in writing PL/SQL procedures.
Involved in writing shell scripts
Documented the test cases and results for future understanding and
reference
Unit testing and integration testing
Migrated Informatica mappings, sessions and workflow from development to QA
and QA to Production
Monitor production loads daily, monthly and quarterly
On call Production Support.
Informatica Architect/ETL Data Architect /Team Lead
Sep 06 - Mar 11
Active Health Management (A Aetna Health Insurance Company), New York, NY
Data Marts: CRS, HRA, PHR, Active Advice, DM Evaluation Run, Sole Source
Personal Health Record (PHR)
To explore the effectiveness of the PHR in improving Care Consideration
compliance, decreasing health risk, and saving unnecessary health costs.
The purpose of this project is to provide an in-depth analysis of Personal
Health Record activity as it relates to the clinical support applications
that underpin Active Health's PHR.
PHR-HRA
Active Health HRA optimizes the clinical usefulness and user experience of
the HRA by presenting each user with only those questions that are most
relevant their unique health status. Factors that can determine what
questions are presented to a member include: age, gender, health
conditions, and questions previously answered on the HRA.
Active Advice
This Project deals with the integration of Oracle sources from Elderplan
and Anthem and SQL Server sources from AAProd, FebProd and Humana to build
the Active Advice Data Warehouse designed using the Immon approach. This
data warehouse includes different subject areas as Patient, questions &
answers, Patient Medication, Patient Eligibility, Clinical review, disease
management, case management system.
Production & Support
Health Risk Assessment (HRA)
HRA provides an overview of which members filled out the survey in the
reporting period, how successful they were at completing it, and how much
time they spent. Demographic information identifies the age group and
gender of respondents. Incentive tracking data is also provided, showing
how many respondents qualified for incentives. Details on eligible
respondents are reported separately.
Extracts
Sending flat files and or/and XML files, upon ad-hoc request, to clients
like ICM, HDMS, Penske, CITI PHR/HRA, Lowes, Aramark, Vanderbilt, Marriot
Marcus and Aetna. Responsibilities:
Technical Responsibilities:-
Designed ETL (Informatica) Architecture for Reporting Data Warehouse
Project
Designed ETL-Data Architecture for PHR DataMart, SoleSrource and Aetna
DataMart. And active advise
Designed ETL Strategies
Informatica Installation On UNIX and Informatica upgrade from 7.1.3 ? 8.1.1
?8.6.1?9.0.1
Informatica Administration
Optimizing / Tuning mappings for better performance and efficiency
Studied the existing environment and accumulating the requirements by
querying the Clients on various aspects
Analyzing specifications for various applications enhancements for
compatibility within the system.
Developing data mapping documents and migration document.
Generating ETL mappings, sessions, workflows using Informatica
Implemented Slowly changing dimensions Type-1, Type-2 and Hybrid
Dimensions
Created reusable components (Mapplets, reusable Transformations, Tasks,
worklets)
Generated FlatFiles,xml and EDI files
Involved in writing PL/SQL procedures.
Involved in writing shell scripts
Documented the test cases and results for future understanding and
reference
Unit testing and integration testing
Migrated Informatica mappings, sessions and workflow from development to QA
and QA to Production
Monitor production loads daily, monthly and quarterly
On call Production Support.
Managerial Responsibilities:-
Leading ETL technical team
Day-to-day leadership in planning and executing activities
Environment: Oracle 10g, SQL Server, Informatica 7.x/8.x/8.6.x, Toad
8.x/9.x, Aqua Data Studio, Win 2K, UNIX
Sr. Informatica Designer/ ETL Data Architect / Onsite Coordinator
Mar 06 - Aug 06
Standard & Poor's, New York, NY
DataMarts: Rating Documentum Reporting
The RDR is the Rating Documentum Reporting will provide S&P with a user-
friendly tool to Audit the Documentum.
Documentum is the SCM Tool for the S&P users.
Documentum will contain Folders and Documents which are supporting Users in
version controlling and document management.
As this contains vast amount of Data, RDR will be helping them for Auditing
Documentum System and their Users who access Documentum
DataMarts: Ratings Reporting Project
The Ratings Reporting Project provides S&P with a user-friendly tool to
access Core data. It will provide complete and comprehensive access to Core
data and will replace Core "canned" reports as well as ad-hoc reports
created in the current in-house reporting tool, Report Writer. It will
employ template/canned reports and user-created ad-hoc reports.
Responsibilities:
Designing ETL-Data Architecture
Understanding the source systems and data model for data mart / data
warehouse.
Developing data mapping documents and migration document.
Generating ETL mappings, sessions, workflows using Informatica 7.x.
Implemented Slowly changing dimensions Type-1, Type-2, Type-3 and Hybrid
Dimensions and Facts
Created reusable components (Mapplets, reusable Transformations, Tasks,
worklets)
Involved in writing PL/SQL procedures.
Involved in writing shell scripts
Unit testing and integration testing
Migrated Informatica mappings, sessions and workflow from development to QA
and QA to Production
Optimizing / Tuning mappings for better performance and efficiency
Environment: Oracle 9i, Informatica 7.x, Toad, Windows 2000, UNIX
Sr. ETL Developer/ Designer/ ETL Data Architect /Technical Leader
Jul 03 - Mar 06
GE Power Systems, Hyderabad/Atlanta
GEPS Enterprise Data Warehousing (DataMarts: CMS-integration, Cash Outflow,
Cash Inflow, Cash Flows, Parts Real Time Data Warehousing) and CGSBI)
CGSBI (Consolidated Global Sourcing BI)
CGSBI is a consolidated Global sourcing data warehouse for all the purchase
information for GE Energy. Sources are from Oracle AP modules and SAP and
BAAN. Requirements were across GEPS and also Orders2Settlement (O2S)
integration with GSDW and Supplier Score Card.
Achievements:
Decreased Load Time from 22-24 hrs. To 6-8 hrs.
Stabilized the data mart
Implemented Duplicate strategy
Improved the data quality for aggregate tables.
Implemented the recast strategy for all the fact tables
Role: As TPL for this project for requirement gathering and Data Modeling.
Suresh has been the single point of contact at onsite to run the project.
Responsibilities:
Understanding the source systems and data model for data mart / data
warehouse.
Developing data mapping documents and migration document.
Generating ETL mappings, sessions, workflows(batches) using Informatica
5.x/6.x/7.x
Created reusable components (Mapplets, reusable Transformations, Tasks,
worklets)
Involved in writing shell scripts
Unit testing and integration testing
Migrated Informatica mappings, sessions and workflow from development to QA
and QA to Production
Optimizing / Tuning mappings for better performance and efficiency
GEPS-IDW (Real Time Data Warehousing)
Design and implement a process to extract and populate the IDW tables
related to Quotes, Orders and Shipping with near real time data. Extract
near real time data (max two hour latency) from Parts ERP Integrate
incremental real-time data into the IDW tables for the critical fields
related to Quotes, Orders and Shipping
Cash Outflow DataMart
Captures actual, scheduled, open, suspended, Future Paid cash payments.
Segments cash outflows by MGMT- Hierarchy 1 to 8.Segments cash outflows by
type of expenditure e.g. Operating, Investing, Financing and by expenditure
activity type e.g. Plant & equipment, Inventory, Direct Material etc.
Provides historical comparative data. Provides cash outflow predictions
every quarter and the trends in outflows.
CMS-integration: - The project consisted of four metrics
Op Plans: This metric is related to employees; the entire employee's
information is getting from CMS replicated database and decomposed as
fiscal week records into CMS DataMart.
Cash Inflow DataMart
The DataMart has achieved the following: Captures actual, scheduled, open,
suspended, Credit Used cash payments. Segments cash inflows by MGMT-
Hierarchy 1 to 8.Segments cash inflows by type of expenditure e.g.
Operating, Investing, Financing and by expenditure activity type e.g. Plant
& equipment, Inventory, Direct Material etc. Provides historical
comparative data. Provides cash Inflow predictions every quarter and the
trends in outflows.
Cash Flows
GEPS25 Cash Flows Metric project will supply the Digital Cockpit with a
consolidated view of cash outflows and cash inflows across GEPS. Currently
GEPS has over 50 distinct non-integrated systems associated with cash
outflow and cash inflow data. These systems are at various locations
throughout the globe and severely constrain GEPS' ability to effectively
manage, understand, and analyze cash, individually and in relation to each
other. Therefore, the GEPS25
Responsibilities:
Developed ETL mapping Documents, Data Migration documents
Developed Perl Scripts for Screen Door process.
Designed ETL Logic for mappings
Interacted with client for ETL Logic
Involved in writing scripts, procedures to load data from different legacy
systems to staging area as well as to load data from staging area to Star
Schema.
Worked in various types of transformation like Lookup, Update Strategy,
Stored Procedure, Joiner, Filter, Aggregation, Rank, Router and XML Source
Qualifier etc. of Informatica.
Creation of Mapplets to reduce the development time and complexity of
mappings and better maintenance.
Developed Complex mappings by extensively using Informatica Transformations
Creating/ Building and scheduling Batches and Sessions using the Server
Manager
Developing Reusable Transformations, Aggregations and created Target
Mappings that contain business rules
Optimizing / Tuning mappings for better performance and efficiency
Involved in writing shell scripts.
Environment: Oracle 8i/9i, Informatica 5.x/6.x,7.x Rapid SQL, Windows 2000,
UNIX
ETL Designer/Developer Jan 03 - Jun 03
IBM, Kolkata for Nestle Globe
Data Conversion (DataMarts: MDR, RLS and HR)
Project involved data conversion from legacy AS/400 data to SAP Management
Workstation. Migration was in four stages of Cleansing; Transforming,
Mapping & Adding; Comparing (Ext. Duplicate Check) and Loading. The two
staging areas, IOS and ODS contain market specific tables implemented in
DB2. Depending on the nature of data it was stored in MDR, RLS or HR data
stores.
Responsibilities:
Developed ETL mapping Documents, Data Migration documents
Developed Perl Scripts for Screen Door process.
Designed ETL Logic for mappings
Interacted with client for ETL Logic
Involved in writing scripts, procedures to load data from different legacy
systems to staging area as well as to load data from staging area to Star
Schema.
Worked in various types of transformation like Lookup, Update Strategy,
Stored Procedure, Joiner, Filter, Aggregation, Rank, Router and XML Source
Qualifier etc. of Informatica.
Creation of Mapplets to reduce the development time and complexity of
mappings and better maintenance.
Developed Complex mappings by extensively using Informatica Transformations
Creating/ Building and Running / scheduling Batches and Sessions using the
Server Manager
Developing Reusable Transformations, Aggregations and created Target
Mappings that contain business rules.
Optimizing / Tuning mappings for better performance and efficiency
Involved in writing shell scripts.
Environment: Oracle 8i, DB2, Informatica 4.7.x/5.x/6.x, Rapid SQL, Windows
2000, UNIX
ETL Designer/Developer Aug 01 - Dec 02
SR Software Solutions, Hyderabad
ADSI (Applied Digital Security)
Applied Digital Security is in the business of providing solutions to
access and analyze data elements from Data Warehouse to answer frequent and
diverse ad-hoc requests from senior management. The primary purpose of this
project will be to facilitate ad-hoc reporting and subsequent data
analysis. This process eliminates manual efforts for the ADSI teams in
processing the data.
Responsibilities:
Developed ETL mapping Documents, Data Migration documents
Developed Perl Scripts for Screen Door process.
Designed ETL Logic for mappings
Interacted with client for ETL Logic
Involved in writing scripts, procedures to load data from different legacy
systems to staging area as well as to load data from staging area to Star
Schema.
Worked in various types of transformation like Lookup, Update Strategy,
Stored Procedure, Joiner, Filter, Aggregation, Rank, Router and XML Source
Qualifier etc. of Informatica.
Creation of Maplets to reduce the development time and complexity of
mappings and better maintenance.
Developed Complex mappings by extensively using Informatica Transformations
Creating/ Building and Running / scheduling Batches and Sessions using the
Server Manager
Developing Reusable Transformations, Aggregations and created Target
Mappings that contain business rules.
Optimizing / Tuning mappings for better performance and efficiency
Writing shell scripts.
Environment: Oracle 8i, Informatica 4.7.x/5.x, Toad, Windows 2000, UNIX
Customer and Vendor Account Management & Billing System Apr 01 - Jul
01
Real World Communications, NJ, USA
Environment: ASP, VBScript, Java Script, HTML, Oracle 8i, Windows NT,
IIS 5.0
HYPERLINK "http://www.ITClassics.com" www.ITClassics.com Dec 00 - Mar
01
IT Classics, USA
Environment: ASP, VBScript, Java Script, HTML, Oracle 8i, Windows NT,
IIS 5.0
Employee Scheduler Aug 00 - Nov
00
Environment: ASP, VBScript, Java Script, HTML, Oracle 8i, Windows NT,
IIS 5.0
Contact this candidate