Natalia Khomchenko

Contact info:

adj15n@r.postjobfree.com

703-***-****

LinkedIn: https://www.linkedin.com/in/natalia-khomchenko-a647851a/

Summary

Databases: MS SQL Server, Sybase IQ, MS Access.

Data Visualization tools: Tableau, Power BI, SAP Lumira

Reporting services: SAP Business Objects: Webi Rich Client/SAP Crystal Reports/ Desktop Intelligence, SAS, SSRS, Cognos

ETL systems: SSIS, Tableau Prep, Alteryx Designer

Programming Languages: SAS, Python, C#, JavaScript, VB

Medical data analysis (Medicare/Medicaid)

Data cleansing and validating

Requirement gathering, technical writing

Certification: Tableau Specialist

Experience

Weems Design Studio, Inc., Suwanee, Georgia

Location: Washington D.C. Metro Area

Lead BI Developer

Sep 2018 – Present

• Building reports and dashboards within USDA reporting project.

• Gathering initial requirements from the client and converting them into suitable algorithm.

• SQL code optimization, analyzing query execution plan for performance tuning.

• Developing, updating and troubleshooting complex Business Objects reports in Webi Rich Client and SAP Crystal Reports using drill-down, cross tables, variables/parameters/formulas, input controls, filters, sorting, ranking, hidden elements, conditional formatting, hyperlinks, merging, graphs, and diagrams.

• Designing and supporting single and multi-sourced Business Objects Universes with Universe Designer and Information Design Tool.

• Converting BO Universes from UNV to UNX format, designing Business Layer views and user security profiles.

Relinking UNV Webi Rich client reports to UNX Universes with the following Unit and Performance testing. Resolving issues and reformatting problematic reports when needed.

• Checking Universe integrity, revealing loops, chasm/fan traps and performance issues.

Promoting reports/Universes between working environments and scheduling for execution.

• Creating reusable data sources with live data and data extracts in Tableau Prep.

• Designing worksheets and dashboards in Tableau Desktop, using action filters, parameters, LOD expressions and table calculations.

• Blending, joining and filtering data in Tableau Desktop.

• Adding custom elements into Tableau workbooks: static and dynamic sets, context and quick filters, groups, hierarchies, and parameters.

• Publishing dashboards in Tableau Server.

• Designing Power BI dashboards inserting visuals and editing reports interactions. Maintaining drill-through/cross reports and filters on visual, page and report level.

• Applying DAX formulas, conditional and logical functions in Power BI, calculating, joining and filtering data with Power Query.

• Publishing reports in Power BI Service and SharePoint portal.

• Analyzing and evaluating Power BI Queries in DAX Studio.

• Adding custom visuals in Power BI using Python libraries.

• Writing white paper reports, presentations, standard operational procedures, instructions, plans and other documentation.

FEI Systems, Columbia, MD

Location: Washington D.C. Metro Area

Report Developer

Nov 2011 – Sep 2018

•Worked as a government contractor for USDA Business Objects reporting project. Developed complex BO reports/dashboards/stories with multiple data sources.

•Built and updated stored procedures for relative data sets.

•Maintained data, creating data models, table relationships, key directions and cardinalities.

•Converted custom SAS reports into required format, emulating SAS Proc SQL, Proc report, ODS statements and etc. Components used: SAS Enterprise Guide, SAS Studio and Base SAS.

•Tuned data performance, estimated query execution plan cost.

•Designed and supported Business Objects Universes against SQL Server 2014 and Sybase IQ data utilizing Information Design Tool and Universe Designer.

•Applied Security on Universe level to restrict data access based on user group.

•Maintained quality control and load/stress /unit/security testing and resolved related issues.

•Migrated/promoted reports/universes between various environments and scheduled for execution.

•Collaborated with the client on team meetings, training sessions and calls. Discussed current issues, report requirements, and potential improvements.

•Designing reports and dashboards using SAP Web Intelligence rich Client, Crystal reports and SAP Lumira Designer .

•Designed reports and dashboards for different projects using SSRS and MS Power BI.

•Applied DAX formulas, transformed Power BI data, analyzing M formulas in advanced editor.

•Analyzed and evaluated Power BI Queries in DAX Studio.

•Added custom visuals, such as categorical, distribution and matrix plots in Power BI using Python libraries.

Integrity Management Services, LLC Alexandria, VA

Data Analyst/DBA

Oct 2007 – Nov 2011

•Worked with a multidisciplinary team on Medicare and Medicaid data analysis, identified fraud, waste, and abuse in healthcare claims and provided summary and detailed data for the client

•Built and scheduled detailed summary, drill down and drill through reports in SSRS, SAP Crystal and BO Desktop Intelligence, manipulating Medicare/Medicaid data.

•Designed reusable report templates in Cognos Query Studio across CMS data. Customized reports with calculations, aggregations and filters.

•Formulated ad hoc queries, stored procedures and functions in SQL Server.

•Imported, exported, transformed, manipulated, validated and cleansed data using SQL Server Integration Services (SSIS), bulk insert VB.NET and C# scripts. Performed Fuzzy Grouping, Fuzzy lookup, Merge, Union, Percentage/Row sampling, Conditional Split and other transformations.

•Managed relational databases, built conceptual, physical and logical data models, using MS SQL Server: assigned fields and table names, identity columns, attributes, and constrains, primary and foreign keys.

•Created and monitored SQL Server Agent jobs for database backup/recovery.

•Produced and maintained technical documentation on design, structure, code, and data management. Developed strategies for backup and recovery

•Created VBA user forms in MS Access for data input and handling.

•Developed JavaScript applications for company internal use.

IQ Solutions, Inc. Rockville, MD

Data Analyst

June 2007- Oct 2007

•Analyzed Medicare and Medicaid data, formulating SQL queries to extract, manipulate, format, and present data stored in relational databases

•Built crosstab and list reports in Cognos Query Studio, utilizing report items such as graphs, maps, filters and repeaters.

•Refined database queries to generate subsets of databases and tables (T-SQL)

•Provided maintenance, extraction, and import/export data into various formats

Education:

Siberian Federal University AKA Krasnoyarsk State Technical University (KSTU) / Krasnoyarsk Polytechnic Institute (Russian Federation)

B.S. In Electrical Engineering (Specialty Automation and Telemechanics)

http://www.sfu-kras.ru/en/about

http://en.wikipedia.org/wiki/Siberian_Federal_University

Contact this candidate