Data Manager
Resume:
REDDY, SREENATH Ph: 408-***-****/925-***-****
PROFILE:
8+ years of total IT experience.
7+ years of Informatica experience.
7+ years of Oracle experience.
SUMMARY:
* ***** ** ** ********** in Analysis, design, development and Implementation of Business Intelligence solutions using
Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server and Web applications on Windows and Unix platforms in
various verticals such as Health Care, Utilities & Resources, Sales & Distribution, Pharmaceutical, Financial &
Telecommunication.
Informatica: 7+ years of Data Warehousing experience using Informatica Power Center
9.0.1/8.6.1/8.5/8.1.2/8.0/7.1.1/7.1.2, Power Mart 6.1/5.1.1/5.x/4.7, Warehouse Designer, Power Connect for
SAP/Siebel/DB2, Power Exchange, Power Analyzer, Power Plug, ETL, Data Mart Siebel 7.0/2000/5.5,
Siebel Warehouse 6.3, Siebel EIM, OLAP, OLTP, Tidal.
Data Analysis: 4 years of strong Business Analysis experience on Data Analysis, User Requirement
Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data
Relationships, Source Systems Analysis and Reporting Analysis.
Data Modeling: 4 years of Dimensional Data Modeling, Erwin Modeling (ERwin
7.3/4.5/4.0/3.5.5/3.5.2, Oracle Designer) Star Join Schema/Snowflake modeling, FACT & Dimensions
tables, Physical & logical data modeling, Star & Snowflake schema Relational, dimensional and
multidimensional modeling and De normalization techniques.
Databases: 7 years of experience using Oracle 10g/9i/8i/8.0/7.0, IBM DB2 8.0/7.0/6.0, MS SQL Server 2005/2000/7.0,
Teradata V2R5/V2R4/V2R3,File Maker, MS Access 7.0/2000,SQL, XML, PL/SQL, SQL*Plus, SQL*Loader,
Intersystem’s Cache DBMS.
Programming: SQL, PL/SQL, ISQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, HTML,
DHTML, C, C++,PERL, Unix Shell Scripting.
BI Tools: Business Objects XI/6.5/6.0/5.1/4.1 (Web Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer
2.0), MS Access Reports.
ERP: SAP R/3, SAP SD, SAP BW, SAP CRM, Siebel/DB2/SAP, Siebel 7.0/2000.
Data Quality: BO Data Quality, Trillium.
Organizational Skills:
Business interaction and business requirements analysis from Users and Managers.
Document requirements and create detailed design specifications.
Experience in preparing developer guidelines and user guides.
Experience in creating good Knowledge Transfer Document for both support team as well as Development team.
Experience in Leading ETL Development & Reporting Team.
Work with users to ensure that development efforts are meeting the users' needs.
EDUCATION/
CERTIFICATIONS
REDDY, SREENATH Ph: 408-***-****/925-***-****
Masters in Software Engineering.
Post Graduate Diploma in Computer Applications.
Bachelors in Computer Applications.
Certified in Informatica Designer.
Professional Experience:
Client: Symantec Corporation Location: Mountain view, CA
http://www.symantec.com
Role: Sr. Informatica Architect/Lead
Duration: Aug 2010 – Present
There is an expectation from the leadership team to provide consistent, relevant KPI reporting as we move into the FMO (Future
Mode of Operations) in the HPES outsourcing agreement. Currently, multiple teams are manually creating reports to highlight
metrics on KPIs across the organization relating to the IT Project Portfolio, Project Approval, HPES contractual obligations,
Finance, Project Delivery, and the Victory Plan.
Data is kept in multiple locations in varying formats, and is time consuming to compile. Based on the time required to manually
compile the KPI data, little time is available to provide appropriate commentary on the trends and variances.
Although the project title contains “KPI”, meaning “key performance indicators”, the business needs access to any data that enables
managers to understand what is driving IT performance. Therefore, the repository should be designed such that it can contain any
and all data that might have a potential to monitor performance.
Responsibilities:
• Responsible for gathering Business requirement and translate into technical requirements.
• Involved in data modeling for IT Business Metrics Repository.
• Extract data from the source files such as Budget, Actuals & forecast data for the projects.
• Develop the Informatica Mappings for IT business Metrics to load data from flat files on to the dimensions & fact tables
using Informatica Power Center 8.6.
• Develop the strategy to check the consistency of data between the source systems & the data warehouse.
• Responsible for creating the Modules & chains in Appworx scheduler to schedule the Workflows.
• Migrated the workflows from Dev to QA environment.
• Designed the data validation strategy for validating the data against warehouse.
• Developed the shell script to ftp the files from tumbleweed secured FTP server to Informatica Server and clean up the .csv
files.
• Used PVCS to maintain the versioning of the informatica mappings, Migration documents.
• Created the database scripts for the data model, which can be executed across different environments.
• worked with Normailzer transformation to convert the revenue of Actuals, Budget, Forecast month.
• Develop the reusable transformation to reconcile the data b/w sources & targets across various objects.
REDDY, SREENATH Ph: 408-***-****/925-***-****
Environment: ETL/Informatica PowerCenter 8.6, Informatica Power Exchange 8.6, Oracle 11g, PL/SQL, Flat files,
Tumbleweed, Appworx, UNIX, Toad, CSV, Shell Scripting, PVCS, Erwin 7.3.
Client: Frontier Communications Location: Rochester, NY
http://www.frontier.com
Role: Sr. Informatica Architect
Duration: Oct 2009 – Jul 2010
This Project deals with integration of Verizon Data, as Frontier brought Subscribers from 14 States of Verizon and as a part of this
project we need to migrate Verizon Customers Data, Billing and Accounting info into the frontier existing systems.
Responsibilities:
• Analyzed source systems and determined needed data.
• Designed specifications and validation strategy for warehouse.
• Responsible for gathering Business requirement and translate into technical requirements.
• Responsible for Automation of Loading of Flat Files using Sql Loader.
• Develop mapping for DPI Billing system to load data from Verizon Billing System on to the Frontier Billing system.
• Extract of Data from DB2 using Power Exchange for DB2 and Loading of Data into DB2 using Power Exchange.
• Oracle Development including writing Pl/Sql Procedures and Functions and writing T Sql Stored proc.
• Experienced in writing Queries against DB2 on AS400 Environment using Hestia.
• Responsible for Performance tuning of oracle queries using Explain Plan and procedures and function using DBMS Debug,
DBMS Profiler Responsible for development of stored procedures and functions in oracle.
• Developed mappings/sessions using Informatica Power Center 8.6 / power exchange 8.6 for data loading.
• Perform QA and Code review for my code and other developer’s code.
• Responsible for managing Informatica Services like Repository Service, Integration Services, Reference Table Manager
Services etc.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet
Designer.
• Used Pushdown optimization (PDO) technique to increase the performance of the load.
• Define Meta data standards for the data warehouse.
• Direct and design the information delivery and access for the data warehouse.
Environment: ETL/Informatica PowerCenter 9.0.1, Informatica Power Exchange 8.6, Oracle 11g, PL/SQL, Sybase, Flat files,
UNIX, Toad, SQL Developer, VSAM, CSV, AS400, DB2, Shell Scripting, HP Quality Center, Erwin 7.3.
Client: Citi Financial Location: NYC, NY
http://www.citifinancial.com
Role: Informatica Architect
Duration: Aug 2008 – Sep 2009
REDDY, SREENATH Ph: 408-***-****/925-***-****
Project Description: This project deals with capital investment developed to calculate operational and credit risk factors to comply
with BASEL II compliance OTC derivatives data.
Responsibilities:
• Responsible for designing Informatica ETL jobs to calculate complex operational risk and credit risk factors
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner,
Aggregator, and Expression Transformation.
• Used Teradata Tools like Fast Load, MultiLoad, Control M and T Pump to constantly load and manage the data.
• Coding TPT Wrappers for loading and extracting data using BTEQ SQL of TERADATA.
• Involvement in implementation of BTEQ, Bulk load and extract jobs in the TPT Wrapper scripts.
• Understanding the Teradata Parallel Transporter (TPT) Wrappers Scripts
• Used BTEQ to monitor the production Teradata Database Environment, including Runtime Optimization, Capacity
Management, Planning, Security, Configuration and Scheduling.
• Extensively used Informatica ETL to load data from Oracle database and MS SQL Server database to Teradata database.
Worked as a Data Warehousing Analyst administering various databases such as MS SQL Server and Teradata.
•
Expertise in Performance tuning of PLSQL Procedures and Complex Informatica Mappings
•
Enterprise data size exceeds 30 Terabytes for Capital investments and derivatives
•
Experienced in working with SAP connect and ERP data extraction.
•
Developed and executed UNIX scripts to schedule loads, through SQL loader utility and wrapper shell scripts for calling
•
Oracle Stored Procedures and Packages.
Applied the Push Down optimization technique (PDO) to improve the performance.
•
Created error handling mappings for monthly extract mappings for Rekeying process
•
Environment: ETL/Informatica PowerCenter 8.6, Informatica Power Exchange 8.6, Oracle 11g, Teradata, PL/SQL, Flat files,
PERL, UNIX, Toad, AS400, DB2, Shell Scripting, HP Quality Center, IDE/IDQ.
Client: E.ON US Location: Tampa, FL
http://www.eon us.com
Role: Sr. Dataware house Developer
Duration: Jan 2008 – Jul 2008
E.ON U.S., headquartered in Louisville, Kentucky, U.S.A., is a diversified energy services company. E.ON U.S. owns and operates
Louisville Gas and Electric Company, a regulated utility that serves 318,000 natural gas and 390,000 electric customers in Louisville
and 16 surrounding counties and Kentucky Utilities Company, a regulated electric utility in Lexington, Kentucky, U.S.A., that serves
518,000 customers in 77 Kentucky counties and five counties in Virginia.
Accenture had about 8 to 10 people at Florida under the solution works migration team providing end to end solutions for EON.
Current Project is a Conversion Project for SAP.
Responsibilities:
• Create the naming standards for the DW team
• Lead the development team during the development process, this include provide help with the tasks and transfer
knowledge of Informatica.
• Tuning the Informatica Repository and Mappings for optimum performance.
REDDY, SREENATH Ph: 408-***-****/925-***-****
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Responsible for managing Informatica Services like Repository Service, Integration Services, Reference Table Manager
Services etc.
• Extensively working with Repository Manager, Designer, Workflow Manager and Informatica Monitor.
• Developed mappings/sessions using Informatica Power Center 8.1 / 6.2 for data loading.
• Perform QA and Code review for my code and other developer’s code.
• Loaded the Data from Legacy systems to SAP by using EMIGALL.
• Used Teradata Tools like Fast Load, MultiLoad, Control M and T Pump to constantly load and manage the data.
• Coding TPT Wrappers for loading and extracting data using BTEQ SQL of TERADATA.
• Used BTEQ to monitor the production Teradata Database Environment, including Runtime Optimization, Capacity
Management, Planning, Security, Configuration and Scheduling.
• Worked as a Data Warehousing Analyst administering various databases such as MS SQL Server and Teradata.
• Used Data Trillium Data Quality & Discovery for cleansing, Profiling & enriching the data.
Environment: ETL/Informatica PowerCenter 8.5, Informatica Power Exchange 8.5, Teradata,Oracle 10g, PL/SQL, Flat files,
UNIX, Trillium, Tidal, Toad, VSAM, ERWIN,CSV, Oracle Warehouse Builder, DB2, Shell Scripting, HP Quality, SAP R/3.
Client: Australian Gas Light Location: Melbourne, VIC (Australia)
http://www.agl.com.au
Role: Sr. ETL Lead Developer
Duration: Mar 2007 Dec 2007
AGL has delivered energy to Australians for 170 years and today, around 6 million people rely on AGL to meet their energy needs.
During 2006/2007, AGL has continued to make progress toward achieving our stated strategic goal of becoming a world class,
customer focused Energy Company.
Retail Energy Retail Energy sells natural gas, electricity and energy related products and services to about 4 million residential and
small business customer accounts across NSW, Victoria, South Australia and Queensland.
Responsibilities:
• Prepared documentation including requirement specification.
• Involved in designing the Datamart model with ERwin using Star Schema Methodology.
• Involved in creating Dimensions and Facts in the physical data model.
• Installed and configured Datastage Client and Server Tools. Used the Datastage
• Designer to develop processes for extracting, cleansing, Transforming, integrating, and loading data into data warehouse database.
• Developed jobs in Parallel Extender using different stages like Transformer,
aggregator, lookup, Source dataset, external filter, Row generator and column generator.
• Worked on converting the ETL processes developed to load Oracle tables to load Teradata tables.
• Used Teradata loaders such as Mload and Fast load.
• Loaded the data on to SAP warehouse from legacy systems.
• Wrote BTEQ scripts for Teradata loads.
• Coding TPT Wrappers for loading and extracting data using BTEQ SQL of TERADATA.
• Loaded target data warehouse in Teradata
REDDY, SREENATH Ph: 408-***-****/925-***-****
• Used Parallel Extender for distributing load among different processors by Implementing pipeline and Partitioning of data in parallel
extender.
• Create the naming standards for the DW team
• Lead the development team during the development process.
• Worked on Trillium Data Quality & Discovery for cleansing, Profiling & enriching the data.
• Used Tera Data External loads like Mload, Tpump, Fast Load
• Wrote Unix Shell Scripts to automate the process.
• Received flat files through FTP.
Environment: Ascential Data stage XE/7.0/6.5, Data stage Plug in, Parallel Extender, Metastage, Qualitystage, MetaRecon,
Erwin 4.5, Version Control, PL/SQL,CSV, Oracle 9i, SQL,FTP, PL/SQL, SQL Server 6.5, DB/DB2, Teradata, Trillium, T
SQL, Micro strategy 7i, Intelligence Server, Web Narrowcast Server, Win NT/XP, UNIX, SAP R/3.
Client: Hewlett Packard Location: Cupertino, CA
www.hp.com
Role: Sr. ETL Lead Developer
Duration: Jul 2005 Feb 2007
The project is about migrating data from Legacy Systems to Siebel 7.8.2, the data used for migration deals with Sales and Services
aspects of HP Products. The objective is to enable a full 360 view of all HP touch points with Sales and Services. The application
will be used by Sales and Service users.
Responsibilities:
• Participated in Business Requirement discussion and transferred into technical specification for data loading.
• Prepared the documentation as dataflow charts and design documents on how the data flow from Legacy Systems to Siebel 7.8.
• Involved in gathering requirements from business, identifying gaps, level of effort and creating technical design.
• Mapped Legacy system to Siebel Data Model. This was done to load data from Legacy system to Siebel every night.
• Created ETL process for loading data from Siebel OLTP to Siebel OLAP.
• Created Mapplets, Transformations and Workflows using Informatica.
• Created Mappings to load data from the Siebel base tables into Warehouse Staging tables.
• Created SIL mappings to load data from Warehouse Staging tables into Warehouse Fact and Dimension tables.
• Created tasks and groups for sessions and Used DAC Client to schedule the ETL process and to troubleshoot the data loads
• Mapped Legacy system to Siebel Data Model. This was done to load data from Legacy system to Siebel every night.
• Mapped Account, Contacts, Assets, Opportunities, Agreements, Entitlements, Service Requests, Orders, Activities and other
entities to Interface and Base tables taking S_PARTY model into consideration.
• Used SQL Scripts, Materialized views, Stored Procedures and PL/SQL Scripts to extract data from Database.
• Used Trillium for data cleansing and also worked on job files to create integrated data quality solutions.
Environment: ETL/Informatica PowerCenter 7.1.1, SQL Server, Trillium, PL/SQL, BI, Data warehousing, Flat files, Siebel,
Toad, Siebel Analytics, Business Objects.
REDDY, SREENATH Ph: 408-***-****/925-***-****
Client: Hewlett packard Location: Bangalore, India
www.hp.com
Role: ETL Developer
Duration: Feb 2002 Jun 2005
This projects mainly deals with the sales domain to track the sales from Wholesalers on daily, weekly & Monthly basis. In term of
extracting the data from Legacy systems to extracts which will be sent to Business analysts across Europe. This is HP – Internal
Clients we run some jobs to make sure that the extracts are generated in time to keep track Record and Refresh the Business
Transactions for Wholesalers on Dash Board for users.
Responsibilities:
• Develop a level of understand of Informatica in order to support conversion transform developer
• Created the transform design for the individual conversion object, using the functional designs and the defined Informatica
architecture.
• Confirm the completeness and consistency of the transform and resolve any inconsistencies discovered.
• Participated in the unit testing, assembly testing and execution of the trail and actual conversions.
• Creating Informatica maps using various transformations like XML Parser, Source Qualifier, Expression, Look up
(connected and unconnected), Stored Procedure, Aggregate, Update Strategy, Joiner, Filter and Router.
• Design and document validation rules, error handling and test strategy of the maps.
• Creation of Reports using Business Objects
• Performance tuning of the sessions using Workflow Manager Statistics and front end query tools.
• Prepared User and Quality Technical Documentation.
• Expertise in Scheduling jobs through Maestro Scheduler, Tidal & Crontab.
Environment: ETL/Informatica 4.0 (Power Center Power Mart), Oracle 8i, PL/SQL, Flat files, HP UX, Toad, Business
Objects, Shell Scripting, Tidal, HP OVSD, BI, Data warehousing, Maestro, Crontab.
Contact this candidate