Venkata Seshubabu Adusumalli

ETL Informatica Developer

acq8lt@r.postjobfree.com

984-***-****

PROFESSIONAL SUMMARY

•4 yrs. 8 months of IT experience in Software Analysis, Development, Implementation of business applications for HealthCare, E-Commerce and Telecom verticals.

•4+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.6/9.1/8.6 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.

•Expertise in Analysis, Design, Development and Implementation.

•Working Experience in Informatica, Cognos,SQL,PL/SQL,Unix.

•Ensure success of the project by taking ownership of deliverables and assist/perform analysis, testing or other tasks as necessary.

•Quickly adapting to the new environment and ability to learn new technologies.

•To work with positive attitude, analyzing all kinds of situation with efforts.

•Ability to interface and communicate effectively with team members and provide the guidance in the development activity.

•Good Experience in creating Transformations and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

•Involved in creating the technical specifications and high level Design documents.

•Responsible for developing Reports using Cognos 10 in Report Studio.

•Developed Standard Reports, List Reports, Cross-tab reports, Drill through reports and Master Detail reports using Report Studio.

•Attending Status meetings and daily scrum calls with the client and Business Users.

•All Phases Testing like Unit testing, QA Testing, Regression testing and UAT.

TECHNICAL SKILLS

Data Warehousing

Informatica Power Center 9.5/8.6/7.1

Mapping Designer, Work flow management tools, SAP DS

Business Intelligence

Cognos 8.1/10.1

Data Modeling

Erwin 4.3/3.5, Star-Schema Modeling, Snowflakes Modeling, FACT & Dimension Modelling.

Database

Oracle,SQL

GUI/ DB Utilities

SQL* Loader, TOAD 6.5/7.0, PL/SQL Developer

Job Schedulers

Autosys, Informatica Scheduler

Languages

JAVA,XML,SQL

Operating Systems

Unix, Linux,Windows

Version Control

Tortoise SVN (Versioning Tool),CVS

EMPLOYMENT HISTORY

•Currently working as Application Developer for ORACLE India Pvt Ltd from Dec 2014 to till date

•Worked as Analyst System Dev for VERIZON from Nov 2010 to Nov 2014.

PROFESSIONAL EXPERIENCE

OHA Data Integrator Dec 2014 to Till Date

Oracle IDC, Bangalore

Responsibilities:

•Working as an individual contributor at Oracle IDC Bangalore and involved in:

•Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.

•Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.

•Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.

•Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.

•Reviewed source systems and proposed data acquisition strategy.

•Designed and Customized data models for Data Mart supporting data from multiple sources on real time.

•Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.

•Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

•Created Mapplet and used them in different Mappings.

•Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

•Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.

•Performance tuning using round robin, hash auto key, Key range partitioning.

•Used shell scripts for automating the execution of maps.

Environment: Informatica Power Center 9.6/9.5,Oracle 11g/12c, SQL, UNIX,SVN

SFS Reporting and Analytics Jun2013 to Nov 2014

Verizon Wireless, Hyderabad

Logility is an ERP System, extract data from Inventory and Sales using different applications perform analysis and generate forecasted Data for Sales and Inventory. Data will be loaded from Logility to stating daily, staging archive and Data Warehouse using Informatica.All reference data will be looked up and transformed in SFS Report,and aggregate data will be loaded into target tables. These tables will be used by Cognos packages and Reports for generating required metrics. These metrics and reports have been used by the Business in performing Business Intelligence and Analytics on Ship From Store Model.

Responsibilities:

•Worked as Sr. Informatica Developer and involved in:

•Used ETL to extract and load data from Oracle, Flat Files to Oracle DWH.

•Involved in Analysis, Documentation and Testing of workflows.

•Debug the Informatica mappings and validate the data in the target tables once it was loaded with mappings.

•Created and Monitored Work Flows using Workflow Manager and Work Flow Monitor.

•Created Workflows / Worklets and scheduled them using workflow manager.

•Worked extensively on different types of transformations like Update Strategy, Look Up, Filter and Router Transformations.

•Developed Mapping to load data in Slowly Changing Dimensions.

•Ensuring proper Dependencies and Proper running of loads (Incremental and Complete loads)

