Data Project

Ram K.V

******@*****.***

PROFESSIONAL SUMMARY

• 12+ years of experience in IT industry in DWH applications.

• Experience spanning all phases of software development life cycle viz. Requirement

Analysis, Design, Development, User Training, Implementation and Production Support.

• Addressing the complete life cycle for all data integration projects including data

warehouses and data marts, data migration and information hubs.

• Excellent ETL Experience in Informatica PowerCenter 8.1/7.1/6.0/5.1.

• Has exposed to Datastage 7.5 Enterprise Edition

• Strong in Teradata (10 Yrs) V2R 12/6.2/6.0 database SQL Tuning, Designing, Data

Modeling and with extensive knowledge of utilities of Teradata BTEQ, MLOAD and

FastLoad.

• Worked in Oracle 9i SQL and PL/SQL. Developed ETL jobs using PL/SQL Packages.

• Technical Mentor with excellent communication and client liaison skills

• Exposed to the Implementation of OLAP Applications and Analytical Report analysis.

OLAP Tool: Whitelight AnalyticServer 4.3 and Exposed to BO XI R2

• Have profound knowledge and experience in Dimensional Modeling

• As Sr. Data Architect at TELECOM GIANT, Participated in the Business and

Specifications requirements gathering sessions and convert it into Design specifications.

The Design specifications ranges from High level Design to Application level designs

and (Cross) Application Interface agreements specifications.

• As a Solution Architect, Consulted in Forecasting and Demand Planning solution

development roles with CPG Client. Designed, presented and managed the delivery of

Sales & Forecasting solutions for Teradata applications.

• As ETL Designer/Architect: Architected, designed, and implemented full scale DataMart for the

Internet Campaign/Marketing Management solution.

• Functional Knowledge in CPGN Industry (Retail Industry) and Online Marketing

Industry.

CERTIFICATIONS

• Master Certified Teradata Professional V2R5 (completed 6 levels)

• Master Certified in Data Modeling concepts

PROFEESIONAL ACHEIVEMENTS

• SHINING STAR award for outstanding performance from Information Resources Inc.,

• FIMC (Feather In My Cap) award from National Grid Transco for submitting paper on

Transco Analytic Reports

SKILLS SET

• BI Tools: Expert in WhiteLight AnalyticServer 4.3.1, Exposed to BOXI R2.

• ETL: Expert in Informatica 8.1 (7.1/6.2/5.1 Versions)

• RDBMS: Teradata 10/6.2/6.1/5.0/3.0, Oracle 9i and SQL Server 7.0

• Design Tools: ERWin 4.0 and 7.3, Dezign for Database 2.0 and Microsoft Visio

• OS: Windows NT & XP, SunOS Rel 5.8 and HP-UX 11.11

EDUCATION

• Master of Computer Application (MCA) from Central University Pondicherry, India.

PROFESSIONAL EXPERIENCE

Client: AT&T inc

Location: Alpharetta, GA

Period: Nov ‘08 – Till Date

Projects: PCA (Personalized course of Action)

Description

Sr. Data Architect for the ECDW of TELECOM GIANT PCA.

*ECDW – Enterprise Consolidated Data Warehouse

Responsibilities:

Participate in the Business and Specifications requirements gathering sessions and convert it

into Design specifications. The Design specifications ranges from High level Design to

Application level designs and (Cross) Application Interface agreements specifications.

Support development activities across application database development teams in support of

corporate application services.

Design data models (in Erwin 7.0), database structures and internal ETL systems to meet

corporate and project objectives.

Review database architectures and designs to ensure compliance with corporate objectives

for data integrity and quality, performance, manageability, scalability, etc.

Evaluate and Estimate Size, implement and support database infrastructure / technologies and

development processes to support database development:

Evaluate prototype and transition new and emerging technologies into the mainstream

development process.

Define documentation standards and implement within the team development process.

Implement and monitor a database migration / synchronization process across the

development teams and environments (development, test, stage, prod).

Define the data management strategy to be used across data domains and products.

Assess existing ETL systems and data structures and develop a roadmap to identify and plan

improvement projects going forward.

Act as a key stakeholder in the cross-team implementation of applications development in

Informatica 8.1 and Teradata 10.0.

Participate on the Enterprise Architecture team; reviewing the architectural approach

proposed by development teams to meet their product development objectives.

Develop and implement End-Client feedback processes and address the issues / problems

reported.

Client: Pepsico

Location: Plano TX

Period: June ‘07 – Nov ‘08

Projects: Demand Planning & Forecasting

Description

Solution Architect for the EDW of Demand Planning.

Responsibilities:

As a Solution Architect, Consulted in Forecasting and Demand Planning solution

development roles with CPG Client. Designed, presented and managed the delivery of Sales

& Forecasting solutions for Teradata applications

Authored the whole process of ELT (Extraction Load and Transform) process at QTG R4

Project. Designed/implementer a system to extract the data, report data anomalies, keep track

