Insurance Sql Server
Resume:
VENKATA AKHILESH RC GARI
Plano, TX 75074
Phone: +1-631-***-****
Email: ***********@*****.***
LinkedIn: VENKATA AKHILESH RC GARI
More than 3 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using SQL Server 2005/2008/2012.
Good experience in using Microsoft BI studio products like SSIS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
Expertize in Insurance, Healthcare sectors.
Used to C# to develop basic UI that have few buttons and will display the results of Master’s academic project.
Used MATLAB to simulate the electrical circuits and test their outputs to deliver the Bachelor’s academic project.
Education
Cleveland State University, Cleveland, OH December 2014
Master of Science in Electrical & Computer Engineering GPA: 3.4
Jawaharlal Nehru Technological University, Hyderabad, India 2008-2012
Bachelor of Technology in Electrical & Electronics Engineering (EEE) GPA: 3.74
Technical Skills
Programming languages: C, C++, C#, Core Java.
Database Packages: MS SQL, SQL BI (SSIS, SSRS, SSAS)
Packages: MATLAB, AutoCAD, MPLAB, PSpice, Kinect Development Kit
Microsoft Office, Open Office and Google Docs.
Relevant coursework
Embedded Systems
Computer Architecture
Secured and Dependable Computing
Network Security and Privacy
Computer Networks
Kinect Application Development
Major Academic Projects
The Swords - A Virtual Combat (A Motion Sensing Game)
A two-player game which uses Kinect sensor for capturing hu8man depth image. This game was designed in Unity 3D and used C# to design the code. It uses all accessories provided by Microsoft Kinect sensor.
Data Replication using Consensus Replication Algorithm (CRA)
This project explains write all, write all available, CRA algorithms and gives the advanced version of data replication techniques depending up on the type of data. Uses C# for UI development and MS SQL database for back end database.
On Campus Work Experience:
Teaching Assistant in Math Learning Centre, Cleveland State University August 2013 to Dec 2014
Work Experience:
IT Commence INC, Irving TX Feb 2015 - Present
SQL, SSIS Lead Developer
Client: Blue Cross Blue Shield of Texas, Richardson, TX.
BCBS is a key player in health insurance sector satisfying health insurance needs for over 106 million Americans. The project was about building up a group enrolment application which enables brokers to enrol their clients to health insurance plans/policies that BCBS offers. This application uses Java on front end and Microsoft SQL Server on the back end to store the application data.
Responsibilities:
Being a lead developer, used to co-ordinate with data base team of about 8 people including both on shore and off shore.
Attended all meetings with Business along with development team and analyse the requirements.
Understand all complex scenarios in the application and made them Data Driven to reduce the maintenance cost.
Automated many of the jobs that are being run manually to limit the repetitive bulky work effort.
Written many stored procedures with complex Joins which will work per Business logic and gives result set according to the requirement.
Worked on parsing XMLs using both SQL and SSIS.
Used Table valued functions, Scalar valued functions and Triggers and cascaded Stored Procedures.
Developed stored procedures for populating data in reports that are generated by BIRT, Cognos Tools.
Implemented performance tuning on several stored procedures that does ETL to reduce their execution cost.
Improvised and automated many SSIS packages to do Incremental loads and put down their execution time from different sources such as DB2, Oracle, Flat file
Used C# scripts in SSIS Packages to obtain hash codes to store some sensitive data.
Implemented Error handling using even handler in SSIS packages.
Developed multiple SSIS packages to implement type 2 Slowly Changing Dimensions (SCDs).
Performed database maintenance such as taking backups, server upgrades, applying windows patches on servers.
Participated in code deployment activities including SSIS packages while promoting application to production environment.
Used Red Gate Data Compare, Red Gate SQL compare to compare the databases across the servers to achieve version control on the database code.
Used Erwin, Microsoft Visio to develop the database model diagrams.
Environment:
MS SQL Server 2008 R2, MS SQL Server Integration Services 2008 R2, Red Gate, Windows 7, MS Office.
IT Commence INC, Irving TX Jun 2013 – Jan 2015
SQL Developer (Intern trainee under CPT):
Responsibilities:
As a member of Database and BI Reporting team, extensively worked on T-SQLs, Data loads and Reports for Land Administration & Revenue Accounting groups.
Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems into the databases for Dashboard Reporting on a daily basis.
Used SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules
Involved in writing various DB Objects like User defined functions, instead of triggers, Usage of Indexes for accomplishing various tasks
Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery
Contact this candidate