LAKSHMI JAYARAM

**** ***** **, ***********, ** 919-***-**** abnuog@r.postjobfree.com

Dedicated IT professional with exceptional data warehouse, database, and business

intelligence skills with more than 3 years’ experience

SUMMARY OF QUALIFICATIONS

Strong experience in End to End delivery of OLAP and ETL solutions

Demonstrated expertise utilizing tools and technologies like Microsoft DW and BI suite of

products, Cognos Reportnet, Business Objects, Informatica, Trillium, and Embarcadero.

Strong leader with experience training developers and advising technical groups on ETL

and Reporting best practices.

Strong knowledge of development methodologies such as water fall and iterative and

familiarity with agile methodology.

Team player with excellent communication and problem solving skills.

TECHNICAL SKILLS

ETL: Informatica Power Center 7, 8, Power Exchange,

PL/SQL, Data Stage

OLAP/Reporting: Business Objects XI R2, Cognos ReportNet, SQL

Server Reporting Services

OS: Windows NT/2000/XP, HP-UX, Sun Solaris,

UNIX/LINUX

Programming: Java, HTML/XML, Visual Basic

Databases: Oracle 9i, SQL Server 2005, IBM DB2 UDB 8, MS

Access

Data Modeling: Embarcadero Data Modeler

Performance Management Software: Microsoft Business Score Card Manager, Microsoft

Share Point Services (for deployment of Score

Cards), Microsoft Performance Point Server

Data Cleansing Tools: Trillium

Project Planning and Execution: MS Project, MS Office, MS Visual SourceSafe

PROFESSIONAL EXPERIENCE

Cognizant Technology Solutions India Pvt. Ltd, Bangalore, India Oct, 2005 - May, 2008

Representative Project Experiences

Contact Deduplication – Cendant Corporation

Duration – 6 months Peak Team Size - 6

Contact Deduplication project was aimed at minimizing the duplicate customer records in

the Contacts list database of Cendant Corporation.

As a developer in the project, was involved in overall design, development, testing and

deployment of an ETL solution.

Tools used were Oracle 9i, Informatica 7.1, Trillium 6.5

Developed Trillium modules to identify duplicate data and enhance data quality

o

Developed Trillium Informatica PowerCenter mappings and other widgets.

o

Developing a data warehouse for Newsprint Consumption and Circulation (NCC)/B2B – New

York Times

Duration – 15 months Peak Team Size - 20

NCC/B2B was a project to create Business Intelligence Reporting System for New York

Times business modules – Newsprint Consumption and Circulation, Business to Business

Portal System.

Worked as a Module Lead and Data Modeler and was also a Quality Leader for the project

My responsibilities were

System study, Collecting requirements and Studying the Enterprise Data

Warehouse Architecture and Roadmap to understand dependencies and

constraints from a reporting stand-point

Data modeling to build the Reporting Data Mart

To lead a team of 5 people for development of reporting solutions

Ensuring quality of end products by conducting multiple rounds of reviews

As a Team Leader, calculated efforts and compiled MS-Project plan, staffing org-

chart.

UAT support after development

Tools used were Business Objects XI R2, Informatica, PL/SQL on Oracle 9i,

Embarcadero –

ETL development using Informatica and PL/SQL

Data modeling (both logical and physical) using Embarcadero

BO universe design, report design, testing and deployment

Reports were designed using Web Intelligence and deployed in Infoview

Reports had to be integrated into Business portal using SDKs

Used Derived tables to create the universe for best performance, and use

context and alias tables to solve the loops in Universe.

Exported the Universes to the Repository to make resources available to

the users for ad-hoc report needs.

Created different reports containing charts showing revenue and

operating income by different divisions, market share of newspaper by

circulation.

Provided the security access management by creating users/groups and

folders.

Developed universe user documentation guide for the end users

reference. Provided training for end users for generating their own report

including complicated report.

Building a product demo for Microsoft Corporation as a Technology partner

Duration – 3 months Peak Team Size - 6

Project was to develop a demo for Microsoft Corporation to showcase Performance

Management Application for IT Services vendors as part of Industry templates. As part of

the project, a complete score carding solution was built for Defects Tracking in Cognizant

My contributions were

Identifying Key Performance Indicators

Build Reports and Score Cards and integrate them in the SharePoint portal

Solution was built using Microsoft SQL Server 2005, Business Scorecard Manager, Share

point Server, SQL Server Analysis Services and SQL Server Reporting Services

Please find below the link for the Microsoft site where the solution was published:

http://eossp.partners.extranet.microsoft.com/en/Documents/SolutionsDetails.aspx?Solu

tionId=4884

Build a Performance Management System for Partners for American Standards (ASD)company

Duration – 6months Peak Team Size - 10

Project was to design, develop, build, test and implement scorecards and reports that

would provide information regarding the performance of each of the partners to ASD

My role as a module lead entailed

Identifying Key Performance Indicators

Build Reports and Score Cards and integrate them in the SharePoint portal

Solution was built using Microsoft SQL Server 2005 database and Business Intelligence

Suite along with Microsoft Business Score Card manager

Porting Data from Legacy system to an ODS for Blue shield California

Duration – 12 months Peak Team Size - 25

Project was to build an ETL solution to move legacy claims and provider related data to

new technologies and develop Integrated Data Store

My role involved leading a team of 5 in developing one module of the project and also to

act as a Quality leader for the entire project.

My contributions were

Developing the ETL entities in Informatica Power Center and data maps in

Informatica Power Exchange to import data from COBOL based sources such as

VSAM

Process reviews and Quality checks on all deliverables across the project

Worked on Value Addition projects

Was part of a team that developed a tool that automated quality testing of Informatica

PowerCenter widgets such as mappings, sessions and workflows. The tool cut down testing

time by a significant percentage. The tool automatically tested the widgets for adherence to

coding standards and coding errors.

As a member of Microsoft Center of Excellence in DW/BI, have participated in activities like

Developing training materials

Developing PPTs for capability presentations

Overall, capacity building

Prudential Financial Corporation, Scranton, PA, March 2005 – July 2005

Data Warehouse Consultant

Worked as a report developer assisting Annuity team in building Business Intelligence reports

using Cognos ReportNet

Worked with the business team to understand requirements and properly communicate them

to technical team

East Stroudsburg University, PA Jan 2002 – May 2004

Teaching/Lab Assistant

Administered UNIX labs

Assisted in teaching Computer Programming subjects

EDUCATION AND TRAINING

Master of Science in Computer Science, East Stroudsburg University, Pennsylvania, May 2004

Bachelor of Science in Computer Science, Kerala University, India, June 2001

AWARDS AND CERTIFICATIONS

IBM Certified Database Associate in DB2 UDB – May 2005

Sun Certified Java Professional – May 2004

Scope Award for Excellent Performance – Cognizant Technology Solutions, Bangalore

Have EAD (Employment Authorization Document)

Contact this candidate