CURRICULUM VITAE

APARAJITH K V

*** ****** **, *** **,

Ph: (502) 759 - 8244

Pasadena, CA 91106 USA

acd70l@r.postjobfree.com

[pic]

OBJECTIVE I am looking for a challenging career which gives me ample

opportunities to learn, share and use technology. I am

currently working for Cognizant Technology Solutions in

Pasadena, CA and willing to relocate within the US.

PROFESSIONAL SUMMARY

. Over 6.5 years of experience in Software Application Development with

emphasis on Microsoft Business Intelligence (MS BI) tools - SSIS, SSAS

and SSRS with SQL Server 2005/2008/2008 R2 and lately SQL Server 2012.

. Experienced in SQL Server database design, maintenance and

administration along with ETL processes and providing High

Availability solutions.

. Involved in Data Modeling and creating Data Warehouse.

. Hands on experience in building dashboards and scorecards using

Microsoft PerformancePoint Server 2010 (PPS) and writing MDX queries.

. Experienced in creating and customizing sites/portals and deploying

dashboards and BI reports (PPS and SSRS reports) in Microsoft

SharePoint 2010.

. Exposure to XML Processing and MS Excel Reporting.

. Involved in Deliverable, Release management activities, Configuration

management and CC audit activities with hands on experience in tools

like VSTF, VSS and Rational Clear Case.

. Good Experience in complete SDLC process.

. Flexible and versatile to adapt to any new technologies and tools.

Technical Skills

Operating Systems Windows 98/XP/Win 7/Server 2008 R2

Technologies SSIS, SSAS, SSRS, PPS, MDX, SharePoint 2010

Integration

Databases MS SQL Server 2005/2008/2008 R2/2012

Tools TFS, VSS and Rational Clear Case, Power Pivot

CERTIFICATION

[pic]

PROFESSIONAL EXPERIENCE

1. EDS/XAA Application

Client: OneWest Bank, Los Angeles, USA

Duration: 3 Months

Technology and Tools Used: SSIS, SSRS, SQL Server 2008 R2

OneWest Bank specializes in mortgage and commercial banking. EDS

(Enterprise Data Store) is an end to end application responsible in

sending timely reports to the treasury and other downstream systems.

XAA, on the other hand, is a critical system that encompasses the

various commercial services that OneWest provides so its customers can

be charged for those services.

Role Played:

. Design of the XAA Data Warehouse - This includes the design and

development of the XAA data warehouse that would provide an

analytical platform for the various commercial services provided

by OneWest and would be used to charge the customers for those

services.

. ETL (SSIS) Development - Includes the design and implementation

of SSIS packages to fetch data from sources like BIC and

Banklink, and transform this data into an analytical form.

. 24/7 Production support for EDS - Providing on-call support for

the EDS application that includes hundreds of SSIS packages and

SSRS reports. This is a critical system that sends data to

several downstream systems and provides daily feed to the

treasury. This also includes managing an offshore team to ensure

the smooth functioning of the system while implementing frequent

enhancements and change requests.

2. Parallel Data Warehouse (PDW) BOH Data Migration

Client: KFC, USA

Duration: 4 Months

Technology and Tools Used: SSIS, PDW with SQL Server 2012

This is a POC executed onsite for KFC in Louisville, KY. It involved

transforming large amounts of Back of House (BOH) and franchise data

(>1 TB) into a Parallel Data Warehouse. An ELT engine was designed

using SSIS 2012 and PDW's dwLoader tool.

Role Played:

. Requirement gathering & Analysis with the customer.

. Formulating effort and time estimations for ELT development

. Converting the High level requirement to the low level design.

. Resolve all technical issues in connecting/executing an SSIS

solution is a PDW platform

. Analyzing the requirements and the complexity and come up with a

design of the Parallel Data Warehouse (PDW) system

. Code development, Unit testing and peer review.

. Design and Develop SSIS packages using best practices to

incorporate complex business logic and to accommodate PDW's

inherent changes and tools.

. Liaise with Microsoft to understand PDW's inherent changes and

to come up with the best design

. Performance tuning of SQL Server stored procedures using SQL

Server Profiler and drawing out execution plans

. Provided Knowledge Transfer to the customer and created

documentation on the design, development, implementation, daily

loads and process flow of the SSIS packages

. Deployed the solution to test servers and provided onsite

support.

3. Project Crystal

Client: KFC, Australia

Duration: 6 Months

Technology and Tools Used: SSIS, SQL Server 2008 R2

This project is for KFC Australia and the requirement was to

consolidate data from various sources and franchise data into an

