SUMMARY:

• 10+ years of full - time database experience with Microsoft SQL Server 2000, 2005, 2008, 2008 R2 and 2012.
• 15+ years of IT experience including hardware, programming and databases .
• 5+ years of management experience as a team lead, supervisor and manager.
• Designed, implemented, maintained and managed the SQL based rule engine that has been generating the majority of the company’s/division’s revenue for the last 9 years (I actually own some of the intellectual property rights on the foundation used by Confidential -SIU's core software).
• Planned and implemented every major feature of Confidential ’s Program Integrity FWA platform.
• Managed all production data for over 60 clients adding up to one terabyte of medical claims.
• Responsible for every single new client implementation between 2004 and 2011.
• Involved in every major database addition & change since being hired 9+ years ago.
• Strong healthcare background, including Medicaid, Medicare, X12 5010 and ICD 10 .
• Extensive knowledge of healthcare Fraud, Waste & Abuse.
• Played the role of a Data Analyst, Data Scientist, Database Administrator (DBA), Database Architect, Database Developer, Database Programmer, Business Analyst and Report Designer.
• Was one of the first Chief Data Officers in the world.
• Obtained several degrees and certificates focusing on databases, data warehousing and data mining .

PROFESSIONAL EXPERIENCE:

Implementation Supervisor/Lead Data Analyst

Confidential

Responsibilities:

• Enabled parallel processing of business rules in order to drastically improve performance.
• Researched products and services, including in-memory databases.
• Synchronized all database code across 60 servers.
• Participated in the design of an operational data store (ODS).
• Designed and implemented a rule engine for prescription claims.
• Added support for dental claims.
• Integrated NCD /LCD into the system.
• Involved in corporate data management initiatives, including EDM and MDM .
• Prototyped score cards for providers.
• Evaluated and integrated 3rd party data sources.
• Reengineered business processes and refactored software to improve efficiency
• Acted as a subject matter expert inside the FWA division.
• Interviewed and trained new employees.
• Programmed additional business rules to enhance the rule engine.
• Helped plan the transition from ICD-9 to ICD-10.
• Assisted in the design, development and integration of corporate systems.
• Added key features and functionality to provide additional services to existing
• Provided key metrics used for billing and ROI purposes.
• Oversaw the processing of over 200 client files per week.
• Managed 10 million business rules for clients in 11 different states.
• Led the conversion from X12 5010 .
• Built several components for mainframe integration.

Database Administration Manager

Confidential

Responsibilities:

• Transitioned Confidential ’s infrastructure onto Confidential ’ corporate systems.
• Added time dependency to key components.
• Improved exception and error handling of all automated processes.
• Implemented more clients in 6 months than in the previous 3 years combined.
• Increased the flexibility and scalability of the database backend by switching

Chief Data Officer

Confidential

Responsibilities:

• Simplified updates and eliminated redundancy by normalizing existing database tables and adding referential integrity .
• Reduced the impact of reporting and ad-hoc querying by separating those functions from the OLTP side using real-time replication .
• Drastically improved database security by utilizing views, stored procedures, functions, triggers, logins, users, and roles.
• Enabled exponential data growth by scaling and tuning the hardware and software as well as extensive performance tuning and query optimization.
• Improved the overall server performance by switching from internal storage to Direct Attached Storage and then to a SAN as well as moving from local commodity hardware to enterprise grade servers in a data center /colocation .
• Utilized the latest features by upgrading all SQL Servers from Microsoft SQL Server 2000 to SQL Server 2005 and then to SQL Server 2008 after defining upgrade paths.
• Reduced human involvement and increased processing speed by automating the extraction, transformation and load ing of data using SQL Server DTS and SSIS .
• Enabled upper management and clients to make better decisions by supplying them with advanced statistics and complex reports utilizing Crystal Reports and SQL Server Reporting Services (SSRS).
• Eliminated hours of downtime every week for 25 concurrent users of an Access application by moving the data from Access to SQL Server to improve reliability and performance.
• Increased data quality using best practices and procedures .
• Saved the company thousands of dollars by programming interfaces for industry standards such as HIPAA X12 .

TECHNICAL SKILLS:

• Access, alternate key, BIDS, big data, Business Intelligence Development Studio, candidate key, composite key, compression, cross join, data mart, data transformation service, data type, data warehouse, database driven application, database management system, DBMS, disaster recovery, DTS, E/R diagram, E/R model, EDM, encryption,
• Enterprise Data Management, ETL, extract - transform - load, federation, foreign key, full text search, function, index, inner join, join, key, left join, LINQ, Management Studio, Master Data Management, MDM, Merge, multi-tenant, MySQL, nested query, normal form, normalization,
• NoSQL, OLTP, online transactional processing, operational data store, Oracle, outer join, query, performance tuning, primary key, Profiler, Query Analyzer, RDBMS, referential integrity, relational database management system, relationship, replication, report, Resource Governor, right join, SCD, slowly changing dimension, SQL, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Management Studio, SQL Server Reporting Services, SSAS, SSIS, SSMS, SSRS, stored procedure, structured query language, subquery, surrogate key, T-SQL, table, transactional structured query language, Transact SQL, trigger, view