Jayaprakash Kurunnantavida

Email: abh284@r.postjobfree.com, abh284@r.postjobfree.com

Summary of Experience

• 13 years of IT experience which consists

• 10 Years of Design & Development experience in complex Data Warehousing, Business Intelligence solutions using

Microsoft SQL server Suite, Oracle, Informatica, Business Objects, MDX Queries, TSQL, PL/SQL, Baan Tools, ProClarity,

FAME, Crystal Analysis Pro, DTS Packages, SSIS Packages, SSAS, Crystal Reports, Cognos, Panorama, MicroStrategy,

ProClarity, Reporting Services AND custom made reporting tools in .Net framework.

• 2 Years of Microsoft Corporation USA experience in developing BI Solutions.

• 2.5 Years of Baan ERP experience and exposure to Oracle Financials.

• 2.5 Years of OLTP application development experience using Oracle and Developer 2000(Forms 5).

• Over 5 years of Dimensional and ER modeling experience by using ERWIN & Visio.

• Expert level skills in developing Strategies for Extraction, Transformation and Loading (ETL) mechanisms.

• Expert level skills in Requirement gathering and implementation of Business Intelligence & Data warehousing solutions for

various domains like Telecom, Sales, Manufacturing, Inventory management, Banking, IT etc.

• Microsoft SQL server 2005 Business Intelligence Application Development Certification.

Area of Specialization : Data warehousing & Business Intelligence.

Database : SQL Server (7.0, 2000, 2005, 2008), Oracle

(7.x, 8,8i), Access, Fame (Time Series Database)

ERP : BAAN 4, BAAN 5, Oracle Financials (10,6)

ETL Tools : Informatica, BAAN ETL Modeler, DTS & SSIS Packages

OLAP Tools : Microsoft Analysis Server 7.0, 2000 & 2005, 2008,

MicroStrategy9, Crystal Analysis Pro, Business Objects,

Hyperion Essbase 6.2

Reporting Tools : Panorama, ProClarity, Crystal Reports 8.5, OLAP Client 3.0,

Custom Reporting tools (ASP.net)

Development Tools : SQL Server Management Studio,

SQL Server Business Intelligence Development Studio,

BAAN Tools, Developer2000, Erwin,

SQLLOADER, TRANSLOADER

Operating System : Windows, UNIX (SOLARIS)

Source Control : VSS, CVS.

Languages : C, SQL, PL/SQL, SQL*PLUS, BAAN 4GL.

Other Tools : Toad 7.0, Tortoise

Professional Experience:

1] Client : Sprint Nextel, Overland Park KS (US) [May 07 to Till date]

Projects:

• EVDO Flux: Lucent, Nortel and Motorola Flux tool development and version upgrades.

• CDMA Flux: Lucent, Nortel and Motorola Flux tool development and version upgrades.

• Iden Flux: Flux tool development and version upgrades for Iden.

• Air interface Tools: Lucent, Nortel and Motorola Flux tool development and version upgrades.

• Capacity Tools: T1, T1 Aging, Q chat Flux tools development and upgrades.

Flux Project is a fast paced Business Intelligence/ Data warehousing project implemented by Sprint Nextel, Networking Group for

performance monitoring of network for all the Vendors for EVDO, 3G1X and Iden platforms. It holds virtually all pegs/ Measures from all

switches for all EVDO vendors; holds majority of pegs/ Measures from all switches for 3G1x and iDEN.

Flux Mediation (using Perl), Mediates the OM, parameter, Neighbor list data from Motorola, Samsung, Nortel and Lucent vendors,

processes and converts the data from vendor specific to Sprint standardized format so that Flux ETL (using SSIS) can load the data

into the Flux data warehouse (SQL server) and this data is processed using Analysis server cubes (using MSAS) and the client

applications (Panorama, Excel, Reporting Services) uses this data to generate reports and do various analysis.

Platforms Used: SQL Server 2000, 2005, 2008, SQL Server Management Studio, SQL Server Business

Intelligence Development Studio, Analysis Server (MSAS) 2000, 2005, 2008, Panorama, Reporting Services.

My Roles & Responsibilities

• Working with Business Analysts to finalize the user requirements.

• Design & Development of SQL database structures, Olap database structures, SSIS and SSAS packages.

• Coordinate with the offshore team for various development & maintenance activities.

• Responsible for performance enhancements of OLAP cubes across the platform.

• Handling Production deployment and UAT issues.

• Creating Reports in Panorama, reporting services.

• Working with end users for their reporting needs.

2] Client : Microsoft Corporation (US) [March 05 to May 07]

Projects:

1. Curve Monitoring System. [Jan 07 to May 07]

Curve Monitoring System is meant for facilitating improvements in performance and stability in Hotmail by analyzing various

