Experience

Monogram

• United States
• Financial Services
• 1 - 100 Employee

• Leading Developer, SQL Server

  • Jan 2015 - Jan 2017

  - Process Automation: Proposed and implemented a framework for conversion of the manual functionality into the processes executed automatically based on data dependencies. Conducted conversion of a number of manual processes. - New data sources: Designed and implemented schemas and supporting functionality for a number of new data sources. - Expanded existing rules engine to accommodate new data types. - Process Automation: Proposed and implemented a framework for conversion of the manual functionality into the processes executed automatically based on data dependencies. Conducted conversion of a number of manual processes. - New data sources: Designed and implemented schemas and supporting functionality for a number of new data sources. - Expanded existing rules engine to accommodate new data types.



Genzeon Corporation (contract in AllScripts)

• Burlington, MA

• Contractor

  • Jun 2014 - Nov 2014

  SQL Server 2012, TFS, Visual Studio 2010, Agile, healthcare analytics • Proposed and implemented changes in metadata structure and processing SQL Server 2012, TFS, Visual Studio 2010, Agile, healthcare analytics • Proposed and implemented changes in metadata structure and processing



TriZetto Healthcare Products

• IT Services and IT Consulting
• 700 & Above Employee

• Sr. Database Engineer

  • Jul 2013 - Apr 2014

  Product stabilization (SQL Server 2008R2, T-SQL, SSIS, TFS, Agile): o Studied and documented product’s data flow. o Made proposals regarding improvement of data quality and architecture o Fixed a number of existing issues Product stabilization (SQL Server 2008R2, T-SQL, SSIS, TFS, Agile): o Studied and documented product’s data flow. o Made proposals regarding improvement of data quality and architecture o Fixed a number of existing issues



Rival

• United States
• Software Development
• 1 - 100 Employee

• Database Architect/Developer

  • Mar 2012 - Mar 2013

  Designed and implemented back-end (DB schema, stored procedures, functions, triggers, SQL Server 2005/2008) for Point (OLTP application for Human Resources evaluating employee’s influence) and provided data integration with the existing company products. Resulting functionality included: o Support for multiple user groups (group creation, join/leave group activities, etc.). o Posting and cross-posting various types of documents into the groups and user’s activities related to these… Show more Designed and implemented back-end (DB schema, stored procedures, functions, triggers, SQL Server 2005/2008) for Point (OLTP application for Human Resources evaluating employee’s influence) and provided data integration with the existing company products. Resulting functionality included: o Support for multiple user groups (group creation, join/leave group activities, etc.). o Posting and cross-posting various types of documents into the groups and user’s activities related to these postings (various types of document’s evaluation). o Computation of influence based on combination of the ‘tags’ (subject definitions) and activities related to the posted documents. o Support for various types of data output functionality (‘magazine’, ‘notebook’, ‘wall’, ‘search’, etc.). o Created and maintained data dictionary. Show less Designed and implemented back-end (DB schema, stored procedures, functions, triggers, SQL Server 2005/2008) for Point (OLTP application for Human Resources evaluating employee’s influence) and provided data integration with the existing company products. Resulting functionality included: o Support for multiple user groups (group creation, join/leave group activities, etc.). o Posting and cross-posting various types of documents into the groups and user’s activities related to these… Show more Designed and implemented back-end (DB schema, stored procedures, functions, triggers, SQL Server 2005/2008) for Point (OLTP application for Human Resources evaluating employee’s influence) and provided data integration with the existing company products. Resulting functionality included: o Support for multiple user groups (group creation, join/leave group activities, etc.). o Posting and cross-posting various types of documents into the groups and user’s activities related to these postings (various types of document’s evaluation). o Computation of influence based on combination of the ‘tags’ (subject definitions) and activities related to the posted documents. o Support for various types of data output functionality (‘magazine’, ‘notebook’, ‘wall’, ‘search’, etc.). o Created and maintained data dictionary. Show less



HP/Healthways/QuitNet

