Business Intelligence Power Bi

ANDREW WATSEK

**** **** ******* ****, ******, Tx 75039 Mobile: 972-***-**** *******@*****.***

Profile: Marketing and Business Intelligence professional

Specializing in Business Intelligence, Data Warehousing, and Marketing

Highly motivated and experienced BI and Marketing professional with a record of successful data modeling and data warehouse architecture projects. Valued for an in-depth knowledge of a wide range of technologies.

Proven professional with a successful record of delivering top performance in BI and Marketing solutions.

Recognized for adept leadership, management skills, technical savvy, project management, and analytical skills.

Attentive to stakeholder needs and delivering their requirements in a changing, deadline-intensive environment, on schedule. Strong organizational, reporting, evaluation, and interpersonal skills.

AREAS OF SPECIALTY

Business Intelligence: Business Objects (XI, XIR2, 3.x, 4.x), Web Intelligence, SSAS, SSRS, Crystal Reports, SQL, T-SQL, PL/SQL, Tableau, TOAD, SQL Developer, Information Steward, Explorer, Power BI

Data Warehouse: Oracle, SQL Server, Kimball Methodology

ETL: Informatica, SSIS, SQL

Marketing: Unica, Campaign Management, Campaign Result Analysis, Campaign Testing

Consulting: 5+ years’ experience as a Business Intelligence Consultant

PROFESSIONAL EXPERIENCE

Caterpillar

Senior Business Intelligence Analyst Oct 2023 – Mar 2025

Migrated complex Tableau dashboards to Power BI, enhancing data visualization and performance.

Designed, developed, and maintained dynamic Power BI reports to deliver actionable insights on key business metrics.

Led project management efforts, ensuring timely delivery of analytics initiatives across cross-functional teams.

Supervised international teams across multiple time zones, ensuring effective communication and productivity.

Achieved Microsoft Power BI Data Analyst Associate certification (PL-300).

Moxie Pest Control

Business Intelligence Specialist (08/2022 – 03/2023)

Developed Power BI data model to enable insightful data visualization and analysis.

Produced and managed Power BI reports to provide insights on key performance metrics.

Improved the effectiveness of reporting by migrating Excel reports to dynamic and comprehensive Power BI reports.

Provided SQL query support to team members and optimized queries for maximum efficiency.

Collaborated with end users to identify reporting requirements, establish KPIs, and evaluate outcomes.

ITS Conglobal

Manager Data Analytics (10/2021– 07/2022)

Ensured accuracy and availability of existing Power BI reports and Dataflows through efficient management.

Collaborated with business stakeholders to identify and define key performance indicators (KPIs) to drive organizational success.

Administered and maintained the Azure-based SQL Server data warehouse.

Provided comprehensive training to end-users on the utilization of Power BI, enabling them to maximize its capabilities.

Collaborated with end-users during User Acceptance Testing (UAT) to ensure complete accuracy and build trust in using Power BI as the primary source for all data points and insights.

CoachNet

Data Analyst (07/2020– 01/2021)

Led the efforts in converting technologies from Tableau to Power BI.

Took charge of the entire Power BI system, from inception to ongoing maintenance.

Designed and implemented Power BI data models and datasets.

Designed and developed Power BI reports based on the datasets created.

Performed UAT for all deliverables to ensure accuracy and performance.

Vermeer Texas-Louisiana

Business Intelligence Manager (03/2019 – 06/2020)

Oversaw a comprehensive system that included Targit Server, Database, ETL, and reporting system.

Pioneered the implementation of the Targit system at the corporation, taking it from concept to production as the first employee to do so.

Managed the development of new reports, ensuring that they included all critical KPIs and information to achieve maximum impact.

Designed and implemented data warehousing solutions in Targit.

Demonstrated the value of the new system and earned employees' confidence.

WATSEK FARMS, OK

General Manager (6/2018 – 12/2018)

Helped my family business out while I was in between contracts.

Planted crops, fixed machinery, took care of livestock, and oversaw general operations.

HILTON INTERNATIONAL

SENIOR CAMPAIGN MANAGER (11/2017 – 05/2018)

Utilized Unica to create precise target segments and develop tailored campaigns.

Set up automated campaigns in Unica for weekly, monthly, and yearly outreach to targeted audiences.

Formulated and executed intricate SQL queries to perform data analysis.

Conducted training sessions to enable team members to independently create campaigns in Unica.

Contributed to the development of marketing tests and took charge of analyzing and reporting the results obtained from the testing.

Designed and implemented SQL scripts for User Acceptance Testing (UAT) to verify the precision of a marketing campaign prior to its launch.

Optimized offer selections using Unica's Optimizer feature to determine the best offer for each individual client.

Addressed campaign issues to guarantee their precision and efficacy.

Developed reusable macros within Unica to streamline recurring campaigns.

FUSION CONSULTING

SENIOR CONSULTANT (01/2017 – 09 /2017)

Lead training sessions with multiple clients for various tools such as Business Objects Information Steward, Universe Design, and Web Intelligence development.

Assisted peers as needed with research, planning, and execution of projects. Created Crystal, Web Intelligence, Lumira, and Explorer reports for multiple clients.

SELF

