Elena (Lena) Koyfman

Studio City, CA *****

ac8hjb@r.postjobfree.com

phone: 323-***-****

With over twenty years of programming experience in database engineering and mathematical background I have developed an In-depth understanding of relational databases. Throughout these years, I have utilized analytical and creative abilities to gather extensive knowledge of healthcare industries, the insurance and financial services and Product Management. I am seeking to utilize my knowledge and experience in an engineering role.

SUMMARY OF QUALIFICATIONS

Software/Programs: Power Shell, Visual Studio 2017, TSQL, MS Excel, VB Script, Assembly Languages, WinSQL, MS Access, SmartOffice, Client Data System

Reporting: SSRS, Crystal Reports, SAP Business Intelligence (BI) solutions,

Business Objects XI (Release 2), Geo Access, Quest Analytics

Database: MS SQL Server 2016/2014/2012/2008 R2/2005/2000, ORACLE 8i/9i,

Adaptive Server Anywhere 9, DB2

Database

Modeling Tools: Visio 2010, ER/Studio 8.5, CA ERwin r7.3

Database Tools: RedGate (SQL Prompt, SQL Compare, SQL Data Compare, SQL Dependency Tracker, SQL Data Generator)

ETL: SSIS, bcp utility.

Version Control: GIT, TFS, CVS, VSS

System: WINDOWS 10/ 7/XP/2000/NT/98/95, OS/MVS

PROFESSIONAL EXPERIENCE

12/2016 – 09/2018 Sr. Database Engineer/ Report Writer/ Business Analysts. United Healthcare Group, Los Angeles, CA (March Vision Care Inc. was Acquired by United Healthcare Group)

Responsibilities included: supporting multiple sprint teams on developing new feature product.

Performed query tuning and table indexing in SQL Server.

Developed complex stored procedures and built optimized SQL codes.

Managed web portal SAP BI reporting solution on daily bases that included publishing Crystal report files, scheduling, monitoring

Tuned SQL Server Stored Procedures to maximize reading/reporting performance.

Performed database codes review before production release for possible performance hit.

Developed and maintained the ETL processes.

Participated in multiple database data conversions which included TSQL coding and SSIS ETL implementations.

Responsibility included producing/developing variety of daily/monthly reports to provide complete figures and statistics to the state authorities (Medicare or Medicaid vision plan) as well as ad-hoc clients’ requests.

Managed monthly Quest Analytics reports by preparing memberships/provider datasets (ETL). Developed and produced Quest Analytics reports.

Implemented the reporting solution on the multiple database servers, which remains on the cloud platform; developed number of permanent reports using SSIS and SSRS. Created varies ad-hoc reports using PowerShell/TSQL with SQLCMD variables.

03/2010 – 12/2016 Sr. Database Developer/Business Analysts. March Vision Care Inc., Los Angeles, CA

Developed a number of very complex reports which included sub-reports, cross-tabs and charts based on MS SQL Server complicated Stored Procedures or queries.

Had many primary roles such as gathering business requirements, producing technical specifications, designing the report structures and finally – developing reports.

I have involved in database tuning and optimization processes. I have improved performance of the stored procedures that were a part of my report building routings. (Improving performance involved - optimizing database schema, adding indexes and re-writing stored procedures etc.)

I concurrently worked on multiple different projects switching priorities based on the management requirements.

As a member of a large report development group, we all worked together in an efficient manor to make monthly/quarterly deliverables on time and meet the management goals and expectations.

Managed web portal reporting solutions as a part of house build-in applications using SSRS and Crystal Report.

Analyzed various database structures to produce required reports.

Gathered business requirements and producing final technical specifications for development teams.

Responsibility included producing variety of daily/monthly reports to provide complete figures and statistics to the state authorities (Medicare or Medicaid vision plan) as well as ad-hoc client’s requests.

Produced use cases based on low level documentation for QA team.

Managed monthly Geo Access and Quest Analytics reports by preparing memberships/provider datasets (ETL). Produced Geo Access and Quest Analytics reports.

Created tables, views and store procedures for reporting purposes.

Tuned SQL report performance.

Converted Crystal reports to SSRS format.

Created and automated Service Level reporting package (over 100 reports) for monthly delivery process.

Performed internal QA processes to deliver a high-end quality final product to the clients.

Created database diagram using Visio 2010 and documentation for database related data.

9/1999-10/2009 CRM Software Reporting Manager. E-Z Data Inc., Pasadena, CA

10 years of experience in Customer Relationship Management (CRM), practice, and agency management solutions. As part of product management team responsible for implementation of on-demand and generic reports across various platforms, including SmartOffice (web-based (mostly java) Oracle/XML CRM Software) and Client Data System (Windows-based Client/Server CRM Software)

Gather business requirements, produce technical specifications and lead report development team to implement on-demand PDF reports to SmartOffice. Reports embedded in CRM solution and made available in core, policy, investment, pending case and group benefit modules based on license availability. SmartOffice provided more than 40 generic reports and over 40 custom, client-requested reports that generated about 30% of SmartOffice client’s revenue

Manage multiple business intelligence projects with offshore development teams

Communicate daily with Project Office, software engineers and QA testers.

Create business / design documentations and workflow specifications for SmartOffice implementation.

Develop business use cases used to create Test Scenarios, Test Cases and Scripts for regression testing.

Improved the test coverage for reports by expanding the test case library 50%.

Implemented Crystal Report development projects including all aspects of project management - from communication with the end user and gathering of report requirements through final delivery and post production support. Use Business Object and Crystal report to produce varies reports that embedded to company CRM solution and provided complete contact and contact’s holdings information.

Manage the daily maintenance and uptime of internal testing Crystal Report and Business Object XI servers.

Troubleshoot and analyze report data.

Compose technical writing for training collateral - reporting user guide, technical solution walkthroughs, document best practices.

Develop Excel templates and use Excel as an alternative reporting tool in SmartOffice.

Use Reporting Services and SQL Server to deliver monthly reports to various departments ranging from software sales tracking to number of licenses and conversions.

Solid know-how of financial services and insurance industry through consolidated financial and policy reports.

02/1995 – 05/1999 Application Programmer. Wolfson Inc., Los Angeles, CA

Participated in development of standalone desktop applications and utilities by using MS Access and MS SQL Server.

Crystal reports and Excel development.

Performing design and development of reporting modules and components: report files, report tables, procedures.

Was involved in development of several DTS packages.

04/1990 – 02/1994 Application Programmer.

Design office of NPO “Impuls”, St. Petersburg, Russia.

Participated in coding; testing and debugging of company-used Control-Measurement Systems for chips and microelements.

Was responsible for design and implementation of system automation tests, from data entry to programming elements and final test run.

EDUCATION

Peter the Great St. Petersburg Polytechnic University, Russia / St. Petersburg, Russian Federation (Formerly

Leningrad Politechnical Institute).

M.S. in Computer Science.

St. Petersburg Industrial and Economic College, Russia. Mathematician/Programmer

WORK AUTHORIZATION US Citizen

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate