Developer Data Analyst

Vandana Mittal

E-mail: *************@*****.***

Mob. No.: +918*********, 999-***-****

Career Experience

To obtain a position as a developer utilizing my education, experience, and communication skills to improve the company’s efficiency by providing exceptional IT services.

Professional Experience

Having Around 3 Year 1 month’s professional experience as a Developments & Application support.

Having 3 year of professional software development experience in the areas of Microsoft Business Intelligence (MSBI) and Having Knowledge in Data Warehousing (DW) applications primarily using Microsoft SQL Server.

Having 1.5 years of knowledge about BI application support solving complex problems,performance, availably, provide correct solution for live application

Having 1.1 years of professional dashboard development experience in the areas of Microsoft SQL Server Reporting Services. Primarily using Microsoft SQL Server.

Strong process/analytical knowledge of MS-BI Developer and Data Analyst in Production, Development and Staging Environments.

Having 1.5 years of experience in excel of crating daily basis report and manage the data.

Good Communication skills, committed team player, creative, self-starter, having ability to work in a fast-paced environment

Experience Summary

Current Employer: R1RCM PVT LTD

Designation: Engineer –BI and Analytics (May -2019 to till date).

Role & Job Responsibility:

Working in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).

Working in Implementing and maintaining existing systems. Fixing some of legacy bugs which are client specific (CR’s).

Working in Hands of experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages.

Working in auditing and processing platform (R1 Tool) using SQL query to update,delete and modify the table and create SSIS package as per client requirement.

Creations of database objects like tables, Functions, view, join and stored procedure using SQL Server.

Project name

1.Title: ICD and HCPCS

Tool: Microsoft SQL Server and SSIS, Role: Developer

Description: HCPCS and ICD data sent by client in excel then create table and dumb the data in table through SSIS then transfer the data in different table through procedure as per client requirement.

2.Title: Historical data Load in Different Tables

Tool: Microsoft SQL Server and SSIS Role: Developer

Description: Load the historical data which is not in table of retro,payments and memo as per reqirements.

Optum Global Solution PVT LTD.

Designation: Associate Management System Analyst (April -2017 to May-2019).

Role & Job Responsibility:

Working in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).

Working in Hands on experience in SQL Server Reporting Service (SSRS) and working on excel on daily basis reports.

Working in Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.

Working in Implementing and maintaining existing systems. Fixing some of legacy bugs which are client specific (CR’s).

Working in Hands of experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages.

Working in auditing and processing platform (APP Tool) using SQL query to update,delete and modify the table as per client requirement.

Creations of database objects like tables, Functions, view, join and stored procedure using SQL Server.

Worked in UCS Omega Project as a backend developer using SQL Server

Project name

1. Title: UHCG Inventory\

Tool: Microsoft SQL Server, SSIS, And SSRS Role: Developer

Description: UHCG inventory store the data of united health care group. In this project we have to create the date warehouse for UHCG inventory. For this we have write lot of SSIS packages that move data from different source (excel, flat files, SQL server) to DWH tables. Same time also working for data visualization through SSRS.

2.Title: Automated Reports

Tool: Microsoft SQL Server, SSIS, And SSRS Role: Developer

Description: Automated various excel reports by import the data in database and Create view, stored procedure and deploy the report in SSRS .

3.Title: UCS Omega

Tool: Microsoft SQL Server Role: Developer

Description: UCS omega acquires data from the various data sources of the company and insert or update data into Data warehouse .We have to create stored procedure, views, function and temp table as per the client requirement

4.Title: Auditing and Processing Platform(APP tool)

Tool: Microsoft SQL Server Role: Developer

Description: It is web – based application. Working as a database support .Delete and update the Customer record as per client specification.

Technical Skill Set:

Operating System : Windows family

Languages : SQL SERVER, T SQL,C

Development Tools: Visual Studio 2010/2008

ETL Tool : SQL Server Integration Services (SSIS)

Reporting Tool : SQL Server Reporting Service (SSRS),

Professional Qualification

Bachelor of Technology (B.Tech), (2012-2016), through Meerut Institute of Technology, Meerut. (UPTU Lucknow)

Academic Qualification

Intermediate from C.B.S.E Board in 2010.

High School from C.B.S.E Board in 2012.

PERSONAL PROFILE:

Language known : English, Hindi (read, write, speak).

Marital status : Single

Gender : Female

SUMMARY

I have a well background of computer knowledge and good knowledge of data communication and networking. Apart from good technical & logical skill, good communication skill, attitude to work in a group and zeal towards quick learning with sincerity & commitment are some of my positives.

Place

Date (Vandana Mittal)

Contact this candidate