John Lopez Email & Phone Number

San Diego, California

Greater San Diego Area

Calabasas, Ca 91302

-Championed informed business decisions by translating business requirements into actionable executive summaries, detail reports and dashboards representing KPI metric aggregations against hierarchies and custom groups.-Designed, wire-framed and initiated the development of Service IQ, a monthly updated web based BI dashboard for Volkswagen and Audi automobile manufacturers.-Supported the Development Team with KPI definitions, QA and performing UAT on new BI functionality. -Accelerated client campaign activities through the development of quarterly business reports for Volkswagen, Audi, Lexus and Porsche OEM clients that analyzed revenue activities and marketing campaign effectiveness year over year and quarter over quarter.-Identified and mitigated processing and data issues through SQL data mining minimizing potential revenue loss.

Greater San Diego Area

-Mined and drilled into the Computer Intelligence Technology Database (CiTDB) in the creation of proposals, client presentations, metric reports, marketing lists and internal analysis.-Supported Sales and Implementation Managers with pre-sales engineering and solution design by analyzing client project requirements.-Primary contributor in assisting the business unit with vendor product evaluation in the replacement of aging software infrastructure.-Generated monthly CiTDB release notes dashboards and reports utilizing SQL Server, Excel and Tableau.-Identified capability and designed processes to track and monitor projects and requests through current MS Dynamics CRM solution and relate it back to departmental KPI metrics.

-Rejuvenated student retention rates to an average of 85% per month by tracking admission results, analyzing performance and developing reports and measures.-Coached Sales Managers and their teams based on results and trends exceeding a 10% increase in admission rates. -Improved weekly call strategies leading to a 2% decrease in retention calls and a 3.5% increase in new prospective student calls.-Regularly developed, published and presented Excel spreadsheet reports on various performance metrics to management for call center based military admissions teams. -Forecasted monthly gross and net admissions results with an average deviation rate of 3.8%.

-Forecasted, recruited, enrolled and retained potential students for accredited undergraduate online degree programs.-Exceeded all admission goals and ranked in the top 20% of performers with 348 successfully enrolled students and a 88% retention rate.-Promoted to team lead within six months and completed the management training program in June of 2011.-Conducted appointments with potential and current students regarding their financial obligations, degree program options and university policies, practices and rules by using sound judgment and discretion.

-Analyzed and generated complex ad hoc reports through IBM Cognos and guarantor partner systems in support of new and existing school customers, sales representatives and management.-Interpreted large report data sets to mitigate processing issues and ensure the uninterrupted flow of student loan disbursements for multiple student loan brands.-Designed, analyzed and maintained complex database housed workflow processes and profiles for over 158 Universities and Colleges regarding the electronic transmission of student loan data through a standardized data processing format known as CommonLine. -Traveled nationally to attend industry related conferences and to present to external teams, partner companies and school clientele on topics ranging from product information to product processing.-Coordinated and supported sales representatives utilizing Salesforce.com in sales generation and brand recognition activities for a $200M territory.

-Acted as team lead and subject matter expert for assigned team regarding the processing of federal student loans in a highly regulated environment. -Provided prompt, courteous and accurate information to clients concerning their loan products in a demanding call center environment.

Provided pre- and post-sales activities for computer, network and telecommunication equipment in the operational support of five account executives resulting in the focused growth of client accounts from $5m to $19M in FY2002. Customized sales presentations, negotiated contracts and pricing, sourced product, and generated purchase orders and quotes to execute complex sales.Developed Excellence in Sales training course.

Marketed and sold technology products and services to educational, government and commercial entities.Acted as the liaison between potential network integration clients and technical staff.Customized sales presentations, negotiated contracts and pricing to execute sales resulting in a volume increase from $50k in 1997 to over $1.7M in 1999.

B.A, Business Administration, 3.93

Activities and Societies: Graduated with Honors

Credits Earned, Computer Science

Activities and Societies: Theta Chi, Intermural Soccer

Credits Earned, Liberal Arts