Manager Data

Sandeep Singarapu

Business Intelligence Analyst

**** **** ***, *** ***, Corona, NY. 11368

C: 408-***-**** *********.*******@*****.***

PROFESSIONAL OVERVIEW

. Over 7 years of experience in Information Technology as a Data

warehouse Professional and Business Associate with extensive

experience in ETL, Reporting process and with a strong background in

Business Intelligence and Data Analysis. ?- Strong experience in Data

Integration, Reporting Design, Social Media and Email Marketing.?-

Solutioning experience for numerous ETL problems in various technology

domains?- Worked with the teams that continuously improved the

processes beyond the scope and limitations

. Constantly improved the process to extract the Media content from over

30 websites, tie back to the customer base and follow the activity on

social media world to exceed the business expectations and bring in

the new level of personalized marketing experience.

. Data Processing experience in designing and implementing Data Mart

applications, mainly transformation processes using Informatica

PowerCenter 9.x/8.x.

. Proficient in extracting the data from API's like Facebook, Twitter,

Tumblr, Google Plus, Youtube, Double Click, Flurry, Lode Stone etc

using OAUTH2 and Access Token.

. Proficient in handling, Parsing the JSON data using Ruby scripting

. Proficient in writing powerful scripts to automize the process of

dealing with the external data source and publicly available social

media data.

. Good knowledge in creating the Universe and Reports using Business

Objects.

. Proficiency in using Informatica PowerCenter tool to design data

conversions from wide variety of sources

. Strong in Data warehousing concepts, dimensional Star Schema and

Snowflake Schema methodologies

. Extensively worked with large Databases in Production environments.

. Experience in Performance tuning of the Informatica and Oracle.

. Strong expertise in Relational data base systems like Oracle,

Infobright, SQL Server, DB2 and Teradata.

. Worked with XML and Flat file sources coming from various legacy

source systems and residing on Mainframe and UNIX.

. Extensively used SQL and PL/SQL to write Stored Procedures, Functions,

Packages and Triggers.

. Proficient in understanding business processes / requirements and

translating them into technical requirements.

. Team Player with excellent communication, analytical, verbal, writing

and interpersonal skills.

Summary of Skills:

Data Warehousing Informatica PowerCenter 9.x/8.x/7.x, Oracle Data

ETL Integrator.

Data Informatica Analyst, Informatica Data Quality (IDQ)

Profile/Quality

Databases Oracle 10g/9i, Teradata, InfoBright, DB2 8.1

Programming SQL, PL/SQL, Unix, Shell Scripting, Python, Ruby, Rails,

C, Java, Perl, SQL Tuning/Optimization, BTEq, Fast Load,

Fast Export, Multi Load

Tools TOAD, SQL*Plus, SQL Navigator, SQL Assistant, Jira,

FileZilla, Autosys, Control-M, Erwin, Excel, Word,

DoubleClick

Reporting Tools Business Objects, Oracle Business Intelligence

Environment UNIX, Windows 7/XP/Vista, Linux.

Scripting Python, Ruby

EDUCATION

Southern New Hampshire University Master's Degree Graduated: June 2010

Major: Information Technology

GPA: 3.7

Course Work Java Programming Advanced

Information Technology

Database Management Systems Simulation

Data Communications & Networking Project

Management Artificial Intelligence

Operating Systems

WORK HISTORY

MLB Advanced Media L.P NY

Apr 2011 - Till Date BI Analyst

MLB.com is the official site of Major League Baseball and is overseen

by Major League Baseball Advanced Media, L.P. (a subsidiary of MLB).

MLB.com is a source of baseball-related information, including baseball

news, statistics, and sports columns. MLB.com is also a commercial site,

providing online streaming video and streaming audio broadcasts of all

Major League Baseball games to paying subscribers, as well as "gameday", a

near-live streaming box score of baseball games for free. In addition,

MLB.com sells official baseball merchandise, allows users to buy tickets to

baseball games, runs fantasy baseball leagues (both free and paid), and

runs auctions of baseball memorabilia.

. Worked closely with client in understanding the Business requirements,

data analysis and deliver the client Expectation.

. Used Informatica PowerCenter 8.6.1/9.1 and its all features

extensively in migrating data from OLTP to Enterprise Data warehouse.

. Extracted data from different sources like Oracle, flat files and

loaded into DWH.

. Took initiative to explore Repository contents to utilize in the Batch

Process.

. Extracted the data from API's like Facebook, Twitter, Tumblr, Google

Plus, Youtube, DoubleClick, Flurry, LodeStone Social etc.

. Also worked on Business Objects to create reports for internal

auditing and maintenance.

. Worked on different programming languages like Python, Ruby etc and

created scripts to interact with FTP servers.

. Involved in Migration process from Informatica 8.6 to Informatica 9.

. Created complex mappings in PowerCenter Designer using Aggregate,

Expression, Filter, and Sequence Generator, Update Strategy, Lookup,

Joiner, and Stored procedure transformations.

. Developed mappings/Reusable Objects/mapplets by using mapping

designer, transformation developer and mapplet designer in Informatica

PowerCenter 8.6.1

. Used Informatica PowerCenter 8.6.1 for extraction, loading and

transformation (ETL) of data in the data warehouse.

. Used Informatica Power Center Workflow manager to create sessions,

batches to run with the logic embedded in the mappings.

. Involved in scheduling the Informatica workflows using Informatica

Scheduler.

