Microsoft BI Technologies - SSIS, SSAS, SSRS

Professional Profile

* ***** ** ******* ********** in Microsoft SQL Server Business Intelligence tools with an excellent background in MDX.

Specialized expertise in integration models including integrating various data sources to source front-end applications/ reports.

Expertise in designing analytical reports in Qlikview and Tableau.

Possess fundamental understanding in Capital Markets (Construction), Retail/FMCG/Manufacturing, Healthcare domains.

Ability to design and develop Data models for various business processes.

Working experience in business intelligence advanced visualization features including Dundas Charts, Heat Maps and Geospatial maps.

Experience in building Microsoft analysis services stored procedures, cubes/queries.

Ability to design, develop and deploy complex ETL processes.

Involved in full life cycle development of Data Warehousing projects spanning across ETL, OLAP (Cubes) and Reporting.

Experience in technical and managerial activities for an end-to-end implementation including developing and maintaining large data warehouses for complex business models.

Ability to create technical documentation and contribute in project estimation.

A Team Player with excellent communication, analytical, verbal and writing skills.

Knowledge of R and machine learning algorithms. Awarded for developing the best predictive model during course-work at IIIT-B.

I have been involved in the below mentioned activities across various projects

- Requirements Gathering

- Source system analysis

- Data modeling

- Integration layer design

- Calculation Layer Design

- Cube Design and development

- Code Review

- Unit testing and Integration testing

- User Acceptance Testing

- Production Deployment & Support

Experience Summary

June 2014 – Present

Enstoa Inc.

Consultant, Technical Solutions

Nov 2011 – Nov 2012

Enstoa Inc.

Business Intelligence Consultant

Jan 2010 – Oct 2011

MindTree Ltd.

Technical Lead

Jul 2009 – Dec 2010

MindTree Ltd.

Senior Programmer Analyst

May 2008 – Jun 2009

MindTree Ltd.

Programmer Analyst

Oct 2007 – Apr 2008

MindTree Ltd.

Programmer Analyst

Certificates & Awards

1.Top of the class at “Foundation course on Big Data and Analytics – IIIT-B”

2.Awarded for the best predictive model project – “Predictive Model to predict Energy Consumption”

Technical Skills

Operating Systems:

Windows 95/NT/2000/XP/10

Languages:

R Analytics, Advanced SQL, PL/SQL, .Net, MDX, VB

Databases

Oracle 8i, 9i, 10g

MS SQL Server 2005, 2008, 2008R2, 2012

Applications/Tools:

MS SQL Server Integration Service 2005, 2008, 2008R2, 2012

MS SQL Server Analysis Service 2005, 2008, 2008R2, 2012

MS SQL Server Reporting Services 2005, 2008, 2008R2, 2012

MOSS 2010, Sharepoint Services

Qlikview (Reporting)

Tableau (Reporting)

Erwin (Data Modeling), Toad, SQLPlus

Business Objects XI R2, Informatica

Professional Experience

Enstoa, Inc.

Consultant/ Database Architecture and Development

Jan 16 – May 16

Construction Industry Institute

New York, New York

Creating solution architecture for various algorithms designed to calculate complex metrics.

Used advanced SQL methods to develop and improve reporting algorithms for various metrics at CII.

Developed Enstoa reusable library for data processing and calculations of various metrics.

Had regular interaction with clients and was part of the maintenance/enhancement team for the entire duration of the work at Enstoa.

Enstoa, Inc.

Consultant/ Database/ ETL Architecture and Development

June 14 – Present

New York Presbyterian Hospital

New York, New York

Creating solution architecture for the specific business requirements which also focused largely on scalability and hence took the project to the next level of delivery ease and excellence

Served as ETL developer to develop, enhance and maintain transformations for the integration of data between Archibus and TMS as the sources and destination.

Continues to work on maintaining and supporting the various intergrations developed for NYP. More than 150 in all.

Had regular interaction with clients and was part of the maintenance/enhancement team for the entire duration of the work at Enstoa.

Enstoa, Inc.

Consultant/ Database/ ETL/ Report developer

Nov 11–Mar 12

Minera Panama

Panama City, Panama

Creating solution architecture for the specific business requirements which also focused largely on scalability and hence took the project to the next level of delivery ease and excellence

Served as ETL developer to develop, enhance and maintain transformations for the integration of data from SAP, Oracle Primavera and Excel data sources.

Worked on developing reports and analytics in SSRS, Qlikview and Tableau.

Served on critical monthly reports at client location in Panama.

Had regular interaction with clients and was part of the maintenance/enhancement team for the entire duration of the work at Enstoa.

Enstoa, Inc.

Consultant/ Database/ ETL/ Report developer

Mar 12-May 12

Cedars Sinai

LA, California

Served as the ETL developer to develop, enhance and maintain transformations for the integration of data from text and Excel data sources.

Developing reports and analytics in SSRS.

Scheduling and maintaining regular ETL jobs. Was the first level of escalation in case of ETL error handling.

