Sales Project

Renjith Sadasivan

Chennai

Contact

number: +91-978*******

India

Email Id: *******.*********@*****.***

An accomplished Software Engineer with industry experience of 5 years in

Data Warehousing and Business Intelligence. Renjith has extensive

experience in delivering business solutions across a spectrum of industry

verticals like Healthcare, Retail, Fast Moving Consumer Goods, Media and e-

Businesses

Summary

> Possess expertise in design, development, implementation and support

of data warehouse and Business Intelligence Solutions in a variety of

industries

> Possess strong technical and working knowledge in Informatica Power

Center 7.1.4/8.6/9.1, Talend, SAP Business Objects XI, Cognos 8 BI,

Oracle BI, Microstrategy, Netezza, Teradata, Oracle and MS SQL Server

2005

> Worked for clients namely Various US Hospitals, Wal-Mart Stores, Inc,

The Golf Channel and United Online Inc-USA. Received excellent

feedback from the clients in recognition of the achievements

Current Employer: ABCO Advisory Services India Private Ltd.

Passport Number: G1051108 Visa: USA B1 visa valid till

2021

Technical skills:

Working knowledge and expertise in the below technologies:

Database Oracle 10g, Teradata, Netezza 4.6, MS SQL

Server 2000/ 2008, MS Access

OLAP Tools Cognos 8 BI, SAP BusinessObjects XI,

Oracle BI, Micro Strategy 8.1.1

ETL Tools Informatica Power Center 7.1.4/8.6, Talend

3.1.3, Microsoft Sql server Integration

services 2005(ssis)

Operating system Windows 98/2000, Windows XP,LINUX

Hardware IBM Compatible PC: PC/XT - Pentium 4

Certifications:

> Certified Oracle BI Professional from Systech Academy, Chennai

> Certified Business Objects Professional from Systech Academy, Chennai

> Certified Teradata Professional from Systech Academy, Chennai

> Certified Netezza Professional from Systech Academy, Chennai

> Certified Data Integrator Professional from Systech Academy, Chennai

> Certified Microstrategy Professional from Systech Academy, Chennai

Educational Qualification:

Qualification University Percentag

e

B-Tech - Computer Science and Mahatma Gandhi 65%

Engineering University

Plus Two Board of Secondary 72%

Education

10th ICSE 72%

Professional Experience:

Compass Products - Development and Support Jan 2010

- Till date

Role: Senior ETL Developer

The Advisory Board Company is the leading provider of comprehensive

performance improvement services to the health care and education sectors-

including operational best practices and insights, business intelligence

and analytic tools, management training, unbiased technology evaluation,

and consulting support. Drawing on nearly three decades of experience, The

Advisory Board Company is privileged to serve a membership of more than

2,800 organizations-including preeminent hospitals, health systems and

universities-all sharing a charter "above commerce," a commitment to best-

practice standards, and an unyielding insistence on continual improvement.

Project Description:

Advisory board offers various business intelligence tools (Compass

products) like surgery Compass, Spend Compass and Nursing Compass to its

members (US Hospitals) to gain more value and improve quality of their

services. Surgery Compass is designed to enable the Hospital management to

figure out their costs, expenses and profit generated out of their

Operation theatres. This tool also gives insight into the physician

performance and helps improve surgical margins in the near and long term.

At the core of our solution is a business intelligence tool, which

aggregates data from legacy systems to create a shared platform and common

metrics for performance benchmarking and comparative analytics across

profitability, cost, volume, and operations

Roles and Responsibilities

> Create and maintain the Informatica codes as per the user

requirements.

> Leading, developing and implementing end to end site build for new

members (hospitals) which include Informatica Mapping creation,

Session and workflow configuration, Data load automation, FTP path set

up, data validation and testing.

> Extensive troubleshooting / debugging using Informatica,

Microstrategy, Oracle and the in-house product viz. SMART

> Process surgical data using ETL code for multiple members to support

their site on a day to day basis.

> Data profiling using Informatica's data profiling tool for the new

member setup.

