Rayavaram - Systems Engineer - India

Padmini Rayavaram

India

Services

Systems Engineer

Summary:

• Over 2.4 Years IT experience involving in the architecture, design and development of Data Warehousing and Business analytics Application, Data Analysis, Data Mapping, Reporting and ETL.
• Experience in configuring Data Warehouse Administration Console(DAC) and ETL(Informatica Power Center 8.6.1/8.5.1) jobs.
• Highly proficient in Extraction, Transformation and Loading(ETL) of data from various sources(such as OLTP Systems, Oracle E-Business Suite, Flat files)/data marts into the target systems(such as OLAP Systems, Business Analytics Warehouse(BAW)) using various tools and utilities which include Informatica Power Center8.6.1and DAC.
• Worked extensively in developing ETL Transformations, Informatica Designer, Informatica Workflow Manager, Informatica Workflow Monitor, and Repository Manager.
• Experienced in interacting with Business users in analyzing the Business process requirements and transforming them into documents, designing, and rolling out the deliverables.
• Efficient in trouble shooting performance tuning and optimization of ETL and reporting analysis.
• Experience in Database Design, Entity-Relationship Modeling, Dimension Modeling, Star Schema & Snowflake with Kimball methodologies.
• Extensive experience in Oracle 11g/10g/9i, SQL Server 2000/2005 and specialized in developing, designing of Stored Procedures/Packages using SQL to improve query performance.
• Excellent interpersonal and technical skills to communicate with users validate requirements and excellent documentation skills with ability to learn and adopt new ideas and technologies.
• Self-Starter looking for challenges, ability to rapidly learn and apply new technologies and improve processes, Self-motivated and results-oriented.
• Highly motivated team player with good communication skills and excellent problem solving abilities and would be willing to work independently or as part of a team.

Work History

Systems Engineer

Tata Consultancy Services

From August 2011

Projects

SIEBEL CRM Implementation

Project Information:
August/12 - Present
Client : MHRIL(Club Mahendra)

The clients have embarked on an enterprise-wide CRM initiative to establish integrated processes spanning customer acquisition and customer servicing. They have selected Siebel CRM as its technology platform for the Company. TCS team is involved in the Implementation of Siebel Call Center application covering the functional areas of Sales, Service and Marketing for various areas of Requirement. For this Siebel CRM implementation including all the functional areas BI Applications has been used to build reports for analysis. Dataware housing has been done using ETL tool Informatica and scheduler tool DAC to execute the workflows.

Roles and Responsibilities:
Role: ETL Developer

• Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Oracle transformed based on business requirements and loaded to Data Warehouse.
• Well acquainted with Informatica mappings and mapplets and also tuned
them for Optimum performance, Dependencies and Batch Design.
• Worked extensively on different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizer.
• Loaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.
• Lead definition, execution, and communication of ETL strategy, design and processes to support the EDW environment.
• Established and ensured appropriate data quality and ETL metrics are defined, monitored and managed.
• Migrated Test Code from Development to QA and QA to Production of Repository,
Dashboard Reports, Informatica mappings and workflows and DAC entities.
• Validated the data/Reports each and every time a migration occurs from Dev to QA and QA to Production environment.
• Responsible for updating/ tracking and documenting the development changes at both ETL level.
• Configured new tasks, parameter files and Execution Plan in DAC for incremental and full load.
• Streamlined the Execution Plans with their respective tasks in DAC.
• Maintained and monitored the Full and Incremental loads through DAC on different environments like Development, QA and Production environment.
• Actively resolved the issues and defects raised by the tester during SIT and UAT testing phases.
• Developed physical and logical star schema using OBIEE administration tool.
• Developed OBIEE Repository (.rpd) with all the three layers: Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Developed dimensional hierarchies based on the business requirement of an attribute.
• Used the Expression Builder utility to configure new logical columns in the BMM layer and configured various calculation measures.
• Customized business reports using BI Answers as per requirements. Developed, configured and tested report in the Dashboard and configured the adhoc report according to the client needs.



COPERNIC


Project Information:
Dec 2011 – Jul 2012

Client AXA –UK(Insurance Domain)

This project is about implementing Platform to replace the Ledger system for European Countries under AXA-UK Client. ETL has been used to load data from SAP source files to ledger system. MD (Master data), GL (Group Ledger), COPA are the few interfaces developed in this project. Batch Scripting is used to move the file to archieve folder.

Roles and Responsibilities:
Role: ETL Developer/Tester


• Extensively used ETL to load data from multiple sources(SAP files) to Staging area (Oracle) using Informatica PowerCenter 8.6.1.
• Batch scripting is done for few workflows as per the requirements.
• Handled ETL testing and support activities on different environments like Development, QA and Production environment.
• Ensured adherence to quality processes.
• Optimized ETL design and tools to gain efficiency and functionality.
• Contributed to process improvement initiatives (best practices, six sigma etc).
• Developed strategy for implementing data profiling, data quality, data cleansing and ETL metadata.

SIEBEL CRM Implementation

Project Information:
The clients have embarked on an enterprise-wide CRM initiative to establish integrated processes spanning customer acquisition and customer servicing. They have selected Siebel CRM as its technology platform for the Company. TCS team is involved in the Implementation of Siebel Call Center application covering the functional areas of Sales, Service and Marketing for various areas of Requirement. For this Siebel CRM implementation including all the functional areas BI Applications has been used to build reports for analysis. Dataware housing has been done using ETL tool Informatica and scheduler tool DAC to execute the workflows.

Roles and Responsibilities:
Role: ETL Developer
• Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Oracle transformed based on business requirements and loaded to Data Warehouse.
• Well acquainted with Informatica mappings and mapplets and also tuned
them for Optimum performance, Dependencies and Batch Design.
• Worked extensively on different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizer.
• Loaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.
• Lead definition, execution, and communication of ETL strategy, design and processes to support the EDW environment.
• Established and ensured appropriate data quality and ETL metrics are defined, monitored and managed.
• Migrated Test Code from Development to QA and QA to Production of Repository,
Dashboard Reports, Informatica mappings and workflows and DAC entities.
• Validated the data/Reports each and every time a migration occurs from Dev to QA and QA to Production environment.
• Responsible for updating/ tracking and documenting the development changes at both ETL level.
• Configured new tasks, parameter files and Execution Plan in DAC for incremental and full load.
• Streamlined the Execution Plans with their respective tasks in DAC.
• Maintained and monitored the Full and Incremental loads through DAC on different environments like Development, QA and Production environment.
• Actively resolved the issues and defects raised by the tester during SIT and UAT testing phases.
• Developed physical and logical star schema using OBIEE administration tool.
• Developed OBIEE Repository (.rpd) with all the three layers: Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Developed dimensional hierarchies based on the business requirement of an attribute.
• Used the Expression Builder utility to configure new logical columns in the BMM layer and configured various calculation measures.
• Customized business reports using BI Answers as per requirements. Developed, configured and tested report in the Dashboard and configured the adhoc report according to the client needs.

Qualifications & Certifications

BTECH, Computer Science

SASTRA UNIVERSITY

SVCH SCHOOL

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Padmini Rayavaram provides the following services:


Supported Countries
Choose your country

×