Katya Bathin

Email: ac0h83@r.postjobfree.com Skype: katya.bathin

Mobile: 530-***-**** LinkedIn: http://www.linkedin.com/in/katyabathin

Address: *** ******** ***, *******, **, 02494

Senior Data Warehouse / ETL developer / Data Architect with more than 15 years.

M.Sc. in Computer Science and Applied Mathematics.

Summary:

I’m passionate about building high-quality data warehouse systems with real impact on customers.

All phases of Data Warehouse development lifecycle, from requirements to testing.

Modular and reusable ETL processes.

Domain-specific expertise in architecting & developing enterprise-scale data management systems for Healthcare, Finance industries.

Highly efficient, strong desire to seek out and learn new technologies, committed and motivated team leader, excellent team player, strong analytical abilities and decision-making capabilities.

Participated in multiple studies involving software engineering and database design experts in Electrical Engineering and Computer Science Department (EECS) at MIT.

Technical Skills:

Databases: MS SQL Server 2005-2008/2012, AWS, S3, Oracle, Sybase SQLAnywhere

ETL Technologies: SSIS, Business Objects Data Service/BODI

BI / Reporting Technologies: SAP Business Objects, SSRS, IBM Cognos / IBM Watson

Various Data Modeling techniques: Kimball methodology, Data Vault (Big Data)

Programming languages: Python, C#, VB.NET, PowerBuilder, UNIX Shell, Perl, Delphi

Tools: GitHub, Jira 7, SFTP, Tuxedo, ClearCase, ClearQuest

Change Data Capture (CDC) technique.

Professional Experience:

Carbonite (Boston, MA) https://www.carbonite.com/

Senior DW&ETL developer / Data Engineer / Data Architect Jun 2016 – present

Lead DW team. Developed and supported high performance for ETL (SSIS ) processes on Microsoft SQL Server that distributed of the data needs of multiple business departments: reports, analytics, finance.

Provided advanced support for incident resolution for technical problems involving production database systems.

Implemented CDC (change data capture) solutions in DW for approach to data integration that is based on the identification, capture and delivery of the changes made to enterprise data sources.

Integrated in the cloud AWS RDS project for business analytics data with Big Data technologies Data Lake systems, architected Data Vault data model, developed ETL - EMR process.

MACIPA (Mount auburn Cambridge independent practice association) http://www.macipa.com Location: Brighton, MA,USA

Senior Data Warehouse / ETL / DBA Developer January 2015 – March 2016

Domain-specific expertise in HealthCare and health insurance industry.

Architected, Designed and implemented tools to automate Data Warehouse operation and monitoring.

Integrated data sources, created ETL infrastructure, designed metadata standards, staging areas and operational data stores (ODS).

Built efficient SSIS packages for processing fact and dimension tables with complex transforms and slowly changing dimension (Type1 and Type2).

Developed complex reports using multiple data providers, user defined objects, Windows functions, CET and synchronized queries.

Network Health Insurance (Medford, MA) http://www.network-health.org/

Senior Data Warehouse / ETL Developer July 2012 – January 2015

Gathered requirements, designed, developed and implemented DB solution for healthcare organization.

Designed, developed, optimize complex stored procedures in daily load process to meet data management and data integration objectives.

Created and customized complex ETL packages using SSIS and Business Objects DI (SAP) to extract client structures data from multi-formatted Flat files, Excel, and XML files into SQL Server.

Analyzed row data from vendors to ensure quality, completeness and to control totals.

Designed and developed Data Warehouse for the BI Analysts system and for the Reporting group.

IBM Global Services at NSTAR Electric&Gas (Westwood, MA) http://www.nstar.com

Senior Database PL/SQL Developer / PowerBuilder Consultant July 2011 – July 2012

Responsible for development and implementation of new modules of a project in financial sector. That included complex PL/SQL development over UNIX Shell and Windows environments for Credit project.

Led team effort for production testing, documentation and customer support.

Configured, optimized and supported project production environment through database management tools.

Participated in research and resolution of technical support issues.

Ness Technologies (Boston MA, USA / Israel) http://www.ness.com

Freelance Consultant / Senior Application / Database Developer February 2009 – July 2011

Designed and developed database front-end and application user interface for finance system applications.

Performed legacy code optimization by transforming PowerBuilder legacy code into MS.Net.

Developed analytic reports, extended data model, PL/SQL packages and procedures.

Trained user teams.

FIS Life Insurance Software Ltd (Israel, Tel-Aviv) http://www.fis-software.com

Senior Application Developer January 2008 –January 2009

Designed and developed front-end for a financial insurance application. This included development of documentation and reporting platform in PowerBuilder and MS.Net; systems integration analysis; and development of external suppliers’ applications with “ALIS” - Enterprise Insurance software platform.

Leading integration and implementation project for IBM Cognos Business Intelligence software. This included PowerBuilder infrastructure development for integration with Cognos BI Reporting system.

ZIM Integrated Shipping Service (Israel, Haifa) http://www.zim.co.il

Senior Application / Database Developer September 2003 – January 2008

Responsible for design, development and maintenance of Equipment Control module for IQSHIP enterprise system.

Led global WW client support projects for IQSHIP Equipment Control module.

Implemented business applications to support strategic customer accounts.

Amdocs Systems Innovation Service (Israel, Raanana) http://www.amdocs.com

Development Team Leader (Managed a team of 4) August 1998 – September 2003

Specified and designed software, release and configuration management.

Responsible for Billing and Customer Services module for design, development and end-user implementation.

Worked with legacy systems.

Education

M.Sc. in Computer Science and Applied Mathematics

Faculty of Applied Mathematics, Computer Sciences and Mechanics

Voronezh State University of Russia

Certifications

ACS Education http://www.acs-inc.com/ 2006 Tel-Aviv, Israel

Oracle 9i – 10g Application Tuning Course for Enterprise systems.

Kedem High-Tech College http://www.hi-tech.co.il/college 1997-1998 Tel-Aviv, Israel

Major subjects: Oracle, PL/SQL, Forms, Visual Basic, networks.

Miscellaneous

Languages English (fluent), Hebrew (fluent), Russian (mother tongue)

Citizenship status: U.S. citizen

Contact this candidate