•Maintaining the OLAP system to provide quality data to support DSS.

•Involved in design of ETL processes using Informatica ETL tool to load data from heterogeneous Source System like Flat Files,SQL Server,Teradata and ORACLE. Responsible for developing Reports using Cognos 10 in Report Studio.

•Developed Standard Reports,List Reports,Cross-tab reports,Drill through reports and Master Detail reports using Report Studio.

•Attending Status meetings and daily scrum calls with the client and Business Users.

•All Phases Testing like Unit testing, QA Testing, Regression testing and UAT.

Environment: Informatica Power Center 9.1,Oracle 11g, SQL, UNIX,SVN

SCM Dashboard Feb 2012 to Jun 2013

Verizon Wireless, Hyderabad

Supply chain Management consists of Sales and operations, pricing, Analytics & Inventory management. It mainly focuses on business transformation process analysis & operational benefits projects to organization. This project will process historical data using ETL Jobs, feeds to Dashboard, generate the required reports and data conversion using EDI tools. Device Management Database (DMD) and Verizon Wireless Integrated Inventory Application are used by all internal and external clients to retrieve device details and availability.

Responsibilities:

•Worked as Sr. Informatica Developer and involved in:

•Understanding the Requirements and performing the development scope analysis.

•Involved in Analysis, Documentation and Testing of workflows.

•Debug the Informatica mappings and validate the data in the target tables once it was loaded with mappings.

•Developed Informatica Mappings to capture data changes from the operational sources systems into data warehouse and data marts (SCD mappings).

•Created Various Complex Transformations such as Update Strategy, Look Up, Filter and Router Transformations.

•Created complex mappings using Unconnected lookup,Sorter, Aggregator,newly changed dynamic lookup and Router transformations for populating target table in efficient manner.

•Creating the Staging Area and loading raw data to cleanse it over there.

•Developed mappings, sessions and workflows (ETL) for SCD types I and II to meet the above requirements.

•Involved in the requirement study and understanding the functionalities.

•Ability to interface and communicate effectively with team members and provide the guidance in the development activity.

•Used Windows scripting and scheduled pmcmd to interact with Informatica server from Command mode.

Environment: Informatica Power Center 8.6.1,Oracle 11g, SQL, UNIX,SVN

Sales and Operations Dec 2010 to Feb 2012

Verizon Wireless, Hyderabad

Sales & Operations Planning (S&OP) is set of decision-making processes to balance demand and supply, to integrate financial planning and operational planning,and to link high level strategic plans with day-to-day operations. Spinnaker will architect future state business process and JDA provide S&OP to support the process. Achieve Supply/demand balance to maximize profitability while meeting financial controls. Improve Service Level,reduce working capital and effectively meet subsidy/budget targets .Collaborative and data driven decision making approach with Inventory Metric reports.

Responsibilities:

•Worked as Sr. Informatica Developer and involved in:

•Used ETL to extract and load data from Oracle, Flat Files to Oracle DWH.

•Developed Informatica Mappings to capture data changes from the operational sources systems into data warehouse and data marts (SCD mappings).

•Created Various Complex Transformations such as Update Strategy, Look Up, Filter and Router Transformations.

•Created basic and aggregate levels of Fact Table mapping and optimized them for incremental Extraction and Aggregation using Parameters and variables to pass values during workflow execution.

•Created and Monitored Work Flows using Workflow Manager and Work Flow Monitor. Involved in the development and implementation of the Enterprise Data Warehousing (EDW) process and Data Warehouse.

•Created Workflows / Worklets and scheduled them using workflow manager.

•Developed Mapping to load data in Slowly Changing Dimensions.

•Ensuring proper Dependencies and Proper running of loads (Incremental and Complete loads)

•Perform Tuning of Sessions and Mappings

Environment: Informatica Power Center 8.6.1, Oracle 11g, SQL, UNIX,SVN

PERSONAL DETAIL

•Full Name : Venkata Seshubabu Adusumalli

•Father Name : Chiranjeevi

•Pan Card No : AUGPA5559A

•Date Of Birth : April 1st 1986

•Email Id : acq8lt@r.postjobfree.com

•Mobile : +91-984*******

Contact this candidate