VSAN Prasad Ravuri

ac1yi9@r.postjobfree.com

Cell: 651-***-****

PROFESSIONAL SUMMARY

Nine plus (9+) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Healthcare Device, State Government, Financial and Manufacturing Sectors.

Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.

Strong Data Warehousing ETL experience of using Informatica 9.1/9.5 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.

Expertise in Data Warehouse/Data mart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling.

Expertise in working with relational databases such as Oracle 11g/10g/9i, SQL Server 2008/2005, DB2 7.0.

Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.

Experience in using Automation Scheduling tools like Control-M.

Worked extensively with slowly changing dimensions.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

Strong skills in PL/SQL Development.

Experience creating multiple PL/SQL stored procedures, functions, views, triggers, oracle schemas to process large sets of data as per business requirements.

Experience in ETL data conversion to SAP-Centre piece environment.

Experience in Agile and Waterfall methodologies.

Extensive experience as Oracle PL/SQL Developer for System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g & 11g in Production, Staging, Development environment.

PL/SQL: 9+years of experience in using the SQL queries to manipulate the business flow and save the business data across different levels and created multiple PL/SQL stored procedures, functions, views, triggers, oracle schemas to process the data as per business requirements.

ETL:4+ years of experience using Informatica Power center and SAP LSMW programs to load data from source to target systems. Experience in handling over 10 million records.

OBIEE:1 year of experience using OBIEE to generate reports after ETL conversion.

UNIX: Responsibilities include design, development, testing & Implementation of EDW daily receive pre-processing (UNIX Shell Scripts), de-normalization for reporting purpose, data security issues, testing of data for the developed modules.

C#: 3 years of C# programming experience to create windows based services to process and create xmls for order processing.

Java: 1 year experience in java programming to debug and analyze issues with production order processing websites which includes quartz jobs, hibernate and spring framework.

AppResponsexpert: Expert in using this tool to identify the performance of data flow across different servers.

Proven complex queries writing, record tracking and conducting performance tuning.

Experience in Agile and Waterfall methodologies.

Team-player and excellent Inter-Personal skills.

Excellent analytical, quantitative and trouble-shooting skills, along with good presentation and leadership skills.

EDUCATION

First class with Distinction in Master of Computer Applications (MCA), Acharya Nagarjuna University, India 2007 Passed out.

TECHNICAL TOOLS

Operating Systems : Win 9X/2000/2003/XP, Linux, Unix.

Database Tools : Oracle SQL Developer 4.1.3, Toad 9.0.

ETL Tools : Informatica Power Center 9.1.0/9.5.1 (Designer, Workflow

Manager, Workflow Monitor, Repository manager and Informatica Server).

Monitoring Tools : App Response Xpert.

Testing Tools : HP Quality Center, Load Runner, Jira.

Languages : SQL, PL SQL, C, UNIX Shell Script.

Databases : Oracle11G/10G,9i, Microsoft SQL Server 2008/2005, MySQL.

Network Protocols : TCP/IP, HTTP, HTTPS, VPN, FTP and LDAP

Domains worked on : Health care Devices, Financial, State Government, Manufacturing

MS OFFICE : MS Excel, MS Word, MS PowerPoint, MS Project

CERTIFICATIONS

IZO-007 introduction to Oracle9i.

1Z0-591 Oracle Business Intelligence Foundation Suite 11g Essentials.

WORK EXPERIENCE

Medtronic, MN Feb-2016 – till date

Sr. ETL/Informatica Developer.

Migration of Covidien systems-Cgens

As part of migrating Covidien to Medtronic we need to ETL data from Covidien different system to Medtronic SAP system.

Responsibilities:

Involved in identifying requirement with business to make them understand the target SAP system and define the requirements as needed.

Create the Design document with data model diagrams and data flows.

Preparing the load process document for detailed understanding of data load.

Developed different sql queries, pl/sql blocks used Informatica to run different sql statements continuously to finish the transformation logic.

Used informatica workflows to load the data from source to stage environment then flow through different transformation logics for target table loads and to generate the load files from the target tables.

