Sr. Consultant - BI

CURRICULUM VITAE

Mohit Kumar Singh

Balaji Apartment, Flat no S-3, Plot No – 9/7,

Sector – 3, Rajendar Nagar

Sahibabad, Ghaziabad,

Country: INDIA

Pin code: 201005

Phone: +919*********

E-mail: cxstuz@r.postjobfree.com

Alternate email Id: cxstuz@r.postjobfree.com

Title :

Data warehouse Consultant/BI Developer/OLAP Developer/BI Consultant

Primary Skills :

ETL , BI, T-Sql, Report Builder 2.0

Secondary Skills :

DATABASE : SQL Server 2000, SQL Server 2005, SQL Server 2008

ETL Tools : Microsoft Integration Services (SSIS)

Version SQL Server 2000, 2005, 2008

Data Mining Tools : Microsoft Analysis Services (SSAS)

Version SQL Server 2000, 2005

Programming Language : VB6.0, VBA

Office Tools : Excel, Access, PowerPoint.

OPERATING SYSTEM : Windows 98 / 95 / 2000 / NT/Server 2003/XP/LINUX

Current Working Location :

Noida (INDIA).

EXPERIENCE SUMMARY :

1 Over 6+ Years of strong IT experience in Design, Development and Implementation of software applications, delivery and support solutions, covering all aspects of the software development cycle. Area of expertise includes Data Warehousing techniques using (Top to bottom approach), Data modeling (Star Vs snowflake schema), and ETL, OLAP cubes, Data architecture, Reporting Services, Ad-hoc reporting, corporate sales Business and Health domain.

2 Over 5.6 years of strong experience on ETL tools SSIS. Designing of new Packages using control flow and data Flow transformation tasks.

3 Over 3.0 years of experience on SSRS 2008, Report Builder2.0 and Report builder 3.0.

4 Over 1.0 years of strong experience on SSAS (SQL Server Analysis Services) Designing and Maintenance of cubes using SQL Server 2000 and SQL Server 2005. Creating Facts & Dimension tables, creating calculated members, Actions, Perspectives in SSAS cubes.

EDUCATION :

1 10th From CBSE Board Securing 61% of Marks in the Year 1999.

2 12th From CBSE Board Securing 64% of Marks in the Year 2003.

3 Pursuing BCA through correspondence from IGNOU (6th SEM).

TECHNICAL CERTIFICATION :

1 MCTS (Microsoft Certified Technology Specialist) in Microsoft SQL Server 2005 - Implementation and Maintenance

WORK EXPERIENCE :

1 Working as a Sr.Consultant - BI in Saviance Technologies Pvt. Ltd., Gurgaon, INDIA from 7 March 2011 to Till Date.

2 Working as a BI-Developer - Software Development in Accretive Health Pvt. Ltd., Noida, INDIA from 14 June 2010 to 4th March 2011.

3 Worked as an MIS Analyst – Digitization in Barclays Shared Services Pvt. Ltd., Noida, INDIA from 22nd September 2008 to 11 June 2010.

4 Worked as a Software Developer in Delhi Call Centers Pvt. Ltd., Ghaziabad, INDIA from 15 Feb 2005 to 9 September 2008.

EXPERIENCE SUMMARY:

I. Present Assignment: (MRI Companies US) [March 2011 – Till Date]

Designing of T-SQL Queries and Stored procedures and Designing and implementation of SSRS Reports using Report manager.

Reports like : Open Purchase Order by Due Date

Contract Cost Reports

Vendor Contract Costs.

II .Present Assignment: (June 2010 to March 2011)

• Working with Accretive Health Pvt. Ltd, Noida as BI developer.

Accretive Health is US based MNC and built for purpose company with the sole focus of generating significant, sustainable improvements in revenue cycle outcomes sufficient to enhance healthcare providers’ ability to pursue their core mission: the delivery of high quality healthcare services to their communities. We pursue this mission by offering end-to-end managed services for revenue cycle operations and through the creation of productive, long term partnerships with providers.

We are a fast-growing company built on the strongest team and technology in a unique company culture. We gather the highest level of industry knowledge in an environment that combines professional excellence and entrepreneurial spirit.

Website – www.accretivehealth.com

REPORTING RELATIONSHIPS

POSITION REPORTS TO: Project Manager (Onshore Team- US)

POSITION PURPOSE

Responsible for Database/BI related jobs.

Key Responsibilities:

