Business Analyst
Resume:
Mark Zelenak
*************@*****.***
(23) Mark Zelenak LinkedIn
PROFILE
Self-motivated Business Analyst with years of Information Technology experience in data management, data processing, data analysis, data governance, Sharpoint, migration projects, JIRA and agile/SDLC methodology. Focus on customer service, while maintaining flexibility and self-organization. Excel in conflict resolution as part of the creative process within a dynamic team setting. Good at problem solving and delivering what the team/client is desiring.
TECHNICAL SKILLS
SQL
Health Rules Manager
MS SQL server
Collibra
Vertica database
SVN
Oracle
Toad
SQL Developer
Data Governance
Linux
UNIX
API Testing
Sharepoint
Power BI
Database Design
AB Initio
Informatica Power Center
Project Management
Microsoft Excel & Word
Microsoft PowerPoint
PROFESSIONAL EXPERIENCE
UCare March 2023 – Present
Technical Data & Business Analyst
Responsible for data quality from source systems into reporting Enterprise Data warehouse.
Documented detailed technical requirements as user stories.
Gathering specifications for data architect, and Subject Matter Expert.
QA and UAT testing on development projects.
Using SQL queries in creating reporting needs for necessary Key Performance Indicators (KPI’s).
Writing complex SQL statements for data mining on member, claims and pharmaceutical data.
Analyze data sources and document the outcome of data analysis.
Identifying and understanding source data through profiling.
Create ongoing data validations, monitoring thresholds and data variances.
Define source-to-target data transformation rules.
Experience with data catalog tools and governance frameworks.
Create post-production reconciliation reports to ensure the integrity of data.
Usage of RightData for data quality checks and validations scheduled in python.
Usage of Collibra data quality and Collibra data intelligence platform as governance tool.
Lead and participated in data governance and stewardship programs at UCare
EPAM Systems (Contractor for FICO) January 2021 – March 2023
Technical Data & Business Analyst/QA Tester
Responsible for data quality and data integrity on incoming data and existing data in the database.
Responsible for large migration projects.
Data modeling and physical database design.
Managed data from large pharmaceutical client.
Created user stories in JIRA for development team.
Perform campaign list processing and data hygiene for database loads.
Managed client on file transfers standards. AWS transfers and automated sftp transfers.
Build, ran, validated and delivered campaign files created in CRM tool Salesforce.
Participated in the Marketing campaign results.
Use WinSQL and SQL Developer in Oracle and Vertica databases to research inquiries.
Created custom reports to uncover data discrepancies.
Build, schedule and monitor automated processes for system loads.
Monitor and manage relational marketing databases Vertica, Redshift and Oracle.
FICO September 1994 – January 2021
Technical Data & Business Analyst/QA Tester
Managed pharmaceutical in Vertica and Redshift database.
Experience with API testing tools.
Automated file transfers with call scripts in Linux.
Created Business Intelligence reports to uncover data variances.
Interrogated, evaluated and validated client data into database.
Interfaced between client and implementation team.
Project management tasks: gathered specifications from client and designed innovative solutions for implementation.
Maintained existing code using ETL tools Informatica and Ab Initio.
Managed system metadata tables.
Japs-Olson September 1989 – September 1994
Computer Operator
Customer service ordering personalized address stamps.
Monitored IBM Mainframe system. Shift lead.
Operated high speed laser printers.
Wrote job control language and submitted batch jobs.
Ran system back-ups.
EDUCATION
A.A. Minneapolis Technical College
Information Technology
University of Minnesota Twin Cities
B.A. Geography
Contact this candidate