Around *+ Years of Experience in Microsoft BI technologies.

Currently working as Technical Lead - BI and Analytics

Preeti Sharma

Mobile: 425-***-****

Email: acn0zx@r.postjobfree.com

CAREER OBJECTIVE:

To work in an organization of repute, where my cognizance and skill can be

applied towards the development of the organization and my services can be

rendered to my satisfaction as well as the satisfaction of the employer.

SUMMARY OF EXPERIENCE:

. 8 + Years' experience in Business Intelligence and Data warehousing.

Having experience on end to end Development of the full life cycle of

a data warehouse project.

. Integration Service (SSIS), SQL Reporting Services (SSRS), Power

Pivot, SharePoint 2013 and related technologies.

. Strong practical and theoretical knowledge of data ingestion & data

mart design.

. Strong communication, critical thinking and problem solving skills

. Ability to meet deadlines in a fast paced environment

. Ability to work within product teams and across product groups

. Ability and passion to pick up new technologies and stay on the

cutting edge of development

EDUCATIONAL/PROFESSIONAL QUALIFICATION:

. B.Tech (Computer Science and engineering) from UP Technical University

in 2004.

. 12th from UP board Allahabad in the year 1999.

. 10th from UP board Allahabad in the year 1997.

SOFTWARE EXPOSURE:

Operating System : Windows Server 2008 R2, Windows 2003

Server

Languages & Technologies : T-SQL

Reporting Tools : SSRS, Power Pivot, Power view

ETL Tools : SSIS

Cube : SSAS Tabular model

RDBMS : SQL Server 2005/2008 R2/2012, Oracle

Testing Tool :MTM,Data Hawk

Configuration and Version Management Tools: TFS, SVN, Visual Source safe

CURRENT PROFILE & ROLE IN THE COMPANY

HCL America Inc.

Technical Lead October 2010 - Till Date

In a Lead Business Intelligence role with key responsibilities to preparing

high level architecture, converting HLD to Low Level Design.

Providing offshore team with Technical Leadership to plan/implement the

Business intelligence and Analytics solutions using MSBI tools. Automate

the data acquisition pipelines, building data model to support the

visualization/ ad hoc requirements using

Agile Methodologies to provide quick solutions creating significant

business value.

Taking initiatives to mentor, build team capabilities, ensuring efficient

processes, code reviews and requirement tractability for customer delight

and business value.

Infogain India Pvt Ltd., Noida

Sr. Software Engineer Aug 2010-October 2010

Working as a senior developer with key responsibilities to design code and

develop the business intelligence solutions.

Key responsibilities include designing SSRS reports, writing and optimizing

T-SQL queries, performance tuning the SSIS packages.

Working with various teams for their data modelling, database design and

reporting needs.

SSRS Design, Development and Integration

Fiserv India Pvt. Ltd. Noida

Software Engineer Sep 2007 - April 2010

Working as a BI software developer with primary responsibility to design

code and develop the business intelligence solutions.

It was an onshore-offshore development model catering to a major investment

banking firm Fiserv Investment support services.

I have worked over five datawarehousing implementation projects in my

tenure with NTL including one which is an upgrade from Sql Server 2000 to

Sql server 2008.

Key roles and responsibilities:

1. Requirement gathering, making technical and business specifications.

2. Defining and modifying processes.

3. Development of SSIS packages to load the central repository from

various OLTP systems and integrating them.

4. SSRS and ad-hoc reporting.

5. Guide and mentor the new members in team, doing code reviews and

ensuring process adherence.

6. Short term onsite travel to USA for delivering and demonstrating

solution.

Synova Innovative Technologies Pvt. Ltd. Bangalore

Software Engineer Nov 2006- Sep 2007

Working as a BI software developer with primary responsibility to design

code and develop the business intelligence solutions

Key Roles and Responsibilities:

1. Development and Enhancements of reports as per the client's business

needs.

2. Development of the new letters in Client letter as per the business

needs.

3. Adding subscription in reports.

4. Developing packages in SSIS.

5. Migration of Legacy reports in SSRS, writing stored procedures, query

optimization.

6. Developing dashboards and scorecards.

Rose IT Solutions Pvt Ltd. New Delhi

Software Engineer April 2006 - Nov 2006

Working as a BI software developer with primary responsibility to design

code and develop the business intelligence solutions

Key Roles and Responsibilities:

1. Development and Enhancements of reports as per the client's business

needs.

2. Development of the new reports as per the business needs.

3. Adding subscription in reports.

4. Developing packages in SSIS.

5. Developing dashboards and scorecards.

Project Summary:

Client- Microsoft (OPS BI)

Team Size: 4

Project Description:-Ad CRM is the Customer Relationship Management system

for MSN Ad Sales which tracks and maintains orders, accounts and contacts.

It enables Sales, Service, Support and Marketing teams to work with

customers, move them through the sales pipeline, execute on orders and

provide support. It captures and tracks capabilities of lead information on

potential customers to Microsoft advertising. It provides forecasting or

'pipeline' information on accounts and potential and realized advertising

deals. It is used by Sales, Service, Support and Marketing teams worldwide.

Being part of Operations Group, I have been working in the Developing Data

Mart,Creating tabular cube on that and provide self-service BI using Power

pivot and power view.

Domain: Operations

Client- Microsoft (Business Intelligence and Analytics)

Team Size: 12

Being part of Search Business Group, I have been working on various

projects as part of the program.

We work closely with Business and Engineering teams to provide cost

effective, lean and agile business intelligence solutions leveraging

Microsoft technologies.

My primary role is to work with Business Analysts for requirement

elicitation, converting requirements into technical architecture design,

designing data model to support the visualization and analytical needs.

Domain: Online Marketing

Client- Fiserv Investment Support Services

Team Size: 10

Project Summary:-

Fiserv investment support services manages client investment accounts. It's

for managing all process starts from opening an account, assigning

different roles for that account, buying and selling the assets.

Being part of FISS Group, I have been working on various projects as part

of the program.

We work closely with Business and Engineering teams to provide cost

effective, lean and agile business intelligence solutions leveraging

Microsoft technologies.

My primary role is to work with Business Analysts for requirement

elicitation, converting requirements into technical architecture design,

designing data model to support the visualization and analytical needs.

Domain: Investment Banking

Client - Synova, Inc. Southfield, MI, US

As a Sr. Developer, I was involved in developing Enterprise BI solutions

and services to the US

Markets. My responsibility was to integrate the source systems and write

reports in SSRS.

We have nightly loads schedule to integrate the systems and the client is

kept updated with

The automated emails and reports.

The regular health checks are performed on the databases on the daily

basis.

Team Size: 4

Domain: Vender Management System

Client - AMDOCS, U.S

As a Developer, I was involved in developing Enterprise BI solutions and

services to the US

Markets. My responsibility was to integrate the source systems and write

reports in SSRS.

Team Size: 6

Other Projects:

Migration Projects from SQL 2005 to SQL 2008

Reports Migrations from SSRS 2005 to SSRS ( SQL 2008)

DECLARATION:

I here by certify that the above details are correct and

complete to the best of my knowledge and belief.

Date : 10/15/2014

Place: Bellevue

(Preeti Sharma)

Contact this candidate