enterprise data warehouse (EDW) and to build aggregate data so as to

facilitate easy reporting.

Role Played:

. Manage tasks at offshore for a team of about 4-5 members.

. Prioritize and assign development tasks

. Report weekly status to Onsite lead and manage contingencies

. Requirement gathering & Analysis with the client and onsite

team.

. Formulating effort and time estimations for ETL development

. Converting the High level requirement to the low level design.

. Resolve all technical issues and ad-hoc requests

. Analyzing the requirements and the complexity and come up with a

design of the Enterprise Data Warehouse (EDW) system

. Code development, Unit testing and peer review.

. Develop SSIS packages using best practices to incorporate

complex business logic.

. Design and develop complex SSIS Packages using various

transformations in Designer to extract the data from sources

like XML Files, Flat Files, Excel Files and SQL Server to

perform mappings based on client requirements and load into SQL

Server tables

. Provide technical assistance to team

. Tuning of packages in SSIS for optimal performance

. Performance tuning of SQL Server stored procedures using SQL

Server Profiler and drawing out execution plans

. Provided Knowledge Transfer to the end users and created

documentation on the design, development, implementation, daily

loads and process flow of the SSIS packages

. Come up with the Implementation plan which helps the Support

team to deploy the ETL code

. Facilitate deliverable preparation and delivery

. Review all deliverables.

4. Pitney Bowes Data Migration

Client: Pitney Bowes, USA

Duration: 5 Months

Technology and Tools Used: SSIS, SQL Server 2008 R2

This project involves migrating large amounts of CRM and SAP data from

flat files into SQL Server. We were involved in developing complex

SSIS packages that apply business logic on the data.

Role Played:

. Design of the Architecture - I was involved in analyzing the

requirements and the complexity and came up with a design of the

system.

. ETL (SSIS) design and development - I was involved in the design

and development of some of the complex packages for the ETL.

. Deployment - Includes working as a team and integrating the

solutions of all other developers into a master and testing the

solution against integration test cases.

5. JPMC - DPA & NetApp Integration

Client: JP Morgan Chase, Columbus, USA

Duration: 3 Months

Technology and Tools Used: SSIS, SSAS, SSRS, PPS 2010, SQL Server

2008 R2

DPA (Data Protection Advisor) is a EMC software primarily designed as

a reporting and estimation tool for its various storage boxes. This

POC is a complete BI Solution for integrating the DPA data and NetApp

data and providing custom reports hosted in a SharePoint portal.

Role Played:

. Design of the Data Warehouse - Given the requirements of DPA and

NetApp data integration, we designed an appropriate data

warehouse using SQL Server 2008. Activities included the

identification of facts and dimensions and various entity

relations and hierarchies.

. ETL (SSIS) and Cube (SSAS) - Includes the design and

implementation of SSIS packages in order to fetch data from both

DPA and NetApp sources into the data warehouse and development

of a multidimensional cube using SSAS.

. Report Development (SSRS & PPS 2010) - Includes development of

tabular reports, analytic charts, scorecards and dashboards

using SSRS 2008 and PPS 2010.

. Deployment in SharePoint 2010 - Includes building a portal and

deployment of the reports and creating connections between web

parts for drill down abilities.

6. eSMART Storage BI

Client: John Hopkins School of Public Health (JHSPH), Baltimore, USA

Duration: 3 Months

Technology and Tools Used: SSRS, MDX, PPS 2010, SQL Server 2008 R2

CLARiiON is a mid-range SAN disk array storage box manufactured by

EMC. eSMART is a complete BI solution that provides the users with a

reporting and estimation tool for their CLARiiON box. It consists of a

data warehouse that maintains analytical information about the usage

of the storage box. The tool also consists of a SharePoint portal

which hosts several capacity and performance dashboards and other

detailed reports developed in SSRS.

Role Played:

. SSRS 2008 R2 & MDX - My role in this project was mainly the

development of reports in SQL Server Reporting Services 2008 R2.

I was involved in the development of about 30+ tabular reports

and analytic charts leveraging the new features of SSRS 2008 R2

like data bars, spark lines etc. The reports fetched their data

from multidimensional cubes by the use of MDX queries.

. Dashboards and Scorecards in PPS 2010 - Included the development

of scorecards using PPS 2010 and integrating both PPS and SSRS

reports into dashboards and deploying them into a web portal

hosted in SharePoint 2010.

. TFS & Configuration Control - Played the role of CC for the

project by taking advantage of Microsoft Team Foundation Server

for the purpose of versioning and auditing.

7. ALSPICS - Historian Server Development