of the execution duration.

Implemented the batch mode for File handler process, Process handler with process

dependency and Job Handler which supports data extraction, cleansing, aggregation,

reorganization, transformation, and load operations:

Tuned application at the Design Level, Process/Transformation level and Query Tuning in

Teradata logical and Physical Model.

Implemented Physical Index like SI, JI and AJI to improve the query performance and make

throughput available to the end Business user within seconds of time.

Client: Online Market & Campaigns

Location: San Jose CA

Period: Jan 06 – June 07

Projects: eCARE ( and Power Seller)

Description

Data Marts Engineer within the Information Management & Delivery Organization, Direct

Marketing Solutions Team. Responsible for development and implementation of the ETL

(Extract, Transform, Load) layer for Marketing Data Marts on Enterprise Data Warehouse.

Responsibilities include:

As ETL Designer/Architect: Architected, designed, and implemented full scale DataMart for the

Internet Campaign/Marketing Management solution

Designed ELT process for data extract and load processes for the campaign management

marketing data marts using Informatica\AbInitio ETL tools and Teradata BTEQ, Appworx

and Perl/Shell scripts

Participate in requirements meetings with Business Users to understand and collect

segmentation and project requirements and prepare technical design documents for the

conceptual, logical and physical design and review with the team members

Collaborate with Data Warehouse, other Data Marts, Architecture, and Campaign

Management teams to design and develop new solutions.

Optimize the data structures to enhance data load times.

Tuned Teradata SQLs for data movement jobs and queries to improve data load times and

end-user data access response times.

Perform Unit testing of the code and follow the IMD release procedures to migrate the code

to Production.

Identified and diagnose data quality issues and provide recommendations on solutions

Manage issue resolution process to ensure all user data quality issues are proactively

researched and resolved

Manage batch schedule and conduct performance testing with DBA team

Stay up-to-date on Information Management design/architecture in order to understand

downstream impacts to the assortment planning systems and processes

Document the requirements, resolve ambiguities and conflicts.

PROJECT DETAILS

Client Information Resources Inc., Chicago, USA

Period Apr ’05 – Dec ‘05

Description

Project Name: Market Knowledge – Builders (MK-Builders)

Information Resources Inc., (IRI) is the leading global provider of enterprise market

information solutions for the CPG, Retail, and Healthcare industries. The initiatives are

focused on improving the currency, completeness and correctness of its marketplace

information to provide faster, more accurate, and more actionable market information to its

customers globally.

Builders - is an integrated data environment, providing the consumer insights needed to help

build sales analytical reports. It provides easy access to consumer purchase behavior and

demographic profiles for categories and retailers. Builders identify consumer traffic

opportunities by category at the account level. It fuels category management decisions and

templates including category role, assessment, score carding, setting strategies and category

review. Builders help uncover opportunities to focus on a retailer’s key shoppers and build

shopper loyalty in general and specific categories.

Role: ETL\BI Solution Lead

Responsibilities

Worked closely with the end users in writing the functional specifications based on

the business needs

Based on the requirements created Functional design documents and Technical design

specification documents for transformation and loading

Translating of client’s strategic vision into technical solutions and application

identification

Designing and reviewing the Erwin data model in Oracle 9i

Designing and reviewing the ETL solutions in Informatica 7.1

Analytical reports using WhiteLight AnalyticServer 4.3

Worked close with BO XI R2 team to tune the reporting Application at ROLAP level

and DB queries Tuning.

Mentoring the team in the technology, design and development areas

Developed Builders Suite an integrated reporting environment that supplies clients

with insights into consumer behavior by integrating panel, store, and demographic

data

Created Consumer Decision Maps that provide both the UPC- and segment-level

insights you want at the price you need

Ensure strict adherence to committed deadlines as per project development /

implementation schedule

Negotiating with customer for handling new change requests

Participate project review meetings

Ensuring adherence to quality processes

Extracted data from legacy applications into the EDW environments, programming in

SQL to perform the data Query functions for Teradata.

Provided a full scope of the data warehouse needs-including space, processing,

design, normalization, scripts for loading, extracting, and manipulating data using

Informatica.

Environment

Informatica 7.1, Erwin 4.2 WhiteLight Analytic Server 4.3, Oracle 10g, Teradata, RedHat Linux,

Windows2000 Advance Server, Oracle 9i, HP-UX 11.11

Client Information Resources Inc., Chicago, USA

Period Apr ’04 – Apr ’05

Role: ETL\BI Solution Lead

Description

Project Name: Black Bird (Group I)

Information Resources Inc., (IRI) is the leading global provider of enterprise market

information solutions for the CPG, Retail, and Healthcare industries. The initiatives are

focused on improving the currency, completeness and correctness of its marketplace

information to provide faster, more accurate, and more actionable market information to its

customers globally.

Role: Data Analyst/ ETL Developer

Contribution

1 Gathering the business requirements from the end user and understanding the existing

system

2 Analyze the nature of data and understand the data model

