TECHNICAL SKILLS:

• MS SQL Server Database Administrator/Developer, BI, ETL, Healthcare and Business settings, SQL Server Configuration, Replication, Virtualization.
• Visual Studio, C#, .Net, C++,VB, SDLC, SharePoint, PowerShell scripts, REST API, Open Data Protocol MS EXCEL, Access, Visio, Oracle, Java, Cogito, Star, Radar, Workbench, REST API, Open Data Protocol, JavaScript.
• SSMS, SSRS, SSAS, SAAS, SSIS, SSRS, ETL, Crystal Reports.
• NoSQL, PLSQL, MySQL, T - SQL, SQL queries, Transact-SQL, SQL Server architecture.
• Data Science, Data Analysis, data mining, Data Warehouse, Business Intelligence, Statistical analysis, concatenations, pivot tables, Table partitioning and archiving, Data cubes, Data marts, Big Data.
• Optimize Stored Procedures, Indexing, Consistency Checks, performance tuning; SQL Server log shipping, SQL replication, scripting, Fine tune database, Function and trigger design and coding, Index implementation and maintenance, Clustering, Indexing.
• Random Forest, Machine Learning, Python, PowerPivot, PowerView Matlab/R, Ruby, Ruby on Rails, Agile, Waterfall, E-Commerce, Hadoop, SSAS OLAP cubes, Pentaho, Hadoop, PIG, Hive, Spark, Oracle.
• Tableau Architect, PHP, SQL Server Integration and Analytics Services, Data cubes, Data Science, Data Analysis, Data Warehouse Architect, mapping.
• E-Commerce, Hadoop, Big Data, MapReduce, Allscripts, R, HBase, Data modeling, HR Analytics, Data Integration architecture.
• OLTP, OLAP, database design, performance tuning and security model implementations.
• BI and analytic tools, Business Objects, QlikView, Tableau, COGNOS.
• Agile, Waterfall, Scrum development methodology, Web Services, Hyperion, OBIEE, Informatica.
• Healthcare, Cerner, Med Epic Tapestry, Epic Cashe, FACETS, Epic Clarity, HIM, Meditech, TriZetto Reporting, Eclipsys, Allscripts, Cerner, Siemens and McKesson EMR, Epic systems, Epic Beaker/Labs, HIPPA, EDI, Revenue Cycle, HEDIS, Healthcare (15 years)Claims (15 years) SOX, Compliance, Configuration, E H R.

PROFESSIONAL EXPERIENCE:

Confidential

FACETS SOLUTIONS ARCHITECT/ CONFIGURATION ANALYST HEALTHCARE ENGINEER

