Arthur Zavulunov

404-***-****

ac3vhe@r.postjobfree.com

SUMMARY

** *****’ experience with relational database systems design and business intelligence data warehousing and reporting

** *****’ cumulative experience in software design and development

Strong cross-functional technical and business communication skills

SKILLS

Sr Programmer Analyst (BI Team) 2016 – Present

Kindred Healthcare, Inc. (formerly Gentiva Health Services)

Perform database & BI programming and related tasks for projects

Conceive and design programs, translating specifications into code, testing results to ensure accurate logic, and facilitating testing with the end user.

Work as a subject matter expert in business/functional & technical area

Act as a role model in learning & implementing new technologies & architectural concepts.

Work with other BI team members to understand, gather and document reporting requirements.

Understand, document & utilize the functional aspects of various source systems from where the data will come into data warehouse

Extract complex data from multiple sources into usable and meaningful reports and analyses

Design, develop and test high-quality Extract, Transformation and Load (ETL) processes, programs and scripts

Troubleshoot data integration issues and bugs, analyze reasons for failure, implement optimal solutions, and revise procedures and documentation

Design, develop and test reports & dashboards

Import daily SQL and SQL SSIS Jobs into Cisco Tidal Enterprise Scheduler

Own support tickets to debug & fix issues related to ETL, reports & dashboards

Write materialized SQL queries and save them as views for MicroStrategy Cube Enhancement

Work with MicroStrategy team after every deployment and verify with IM testing

Manage small to medium project efforts; organization, process flowing, task completion

Identify and document trends regarding reoccurring issues

Provide general reporting on data/status to management as requested

Support co-workers and promote a positive work environment

Participate in projects as well as process improvement initiatives

Advanced professional communication skills both written and verbal

Service orientation – high commitment to meeting needs of customers & colleagues and delivering stellar service

Success in working in a fast paced, changing environment with demonstrated ability to prioritize and manage multiple tasks

Utilize highly developed communication skills, including both excellent verbal skills and accurate written communication

Persistent in overcoming challenges to accomplish goals

Articulate complex information clearly

Detail oriented and able to own, organize, and prioritize workloads to handle multiple top priorities

Ability to work constructively in a fast-paced, collaborative, matrixed team environment

Strong work ethic and passion for excellence

BI / ETL Finance Services II

2016 – 2016

Coca-Cola

Define and implement strategies for extracting, transforming and loading data from multiple data sources into enterprise data warehouse

Consult with business/collaborate with business analysts on business requirements definition

Lead BI application design and development

Create and deploy reports

Configure, deploy and maintain database servers

Write relational and multidimensional database queries

Understand stakeholder business needs/requirements and transforming the information into meaningful, graphical representations using a BI tool

Serve as Subject Matter Expert (SME) and “Go-To" person for BI product line

Support and enhance the Capital Reporting and Forecasting Tool (CRAFT) utilizing SSIS, SSAS, SQL, T-SQL, Stored Procedures, SAP and Excel

Support the ongoing business processes for the Foodservice “PLUS” planning and reporting tool

Support Planning & Forecasting System Upgrades, Enhancements, and Changes

Address Known Internal Control Risks in Planning and Forecasting Systems

Support and Created Management Reporting system tools and processes

SQL Server Database Administration and Development along with Oracle connection to the PLUS system

SSIS Package Development and Administration for process improvement on various validation steps and reporting by developing or enhancing new tools as necessary

ETL / Database Administrator / BI

1999 - 2015

WorldPay.us (formerly RBS WorldPay, formerly RBS Lynk, formerly LynkSystems)

Engineered and executed an ETL process for a large scale transaction processing system

Modified and monitored existing DTS production jobs that produced and distributed over 50 manufacturing reports on a daily basis

Implemented and monitored over 50 electronic files into monthly databases

Facilitated the implementation of stored procedures using SQL and the deployment of enterprise-level data integration and data transformation solutions using Microsoft SQL Server Integration Services (SSIS)

Developed logical and physical data models data flows using SSIS

Designed and deployed the ETL process which is used to transfer data from Oracle databases to a consolidated SQL database repository

Designed and deployed SSIS applications which use stored procedures to extract and transfer data from MS SQL tables to FTP sites and various internal and external client sites

Analyzed and served as team lead with developers in the design, code review and implementation of a Payment Card Industry Data Security Standard (PCI DSS) conversion

Designed and developed reporting process for our Quarterly IRS reports

Implemented and improved several processes by rewriting them in SSIS

Prepared regulatory reports that contained critical and sensitive information that was used to ensure VISA/MasterCard compliance with state and federal credit card regulations.

Designed reporting solutions for the business

Led a team of DBAs modifying a constantly growing database application

Maintained the integrity and performance of mission critical databases

Created stored procedures, triggers, and functions

Reviewed stored procedures submitted by application developers, making changes as necessary to ensure consistent performance and availability of the system

Participated in team discussions to design solutions to meet business requirements

Responsible for one of the company’s largest internal applications

Led an initiative to convert legacy VB transaction management process to C#

Improved performance of existing ETL routines over sixfold

Demonstrated expertise in a variety of the field's concepts, practices, and procedures

Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client / server software applications

Assist in managing daily operations of development team and support channels; these include handling build releases and deployments, database deployments, production environment access and user accounts for our developed applications and tool

Updated job knowledge by researching new intranet technologies and software products

Completed applications development by coordinating requirements; contributing to team collaboration; troubleshooting development and production problems across multiple environments; support users and other developers

Follow proper procedures to resolve operational issues

Work to complete all assigned tasks on time with quality and consistency

Desktop Support

1999 - 2002

WorldPay.us

Diagnosed and repaired internal users’ computers and applications

Set up new user accounts and computers

Managed the support ticketing system

Technician

1996 - 1999

Southern Electronics Distributors

Built computers to customer specifications, from parts in a large warehouse

Promoted to phone support

EDUCATION

Georgia Piedmont Technical College

1996 – 1998

Clarkston, GA

Computer Science

Contact this candidate