3 Understand the design specifications send by the client

4 Translating of client’s strategic vision into technical solutions and application

5 identification

6 Designing and reviewing the ETL architecture

7 Building the dimensional model in Analytic server

8 Mentoring the team in the technology, design and development areas

9 Unit and Integration testing

10 Negotiating with customer for handling new change requests

11 Responsible to run Consumer Report Network a consumer panel that provides consumer

behavior data so that sales and marketing professionals can create new strategies

12 Part of team to develop RxPulse Net-a web-based reporting tool that empowers retailers

and manufacturers to better leverage the Sales Strategies. Involved in requirement

gathering and engaged with Client Interaction while conducting feasibility study on

Functional Requirements

13 Loading/Refreshing IRI Data Marts based on Daily/Weekly data.

14 Working knowledge on different data sources ranging from flat files, Excel 2000, Oracle

9i

15 Created and Managed Models and Worksheets in OLAP Tool WhiteLight Analytical

Server 4.3.

16 Maintained Datamarts in SQL Server and involved in Part time DBA activities.

Environment

Informatica 7.1, WhiteLight AnalyticServer 4.3, Teradata V2R5, Oracle 9i, HP-UX 11.11,

Windows2000 Advance Server, MS-SQL Server 7.0

Client National Grid Transco, UK

Period Sep’03 – Apr’04

Role: Solution Lead

Description

Project Name: Gas Transmission - PROGRAMME

National Grid is dedicated to being the world’s premier network utility. Its core skills lie

primarily in the management of large and complex energy delivery networks. It owns,

operates and develops the high-voltage electricity transmission network in England and

Wales and Great Britain's principal natural gas transportation system.

Role: ETL Analyst

Contribution

1 Executed data warehouse solution for GT-Program, Transco U.K in the consulting

capacity

2 Supervised and worked with a team of 5 associates with overall responsibility for the

quality and defect free delivery of the end product.

3 Managed the defect prevention by convening causal analysis meetings at regular

intervals.

4 Recruited and trained new associates.

5 Experienced in Data warehouse Data Modeling and Database Designing and all aspects

of software and data warehouse development and related quality processes. Proven

ability to motivate team and maintain high morale.

6 Directly worked with project management and contributed for improving team planning,

time management, productivity and quality at project application level.

7 Excellent techno-marketing and presentation skills demonstrated during client visits.

8 Extensive expertise in implementing complex business rules by creating re-usable

transformations, and robust mappings/mapplets in Informatica 6.0

9 Implemented strong and in-depth knowledge of Index in Oracle to improve the query

performance.

Environment

Informatica 6.0, Teradata, Oracle 9i, HP Tru64 UNIX V5.1A, Windows NT,

Client National Grid Transco, UK

Period Jan ’02 – Sep’03

Location Solution Lead

Description:

Project Name: Ulysses, Shipper Services DWH

National Grid is dedicated to being the world’s premier network utility. Its core skills lie

primarily in the management of large and complex energy delivery networks. It owns,

operates and develops the high-voltage electricity transmission network in England and

Wales and Great Britain's principal natural gas transportation system.

Role Data Warehouse Developer

Contribution

• Involved in Full Life Cycle Development of building a Data Warehouse.

• Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions.

• Extensively involved in writing scripts to Extract, Transform and Load raw data into tables

as part of Data Warehouse development using Informatica Tool

• Implemented Partitioning, Folder and session migration and Repository administration.

• Exposed in Cognos (Impromptu Administrator, Transformer, Power Play).

• Experience in Dimensional-Modeling using star and snowflake schemas for OLAP

environments.

• Worked on Cognos Impromptu and Powerplay to deliver the End User reports.

• Extensively used PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.

• Exceptional analytical and problem solving skills. Team player with the ability to

communicate effectively at all levels of the development process.

• Responsible for requirements, specifications & guidance for Data Warehousing design,

including Cognos reporting and analysis requirements, metadata for business metrics, KPI’s,

and scorecard data components; and logical dimensional model design, application design for

management of dimensional data extract, transformation & load (ETL), data validation,

controls and acceptance criteria

Environment: Informatica 5.1, Oracle 9i, HP UNIX, Windows NT, Cognos 7.0

Client Lloyds TSB Bank, UK

Period Dec ’98 – Jan’02

Description:

Project Name: Embankment Reports

Role: ETL Developer

• Responsible for creation of logical data models based on entity-relationship diagrams.

• The models were developed in accordance with the rules of referential integrity and

normalization.

• Involved in interacting with the business community to understand their requirements.

• Design and developed PL/SQL procedures, packages and triggers to be used by team

members.

• Created materialized views to increase the speed of queries

• Created test databases to test and tune the queries.

• Designed and implemented user interface with various VB Controls and Components.

• Implemented various types of Reports on date, amount and quantity criteria

Environment: VB 6.0, SQL, PL/SQL, Oracle 8.x, Windows 98/2000.

Contact this candidate