Experience

LiveData, Inc.

• United States
• Software Development
• 1 - 100 Employee

• Senior Analytics Developer

  • Jan 2022 - Present



Change Healthcare

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Software Engineer

  • Nov 2013 - Jan 2022

  * Technical project lead on replacement of IBM Medical Episode Grouper (MEG) with Change Healthcare (CHC) owned Prometheus Analytics engine. * Leading role in multi-server (50+) migration from a physical data center to AWS cloud environment. Performed capacity planning, data migration scheduling, regression and performance testing, bug and incompatibility fixing, direct work with end users as well as with external clients. * Design and development of the ETL for the patient risk score conversion project from Cotivity DxCG Intelligence engine to Johns Hopkins ACG system. * Major custom client work that allowed to process direct raw data feeds, winning away data conversion business from 3rd party company. The project corrected multiple data errors, reduced processing time by the factor of 8. * Complete redesign/rewrite of a proprietary Primary Care Physician Attribution engine (about 20 times performance increase). * Development of stored procedures (SQL Server) to support client incoming feed file handling and status reporting. Performance tuning of multiple existing stored procedures. Automation of multiple previously manual processes. * Design and implementation of customer facing as well as internal reports (SSRS, SQL Server) to monitor feed file processing. Development of SLA compliance reports. Show less



Fidelity Investments

• United States
• Financial Services
• 700 & Above Employee

• Principal Software Engineer/Developer

  • Jun 2005 - Sep 2013

  Fund Performance and Oversight Technology Lead designer/developer. * Design and development of database and calculation engine for portfolio manager compensation (Oracle, PL/SQL, Sybase). Implementation data barriers for sensitive information (Oracle VPD). * Design and implementation of mutual fund and market index total return and risk calculation engines (Oracle, PL/SQL). * Design of data warehouse to store mutual fund information (Oracle) provided by third-party data vendors like Morningstar, Lipper, iMoneyNet, Paltrak, Micropal, eVestment Alliance. * Design and implementation of internal Sybase-to-Oracle data replication/synchronization system based on Oracle Gateway product, materialized views and custom access methods (pipelined functions). * Development of in-house template based reporting system by combining and enhancing public Perl modules: GD, PDF:API2 and PDF:Table. * Design and implementation of enterprise-wide management reports suite to provide top management with aggregated portfolio relative and competitive performance data (Oracle, PL/SQL, Sybase, Perl PDF). Show less



Fidelity Investments

• United States
• Financial Services
• 700 & Above Employee

• Principal Consultant Software Developer

  • 2002 - 2005

  Strategic Advisers TechnologyLead back-end and front-end developer.* Migration of legacy C-based account Trade Recommendation Engine to Sybase SQL* Leading database role in a major re-work of Strategic Advisers Investment Management environment (Sybase SQL). Design and developed semi-automated testing tools that allowed easy access to both user acceptance and regression testing results (Java, using JUnit framework, JSP, Struts).* Design and development of Strategic Advisers communication website (ASP, JavaScript, VB Script, VB6, XML, XSLT). Show less

• Principal Consultant Software Developer

  • 1999 - 2002

  Global Performance and Data DistributionLeading technical role on major international data warehouse design and development.* Data modeling, design and development of a new cross-department warehouse to store mutual fund reference, performance, risk, holdings and assets data (Perl, Sybase SQL).* Designed and developed generic ETL solution (Perl) that allowed the processing of feed files by bulding templates rather than writing separate loader programs.* Data modeling, design and development of a new Fidelity International reporting database (Sybase). Developed multiple tables, stored procedures and loaders (SQL, Perl).* Design and development of Fidelity International communication website (ASP, JavaScript, VB Script, VB6, XML, XSLT).* Analysis and implementation of international mutual fund marketing composites based on standard AIMR/GIPS calculations (SQL, Perl) involving dynamic run-time PDF report creation and multi-currency conversion (XML, XSLT, FOP). Show less