Curriculum Vitae

SAGAR SHRAVAN CHAUDHARI Ph No: +919********* / +971*********

E-Mail ID: - adiy39@r.postjobfree.com / adiy39@r.postjobfree.com

Career Objective: -

To lead and excel by benchmarking with maximum utilization of my skills for organizational and personal growth.

Professional Summary: -

Having 9 years of IT experience in analysis, design, development, implementation, testing and support using Business Intelligence tools, Visual studio (.NET) etc.

Latest Six years’ experience in SQL Development (MSSQL, T-SQL and SSIS).

Initial Three plus years’ experience in .NET technology (ASP.NET, VB.NET, C#, JavaScript, jQuery, T-SQL, MSSQL Server, MySQL, PL/SQL).

1 year Experience in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Transformation from Excel Sheets using SQL SSIS.

Worked on MySQL & PL/SQL for a short period of time and I am able to work on any given environment related to SQL.

Future aspiration is to excel in Data Analyst or Data Science.

Good experience in Design and Implementation of Database systems using MSSQL 2014.

Experience in creating jobs, SQL Mail Agent and schedule DTS/SSIS Packages.

Ability to translate business requirements into technical specifications and interact with end users to gather requirements for reporting. Excellent analytical and programming

Has the Capacity to work hard in order to meet the stipulated deadlines.

Good work ethics, team oriented, flexible and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills.

Technical Skills : -

Web Technologies

ASP.NET (3.0), HTML, Java Script, JQuery, CSS, Ajax.

Languages & Software

ASP.NET, C#, VB.NET.

Database

SQL Server 2008, 2012 and 2014, MySQL, Oracle 11g.

Other BI

MSBI-SSIS

Reporting Tool

MSBI-SSRS

Operating System

Windows 2007, Windows XP.

Source Control Systems

TFS, Visual Source Safe and Sub Version.

Professional Experience: -

Cigna Insurance, Dubai Oct 2019 – Present

Work Experience (SQL Database, C#): - Team Size: - “1”

Project Name: - “Policy Certificate” Role: - Database Developer.

Project Description :-

Generates different types of certificates like Health Insurance, Travel Certificate and Continuity Certificate using window based application. Collect all types of data from different system through Text files & Excel sheets and stores it in SQL Database. Using this data it generates Policy certificate at Front end application (.Net).

Capgemini Technology Services India Ltd

Apr 2016 – Sept 2019

Work Experience (SSIS,SSRS,SQL Development): -

Team Size: - “08”

Project Name: - “Deposit Import”

Role: -

Developer & Support

Client: - WillisTowersWatson (US/UK)

Environment: - MSSQL Developing, SSIS, SSRS, C#

Domain: - Insurance & Brokerage

Project Description :-

Willis is a leading global advisory, broking and solutions company that helps clients around the world turn risk into a path for growth.

Willis service center supports insurance & re-insurance accounting, managing premiums & claims, accounting & receivable management, along with some of the risk management services like pre-sale research, actuarial services, knowledge services, project management, catastrophe modeling, IT development, human resources, and many more.

In Deposit Import we build an automate process to receive lockbox and ACH/Wire transmission files, convert into standardized format, loaded the payment information into EPIC application and generated reports over SharePoint for the same.

Roles & Responsibility :-

Designing and developing Database structure and Tables procedures & flow.

Debug SSIS Packages find out RCA & resolved issue in SSIS Packages.

Working on Developing, Deploying and Processing SSIS packages.

Developed SSIS packages using ETL architecture, solution design & development.

Responsible for developing new requirement and any change requests – investigation, resolution of issues.

Created jobs, SQL Mail Agent and schedule SSIS Packages.

Developed Reports using SSRS 2012, 2015

Co-ordinating with BA to understand the requirements and help with the technical documents to be prepared.

Coding and testing of my own deliverables.

Helped converting business requirements into technical solutions

Interaction with the end users if they face any issue.

Managing the project from offshore

AurionPro Solution pvt ltd. May 2015 – April 2016

Work Experience (T-SQL Developer, MS SQL Server): - Team Size: - “3”

Project Name: - FAME ERP (HUMAN CAPITAL MANAGEMENT) Role: - Backend Developer.

Client:- Bahrain Institute of Banking and Finance, Gulf Union Insurance, Delmon Readymix, Bahrain

Development Bank

Environment: - MSSQL Developer, T-SQL Developer

Modules in Project: - HCM is a complete solution to HRMS that contains various sub modules such as HR, Self Service, Attendance, Payroll, Leave Management, Work Flow Management, Recruitment and Training.

Project Description :-

Fame ERP is a new technology based ERP solution that contains two products client application called as FAME Business Suit and Developer application called as FAME Designer suit. ERP User can interact with the system through FAME Business Suit. FAME Designer which allows drag and drop based application designing and developer can easily design the front end and can develop and enhance as per the requirements in integrated suit itself.

Business logic is defined at database end especially in the stored procedures, functions, triggers so as to keep system performance.

Roles & Responsibility :-

Development of ERP Solution for Human Capital Management Module all Backend part like create table structure, store procedure, function triggers etc.

Analysis, Design & Development of core modules of HCM such as Attendance, Payroll, Leave Management, HR, Self Service and Workflow Management

Handling Offshore Team developments

Brinks India Pvt Ltd Sept 2014 to May 2015

Work Experience (ASP.NET, C#): - Team Size: - “7”

Project Name: - “E-Routing” and “E-CBR” (Cash Balance Report) Role: - Software Developer.

Client: -HDFC Bank, ICICI Bank, SBI Bank, Yes Bank, Axis Bank.

Environment: - SQL Server 2012, ASP.Net 4.0, HTML, JQuery.

Project Description :-

E-Routing system is to improve the schedule services of ATM/Stops to the Customer. The E- routing over comes the hurdles to keep track of relevant information’s carried out by the Brinks during their services to the Atm/Stop. The E-Routing will to maintain the updated records of the Atm/Stop Process. And ECBR system is a Maintain all the ATM money transaction in daily basis and send Money transaction report to the all banks.

Roles & Responsibility :-

Designing and developing ATM Cash Transaction Software.

Handling and resolving user acceptance issues raised by client.

Involved in preparation of detailed design documents.

Coding as per Naming convention of CMMI 5 & Unit Testing.

Conducting reviews and Independent Testing.

Work in RDLC Reports for M.I.S.

Created jobs, SQL Mail Agent and schedule SSIS Packages.

Shawman Software pvt Ltd Sept 2011 – Sept 2014

Work Experience (ASP.NET, VB.NET, C#, MS SQL Server): - Team Size: - “13”

Project Name: - “Human Resource Management System” Role: - Software Developer.

Client: - Eureka Forbes pvt ldt, Sahara Hotels, Sayaji Hotels, Nilkamal, Leela Hotels.

Environment: - ASP.Net 3.0, C#, VB.NET, SQL Server 2008, HTML, JavaScript.

Modules in Project: - HRIS Foundation Module, HRIS Portal Module, Training Module, Attendance Module, Leave Module, Confirmation Module, Exit Interview Module, Appraisal Module,

M.I.S Reports Module, Organization Chat.

Project Description :-

A Human Resources Management System (HRMS) is a Software Application that combines many human resources functions, including benefits administration, payroll, recruiting and training, and performance analysis and review into one package.

The HRIS ensures that every aspect of Human Resource is covered, from Employee details, head hunting, appraisals, training, career progression, separation and diverse variety of MIS. The software initiates comprehensive HR solutions to the organization disengaging complexity in the HR operations thus bringing forth value-added services as well as reducing operational costs.

This was a product that facilitated various routine activities of the Human Resources Department right starting from recruitment, then with implementation of leave/attendance policies and even performance appraisals.

Roles & Responsibility :-

Designing and developing various modules like Training and knowledge canter of HRMS.

Designing and developing Database structure and Tables procedures & flow.

Handling and resolving user acceptance issues raised by client.

Involved in preparation of detailed design documents.

Coding as per Naming convention of CMMI 3 & Unit Testing.

Conducting reviews and Independent Testing.

Work in RDLC Reports for M.I.S.

Interaction with the end users if they face any issue.

Academic Qualification :-

Examination

School/College

University

Year of Passing

M.C.M

Neville Wadia Institute of

Management Studies & Research.

Pune

July 2010

B.COM

Agrawal College

Mumbai

June 2008

H.S.C.

Model College

Mumbai

June 2004

S.S.C.

Saraswati Mandir School

Mumbai

June 2002

Personal Details :-

Permanent Address

E-302, Om Palace, Mangeshi Elite, Dadaji Nagar, Rambaug Len

Number 4 End, Kalyan West – 421301 Dist – Thane

Current Address

Al Amer Build, Near Al Fahidi Metro, Dubai - UAE

Father Name

Shravan Rama Chaudhari.

Date of Birth

16th March 1987.

Gender

Male.

Marital Status

Married.

Nationality

INDIAN.

Languages Known

English, Hindi and Marathi.

Awards and Achievements: -

Completed Three year N.C.C (National Cadet Crops) “B” & “C” Certificate.

Best Cadet and Best Rank Holder (Senior) in College.

Working in CG (Capgemini) for Last two year rated 2 in both the appraisal.

Awarded with Pat on Back (POB) for May 2017 and Star Award H1 2017 in CG.

I hereby declare that above written particulars are best of my knowledge and belief.

Place: - Dubai

Date: Sagar S. Chaudhari.

Contact this candidate