• Architect/Developer Database and Data Analytics

  • Jul 2005 - Apr 2012

  Design and implementation of Reporting/Data Analytics functionality. Assessment and redesign of OLTP and OLAP databases functionality. ETL implementation. Creation of BI support platform. Supervision of the system engineering staff in the area of database development. Data coordination and integration within QuitNet and with another business units. Data Management (data dictionary, data linkage, data integration) Analysis of the requirements from clients and Account… Show more Design and implementation of Reporting/Data Analytics functionality. Assessment and redesign of OLTP and OLAP databases functionality. ETL implementation. Creation of BI support platform. Supervision of the system engineering staff in the area of database development. Data coordination and integration within QuitNet and with another business units. Data Management (data dictionary, data linkage, data integration) Analysis of the requirements from clients and Account Managers; development of the functional specifications and plans of implementation. Achievements: Designed and implemented data warehouse (SQL Server 2005, T-SQL, SSIS, SSRS, SSAS). Created automatically functioning reporting environment based on SSRS: - Created brand-new subsystems to provide monthly reporting for Q-Comp and Quitline clients: study of the competitor's reporting systems and clients' requirements, definition of the reporting functionality, design and implementation of presentation level, supporting database structure and report-generating functionality, data collection and processing (T-SQL, SSRS, SSIS). - Created BI-supporting platform: dashboard, KPI, drill-down and flexible time interval reports, SQL level support for data analysis - numerous ad-hoc reports and data extractions, creation of user-friendly SQL-level platform for data analysis (SSRS/SSAS/T-SQL/OLAP cubes). Functionality had been used by QuitNet accounting, marketing, product management and business analysts. Improved stability of QuitNet site by streamlining data transfer processes on Production Server and transfer of the long-term data storage to data warehouse. Implemented ETL functionality (SSIS) for an automated data transfer from Production to data warehouse. Conducted transition from SQL Server 2000 to SQL Server 2005 (switch from DTS to SSIS) Conducted audits of the production databases: removal of the stale data, re-indexing, creation of the scheduled packages for indexes de-fragmentation, etc Show less Design and implementation of Reporting/Data Analytics functionality. Assessment and redesign of OLTP and OLAP databases functionality. ETL implementation. Creation of BI support platform. Supervision of the system engineering staff in the area of database development. Data coordination and integration within QuitNet and with another business units. Data Management (data dictionary, data linkage, data integration) Analysis of the requirements from clients and Account… Show more Design and implementation of Reporting/Data Analytics functionality. Assessment and redesign of OLTP and OLAP databases functionality. ETL implementation. Creation of BI support platform. Supervision of the system engineering staff in the area of database development. Data coordination and integration within QuitNet and with another business units. Data Management (data dictionary, data linkage, data integration) Analysis of the requirements from clients and Account Managers; development of the functional specifications and plans of implementation. Achievements: Designed and implemented data warehouse (SQL Server 2005, T-SQL, SSIS, SSRS, SSAS). Created automatically functioning reporting environment based on SSRS: - Created brand-new subsystems to provide monthly reporting for Q-Comp and Quitline clients: study of the competitor's reporting systems and clients' requirements, definition of the reporting functionality, design and implementation of presentation level, supporting database structure and report-generating functionality, data collection and processing (T-SQL, SSRS, SSIS). - Created BI-supporting platform: dashboard, KPI, drill-down and flexible time interval reports, SQL level support for data analysis - numerous ad-hoc reports and data extractions, creation of user-friendly SQL-level platform for data analysis (SSRS/SSAS/T-SQL/OLAP cubes). Functionality had been used by QuitNet accounting, marketing, product management and business analysts. Improved stability of QuitNet site by streamlining data transfer processes on Production Server and transfer of the long-term data storage to data warehouse. Implemented ETL functionality (SSIS) for an automated data transfer from Production to data warehouse. Conducted transition from SQL Server 2000 to SQL Server 2005 (switch from DTS to SSIS) Conducted audits of the production databases: removal of the stale data, re-indexing, creation of the scheduled packages for indexes de-fragmentation, etc Show less



TNCI

