Summary of qualifications:

• 9years of experience in software Development involving in Design, Analysis, Coding, Testing, Implementation and Support
• Thorough understanding of complete System DevelopmentLife Cycleincluding requirement analysis, database design, systems design, development and Testing
• Extensiveexperience on Databases like MS SQL 2005/2008 R2, Oracle 9i/8.x/7.x/6.x
• Extensive experiencein scripting languages like T-SQL and PL/SQL, Unix Shell Scripts Tremendous experience in writing complex SQL Queries, stored procedures and triggers Good experience in Database Administration, Analysis, design and Architecture
• Extensive experience in Clinical Healthcare, HL7 formatting, LIMS and ANSI X12 / HIPAA Health Care Transactions
• Good understanding of Data warehousing project life cycle, especially tasks within the ETL phase
• Strong experience in Data Modeling, ETLTools like AscentialDataStage7.x and MS DTS/SSIS
• Very good experience in Microsoft BI Technologies SSIS/SSAS/SSRS
• Selfmotivated, hard working, team oriented, hand-on professional with an excellent track record of productivity

Professional Experience

Confidential

MS SQL Lead/Data Warehouse Developer

Confidential home Confidential monitoring services. It helps patients and healthcare professionals get timely and actionable information anywhere, anytime. Confidential products and services empower caregivers and patients with the data they need to make better decisions to achieve better health and economic outcomes.

Roles and Responsibilities:

• Developed an integrated automated process for Eliza Compliance call IVR System using SSIS
• Designed a process for auto faxing to send Clinical monthly summary reports to eligible clinics using T-SQL/SSRS/SSIS
• Created various reports like eRx Physicianforms, elizareports for testing services using SSRS
• Involved in building Presence Dialer Processes for testing services Call Center for various outbound dialer services
• Involved in data analysis and building the complex business logic for CMS billing
• Created an automated process by generating billing lists for various billing categories CMS, Aetna and Medicare Replacement plan which eliminates all manual process including reconciliation
• Involved in creating several ETL processes in Data warehouse environment by integrating Clinical Management System
• Involved in creating OLAP cubes for patient diagnosis and billing
• Involved in database administration and production support
• Involved in configuring file operations for FTP/SFTP
• Currently working on building an efficient tool Billing Engine by embedding the billing rules for all plans, validation checks as pre-requisites for major plans like CMS which accomplishes the compliance and regulatory support for the business also comply with audits

Environment :SQL Server 2012/2008 R2/2005, T-SQL , Eliza IVR System, Presence Dialer suite, ASP.NET, SSIS, SSRS, SSAS, ETL , OLAP, SalesForce,FTP/SFTP,Windows 7 Professional, SharePoint 2007, Visual Studio 2008/2010

Confidential

MS SQL/ BI Consultant

Confidential : is a Internet-based energy management software, which allows for real-time monitoring of site conditions and energy production, fault isolation and diagnostics, operation and maintenance logs, remote access and control of the entire system and hundreds of alerts and alarms. ISIS is integrated and designed specifically for the Confidential tracker system.

Roles and Responsibilities:

• Involved in creating the complex stored procedures for the ISIS system to monitor the site performance using T-SQL
• Designed and developed various reports for the ISIS application using SSRS 2008 R2
• Involved in creating charts for different entities using SSRS
• Created various manufacturing reports for the manufacturing system using SSRS
• Involved in Data Analysis, data validations , production support
• Involved in configuring the Report server, Scheduling the reports
• Involved in creating SSIS packages for DAT files extract to load the manufacturing data into the system
• Created complex SSIS packages for the Corporate operations data exchange
• Created complex ETL process for the warehouse as well as ODS
• Developed the formula model for engineering team by writing complex meta rules using T-SQL

Environment : SQL Server 2008 R2 , SSRS, SSIS, T-SQL, ASP.NET, VB.NET/C , Windows 7 Professional , TFS , SharePoint 2007, Visual Studio 2008/2010

Confidential

SQL/ETL Developer

• Confidential: The Insight program aims to integrate information across multiple subject areas there by maximizing the potential of using Paradigm's unique data and providing its business areas witha historical, current, and consolidated view of clinical and contract information. The program also addresses the need to automate and publish Confidential on a dashboard for intended audience
• Confidential:Is a referral application which is developed in order to create an efficient referral intake process through automation and batch upload by assigning referral cases to PMDs and Attorneys once the cases were validated or reviewed by the physician and then creating a patient contract for the complex case management

Roles and Responsibilities:

• Implemented the ETL process in a data warehouse environment.
• Created dimension, fact, aggregate tables through SSIS packages
• Involved in data massaging, error handling and alert messages in the EDW
• Created/validated transformations or aggregations
• Created complex SSIS packages to upload the data through FTP/SFTP
• Designed the IMM referral screens using .NET 4.0 Class libraries
• Developed and maintained the referral application by utilizing ASP.NET and implementing the business logic using C
• Created stored procedures for KPIdash board reports which involves many calculations like variance, gap days for OP report deliverables associated with a case management contract , etc, to support clinical management team
• Created OLAP cubes for KPI dash boards using SSAS
• Developed SSRS 2008 reports for Clinical Management Team
• Involved in creating complex T-SQL Scripts/Stored procedures for IMM Referral application
• Involved in working on other business systems to support the production environment