. Migrated mappings, sessions, and workflows from development to testing

and then to Production environments.

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

sessions.

. Performed unit testing on the Informatica code by running it in the

Debugger and writing simple test scripts in the database thereby

tuning it by identifying and eliminating the bottlenecks for optimum

performance.

. Worked extensively with different caches such as Lookup cache (Static,

Dynamic, Persistence and Shared).

. Created deployment groups, migrated the code into different

environments.

. Worked closely with reporting team to generate various reports.

Environment: Informatica PowerCenter 8.6.1 (Power Center Repository

Manager, Designer, Workflow Manager, and

Workflow Monitor), Business Objects, Oracle 10g, InfoBright, TOAD, SQL

Navigator, FileZilla,, SQL, PL/SQL, UNIX.

The New York Times (Datawin Systems) NY

June 2010 - Apr 2011 ETL/Informatica

Consultant

Responsibilities:

. Worked closely with client in understanding the Business requirements,

data analysis and deliver the client Expectation.

. Used Informatica PowerCenter 8.6.1 and its all features extensively in

migrating data from OLTP to Enterprise Data warehouse.

. Involved in Logical and Physical data modeling and designing Star

Schemas using Erwin.

. Extracted data from different sources like Oracle, flat files and

loaded into DWH.

. Created complex mappings in PowerCenter Designer using Aggregate,

Expression, Filter, and Sequence Generator, Update Strategy, Lookup,

Joiner, and Stored procedure transformations.

. Developed mappings/Reusable Objects/mapplets by using mapping

designer, transformation developer and mapplet designer in Informatica

PowerCenter 8.6.1

. Used Informatica PowerCenter 8.6.1 for extraction, loading and

transformation (ETL) of data in the datawarehouse.

. Handle slowly changing dimensions (Type I, Type II and Type III) based

on the business requirements.

. Used Informatica Power Center Workflow manager to create sessions,

batches to run with the logic embedded in the mappings.

. Involved in scheduling the informatica workflows using Informatica

Scheduler.

. Migrated mappings, sessions, and workflows from development to testing

and then to Production environments.

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

sessions.

. Performed unit testing on the Informatica code by running it in the

Debugger and writing simple test scripts in the database thereby

tuning it by identifying and eliminating the bottlenecks for optimum

performance.

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

business rules and transformations.

. Worked extensively with different caches such as Lookup cache (Static,

Dynamic, Persistence and Shared).

. Created deployment groups, migrated the code into different

environments.

. Worked closely with reporting team to generate various reports.

Environment: Informatica PowerCenter 8.6.1 (Power Center Repository

Manager, Designer, Workflow Manager, and

Workflow Monitor), Oracle 10g, TOAD 6.0, SQL, PL/SQL, UNIX, Erwin.

Keshav Consulting NC

April 2010 - June 2010 ETL Developer / Intern

. Experience in creating mapping, reusable transformations and mapplet

. Developed scheduling jobs in Informatica and monitored the same using

the workflow monitor

. Practical understanding of the Database schemas like Star Schema and

Snow Flake Schema used in relational and dimensional modeling.

. Strong knowledge of Entity-Relationship concept, Facts and dimensions

tables and Slowly changing dimensions

Arkansas State University & Southern New Hampshire University

Aug 2008 - Jan 2010 Graduate

Assistant/Student Assistant

. Maintain scheduled office hours and assist with the daily office

operation as determined by supervisor

. Coordinate maintenance and updates of areas Campus Life website

. Type correspondence, entering data/computing

. Answer phones

C3i, Hyderabad, INDIA

May 2007 - June 2008 RD Systems Analyst

Responsibilities:

. Extensively used ETL to load data from multiple sources to Staging

area (Oracle 9i) using Informatica PowerCenter 7.1 Worked with pre and

post sessions, and extracted data from Transaction System into Staging

Area.

. Knowledge of Identifying Fact and Dimension tables.

. Created reusable transformations and mapplets and used them in

mappings Extensively used Informatica PowerCenter 7.1.2 to extract

data from various sources and load in to staging database.

. Extensively used transformations such as Source Qualifier, Aggregator,

Expression, Lookup, Router, Filter, Update Strategy, Joiner,

Transaction Control and Stored Procedure.

. Tuned sources, targets, mappings and sessions to improve the

performance of data load Designed Logical and Physical Modeling using

Erwin Data Modeler tool.

. I created Several Informatica Mappings to populate the data into

dimension and fact tables.

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

sessions.

. Performed unit testing on the Informatica code by running it in the

Debugger and writing simple test scripts in the database thereby

tuning it by identifying and eliminating the bottlenecks for optimum

performance.

. Created sessions and batches for incremental load and schedule them to

run daily.

. Implemented Type II slowly changing Dimension to maintain all

historical information in Dimension Tables.

Idea Labs (Renaissance Softlabs Pvt Ltd), Hyderabad,

India

April 2006 - May 2007 Intern

. Knowledge of Identifying Fact and Dimension tables.

. Created reusable transformations and mapplets and used them in

mappings Extensively used Informatica PowerCenter 7.1.2 to extract

data from various sources and load in to staging database.

. Used transformations such as Source Qualifier, Aggregator, Expression,

Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control

and Stored Procedure.

. Tuned sources, targets, mappings and sessions to improve the

performance of data load Designed Logical and Physical Modeling using

Erwin Data Modeler tool.

. I created Several Informatica Mappings to populate the data into

dimension and fact tables.

Contact this candidate