• Programmer Analyst III/Data Warehouse Architect

  • Aug 2004 - Jun 2005

  Responsible for design and development of company's data warehouse and Decision Support System (SQL Server 2000, MS DTS, T-SQL, Business Objects/Crystal Reports, MS Data Analyzer, Excel, MS Analysis Services, stored procedures): Conducted analysis of the functional requirements and data sources. Worked closely with various groups such as finance, product and account managers, to understand their requirements and translate these needs into design. Along each of the steps, documented findings,… Show more Responsible for design and development of company's data warehouse and Decision Support System (SQL Server 2000, MS DTS, T-SQL, Business Objects/Crystal Reports, MS Data Analyzer, Excel, MS Analysis Services, stored procedures): Conducted analysis of the functional requirements and data sources. Worked closely with various groups such as finance, product and account managers, to understand their requirements and translate these needs into design. Along each of the steps, documented findings, reviewed them with users and supervisor, and provided feedback on the issues (bad data, options of implementation) to the appropriate resource. Designed and implemented data warehouse architecture including database schemas, data conversion and storage functionality, ETL (data feed from the production servers and export to web-based Portal server) based on MS DTS and stored procedures, functionality for automatic execution and synchronization of the periodic processes. Created automatically functioning reporting subsystem for the daily and monthly reports. Implemented report templates (Crystal Reports) for deployment on Portal server (as a part of the client interface) and provided access for the internal users through Excel. Implemented BI-supporting platform for company's Finance, Product, AMS and Sales departments (subsystems for Calls rating, Carriers data evaluation, Customers churn, Travel Card Analysis, Revenue by Product, AMS Billing). Designed and built OLAP cubes for Finance Usage and MRC, AMS Billing, Travel Card Usage and Fraud Analysis, Product MRC and organized access through MS Data Analyzer and Pivot Table functionality. Implemented procedures to calculate estimated monthly usage data on Agent Portal subsystem and helped to design a database schema for reporting component of this subsystem. Implemented ad hoc reports. Provided data warehouse deployment, performance tuning and maintenance. Show less Responsible for design and development of company's data warehouse and Decision Support System (SQL Server 2000, MS DTS, T-SQL, Business Objects/Crystal Reports, MS Data Analyzer, Excel, MS Analysis Services, stored procedures): Conducted analysis of the functional requirements and data sources. Worked closely with various groups such as finance, product and account managers, to understand their requirements and translate these needs into design. Along each of the steps, documented findings,… Show more Responsible for design and development of company's data warehouse and Decision Support System (SQL Server 2000, MS DTS, T-SQL, Business Objects/Crystal Reports, MS Data Analyzer, Excel, MS Analysis Services, stored procedures): Conducted analysis of the functional requirements and data sources. Worked closely with various groups such as finance, product and account managers, to understand their requirements and translate these needs into design. Along each of the steps, documented findings, reviewed them with users and supervisor, and provided feedback on the issues (bad data, options of implementation) to the appropriate resource. Designed and implemented data warehouse architecture including database schemas, data conversion and storage functionality, ETL (data feed from the production servers and export to web-based Portal server) based on MS DTS and stored procedures, functionality for automatic execution and synchronization of the periodic processes. Created automatically functioning reporting subsystem for the daily and monthly reports. Implemented report templates (Crystal Reports) for deployment on Portal server (as a part of the client interface) and provided access for the internal users through Excel. Implemented BI-supporting platform for company's Finance, Product, AMS and Sales departments (subsystems for Calls rating, Carriers data evaluation, Customers churn, Travel Card Analysis, Revenue by Product, AMS Billing). Designed and built OLAP cubes for Finance Usage and MRC, AMS Billing, Travel Card Usage and Fraud Analysis, Product MRC and organized access through MS Data Analyzer and Pivot Table functionality. Implemented procedures to calculate estimated monthly usage data on Agent Portal subsystem and helped to design a database schema for reporting component of this subsystem. Implemented ad hoc reports. Provided data warehouse deployment, performance tuning and maintenance. Show less



Gemis Technologies

• Principal Database Engineer

  • Jan 2003 - Dec 2003

  Designed and implemented databases for a number of projects related to ceramic metallization process (SQL Server 2000, T-SQL, stored procedures, MS DTS). Designed and implemented databases for a number of projects related to ceramic metallization process (SQL Server 2000, T-SQL, stored procedures, MS DTS).



GrandVirtual