Environment: SQL SERVER 2005/2008, T-SQL, SSIS, SSAS, SSRS, COGNOS 10.1, Windows 7,.NET 4.0, ASP.NET, VSS 6.0, C , VB.NET

Confidential

SQL/SSRS Report Developer

Confidential: Confidential system offers enterprise practice management, electronic medical records, enterprise appointment scheduling, Patient Portal, with a constant need to increase efficiency and reduce costs while providing high-quality service. The Practice management systemMedical billing is a complex procedure of billing and collecting professional fees for medical and healthcare services provided to patients. Doing it right requires a broad range of knowledge and understanding of the medical billing process and health insurance company rules provides a powerful and easy to use solution to manage Confidential entire business accounts details in easiest and accurate way.

Roles and Responsibilities:

• Involved in Extraction, Transformation and Loading of several flat files pharmacy and load them into OLTP tables by creating SSIS Packages
• Involved in helping accountant department by creating various financial reports using SSRS
• Involved in creating various billing reports to calculate revenue details for A/R
• Involved in event handling by sending automatic email messages
• Involved in developing the Practice management system using .NET Class Libraries
• Created T-SQL scripts for error log tool to track the errors in log files and then sends an automatic email messages upon encountering a new error in the log files
• Supported business users by debugging the application and fixing the data issues
• Involved in backup and recovery strategies, supporting the production environment from recovery
• Involved in creating SSIS packages for maintenance plans and other system support
• Designed the intranet web application for the HR by creating customized timesheet application using ASP.NET/C

Environment: SQL SERVER 2005, T-SQL, SSIS, SSRS, .NET 3.5, C , Windows XP, Database mail server

Confidential

SQL/EDI Developer

Confidential is the combination of Clinical Management System and Laboratory Information system thattracks the patient through the entire clinical procedures, focuses on patient-physician encounters, eliminated paper charts, enables the end-user to generate a comprehensive clinical note, maintain patient's health information and provides interfaces for external laboratories to directly feed the lab results into the central database.

Role:

Confidential

• Involved in Database modeling logical and physical using Erwin 4.0
• Involved in Design, Development and Testing of Practice Management System that submits Claims electronically and tracks remittance
• Designed and developed BizTalk solution for the client's insurance company. It interfaces with backend legacy system using flat file format and interfaces with external partners using EDI X12 837, 835
• Involved in developing an interface with Blue Cross/Blue Shield
• Involved in creating interface stored procedures used in SSIS to load/transform data to the OLTP database
• Involved in Design and development of Various Aging Reports, Financial Reports and Patient Accounts using Crystal Reports v10 and SQL Reporting Services SSRS

Confidential

• Developed Bi-directional HL7 compliant Interface that Interfaces directly with lab companies like LabCorp for placing orders and receiving results.
• Involved in building HL7 Messages and transferring Order files to Lab Companies and Clearing houses
• Developed SQL Server Integration Services SSIS packages to transform data from SQL 2000 to MS SQL 2005
• Created OLAPcubes by extracting from SQL stored procedures in order to generate reports
• Developed testing scenarios and test plan for interfaces. Performed unit, functional and regression testing of interfaces
• Created MDX queries for the OLAP cubes using SSAS
• Involved in design and development of Presenting/Reporting Results to Physicians and Alerts on Abnormal Result
• Involved in building Stored procedures, Triggers etc and Data base related Scripts for the interface

Environment: SQL SERVER 2000/2005, T-SQL,Visual Basic 6.0, COM , ERWIN 4.0, Crystal Reports v 10, SSRS, SSAS, OLAP, Test Director and Windows 2000, BizTalkServer2006, DTS/SSIS, VSS 6.0

Confidential

Database Developer

The Confidential provides a user interface to allow for outfitting choices, as well as perform data manipulation and processing to streamline the assimilation process. The tool allows requisitioning of the essential equipment, phone and computer, necessary to provide baseline communication and functionality. This process will automate the essential account creation upon generation of the EmpID, eliminating the need for a separate request and signature loop. By evaluating the processes and making some changes the lag between start date and productivity can be reduced to day one or two.

Role:

• Designed the database in a normalized way and involved in importing the data from Flat files people soft to Data base Tables using SQL LOADER
• Provided an interface to People Soft HReRecruit in order to collect data for RFT personal in the hiring pipeline
• Connected to LDAP server in order to get required attributes from corporate directory
• Involved in creating Database Objects, Batch Processes for eRecruit Interface
• Involved in writing complex Queries, Stored Procedures, Email Triggers using SMTP in order to send emails to Hiring Managers, Originators as well as Remedy System using MIME Formats.
• Configured the LDAP ActiveX Client components COM in order to retrieve corporate directory Sun One Directory 5.2 attributes using VB.NET application logic
• Involved in SQL Query Performance Tuning
• Involved in Backing up and restoring Oracle9i databases
• Involved in writing UNIXShell scripts to schedule the jobs

Environment:

Oracle 9i, LDAP Sun one Directory 5.2 , ASP.NET, ADO.NET, SQL, PL/SQL, COM, VB.NET, SMTP, MIME, WINDOWS 2003, UNIX, IIS 6.0,TOAD, MS Visual Studio.net 2003