Ashish Sharma

acy3g7@r.postjobfree.com

502-***-****

Professional Summary

* ***** ** ********** ******** Implementation, Deployment, Requirement Gathering, Analysis, Testing and Support

Expertise in MSBI technologies SSIS and SSRS.

Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy Lookup, Aggregate, Derived Column, Sort, Multicast, Merge)

Created the SSIS package with Data incremental loading functionality.

Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging in SSIS.

Experience in creating configuration files to deploy the SSIS packages across all environments.

Worked with report manager for deploying the reports across all the environments.

Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.

Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.

Deployed reports in the report server and implemented subscription functionality.

Experience in using CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.

Expertise in writing Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Good ability to quickly grasp and master new concepts and technologies

Expertise in designing, implementing and maintaining QlikView Applications.

Hands on professional with thorough knowledge of scripting, data source integration and advanced GUI development in QlikView.

Expertise in using advanced features in Qlikview like set analysis, advanced functions, variables, multi-layer charts etc.

Proficient in creating QlikView data model designing for the QlikView applications.

Expertise in Problem solving

Bussiness domain knowledge of Healthcare, Insurance industries.

Responsible for the development and implementation using agile development.

Excellent Communication and Inter-Personal skills.

Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

Experience:

Organization

Designation

Duration

TCS

AST

11/2011- Till Date

United Health Group

Software Engineer

03/2010 – 10/2011

e2e Projects Private Ltd.

Tech. Consultant

11/2008 – 02/2010

Spica Software Services (company name changed to i2Soft now)

Software Engineer

07/2007 – 11/2008

IT Skill set:

OS

Microsoft Windows

Programming Languages

C#

Database

SQL Server 2005/2008 R2/2012

Technologies & frameworks

ASP.Net

BI

SSRS, SSIS

Tools

Qlikview, EPM 2007, Exposure to

Sharepoint, TFS

Scripting Language

JavaScript, Exposure to Ajax

PROJECT DETAILS

CANVAS

Company: TCS

Duration: 02/2013 to till date Client: Humana

Location: Louisville, KY,USA

Role: Developer

Salient Features:

Telemarketing Applications are group of Applications which supports Telemarketing area in Humana. These applications allow Telemarketing people to receive calls from Prospects, provide plan details, allows enrollment for plan, schedule an appointment/seminar; generate reports and many such features.

Responsibilities:

Analyzing the requirements and Understanding the requirement specifications

Design and Development of mock up reports to demonstrate the GUI to the client to get acceptance after the design of the screens/GUI.

Design and development of Qlikview reports and SSIS packages.

Implemented error handling in SSIS packages along with logging and configuration.

Extracted data from SQL Server, Flat files, CSV files and loaded into Data warehouse.

Identifying SSIS performance bottlenecks and providing resolutions for it.

To deploy and schedule SSIS packages.

Correct errors by making appropriate changes identified during system/ integration testing and then rechecking the program to ensure that the desired results are produced

Involved in designing the Data model and Construction of the Data model and implemented the Star schema for QV better optimization.

Created QVDs by importing data from the database tables using QlikView load script.

Load Data into QlikView application from different QVDs.

Reviewing the code, tasks and triggers when deploying the applications in production. Making sure that data model is clean and the coding is done following all the best practices such as eliminating synthetic joins or circular loops, commenting unused fields, reusing qvds etc.

Worked on qlikmaps and developed the geo maps using zip code and county boundary files.

Technologies Used: Qlikview, SQL Server 2008 R2/2012,SSIS

WF Trust CMO VarRate Offshore

Company: TCS

Duration: 08/2012 to 02/2013 Client: Wells Fargo

Location: Hyderabad, India

Role: Developer

Salient Features:

The application DTCIncomeProcessing contains a database which contains both CMO and Varrate data. Application contains Console Applications, Web Applications, Macros and Reports along with Control Logs. Periodically data will be loaded into the application from external sources like CMORT,DVCHG,Cusipfiles, which in turn will be processed and posted to the SEI (mainframe) system through the application using HIS Web Service.

Understanding and migrating two existing applications CMO and VarRate to single application DTCIncomeProcessing, which extracts data from external flat files and transforms the data to local database, and which posts data to Mainframe system using HIS services. After successful posting of data to SEI mainframe system, it responds to the application stating the status of the data which will be update in the database as well as shown in the SSRS reports.

Responsibilities:

As part of development group –

Coordinate with other application teams to resolve issues and dependencies

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSIS in Business Intelligence Development Studio (BIDS).

Used SSRS to develop different kinds of reports like ad-hoc reports .

Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.

Worked on formatting SSRS reports using the Global variables and expressions.

Deployed reports in the report server and implemented subscription functionality.

Prepared Sub reports, Nested Reports, Drill through Reports & Graphs reports using SSRS.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Provide support to system test and production launch activities

Technologies Used: SQL Server 2008 R2, SSRS,C#,.NET, Entity Framework

WFWTS Crystal to SSRS Conversion

Company: TCS