• Principal Database Engineer

  • Mar 2002 - Sep 2002

  Designed and implemented data marts for financial and marketing analysis (SQL Server 2000, MS Enterprise Manager): • Worked in close contact with company management, marketing and sales departments to define BI functionality and database content. Prepared functional and design specifications. • Designed and implemented general architecture, data models for the staging database and OLAP cubes, DB schemas. • Implemented ETL functionality for converting and loading data from the multiple… Show more Designed and implemented data marts for financial and marketing analysis (SQL Server 2000, MS Enterprise Manager): • Worked in close contact with company management, marketing and sales departments to define BI functionality and database content. Prepared functional and design specifications. • Designed and implemented general architecture, data models for the staging database and OLAP cubes, DB schemas. • Implemented ETL functionality for converting and loading data from the multiple OLTP databases (MySQL, Informix) into data mart. • Created DSS based on OLAP cubes for data analysis and data mining (MS Data Analysis Services), reports (Excel) and data presentation based on MS Data Analyzer. Provided users training. Show less Designed and implemented data marts for financial and marketing analysis (SQL Server 2000, MS Enterprise Manager): • Worked in close contact with company management, marketing and sales departments to define BI functionality and database content. Prepared functional and design specifications. • Designed and implemented general architecture, data models for the staging database and OLAP cubes, DB schemas. • Implemented ETL functionality for converting and loading data from the multiple… Show more Designed and implemented data marts for financial and marketing analysis (SQL Server 2000, MS Enterprise Manager): • Worked in close contact with company management, marketing and sales departments to define BI functionality and database content. Prepared functional and design specifications. • Designed and implemented general architecture, data models for the staging database and OLAP cubes, DB schemas. • Implemented ETL functionality for converting and loading data from the multiple OLTP databases (MySQL, Informix) into data mart. • Created DSS based on OLAP cubes for data analysis and data mining (MS Data Analysis Services), reports (Excel) and data presentation based on MS Data Analyzer. Provided users training. Show less



GTE/Verizon

• Telecommunications
• 1 - 100 Employee

• Principal Member of Technical Staff/Data warehouse Architect

  • May 1997 - Sep 2001

  Architect of the DART ("Data Aggregation and Reporting Technologies") project: development of a data warehouse for long-term (up to 2 years, up to 2 Terabytes) storage of the process status data collected from the multiple production databases (C++, Oracle, Informix, PL/SQL, ESQL/C, Pro*C, Oracle Designer, Oracle Warehouse Builder, Visio, UNIX); Conducted analysis of the client's requirements, prepared functional specifications and test plan. Participated in 'NeMOW' project (management… Show more Architect of the DART ("Data Aggregation and Reporting Technologies") project: development of a data warehouse for long-term (up to 2 years, up to 2 Terabytes) storage of the process status data collected from the multiple production databases (C++, Oracle, Informix, PL/SQL, ESQL/C, Pro*C, Oracle Designer, Oracle Warehouse Builder, Visio, UNIX); Conducted analysis of the client's requirements, prepared functional specifications and test plan. Participated in 'NeMOW' project (management of the net elements). Responsible for design and development of the back-end functionality integration with the data acquisition system (TONICS): (ESQL, C++, CORBA IDL). Participated in 'VECTOR' project - evaluation of the EAI products (messaging systems, process integrators, workflow, and security management systems) used by Verizon affiliates. Responsibilities included products technical reviews, evaluations and presentations, development of the assessment methodology, preparation of the questionnaires, interviews with the vendors and users and software trials. Show less Architect of the DART ("Data Aggregation and Reporting Technologies") project: development of a data warehouse for long-term (up to 2 years, up to 2 Terabytes) storage of the process status data collected from the multiple production databases (C++, Oracle, Informix, PL/SQL, ESQL/C, Pro*C, Oracle Designer, Oracle Warehouse Builder, Visio, UNIX); Conducted analysis of the client's requirements, prepared functional specifications and test plan. Participated in 'NeMOW' project (management… Show more Architect of the DART ("Data Aggregation and Reporting Technologies") project: development of a data warehouse for long-term (up to 2 years, up to 2 Terabytes) storage of the process status data collected from the multiple production databases (C++, Oracle, Informix, PL/SQL, ESQL/C, Pro*C, Oracle Designer, Oracle Warehouse Builder, Visio, UNIX); Conducted analysis of the client's requirements, prepared functional specifications and test plan. Participated in 'NeMOW' project (management of the net elements). Responsible for design and development of the back-end functionality integration with the data acquisition system (TONICS): (ESQL, C++, CORBA IDL). Participated in 'VECTOR' project - evaluation of the EAI products (messaging systems, process integrators, workflow, and security management systems) used by Verizon affiliates. Responsibilities included products technical reviews, evaluations and presentations, development of the assessment methodology, preparation of the questionnaires, interviews with the vendors and users and software trials. Show less



