Robert Truman

ad3vgo@r.postjobfree.com

312-***-****

Profile:

Dedicated and highly accomplished Business Intelligence and Information Technology professional with experience in roles as Business Intelligence Manager, Business Intelligence Analyst, Business Intelligence Developer, Data Analyst, and Business Analyst.

20 years of data acquisition, data mining, data profiling and data visualization for the automotive, real estate, insurance, pharmaceuticals, supply chain and manufacturing industries.

Most roles required an ability to write SQL, MySQL, PL/SQL scripts and the ability to provide data related business solutions or to solve data related issues.

Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS.

Experience in Database Development, Design, Data Analysis and Support of MS SQL Server 2016/2014/2012/2008 R2/2008, Business Intelligence applications, design, development, and Maintenance of SSIS, SSRS and SSAS.

Extensive knowledge of different Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling, and reporting tools.

Professional in usage of SSIS Control Flow items (for each Loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all).

Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types and functions.

Technical Skills:

Databases: Microsoft Azure, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2017, SQL Server 2019, Oracle 11g, Oracle 10g, Oracle 9/10i, MySQL, Microsoft Access, Teradata

Database Tools Microsoft Server Management Studio, TOAD, MySQL Workbench, PL/SQL Developer, Oracle Forms, Oracle Discoverer, SQL Developer, SQL Server Management Studio 2014, SQL Server 2014 Import and Export Tool

BI Tools Microsoft Power Automate, Cognos, Microsoft Visual Studio, Power BI, Power Bi Report Builder, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Power Pivot, Power View, Business Objects XI, Crystal Reports, Desktop Intelligence, Web Intelligence, Oracle Reports, Pentaho Console, Pentaho Report Designer, SAP BI, SQL Server Reporting Services, QlikView

Other Epicor, Microsoft Excel, Microsoft Project, Microsoft Visio, Ultra Edit Text Editor, FileZilla, Ultra Edit, Microsoft Visual SourceSafe, Mind Manager, Note++, Jira

Professional Experience:

The Ironman Group, August 2022 – Present

Sr. Power BI Developer

Met regularly with Director of statistician, and other key stakeholders to gather and understand requirements for creating new and update existing Power BI dashboards.

Led the development of Power BI dashboards based off existing QlikView dashboards. Dashboards utilized bookmarks and selections to mirror existing functionality.

Led the migration of 30+ Tableau dashboards to include data sourcing and measures over to Microsoft Power BI.

Led the adaption of Power BI as the primary business intelligence solutions for the entire business and athletes.

Knowledge of statistical software such as SAS, R

Document RBC’s credit stress test methodologies, frameworks, and practices

Knowledge of databases structure and management (SQL, SAS, etc.)

In analytics experience spanning data mining, statistical analysis, forecasting and predictive modeling

Draper & Kramer Mortgage, December 2019 - 2022

BI Program Manager

Report directly to the Senior Vice President of Finance and the Director of IT.

Lead the implementation of an Enterprise Business Intelligence program implementation across multiple departments and functions.

Lead the development of a suite of Underwriting Power BI dashboards to depict Underwriter Productivity, Underwriter Pipeline activities.

Lead the development of a P&L, Derivatives and Corporate Income Statement reports in support of the Finance Department.

Underwriter Allocation Model using Power Automate, SQL Server, PowerApps and Power BI. Reducing the time required (from hours to minutes) daily to assign new loans to underwriters for processing.

Payroll Application using Power Automate, SQL Server, PowerApps and Power BI servicing hundreds of users. Reducing the management of hundreds of individuals reports, implementing an approval process and removing IT and Payroll from manually generating and reviewing.

Implemented RPA technology using Power Automate Desktop to automate manual tasks. RPA technology that automates the logging into third party systems, extracts data which is then stored in SQL Server for further automation and reporting.

Implemented the use of DevOps for report development and tracking for developers and key stakeholders.

Managing the migration of SSRS reporting to Power BI Paginated reports. Migrated over 400 operational SSRS reports over to Power BI Paginated reports.

Migration of Motivity Reporting to Paginated reports. Moved hundreds of reports, often consolidating them over to Power BI paginated reports from Motivity.

Deployed Power BI across the entire organization including SharePoint sites including the upgrade to Power BI premium.

Hired and managed a team of 6 Power BI Developers.

Creates, modifies, enhances and maintains Framework Manager Models within Cognos BI.

Works with IR on resolve technical and performance issues related to Cognos.

Constantly seeks process improvement opportunities and applies Lean Sigma practices to those opportunities.

Responsible for data analysis, designing, developing and testing reports in Cognos for the various disciplines within organizations in accordance with standard team processes.

SunSource, March 2016 – December 2019

