Project Sql Server
Resume:
Ashish Sharma
******.********@*****.***
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