• Experienced working in MS-SQL, Epic Clarity, Healthy Planet Analysis & Reports Developer, Oracle OIM & CACHE database systems
• Worked on FACETS configuration setup and maintenance
• Created and audited benefits and claims
• Performed analysis of Facets for benefits and medical definitions
• Trizetto Facets Hosted Platform experience & troubleshooting batch job issues.
• FXI/FHG services Integration Exposure.
• Facets production Support of EDI transactions and accumulators.
• Integrated Facets applications to achieve business requirements
• Worked with multiple lines of businesses including Commercial, Medicaid, Medicare, and Specialty Benefits
• In-depth understanding of Facets Data model
• Strong knowledge on Healthcare domain
• Experience working with Facets batches, HIPAA Gateway and EDI processing
• System Configuration and migration through different environments
• Designed relational data models, SDLC and Architecture processes
• Trizetto Core batch processing .
• Facets HIPAA Gateway Trading partner and EDI configurations parameter settings.
• Understanding and Processing of EDI transactions.
• Experienced in Facets Implementation ( Legacy to Facets platform).
• Knowledge on Facets customization ( Interfaces and Extensions).
• Experienced in SOAP, WSDL, ETL, EDI, UML, OOA & OOD, REST, Data Warehouse
• Lead/supported Oracle & MS-SQL/CACHE database with operational, troubleshooting, management and administration
• Experienced working in Disaster Recovery Test & Exercises for Database Recovery, Healthy Planet Analysis, Developed Reports/Dashboards
• Worked in planning & deployment of Patch & Upgrades on Database systems
• Worked in the development, testing, documentation and integration of databases and user interface software products
• Worked in Proactive Performance & Capacity Analysis of Database infrastructure and provided recommendations
• Worked in configuring Database objects including tables, clusters, indexes, views, sequences, packages and procedures
• Able to work with application developers, system and storage administrators to optimize Database Configurations
• Configured Database encryption and security parameters
• Worked in configuring clustered databases as required using technologies such as Oracle & SQL Server clusters
• Experienced working in healthcare Industry and comply with HIPAA/PHI regulation
• Experienced in ITIL v33 processes
• Served as an escalation point for all database related incidents to customer
• Evaluated Database Configurations and provided recommendations for improvement & executed upon approval
• Assisted in application development in the logical design of databases
• Participated in New Project/application development design sessions and provided Database design recommendations
• Implemented Database archive processes and procedures
• Monitored Database logging systems including Database lock errors and troubleshoot causes
• Supported daily core functions of the various EPIC systems by designing and the developing complex reporting solutions to support the operational and management needs of various lab functions and user groups
• Provided operational support of EPIC reports and analytical solutions
• Worked with other team members, users in developing reporting and review analytical requests, designed, developed and deployed useful quality reporting solutions that not only met current but also future user needs utilizing organization tools, infrastructure, and existing reporting and analytical solutions. 
• Built solutions in Trizetto, MediTech, and Epic Clarity reports and data marts within the Enterprise Data Warehouse (EDW). Worked with organizations Epic Beaker system, data structures, and data integration including PowerPath, Rhodes, SafeTraceTX, and Beaker lab systems.
• Worked in the development of business intelligence solutions and other reports and analysis across all divisions of various organizations.
• Worked directly with front line clinicians to design and building BI reports and SQL queries and dashboards
• Familiarity with healthcare industry code sets RXNORM, SNOMED, CPT, ICD-9, ICD-10, PQRS,
• Experience working with healthcare data from IT systems such as Epic, Cerner, MediTech, Allscripts, Eclipsys, Sunrise, TouchWorks, McKesson Paragon, Horizon, Siemens Soarian, SMS Invision
• Worked on the oracle to SQL transition and training for staff
• Worked on the deployment, console and data operations.
• Provided Clarity Administration system updates, annual upgrades, and supported the development team
• Worked on ETL Administration, Business Intelligence, and Data Warehouse
• Worked in supporting the Epic Clarity on SQL Server project through design, development, testing and implementation. 
• Worked on Clarity Administration, system configuration and ETL development in SQL Server database environments for project data and analytics
• Performed scoping and estimating on Clarity and Data Warehouse related activities.
• Provided technical analysis for data accuracy of data
• Developed, Implemented and maintained Epic reporting system including Clarity and CDW with the implementation, monitoring and validation of provided ETL routines.
• Implemented, maintained, monitored and fixed Epic supplied data feeds and processes from various sources
• Provided recommendations for ETL and data processing routines and system configuration/environments to ensure promptness and error free.
• Developed custom ETL processes to provide additional data to the Epic Clarity Data Warehouse, BI data warehouses and systems for Reports
• Provided complete and consistent documentations of data warehouse contents, provided users with warehouse data analysis and reporting
• Delivered ETL tools and data warehouse systems including Epic Caboodle Data Warehouse, Ambulatory, Beaker, etc..
• Work with clients/vendors and team resources to evaluate and update new systems, modules for existing systems and implemented healthcare reporting and analysis.
• Evaluated and proposed architectural and design approaches for implementing new systems and assure adequate capacity for longer term scalability and supportability
• Performed all necessary technical installation and configuration steps to implement changes, troubleshoot and resolve application bugs.
• Worked in administering and supporting Epic Clarity.
• Worked with SQL Server, ETL SSIS, SSRS, SSAS, performance tuning, and system optimization.         
• Worked with Data Warehouse environment utilizing Epic Healthcare Data, Epic Clarity Database and Epic ETL Processes
• Worked with SQL, T-SQL coding and tuning, data warehousing architecture and design
• Ability to read, write and maintain SQL Code.
• Demonstrate Core Competencies as established for your position (Leading Self, Leading Others, Leading Leaders, Leading Function)        
• Worked with Oracle PL/SQL coding, performance tuning and Epic Clarity ETL.
• Evaluated, tested and implemented new and upgraded software. Performed Troubleshooting reported problems pertaining to reports and the reporting database environment, worked closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, in identifying the cause and designing and developing an approach for resolution. Assessed impact of changes and updates to source production systems, planning and implementing resulting changes to reports .
• Worked directly with business owners and analysts in the development of requirements and user stories for data solutions . Conducted end user training on reporting systems.

