SUMMARY:

• Over 7 years of project leadership, data architecture, implementation and integration experience in Healthcare Industry.
• Over 7 years of technical leadership and architecture experience in developing highly available and scalable applications.
• Over 8 years of experience in data Integration, data analysis, data extraction and data manipulation in Healthcare, Oil & Gas and Education industry.
• Over seven years of proven experience in analysis, design, development, implementation, testing, and maintenance of database design and development in SQL server system
• More than seven years of experience in writing SSIS packages, stored procedures, stored functions and database triggers using SQL server, working with PL/SQL, T - SQL and working on database tier of the three tiers windows DNA architecture, MY SQL, SSIS, SSRS, master data management, JAVA, C, C++, XML, C#, VB.NET and many other applications and tools
• In-Depth data Extraction knowledge from EMR/EHR systems, Patient management systems and clinical informatics systems.
• In-Depth knowledge of Healthcare EDI standards.
• Over two years successfully architected and designed and led and developed enterprise projects covering various aspects of software development, processes and methodology
• Extensive experience in object oriented analysis and design development, middleware and enterprise application architecture and implementation
• Ability to see, suggest, model and deliver viable technical solutions for real world business problems
• Business focused, possess strong technical aptitude and excellent client-facing communication
• Sound knowledge of upcoming advance and high tech technologies
• Deadline oriented, a good organizer, self-taught person in terms of the latest technologies and techniques, good communication skills, team worker, and very fast learner
• Excellent academic credentials
• Lead the team on implementation as technical and functional lead
• Ability to educate, demonstrate and teach the new technologies

TECHNICAL SKILLS:

SKILLS: EMR/EHR and PM systems Epic, NextGen, Allscripts, Meditech, eClinicalWorks(ECW), eMD, Greenway, Mckesson, Lytec, Athena, Centricity, GE IDX-Flowcast, GE Groupcast, Sage Intergy

Database: MSSQL, Clarity, Hadoop, MYSQL, T-SQL, D3, MSACCESS

Languages: C#, C, C++, JAVA, J2EE, SQL, Ruby, Pig Script

Operating Systems: Windows, MS-DOS

Developer Tools: Cloverleaf, Visual Studio 2003-2013, MSSQL Integration Services, MSSQL Reporting Services, Eclipse, Netbeans

Data Management Tools: Bluefinity, SQL Server Management Studio, Initiate Data Services (IBM)

Networking/Security: Active Directory, TCP/IP, DNS, S/FTP, VPN, IIS 5.0-7.0, SSL, VMware

Other Tools: FACTS (Fully Automated Claim Transaction System), CA Tool, Active Directory, Ghost, Hobson s Employment Management Technology (EMT) Tool, VMware vSphere Client, IBM Remote Supervisor Adapter (RSA), Advanced Management Module (AMM), JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Integration Architect

• Work directly with hospitals (Clients) and vendors to gather requirements for integration and implementation of Hospital EHR/EMR and PM systems with Watson Health Products.
• Lead technical requirements gathering, documentation, and implementation of assigned client integrations, Configuration and development of software necessary to support client integrations
• Lead technical and functional activities related to large-scale projects to deliver on schedule with superior quality.
• Lead and develop the communication of integration and implementation activities with directors and VP’s of other departments to accomplish overall strategic department project goals.
• Responsible for enabling system integration between Watson Health system and client's Practice Management System, Electronic Medical Records System, Hospital Information Systems and/or Data Warehouse(s).
• Successfully bridge the gap between business and technology, manage client resources, drive technical solutions to timely completion, and identify, analyze, and extract key data from heterogeneous systems.
• Support the development of software tools, processes, and procedures that radically reduce customer implementation cycle time and eliminate opportunities for deployment defects
• Understand the needs of the business in order to ensure data supports client requirements
• Suggest process improvements to clients in their EMR/EHR and PM systems based on data analysis.

Environment: EMR/EHR system, Patient Management (PM) systems, Cloverleaf, Hadoop, Ruby scripts, PIG, GitHub, Impala, Hive, Jenkins, MS SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio, SQL Server Management Studio, Microsoft Visual Web Developer, MS Access, Excel

Confidential, Irving, TX

Integration Architect

• Worked directly with hospitals (Clients) and vendors to gather requirements for integration and implementation of Hospital EHR/EMR and PM systems with Watson Health Products.
• Led technical requirements gathering, documentation, and implementation of assigned client integrations, Configuration and development of software necessary to support client integrations
• Led technical and functional activities related to large-scale projects to deliver on schedule with superior quality.
• Led and developed the communication of integration and implementation activities with directors and VP’s of other departments to accomplish overall strategic department project goals.
• Responsible for enabling system integration between Watson Health system and client's Practice Management System, Electronic Medical Records System, Hospital Information Systems and/or Data Warehouse(s).
• Successfully bridge the gap between business and technology, manage client resources, drive technical solutions to timely completion, and identify, analyze, and extract key data from heterogeneous systems.
• Supported the development of software tools, processes, and procedures that radically reduce customer implementation cycle time and eliminate opportunities for deployment defects
• Understood the needs of the business in order to ensure data supports client requirements
• Suggested process improvements to clients in their EMR/EHR and PM systems based on data analysis.

