Prathyush Katarpu

add8ai@r.postjobfree.com 747-***-****

Skype ID: k.prathi14

Summary

As a Business Oriented Professional eight years (8) years of total IT experience and strong background in Data Modeling, OLAP, ETL Design, Analysis, Development, Testing, Performance Tuning, Implementation, Troubleshooting and error handling in the field of Data Warehousing in ETL process using Informatica, ODI 12c/11g/10.1.3.4/10.1.3.5, Business Intelligence Applications using Oracle Business Intelligence (OBIEE), OBIEE 11G, OBIEE12c, PL-SQL, SQL Server/2008R2/2012/2014 Well experienced in all phases of System Development Life Cycle (SDLC).

Extensive development experience for the Extraction, Transformation and Loading of data from multiple sources such as Informatica, ODI,Oracle, MS SQL Server, DB2, Flat Files and XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems.

Extracted data from various sources including Oracle, SQL Server using ODI.

Used Topology Manager to create database connections, schemas, etc.,

Migrated Code from Development to Testing to production.

Extensive DW experience using Oracle Data Integrator (ODI), Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.

Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings

Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.

Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.

Developed several reusable transformations and mapplets that were used in other mappings.

Extensively worked with large Databases in Development, Testing and Production environments.

Worked on Multiple projects at same time and efficiently managed work schedules and timelines.

Extensive BI and Data warehousing experience using reporting Solutions and Informatica PC 9.0.1, 8.1/7.x/6.x.

Strong understanding of the principles of Data Warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.

Using Data Warehousing DWH tools like OBIEE, ODI.

Experience in creating ODI Packages, Procedures, Triggers for Jobs of various complexities and automated process data flow.

Extensive experience in writing stored procedures, functions and views.

Worked on performance tuning of various OBIEE Reports / Dashboard.

Create/Modify OBIEE Reports using OBIEE Answers and Dashboards.

Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool

Technical Skills

Operating Systems: Linux, UNIX, Windows 98/XP, windows 7, windows 10

ETL Tools : ODI,10.1.3.6,/11g,/12c, informatica 9.6.x, OWB 11g/10g. SQL, MSBI,

Server2008R2/2012

Web Technologies: HTML, Java Script, XML, CSS,

Language: SQL, PL/SQL, UNIX/Linux, Shell Scripting

Databases: Oracle 10g/11g/12C. DB2 and MS SQL Server 2000/2005/2008.

Other tools: Toad, SQL Navigator, SQL*Plus, SQL*Loader.

IDE: Visual Studio 2003/2005/2008R2/2012

Reporting Tools: OBIEE 11.1.1.5/11.1.1.6.12c, SSRS.

Education

Bachelor of Technology in computer science from Jawaharlal Nehru Technological University, Hyderabad, India.

Professional Experience

Los Angeles unified School District, Los Angeles Mar 2017 to Till Date Role: ETL Developer

Description:Los Angeles unified School District (LAUSD) is the largest public school system in the U.S. state of California and the 2nd largest public school district in the United States.

Responsibilities:

Design and build ETL processes (Star Schemas) and ETL for relational reporting.

Interacted with the users for requirement analysis and to define business and functional specifications.

Expertise in creating stored procedures, functions, packages, triggers, collections and bulk collections using PL/SQL.

Experience in ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.

Worked with ODI Graphical (Designer, Topology Manager, Operator and Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration, Service).

Created and maintained Process Flows and schedules for loading data into the Data Warehouse using informatica power center to migrate data from different sources and target databases,relation tables, flat files, xml files.

Experience in Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager

Utilized JIRA, BMC remedy and kept track of all the tickets assigned and cleared the tickets with in deadline.

Implemented Slowly Changing Dimensions – Type I & II in different mappings as per the requirements.

Customized ODI Knowledge modules like Loading Knowledge Modules and Integrated Knowledge Modules, check knowledge Modules, journalizing knowledge Modules.

Analysis, Design, Implementation, documentations and BI specifications that incorporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.

Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.

Implemented Success and Failure Notifications into ODI Packages.

Reverse Engineered Source and Target Data Stores using Reverse Engineering Knowledge Modules

Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings

Migrated OWB mappings to PLSQL and created procedures and packages.

Implemented CDC through ODI Journalization Knowledge Modules.

Extensive proficiency in data and object level Security in OBIEE.

Create/Modify OBIEE Reports using OBIEE Answers and Dashboards.

Creating the metadata in OBIEE RPD for reporting purpose.

Preparing Dashboards to meet the client requirement.

Created hierarchy for OBIEE Reports.

Worked on Performance improvement for OBIEE Reports.

Wrote shell scripts in UNIX using PUTTY to load the data.

Scheduled various jobs in Crontab to load the data in the SQL tables.

Environment: ODI 12c/11g / 10.1.3.4,OBIEE, PL/SQL, SQL, SQL Loader, Informatica 9.6.x,Toad, ETL, Erwin, Flat files, Oracle 12c/11g, Shell Programming, Toad, SQL Developer, Unix scripting, Windows XP. SQL Server 2012, 2012 R2, Visual Studio 2012, T-SQL, SQL Server Analysis Services, SQL Server Integration Services.

Los Angeles unified School District, Los Angeles May 2015 to Feb 2017 Role: Datawarehouse Consultant

Description: Los Angeles unified School District (LAUSD) is the largest public school system in the U.S. state of California and the 2nd largest public school district in the United States.