• Sound understanding and experience in data warehousing concepts and business intelligence

• Ability to work individual and coordinate with people from the Business side as well as across IT, including development and Operations.

• Performed various project tasks in the development life cycle including analysis, design, development, and testing. (SSIS package), data integration, enterprise reporting.

• Experienced in Version Control Tools and Collaboration like Visual Source Safe and TFS.

• Leading the Offshore BI team from the front and delegating the task.

Technical Skills

TSQL

• Strong SQL Server Fundamentals and T-SQL Skills (SQL Server 2000, 2005, 2008).

• Proficiency in writing complex stored procedures, Joins, Function etc to support data integration, analysis, and various business processes.

• Proficiency in writing dynamic SQL query

• Knowledge about index.

• Conduct peer-review on existing stored procedures/functions and perform optimization.

• Development of SQL Agent jobs.

ETL

• Designed effective packages for daily Extraction, Transformation and Loading data from heterogeneous sources like Flat files, excel and SQL server database.

• Transformed the staging data to Data Mart.

• Experience implementing most of the Data flow/Control flow Tasks, Containers and Transformations task like Lookup, Merge, conditional split and Data Conversion etc.

• Created Meta data around ETL processing for monitoring and troubleshooting processing steps.

• Basic idea about slowly change dimension Type 2 and Type 3.

• Experience in building Package deployment and package Configuration

• Monitoring of SSIS jobs on ongoing basis for stage data populating in data mart.

• Experience implementing Analysis Services tasks

OLAP/SSAS Development

• Designed and developed STAR and Snowflake schema.

• Design the relationship of dimension and fact tables and added role playing dimension in the cube.

• Designed and Developed of Dimensions and Cubes (2000, 2005 & 2008).

• Experience Writing KPIs, Implemented Drill-through.

• Develop new or modify existing OLAP cube / MDX coding to extract historical data (SSAS 2005, SSRS 2005/2008).

• Created various calculated members.

• Created Partitions within the cube for historical data to improve the cube browsing performance and also cube processing performance.

• Experience with SSAS Cube performance tuning

• Processing of dimensions and cubes through XMLA script.

• Deployed cubes on Production.

Analytical SSRS Reports

• Create Multidimensional (Matrix)/Analytical Reports from the cubes or SQL dataset.

• Scheduled reports on Scheduled reports on BI Portal (Third party Reports Portal tool).

• Created OLAP reports in Excel 2007 and Microsoft SQL server 2008 Report builder 2.0.

• Created Report in SSRS for users to their ad hoc requirements and provided support for the same.

• Created Dashboard report on ReportsProtal for Yield Based follow-up ops team.

• Creating and maintaining Analytics users, roles and security management.

Documentations

• Business Requirement Documents.

• User Acceptance Testing (Test Cases)

• Production migration document.

• Data dictionary of Cubes metadata for business users

PROJECT DETAILS (Some Important project)

MAJOR PROJECTS

1. Analytics - BINextGen

Project Description: The objective of the BINextGen reporting is to improve Financial Results,, Enhanced Patient and Community Relations, Expanded Employee Opportunity , Improved Physician Relations , Increased Freedom of Focus. It provides the metrics about leakage area so that resource can invest more time on that area. This project has covered all the medical facilities available and provides to patients by hospitals according to patient type and their insurance covered details. It has many dimension for reporting like

Patient demographic

Insurance enrollment details

Charge entry

Insurance verification details

Billing and reconciling of accounts

Account receivable follow-ups and collections

Payments posting process for insurance as well as patient

Denial management

Client US Based Hospitals (PHI and Clinical data)

Duration June 2010 – Till Date

Environment SSAS 2008, SQL Server 2008, SSIS 2008, SSRS 2008, Excel 2007, Report Builder 2.0, Team Foundation Server.

Role Software Developer

Responsibilities:

• Designing Measure Group, dimensions, hierarchies.

• Designed Aggregation and cube partitions

• Implemented Drill through action in the cube

• Created security roles and managing roles in cubes

• Designed dimensions and cubes.

• Deployed Cubes on Development and Production server

• Writing SQL queries and creating stored procedure to populate data mart.

• Designed SSIS Packages to load data from production data sources (SQL Server to data mart into data ware housing server).

• Created Database objects for handling failed data loads and recorded SSIS packages execution log details and populated those using SQL Server Report Services.

