Jerry Becker Email & Phone Number

Kansas City, Missouri Area

● Assumed responsibility for an enterprise-level Power Bi report in March 2023 which tracked key metrics for the company’s operations. Worked towards a goal of eliminating reporting and data source redundancies by merging our department’s Excel reporting metrics into the Power Bi report and add new filtering slicers and visualizations. Built SSIS packages to transfer large amounts of data from multiple .csv flat files into SQL Server. Initiated training myself into how to use Python code to also move data from flat files in SQL Server. Started research into redesigning the report using different Data Warehousing and Cloud database options, such as SQL Server Analysis Services and Azure, to store and model the data. Reviewed Dax formulas in existing Power Bi report to determine what columns in the .csv flat files were being used and see if there were existing SQL Server tables which this could be sourced from. ● Designed Power Bi dashboards by collecting requirements from management, building SQL Server data from multiple database sources and testing reports for accuracy and performance. Presented Power Bi reports to stakeholders and made design updates as needed.● Developed new SQL Server data source for a combined view of daily transactions for ad hoc, weekly, monthly and quarterly reports. Gathered requirements and researched existing SQL tables to determine which data met the needs of the pricing department reporting structure. Built SSIS packages to transfer data from multiple sources and created stored procedures for data updates.● Enhanced existing Access databases used to create XML files to load requests into site used by salespeople to manage customer tariff programs. Created and modified VBA code which would create different outputs for the XML file.● Supported conversion from company-built sales pricing requests system to Salesforce by creating and testing request routing rules and mass file injection process.

Kansas City, Missouri Area

Generated mutual fund reports for numerous fund management companies using PowerSelect financial tables in Microsoft Access. Analyzed requests and used Access query builder, JetSQL and SQL pass through queries to extract, organize and present fund information to customer specifications. Researched multiple data tables to fulfill complex requests and created new processes and logic to build custom reports. Analyzed current reporting processes and determined where improvements and upgrades could be made.Reviewed frequent reporting requests and developed reporting tools in Microsoft Access to complete them. Designed tools in Microsoft Access to calculate client ownership of funds and account details for any requested business date. Integrated data from multiple sources with SQL statements, using variables within VBA code.

Overland Park, Ks

Processed various report requests using data from linked tables through MS Access, with requests ranging from basic financial advisor account information, to complex data from TA2000 and Sungard OnBoard. Updated basic SQL statements in existing MS Access databases to run pass-through queries. Organized output data in MS Excel in reports ranging from standard columnar, to advanced pivot table formatting.Managed over 300 automated reports on VMware server, troubleshooting any that did not run properly. Built new automated reporting requests and scheduled them with Task Scheduler in Windows OS. Put together macros in MS Access to automatically run queries and email tables for end users on daily, weekly, monthly, quarterly and yearly basis. Used conditional statements in macros when needed to send different output if conditions are met, and utilized VBA code to export and send MS Excel attachments for reports with a very large data output. Managed projects and built complex tools in MS Access for departments that needed help gathering and managing different data. Conducted various meetings with end users to gather requirements and understand the customer's needs. Documented client's current process, researched what improvements could be made, and presented suggested new procedures. Wrote formal business requirements in MS Word, and utilized MS Visio to provide client with visual representation of the new process. Designed and built approved tool in MS Access to help clients manage and modify their data more effectively.

Overland Park, Ks

Managed big data by creating a database in Microsoft Access to combine multiple data sources, which were used in analytical Microsoft Excel-based tools I created. Generated standard and ad-hoc reports in Microsoft Excel, and analyzing date milestones for over 32,000 cell sites for the Sprint Vision Backhaul Process. Collected, consolidated and examined spreadsheet data from Project Coordinators for use in reports. Used VLOOKUPS and other advanced functions in Excel to pull in data from FST and Siterra to create Pivot Tables and Microsoft Power Point presentations for Project Coordinators and Sprint management. Composed weekly Microsoft PowerPoint presentations with Excel graphs, tracking multiple types of information for upper management to review. Designed an Alcatel Lucent Scorecard report, which allowed Project Coordinators to daily refresh FST data for their calls and view only their selected vendors and markets. It also provided them information about average days between milestones, percentage of vendor completion for sites that were actualized and future forecasts for several milestones in the Sprint Backhaul process. Project lead for database update project to take over vendor data for reporting. Worked with team members to determine process for obtaining data from third party vendors and uploading into the Sprint Siterra database. Created template to compare both data sets to determine which sites need forecast and actual updates, and then compile them in correct format for Siterra upload. Worked with our partners at Alcatel Lucent on identifying and correct other invalid data between FST and Siterra.

Overland Park, Ks

Analyzed promotions and pricing programs for account managers and design architects on EMC, VMware and other storage hardware/software technology. Assisted sales opportunities by summarizing prioritization, researching product registrations, providing technical information, compiling related data and acquiring pricing structures. Verified registration, pricing and/or other specialized agreements then communicated and facilitated delivery schedules with account managers, design architects, external vendors, and channel managers. Completed field-related continuing education for new product descriptions.

Reviewed and analyzed CAD specifications and determined information for Sprint’s underground fiber optic network. Eliminated backlog of over 200 Outside Plant fiber optic work orders within a six month period, well ahead of project due date. Managed project to update the software used to report and track work orders. Coordinated with different departments to improve work flow process. Assisted internal customers with report requests regarding details about Sprint network assets at work locations. Also took care of ad-hoc reporting requests using data from internal Sprint software and analyzing and organizing data on Excel spreadsheets. Built and approved network engineering work orders, managed financial status in PeopleSoft 8.9 and reported dollars on internal software system for asset management purposes.Facilitated journal entries through Finance and ensured retirements and transfers of materials to and from work sites were completed.Assisted in post-conversion PeopleSoft 8.9 Accounts Payable invoice approval project to help process over 3000 vouchers within a six month time periodResearched work orders with lost or stolen materials on them, and was able to track down and recover network equipment, saving Sprint over half a million dollars in new hardware acquisitions.Maintained and reported on survey data metrics from Network Development Group presentations.

Responsible for planning business travel for Sprint employees and VIP executives, in both domestic and international markets. Key responsibilities included, using the computer reservation systems Worldspan and Sabre to search for and acquire the lowest airfare, supporting the Sprint vendor contracts by recommending preferred airlines, cars and hotels, providing information and assistance on passports and visas, and solving travel-related problems for the customer.

Created and processed reports on travel agency software and SQL-based databases for internal and external customers. Maintained database integrity by creating and running Microsoft Access queries and correcting invalid information.Generated daily, weekly and monthly reports for internal and external customers from internal software and organized data to customer specifications using Microsoft Word and Excel. Would receive ad-hoc reporting requests from internal and external customers and would build original reports to their specifications using internal agency software.

Responsible for planning business and leisure travel for Sprint employees in both domestic and international markets. Key responsibilities included, using the computer reservation systems Worldspan and Sabre to search for and acquire the lowest airfare, supporting the Sprint vendor contracts by recommending preferred airlines, cars and hotels, providing information and assistance on passports and visas, and solving travel-related problems for the customer.

Bachelors Business Administration, Business

Associates Of Arts Degree, General Study