Design Mapping Specifications based on the Transformation rules to load the data from source to the Staging.

Perform administration of the Informatica Platform; including incident management and resolution.

Worked on OBIEE upgrade from OBIEE10g Application to OBIEE11g and then to OBIEE 12c.

Worked with software/systems personnel in application testing, such as system, unit, regression, load and acceptance testing methods.

Worked on system and regression testing and guided other team members for effective testing.

Designed and developed OBIEE Metadata repository (.rpd) that consisted of Physical layer, business model and Mapping layer (Aggregates, Dimensions and time Series functions) and presentation Layer.

Create mappings utilizing most of the Informatica Transformations.

Performed Informatica application administration that include creating users, connections, folders and managing privileges on them.

Performed build, deploy and project implementation activities.

Designed and developed Informatica Mappings/Sessions/Workflows to load data from Source systems to Staging DB.

Implemented mappings in ODI 12c using Aggregate, Expression, Filter, Dataset, Join, Lookup and Split components and Implemented ODI12c mapping to load multiple target tables.

Created and Implemented physical databases from relational and dimensional logical data models.

Designed end-to-end ELT process flow and implemented it using ODI packages.

Informatica Software installation, configuration, Patch management

Configuration and tuning of production and lower-level environments

Experience with Business Intelligence/Data-warehousing products, specifically with installing, configuring, and administering informatica

Experience in writing most complex UNIX shell scripts and sent files through sftp and ftp through cronjobs for ETL processes

Environment: Informatica Power Center 9.6.1, files, OBIEE 12.2.1.1.0 Oracle 12c/11g, Shell Programming, Toad, SQL Developer, Unix scripting, Windows XP. SQL Server 2012, 2012 R2, Visual Studio 2012, T-SQL, SQL Server Analysis Services, SQL Server Integration Services

Crossmark, Plano, Tx Dec 2014 To May2015 Role: Etl Developer

Responsibilities:

Gathered ELT requirements from Business team and designed its high level documents.

Installed and configured the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings.

Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool.

Configured ODI Agents on Windows server and tested them to execute and schedule ODI Scenarios.

Setup Security for accessing ODI s/w by creating groups and users into Security Manager.

Reverse Engineered Source and Target Data Stores using Reverse Engineering Knowledge Modules.

Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Installed and configured ODI12c on windows environments.

Hands on experience of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).

Created and configured ODI12c Agent and Installed it as a window services.

Implemented mappings in ODI 12c using Aggregate, Expression, Filter, Dataset, Join, Lookup and Split components and ImplementedODI12c mapping to load multiple target tables.

Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.

Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.

Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.

Experienced in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.

Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.

Optimized the Knowledge modules for increasing the efficiency of jobs as a part of performance tuning.

Environment: Informatica Power Center 9.6.1,Oracle Database 11g/10g, ODI 10.1.3.4, SQL*Loader, SQL, PL/SQL, SQL*Developer, UNIX, Golden Gate, SQL Loader, ETL, XML.

AT&T Richardson, TX JAN 2014 to NOV 2014 Role: ETL Developer

Description: Worked as an ODI ETL developer in AT&T. AT &T is a publicly held company that is a leading owner and operator of wireless and broadcast communications. It helps people to mobilize their worlds with advanced mobile services. It has provided services with innovative, reliable, high-quality products. AT&T is constantly innovating to find new connections in the Internet of Things.

Responsibilities:

Requirements Gathering, Business Analysis, and End User meetings

Defining business needs (key Indicators).

Responsible for data modeling using, Star Schema Modeling and Snow flake modeling, Fact and Dimension tables, physical and logical modeling.

Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.

Implemented CDC through ODI Journalization Knowledge Modules.

Created PLSQL procedure, to validate the data.

Installed and configured the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings.

Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool.

Integrated Changed Data Captures (CDC) which are reflected in the views

Created and optimized source-to-target mappings by using Expression, Splitter, aggregator, filter, joiner, lookups, and operators.

Customized ODI Knowledge modules like Loading Knowledge Modules and Integrated Knowledge Modules, check knowledge Modules, journalizing knowledge Modules. Reverse Engineered Source and Target Data Stores using Reverse Engineering Knowledge Modules.

Responsible for issue resolution and performance tuning of ODI Interfaces.

Used Topology Manager to create database connections, schemas, etc.,

Migrated Code from Development to Testing to production.

Responsible for coordinating with teams to report the spending patterns and supplier score cards using dashboards of Oracle Procurement and Spend analytics.

Environment: ODI 11g, OBIEE, Oracle Applications 11.0.4, 12.1.2, Oracle 11g, Toad, SQL Server.

Global-Tech, India SEP 2011 to AUG2013

Role: Role: PL/SQL developer

Description: Worked as PL/SQL developer in Global tech. Global-Tech has a wide sales network covering all over India for easy accessibility to customers. Global-Tech is one of India’s leading marketing and servicing organization, focused on providing perfect engineering solutions for Imported Machinery to Indian manufacturing industry.

Responsibilities:

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Experience in Oracle supplied Packages, Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using range partition technique.

Experience with Oracle Supplied Packages.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Creating Procedures and functions.

Environment: PL/SQL, SQL, SQL Loader, Toad, ETL, Erwin, Flat files, Oracle 11g/10g, Shell programming, Toad, SQL Developer, Windows XP.

Contact this candidate