House No. 148, Sector -2, Old Mahabir
Nagar, New Delhi, 110018
Email id:-Home:-
Cell: -
Abhishek Mahna
Profile
3 years 6 months of IT industry experience encompassing a wide range of skill set, roles and
industry verticals.
Certified in Microsoft Professional Program in Data Science.
Extensive knowledge of Healthcare Domain especially in Claims Processing.
Extensive experience with analysis, design, development, customizations and implementation of
software applications.
Proficient in analyzing and translating business requirements to technical requirements and
developing processes.
Developed three In-House Tools to automate daily organizational activities.
Strong database skills, Object Oriented Programming and development knowledge
Handled multiple roles –Software Developer, Software Tester, System Analyst, Project Trainer,
Mentor.
Proficiency at grasping new technical concepts quickly & utilizing it in a productive manner
Good communication skills, interpersonal skills, self-motivated, Dynamic, versatile, quick learner,
team player.
Skill Set
Sybase, Microsoft SQL Server 2012, Oracle 9i/Oracle 10G/12C, MS
Access 2000
Visual C#.Net, Visual VB.Net, C,C++, Visual ASP.Net, SQL, PL/SQL,
Transact-SQL, Python
MS-Windows XP/7, Windows NT
RDBMS:
Languages:
O/S:
IDE:
Interactive SQL(SQL Anywhere), Microsoft Visual Studio, PL/SQL
Developer, Microsoft Office, Microsoft Visio, Crystal Reports, HP ALM,
Ultra Edit, IPSwitch WS_FTP and Beyond Compare.
Healthcare Product:
Facets Interactive 4.71/5.2 in Claims Processing Module and Provider
Module.
Education:
2013 Bachelor’s in Computer Science Engineering, Guru Gobind Singh Indraprastha
University, New Delhi, India
2008
All India Sr. Secondary School (CBSE) from VV DAV Senior Sec School, Delhi
2006
All India Secondary School (CBSE) from DAV Public School, Himachal Pradesh
Professional Experience
March 2015 – Till date, Software Engineer UHG Information Services Pvt. Ltd.
India
1
Project Title: FACETS CSP (Community and State Strategic Platform) (Dec 2013 – Till Date)
Responsibilities:
Analyzed the business requirements of the project by studying the Business Requirement
Specification document.
Interacted with business analyst to develop the modeling techniques.
Involved in understanding business requirements and preparing functional specification
document of the requirements.
Worked on ICD10 Migration Modules and Code Load Modules which have a greater impact to
the business in the coming future.
Working on Providers, Claims, Utilization Management and Finance Modules which has a greater
impact to the business in the coming future.
Creating SQL, PL/SQL stored procedures, views and functions to meet the requirements
Involve in analysis, design, development and testing of the Sybase/Oracle objects
Running batch jobs for loading databases tables from 837 KWD (keyword) files using NT server
and FTP/Telnet.
Went through internal training for Facets 4.71 front end interfaces and completed multiple case
studies involving both Provider and Member modules.
Created an automation tool “Database Analyzing Utility” in C# Dot Net to automate the
following processes resulting in an annual savings of $1,60,000
o Determining Object Text/Name Dependencies.
o Distinguishing Objects Based on Object Type(Tables, Triggers, Views, Procedures)
o Generating an Automate worksheet that could help in further analysis.
Created an automation tool “Sybase Script Generator” in C# Dot Net to automate the following
processes resulting in an annual savings of $17,500
o Create generic scripts for the basic commands including Create Table, Indexes, Triggers,
functions, etc.
o Determine the presence of primary keys on table and if not present then create one
based on the Current data present or as per User requirement.
Environment: Interactive SQL 11.0.1, Facets 4.71, Facets 5.2, Oracle 12C, Dell Toad, Microsoft
Visual Studio 2015.
Team Size
: 15- 20
Nov 2013 – Feb 2015, Associate Software Engineer UHG Information Services
Pvt. Ltd. India
Project Title: FACETS RV (River Valley) (Dec 2013 – Oct 2014)
Responsibilities:
Analyzed the business requirements of the project by studying the Business Requirement
Specification document
Interacted with business analyst to develop the modeling techniques
Creating SQL, PL/SQL stored procedures, views and functions to meet the requirements
Creating Front End Application in VB.Net to meet the requirements of the Business.
Involve in analysis, design, development and testing of the DOTNET/Sybase objects
2
Running Bulk Copy Paste Functionality for loading Input Files to the database using Dotnet
Code.
Involved in performance tuning of the front End Application.
Successfully implemented a tool “Evaluation Exam Summary” for a Team in current
organization resulting in an annual savings of $10,000
Environment: Interactive SQL 11.0.1, Microsoft Visual Studio 2012
Team Size
: 3-5
Accomplishments
Received a Ruby Recognition Award from IT Director, for exceptional performance in ICD10
Code Load Process.
Received Diamond and Opal Recognition Awards from Onshore leads for performance.
Received a Special Thanks and Recognition (STAR) Award from senior management, for
exceptional performance across major projects.
Received 3rd prize in .Net Quiz competition across UHG India.
Achieved Director’s Honors Awards and Merit Certificates for scoring second highest marks in
B.Tech (CSE) 1st Semester, 4th Semester and 5th Semester.
Achieved a Certificate and the 1st Prize in Inter School Programming (Visual Basic) Competition
in class 12th.
Achieved a Certificate and Memento for scoring good marks in 10th Class in City.
Other Activities
Working with an NGO “Koshish Kuch Kar Dikhane Ki” since December 2013. Developed
Financial Tools to create Donor Penny Visibility, thereby attracting more donations to the
organization.
Have tutored high School kids for more than a decade.
3