Used LSMW program from SAP to load the data to SAP.

Co-ordinated with Sap LSMW development team to write the correct LSMW program for clear understanding and clean load of data to SAP system.

Working on 10 million records to load the data from source to target systems.

Working in UNIX environment to move the load files from informatica server to SAP server and downloading the data from source system.

Written shall script to make sure the LSMW logs can be segregated in a meaningful manner.

Used the defect tracking system as HPQC.

Working on creation of different workflows for the generation of retrieving data from SAP to stage environment and reconciling the loaded data.

Working on different SAP centerpiece functionalities to validate the loaded data.

Coordinated with different module teams of SAP to load the data accurately as we need to make sure dependent conversions load the data as needed.

Created the Data model like star schema and snowflake schemas using Erwin tool to design business process.

Created different type 2 slowly changing dimensions with fact tables to understanding the legacy history of data in data warehouse environment.

As new products are moved to the new system to differentiate the plants and products comparing from covidien system to the Medtronic system create the data rehouse environment and loaded the data for better understanding of products and plant information to the end users.

Continuously getting multiple appreciation emails from business as worked beyond the expectations to make sure the data load happens smoothly and accurately.

Environment: Toad 9.0, Erwin, Oracle 11g, PL/SQL, Informatica Powercenter 9.5.1, Windows 7, HpQuality Center (Defect tracking tool), Unix Shell Scripts.

State of Minnesota – Pollution Control. May 2014 – Feb 2016

Sr. ETL/Informatica Consultant.

Tempo Transformation.

This project is to upgrade the existing tempo system used by pollution control Agency to new system to move data from old system to new system.

Responsibilities:

•Closely Involved in Requirement Analysis, Design, development and testing phases.

•Prepared the Design Documentation like High Level and Low Level Design documents.

•Wrote different functions to calculate the late fee for pollution control.

•Created Data warehouse with start and snowflake schemas to create the better reporting environment for pollution control Agency.

•Created different dimensions and facts for understanding the pollution control agency fines with different pollution causing factories and also understanding the trend of air pollution in different areas.

•Used the Tableau desktop to create the simple report of identifying the trending of air pollution using the data warehouse.

•Wrote Auto Id Generation functions with “PRAGMA AUTONOMOUS_TRANSACTION” to commit or rollback the updates or inserts made while generating the new ids.

•Used joins and nested subqueries to retrieve the data from different tables.

•Created and modified schemas, procedures, functions, views, indexes, triggers to accomplish the new changes.

•As one of the major activities we were copying data from oracle9i to oracle11g.

•As part of the process we need to write sql/plsql to Extract the data from old system and Transform the data as required for the target system and load the data to target system.

•Closely working with business teams to understand the different levels of Transformation to match up the target system.

•As the old system is legacy and pollution control maintains huge amounts of data we were loading the data to target systems in bulk.

•Did debugging and validated the explain plan to improve the performance of data copy down.

•Used different Analytical functions to achieve the reporting requirements.

•Used BULK COLLECT and FOR ALL to avoid the context switching with pl/sql code.

•Checked the query execution process using Explain Plan and modified the queries using the plan.

•Used different Hints to increase the query performance.

•Build and release management of integrated application.

•Worked on Partitioning of tables and created indexes on partitions.

•Coordinating code builds between environments.

•Closely involved in performance testing to validate and improve the performance of pl/sql blocks.

Environment: SQL Developer 4.1.3, Oracle 11g, Informatica Powercenter 9.1.0, PL/SQL, PowerBuilder, Windows 7, Quality Center (Defect tracking tool), Tableau 9.3.

Deluxe Corporation, MN. November 2013 – May 2014

ETL Informatica Developer

Checks by Deluxe

This project is to provide the functionality of route the checks by deluxe orders through new financial services order entry system.

Responsibilities:

Involved in different phases of project life cycle like Analysis, Design, Development, Unit testing, QA Support, UAT Support and implementation of requirements using waterfall method.

Prepared the Design Documentation like High Level and Low Level Design documents.