Environment: EMR/EHR system, Patient Management (PM) systems, Cloverleaf, Hadoop, Ruby scripts,GitHub, Impala, MS SQL Server 2012, MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2012, Visual Studio 2008, SQL Server Management Studio, Microsoft Visual Web Developer 2010, MS Access 2007, 2010, Excel

EDI Developer

Confidential, Oklahoma City, OK

• Worked directly with hospitals (Clients) and vendors to gather requirements and implementation of projects.
• Worked closely with the management in the claims, provider maintenance, customer service, and marketing & eligibility teams.
• Provided data integrity and compliance by performing data cleansing, data mapping, data audit and data validation.
• Encryption, manipulation and analysis of claims & eligibility data received in electronic format, as well as creation of electronic files for third party vendors.
• Developed SSIS ETL packages to meet data flow needs.
• Extracted Data from D3 data source using Bluefinity tool.
• Imported data from different sources and the file formats such as text, CSV, Excel, access, EDI and XML.
• Designed new databases in SQL and write queries both in SQL and MS Access to update the existing database.
• Designed various SSIS modules in order to fetch the data in the data staging environment based on different types of incoming data.
• Designed various packages using various task e.g. for each loop, file system task, fuzzy lookups, multicasting various others for data cleansing.
• Extensively used views for complex joins queries involving multiple tables from different databases.
• Performed index analysis for tables and come up with more efficient solutions to use clustered and non-clustered indexes for significant performance boost of the existing product databases.
• Created complex stored procedures, triggers, and functions for validation process & for loading data from the staging out to the product database in SQL 2008.
• Developed, maintain, and monitor all import/export and data transformation into the staging, production and data warehouse environments.
• Created and develop query for drill down and AD Hoc reports using SQL Server 2008 Reports Services (SSRS).
• Worked on report generation using SQL Server Reporting Services (SSRS) that could be used to send information to other teams in the organization.
• Generated reports using global variables, expressions and functions for the reports.
• Maintained scheduling the subscription reports with the subscription report wizard.
• Created written plans of action to address requirements.
• Supervised EDI procedures and daily functions to ensure best performance, completeness and superiority.
• Updated provider records and fee Schedules in the FACTS system on the monthly basis.
• Processed weekly check run.
• Experience with ANSI x 12 EDI standards such as 834, 837, 835, 270-271 (both 4010 and 5010 versions) file formats.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2008, SQL Server Management Studio, Microsoft Visual Web Developer 2010, FACTS (Fully Automated Claim Transaction System), D3, TCL, MS Access 2007, 2010, Excel

Systems Specialist

Confidential, Oklahoma City, OK

• Designed, developed, tested, tuned, and implemented relational databases and procedural database code.
• Provided database development support to development team.
• Produced ad-hoc queries and developed reports to support business needs.
• Performed unit testing of developed solutions.
• Supported database administration and participated in special projects related to database administration.
• Developed and maintained SQL scripts in Microsoft SQL Server.
• Responsible for, and ensures timely resolution for end user requests/problems.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2008, SQL Server Management Studio, MS Access 2007, 2010, EXCEL.

Graduate Assistant

Confidential, Oklahoma City, OK

• Interaction with IT Head to understand business requirements and scope of the project
• Wrote various java scripts to automate day-to-day system administration
• Creating GUI Screen and implementing business logics for them.
• Migrating and upgrading the multiple applications Written Using MS Access and Vb 6 to Vb.Net 2005 Platform.
• Migrating the Database in Access to MSSQL with relational functionality
• Defining integration architecture, documenting technical requirements, and identifying success criteria.
• Reviewed and written technical specifications for various integration scenarios
• Programming, developing, and producing data-driven web applications and web sites using the latest technology solutions and software
• Coordinating and participating in the programming, implementation, testing, and support of web-based project.
• Executing test cases and fixing bugs through unit testing.
• Generating daily progress reports
• Experience in Database Management Task such as Creating Table, View, Stored Procedures, and Functions and Importing, Exporting or Transforming Data.
• Experience in Data Operations like Inserting, Updating, and Deleting Records
• Worked on Hobson’s Employment Management Technology (EMT) Tool
• Certification of Excellence for the Service at Confidential .

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2008, SQL Server Management Studio, MS Access 2007, 2010, EXCEL

SQL Developer

Confidential

• Developing SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Alter the schema for the required objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Designed and implemented stylish report layouts.
• Identified the Data Source and defining them to build the Data Source Views.
• Identified and defined the Datasets for report generation and also included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Implemented full and differential backups and also created and managed DB objects.
• Make recommendations for File group Creation and Placement.
• Scheduling backups and automating weekend maintenance tasks.
• Created users and roles for login authentication and validating permissions.
• Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
• Upgraded SQL Server 2000 to SQL Server 2005.
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.

Environment: SQL Server 2005/2000, SQL, MS Reporting Services, Management Studio, Query Analyzer, Windows 2003/2000 Server, MS Access 2003