Confidential

Healthcare HEDIS Reporter Developer

• Trizetto Facets Hosted Platform experience & troubleshooting batch job issues.
• FXI/FHG services Integration Exposure.
• Facets production Support of EDI transactions and accumulators.
• Integrated Facets applications to achieve business requirements
• Worked with multiple lines of businesses including Commercial, Medicaid, Medicare, and Specialty Benefits
• In-depth understanding of Facets Data model
• Strong knowledge on Healthcare domain
• Experience working with Facets batches, HIPAA Gateway and EDI processing
• System Configuration and migration through different environments
• Designed relational data models, SDLC and Architecture processes
• Trizetto Core batch processing .
• Facets HIPAA Gateway Trading partner and EDI configurations parameter settings.
• Understanding and Processing of EDI transactions.
• Experienced in Facets Implementation ( Legacy to Facets platform).
• Knowledge on Facets customization ( Interfaces and Extensions).
• Experienced in SOAP, WSDL, ETL, EDI, UML, OOA & OOD, REST, Data Warehouse
• FXI/FHG services Integration Exposure.
• Facets production Support of EDI transactions and accumulators.
• Trizetto Core batch processing .
• Facets HIPAA Gateway Trading partner and EDI configurations parameter settings.
• Understanding and Processing of EDI transactions.
• Experienced in Facets Implementation ( Legacy to Facets platform).
• Knowledge on Facets customization ( Interfaces and Extensions).
• Worked on FACETS configuration setup and maintenance
• Created and audited benefits and claims
• Performed analysis of Facets for benefits and medical definitions
• Worked with Facets benefits and medical definitions
• Provided operational support of existing lab related reports and analytical solutions. Worked with team members, users, and others to triage reporting and analytics requests.
• Defined requirements, designed, developed and deployed high-quality reporting solutions that met current and future user needs utilizing organizations tools, infrastructure, and existing reporting and analytical solutions.
• Built solutions largely as Epic Clarity reports and data marts within the organizations Enterprise Data Warehouse (EDW).
• Have an understanding of the clients core functions, data structures, and data integration among Epic Beaker, PowerPath, Rhodes, SafeTraceTX, and other supporting laboratory systems, am proficient with Epic Clarity, Orders/Results the Beaker data models, Crystal Reports, SAP Web Intelligence, universe and report development, SQL in both SQL Server and Oracle environments, and SQL development tools, Oracle SQL Developer, Visual Studio, SQL Server Management Studio, including data warehousing concepts, ETL related tools.

Confidential, Nashville

EPIC CACHE CLARITY /FACETS SOLUTIONS ARCHITECT/ANALYST CONSULTANT

