DW/Database SQL/SAP Business Object developer

Galina Zimenkova

*** ******* *****, *** **** Tel: 718-***-****

Cliffside Park, NJ 07010 Email: ********@*****.***

DATABASE/BUSINESS INTELIGENCE/DATA WAREHOUSE/ETL DEVELOPER/DATA ARCHITECT

with 15+ years of experience in database programming.

SUMMARY OF QUALIFICATION

Over 15 years of experience as an IT professional in healthcare and finance industries.

Proficient in database development using Microsoft SQL Server, SSIS, SSRS, SSAS, T-SQL, Visual Studio.NET

Proficient in architecting Database/DW models, developing BI Reports/Universe/Schemas (BO XI R2/R3, MicroStrategy).

10+ years of experience in DW and SAP Business Objects software suite: Universe Designer, Web Intelligence, Desktop Intelligence, Infoview, Webi Rich Client, Central Management Console, Central Configuration Manager, BCA.

Expert creating ETL processes, defining data architecture, strategy, and road maps, data analysis and modeling, building DW/BI models/schemas/Universes. Created BO/MicroStrategry/QlikView Reports/Dashboards.

TECHNICAL SKILLS

Languages: T-SQL, SSIS, SSAS, SSRS, Visual Stuio.Net, VBA, VB.NET, C# and all SDLC phases.

Business Intelligence: DataWarehouse /BI Architect, Business Object 3.5, XI R2/R3, MicroStrategy, Schemas/Universes,

Desktop/WEB Intelligence, Reports and Dashboards, QlikView.

Tools: InfoView, Central Management Console, Web Intelligence, SSRS Reports.

Central Configuration Manager, Crystal Report, ERWIN, MicroStrategy, Share Point, Team

Foundation Server

Databases: Microsoft SQL Server, Sybase IQ 15.4, Oracle7 and 9i, Microsoft Access.

PROFESSIONAL EXPERIENCE

Health Republic Insurance NY, New York, NY 07/2014 – Present

Business Intelligence/Data Warehouse architect/developer

Created Claims, Membership/Member Enrollment and Provider process/extract for submission files (TSQL/ETL) to CMS/Altegra Edge Server for RISK RA/RI programs. Wrote company’s internal/external processes and repots for CMS.

Created TSQL/ETL processes for files submission/load/automation and FTP transmission for multiple Health Care vendors (POMCO, Wakely, Altegra, GDIT/HIDIS, Milliman). Created complex SSIS Packages in Visual Studio. NET, extract/load process of CMS RISK RI/RA reports in different file format.

Designed DW/BI complex claims/members/providers data mart models, created ETL process to populate DW tables.

Participated in gathering business requirements, source systems analysis, defining underlying data sources and transformation requirements, designing data model, developing metadata for DW/Analytical Reporting. (MicroStratagy/QlickView) Design/Managed company data architecture. Developed data standard/governance.

Affinity Health Plan, Bronx, NY 03/2012 – 07/2014

Information Management/DW Developer

Created complex data extracts (VIPS, LABCORP, CareCore) from FACETS database using T-SQL/SSIS packages.

Created Facets DW data models/BO universe for Medical Management, Membership and Claims Departments

Created complex reports in BO Web Intelligence (BI Launch Pad), Dashboards and SSRS.

Created functional requirements for technical specifications, test and production release documents.

Created and maintained finance MMCOR reports for DOH (BO Universe, WEBI reports).

Provided user’s training for BO designer tool. Created course material.

Health Plus, Brooklyn, NY 10/2001 – 03/2012

Sr. Programmer Analyst

Created complex data extracts, stored procedures, user defined functions, derived/summary tables and queries for medical financial reports, submitted to NY State and Re-insurance companies (Medicaid Encounter Data System II – MEDS II Professional and Institutional Segments, Medicaid Managed Care Operating Report – MMCOR, IBNR, Stop-loss Reports, Premium Payment, Bank files Processing, Health Integrated, HDM, EDI Claims processing and conversion)

Created DTS and SSIS packages and SQL Server Jobs for Facets and MemberPro.

Created Web and Desktop Intelligence reports for finance, claims, member enrollments, provider relations, utilization management, marketing, member services, enrollment, recertification using BO 3.1, XI R2/R3 based on BO universes and free hand SQL. Created multiple reports - letters (invoices, informational, notifications) for members and providers.

Supported, developed and maintained security for all BOBJ users in CMS and BO Supervisor: created users and groups, assigned security rights to users, groups, and folders.

Created BO Universes for different Facets database functional areas (Claims, Accounting, Providers, Member/Subscriber, Utilization Management, Capitation and Customer Services), and MemberPro (Accounts, Customers, Billing, Payments).

Participated in migration and upgrade Business Objects from 6.1 to XI R2/R3 and Facets Application to 4.81.

Directly coordinated with end users to gather new requirements and working with existing issues.

Trained end users in understanding and running new reports, using different tools.

Created Projects and Report Requirements Specifications (along with end users), Test Plans, Production Installation Instructions, and Batch Process Documents. Work closely with business analysts to breakdown business requirements into functional requirements.

Scheduled reports in CMC and monitor reports generation.

Being in-charge of all Business Objects related issues, including full BO security.

Provided training and code review for less experienced team members.

Merrill Lynch, New York, NY 12/2000 – 09/2001

Database Developer/DBA/Consultant

Developed all required database objects (tables, views, indexes, roles, complex stored procedures, triggers), performed query optimization for financial applications in SQL Server 2000.

Designed database models for implementing financial Applications in SQL Server.

Implemented Full-Text Indexing in SQL Server 2000 for performing full text searches.

Participated in Development and Implementation of backup and recovery strategies, transferring mainframe data in to SQL Server via text files, BCP, conversion of MS Access financial applications (MAC, SRR) to SQL Server.

Maintained and developed MS Access database, Account Payable reports, coding.

Worked extensively with client, gathering requirements to generate customized ad-hoc SQL reports.

Reduced data retrieval time from SQL Server database for a proprietary reporting application. The optimization was accomplished by moving data retrieval code from the application layer to back-end database.

Redesigned and rewrote several VBA modules of client applications to SQL Server Process.

Optimark Inc., Jersey City, NJ 02/2000 – 11/2000

Database Developer

Created, and supported Sybase Database for Profile System Application.

Designed and optimized indexes, views, tables and stored procedures using T-SQL.

Wrote database stored procedures and DTS packages to extract data in different file format.

Supported database objects with DB Artisan/Query Analyzer. Created, enhanced and supported existing batch processes.

Tested and configured automated routine maintenance tasks like performance tuning, archiving, indexes and stores procedures. Created scheduled jobs.

Scope Dynamic Inc., New York, NY 04/1997 – 01/2000

Database Developer/Programmer

Developed logical and physical data models. Designed, developed, and normalized Sybase database using Erwin, DB Artisan and PowerBuilder for the Real Estate companies.

Wrote MS Access Applications and proprietary Reports using VBA code for Real Estate companies.

Created Data Dictionary with report descriptions, purpose and business needs. Involved in data migration/integration.

Checked coding standards followed by peers of the team, prepared test reports and bug logs for the testing purpose.

Developed stored procedures, triggers and functions and added/changed tables for data extraction, transformation and loading. Troubleshoot performance problems and data issues.

Designed, tested DTS packages, required for data transfer from consolidated files to database tables.

EDUCATION

COPE Business Institute. Diploma in PC Programming New York, New York

Moscow Polytechnic University. BS in Computer Software Engineering and Minor in Mathematics Moscow, Russia

Contact this candidate