Client: ALSTOM, Paris, France

Duration: 9 Months

Technology and Tools Used: SSIS, SQL Server 2008

ALSTOM provides complete solutions for the power generation

requirements of its clients world-wide. ALSPICS is a part of the ALSPA

320 system which is an automation of the control systems of their

Hydro Electric Power Plants. There are two layers of operation in the

ALSPA system namely Controplant (built on the traditional RDS system)

and Optiplant (built on SQL Server 2008 platform). My role in the

project was the design and development of the Optiplant layer and the

migration of the Controplant layer from RDS to SQL Server 2008.

Role Played:

. Design of the Optiplant layer - Included the design of the data

warehouse and assessing the hardware requirements of the system.

. Data Integration - Design and implementation of SSIS packages

for the continuous integration of all the Controplant data into

the Optiplant layer taking advantage of some of the advanced

features of MS SQL Server 2008, like merge, etc.

. Development of a front end web application using ASP.Net and C#

to provide access to the alarms and events occurring in the

ALSPA system as per user's requirements.

. Performance Tuning - Optimizing performance by analyzing the

execution plans of the queries and introducing indexes on the

tables, query optimization, table and index partitioning,

compression of data for better storage, tuning the recovery

interval, etc.

. High Availability - Providing an optimal high availability

(redundancy) solution of the database system. Made POCs on Peer-

to-Peer Replication, Database Mirroring in different modes of

operations and also worked on Failover Clustering. Also

developed a mechanism to automate the Failover process in the

High Performance mode of Database Mirroring.

. Maintenance Activities - Creating an appropriate maintenance

plan for the system including taking regular backups, rebuilding

indexes, integrity checks, handling transaction log

fragmentation, etc.

. SQL Server Administration - Taking and restoring backups,

disaster recovery plans, managing logins, etc.

. Migration of Controplant layer from RDS to SQL Server 2008.

. SSRS - Made a POC in SSRS for providing a solution to the

client's reporting requirements.

8. Electrical Estimating Tool (EET)

Client: TYCO

Duration: 3 Months

Technology and Tools Used: SSIS, SQL Server 2005

EET is an electrical project estimating tool that enables the sales

person to estimate the cost of labor categories and installation

material entered to perform a project which has multiple "systems".

The "systems" are composed of electronic components or device types

which will drive the estimated labor cost and installation materials.

EET will provide a logical and detailed breakdown of the cost

estimation for different labor categories based upon the device types

entered.

My role in the project was to design an OLAP system which pulls its

data from above tool (an OLTP system) and populates a data warehouse

through an ETL process.

Role Played:

. Designed a Data Warehouse which can be further used for analysis

and reporting purposes.

. Developed SSIS packages and Stored Procedures to populate the

DW.

. Developed scripts in SQL Server 2005 to automate the test

scripts so as to facilitate faster and effective testing of the

application.

9. Services Application for Advanced Metrics (SAAM)

Client: Microsoft Technologies Ltd, Redmond, USA

Duration: 16 Months

Technology and Tools Used: SSIS, SQL Server 2008

SAAM is a legacy system aimed at providing a set of globally-agreed,

standard, timely and accurate reports by which the Services Business

can be managed. SAAM pulls its data from various upstream sources,

processes the same (through ETL steps) and generates Excel reports.

The ETL is handled through a number of Stored Procedures and SSIS

packages. Reports are generated in MS Excel and are hosted in a front

end web application developed in ASP .Net 2.0.

Role Played:

. Worked on SQL Server 2000 and 2008, primarily in OLTP Systems.

. SQL Server Administration - Monitoring of the backend,

scheduling jobs, trouble shooting production issues and

resolving them by query, schematic or design changes. Attending

to production job failures and resolving them. Other DBA tasks

like taking and restoring backups, managing the logins, etc.

. Performance Tuning - Introducing indexes, query optimization,

table and index partitioning and monitoring the performance.

. Conversion of DTS packages (created for ETL tasks) to SSIS

packages for better performance.

. Excel 2003 & 2007 - Designing and implementing pivot tables for

the generation of reports.

. Was involved in the development of the front end web application

using ASP.Net with C# for hosting the Excel Reports.

. Provided support on deployment in UAT and Live environment.

. Involved in coding, module integration, unit and integration

testing and release activities.

EDUCATION

Bachelor of Engineering, Information Science

P.E.S Institute of Technology, Bangalore, India

Awarded By: Visvesvaraya Technological University (VTU), Belgaum,

India

OTHER PERSONAL DETAILS

Visa Status: H1B Visa, Valid till March 14th, 2015

Contact this candidate