Data Support / ETL / DBA / BI Programmer
Resume:
Arthur Zavulunov
***************@*****.***
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