Y P Raju_dwh_resume
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Y P Raju_dwh_resume as PDF for free.
More details
- Words: 1,768
- Pages: 7
DWH - BI - INFORMATICA - PL/SQL-ANALYST Company
: Global ERP Solutions Inc.
Name Email Id Mobile no Location
: : : :
PenchalaRaju.Yanamala [email protected]. +91 9676447835. Hyderabad.
Profile:-
•
A highly Challenging role in ‘Data Warehousing’, where I can apply my Creative, Analytical Developing skills Experience to the Organization. To always strive hard and thrive on Challenging situations and do better than the best. Professional Summary:-
•
4.4 years of total IT Experience in Data Loading, Analysis, Design, Development, and Coding by using Various Technologies like Informatica Power Center, Microstrategy and Oracle in Data Warehousing.
•
3.6 years of Development and Coding Experience on ETL processes by using Informatica Power Center 8.6.0 & Oracle 10g like PL/SQL Coding, Shell Scripting on UNIX Platform.
•
10 Months of Development Experience on Public Objects & Schema Objects - Facts , Attributes Creating and Generating the Reports by using BI tool like Microstrategy 8.0.1.
•
Developing ETL processes like Data Extraction, Transformation, and Loading using various Versions like Informatica Power Center 7.1.1 and 8.6.0. • Extensively worked on Informatica Power Center Designer, Workflow Manager and Workflow Monitor tools. • Strong Knowledge on ETL tool like Informatica and Clear understanding of Software Development Life Cycle (SDLC) in Data Warehousing. • Have clear understanding of Data warehousing Concepts like BI, Star Schema, Snowflake Schema, OLTP, OLAP, Staging Area and ODS.
•
Extensively worked on third party tool like TOAD, SQL*PLUS and PL/SQL Developer.
•
Good Knowledge on RDBMS Concepts in Oracle and Business Intelligence tool like Microstrategy 8.0.1and Data modeling tool like Erwin. My Strengths:• Ability to work with any Environment based on client requirement and Ability to interaction with Client regularly.
•
Ability to manage project issues and Risks, Deliver work on time with multiple, competing priorities.
DWH - BI - INFORMATICA - PL/SQL-ANALYST
•
Ability to work in a team or individual and handling multiple tasks simultaneously and Ability To pickup new skills quickly. •
Good Analytical and Strong Interpersonal skills and Excellent Communication skills.
Work Experience:-
•
Working as an ETL Analyst at GLOBAL ERP Solutions Inc, Hyderabad from August’05 TO till date.
•
Worked as an ETL Consultant at Keane India Ltd, Hyderabad from July’07 TO November’08. Qualification:-
•
Bachelor of Computer Science from Sri Venkateswara University in 2004. Technical Skills:ETL Tool.
Informatica Power Center 7.1.1, 8.1.1 and 8.6.0.
Reporting Tool.
Microstrategy 8.0.1 and Cognos 8.0.
Data modeling Tool.
Erwin.
Databases & Tools.
Oracle 8i,9i and 10g (SQL*Plus,PL/SQL with Stored Procedures) SQL Server 2005 & TOAD.
Operating Systems.
Windows 2000/ NT/ XP. Unix Shell Scripting.
Languages.
C, C++ and Cobal.
Packages.
MS OFFICE (MS Word, MS Excel, MS Access).
Business Areas.
Banking, Insurance, Sales and Retail.
Project Experience:Project #1 US BANK Inc, USA.
December’08 TO till date.
Project: Financial Services Warehouse. Team Size: 4. ETL Analyst. GLOBAL ERP Solutions Inc, Hyderabad. Description: U.S. Bank is a subsidiary of Bancshares, Inc. it is a $242 billion in assets and the 6th largest commercial bank in the United States. The company operates 2,522 banking offices and 4,844 ATMs, and the Company provides a comprehensive line of banking, brokerage, insurance, investment, mortgage, trust, retail, commercial and financial products and payment services products to consumers. The bank needs to build data warehousing and the purpose of the implementation is to understand the trends, performance and customer analysis of the Bank. Subject areas covered in the warehouse are Accounts like Savings bank Account, Current Account, Loan
DWH - BI - INFORMATICA - PL/SQL-ANALYST
Account and Over Draft Account. Loans like Personal Loan, Educational Loan, Industrial Loan, and House Loan etc. Deposits like Fixed Deposits, Recurring Deposits Promotions like Seasonal, Banking Loan. As required a Data Warehousing was designed, developed, implemented and maintained defining data marts for each line of business.
Responsibilities:-
Understanding the Customer Requirements and the Technical Specifications Documents.
Extraction of data from Different Sources like Oracle, SQL server, Cobal and Flat files.
Integration of Different Source data in Staging Area by using ETL process like Data Merging, Data Cleansing and Data Aggregation.
Design, Develop and Implementation of Informatica Mappings and Workflows.
Creation of Mappings using Different Transformations like Source Qualifier, Joiner, Expression, Aggregator, Router, Sorter, Lookup and Update Strategy Transformation.
Used SQL Queries, different properties in Transformations.
Involved in performance tuning on Informatica like Session level and Mapping level.
Creating the Workflow and Running the Workflow by using Workflow Manager.
Involved in Unit test plans and Performing Unit Testing on ETL Mappings and Workflows.
Preparation of Design Documents, Test Cases and Test Scripts.
Validating the Required data at the database level by using 3rd party tool like TOAD.
Files data move to another Server by using FTP on UNIX Platform.
Open to play the role of independent contributor in handling a complex task.
Playing an effective team member’s role in the team of 4. Environment: Informatica Power Center 8.6.0, Oracle 10g (SQL, PL/SQL), TOAD, and UNIX. Project #2 Allmerica Technology Inc, USA.
July’07 TO November’08 (17m).
Project: Hanover Insurance Group. Team Size: 8. ETL Consultant. Keane India Ltd, Hyderabad. Description: This is a strategic initiative to adhere to the personal lines guiding principle of maintaining and rating on verifiable data. As an improvement to the quality of data being captured for Connections rating. They want to solicit from 3rd party vendors a validation of
DWH - BI - INFORMATICA - PL/SQL-ANALYST
the data to ensure the accuracy. Their current process, although satisfying the guiding principal, is cumbersome and time consuming. Choice Point has a product offering that utilizes an internal database of current carrier policy information. The product offering has two steps. First, each carrier customer must contribute in-force policy information – both an initial load of all policies within the line of business being solicited. After that load any transactional updates must be reported.
Responsibilities:-
Understanding the Technical Specifications Documents and providing KT.
Extraction of data from Different Sources like Oracle and Flat files.
Integration of Different Source data in Staging Area by using ETL process like Data Merging, Data Cleansing and Data Aggregation.
Creating Mappings using Different Transformations like Source Qualifier, Joiner, Expression, Aggregator and Lookup Transformations.
Used SQL Queries, different properties in Transformations.
Creating of Sessions according Business logics by using Task Developer.
Creating the Workflow and Running the Workflow by using Workflow Manager.
Involved in performance tuning on Informatica like Session level and Mapping level.
Involved in Unit test plans and Performing Unit Testing like Quantitative Testing and Qualitative Testing.
Validating the Required data at the database level by using 3rd party tool like TOAD.
All Mappings & workflows succeeded in Testing Environment move from Development to Production Environment.
Open to play the role of independent contributor in handling a complex task.
Played an effective team member’s role in the team of 8. Environment: Informatica Power Center 8.1.1, Oracle 9i (SQL, PL/SQL), TOAD, and UNIX. Project #3 Roamware Inc, Atlanta. Project: Customer Business Management. Team Size: 5. MSTR Analyst. GLOBAL ERP Solutions Inc, Hyderabad.
August’06 TO June’07 (10m).
DWH - BI - INFORMATICA - PL/SQL-ANALYST Description: The application is Customer Business Management, of a Company that keeps track of the Assets, which are given to lease. The source system is capable of accepting request for Assets and processes it, when there is an Exception then it is the Analyst duty to manually process that request. The company want to keep track of what sort of exception are Raised, to reduce the number of exceptions so, as to reduce the burden on analyst. This is implemented using tool like Informatica Power Center and Oracle PL/SQL with SP then to load the Data Warehouse.
Responsibilities:-
Understanding the Customer Requirements and the Technical Specifications Documents.
Creating Attributes, Facts, Tables and Hierarchies by using Schema Objects.
Creating Filters, Prompts, Metrics, Reports and Drill Maps by using Public Objects.
Migrating the Objects and Reports to Production, through Object Manager.
Interact with Users, Business Analysts, ETL Developers, Project Managers, and QA Analysts and production support teams.
Involved Adhoc Report, Custom groups and Consolidations Dashboards for Reports.
Involved on performance tuning in Microstrategy Level.
Coordinate and Deploy MSTR Report changes between Different Environments.
Validating the Required data at the database level by using 3rd party tool like TOAD.
Playing an effective team member’s role in the team of 5. Environment: Microstrategy 8.0.1, Oracle 9i (SQL), TOAD and XP. Project #4 Avis Car Travels, USA. Project: Sales Distribution System. Team Size: 12. ETL Developer. GLOBAL ERP Solutions Inc, Hyderabad.
August’05 TO July’06 (12m).
Description: This system is to enter Journal Entry Transactions. This application allows User to enter, validate the Journal Entries. Each user is allowed to enter the data by using User Id and Password. The Reports are generated to enable the Users to know about the data and also allow the Administrators to control the system. Users can upload large data by using Excel Spreadsheets, which is the special feature in this system.
DWH - BI - INFORMATICA - PL/SQL-ANALYST
The Functional and Transactional purpose of the back end process is to validate the data entered in conjunction with data from the custom tables. The Company develops these Tables, which are invoked by the Packages, Stored Procedures, Functions, and Triggers. Responsibilities:-
Understanding the Customer Requirements and the Technical specifications Documents. Extraction of data from Different Sources like Oracle and Flat files.
Creation of Mappings using Different Transformations like Joiner, Filter, Router, Lookups (Connected & unconnected) and Aggregation Transformations.
Extensively used Designer Tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation developer.
Development and Testing, Performance Tuning of Mappings. Creation of Sessions & Batches to Schedule ETL Mappings. Preparation of Design Documents, Test Cases and Test Scripts. Involved in PL/SQL Coding like Stored Procedures, Triggers and Packages
Validating the Required data at the database level by using 3rd party tool like TOAD. Played an effective team member’s role in the team of 12. Environment: Informatica Power Center 7.1.1, Oracle 9i (SQL, PL/SQL), TOAD, and XP. **** Personal Profile:Full Name
: PenchalaRaju.Yanamala.
Father Name
: Penchalaiah (China) .Y
Date of Birth
: 23/06/1981.
Passport
: Availability.
Martial status
: Single.
Nationality
: Indian.
Current Company
: Global ERP Solutions Inc
Work Location
: Hyderabad.
Designation
: Software Engineer.
Role
: ETL Analyst.
Total Experience
: 4.4 Years.
ETL Experience
: 3.6 Years.
Mobile no
: +91 9676447835.
DWH - BI - INFORMATICA - PL/SQL-ANALYST …………………………@…………………………
: Global ERP Solutions Inc.
Name Email Id Mobile no Location
: : : :
PenchalaRaju.Yanamala [email protected]. +91 9676447835. Hyderabad.
Profile:-
•
A highly Challenging role in ‘Data Warehousing’, where I can apply my Creative, Analytical Developing skills Experience to the Organization. To always strive hard and thrive on Challenging situations and do better than the best. Professional Summary:-
•
4.4 years of total IT Experience in Data Loading, Analysis, Design, Development, and Coding by using Various Technologies like Informatica Power Center, Microstrategy and Oracle in Data Warehousing.
•
3.6 years of Development and Coding Experience on ETL processes by using Informatica Power Center 8.6.0 & Oracle 10g like PL/SQL Coding, Shell Scripting on UNIX Platform.
•
10 Months of Development Experience on Public Objects & Schema Objects - Facts , Attributes Creating and Generating the Reports by using BI tool like Microstrategy 8.0.1.
•
Developing ETL processes like Data Extraction, Transformation, and Loading using various Versions like Informatica Power Center 7.1.1 and 8.6.0. • Extensively worked on Informatica Power Center Designer, Workflow Manager and Workflow Monitor tools. • Strong Knowledge on ETL tool like Informatica and Clear understanding of Software Development Life Cycle (SDLC) in Data Warehousing. • Have clear understanding of Data warehousing Concepts like BI, Star Schema, Snowflake Schema, OLTP, OLAP, Staging Area and ODS.
•
Extensively worked on third party tool like TOAD, SQL*PLUS and PL/SQL Developer.
•
Good Knowledge on RDBMS Concepts in Oracle and Business Intelligence tool like Microstrategy 8.0.1and Data modeling tool like Erwin. My Strengths:• Ability to work with any Environment based on client requirement and Ability to interaction with Client regularly.
•
Ability to manage project issues and Risks, Deliver work on time with multiple, competing priorities.
DWH - BI - INFORMATICA - PL/SQL-ANALYST
•
Ability to work in a team or individual and handling multiple tasks simultaneously and Ability To pickup new skills quickly. •
Good Analytical and Strong Interpersonal skills and Excellent Communication skills.
Work Experience:-
•
Working as an ETL Analyst at GLOBAL ERP Solutions Inc, Hyderabad from August’05 TO till date.
•
Worked as an ETL Consultant at Keane India Ltd, Hyderabad from July’07 TO November’08. Qualification:-
•
Bachelor of Computer Science from Sri Venkateswara University in 2004. Technical Skills:ETL Tool.
Informatica Power Center 7.1.1, 8.1.1 and 8.6.0.
Reporting Tool.
Microstrategy 8.0.1 and Cognos 8.0.
Data modeling Tool.
Erwin.
Databases & Tools.
Oracle 8i,9i and 10g (SQL*Plus,PL/SQL with Stored Procedures) SQL Server 2005 & TOAD.
Operating Systems.
Windows 2000/ NT/ XP. Unix Shell Scripting.
Languages.
C, C++ and Cobal.
Packages.
MS OFFICE (MS Word, MS Excel, MS Access).
Business Areas.
Banking, Insurance, Sales and Retail.
Project Experience:Project #1 US BANK Inc, USA.
December’08 TO till date.
Project: Financial Services Warehouse. Team Size: 4. ETL Analyst. GLOBAL ERP Solutions Inc, Hyderabad. Description: U.S. Bank is a subsidiary of Bancshares, Inc. it is a $242 billion in assets and the 6th largest commercial bank in the United States. The company operates 2,522 banking offices and 4,844 ATMs, and the Company provides a comprehensive line of banking, brokerage, insurance, investment, mortgage, trust, retail, commercial and financial products and payment services products to consumers. The bank needs to build data warehousing and the purpose of the implementation is to understand the trends, performance and customer analysis of the Bank. Subject areas covered in the warehouse are Accounts like Savings bank Account, Current Account, Loan
DWH - BI - INFORMATICA - PL/SQL-ANALYST
Account and Over Draft Account. Loans like Personal Loan, Educational Loan, Industrial Loan, and House Loan etc. Deposits like Fixed Deposits, Recurring Deposits Promotions like Seasonal, Banking Loan. As required a Data Warehousing was designed, developed, implemented and maintained defining data marts for each line of business.
Responsibilities:-
Understanding the Customer Requirements and the Technical Specifications Documents.
Extraction of data from Different Sources like Oracle, SQL server, Cobal and Flat files.
Integration of Different Source data in Staging Area by using ETL process like Data Merging, Data Cleansing and Data Aggregation.
Design, Develop and Implementation of Informatica Mappings and Workflows.
Creation of Mappings using Different Transformations like Source Qualifier, Joiner, Expression, Aggregator, Router, Sorter, Lookup and Update Strategy Transformation.
Used SQL Queries, different properties in Transformations.
Involved in performance tuning on Informatica like Session level and Mapping level.
Creating the Workflow and Running the Workflow by using Workflow Manager.
Involved in Unit test plans and Performing Unit Testing on ETL Mappings and Workflows.
Preparation of Design Documents, Test Cases and Test Scripts.
Validating the Required data at the database level by using 3rd party tool like TOAD.
Files data move to another Server by using FTP on UNIX Platform.
Open to play the role of independent contributor in handling a complex task.
Playing an effective team member’s role in the team of 4. Environment: Informatica Power Center 8.6.0, Oracle 10g (SQL, PL/SQL), TOAD, and UNIX. Project #2 Allmerica Technology Inc, USA.
July’07 TO November’08 (17m).
Project: Hanover Insurance Group. Team Size: 8. ETL Consultant. Keane India Ltd, Hyderabad. Description: This is a strategic initiative to adhere to the personal lines guiding principle of maintaining and rating on verifiable data. As an improvement to the quality of data being captured for Connections rating. They want to solicit from 3rd party vendors a validation of
DWH - BI - INFORMATICA - PL/SQL-ANALYST
the data to ensure the accuracy. Their current process, although satisfying the guiding principal, is cumbersome and time consuming. Choice Point has a product offering that utilizes an internal database of current carrier policy information. The product offering has two steps. First, each carrier customer must contribute in-force policy information – both an initial load of all policies within the line of business being solicited. After that load any transactional updates must be reported.
Responsibilities:-
Understanding the Technical Specifications Documents and providing KT.
Extraction of data from Different Sources like Oracle and Flat files.
Integration of Different Source data in Staging Area by using ETL process like Data Merging, Data Cleansing and Data Aggregation.
Creating Mappings using Different Transformations like Source Qualifier, Joiner, Expression, Aggregator and Lookup Transformations.
Used SQL Queries, different properties in Transformations.
Creating of Sessions according Business logics by using Task Developer.
Creating the Workflow and Running the Workflow by using Workflow Manager.
Involved in performance tuning on Informatica like Session level and Mapping level.
Involved in Unit test plans and Performing Unit Testing like Quantitative Testing and Qualitative Testing.
Validating the Required data at the database level by using 3rd party tool like TOAD.
All Mappings & workflows succeeded in Testing Environment move from Development to Production Environment.
Open to play the role of independent contributor in handling a complex task.
Played an effective team member’s role in the team of 8. Environment: Informatica Power Center 8.1.1, Oracle 9i (SQL, PL/SQL), TOAD, and UNIX. Project #3 Roamware Inc, Atlanta. Project: Customer Business Management. Team Size: 5. MSTR Analyst. GLOBAL ERP Solutions Inc, Hyderabad.
August’06 TO June’07 (10m).
DWH - BI - INFORMATICA - PL/SQL-ANALYST Description: The application is Customer Business Management, of a Company that keeps track of the Assets, which are given to lease. The source system is capable of accepting request for Assets and processes it, when there is an Exception then it is the Analyst duty to manually process that request. The company want to keep track of what sort of exception are Raised, to reduce the number of exceptions so, as to reduce the burden on analyst. This is implemented using tool like Informatica Power Center and Oracle PL/SQL with SP then to load the Data Warehouse.
Responsibilities:-
Understanding the Customer Requirements and the Technical Specifications Documents.
Creating Attributes, Facts, Tables and Hierarchies by using Schema Objects.
Creating Filters, Prompts, Metrics, Reports and Drill Maps by using Public Objects.
Migrating the Objects and Reports to Production, through Object Manager.
Interact with Users, Business Analysts, ETL Developers, Project Managers, and QA Analysts and production support teams.
Involved Adhoc Report, Custom groups and Consolidations Dashboards for Reports.
Involved on performance tuning in Microstrategy Level.
Coordinate and Deploy MSTR Report changes between Different Environments.
Validating the Required data at the database level by using 3rd party tool like TOAD.
Playing an effective team member’s role in the team of 5. Environment: Microstrategy 8.0.1, Oracle 9i (SQL), TOAD and XP. Project #4 Avis Car Travels, USA. Project: Sales Distribution System. Team Size: 12. ETL Developer. GLOBAL ERP Solutions Inc, Hyderabad.
August’05 TO July’06 (12m).
Description: This system is to enter Journal Entry Transactions. This application allows User to enter, validate the Journal Entries. Each user is allowed to enter the data by using User Id and Password. The Reports are generated to enable the Users to know about the data and also allow the Administrators to control the system. Users can upload large data by using Excel Spreadsheets, which is the special feature in this system.
DWH - BI - INFORMATICA - PL/SQL-ANALYST
The Functional and Transactional purpose of the back end process is to validate the data entered in conjunction with data from the custom tables. The Company develops these Tables, which are invoked by the Packages, Stored Procedures, Functions, and Triggers. Responsibilities:-
Understanding the Customer Requirements and the Technical specifications Documents. Extraction of data from Different Sources like Oracle and Flat files.
Creation of Mappings using Different Transformations like Joiner, Filter, Router, Lookups (Connected & unconnected) and Aggregation Transformations.
Extensively used Designer Tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation developer.
Development and Testing, Performance Tuning of Mappings. Creation of Sessions & Batches to Schedule ETL Mappings. Preparation of Design Documents, Test Cases and Test Scripts. Involved in PL/SQL Coding like Stored Procedures, Triggers and Packages
Validating the Required data at the database level by using 3rd party tool like TOAD. Played an effective team member’s role in the team of 12. Environment: Informatica Power Center 7.1.1, Oracle 9i (SQL, PL/SQL), TOAD, and XP. **** Personal Profile:Full Name
: PenchalaRaju.Yanamala.
Father Name
: Penchalaiah (China) .Y
Date of Birth
: 23/06/1981.
Passport
: Availability.
Martial status
: Single.
Nationality
: Indian.
Current Company
: Global ERP Solutions Inc
Work Location
: Hyderabad.
Designation
: Software Engineer.
Role
: ETL Analyst.
Total Experience
: 4.4 Years.
ETL Experience
: 3.6 Years.
Mobile no
: +91 9676447835.
DWH - BI - INFORMATICA - PL/SQL-ANALYST …………………………@…………………………
Related Documents
138 M Y P
November 2019 14
Pauta P Y Vocales
April 2020 5
Y P Raju_dwh_resume
July 2020 11
P&y Score Sheet
June 2020 5
Lectura Y Escritura P
April 2020 12
Sadi Y -p
May 2020 8More Documents from ""
Y P Raju_dwh_resume
July 2020 11
Global Erp Pay Slip For The Month Of September, 09
July 2020 20
Running Away Piano Music Sheet
June 2020 19
Do What You Want.docx
May 2020 31