measurements across various dimensions.

These measurements are generated by a system called "Monitoring Curves" which provides both simple counters and arrays of

counters (buckets) that allow tracking and distribution of measurements as a histogram covering range of values. These Measurements

are extracted in every 10 minutes into the CMS database partitioned tables. Analysis Server Cube is built on top of these partitioned

tables. Olap partitions are also used for faster processing and retrieval of the data.

My Roles & Responsibilities

• Developed the stored procedures in SQL Server for extraction/transformation & Loading from the source system to the

target.

• Designed and Developed the Cubes/ Dimensions in Analysis Server using SQL Server Business Intelligence Development

Studio.

• Created the XML Scripts for creating and processing the cube/ dimension/cube partitions etc.

2. Net Availability Reporting. [Nov 05 to Dec 06]

The Net Availability Report is designed to give the supply chain planning community a glance into the health of an SKU at the Plant

level. Based on the Net Available Quantity and the number of Weeks On Hand, they can make decisions about building, planning, and

sales plan for that SKU. The data is going to be aligned according to where the supply & demand fall in their respective Fiscal Weeks.

My Roles & Responsibilities

• Created the Technical Spec, Build Document, Operational Guide and Release Notes

• Designed and Developed the Cubes/ Dimensions in Analysis Server using SQL Server Business Intelligence Development

Studio.

• Modified the data source views by means of adding the new views and adding and modifying the named queries to meet the

design requirements.

• Created Calculated Members and KPI’s for analysis using MDX Functions.

• Designed and Developed reports in ProClarity.

• Created the test scenarios and carried out unit testing.

• Created SSIS Packages in the MSDB and setup SQL Agent Jobs for processing the cube.

• Made use of the Usage based optimization wizard to design the aggregation for partitions.

• Used SQL Profiler and Performance monitor to analyze performance bottle necks.

• Defined the VSS development Structure automated the Build for the deployment.

3. GPS Mart [Mart system for Global Planning Data mart] [May05 to Nov05]

GPS Mart is a data mart system for the Analysis & reporting of Operational and Finance related forecasting and corresponding actual

sales.

My Roles & Responsibilities

• Gathered, Analyzed the requirement and designed the data mart.

• Prepared the technical documents for the design.

• Developed the dimensional models of the data marts using Erwin.

• Designed and developed the cubes in analysis server.

• Carried out unit testing and created the Installation manual for the solution.

Platforms Used: SQL Server 2000, 2005, SQL Server Management Studio, SQL Server Business Intelligence Development Studio,

Analysis Server 2000, 2005, ProClarity, Erwin

3] Client : Deutsche Bank (London & New York)

Project : DbReport [Reporting system Data warehouse] [Sep04 to March05]

Team Size : 40

Platforms Used : Oracle 8.1.7.4, MSOLAP (Microsoft Analysis Services), Hyperion Essbase 6.2,

Informatica6.1, Hyperroll, SqlNavigator 3.1, Toad7.0 and Windows 2000.

Modeling Tool : Erwin.

FRONT END : WEB BASED AND EXCEL ADDINS.

DbReport is meant to bring both dbCube (London) and Data services (NY) into one common reporting framework.

DbCube application is used as Risk reporting tool. Currently Market risks (GPC), Liquidity Risk (LiMA), Operational risk, and Daily PL

application uses dbCube framework for reporting. The application is a multi dimensional product allowing the users to drag and drop

the dimension and gets the reports instantly in web front end/Excel Addins that gets the data from Essbase and MSAS cubes. Each of

the application has its own cube building process steps pre defined using Oracle objects. After each successful completion of the cube

build process, the users can retrieve the data from the web front end or Essbase excel addin/MIS Plain software.

DATASERVICES IS A WEB BASED MIS FRAMEWORK THAT ALLOWS USERS TO VIEW AND ANALYZE A BROAD SPECTRUM OF

BUSINESS INFORMATION THROUGH FRONT END.

My Roles & Responsibilities

• Visited Client place for the requirement gathering.

• Worked as a technical architect for the project.

• Analyzed, gathered the requirement and developed the data models.

• Designed the complete data warehouse architecture.

• Interacted with the database administrators, Project Managers, Business Managers etc during the requirement analysis

phase.

• Conducted feasibility study of the existing technologies to use in the new solution.

• Prepared the requirement analysis, technical design documents and done the knowledge transfer to the development team.

• Designed and migrated the existing Essbase cubes into MSAS cubes.

5] Channel Wave Business Intelligence Solution [Oct03 to Sep04]

Channel Wave CA, [USA]

Client :

Platforms Used : SQL Server2000, Informatica6.1, Microsoft Analysis Server, Erwin4.0 and Windows 2000

Front End : ASP.Net (Dot Net Framework)

