Kenneth Ryan Kosik
Benton,LA
Summary
Driven business intelligence professional managing areas such as data mining, database management and development. Meticulous and hardworking with a disciplined and methodical approach. Exceptional skills in project management, problem-solving and solution building. Results driven with a team focus.
Overview
23
23
years of professional experience
Work History
Lead BI Developer
Lumen Technologies
Monroe, LA
08.2018 - Current
- Created a Data Warehouse with over 2 TB of data that has recurring automate feeds from both internal systems and external vendor applications
- Built automated feeds utilizing SQL Server Data tools that disminated HR related data for business partners
- This enabled those teams to further audit and ensure data quality and accuracy across their solutions
- Automated several key manual processes
- These enabled daily refreshes of KPIs, dashboards, reports to drive key business initiatives across HR, Operations, and Finance
- Created custom security solution for dynamic security and proxy access for various reports and dashboards utilized by all levels of the business
- Supported divesture data handovers from internal Lumen source data to external customer and vendor processes
- Created audit processes for Success Factors data to notify data entry team of potential data issues in a proactive manner.
Manager Enterprise Data Management
AFS Logistics
Shreveport, LA
12.2016 - 08.2018
- Managed team of 8 developers across multiple locations, including contract and off shore resources
- Responsible for over 30 SQL Server production instances with over 200 databases across multiple SQL Server version ranging from 2008 R2 to 2016
- Optimized current data warehousing techniques to speed up processing times
- This provided critical reports and dashboards to both internal and external clients on a consistent basis
- Created standardized maintenance plans for all production servers to ensure backup and maintenance plans were consistent across the enterprise
- Migrated databases from various versions older versions to SQL Server 2016
- Ensured reliant production applications had limited downtime and planned and implemented production cutover project plans for each instance
- Implemented SQL Server Always On Availably Groups on SQL 2016 instances to provide HADR solutions for mission critical application databases
- Automated several manual processes into SSIS packages on schedules to provided critical file processing for end users
- Monitored production databases and optimized long running and poorly formed queries
- This was done to ensure applications were running as efficient as possible
- Worked with multiple IT departments to ensure Development and QA environments were kept up to date and code deploy processes were managed on the database instance.
Owner/Consultant
Bayou BI, LLC
Benton, LA
08.2014 - 08.2018
- Developed custom data warehouse solutions based on business assessment of current and future data analysis and reporting needs
- Maintained and optimized databases for clients to improve manageability and ensure database availability and recovery
- Created backup and replication plans for SQL Server implementations
- Consultant for business process improvement and customized reporting solutions
- Optimized and updated existing data warehouses to fit business analytic needs to ensure business requirements were fully obtained
- Built Patient Intake system for a specialty pharmacy to streamline their patient intake process and improve workflow, patient follow up adherence, and profitability.
Senior Developer
Progressive IT
Dallas, TX
11.2015 - 12.2016
- Created scripts for pulling data from legacy billing database to current production database to consolidate and streamline business processes around customer billing
- Created process to verify extracted data matched with source data to ensure extract queries for the conversion processes were correct
- Worked with various business partners to ensure data quality and that all billing requirements were met
- Worked with data quality team to verify billing amounts were correct and created process to identify largest issues to prioritize critical path lists
- Worked with team members to optimize and correct processes to ensure uniformity and process timelines.
Director of Business Intelligence and Analytics
IC Intelligence
Bossier City, LA
06.2013 - 08.2014
- Managed team of 4 across multiple locations to provide best in class custom BI solutions
- Developed custom data warehouse solutions based on business assessment of current and future data analysis and reporting needs
- Maintained and optimized databases for clients to improve manageability and ensure database availability and recovery
- Created backup and replication plans for client side databases
- Developed processes to import data from 3rd party vendors and manual business processes to enable the data to be included in the BI solutions
- Assisted clients in learning how to interface with their BI solution across their enterprise to get the most out of their data to ensure ROI
- Built real time dashboards for Food and Beverage to be consumed by various levels of business analysts and management
- Built hourly gaming reporting for clients so they had insight to what their gaming floor was currently doing each hour in real time
- Involved in all stages of the development lifecycle, including gathering requirements, designing meetings, development, QA, installation, and support
- Created various SSRS reports that used MDX and SQL data sets to provide critical data to business analysts and management
- Interfaced with several source system databases including: OASIS, IGTA, Infogenesis, MICROS, and Opera
- These databases were over SQL Server and Oracle.
Database Architect/Developer
Tech Results
Shreveport, LA
03.2009 - 06.2013
- Developed BI solution that was used by clients worldwide which had various transactional systems as the source data
- I was involved in all aspects of development, including using ETL, database design and development, cubes, and reporting
- Involved in all stages of the development lifecycle, including gathering requirements, designing meetings, development, QA, installation, and support
- Created SSIS/ETL packages that loaded client data from various source systems across industries (Gaming, Food and Beverage, Hotels) into a centralized data store and then into our data warehouse
- Created and modified cubes and optimized them for reporting and dashboard needs
- Created add-on modules to our BI solution that gathered data for reporting on specific aspects of casino data, e.g
- Free Play and Food and Beverage
- This included all table and cube design and overseeing the report development to ensure business needs were met
- Created various SSRS reports that used MDX and SQL data sets
- Worked onsite at numerous client sites worldwide
- While onsite I was responsible for installing our BI solution and ensuring that clients’ needs were met by explaining functionality and adjusting the product as needed to meet customized requests
- Maintained and optimized databases for clients to improve manageability and ensure database availability and recovery
- Created backup and replication plans for client side databases
- Interfaced with various source system databases including: OASIS, IGTA, PGI, S7000, S6000, Infogenesis, MICROS, LMS, and Opera
- These databases were over SQL Server and Oracle.
Sr. DBA/Database Developer
AFS Logistics
Shreveport, LA
08.2007 - 03.2009
- Created databases, procedures, functions, tables, and views for new versions of business analytic tools
- Implemented backup and maintenance plans for all production databases
- Created indexes on database tables to improve application response times
- Created ODS and Warehouse databases for client cubes and analytics
- Created cube definition using Visual Studio for Analysis Services Database
- Created procedures and functions to load the ODS database and an ETL process to push that data to the Warehouse
- This ETL process included the data for the various Dimension and Fact tables
- Created custom drill through report for Analysis Services
- Created performance reports with dynamic SQL used companywide to provide Quarterly, Monthly, and Weekly reports
- Modified cube structure to display various hierarchies, including Regions, Divisions, etc., used in Client Reporting
- This allowed the cube data to be sliced according to business needs
- Created database structure and procedures for Bill of Lading and Claims applications that were used by over 1000 clients
- Automated data loads from flat files provided by outside companies so key customer reports could be created faster
- Implemented new security model using asp net Membership tables
- This helped the company to streamline the process of adding new users and applications.
Database Programmer/Analyst
Lumen Technologies formerly CenturyTel
Monroe, LA
05.2003 - 08.2007
- Developed PL/SQL procedures and functions for various projects
- Managed team that was responsible for creating SQL and PL/SQL scripts for the database
- Maintained and enhanced several batch processes used by the company for the in house Billing System
- Developed and implemented a reporting interface for tracking message transaction times through the production MQSeries server.
Analyst
The Berry Company
Monroe, LA
08.2001 - 05.2003
- Queried database for reporting needs of management
- Keyed order information into database
- Verified accuracy and integrity of information entered in the database by other employees.
Education
B.B.A., Computer Information Systems -
University of Louisiana at Monroe
Monroe, LA01.2003
Skills
- Highly proficient in logical and physical database design, performance tuning, scalability, query monitoring and troubleshooting
- Highly Proficient in SQL and PL/SQL
- Success Factors Reporting Center
- Success Factors Integration Center
- Microsoft SQL Server
- Oracle
- Data Warehousing
- Performance Tuning
- Data Security
- Requirements Gathering
- Data Quality Management
- Database Administration
- SQL Server Data Tools
- MDX
- Success Factors
- Tableau
- Power BI
References
Available upon request
Timeline
Lead BI Developer
Lumen Technologies
08.2018 - Current
Manager Enterprise Data Management
AFS Logistics
12.2016 - 08.2018
Senior Developer
Progressive IT
11.2015 - 12.2016
Owner/Consultant
Bayou BI, LLC
08.2014 - 08.2018
Director of Business Intelligence and Analytics
IC Intelligence
06.2013 - 08.2014
Database Architect/Developer
Tech Results
03.2009 - 06.2013
Sr. DBA/Database Developer
AFS Logistics
08.2007 - 03.2009
Database Programmer/Analyst
Lumen Technologies formerly CenturyTel
05.2003 - 08.2007
Analyst
The Berry Company
08.2001 - 05.2003
B.B.A., Computer Information Systems -
University of Louisiana at Monroe
Similar Profiles
Naga SreedharNaga Sreedhar
Sr Development Consultant at Lumen TechnologiesSr Development Consultant at Lumen Technologies
ERIC TOMLINSONERIC TOMLINSON
Network Technician at Lumen TechnologiesNetwork Technician at Lumen Technologies
Omar RodriguezOmar Rodriguez
Sr. Network Engineer Program Manager at Lumen TechnologiesSr. Network Engineer Program Manager at Lumen Technologies
CELINE MARY SCELINE MARY S
Senior order management specialist at Lumen TechnologiesSenior order management specialist at Lumen Technologies
Toni VercherToni Vercher
Teacher at Bossier Parish SchoolsTeacher at Bossier Parish Schools