Duration: 11/2011 to 07./2012 Client: Wells Fargo

Location: Hyderabad, India

Role: Developer

Salient Features:

Understanding and migrating existing application named Popeye to SSRS 2008 R2 reports. The old application is coded in VB and crystal, which consists of 110 reports which are used for analysis by the client.

Responsibilities:

As part of development group –

Analysis of existing reports and its logic.

Segregating and estimating the effort for development of different complex/Medium/Simple reports.

Development of Reports with existing and new Requirements.

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.

Configuring the SSRS server

Managing and Deploying the reports.

Technologies Used: SQL Server 2008 R2, SSRS 2008R2,Recast Tool(TCS Internal Tool))

PCMH

Company: United Health Group

Duration: 01/2011 to 10/2011 Client: United Health Group

Location: Hyderabad, India

Role: Developer

Salient Features:

Patient-Centered Medical Home (PCMH) is an approach to providing comprehensive primary care of adults, youth and children, The PCMH is a health care setting that facilitates partnerships between individual patients, and their personal physicians, and when appropriate, the patient’s family.

Responsibilities:

As part of development group –

Understand and analyze the business requirements for Admin module and Patient module.

Coding and writing unit test case

Perform unit testing

Review system test cases with testers

Provide support to system test and production launch activities

Coordinate with onsite team members for business requirements.

Technologies Used: C#.Net4.0, SQL Server 2008, Third party tool (Infragistics), Windows XP

Global Solutions

Company: United Health Group

Duration: 02/2010 to 12/2010 Client: United Health Group

Location: Hyderabad, India

Role: Developer

Salient Features:

UHI Global Solutions system is part of the Global Hub system. The project purpose is to implement support claim processing for the international claims. The project includes user interface design for capturing and maintaining the claims, providers, members and subscribers information into Global hub database, processing that data by performing operations including currency and language conversion. The data into the global hub is also done using data got from other dependent systems using various file formats like 834, Xml, GSF, 837D, 837P, NSF & UB92 etc .The project also takes care of regenerating the input files after processing the data from the global hub which would be used by other dependent systems.

This application having 13 modules including Login Module, App Module, Site Minder functionality, Employer Portal, Call Center Portal, FLN Module, VOB Module, CLAIMS Module, Provider Module, International Provider, Customer / Member Files, Claim Files, Financial Files, Provider Files... etc..

Responsibilities:

As part of development group –

Understand and analyze the business requirements

Coordinate with other application teams to resolve issues and dependencies

Coding and writing unit test case

Perform unit testing

Review system test cases with testers

Provide support to system test and production launch activities

Provide support to infrastructure team for build and deployment

Coordinate with onsite team members for business requirements.

Worked on file processing and completed successfully all the files like UB92, NSF, GSF,

and UCAS files.

Created SSIS packages for file processing like UB92 and NSF acknowledgement.

Created SSRS reports for UCAS file.

Great team-worker - adaptable and flexible

Technologies Used: VB.Net3.5, SQL Server 2008, WCF, Entity Frame Work, SSIS, SSRS, Windows XP

Enterprise Application Project Tracker

Company: e2e Projects Private Ltd.

Duration: 07/2009 to 02/2009 Client: Wipro, Bangalore

Role Developer, Consultant

Salient Features:

Enterprise Application Project Tracker is an integral part of client’s enterprise application intitiave with an objective to integrate all internal applications at common platform. The project tracker application will provide the realtime status of the project to the business user. The project consists of the following modules:

EPM Deployment: EPM is a web based application which caters to project trails with updated task details of each resource and help organization use their work break down structure more effectively.

SSRS Reports: This module generates the custom reports to track the over all organizational health and details of each and every project on dash board and integrate it with Sharepoint.

Custom Field Creation: This consists of creation of the fields in project server as per the client’s requirements/specification.

Project Views Creations: This module consists of describing the fields to be displayed in dashboard as per the client’s requirements and populate it in a view.

Responsibilities:

Understand and analyze the business requirements

Coordinate with other application teams to resolve issues and dependencies

Coding and writing unit test case

Perform unit testing

Review system test cases with testers

Provide support to system test and production launch activities

Provide support to infrastructure team for build and deployment

Solely responsibe for the custom field creation and SSRS Reports creation. This includes the creation of:

oProject Detail Report

oTask Detail Report

oAudit Status Report

Development included designing, coding and testing components in the system from the presentation layer through the data persistence layer

Technologies Used: EPM, PL/SQL, SQL Server 2005, SSRS, C#.Net,Windows Server 2003

United Breweries

Company: e2e Projects Private Ltd.

Duration: 12/2007 to 07/2009 Client: United Breweries, Bangalore

Role: Developer, Consultant

Salient Features:

The Project Management Tool is a web based tool to provide the realtime status of the project using reports. This tool has features like user management and workflow mangement. The tool consists of the following modules:

EPM Deployment: EPM is a Web based application which caters Project Trails with updated task details of each resource and help organization use their Work Break Down structure more effectively