Used Power Designer tool for Designing the new tables and modification of existing tables as part of fulfilling the data modeling requirements.

Created different slowly changing dimensions with facts to understand the different types of checks and its percentage of sales to understand the sale trend after checks by deluxe project.

In this project, we used different database to extract the data as the orders can come through different order placing systems and stored and different transactional databases like oracle and sql server databases.

Used IBM tool for debugging in identify the root cause of the issues.

Used joins and nested subqueries to retrieve the data from different tables.

Created and modified schemas, procedures, functions, views, indexes, triggers to accomplish the new changes.

Used different Analytical functions to achieve the reporting requirements.

Used BULK COLLECT and FOR ALL to avoid the context switching with pl/sql code.

Checked the query execution process using Explain Plan and modified the queries using the plan.

Handled large sets of data flowing across different systems to ensure the checks are manufactured successfully as per the order placed.

Used different Hints to increase the query performance.

Build and release management of integrated application.

Worked on Partitioning of tables and created indexes on partitions.

Used control - M tool to configure the new jobs.

Coordinating code builds between environments.

Providing on-call support for production roll out.

Modified few Database interaction files in C#.

Supported Different issues in ChecksByDeluxe place order website developed in JAVA to avoid any delay in cod delivery.

Closely involved in performance testing to validate and improve the performance of pl/sql blocks.

Environment: Informatica Powercenter 9.1.0, UNIX AIX OS, C#, Java, TOAD 9.0, EditPlus, SQL Developer 4.1.3, Oracle 11g/9i, Appresponse Expert, PL/SQL, Putty, PowerBuilder, Windows XP, Quality Center (Defect tracking tool), Microsoft SQL Server 2008,

Deluxe Corporation, MN January 2013 –October 2013

ETL/Informatica/Pl/SQL Developer

BRINKS

This project deals with providing the High security checks with additional features. All different types of existing checks need to be substituted based on fi and product participation.

Responsibilities:

Implementation of new checks by substituting the existing checks with fi and product validation rules.

Key role in deciding the aspects of implementation against business requirements on existing application.

Conducted sessions with clients for requirement clarification and design finalization.

Participated in requirements gathering and analyzed the scope of the requirements and conducted code walk-throughs and inspections.

Involved in database design in data warehouse environment as the new security feature enabled with different existing fraud protection systems.

Using the different dimensions and facts to understand different checks orders with different security protection and fraud protection features.

As Deluxe management wants to understand the usage of the service to understand the money and effort put on the service.

Worked in production support after scheduling the informatica job for loading the data to the data warehouse environment.

Monitoring of control-M jobs running the data warehouse environment in case of any failures re-running the jobs to continue the flow of data load by validating the dependencies.

Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data

Worked on portioning the tables and created indexes on partitions

Used different set operators in PL/SQL like Union, Union all, Intersect and Minus for querying and joining tables

Created/Modified the PL/SQL procedures, functions, views, Indexes, Triggers and packages for accommodating new changes

Used BULK COLLECT and FORALL to decrease the context switching over the execution of pl/sql code

Used Joins and nested sub-queries to get the data from multiple tables.

Developed different shell scripts to notify the business users about the statistics of orders in applying pony express service differentiating between successful orders, queue struck orders in different stages of manufacturing.

Modified several reporting UNIX shell and PL/SQL scripts to meet new business requirements. Also, identified the implementation problems on the existing application and provided new shell scripts that replaced the age-old scripts and are successfully implemented in production.

Responsible for promoting code among development, testing, UAT, XUAT, pre-prod and production environments

Formulated unit test cases covering all the scenarios in addition to teams’ test cases to make sure of no slippage of any requirement and its dependencies.

Environment: UNIX OS, C, TOAD 9.0, EditPlus, Informatica Powercenter 9.1.0, SQL Developer 4.1.3, Oracle 9i, Appresponse Expert, PL/SQL, Putty, PowerBuilder, Windows XP, Quality Center (Defect tracking tool), Control-M.

Deluxe Corporation, MN March 2012 – December 2012

PL/SQL Developer

PONYEXPRESS