Developing managerial reports for the client’s monthly meetings and played a major role in tuning the reports for performance.

Enstoa, Inc.

Consultant/ Database/ ETL/ Report developer

Jun 12 – Aug 12

New York Presbyterian

NY, New York

Served as the ETL developer to develop, enhance and maintain transformations for the integration of data from various energy sources and from Sharepoint.

Developing reports and analytics in SSRS.

Scheduling and maintaining regular ETL jobs. Was the first level of escalation in case of ETL error handling.

Developed a mechanism to download data from Sharepoint and use that data in integrating it with data from other sources and finally generating reports. This mechanism was developed in C# and .Net

Enstoa, Inc.

Consultant/ Database/ ETL/ Report developer

Sep 12 – Nov 12

New York University

NY, New York

Served as the ETL developer to develop, enhance and maintain transformations for the integration of data from Oracle database and excel sources.

Developing reports and analytics in SSRS.

Scheduling and maintaining regular ETL jobs. Was the first level of escalation in case of ETL error handling.

Developed a mechanism to download data from Oracle DB and use that data in integrating it with data from other sources that included multiple databases and finally generating reports.

MindTree Ltd.

Technical Lead

Jul 10-Oct 11

Unilever UKCR Ltd.

London, UK

Unilever Complexity Metrics

This project created a benchmark for all Unilever projects as it resulted in zero-defect UAT phase.

Understanding Unilever Data model and incorporating the key aspects to the project data model resulting in minimal post development changes.

Creating solution architecture for the specific business requirements which also focused largely on scalability and hence took the project to the next level of delivery ease and excellence

Creating ETL design and architecture

Design and Development of Cube and Reports

Code Review resulting in minimal integration testing errors.

Unit Testing and Integration Testing

Support to Testing Team and Business users during UAT. Handling the business users during acceptance testing and providing on-site support for the same.

Co-ordination with Business and Onsite Managers resulting in smooth execution with zero co-ordination errors

Managing the project related activities for the project including documentation, timelines and escalations

Suggesting enhancements and improving user usability of existing features while not compromising the business model which was accepted and implemented as part of new phase of the project.

Production Deployment which ended in zero defects during integration and acceptance testing.

Provided 24/7 support and addressed issues and bugs in real-time during UAT and integration testing.

MindTree Ltd.

Technical Lead

Jan 10-Jun 10

Unilever UKCR Ltd.

London, UK

Unilever Vitality

Understanding Unilever Data model and incorporating the key aspects to the project data model resulting in minimal post development changes.

Creating solution architecture for the specific business requirements which also focused largely on scalability and hence took the project to the next level of delivery ease and excellence

Creating ETL design and architecture

Design and Development of Cube and Reports

Code Review resulting in minimal integration testing errors.

Unit Testing and Integration Testing

Co-ordination with Business and Onsite Managers resulting in smooth execution with zero co-ordination errors

Managing the project related activities for the project including documentation, timelines and escalations

Suggesting enhancements and improving user usability of existing features while not compromising the business model which was accepted and implemented as part of new phase of the project.

Production Deployment which ended in zero defects during integration and acceptance testing.

MindTree Ltd.

Senior ETL/ Report Developer, Onsite Co-coordinator

Oct 09 – Dec 09

Unilever UKCR Ltd.

London, UK

Unilever Total Rewards Statement

Requirements Gathering

Source system Analysis

Design and Development of ETL components

Code Review which resulted in minimal bugs during Integration testing.

Unit Testing and Integration Testing

User Acceptance testing

Responsible for providing bug-free and smooth transition to production environment resulting in obtaining multiple phases for the project continuation.

Production Deployment

Provided technical inputs and design on a consulting basis for the second and third phase of the same project while working on another development project.

MindTree Ltd.

Senior Report Developer

Jul 09 – Sep 09

Imperial Tobacco Group

Netherlands, UK

ITG NL

Design and Development of Reports

Code Review

Unit Testing and Integration Testing

Was part of a team that delivered excellent quality reports resulting in continued engagement with the client.

MindTree Ltd.

Senior OLAP/ Report Developer

Nov 08 – Jun 09

Unilever Asia PTE Ltd.

APAC Region

Unilever OPSOLight+

Design and Development of Cubes and Reports

Multiple cubes were designed and developed for all the regions involved in the APAC Region.

Code Review

Unit Testing and Integration Testing

Involved in implementing complex and advanced business model in MDX which improved report performance.

MindTree Ltd.

Senior OLAP/ Report Developer

May 08 – Oct 08

Unilever Singapore

Singapore

Unilever Envision

Development of Views and Reports

Unit Testing

Involved in creating reports with charting capabilities to take visualization to the next step of data analysis using Dundas Charts.

Implemented complex charts to make data analysis for the business simpler.

Personal Details

Visa Type: Open Work Permit (Valid till 30-April-2018)

You can connect with me here: Kavita Sunku (LinkedIn)

Contact this candidate