Vitaly Romm
Silver Spring,USA
Summary
At KL Discovery, a global leader in eDiscovery and data recovery solutions, I am a Certified Microsoft Senior SQL Data Warehouse and BI Lead. I have worked in the Healthcare, Insurance and e-commerce domains and have over 20 years of extensive hands-on experience in building out, developing and maintaining Data Warehouses.
I specialize in on-prem and cloud-based data architecture and development, ETL/ELT integrations and complex data migrations. I also have extensive experience in business intelligence reporting and a strong background in performance analytics in the Power BI ecosystem.
Overview
30
30
years of professional experience
1
1
Certification
Work History
Senior Data Warehouse BI Lead/Architect
KL Discovery
10.2018 - Current
- BI lead and architect on the Enterprise Financial Data Warehouse project. Designed, developed, and deployed the KL Discovery star schema Data Warehouse which is used for all Power BI and SSRS reporting dashboards along with data integrations from Salesforce, Microsoft Dynamics 365 and Oracle integration cloud.
- Built automated configuration driven SSIS packages for all types of ETL data integrations. Migrated and deployed SSIS packages to Azure.
- Developed extensive cloud-based data pipelines and data flows within Azure Data Factory (ADF). Automated data ingestion pipelines to migrate on-premises SQL data to Azure Data Lake Storage.
- Designed and developed Power BI and SSRS reports with row-level security and DAX driven metrics for marketing, sales, accounting, and executive dashboards. Provided reconciliation reports for data migrations, forecasting and trend analysis. Developed strategic KPI reports on performance metrics.
- Created a relational Data Warehouse within BigQuery (GCP) that contained Account, Opportunity, Lead and Product data integrations from Salesforce.
- Worked with a data science team to develop unsupervised and non-generative AI anomaly detection models.
- Worked with GitHub and Microsoft Azure DevOps for version control, testing/release management, pipelines and automated builds.
Senior Data Warehouse BI Lead
CoStar Group
05.2016 - 10.2018
- Designed and developed the CoStar Financial Data Warehouse. The SQL Data Warehouse supplied data for all Power BI dashboards, historical analysis, data load processing and ETL integrations.
- Developed complex import and export SSIS packages that sourced, cleansed and restructured data into multi-staging environments. Used SSIS to manage complex data integration projects.
- Developed and deployed reports with Power BI, SSRS and Oracle OTBI.
- Worked on Master Data Management solutions for customer data that involved standardization, cleansing and consolidating data from multiple sources to ensure data accuracy.
- Worked with data mining tracking patterns, classifications, associations, and clustering.
- Helped manage database backup and recovery, system performance and system monitoring.
Senior Data Warehouse BI Lead
Choice Hotels International, Inc.
11.2015 - 09.2016
- Worked on the Choice A360 data warehouse project for reconciling and managing customer and billing data. Project work involved database design, performance optimization and data analysis.
- Developed SSIS ETL implementation from multiple internal systems along with complex data matching.
- Provided reconciliation reports for data migrations, forecasting and trend analysis.
- Designing SSRS reports for the central reservation system.
- Types of reports: Drill down/Sub-reports/Parameterized/Ad-Hoc
- Wrote functional and technical application documentation.
- Gathered requirements from the business operations team.
Senior SQL ETL/BI Developer
AmerisourceBergen
05.2009 - 10.2015
- Company Overview: Healthcare Services
- Worked as a team leader for both Onshore/Offshore SQL development teams.
- Developed numerous configuration driven SSIS data applications.
- Packages ran imports/exports dynamically on automated schedules for over 100 production data feeds for over 40 different clients.
- Performed hundreds of developer peer reviews and project estimates.
- Worked with SQL Server replication for data synchronization and performance.
- Developed data masking functionality for HIPAA compliant data.
- Worked closely with internal operations, testing teams and clients on functional and technical design of application functionality.
- Developed SSRS reports for external/internal clients.
- Created drilldown/drill-through, parameterized, linked and ad-hoc reports.
IT Development Manager
Healthy Directions
10.2008 - 10.2010
- Responsible for the full life cycle of all new and existing SSIS and SSRS development.
- Lead the effort for the migration of legacy data into new production systems.
- Participated in the development and maintenance of the fulfillment ordering system.
- Developed SSRS reports that tracked and monitored dozens of database jobs across all production environments.
- Performed database performance tuning and analysis.
Senior SQL Software Developer
Catalyst Rx
06.2008 - 10.2008
- Company Overview: Healthcare Services
- Worked on both SSIS and SSRS requirement gathering, analysis and development.
- SSIS jobs were client-based import and export data feeds from multiple sources.
- SSRS Reports were used for internal multi-layered healthcare reporting.
- Worked on SSAS processing and data mining functionality.
- Worked closely with business analysts and operation managers.
Database Architect / Technical Lead
Department of Economic Analysis (BEA)
10.2007 - 05.2008
- Lead developer and designer of the main transactional Data Warehouse for the Bureau of Economic Analysis
- Work Involved managing, overseeing and distributing work among the entire database team.
- Developed numerous SSIS packages for ETL, reporting and data analysis requirements.
- Converted and integrated data from old legacy systems into new SQL Server database environments.
- Designed physical and logical database designs in ERWin that were used to push out database structures into live environments.
Senior SQL Database Lead
Merkle Inc.
10.2006 - 10.2007
- Lead developer of a dimensional Data Warehouse that contained membership and prospect data for AARP.
- Worked with other developers to architect the Data Warehouse and ETL process.
- Processes included the staging of the data, data type conversion, data validation, warehouse updates, aggregation, quality assurance, Business Object extraction and campaign selection processing.
- Implemented more than 250 attributes into the dimensional warehouse.
- Assisted with the construction of a data dictionary that included approximately 500 attributes and measures.
- Created and maintained various technical documents including system design documents and ERDs.
Senior SQL Application Developer
Merkle Inc.
10.2006 - 03.2007
- Participated in the design and implementation of the NIKE data warehouse.
- Worked closely with the client during the planning stages to gather system requirements and define business rules.
- Responsible for the design of more than 150 test cases to ensure data quality within the data warehouse.
- Responsible for modeling and conforming more than 40 data feeds and over 1,200 unique attributes.
Senior SQL Server ETL/Database Developer
Envision EMI
05.2004 - 10.2006
- Primary architect of the data warehouse ETL process. Processes included staging data feeds, data type conversions, data validation, warehouse updates and quality assurance.
- Responsible for all performance issues and backups on the Data Warehouse and transactional databases.
- Designed and created a SQL database that was used for online enrollment which interacted with a PeopleSoft front-end system.
- Participated in requirements gathering with the heads of other departments.
Database SQL Developer
Merkle Inc.
12.2001 - 10.2004
- Participated in the design and implementation of the Dell data warehouse.
- Responsible for supplying Dell with over 20 million records of consumer data which was based on complex models and attributes.
- This data was used to mail individuals on a monthly and weekly basis.
- Participated in the development of the ETL process for loading data of upwards of 150 million records into the data mart.
- Responsible for the Dell data warehouse incremental and refresh updates which were performed on a weekly and monthly basis.
- Responsible for running statistics, performing backups and overall maintenance of the databases.
- Wrote SQL and VBScript processes that generated dozens of control reports on consumer financials and demographics.
- Participated in data discovery and requirements gathering meetings with Dell analysts and account managers to write out functional specifications.
Web/Software Developer
USA TODAY
06.1998 - 12.2001
- Helped develop two transactional SQL server databases that were used by over 50k outside users
- Developed and maintained over 50 ASP Scripts for USA TODAY clients such as AT&T and it’s Gannett news affiliates.
- Participated in the full life cycle development of numerous ASP applications.
- Helped design and implement web content throughout the site using HTML, VBScript and XML.
- Documented applications and procedures at the technical and user level.
- Trained users in using applications and procedures.
- Fully redesigned and automated the lottery, crossword puzzle and parts of the Sports and World sections for the USA TODAY site.
Programmer/Analyst
Quantum Research Corp.
03.1996 - 06.1998
- Worked on many of the financial database projects for the Howard Hughes Medical Institute.
- Designed, developed, and implemented the Grant Initiation system, a web based budget and expenditure system that was used by over 250 international fellows.
- Responsible for developing and administering the graduate budget system, a VB application for budgeting and tracking expenses for over 400 graduate fellows.
- Developed and helped design a back-end SQL Server database for both systems.
- Participated in migrating data and converting Access databases to SQL Server.
- Work involved interacting directly with clients and generating specifications.
Education
Some College Coursework Completed -
Rider University
Lawrenceville, New Jersey05.1996
Skills
- SQL Server Data Warehouse Development
- Power BI Report Development and Visualization
- Azure Data Factory
- SQL Server Integration Services
- ETL/ELT Data Migrations and Integrations
Certification
Microsoft Azure Fundamentals
Microsoft Azure Developer
Microsoft Azure AI
LANGUAGES
Russian Intermediate
Timeline
Senior Data Warehouse BI Lead/Architect
KL Discovery
10.2018 - Current
Senior Data Warehouse BI Lead
CoStar Group
05.2016 - 10.2018
Senior Data Warehouse BI Lead
Choice Hotels International, Inc.
11.2015 - 09.2016
Senior SQL ETL/BI Developer
AmerisourceBergen
05.2009 - 10.2015
IT Development Manager
Healthy Directions
10.2008 - 10.2010
Senior SQL Software Developer
Catalyst Rx
06.2008 - 10.2008
Database Architect / Technical Lead
Department of Economic Analysis (BEA)
10.2007 - 05.2008
Senior SQL Database Lead
Merkle Inc.
10.2006 - 10.2007
Senior SQL Application Developer
Merkle Inc.
10.2006 - 03.2007
Senior SQL Server ETL/Database Developer
Envision EMI
05.2004 - 10.2006
Database SQL Developer
Merkle Inc.
12.2001 - 10.2004
Web/Software Developer
USA TODAY
06.1998 - 12.2001
Programmer/Analyst
Quantum Research Corp.
03.1996 - 06.1998
Some College Coursework Completed -
Rider University