Sharath Marka

Phone: 408-***-****

Email:acggc1@r.postjobfree.com

P

pp

PROFESSIONAL SUMMARY:

. 7+ years of extensive experience in IT industry with a strong

background in Data Warehousing, Business Intelligence and ETL process

using Informatica Power Center 9.1/8.x/7.x.

. Experience in using Informatica Power Center tools such as Source

Analyzer, Transformation Developer, Mapping Designer, Workflow

Manager, Workflow Monitor and Repository Manager.

. Experienced in loading data, troubleshooting, Debugging mappings,

performance tuning of Informatica (Sources, Targets, Mappings and

Sessions) and fine-tuned transformations to make them more

efficient in terms of session performance.

. Database experience using Oracle, SQL Server, Teradata, DB2 and MS

Access.

. Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and

Packages.

. Experience in UNIX Operating System and Shell scripting.

. Experienced with Integration of data from heterogeneous sources such

as Relational tables, flat files, MS Excel, and XML files

. Good understanding of Views, Synonyms, Indexes, Joins, and Sub-

Queries.

. Working knowledge of data warehouse techniques and practices,

experience including ETL processes, dimensional data modeling (Star

Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.

. Experience in data mart life cycle development, performed ETL

procedure to load data from different sources into Data marts, Data

warehouse and ability of loading to large data sets using Informatica

Power Center.

. Experienced in all data processing phases, from the Enterprise Model,

Data Model (Logical and Physical Model), Data Warehousing (ETL).

. Used Debugger in Informatica Power Center Designer to check the errors

in mapping

. Experience in writing complex SQL queries and PL/SQL, including the

use of stored procedures, functions and triggers to implement business

rules and validations.

. Excellent skills in fine tuning the ETL mappings in Informatica.

``

. Experience in Data Modeling tool - Erwin and Data Warehousing Concepts

. Extensive experience using database tool such as SQL *Plus, SQL *

Loader and TOAD

. Experience with System Development Life Cycle (SDLC).

. Worked extensively on OBIEE/Siebel Analytics Administration Tool

involving all the 3 layers namely Physical Layer, Business Model and

Mapping Layer and Presentation Layer of an OBI Metadata Repository

using Oracle BI Administration Tool.

. Effective working relationships with client team to understand support

requirements, and effectively manage client expectations.

. Excellent communication, presentation, project management skills, a

very good team player and self-starter with ability to work

independently and as part of a team.

TECHNICAL SKILLS:

ETL Tools Informatica 9.x/8.x/7.x (Power Center) (Designer, Workflow

Manager, Workflow Monitor)

Data Modeling Physical Modelling, Logical Modelling, Relational

Modelling, Dimensional Modelling (Star Schema, Snow-Flake,

Fact, Dimensions), Entities, Attributes, Cardinality, ER

Diagrams.

Databases Oracle 11g/10g/9i, MS SQL Server, Sybase, MySQL, Teradata

and DB2

Languages SQL, PL/SQL,C,C++,Data Structures, Unix Shell Script,

Visual Basic

Web Technologies HTML, XML, Java Script

Tools SQL plus, PL/SQL Developer, Toad, SQL* Loader

Operating Systems Windows XP/Vista/7, UNIX, MS-DOS and Linux

Education:

Bachelor's in Computer Science Engineering, Jawaharlal Nehru

Technological University, India.

Professional Experience:

Cisco Systems, San Jose, CA

May 2014 - Present

ETL developer

Customer Excellence is a project of customer analytics to improve key

measures for top revenue customers. The purpose of this project was to

design the backend data to calculate the measures for customers in Supply

Chain Operations.

Responsibilities:

. Working with business users and business analyst for requirement

gathering and business analysis.

. Designing and customizing data models for Data warehouse supporting

data from multiple sources.

. Extracted data from flat files, Excel files and transformed the data

based on user requirement using Informatica Power Center.

. Performed analysis on quality of source data to determine accuracy of

information being reported.

. Debugging the mappings and used session log files to trace errors that

occur while loading.

. Performance tuning by optimizing the mappings and sessions.

. Performed Unit Testing and tuned for better performance.

. Used the backend data to calculate the metrics rolling to the customer

level on a Quarterly basis.

. Working with quality and operational metrics in supply chain business

unit for top customers.

. Optimized the SQL queries using Explain Plan.

. Built WebI reports provided OLAP functionality and worked extensively

with data warehousing.

Environment: Informatica PowerCenter 9.0.1, Flat files, Excel, Oracle11g,

Teradata, MySQL,

SQL, Business Objects XI 3.1.

Charles Schwab, San Francisco, CA

Oct 2012- April 2014

ETL / Informatica developer

The Advice delivery program is a project focused on delivering the industry

most ethical, useful and valued investment advice services. These efforts

directly support the firm's landmark introduction of Schwab personal choice

as well as key enhancements to Schwab's advice capabilities and

improvements to the scalability and reliability of the supporting advice

technology infrastructure.

Responsibilities:

. Gathered user requirements and designed source to target data load

specifications based on business rules.

. Used Informatica Power Center to load data from Flat Files to DB2, XML

files to DB2, Flat Files to Oracle.

. Staged vendor data as provided by the vendor .Applied transformation

logic to extract datasets.

. Analyzed Data warehouse and data elements documents received from the

vendor Morningstar.

. Used Tic stream to download Global Equity data files, validated and

staged the data.

. Applied data validations and loaded the source data to the target

tables using Informatica.

. Created control files and used SQL Loader to load the data.

. Used Informatica debugging techniques to debug the mappings and used

session log files and bad files to trace errors that occur while

loading.

. Worked on performance tuning for the workflows that took longer time

to load the data.

. Automation of workflows to run daily and monthly jobs.

. Created and maintained various UNIX Shell Scripts for loading process.

. Created deployment groups, migrated the code into different

environments.

. Developed Oracle PL/SQL Stored Procedures. Performance and fine

Tuning of SQL.

. Performed Unit testing by executing the SQL scripts and comparing the

source with target data.

. Created and documented ETL test Cases and Validations.

Environment: Informatica PowerCenter 9.0.1, Flat files, XML, Oracle11g,

DB2, SQL, PL/SQL and UNIX.

SunRun, San Francisco, CA

Jan 2012 - Sep 2012

ETL Consultant

The SunRun EBS contains various data storage mechanisms (Salesforce.com,

Oracle) and in-house systems (Best Bill, Customer Billing Engine, etc.)

that interact with each other. Informatica is used as a middleware tool to

handle the data flow between these systems.

Responsibilities:

. Loaded Data from various Salesforce.com (SFDC) objects into Oracle

database tables.

. Developed mappings where data from Oracle data sources is updated

to the respective SFDC objects.

. Used Power Exchange for Oracle E-Business Suite to import an Oracle

E-Business Suite as a source definition.

. Used Apex Explorer to query Account, Contacts and Generation assets

tables in SFDC.

. Created Web service source and target in mapping designer and

published Web services.

. Used Web service consumer as source and developed mapping to target

depending on the business requirement.

. Implemented Upsert logic for the incremental load.

. Developed slowly changing dimension Type 2 mappings to maintain the

history of the data.

. Implemented automated schedule of ACH file transfer from oracle

server to US bank and Comerica bank server .

. Performed operational support and maintenance of ETL bug fixes and

defects.

. Worked on performance tuning for the sessions that took longer time to

load to the target.

. Generated WSDL's in Power Center Web service hub.

. Used Informatica Power Center Workflow manager to create sessions,

batches to run with the logic embedded in the mappings.

. Written and executed complex T-SQL queries using SQL Server Management

Studio for back end data validation testing.

. Designed and implemented custom business intelligence solutions

Metadata and Dashboards and Reports using the Oracle BI Analytics

platform.

. Developed the repository model for the different work streams with the

necessary logic that involved creating the Physical, BMM and the

Presentation layer. Also created hierarchies, variables, and event

poll strategies in the repository.

Environment: Informatica PowerCenter 9.0.1, SFDC, Web services,

Oracle10g/11g, SQL Server 2008 Enterprise Edition, SQL, PL/SQL, UNIX, Flat

files, XML, Erwin, OBIEE 10.1.3.4.1.

Abbott Laboratories, Waukegan, IL

Aug 2011-Dec 2011

Informatica developer

The project MOST Retail Expansion vision is to create a single integrated

system that will support standard sales reporting, self-service analytics

and ad-hoc analysis. As a Data warehouse consultant loaded different data

sources into Staging Area, leveraging the Teradata database platform. The

DDS is then populated only from the staging area where we store the fact

data and the various dimension data. The ADS is then populated from the DDS

data for analysis purpose.

Responsibilities:

.

. Analyzed the functional specs provided by the data architect and

created technical specs documents for all the mappings.

. Developing several mappings in Informatica a variety of PowerCenter

transformations, Mapping Parameters, Mapping Variables and Parameter

files in Mapping Designer.

. Created reusable transformations and mapplets and used them in

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.

. Implemented performance tuning logic on Sources, Targets, mappings,

and sessions to provide maximum efficiency.

. Used Informatica Version Control for checking in all versions of the

objects used in creating the mappings and workflows and to keep

track of the changes in the development, testing and production

environments.

. Created Workflows with worklets, event wait, email and command tasks

using Workflow Manager and monitored them in Workflow Monitor.

. Created logical and physical data models and maintained relationships

between tables using Erwin.

. Developed database triggers, packages, functions, and stored

procedures using PL/SQL and maintained the scripts for various data

feeds.

. Created Pre/Post Session/SQL commands in sessions and mappings on the

target instance.

. Enhance performance by creating Aggregate tables, Indexes and managing

Cache.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/11g,Teradata 13, f,

SQL, PL/SQL, UNIX, Flat files, XML, SQL Server 2008, Erwin, OBIEE10.1.3.4.1

Pfizer Inc, Newyork

Feb 2011-July 2011

Informatica developer

Pfizer Inc is the world's largest research-based pharmaceutical

company. Pfizer Inc discovers, develops, manufactures, and markets leading

prescription. Pfizer is implementing HCP Payment disclosure project where

there are different data sources that need to be loaded to the Transaction

Repository for Business improvement and Analysis.

.

Responsibilities:

. Integration of various data sources like Oracle, SQL Server, Fixed

Width, Delimited Flat Files, DB2, COBOL files & XML Files.

. Extracting the data from SFDC and loading into Oracle database.

. Used Informatica to pull the data from SAP and loading in to Oracle

Database.

. Developing several complex mappings in Informatica a variety of

PowerCenter transformations, Mapping Parameters, Mapping Variables,

Mapplet and Parameter files in Mapping Designer using Informatica

PowerCenter.

. Designed Mappings using B2B Data Transformation Studio.

. Responsible for implementing Incremental Loading mappings using

Mapping Variables and Parameter Files.

. Migration of code between the Environments and maintaining the code

backups.

. Created the Test cases and Captured Unit test Results.

. Designed mappings from the scratch and also did performance tuning

of the mappings that were previously implemented.

. Migrating mappings, workflows and parameter files from development

to production.

. Responsible for implementing Incremental Loading mappings using

Mapping Variables and Parameter Files.

. Maintained the target database in the production and testing

environments.

. Produced automated build scripts using Perl and shell programming.

. Implemented Logical /Physical design of database schemas and

business processes though Erwin.

. Developing information systems through investigation, analysis,

design, implementation and maintenance with SDLC.

. Implemented complex views, procedures, functions, packages and

triggers in PL/SQL.

. Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Centre 8.6.1, Oracle 10g/9i, SAP, ABAP,

PL/SQL, Erwin, Flat files, XML, SQL Server, MS Access, Business

Objects, UNIX.

Bank of America, Charlotte, NC

Jan 2010- Nov2010

Informatica developer

I have assisted in the design and development of data warehousing project

for the improvement of account management and I used to load the

transaction data to the warehouse.

Responsibilities:

. Interacted with Business Analysts to understand the requirements and

the impact of the ETL on the business.

. Worked with data modelers in preparing logical and physical data

models and adding/deleting necessary fields using Erwin.

. Extracted data from flat files and oracle database, applied business

logic to load them in the central oracle database.

. Created reusable transformations and Mapplets and used them in

mappings.

. Worked on different data sources such as Oracle, SQL Server, Flat

files etc.

. Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in

Informatica.

. Created E-mail notifications tasks using post-session scripts.

. Worked with command line program pmcmd to interact with the server to

start and stop sessions and batches, to stop the Informatica server

and recover the sessions.

. Wrote SQL, PL/SQL, stored procedures & triggers, cursors for

implementing business rules and transformations.

. Worked with BTEQ, FLOAD, MLOAD Teradata utilities to export and load

data to/from Flat files.

. Implemented performance tuning logic on Targets, Sources, mappings,

sessions to provide maximum efficiency

. Assessed functional issues by troubleshooting Informatica mappings,

sessions, and workflows with UNIX shell scripts; Perl scripts; SQL

queries in all stages of development and/or production.

. Developed a. Framework for extensible automated production support in

PL/SQL.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, SQLServer2005,

Teradata 13,PL/SQL, XML, MS Access, Java, Sybase, Netezza, Web services,UNIX, Perl, UDB DB2 8.1, Toad, Business Objects.

Wellcare

July 2008- Nov 2009 Informatica Developer

Wellcare Health Plans, Inc. provides managed care services exclusively for

government-sponsored health care programs, focusing on Medicaid and

Medicare. The goal of this project is to migrate data from the various

systems in the manufacturing domain . The data is extracted from different

systems like Oracle databases and flat files. The data is extracted from

these systems into a MDI data mart using Informatica Power Center 8 tools.

Responsibilities:

. Transforming high-level design spec to simple ETL coding. Designing

mappings according to the mapping standards, naming standards and

warehouse standards for future application development. .

. Developed and scheduled various pre and post-sessions commands and

workflows for all mappings to load data from source files to target

tables.

. Created one time mappings and workflows for better understanding and

easy to use.

. Worked with Variables and Parameters in the mappings.

. Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in

Informatica.

. Involved in Performance tuning for sources, targets, mappings and

sessions.

. Created logical and physical data models and maintained relationships

between tables using Erwin. Well versed with reverse engineering

processes in Erwin.

. Validated X12 and tested HIPAA EDI Transactions 837, 835, 834 to meet

the customer specific requirements.

. Involved in requirements and in modeling activities of the attributes

identified from different source systems which are in Oracle,

Teradata, CSV FILES and Mainframe. Data is Staged, integrated,

Validated and finally loaded the data into Teradata Warehouse using

Informatica.

. Created Teradata External loader connections such as MLOAD, FLOAD

while loading data into the target tables in Teradata Database.

. Used for Creating, Validating, Testing and running the sequential and

concurrent Batches and Sessions. Migrated mappings from Development to

Testing and performed Unit Testing and Integration Testing.

. Developing information systems through investigation, analysis,

design, implementation and maintenance with SDLC.

Environment: Informatica PowerCenter 8.6.1, OWB, SQL Server 2000, Teradata,

TOAD, Oracle 9i, DB2, SQL, PL/SQL, Netezza, UNIX Shell Scripts, OBIEE,

Erwin.

State Farm Insurance

June2007- July 2008

ETL Developer

The Insurance DW project was developed in an effort to streamline the

entire process of Insurance and to keep track of various financials on a

daily, weekly, monthly basis. Claims, Premium, Loss and Contracts were some

of the modules to deal with.

Responsibilities:

. Worked with Business analysts and the DBA for requirements gathering,

business analysis and designing of the data warehouse.

. Used Repository manager to create user groups and users, and managed

users by setting up their privileges.

. Tuned performance of Informatica session for large data files by

increasing block size, data cache size, sequence buffer length and

target based commit interval.

. Created Complex mappings using Unconnected, Lookup, and Aggregate and

Router transformations for populating target table in efficient

manner.

. Created Mapplet and used them in different Mappings.

. Used sorter transformation and newly changed dynamic lookup

. Created events and tasks in the work flows using workflow manager

. Developed Informatica mappings and also tuned them for better

performance

with PL/SQL Procedures/Functions to build business rules to load

data.

. Created Schema objects like Indexes, Views, and Sequences.

. Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data

Import/Export.

. Developed mappings for policy, claims dimension tables.

. Tuned performance of existing SQL statements and PL/SQL code.

. Developed procedures, functions, packages and triggers in PL/SQL

. Developed shell scripts for running batch jobs and scheduling them.

Environment: Informatica Power Center 8.0 Work Flow Manager/Monitor, Erwin

4.0, Oracle 10g/9i, SQL, PL/SQL, Netezza, TOAD, SQL Loader, Java, Sun

Solaris 2.6, UNIX Shell Scripting.

Contact this candidate