ENTREPENEUR (8/2015 – 8/2016)

Created and launched a business aimed at connecting attorneys with court reporters for testimony, but ultimately faced challenges due to a lack of interest from court reporters.

FLOWSERVE

Business Intelligence Project Manager (5/2014 – 7/2015)

Successfully lead the efforts of creating multiple data marts in SQL Server 2008/2012

Utilized PL/SQL as a means of creating ETL’s.

Lead the efforts, as well as assist in creating Web Intelligence reports associated with various marts.

Lead team members to accomplish various ETL, Datamart, and BI goals.

Successful in not only leading but technical development as well.

Developed, maintained, and modified Information Spaces in Business Objects 4.1.

Developed and modified Web Intelligence reports.

Managed projects throughout the SDLC process.

Maintained three Business Objects servers including patching and upgrades.

Worked with business stakeholders globally and provided real-time data in BI.

WATSEK FARMS, OK

General Manager (4/2013 – 1/2014)

Assumed responsibility for operations due to a family emergency and subsequently delegated them to a relative on a permanent basis.

ARTIS CONSULTING, TX

Data Warehouse Developer (2/2013–4/2013)

Assisted peers with numerous SSRS reports with drilldowns using SSAS and tables as a source.

Utilized SSRS as a means of reporting.

Developed and updated numerous SSIS ETL processes, while also documenting the changes made to them for future reference.

Worked with Oracle and Microsoft relational databases including, but not limited to, creating tables, querying, and utilizing stored procedures for reporting.

ONE TECHNOLOGIES, TX

Data Warehouse Developer (9/2012 –12/2012)

Worked alongside the BI Architect to enhance the current solution for better performance on a temporary contract basis. Created many SSIS ETL’s using flat files as a source, primarily to update data warehouses.

Used the Kimball methodology to design data warehouses.

TEKNION DATA SOLUTIONS, TX

Business Intelligence Consultant (2/2012 –7/2012)

Designed and documented ETL processes using SSIS for clients across various industries, ensuring effective data integration and management.

Designed and developed interactive dashboards using Tableau for data visualization and analysis purposes.

Collaborated with multiple clients to understand their business intelligence requirements and translate them into actionable solutions.

Utilized Erwin for database modeling, including defining table structures, establishing relationships and keys, creating indexes, and generating DDL scripts. Additionally, performed database comparisons to identify discrepancies and ensure consistency.

Designed BI solutions and co-designed data warehouses to meet client needs. Designed SSIS packages to update data marts and data warehouses.

Applied business analysis expertise to understand client requirements and develop technical solutions that met their needs effectively.

TARGETBASE, TX

Senior Campaign Manager / Business Intelligence Manager (2008 –2011)

Translated business user requirements into technical specifications, ensuring alignment between business objectives and technical feasibility.

Designed and modeled Data Marts to cater to diverse industry-specific requirements of multiple clients.

Analyzed incoming data, loaded the data into staging tables, then staged the data into production, and finally loaded the production data into a reporting schema.

Expertly utilized Informatica, Business Objects, SSAS, SSIS, and SSRS to architect and deploy data warehousing solutions that met the unique needs of clients across various industries.

Develop Business Objects universes and reports as well as manage the Business Objects server.

Oversaw and directed cross-functional teams in BI projects from conception to delivery.

Created and managed campaigns utilizing Unica.

Played a key role in developing and implementing marketing testing strategies, including A/B and Multivariate testing methods.

Spearheaded the storage, analysis, and reporting of test results.

Led efforts to establish and maintain quality control processes for all team deliverables, ensuring that they were error-free and met all project requirements.

Leveraged Informatica and raw SQL to manipulate incoming data.

Created complex flowcharts, segments, and custom macros as well as loaded response data using Unica.

Designed SSAS databases in SQL Server 2008 for optimal query response time; designed database tables including transaction and warehouse.

Developed Universes, Web Intelligence (Webi), and Desktop Intelligence (Deski) reports using Business Objects 3.1 and XI R2, enabling clients to analyze and visualize their data effectively.

WCI CONSULTING, TX

Business Intelligence Consultant (2007-2008)

Designed customized WebIntelligence (Webi), DesktopIntelligence (Deski), and Crystal reports for various clients, catering to their specific data analysis and visualization requirements.

Consulted and designed information architecture including table creation, joins, data types, maximizing efficiency.

FIRST HORIZON NATIONAL CORPORATION, TX

Enterprise Technologist for Reporting Systems (2005-2007)

Developed Crystal reports as well as queries, commands, and ETL’s for diverse corporate business partners.

Established and maintained user, group, and folder security for the Business Objects XI system.

Maintained security for Hyperion, Crystal 8.5 and XI systems.

Administered reports, output, and services on the Business Objects system.

SERETEAN WELLNESS CENTER, OK

Systems Administrator (2001-2005)

Administered the IT infrastructure of the organization, which included a Novell server, Lotus Notes clients, backup system (Retrospect), and desktops running on Windows 2000/XP operating systems. Planned and executed system upgrades and maintenance activities to ensure optimal performance and security.

EDUCATION

Bachelor of Science, Management Information Systems, Oklahoma State University, Stillwater, OK

Contact this candidate