Task Escalation: This module performs task escalation automation with 3 levels of escalation i.e. if the resources have not completed their assigned task, the notification of this should go to their respective managers and similarly, if the task is still not completed after 15 days of the Task Finish Date, this should be escalated to the 2nd level and so on to the 3rd level.

Dashboard Customization: Created custom dashboard using .net framework

SSRS Reports: This module generates the custom reports to track the over all organizational health and details of each and every project on dash board and integrate it with Sharepoint.

Custom Field Creation: This consists of creation of the fields in project server as per the client’s requirements/specification

Project Views Creations: This module consists of describing the fields to be displayed in Dashboard as per the client’s requirements and populate it in a view.

Responsibilities:

Understand and analyze the business requirements

Coordinate with other application teams to resolve issues and dependencies

Coding and writing unit test case

Perform unit testing

Review system test cases with testers

Provide support to system test and production launch activities

Provide support to infrastructure team for build and deployment

Role includes idnetifying client’s requirement and creating the views and reports as per their specification. This also require the interaction with the other teams.

Solely responsibe for the Custom field Creation and SSRS Reports Creation. This includes the creation of :

oTask Summary Report

oTask Milestone Report

oProject Baseline Duration Vs Actual Duration Chart Report

Technologies Used EPM, PL/SQL, SQL Server 2005, SSRS, C#.Net, Windows Server2003

GMR

Company: e2e Projects Private Ltd

Duration: 03/2009 to 06/2009 Client: GMR, Bangalore

Role: Developer

Salient Features:

The Project Management Tool is a Web-based tool to provide the current status of the project at any point of time, to the management /concerned person. The tool consists of the following modules:

Customization: Custom Dashboard with the help of .Net

SSRS Reports: Create the Reports which shows over all Organizational Health and details of each and every project on Dash Board and integrate it with Share Point, where higher authorities will manage to see the overall project details.

Custom Field Creation: This consists of creation of the fields in project server as per the client’s requirements/specification

Project Views Creations: This module consists of describing the fields to be displayed in Dashboard as per the client’s requirements and populate it in a view.

Responsibilities:

Understand and analyze the business requirements

Coordinate with other application teams to resolve issues and dependencies

Coding and writing unit test case

Perform unit testing

Review system test cases with testers

Provide support to system test and production launch activities

Provide support to infrastructure team for build and deployment

Role includes idnetifying client’s requirement and crating the views and reports as per their specification. This also require the interaction with the other teams.

My role also included installation of Project Server 2007 and SQL Server 2005.

Solely responsibe for the Custom field Creation and SSRS Reports Creation. This includes the creation of:

oProject Detail Report

oProject Review report

oProject Baseline cost Vs Actual Cost Report(Chart)

oTask Detail Report

Technologies Used: EPM deployment, Project Viewes, Project template prepartion, Creation

of Custom Fields

Arogya

Company: Spica Software services.

Duration: 10/2007 to 08/2008 Client: Spica, Bangalore

Role: Developer

Salient Features:

It is a web based project developed for hospital management system along with its specialty to handle insurance domain. It provides easy access to critical information there by enabling the management to take better decisions on time. There is provision for non – insured patients to insure themselves in the hospital itself. It covers the following features:

Health Insurance

Inpatient management

Outpatient management

Appointments and Doctor’s Scheduling

Hospital Services (CT scan, MRI, ECG, Blood Test etc.)

Wardroom and Bed management

Pharmacy and Invoice management

Discharge and billing

Employee Module

Managerial Report

Registration for Patients and Doctors.

Responsibilities:

Understand and analyze the business requirements

Participate and Prepare the High level design document

Coordinate with other application teams to resolve issues and dependencies

Coding and writing unit test case

Perform unit testing

Review system test cases with testers

Provide support to system test and production launch activities

Provide support to infrastructure team for build and deployment

Technologies Used: ASP.NET, C#, ADO.NET, SQL Server 2000, HTML, JavaScript

Employee Transfer Application

Company: Spica Software services.

Duration: 07/2007 to 09/2007 Client: Spica, Bangalore

Role: Developer

Salient Features:

This is an intranet application for maintaining information related to its employees transfer and generating the transfer related documents. This application will be facilitating the system administrator (Higher Management) to search the employees transfer record, make new transfer record and also amend the allowances offered to the employee which usually depends on the post of the employee and the type of transfer he/she is getting. Intranet Employee Transfer Application will cover the following functionalities:

Login

Interface for filling up the following information

Searching the transfer records

Updating the transfer record

Making new transfer

Interface to generate the transfer related documents in .doc format.

Automatic mail notifications to the employees who got transferred and to the manager who would be receiving the transferred employees.

Logout.

Responsibilities:

Understand and analyze the business requirements

Participate and Prepare the High level design document

Coding and writing unit test case

Perform unit testing

Review system test cases with testers

Provide support to system test and production launch activities

Provide support to infrastructure team for build and deployment

Technologies Used: ASP.NET, C#, ADO.NET, SQL Server 2005, HTML, JavaScript

Contact this candidate