Creating and Scheduling SQL Server agent jobs to process ETL SSIS and XMLA script to processing cube

2. Analytics - AccountReceivable

Project Description: This project has information has covered the important function in the process flow of data. Unless this is taken care of, insurance balance will only be on an upward trend. So with the help of this project they can have metrics for below area.

Problem in Medical billing

Inaccurate or lack of coding

Incomplete claims

Lack of supporting documentation

Client US Based Hospitals (PHI and Clinical data)

Duration June 2010 – Till Date

Environment SSAS 2008, SQL Server 2008, SSIS 2008, SSRS 2008, Excel 2007, Report Builder 2.0, Team Foundation Server.

Role Software Developer

Responsibilities:

• Designing Star schema, Measure Group, dimensions, and hierarchies.

• Specifying dimension usage and define relationship between Dimension and Fact table

• Created Partition and Optimizing Aggregations by using Usage based Optimization

• Created Calculated members

• Designed dimensions and cube.

• Writing SQL queries and creating stored procedure to populate data mart.

• Designed SSIS Packages to load data from production data sources (SQL Server to data mart into data ware housing server).

• Identified slow running reports and optimized the underlying stored procedures

Previous Experience

III. Past Assignment: (Sept 2008 to June 2010)

• Worked with Barclays Shared Services Pvt. Ltd. (An International BPO –Banking domain) as “MIS Analyst - Digitization”

REPORTING RELATIONSHIPS

POSITION REPORTS TO: Project Manager (Offshore Team)

POSITION PURPOSE

Responsible for Database designing for Windows Applications.

Key Responsibilities:

• Sound understanding and experience in data base designing concepts and business intelligence.

• Ability to work individual and coordinate with people from the Business side as well as across IT, including development and Operations.

• Performed various project tasks in the development life cycle including analysis, design, development, and testing. (SSIS package), data integration, enterprise reporting.

MAJOR PROJECTS

1. One Source (Employee Resource Planning)

Project Description: This project provides the information about all the Employee related details that need to be captured from the Stage of Offer to the applicant till the Full and Final stage of the employee exit.

Client Barclays Shared Services – INDIA

Duration September 2008 – June 2010

Environment SQL Server 2005,SSIS 2005

Role MIS Analyst – Digitization

Responsibilities:

• Designed Database Design for the ERP.

• Created stored procedure, jobs & views.

• Involved in creation of ETL package

• Responsible for the design and the report using Excel 2007.

IV. Past Assignment: (Feb 2005 to September 2008)

• Worked with Delhi Call Centers Pvt. Ltd. (An International BPO –Telecom domain) as “Software Developer”

The high-tech web-enabled call center solution by Concerto has truly assisted the strong commitment of Delhi Call towards customer-service. Delhi Call Center has now entered into E commerce market with unique online marketing strategy of selling mobile phones and plans. The Portal has a unique functionality of selling our client VIPtel's mobile services and managing their customer's mobile account online.

REPORTING RELATIONSHIPS

POSITION REPORTS TO : HOD (Software)

POSITION PURPOSE

Responsible for whole Delhi Call BI application Maintenance related jobs.

MAJOR PROJECTS

1. Analytic –Sales Floor Analysis

Project Description: This project provides the information about all the sales made by Agents or sale made through online request. It also capture the customer details and the plan code details, offers , handset details and type of transaction details etc.

Client VIP Mobile (India and Australia)

Duration March 2007 – September 2008

Environment SQL Server 2000 database,DTS Packages 2000,Analysis Manager, Excel 2003 Reporting.

Role Software Developer

2. Analytic – Leads management & Penetration Reports

Client VIP Mobile (India and Australia)

Duration Jan 2007 – September 2008

Environment SQL Server 2000 Database,DTS Packages 2000,Analysis Manager, Excel 2003 Reporting.

Role Software Developer

3. Analytic – MIS Adhoc Reporting

Client VIP Mobile (India and Australia)

Duration February 2005 – Jan 2007

Environment SQL2000 database,Query Adhoc Reports,Excel 2003 Reporting.

Role MIS Executive

PERSONAL PROFILE:

Name : Mohit Kumar Singh

Father's Name : Shri Gordhan Singh

Date of Birth : 17th March 1984

Nationality : Indian

Marital Status : Single

Hobbies : Cricket & Listening Music

Languages Known : English and Hindi

Place: Noida

Date: (Mohit Kumar Singh)

Contact this candidate