SUMMARY:

• Innovative, results oriented data/business/analyst/project manager wif over ten years of experience and a passion for building relationships and exceeding client and management expectations.
• Proven success in teh areas of data analysis, reporting and data visualization. Ability and interest in learning and incorporating new technology, especially business intelligence.
• Strong skills in developing and automating reports, dashboards, and presentations, as well as inter - department and executive client relations and vendor management.

TECHNICAL SKILLS:

FrontEnd developer: who can translate business requirements into impactful reports and interactive Dashboards in MS PowerBI & Tableau Data Modeling, Data Validation, Testing Gathering, manipulating, and visualizing data SQL to query relational databases to create needed datasets & perform data analysis DAX Data Metric Analysis to identify business trends and results. Creating Pivot Table Reports in Excel Technical Writer

Project Management: Finance Audit Vendor Management Requirements Analysis Monitoring Critical Path & Milestones Project Scheduling Client/Stakeholder Relations

PROFESSIONAL EXPERIENCE:

Confidential

Power BI Developer-Business Analysis

Responsibilities:

• Meet and develop relationships wif stakeholders.
• Business requirement documentation
• Gather requirements and functional speciation
• Assist wif user research and needs analyses to identify analytics requirements and design appropriate solutions.
• Data ingestion, data model creation: Teradata, DEEP
• Define calculations for metrics and KPI’s.
• Create and maintain reports and dashboards dat provide clear and actionable information for call center teams.

Confidential, Overland Park, KS

Business Analyst/Program Manager

Responsibilities:

• Responsible for creating all reports and dashboards for management team wif data extracted from Sprint Vision (tool used to manage project timelines)
• MS PowerBI, Excel Pivot Table reports, Tableau, Access
• As teh teams designated PeopleSoft Specialist, me review, create, track all PO requests in PeopleSoft. From me generated approximately $26 Million in PO requests. Reconcile/research vendor issues.
• Worked on several projects to review contracts, amendments related to Site Acquisition.

Confidential, Gardner, KS

Analyst

Responsibilities:

• Conducting in-depth data analysis using various data collection methods and tools. Efficiently identified, processed, and analyzed raw information for effective report creation and presentation to senior management. Data was extracted primarily from Salesforce and other sources.
• Testing and validating report data
• Creating and implementing Site Survey, Construction, and Engineering reports on a daily and weekly basis.
• Developed and maintaining Access database for AD-HOC reporting.

Confidential, Overland Park, KS

Data Analyst

Responsibilities:

• Extracted, compiled, tracked, and analyzed data from MS Sql Server, Oracle, and Access to generate reports. Used SQL to query dataset output.
• Used advanced Excel (Power BI, PowerPivot, Power Query,) to generate spreadsheets, pivot tables, visualizations, and dashboards.
• Utilized trend analysis to examine past call data to predict future performance- created charts to visualize information in Excel.
• Statistical analysis -MAX, MIN, AVG. etc. utilized to measure call data.
• Performed daily data queries and prepares reports on daily, weekly, monthly, and quarterly basis.
• Liaison wif Afiniti: compile and send data queries daily to company and check their analytics for accuracy.
• Worked wif management leadership to translate business plans into teh required report & dashboards needed to make sound business decisions.
• Power BI Sample: Call Center Analysis

Confidential, Kansas City, KS

Financial Controls Project Manager:

Responsibilities:

• Served as key point of contact for assigned OSP vendor/stakeholders.
• Successfully completed $7M close-out audit.
• Reviewed and processed over $5M in change orders for FY 2015.
• Tracked spend, change orders, and invoices against current PO’s to ensure budget is maintained.
• Extracted data from various Google databases to review information and create reports.
• Created weekly audit/delta reports dat ensured vendor consumption was accurate. Utilized advance excel skills - v-lookup and pivot tables. Also used Google Docs & Google Sheets for reporting.
• Reviewed assigned schedules in Primavera for accuracy to ensure project is on track.

Confidential, Overland Park, KS

Program Manager

Responsibilities:

• Supported network’s vendor management team by implementing change requests and ensuring fiscal compliance of contractual obligations.
• Managed issuance of PO requests based on financial, cost accounting, and procurement standards.
• Extracted PO data from PeopleSoft, Access, and other Sprint databases to review and audit information.
• Processed on average over $15M in PO requests per month.
• Successfully completed an audit dat revealed dat over $20M in PO cancellations had not been completed by SCM (Supply Chain Management.
• Interfaced wif network vendors to resolve PO related escalations, payment disputes and commercial disagreements.

Confidential Overland Park, KS

Migration Analyst

Responsibilities:

• Scheduled migration duties for field technicians, customers and third parties when adding and upgrading current router equipment Confidential cell sites.
• Documented teh success or failure of teh migration/maintenance and network performance in teh appropriate databases and notified external groups of migration status, accordingly.
• Developed pivot table reports and dashboards for Project Management and Executive teams.
• Extracted data from Primavera P6 Access and Intuit QuickBase databases to complete high-level analysis to ensure data is current/correct.

Confidential, Overland Park, KS

Project Coordinator

Responsibilities:

• Extracted (SQL) data from multiple databases to review data and create pivot table reports.
• Developed dashboards, PowerPoint presentations, ad-hoc reports for executive team
• Designed and developed a test SharePoint 2010 site for teh PMO and technical documentation to train department.
• Utilized trend analysis in Excel to monitor past PMO performance to predict future outcome to halp office meet service level agreements wif client.

Confidenial, Kansas City, MO

Associate & Design

Responsibilities:

• Edited and revised writing and tax content in a variety of income tax books
• Created case studies and wrote material to adhere to teh new BlockWorks software.
• Updated Web Based scripts and visuals.
• Performed user acceptance software testing and quality assurance to ensure to dat tax preparers received teh maximum quality product.
• Used Agile project management methodology to create schedules and monitor progress wif all stakeholders.

Confidential, Overland Park, KS

Sales Compensation Analys

Responsibilities:

• Data mining in various Sprint data repositories (billing, payment, Nextel Data Warehouse, Order Detail Report, Access).
• Utilized flat file (CSV)& SQL queries to extract needed data for analysis.
• Used VLOOKUP to combine and transform data.
• Used Trend analysis to look Confidential teh history of appeal data to predict future influx.
• Reviewed and audited appeals to ensure their accuracy for compensating retail sales staff.
• Developed technical plans and M&P’s for new team members.
• Implemented process improvement dat recognized over $12,000 per month in fraudulent and erroneous payments dat resulted in recovery for Sprint.