Sign in

Business Intelligence and Data modeling lead

Mumbai, Maharashtra, India
February 09, 2019

Contact this candidate





Mob: +91-897*******

Professional Summary

Over all 5 Years of experience in IT Industry with knowledge and experience in BI tools like SSIS, SSRS, SSAS, MDX and Databases like T-SQL, Oracle and DB2 etc.

Good Experience in Insurance and Financial domain.

Expertise in generating reports using SQL Server reporting services, Crystal reports, MS Excel spreadsheets and Power pivot .

Experienced in designing and developing SSRS reports using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.

Good understanding of Data Mart and dimension modeling using different Schemas.

Good communication skill.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Knowledge of data ware housing concepts and designing entity relationship and data flow diagrams for the business process.

Basic knowledge on BO and SAS.

Knowledge of working with SharePoint 2013.

Knowledge of creating OLAP cubes defining the dimensions and relationship between dimensions and measure groups.

Strong investigative and troubleshooting skills.

Good knowledge on Excel, Power View, Power Pivot etc.





16th Dec 2013 to 06th Jan 2017

Syntel Private Ltd.

Software Engineer

9th Jan 2017 to 28th Feb 2017

Hansa Cequity Private Ltd

System Analyst

1st March to 9th June 2017

TCS on Payroll of Innova Solutions Private Ltd.

Senior Software Engineer

12th June 2017 to till date

Nomura on Payroll of Infrasoft Technologies Limited

Associate Consultant

Technical Skills

Technology: SSAS, SSRS, SSIS, SAP BO (Basic Knowledge), Crystal Report XI, SAS (Basic Knowledge), Power Pivot, Power View, Power BI, ProClarity, XLCubed, QlikView, Tableau, Informatica, Autosys scheduler, Power Query

Database: SQL Server 2012, Oracle, DB2 Basics, MDX, DAX, PL/SQL, Sybase ASE

Academic Qualifications


School /Institute

Year of Passing

University / Board


B.Tech (Information Technology)

Faculty of Engineering & Technology


Manav Rachna International University, Faridabad



St John’s School, Faridabad


CBSE Board


High School

St John’s School, Faridabad


CBSE Board


Internship (Industrial Training)

Name of the Organization – Koncept Software Solution, Badarpur Border

Designation: Industrial Trainee

Duration: JAN-2012 to JUN-2012

Title of the Project: College ERP System

Project name: School/College ERP System

Specification: PHP

Framework Tool: Dreamweaver, Notepad

Web Development: HTML, Jquery, AJAX

Database: My SQL

Work Experience

Project Name : CRIMS (Charles River Investment Management System)

Client : SLI (Standard Life Investment)

Technology : Crystal Reports, Oracle, T-SQL

Description: CHRIMS solution enables accurate and timely investment decision support for institutional, wealth and alternative investment firms. Charles River IMS helps clients streamline operations, reduce risk, and improve reliability.

Roles & Responsibilities:

Involved in the analysis of the requirements and gathering requirements for closed loop project/Charles River front end application.

The project involves migration of Crystal reports from CRIMS V8 to V9 and development of new reports for Version V9.

Developed T-SQL query, stored procedures and functions to retrieve data for reporting .

Created Technical Report Requirement document for the Standard Reports.

Creating different type of Crystal reports.

Using CVS as the repository location and Service Now as a process for end to end deployment.

Project Name : CODA

Client : SLI

Technology : T-SQL Stored Procedures, Functions and Triggers

Description: The project is collaboration with .Net team and the Scripts which we wrote. One front end application CODA is built on .net and our scripts will run on the click of button and perform respective action.

Roles & Responsibilities:

Involved in gathering requirement from business and understanding the CODA application.

Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks.

Created triggers for the table specified by the end user to maintain the log.

Support the project till UAT and then move to SIT/Production.

Project Name : IDM (Investment Data Mart)

Client : SLI

Technology : SSRS, Oracle, MDX, T-SQL, SAS

