SUMMARY:

• Expertise in developing Data Warehousing and BI Solutions for more than 5 years in OLTP environments. Expert in writing SQL, SSIS packages, SSRS reporting. Proficient in analyzing healthcare domain data and used systems like Epic, Cerner and McKesson - Star.
• Knowledge of healthcare data that involving patient encounter, appointments, provider schedules, patient charges and transactions, hospital supplies, ICD-9 and ICD-10 diagnosis and procedures codes.
• Worked in agile and scrum processes to analysis, design, deploy and support in data warehousing. Collaborating with DB Architect and DBA for database modelling, database capacity planning, gap analysis, data retention policy and performing code review.
• Expert in data conversion and data migration using SSIS packages to transfer data between Oracle, DB2, flat files, Teradata and Flat Files to SQL Server using SSIS.
• Thorough knowledge of Machine Learning and writing algorithms like linear, logistic, neural network, k-means, SVM, PCA, and anomaly detection.

HEALTHCARE SKILLS:

Healthcare Standards: HL7, Confidential, Confidential FrameWork

Healthcare Tools: Epic Clarity, Epic Hyperspace, Cerner, McKesson Star

TECHNICAL SKILLS:

Languages: R, Python, C#, SQL, Unix Scripting, C, C++, Core Java

Tools: SQL Server 2014/2012, BIDS 2010, Oracle 9i/10g, DB2 10.5, Performance Dashboard, SQL Execution Plans, SQL Server Profiler, RapidSQL, BIDS, Octave, Juypter, R-Studio, Winscp API

Management Tools: Confidential IDA(Info Sphere Data Architect), JIRA, GIT Repository, MS Excel, FastTrack

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, MN

Technical Lead

Technologies: DB2 10.5, RapidSQL, FastTrack, DataStage 9.5, Epic Clarity and Person system, Epic Hyperspace, Business Objects reports

Responsibilities:

• Analyzing the report matrices from to developed data validation queries for Hospital Supplies database from Clarity database of Epic. Validated data from old SIMS (supply inventory management systems) in the database to replicate similar grain for new clarity data coming from epic ( Confidential ).
• Developing source queries that involves supplies, manufactures, supply types/charges, location, departments, sites, specialty and providers and procedures from Epic database.
• Coordinating with client to analyze the gaps in the reports and with find the source and with ETL developer to fix the gaps.
• Analyzing access management data which involves patient appointments, encounters, provider care teams, sites and departments. Analyses involves monitoring of staff on floor time, specialty / procedure time, inpatient hospital time, offsite care time, and personal time.
• Monitoring data quality of the providers visit types and unavailable reason free text of providers coming from epic templates and Cerner schedules block. Also coding the missing visit types to their correct time slots.
• Also monitoring data for providers who use specialty visit types or blocks in primary care departments. Provided monthly reports to management which helped in training operational staff on using correct visit types.

Confidential

Technologies: Oracle 11g, Informatica 10.1, Unified Data Model for Healthcare ( Confidential ), Confidential Info-Sphere Data Architect 9.1 (IDA), JIRA

Responsibilities:

• Coordinated with client and SME’s to created source-to-target mapping sheet and database design using Confidential and IDA. Data analyzes included identifying correct business Keys, lookup’s, business logics, and expressions to map correct data using Confidential framework.
• Provided walkthrough sessions to handover model design and requirements to ETL and QA team. Design included entities like anchor, detail, bridge and array tables.

Confidential

Technologies: MS SQL 2014 Standard Edition, SSIS, Visual Studio-2013, T-SQL, UDF’s, JIRA, Java, Confidential using Winscp API, Eclipse Mars, kafka, storm, GIT

Responsibilities:

• Developed transactional data model for Confidential (consolidated clinical document architecture) and to store logs, messages, and subscription notification involving 150 tables covering 2500 attributes.
• Performed database and data migration (23 million rows of 75 GB which includes 36 GB BLOB data) using scripts to move from phase-2 to phase-3 of project into production. Base script and delta scripts were versioned in sync with every application bugs fixing releases.
• Optimized the database performance by implementing table partitioning, tuning archiving stored procedures, UI queries in order to handle up to 33GB of data daily. Improved performance of application with indexing, setting fill-factor, data-page compression which reduced storage by 17%, tuned application queries to do index seek .
• Created SSIS packages to extract flat-files and sent it over Confidential ; created POC model to load delimited files into database using SSIS packages.
• Monitoring database performance during volume testing of application high peak load of 35000 mgs/hour; archiving; and Archiving performance of peak load of 18000 messages/hour.

Confidential, Parsippany, NJ

Database Developer

Technologies: MS SQL Server 2014/2012, BIDS 2010 (SSIS, SSRS), C# scripting, SSIS expression builder

Responsibilities:

• Created SSIS packages to load data from flat files, oracle data source to staging tables and then to transactional tables. Performed data quality check and scheduled packages into production.
• Implemented logging tables which maintained time taken for control tasks and procedures for all the packages and stored procedures. This helped tremendously in checking time taken by procedure and optimize them.
• Scheduled productive session with team to share new built-in functions in sql server, using available tasks in control flow for data transformation, improving code-quality, interpreting query execution plans and improving query performance using indexes.
• Used CTE that improved the performance of complex logic by over 30% in time. Developed complex queries that validated the anomalies in charges or transactions.
• Used various SSIS objects in data loading packages such as control flow Components, dataflow components, connection managers, error logging, configuration Files etc.
• Scheduled and maintained Packages using SQL job agent. Created database maintenance packages using shrink database and rebuild Index tasks for all databases.
• Implemented error handling logics in all the SSIS packages to handle bad data to error flow and avoid package failures.

Confidential, Malvern, PA

SQL Developer

Technologies: MS SQL Server 2008/2005, BIDS 2005 (SSIS, SSRS), C#, Teradata V2R6

Responsibilities:

• Created C# script to iterate over flat files and parse date, time, and decimal data values, change to ascii characters from report files provider by client.
• Created ad-hoc queries to check missing master codes, count and duplicates in transactional tables, min-max date ranges for missing data files, null percentage in columns.
• Developed stored procedures for reports for client. Built various drill down reports, parameterized reports and linked reports using SSRS.
• Created data model documentation like ER diagrams showing cardinalities, table and attribute definitions.

Confidential, Pittsburgh, PA

SQL Developer

Technologies: MS SQL Server 2005, SSRS, Teradata V2R6

Responsibilities:

• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Found bottle necks in queries and stored procedures and fine tuning. Monitored and tuned SQL scripts. Created upgrade scripts for production database and supported it.