> Generate Oracle query to pull data from the Data Warehouse based on

member requirement

> Monitor and support the Data warehouse and Datamart loads

> Mentor new resources in the team

Project Environment: Informatica 8.6/9.1, Microstrategy, Oracle 10g, UNIX,

The Golf Channel - Datamart Development and Reporting Aug 2009-

Dec 2009

Role: Report/ETL Developer

GOLF CHANNEL was launched on January 17, 1995, and was the first fully

digital production facility in the United States. In its first year, Golf

Channel televised 23 domestic tournaments and 41 European and Australian

events. Since then, the network has been the gold standard for other niche

cable start-ups and has become golf's home on television. Golf Channel is

available in more than 120 million homes worldwide through cable, satellite

and wireless companies.

In 1996, GolfChannel.com was launched and has grown to become the #1 golf

site on the Internet. As a one-stop portal for all things golf, not only is

GolfChannel.com the destination for the latest news and scores, but also a

place to find services to help the recreational golfer enjoy golf more and

improve his/her game. GolfChannel.com also is helping to grow the game of

golf overall through platforms like facilitating online tee times and video

instruction. The GolfNow.com offers the best in tee times through easy and

convenient booking methods. Using leading edge technology, GolfNow.com

allows golfers more ways to stay connected to their favorite courses and

tee times through the web, email and upcoming mobile feature. GolfNow.com

operates in 41 states and is partnered with more than 1,800 courses across

the nation. Golfnow.com is owned and operated by Golf Channel in Orlando,

Florida and is the largest online tee time retailer in the United States.

Project Description:

Golf Channel lacked an effective way to consolidate, manage and distribute

business data. Data resided in many different sources and in different

formats, limiting its ability to analyze and deliver within a single

platform. The Datamart Development and Reporting project involved design,

development and implementation of datamart that could help them to analyze

the business from different perspectives. The source data residing at

disparate data sources were pulled together, cleansed, transformed

according to business rules and then loaded into the datamart. Cognos

reporting environment was built above the datamart to provide real-time

information to the business users. The datamart also provides complex

analytical capabilities enabling the business users to track sales, open

bookings and cancellations.

Responsibilities in the project:

> Understood the business requirements

> Performed source system data analysis

> Configured the database connections in Informatica

> As per the requirement, ETL jobs were developed to implement the

incremental data load as well as full load.SCD1 and SCD 2 concepts

were also implemented.

> Integrated all the jobs according to the data flow diagram

> Involved in the Installation and configuration of Cognos 8.3.

> Configured the data Source Connections in Cognos.

> Created different models and Packages and also published the packages

using cognos framework manager

> Generated various List Reports, Cross tab Reports, Chart Reports and

Drill-Through Reports using Cognos Report Studio

> Extensively used prompts, master-detail query relationships,

summaries, conditional formats, grouping and sorting features to

generate efficient and user-friendly reports

> Developed complex reports which involved multiple prompts, filters,

calculations, multi - page, multi-query reports with Drill Down and

Drill Through capability

> Created Dashboards to present critical company data in a single report

> Distributed Reports through Bursting, E-mail and uploading to folders.

> Scheduled Reports to run on a monthly, weekly and daily basis using

Cognos Scheduler

> Validated the reports by writing SQL scripts to fetch the data

> Created Test Case Documents and scripts

Project Environment: Informatica 8.6, Cognos 8.3, Oracle 10g, MS SQL Server

2008, Windows XP

United Online - Sales Operational Analytics and Reporting

Nov 2008 - Aug 2009

Role: ETL/Report Developer

United Online, Inc. is a leading provider of consumer Internet and media

services with over 60 million members across its stable of brands. The

company is structured around two primary business models which include both

social networking sites and subscription based communications segment of

the business. The company's primary Content & Media segment services

include social networking and online loyalty marketing such as

classmates.com

Project Description:

The Sales division at UOL was driven by daily web Ad sales strategy meeting

using a set of dashboard reports, referred to as WAR Room Dashboard, built

in MS Access and MS Excel. An operational analyst extracted data from

