SQL Server/SSRS/SSIS/MSBI

DIPALI MAKKAR

MOBILE: +91-851******* EMAIL:

**************@*****.***

Objective

To secure a challenging position where I can effectively contribute my

skills as Software Professional, possessing competent Technical Skills and

contribute myself to innovative world of technology and to apply my skills

to learn new techniques, applications, technology and also grow with an

organization.

Academic Details

LEVEL SCHOOL/ COLLEGE BOARD/UNIV. YEAR PERCENTAGE

B.Tech(CSE Bhagwan Parshuram GGSIPU 2012 76.5

) Institute of

Technology, Delhi

12th D.L.D.A.V Model School, CBSE 2008 85

Delhi

10th D.L.D.A.V Model School, CBSE 2006 89

Delhi

Technical Skill Set

Platforms: Microsoft Windows XP, MicrosoftWindows7, UNIX.

Tools: MS Office (Excel, Word & Power Point), Autosys, BIDS, SSMS.

Database Management: RDBMS, SQL,SSRS,SSIS,SSAS

Projects Undertaken

SunTrust Mortgage(March 2013 to August 2014)

Employer

IBM India Pvt. Ltd.

Client

SunTrust Bank Inc

Brief Description Of Project

Sun Trust Banks, Inc. is one of the leading, largest and strongest

financial holding banks of USA. The bank provides deposit, credit, trust

and investment services to a broad range of retail, business and

institutional clients from its banking subsidiaries. Other subsidiaries

include mortgage, banking, credit-related insurance, asset management,

brokerage and capital market services. I am part of investment management

portfolio and works for Mortgage team. Mortgage is responsible for

maintaining and developing reports for their clients.

ROLE & Responsibilities

Developing various types of reports like Graphs, Cross tabs, Drill-through,

Drill-Down, Simple lists, etc and created complex stored procedures too.

Directly Interacting with clients for gathering New Business Requirements

and existing system changes

Interacted with Onsite Coordinator for all the application support issues,

Knowledge transition and for all the gaps at interaction level

Deploying the reports from Development to testing, Testing to Production

environments

Investigated and Found root causes for the Report issues.

Delivered all the deliverables on the schedule to successfully meet the

needs of the client.

Tested all the deliverables properly.

Citi GFTS(September 2014 to Present)

Employer

IBM India Pvt. Ltd.

Client

CitiGroup

Brief Description Of Project

Citigroup Inc. (branded Citi) is a major American financial services

company based in New York City. Citigroup Inc. has the world's largest

financial services network, spanning more than 140 countries with

approximately 16,000 offices worldwide. I am part of CSD Team and handling

2 Applications.

ROLE & Responsibilities

Involved in Implementation and delivery of MSBI platform solutions to

develop and deploy ETL, analytical, reporting and scorecard / dashboards on

SQL Server 2008 using SSIS and SSRS.

Working in SQL Server Integration Services (SSIS) and SQL Server.

Involved in Technical decisions for Business requirement, Interaction with

Business Analysts, Client team, Development team, Capacity planning and Up

gradation of System Configuration.

Certifications

IBM certified in IBM Cognos BI Author.

Oracle certified in SQL Fundmentals (Oracle database 11g).

Extra Activities

Undertaken many initiatives such as Preparing and maintaining Activity

Tracker, Quality related Documents preparation, Employee Engagement Spoc,

Team Activities organizer etc.

Personal Information

Date of Birth: 7th June 1991

Sex: Female

Martial Status: Single

Languages Known: English, Hindi and Punjabi

Address:

Declaration

1 I hereby declare that all the details furnished above are true to the

best of my knowledge.

Contact this candidate