• Worked with Facets, Epic, Healthcare systems including Oracle OIM, MS SQL & CACHE database systems
• Worked on FACETS configuration setup and maintenance
• FXI/FHG services Integration Exposure.
• Facets production Support of EDI transactions and accumulators.
• Integrated Facets applications to achieve business requirements
• Worked with multiple lines of businesses including Commercial, Medicaid, Medicare, and Specialty Benefits
• In-depth understanding of Facets Data model
• Strong knowledge on Healthcare domain
• Experience working with Facets batches, HIPAA Gateway and EDI processing
• System Configuration and migration through different environments
• Designed relational data models, SDLC and Architecture processes
• Trizetto Core batch processing .
• Facets HIPAA Gateway Trading partner and EDI configurations parameter settings.
• Understanding and Processing of EDI transactions.
• Experienced in Facets Implementation ( Legacy to Facets platform).
• Knowledge on Facets customization ( Interfaces and Extensions).
• Experienced in SOAP, WSDL, ETL, EDI, UML, OOA & OOD, REST, Data Warehouse
• Created and audited benefits and claims
• Performed analysis of Facets for benefits and medical definitions
• Worked with Facets benefits and medical definitions
• Lead/supported Oracle & MS-SQL/CACHE database with operational, troubleshooting, management and administration
• Experienced working in Disaster Recovery Test & Exercises for Database Recovery
• Worked in planning & deployment of Patch & Upgrades on Database systems
• Worked in the development, testing, documentation and integration of databases and user interface software products
• Worked in Proactive Performance & Capacity Analysis of Database infrastructure and provided recommendations to customers
• Worked in configuring Database objects including tables, clusters, indexes, views, sequences, packages and procedures
• Able to work with application developers, system and storage administrators to optimize Database Configurations
• Configured Database encryption and security parameters
• Worked in configuring clustered databases as required using technologies such as Oracle & SQL Server clusters
• Evaluated Database Configurations and provided recommendations for improvement & executed upon approval
• Assisted in application development in the logical design of databases
• Participated in New Project/application development design sessions and provided Database design recommendations
• Implemented Database archive processes and procedures
• Monitored Database logging systems including Database lock errors and troubleshoot causes
• Managed data integration and business analytics with various healthcare organizations to deliver implementation services to clients an enterprise-class, open source-based platform for diverse Trizetto, Meditech, and Epic Clarity/Lab reports. I worked in the development of business intelligence solutions, Epic reports and analysis across all divisions of the organization. Wrote complex SQL scripts to extract data from various databases and systems for Epic reporting. Worked with Epic Clarity Orders/Results and with Beaker data models.
• Created reports using Crystal Reports, SAP Web Intelligence for report development, used SQL in SQL Server and in Oracle. Worked with SQL development tools such as Oracle SQL Developer, Visual Studio, SQL Server Management Studio, data warehousing concepts, and ETL tools. Created Schemas using Pentaho Infrastructure for Reporting & Analytics. Served as sole subject matter expert in the development of business intelligence reports and analysis. Researched and integrated external data sources into the organizations OLTP and Data Mart environments. Managed reporting environments including report data sources, security, subscriptions and metadata. Worked in data normalization and data integrity initiatives across the enterprise
• Identified and revised lab reporting requirements. Evaluated, tested and implement updates in software.
• Developed Relational Databases; Columnar Databases and columnar storage; SQL Programming; Pentaho Administration; Epic Clarity; ETL Management; Data Modelling; Data warehousing; SQL Server Management Studio; SQL Server Integration Services; SQL Server Analysis Services; Microsoft Excel; Microsoft Access; Microsoft Visio; Microsoft SharePoint 2007. Microsoft SQL Server 2012/2014; HP Vertica; Amazon Redshift; Pentaho
• Installed/reviewed Configuration/Administration; Pentaho Deployments; Pentaho BI Suite; Pentaho PDI; BI Tools, Business Objects; Team Foundation Server; Erwin; TOAD for Oracle; Created visual displays for data analysis and presentation of big data deployments.
• Helped clients with BI and data integration solutions to ensure each client's long term success. Designed and implemented BI and data integration solutions using development methodologies. Helped clients and staff with training in the use of product features. Researched and resolved installation, configuration, deployment and new/ upgrade issues; worked as an advocate for customer and liaison to Engineering, Product Management and Support organizations. Worked in Enterprise Architects with the designing, development, integration, performance tuning, roll-out, support and optimization of customer implementations of products.
• Implemented business intelligence and data integration tools including Informatica, Datastage, Talend and development processes such as dimensional modeling. Worked with ER-modeling, dimensional modeling and data vault, web and database application development tools, standards and languages such as SQL, MDX, XML, Java, JavaScript and HTML. Worked with core infrastructure technologies including Windows and application servers such as WebSphere, WebLogic. Worked with relational databases such as Oracle, MySQL, PostgreSQL, SQL Server and column store databases such as Vertica, Microsoft Active Directory, BI/data integration tools including Pentaho,Business Objects, Cognos, Microsoft, Microstrategy, and Oracle. Created Predictive Modeling. Worked with data mining using R. Provided training in data integration and business intelligence concepts and proper usage of DI and BA toolsets to clients and their staff by demonstrating products, technical benefits and integration points.
• Worked with Trizetto, Meditech, EPIC, and Cerner Healthcare analytics with a wide and deep understanding of Healthcare data working in clinical, financial and population health systems working in designing new analytical assets.
• Worked with hospital and clinical workflows working in a fast-paced environment and innovating new processes
• Worked with SQLqueries, BI and reporting writing tools such as SSRS, Crystal and Tableau.
• Worked with business end users and customer IT personnel to elicit and clarify detailed data requirements to support analysis use cases.
• Worked directly with front line clinicians to design and building BI reports and SQL queries and dashboards
• Familiarity with healthcare industry code sets RXNORM, SNOMED, CPT, ICD-9, ICD-10, PQRS,
• Experience working with healthcare data from IT systems such as Epic, Cerner, MediTech, Allscripts, Eclipsys, Sunrise, TouchWorks, McKesson Paragon, Horizon, Siemens Soarian, SMS Invision
• I worked in a innovative and collaborative team/work environments, am able to communicate effectively with clients' users and internal developers, am flexible and adaptable to changes to process. Am willing to learn new topics and create new analytics.
• Expertise in healthcare data domains clinical, claims, billing, labs, surgeries,
• Worked with data in healthcare IT systems including Epic, Cerner, Allscripts, McKesson etc.

