Senior Business Intelligence Analyst

Jeff Federico ************@*******.***

*** ********* **., ********, ** 94506

https://www.linkedin.com/in/jeff-federico/ Cell#: 925-***-****

Business Intelligence Analyst Data Analysis and Reporting

Analytical, quality focused, and detail-oriented IT professional with over 15 years of experience in business intelligence. Proven adeptness in report automation using SQL and Excel, data analysis, SDLC, report design, scripting, and implementation across various industries. Proficient at writing advanced SQL queries to report on complex data with large data sets and intricacies. Adept at communicating with stakeholders to determine needs, KPIs, ROIs, deliver results, and explain processes to non-technical users. Problem solver and creative thinker, providing innovative and effective solutions. Developed numerous, interactive and unique reporting methodologies within Excel for data visualization.

Areas of Expertise

Advanced SQL Queries

Report Automation

Strong Analysis Skills

Data Modeling/Integration/Cleansing

Advanced Excel

QA and User Acceptance Testing

Interactive Excel Data Visualization

Project Management/Requirements

Have Also Worked With

Crystal Reports MicroStrategy Business Objects Tableau Google Analytics

MS Access MS PowerPoint Test Track Pro JIRA Confluence SharePoint

Experience

Senior Business Intelligence Analyst Old Republic Home Protection, San Ramon, CA March 2015 – Present

Successfully conceptualized and created a unique, interactive Excel data visualization methodology (which includes some Visual Basic/macros) to show claims data mapped by county in over 20 states.

Applied knowledge gained from my Excel data visualization methodology to other areas of the business to enable easy, interactive, data visualization for a Call Center Authorization Agent Dashboard (for comparison of both individuals and teams), Cost Analysis by Trade, Written/Earned Premium, front end user interface errors, and numerous other Claims metrics.

Proactively performed SQL audits to find gaps and data issues for various business processes including: report generation, plan updating, commission payouts, and triggered customer facing correspondence.

Provided expertise on projects that contained over 2 billion individual data metrics, to compare before vs after data states when logic or process changes were implemented.

Extensive QA work on both customer and employee facing interfaces (as well as the accompanying databases) for process improvements and enhancements, including writing the official release notes for the business at large.

Spearheaded, managed, and created the backbone for being able to proactively know when any of the 400+ scheduled reports did not run.

Served as lead project manager and QA expert on hundreds of reporting projects.

Leveraged exceptional analysis skills to show how a small process change could save ~$150,000 per year in postage and production costs.

Marketing Analyst Prosper Funding LLC, San Francisco, CA September 2014 – March 2015

Slashed manual work load by 25 hours per week by fully automating all business partner reporting, which tracked lead conversions and payouts. Automation done by utilizing a SQL back end and an Excel front end.

Increased partner visibility into leads that resulted in no commission via decline reporting.

Assumed managerial responsibilities of the Digital Marketing reporting group in the month’s long absence of my supervisor.

Created dynamic cost modeling for partner commission payouts scenarios to allow management to plan contractual payment strategies.

Senior Payments Reporting Analyst Expedia, Inc., Bellevue, WA April 2008 – August 2014

Promoted to be the first ever Payments analyst at Expedia, in a new Payments group.

Provided easy visibility into companywide purchase success rates across 200+ points of sale.

Increased companywide credit card acceptance rates by creating decline reporting, which was used to work with individual card issuing banks to resolve processing issues.

Development and sustained reporting of many different purchase success metrics across all of Expedia and Hotels.com to monitor customer transaction conversion rates, launches of new forms of payment types, and payment process system changes. Full report automation.

Prepared executive level summary, management level, and ad hoc reports including bookings, transaction decline reporting, payment mix reporting, and ad-hoc requests.

Saved $100k per month by identifying and stopping bot fraud occurring on specific credit cards.

Risk Reporting Analyst Expedia, Inc., Bellevue, WA August 2006 – March 2008

Earned recognition by saving millions of dollars in losses companywide by developing queries to assist in catching fraudulent transactions across all business segments.

Development and sustained reporting around all companywide points of sale to show the fraud losses, losses prevented, chargebacks, airline debit memos, people costs, gross bookings.

Conceptualization and development of dashboard reporting to monitor fraud prevention employee performance and provide managers with key areas to focus on for improvement.

Data and Report Analyst RW3 Technologies, Austin, TX June 2003 – July 2006

Promoted to be the first ever report analyst in the company, after showing an aptitude for SQL, allowing it to realize an additional revenue stream by selling reporting services to clients.

Reporting liaison for many Consumer Package Goods clients (including Sony, Nestle, Kellogg’s), in charge of the entire report creation process.

Creation and delivery of both scheduled and ad-hoc SQL reporting for summary level, detail level, trending, comparison, exception, and gap-analysis reports for high level executives.

Systems Administrator and Tech Support RW3 Technologies, Austin, TX January 2002 – May 2003

Trained end users on RW3 proprietary software and general system administration.

Performed simple database queries, as well as creation of client’s data collection surveys.

Education

The University of Texas at Arlington, Arlington, TX May 2001 B.S. in Information Systems Cum Laude

Contact this candidate