This project deals with creating a new delivery method to increase tracking capabilities thereby obtaining extra revenue as value added service from customers.

Responsibilities:

Implementation of new shipment method with extra tracking information to the customers.

Key role in deciding the aspects of implementation against business requirements on existing application.

Conducted sessions with clients for requirement clarification and design finalization.

Participated in requirements gathering and analyzed the scope of the requirements and conducted code walk-throughs and inspections.

Worked with AppResponseExpert to identify the performance of data flow across different servers and provided analysis to the client on server performance upon each deployment and compared the responses that helped in decisions.

Developed several PL/SQL procedures to update/insert different service specific operations like any additional charges if third party enrolls for pony express, implementing pony express but not displaying in check out page etc.

Implemented and scheduled scripts to analyze the revenue difference before and after implementation of pony express service which proved to be very beneficial at management level.

XML is used in maintaining exchange of a large array of data on the Web.

Implemented queuing theory to work with different automation tools like Control-M and Autosys job automation tools.

Developed different shell scripts to notify the business users about the statistics of orders in applying pony express service differentiating between successful orders, queue struck orders in different stages of manufacturing.

Modified C programs and files to differentiate between different types of service and bill accordingly.

Modified several reporting UNIX shell and PL/SQL scripts to meet new business requirements. Also, identified the implementation problems on the existing application and provided new shell scripts that replaced the age-old scripts and are successfully implemented in production.

Modified and created c programs to meet the business requirements.

Responsible for promoting code among development, testing, UAT, XUAT, pre-prod and production environments

Deluxe witnessed a huge spike in its revenue because of big success of this project and awarded “Best Implementation Lead” award for leading this project very successfully.

Environment: UNIX OS, C, TOAD, EditPlus, SQL Developer, Oracle 9i, Appresponse Expert, PL/SQL, Putty, PowerBuilder, Windows XP, Quality Center (Defect tracking tool), Microsoft SQL Server.

Deluxe Corporation, MN May 2008 – February2012

Pl/Sql Developer

CI TO POMS

Customer Interface (CI) is an intermediary system to process orders placed from different order entry channels (like Orderpro, oneplus, AOE etc.) to manufacturing system. Previously, all the orders were routed to Manufacturing Order Management System (MOMS) which involves lot of human intervention. Deluxe has set up a new manufacturing system called Production Order Management System (POMS) and has direct all orders to this system. This reduces human effort many folds and increases the revenue. This project deals with change of order manufacturing and routing process from MOMS to POMS.

Responsibilities

•Analysis of requirements from root as it was a big project requiring entire transfer of the systems.

•Organized sessions and discussions with clients and submitted work reports with detailed information that impressed clients very much and also helped in smooth phase wise deliveries.

•Modified the C programs and PL/SQL files to route the orders to different manufacturing system (POMS) which was a very hard task.

•Experience in supporting SSRS reports and verifying report data against database.

•Made use of Sub-Query Factoring (WITH clause) to make complex SQL statements simple and make them more efficient

•Using set operators in PL/SQL like Union, Union all, Intersect and Minus

•Developed the changes across the system to Route the orders from MOMS to POMS.

•Moved the order entry system from MOMS to POMS which reduced lot of manual work that in turn increased the revenue and fetched huge profits.

•CI (Customer Interface) TO CMP is a huge project because MOMS produces 3/4th of orders before, and my team has done changes to route those orders through automated CMP process.

•PowerBuilder was used to design the customer interface that processes orders from many entry channels.

•Modified c programs, shell scripts and PL/SQL procedures to meet the new automated version from manual version which was a great challenge and I was able to meet the challenge very successfully and received many applauds for leading the team.

•Successfully led the team of 8 members throughout the project and guided and helped them in tough times and achieved a milestone with individual focus and team effort.

Environment: UNIX OS, C, TOAD, EditPlus, SQL Developer, Oracle 9i, Appresponse Expert, PL/SQL, Putty, Windows XP/2003, Gemini (Defect tracking tool), Remedy-Production Defect Tracking System, Microsoft SQL Server.

Contact this candidate