Confidential

EPIC FACETS HEALTHCARE SOLUTIONS ARCHITECT/DEVELOPER/ANALYST

• Experienced working in MS-SQL, Oracle OIM & CACHE database systems
• Lead/supported Oracle & MS-SQL/CACHE database with operational, troubleshooting, management and administration
• Experienced working in Disaster Recovery Test & Exercises for Database Recovery
• Worked in planning & deployment of Patch & Upgrades on Database systems
• Worked in the development, testing, documentation and integration of databases and user interface software products
• Worked in Proactive Performance & Capacity Analysis of Database infrastructure and provided recommendations to customers
• Worked in configuring Database objects including tables, clusters, indexes, views, sequences, packages and procedures
• Able to work with application developers, system and storage administrators to optimize Database Configurations
• Configured Database encryption and security parameters
• Worked in configuring clustered databases as required using technologies such as Oracle & SQL Server clusters
• Evaluated Database Configurations and provided recommendations for improvement & executed upon approval
• Assisted in application development in the logical design of databases
• Participated in New Project/application development design sessions and provided Database design recommendations
• Implemented Database archive processes and procedures
• Experienced working in healthcare Industry and comply with HIPAA/PHI regulations
• Experienced in ITIL v3 processes
• Served as an escalation point for all database related incidents to customer
• Monitored Database logging systems including Database lock errors and troubleshoot causesExtensive working experience as IT auditor, data analyst, using MS SQL, EMR and EPIC, MS SQL Server 2005 / 2008, R2 Database Administration Server installation, configuration, upgrade Building different environments, Replication, Performance tuning, optimization, backup/restore, recovery, migration, monitoring, Security planning and trouble-shooting.  
• Designed, worked on Development in production environment, System analysis, DB environments and establish good procedures, Implement, troubleshoot, maintain compliance with HR, HIPPA, SOX, HEDIS, Medicare, State, Federal, and county standards. Analyze data to achieve desired business results, ensure federal, state, local laws, collective bargaining agreements and corporate HR-related compliance matters are proactively managed.
• Conducted auditing and reconciliation of monthly encounter submission counts from IT to Clearinghouses, coordinated and performed corrections to encounter data rejects.
• Epic Clarity, HIM, Tapestry, and Epic Care Ambulatory data was used to monitor production, claims processing, auditing, patient information, reporting, MS SQL, R, SAS, ACCESS, Sharepoint, JAVA. Worked within a healthcare/financial and IT setting with large databases, Data Quality Assurance team to ensure the delivery of products and services to clients, through the operational processing of various systems.
• Database systems such as MY SQL, SQL DBA, SQL Server expert was used to execute DBA operational responsibilities to proactively guarantee availability and performance, delivered new services and systems, and to resolve any production issues.
• Platforms such as Random Forest, Machine Learning, Big Data, Python, Matlab/R, and SAS.Partner with physicians, hospitals, clinics, finance, marketing and data sciences were used to support their specific database-related requirements.
• Designed, created data architect models, implemented and built scalable databases in virtual and physical environments, worked with RDBMS and SQL database technologies, database designs, modeling and architecture, monitoring/troubleshooting, capacity planning and performance tuning
• Created query design for optimization using SQL, Oracle, and used Ruby framework for developing database-backed web applications and ETL for gathering information, data analysis, and reporting. Worked with T-SQL and SQL Server in creating database objects, performing complex queries, tables, views, joins, functions, and stored procedure development, migrating data files and reports built in SQL 2008 to SQL 2012, then adding new functionality to the environment.
• Database such as MongoDB, and Cassandra, SQL, Oracle were used for various projects. Provided data element naming consistent with standards and conventions, ensures data dictionaries are maintained. Development Methodologies, Databases Platforms, Oracle/ SQL Server, expertise in Data Modeling tools (ERWin/ Model Manager), work with Relational Data Models (conceptual, logical and physical data models), Dimensional Data Models, Data Dictionary and Metadata, As a
• As a Financial/Data Analyst I provided ad-hoc reporting/decision support for internal and external clients; supported forecasting and budgeting processes; consolidated and managed data sources; data integrity company-wide; and created, monitoring and reporting.
• Used business intelligence, reporting and financial planning systems to analyze data using SQL, PLSQL, NoSQL, Excel, BI platforms. Worked with SQL database, queries, data analyst.
• Followed Medicare, CMS guidelines for projects, used EMR data to generate report, including Epic Systems, Cerner, E-Clinical Works, Allscripts, McKsson
• SSAS, SSIS, SSRS were used for data integration and for reporting, clinical data, data mapping, Hadoop MapReduce was used for big data projects, Use of HR Analytics to create predictive modeling for forecasting, designing, build dashboard flows.
• Ensured health plan encounter data meet industry and individual health plan requirements, interpret encounter data to identify issues, trends, support department projects/tasks, analyze, audit, and conduct research of lab results, patient information, Healthcare medical claims data analysis/architect
• Created Technical Design Document and Create Source to Target transformations mapping/ Data Dictionary Develop, test and deploy data pipelines reporting dashboards. Various data integration tools were used to prepare and blend data to create picture of business data into actionable insights to end users from variety of sources.