Description: The project involves migration of SAS reports to SSRS reports. It involves migration of around 200+ reports from SAS to SSRS. The reports are built over SSAS cube. MDX query is henceforth used to extract the data from SSAS cube.

There were businesses scenarios identified and created report on top of that also.

Roles & Responsibilities:

Understanding and analyze the requirements in BRD.

Analyzing the SAS code and gathering requirement for SSRS Report.

Writing MDX (Multidimensional Expression)

Creating different types of SSRS reports from SSAS cubes through MDX.

Design complex reports/ report templates for reusability across reports.

Perform time based file share and Email scheduling of reports.

Diagnose and solve technical problems related to Report building.

Created indexed views, and appropriate indexes to reduce the running time for complex queries

Active part in creating OLAP and ROLAP cubes and used MDX queries to retrieve data from the cubes.

Utilized T-SQL to pull loan data from various databases and created various dashboards, scorecards and reports to support loan business decision making.

Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using SSRS.

Provided technical assistance during requirements meetings in coordination with end users.

Project Name : ROI (Return of Investment)

Client : Nomura

Technology : T-SQL, SSIS, SSAS, Sybase ASE, Autosys scheduler, UNIX

Description: Return on Investment (ROI) is a performance measure, used to evaluate the efficiency of an investment or compare the efficiency of a number of different investments. ROI measures the amount of return on an investment, relative to the investment’s cost.

Roles & Responsibilities:

The project involves end to end activity of data extraction to data massaging to end report or OLAP cube.

Extracted data from various sources like SQL Server 2008/2012, .CSV, Excel and Text file from Client servers and through FTP.

Gathering requirement from Client of all the upstream and design the data model for the same.

Write efficient stored procedures and SSIS packages for data loading from different upstream systems to our system and optimal performance of the system

Create ROI report for users and studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems for adding few attributes in OLAP cube like PNL, cost, revenue etc.

Users can access the data either via excel reports or accessing cube via ProClarity or XLCubed.

Coordinated with business partners for identification of improvement opportunities.

Project Name : ZURICH MI

Client : ZURICH

Technology : SSAS, SSIS, T-SQL

Description: Ztrade is policy administration system for Zurich’s SME products. Quotes, policies and other transactions data are available in existing system in XML format. This data would be later shredded from SME application (Duckcreek) to SQL Server database. Data Mart created on top of existing Shredded database to facilitate the reporting requirement from Zurich. These reports would be used by different business areas of Zurich e.g. pricing, product, Sales & distribution or operations in decision making and measuring performance.

Roles & Responsibilities:

Gather the requirement from BRD.

Write the object scripts and Stored Procedure.

Create the SSIS package to load the data to staging and data mart.

Used ETL tools to implement the Slowly Changing Dimensional maintain Historical Data in Data warehouse.

Create the mapping source to the destination.

Used different transformation like data conversion, derived column, Merge Join to apply the business logic

Designing and deploy the cube in SSAS.

Writing and reviewing the unit testing code and done unit testing in SSMS.

Professional enhancements

Attended the personality development course by ASPIRE INDIA organized by Manav Rachna international university

Two months course in C Language from SAHA INSTITUE FARIDABAD.

Completed Certification Microsoft SQL Server certification. (70-461)

Completed Certification Implementing Data Model and Reports with Microsoft SQL Server 2012 (70-466)

Completed ITIL certification.

Completed agile level-1 and agile level-2 certification.

Completed Lean Basic level certification.

Trained employees in MSBI and Crystal reports.

Achievements and awards

Participated in 3rd Young Scientist Talent Test-2006.


Got KUDOS award in Syntel Ltd.

Awarded 2 times Excellence award in Syntel Ltd .

Personal Details

Name : Neha Chopra

Father’s Name : Parmod Chopra

Languages known : English, Hindi, Punjabi.

Date of Birth : 06 March 1991

Marital Status : Single

Permanent Add : 6095-A SEC-3,Near Takshila Model Senior Secondary School,

Faridabad, Haryana 121004


I hereby declare that the above written particulars are true to the best of my Knowledge and belief.


Contact this candidate