Jan Surovciak
Open to work25 years experienceBI & Data Analytics Specialist
BI & Data Analytics Specialist with over 20 years of experience in database development and data modeling.
Standing Rank
Rank Not Available
Developer Badges
Skills & Technologies
34 skillsGitHub Activity Evidence
GitHub Footprint Not Connected
Recruiters value verified code contributions. Linking a GitHub account displays live heatmaps, active contribution metrics, repository languages, and push activity tags.
Work Experience
Software Developer
Telecom Contract
- Developed and enhanced the Netcracker Inventory application using Java.
- Architected and refined workflows and business processes.
- Crafted and optimized Oracle PL/SQL components, including packages, functions, views, and reports.
- Improved data warehouse performance through the strategic implementation of DB links.
Senior Software Developer
SYNPULSE
- Contributed to multiple Avaloq banking system projects for HSBC and A1 Bank.
- Executed the HSBC Paris to Luxembourg branch migration.
- Facilitated process simplification and Avaloq upgrade adaptations for HSBC London.
- Managed data migration from legacy systems to the Avaloq platform for A1 Bank Vienna.
- Performed AWS-based deployments and developed Oracle PL/SQL solutions.
- Monitored web services using Datadog for performance and availability.
- Authored epics, user stories, and test cases, alongside conducting data validations in Jira.
Database Specialist
SWISS RE
- Engineered data models and developed solutions in SAP HANA, including CDS views and calculation views.
- Created stored procedures to automate finance cost accounting processes.
- Developed reports utilizing ABAP and Informatica, and visualized data with Power BI.
- Automated Excel-based processes through VBA scripting.
- Contributed to the Git migration initiative to Azure Cloud.
- Managed task tracking and project coordination through Jira.
Senior Solution Developer
ERSTE BANK (Erste Group IT)
- Served as a SAS developer within the Credit Risk Reporting department.
- Optimized the performance of Oracle PL/SQL procedures that fed SAS risk calculations.
- Constructed SAS solutions for key risk metrics including CVA, RWA, PD, LGD, and EAD.
- Appointed as CVA Solution Manager, acting as the primary regulatory contact for Basel III, GDPR, and audits.
- Authored Unix shell scripts and Python scripts for efficient data manipulation.
- Administered SVN repositories and managed monthly production releases.
Senior BI Specialist Oracle
SLOVNAFT (MOL Group)
- Developed and fine-tuned Oracle Discoverer reports operating on a Data Warehouse (DWH).
- Designed data marts to enhance the performance of financial reporting.
- Built and maintained Extract, Transform, Load (ETL) processes integrating data from multiple source systems.
- Optimized SQL and PL/SQL queries through techniques such as partitioning, indexing, and table functions.
- Participated in the analysis and design of new DWH interfaces.
Senior Core Developer
Q-FREE
- Contributed to the Slovak Electronic Toll System (SkyToll) project, providing 2nd and 3rd level support, error analysis, and database development.
- Developed core stored procedures utilizing Sybase and Oracle.
- Managed ETL processes from Sybase to an Oracle Data Warehouse.
- Executed Java unit testing using JUnit.
- Developed a standalone C# application with an MS SQL Server backend for the OBU Shipment Application.
- Support of DWH, data extract from Sybase to oracle on daily basis, reporting in SAP BusinessObject.
- Integrated barcode readers, electronic scales, and printers into the OBU Shipment Application.
- Successfully delivered the OBU Shipment Application project within 2 months with a 6-member team.
Senior Financial Software Analyst
DELL
- Designed and developed financial reports for the EMEA region.
- Performed Oracle SQL development utilizing Brio Insight and Business Objects.
- Collaborated directly with international Dell analysts on financial reporting initiatives.
Programmer / Developer
DOSHI ASSOCIATES MI (USA)
- Engineered and developed MS Access client/server applications.
- Administered and optimized SQL Server 2000 performance.
- Configured networks and servers, including Windows Server 2000/2003.
- Implemented robust backup strategies and biometric access systems.
Programmer / Developer
ASSETSOFT
- Developed a Management Information System (MIS) for Allianz, an insurance company.
- Handled large-scale data processing tasks using SAS and Oracle.
- Designed and developed MDDB (Multi-Dimensional Database) solutions and SAS-SCL applications.
- Executed ETL processes to transfer data from Oracle into a SAS Data Warehouse.
Data Processing Administrator
CREDIT LYONNAIS BANK
- Generated statistical reports for the National Bank.
- Automated reporting processes using Excel VBA and macros.
Projects
Projects Not Populated
Personal applications, open-source work, and code repos will show here.
Leaderboard Standings
Leaderboard Position Pending
Global test scores, peer standing percentiles, and algorithm leaderboard ranks are updated dynamically.
Assessment Highlights
Assessments Not Completed
Coding evaluations, system assessment results, and conceptual score badges will appear here after taking a test.
AI Collaboration Score
AI Collaboration Score Pending
Developer coding behavior, assistant cooperation, and AI pair-programming indicators are evaluated during live coding sessions.
Role Compatibility Profile
Role Compatibility Analysis Pending
Custom matching reports, candidate role compatibility percentiles, and core engineer strength profiles are processed once conceptual code screenings are complete.
Achievements
O BU Shipment Application Delivery
Successfully delivered the O BU Shipment Application project within 2 months with a 6-member team.
About Details
Professional Bio
Highly skilled BI & Data Analytics Specialist with over 20 years of experience in database development, data modeling, and reporting. Proven expertise in SQL, Oracle PL/SQL, Power BI, and ETL processes, with a strong ability to optimize database performance and create insightful reports.
Master’s Degree in Information Technologies
FHI, University of Economics ( - Present)