Channel Wave provides outsourced solutions to companies engaged in selling products direct to the end customer, or through multi

channel partners such as dealers, VARs and retailers.

“Channel Wave Business Intelligence” is a combination of applications, databases and a presentation layer (Graphic User Interface or

GUI) that work together to allow users to receive the right information (data) at the right time, based on the user’s job function and

permission rights. The project was in 2 phases.

The first phase of this project is about developing the reporting framework and the MSAS cubes for creating and accessing the

predefined reports given by channel wave. The second phase of the project is about redesigning the data warehouse as per the

proposal given during 1st Phase and introducing additional functionalities to the reporting framework.

My Roles & Responsibilities

• Designed and implemented the data marts/data warehouse which took data from 2 transactional sources.

• Designed and developed cubes in Analysis server. Design has 22 cubes and 23 dimensions. Out of the 22 cubes 10 are

invisible, 3 cubes are Virtual cubes. Rests of the cubes are based on 6 Data marts and some of them on views which are on a

different aggregation level as compared to the fact table.

• Designed the extraction and loading methodologies.

• Performed the reverse engineering by using ERWIN to get the existing data model and re developed the complete data

model for the solution.

• Created source and Target definitions, Developed some of the complex mappings using various transformations, created

reusable transformations and Mapplets.

• Developed sessions, tasks etc by using workflow manager.

• Designed and developed the additional MSAS cubes.

• Prepared the test cases and test scripts for the data warehouse and as well for the cubes.

• Carried out Performance improvements on processing and querying the cubes.

• Carried out performance testing of reports.

• Designed and developed the DTS jobs for scheduling the cube processing.

• Carried out the performance improvement on the MDX queries that are generated through the front end application.

Software Projects from BAAN Info system MAY01 to OCT03

My Roles & Responsibilities

• Design & Development of Business Intelligence Solutions (Data warehousing) in various functional domains of BAAN ERP.

Responsibility mainly consists of

Feasibility study of the Source system with respect to the DS (Definition Study).

Writing the FD (Functional Design), TD (Technical Design).

Developing the BAAN 4GL export scripts for the extraction of data.

Developing the ETL Models using BAAN ETL Modeler for building the data mart.

Development of Cubes using Microsoft Analysis Server.

• Involved in the Reviews and Technical Design of all Business Intelligence Solutions.

• Played a role as a mentor and a guide to the team

• Involved in conducting interviews for new candidates.

Platforms Used:

Baan IV, Baan V (Corelli and Reger environment), SQL Server 7, 2000, Olap Server, Analysis Server, Business Objects 5.0, Windows

2000, NT.

Tools Used: ETL Modeler, DTS Packages, and Baan 4gl Script.

Front End: Olap Client, Crystal Analysis Pro & Crystal Reports

7] Migration of Existing BIS Solutions [Jan03 to Oct03]

Client BARCO [Belgium]

:

THIS PROJECT IS FOR MIGRATING THE EXISTING BUSINESS INTELLIGENCE SOLUTION TEMPLATES OF SALES,

PURCHASE, FINANCE, PLANNING FROM BAAN CORELLI TO BAAN REGER ENVIRONMENT.

My Roles & Responsibilities:

• Team lead for the migration of the above mentioned BIS Templates.

• Modified the DW and cube design to accommodate the changes in the source system.

• Conducted reviews and technical discussions.

• Coordinated between the Customer and the team with the design issues.

• Responsibility involved in assuring the performance and Quality of the templates.

8] Service Watch [Oct02 to Jan03]

Client BAAN Consulting Organization [Holland]

:

THIS PROJECT IS FOR BAAN CONSULTING ORGANIZATION IN HOLLAND. THIS IS A CUSTOMIZATION OF AN EXISTING BAAN

4PROJECT STANDARD BUSINESS INTELLIGENCE SOLUTION TEMPLATE TO MEET SOME ADDITIONAL REQUIREMENT.

My Roles & Responsibilities:

• Created Technical and Functional Design Documents.

• Modify the Baan export scripts to accommodate the design changes.

• ETL Model development for Loading /populating the data marts.

• Cube Development Cubes using Microsoft Analysis Server.

8] Waterfall Project [May02 to Oct02]

Client : Defense Aviation Repair Agency (DARA)[UK]

Waterfall Data Warehouse for DARA covers the Project Industries analysis and reporting requirements to produce waterfall analysis at

two specific points as forecasted Projects and actual Projects and compare the differences against them within a time frame.

Implementing this Business Intelligence Solution would ensure a consistent data analysis of actual and forecasted amounts and

quantities.

My Roles & Responsibilities:

• Visited BAAN Holland to discuss the functional requirement of DARA with BAAN Functional consultants and Client.

• Architected the entire design which includes design of star schema, Fact and Dimension tables and Analysis Server Cubes