Senior Power BI Developer

Project: Reduced Inventory across the organization by $25M within the first 6 months of delivering Inventory Analytics Dashboard and Visualizations. Served as Subject Matter Expert working closely with business and technology leaders to understand the enterprise objectives and build our capabilities in BI, Reporting & Analytical applications to support Sales, Operations and Shared Services. The role is instrumental in advancing the Advanced Analytics capabilities to lead the industry in the utilization of data to capture market share.

Responsibilities:

Work with all levels of business users to include the CIO, Directors, and Senior Managers, to understand reporting requirements and specifications.

Facilitate and lead senior IT and business teams through challenging data issues.

Assist in developing the roadmap for Analytics and Advanced Analytics across the company to enable the business strategy.

Serve as the Power BI administrator deploying, sharing, subscribing and security for all Power BI reports, dashboards and apps.

Designed models for Inventory, Finance, Operations and Sales using Power BI for self-service and operational reporting.

Designed, automated and operationalized reporting using Power BI Report Builder. Delivering daily, weekly, and monthly reporting to individuals at all levels of the organization.

Created Power BI visualization of Dashboards & Scorecards (KPI) for Supply Chain, Operations and Finance Departments.

Automated business processes within the organization using Microsoft Power Automate for process automation. Replaced dozens of manual processes with business automations and SharePoint.

Participated in daily agile scrum meetings to understand business logic and requirements of the company and provide optimal solutions to the users.

Develop & support backend data model, SSIS ETL and Power BI Analytics & Reporting & Dashboards. Developed reports using SSRS that could be used to send information to different Primary Vendors, Suppliers, and Internal Users.

Writing complex DAX formula Develop the complex Dashboard by showing key inventory, turns, excess and obsolete values.

Perform BI solution development activities including requirements gathering, functional design, technical specifications, ETL design & development, unit & integration testing, and reports & dashboard development.

Designed SSIS packages for transient and persistent staging area, to extract data from SQL Azure and different applications, from excel files and flat files using for each loop container, sequence container, and tasks such as execute SQL task, look up, merge, merge join.

Migrated existing suite of SSRS reports over to Power BI Paginated reports.

Generate automated, repeatable, and stable processes to support data transformation, data load, data movement, and data synchronization.

Assist in the training of end users and contribute toward the continuous improvement of our internal data capabilities.

Meet with subject matter experts in different areas of the business, be able to quickly learn the concepts and business language relevant to their line of business and develop an understanding of how their data supports their business processes.

Developed and maintained QlikView Load Scripts across multiple data sources.

Designed, created and maintained QlikView applications.

Identified data sources and prepared data for Qlikview applications.

Fuel Tech, October 2012 – March 2016

Epicor Business Analyst

Project: Consulted on an Epicor project reporting to the principal parties of an organization while implementing and training end users in the proper use. Guided and supported the company in the go live process and provided post go live support.

Designing complex end-to-end DW applications, integrating multiple ERP and business applications in a global environment.

Define project scope, develop project plans, gather, and document business requirements.

Business data modeling and analysis and a thorough understanding of relational data structures, database star.

Converted all data, customized screens for unique business processes, and customized screens for improved efficiency by reducing the number of clicks and navigation time.

Subject matter expert for several Epicor tools such as Advance Print Management, DMT, Business Activity Query, Business Report Designer, Crystal Report writing skills and Dashboards.

Co-ordinate training, implementation, and post-go-live support, incorporating business logic into Epicor. Result obtained; the business tripled while maintaining the initial staffing due to capturing efficiencies using the tools mentioned above.

Implement, in a challenging and dynamic environment, Epicor ERP software into customer locations.

HomeFinder.com, November 2007 – September 2012

Reporting Manager

Lead the creation of a centralized data mart to store information used to populate external reporting metrics. Responsible for all business reporting distributed to both internal and external customers.

Data Subject Matter Expert to external and internal customers reporting directly to the Vice President of Product Development. Served as the primary resource in the development of custom reporting to assist the President, the Vice President of Product Development, the Vice President of Business Development & Sales, the Director of Finance and Marketing and other upper management personnel in day-to-day decision-making processes.

Facilitate the conversion of existing Business Objects Desktop Intelligence reporting to Crystal reports or Business Objects Web Intelligence reports.

Reporting pulls data from newly created centralized data reporting mart.

Develop customized reports for both internal and external customers to support their sales initiatives.

Create ad hoc reports using SQL in platforms such as PL/SQL Developer and TOAD for both internal and external customers.

Experience prior to 2009 available upon request

Prior experience:

United States Army Reserve

Military Policeman

Education:

M.S. in Kinesiology, Western Illinois University

B.S. in Computer Science, Western Illinois University

Contact this candidate