Xerox

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

• Senior Member of Technical Staff

  • Aug 1994 - Apr 1997

  Participated in the development of InConcert (a workflow management system, now TIBCO/InConcert): Participated in product internationalization. Ported InConcert on Oracle 7 (Pro*C, PL/SQL). Made improvements in InConcert database access level (Sybase, Oracle, UNIX). Participated in the product releases, system testing and troubleshooting. Participated in design and development of the in-process OLE Automation Server (VB, VC++, SQL Server). Participated in the development of InConcert (a workflow management system, now TIBCO/InConcert): Participated in product internationalization. Ported InConcert on Oracle 7 (Pro*C, PL/SQL). Made improvements in InConcert database access level (Sybase, Oracle, UNIX). Participated in the product releases, system testing and troubleshooting. Participated in design and development of the in-process OLE Automation Server (VB, VC++, SQL Server).



Information Resources, Inc

• Senior Software Engineer

  • Jun 1990 - Aug 1994

  Participated in design and development of IRI EXPRESS (now ORACLE EXPRESS): Designed and implemented EXPRESS interfaces with Oracle (6 and 7), Sybase (4 and 10), SQL Server, and ODBC on various UNIX platforms, Windows, and MS-DOS (Oracle OCI, Pro*C, Sybase db-Library), expanded EXPESS SQL engine to accommodate extended SQL functionality (stored procedures, dynamic queries). Acted as project DBA. Provided new installations (Oracle, Sybase, SQL Server), upgrades to the new versions… Show more Participated in design and development of IRI EXPRESS (now ORACLE EXPRESS): Designed and implemented EXPRESS interfaces with Oracle (6 and 7), Sybase (4 and 10), SQL Server, and ODBC on various UNIX platforms, Windows, and MS-DOS (Oracle OCI, Pro*C, Sybase db-Library), expanded EXPESS SQL engine to accommodate extended SQL functionality (stored procedures, dynamic queries). Acted as project DBA. Provided new installations (Oracle, Sybase, SQL Server), upgrades to the new versions, backup-recovery, users management. Show less Participated in design and development of IRI EXPRESS (now ORACLE EXPRESS): Designed and implemented EXPRESS interfaces with Oracle (6 and 7), Sybase (4 and 10), SQL Server, and ODBC on various UNIX platforms, Windows, and MS-DOS (Oracle OCI, Pro*C, Sybase db-Library), expanded EXPESS SQL engine to accommodate extended SQL functionality (stored procedures, dynamic queries). Acted as project DBA. Provided new installations (Oracle, Sybase, SQL Server), upgrades to the new versions… Show more Participated in design and development of IRI EXPRESS (now ORACLE EXPRESS): Designed and implemented EXPRESS interfaces with Oracle (6 and 7), Sybase (4 and 10), SQL Server, and ODBC on various UNIX platforms, Windows, and MS-DOS (Oracle OCI, Pro*C, Sybase db-Library), expanded EXPESS SQL engine to accommodate extended SQL functionality (stored procedures, dynamic queries). Acted as project DBA. Provided new installations (Oracle, Sybase, SQL Server), upgrades to the new versions, backup-recovery, users management. Show less



Institute of Mini- and

• Leading Software Engineer

  • Jan 1984 - Jan 1989

  Research and development in the area of databases/OLTP in the distributed information systems: data modeling, software design and development. Research and development in the area of databases/OLTP in the distributed information systems: data modeling, software design and development.