Alec Weaver Email & Phone Number

United States

-Creates Power BI dashboards for business and IT end users. (SQL, Dax, ETL, Power Query, RLS, Requirements Gathering, Data cleansing/ transformation, Data Modeling, Data visualization, datasets/workspaces/members management) -Prescribed two major upstream application workflow changes within Guidewire Claims Center, specific to reinsurance reporting and claims subject to litigation-Utilizes data mining techniques within Azure sql data lake, log analytics(kql), GuideWire (policy, billing, claims), Financial data mart to create standard datasets servicing enterprise reporting objectives-Collaborates with infrastructure, application, product, and reporting teams on data analytics projects-Shares and tracks improvement opportunities in Jira with technical documentation-Presents findings to technical and non technical groups throughout the data modernization project-Leads without authority-Serves as active member of the Data Governance team providing research based guidelines and opportunities around Data Lineage, Quality, Availability

-Reduced active application and infrastructure vulnerabilities by 65% by implementing and analyzing rapid7 data within ServiceNow vulnerability response module and coordinating with teams to implement solutions and drive security response (Recognized multiple times at global IT all hands) -Served as project management resource for IT projects including but not limited to; evaluating patching automation solutions, driving workshops to collect monitoring information on our critical application infrastructure -Engaged in reporting and analytics projects with stakeholders throughout the business -Developed and administered Power BI dashboards and workspaces for IT Ops. and executive consumers using SQL, Dax, ServiceNow, Sharepoint and Excel -Shared Power BI knowledge with junior teammates

Richmond, Virginia, United States

-Identified large (undisclosed) reimbursement by analyzing contractual service level agreements with managed service providers-Audited ServiceNow incident, change, configuration item management data to effectively collaborate with delivery managers and ITSM parties on ways to maximize business continuity, increase visibility, reduce cost and address recurring issues-Participated in quarterly database, server, network health checks, ensuring appropriate patching and risk documentation is completed-Provided IT Operations reporting using SSMS, SQL, Power BI, ServiceNow, Excel

Richmond, Virginia

-Researched, demonstrated, and implemented Power BI transition from legacy reporting system SSRS (Row level security , API, Dax, ETL, gateway configuration, dashboard creation, power query, data visualization, data modeling, data cleansing, kpi) -Reduced manual tasks through SQL, yielding 30 annual business days worth of savings -Served as data liaison for projects relating to policy implementation, performance evaluations , process management, forecasting, auditing, marketing, finance and accounting -Provided application functional support in addition to researching new technologies

Charlottesville, Virginia

-Saved $20,000 in annually by negotiating new credit card processing agreement-Transitioned legacy Crystal Reports to Sisense Business Intelligence platform-Served as project manager for 2 IT software implementations and acted as primary liaison between internal/external parties -Scripted and staged SQL code in Crystal Reports(occasionally Microsoft Access) to fulfill data requests for all departments and levels of the organization, including Accounting, Marketing, Ticketing, Development, Guest Services-Created dashboards and validates results with documentation derived from ER diagrams and database dictionary-Served as DBA for the ticketing database which captures transactions of annual revenues in excess of 9 million dollars

Richmond, Virginia Area

-Drove profitability, partner confidence/visibility, risk adjustment accuracy and nurse practitioner's effectiveness of care through a data model created with SSMS, SSRS, patient claims, and documentation from CMS-Gathered requirements, wrote and edited SQL code to reflect technical specifications , presented and maintained over 50 reports-Translated technical concepts to non-technical audiences throughout product development life cycle

Henrico, Virginia

-Assessed viability of supply chain transition, yielding $250,000 in annual cost savings-Analyzed and prescribed forecasting accuracy changes leading to large undisclosed savings based on materials reserve reductions-Developed a Microsoft Excel tool, automating an ordering process by 75%, yielding 4.5 annual business day savings-Structured and scheduled shipments from international national distribution centers to national distribution centers to maximize fulfillment rates (99.4%) which is strongly correlated to profitability -Monitors and balances inventory levels between international warehouses based on demand and transportation restrictions-Used and learned SQL to provide ad-hoc reporting for management

Midlothian, Va

-Created and implemented organization-wide billing order standards to accurately monitor the cost to serve clients, establish best practice logistic strategies, and identify areas for improvement.-Extracted, analyzed, summarized and presented findings derived from sales data. -Oversaw case life cycle activity to ensure efficient resource utilization and comprehensive policy adherence.-Contributed to asset management team in a local effort to responsibly and effectively manage $40 million+ worth of inventory, all while complying with corporate standards.-Enhanced, simplified, and streamlined internal operational reporting to guide managerial decisions.-Utilized the following software applications to perform the tasks above; Cognos Powerplay, Livelink, Surgery Management System (SMS), DCS, Microsoft Excel (VLOOKUP, Macros, Pivot Tables, Pivot Charts, Conditional Formatting, Variance Analysis, Forecasting with Regression Analysis).

Various

-Assessed individual needs, designed, implemented specified lesson plans and consulted on projects.-Maintained professional communications with students, parents, and teachers to assure convenience in scheduling, awareness of student’s progress, and effective service.-Facilitated lessons in Algebra, Trigonometry, Statistics, and Economics for 20+ students.

Bachelor Of Arts (B.A.), Economics, 3.4

Activities and Societies: Men's Soccer, Study Abroad I played soccer, learned Economics, traveled around the world, volunteered.

International Business

Activities and Societies: Civic Engagement, Academic Seminar, Group Project and Presentation The Washington Center for Internships.

Diploma, 3.3