• Created Technical and Functional Design Documents.

• DEVELOPED SCRIPTS TO EXPORT THE DATA FROM BACKEND SYSTEM.

• Developed ETL Models for Loading /populating the data marts.

• Developed Cubes using Microsoft Analysis Server.

9] Standard Business Intelligence Solution Template For Projects

[Data Warehouse] [Dec01 to May02]

My Roles & Responsibilities:

• Architected the entire design for Project Industries of BAAN Vertical. Design includes Functional & Technical Definition of the

Star schema and Analysis Server Cubes.

• Developed BAAN 4GL export scripts to export/transform data BAAN ERP Source system TO SQL Server Tables & Flat files.

• Developed ETL Models for Loading /populating the data marts.

• Developed Cubes using Microsoft Analysis Server.

10] BI Solution Template for Sales & Sales Quotation [Jul01 to Dec01]

My Roles & Responsibilities:

• Developed BAAN 4GL export scripts to extract & transform data from BAAN ERP Source system TO SQL Server Tables &

Flat files.

• Developed ETL Models for Loading /populating the data marts.

• Developed Universe and created Reports.

Software Projects from TCS [Tata Consultancy Services] Jul00 to May01

11] NETA Economic Database (NED)[Data warehouse]

N.G.C (National Grid Company U.K Govt. Organization)

Client :

Platform : Oracle8i, Solaris.

Front End : Web Based front end, Cognos, Fame

Duration : 1 year.

The NED system is a 3 tier web technology based intranet environment. Data is collected from a number of data sources on a daily

basis, either as data files or by direct access to remote databases over an Oracle database link connection. This data is reformatted

and loaded into the NED staging area, which is an Oracle 8i database on a Solaris 8 server. Relevant data from the staging area is

used to load a time series database (FAME on the Solaris 8 server) where it is stored, interpolated and aggregated. This aggregated

data returned to the staging area. Users through the NED intranet interface can access the time series database. Selected users can

also export the time series data into Excel, through an add in. The raw and aggregated data in the staging area is loaded into the NED

data warehouse by a transformation process. The data warehouse is an Oracle 8i database on the Solaris 8 server. This data

warehouse is accessed using a selection of Cognos tools via the intranet interface.

My Roles & Responsibilities:

• Writing procedures in Oracle and Fame.

• Writing shell scripts for invoking different processes according to their different stages of the data flow.

• Making the FAME configuration files for data loading from oracle to fame, fame to oracle by using the Transloader Utility.

• Making the Catalog Browser for viewing the data structure diagrammatically.

Software Projects from EXI Jul99 to Jun00

My Roles & Responsibilities

REQUIREMENT GATHERING, ANALYSIS, CODING AND INTERACTING WITH THE CLIENT, DESIGNING THE SCHEMAS,

DESIGNING AND DEVELOPMENT OF FRONT ENDS USING FORMS DEVELOPER 2000, WRITING THE NECESSARY BACK END

PROCEDURES, FUNCTIONS, TRIGGERS AND PACKAGES.

Platform : Oracle 8, Developer2000, windows 98, Erwin

No Project Client Project Description

1 Development of Invoicing System Indian Smelting & Refining INVOICE SYSTEM DEVELOPMENT (OLTP)

Co. Mumbai.

2 Development of Inventory System Indian Smelting & Refining INVENTORY SYSTEM DEVELOPMENT (OLTP)

Co. Mumbai.

Software Projects from Microsys Information Technologies Nov97 to Apr99

My Roles & Responsibilities

REQUIREMENT GATHERING, ANALYSIS, CODING AND INTERACTING WITH THE CLIENT, DESIGNING THE SCHEMAS,

DESIGNING AND DEVELOPMENT OF FRONT ENDS USING FORMS DEVELOPER 2000, WRITING THE NECESSARY BACK END

PROCEDURES, FUNCTIONS, TRIGGERS AND PACKAGES.

Platform : Oracle7.1, Developer2000, windows 98, Erwin

No Project Client Project Description

1 Automation of car service center ANEKAR MOTORS SYSTEM TO TRACK THE CARS COMING FOR

BANGALORE. REPAIRS. (OLTP)

2 Sales Order Processing ALWAE ENGINEERING THE APPLICATION IS INTENDED TO EASE

WORKS. BANGALORE THE PROCEDURE OF MANUFACTURING OF

SIMPLE MACHINERY PARTS AND SALES

ORDERS.

Academic Qualification

Bachelor of Engineering (BE) IN Civil Discipline from BMS College of Engineering, Bangalore University, Bangalore, India, 1997.

Successfully completed the requirements to be recognized as a Microsoft certified Technology Specialist (MCTS): Microsoft SQL

server 2005 Business Intelligence Application development.

Contact this candidate