several data sources, integrated the data into the excel spreadsheet and

updated the dashboard before 9:00AM every day. As this proved unstable, the

Sales Operational Analytics and Reporting project was started with the aim

of cutting down the time for extracting & collecting data from different

data sources manually.

The project involved design, development and implementation of Sales

datamart that could provide a valuable insight into the company's business.

A reporting environment was build upon the datamart that would help the

UOL's sales division to strategize their daily, weekly, monthly & quarterly

Advertisement Sales vision.

Responsibilities in the project:

> Performed source system data analysis

> Transformed the raw data into meaningful information by applying

various business rules using SQL and Informatica

> Extensively worked on Informatica Tools - Designer(Source Analyzer,

Warehouse designer, Mapping designer, Mapplet designer, Transformation

developer),Workflow manager and Workflow monitor

> Designed various complex business logics using Informatica Mapping

designer to load the Dimension and Fact Tables

> Maintained development standards to ensure data quality

> Wrote SQL scripts to perform data integrity checks

> Involved in designing report models using Cognos Framework Manager.

> Generated various List Reports, Cross tab Reports, Chart Reports and

Drill-Through Reports using Cognos Report Studio.

> Extensively used Cascading prompts, master-detail query relationships,

conditional formats, grouping and sorting features to generate

efficient and user-friendly reports

> Worked on Query Studio to generate Ad-hoc Reports

> Created Dashboards for users to analyze the business performance

> Scheduled the reports to run on different time frames

> Distributed Reports through Bursting, E-mail and uploading to folders

> Validated the reports by writing SQL scripts to fetch the data

Project Environment: Informatica 8.6, Cognos 8.3, Oracle 10g, MS SQL Server

2005, Windows XP

Walmart.com-Business Intelligence Development and Support Services

Jan 2008 - Nov 2008

Role: ETL/Report Developer

Walmart.com is a subsidiary of Wal-Mart Stores, Inc. founded in 2000 with

headquarters in Brisbane, CA. More than one million products are available

online along with creating innovative business including Music Downloads

and 1-Hour Photos which enable customers to order online and then pick up

at their local Walmart retail store. They also act as a marketplace where

they allow retailers, like eBags and CSN Stores, to sell merchandise on

their website

Project Description:

The scope of this project is to work with the Walmart.com Reporting Team on

enhancements and changes to the existing system through approximately nine

release updates per year. The tasks assigned include assignments and QA

using Informatica, SQL, BO Universe, BO Reporting, and Unix Reporting in

addition to Production Support.

Responsibilities in the project:

> Understand the business and business requirements

> Analyze the data and design the ETL mappings as per ETL standards and

strategies.

> Worked extensively on different types of transformations like source

qualifier, expression, aggregator, router, filter, update strategy,

lookup, sorter, normalize, and sequence generator

> Implemented Type 1 and Type 2 Slowly changing dimensions according to

the business requirement

> Worked on the creation of Sessions, Worklets and Workflows

> Implemented performance tuning logic on Targets, Sources, mappings and

sessions to provide maximum efficiency and performance.

> Involved in execution of Unit test plans & prepare the Unit Test Cases

and Scripts.

> Involved in migrating the Mappings, Sessions, Workflows from

Development environment to Test environment

> Involved in designing the universe by creating the Business Objects

data model selecting/joining tables, indicating cardinalities,

creating aliases to resolve the loops, subdividing into contexts and

creating the objects which are grouped into classes.

> Created the reports (Master/Detail, Crosstab, and Chart templates) in

Business objects desktop intelligence using the universes as the main

data provider.

> Modifying the existing reports as per the change in business and users

request

> Validated the reports by writing SQL scripts to fetch the data

> Scheduling the reports to run on daily, weekly and monthly basis

according to the requirement.

Project Environment: Informatica PowerCenter 8.1.1, Business Objects XI R2,

Oracle Database 10g, Netezza 4.1.1, Sun Solaris (UNIX) 8.0, Shell

Programming 8.0, Win SQL 6.5, and Microsoft Visio 2003

Contact this candidate