PROFESSIONAL SUMMARY:

Experienced and knowledgeable Business Analyst with focused experience in the areas of Business Intelligence, Data Analysis, and Reporting. Have worked closely with stakeholders to maximize business functionality and efficiency. Hardworking, with great verbal and written communication skills.

CORE QUALIFICATIONS:

• Tableau
• SQL
• OBIEE
• Microsoft Power BI
• Business Intelligence
• Project Management
• Oracle/Netezza/SQL Server
• Microsoft Office: Excel, Word, Access, Visio, Project

EXPERIENCE:

Confidential, Leawood, KS

Business Intelligence Analyst

Responsibilities:

• Responsible for maintaining the reporting, visualization and analytical tools (Tableau) as well as creating content within these tools.
• Disseminate data from multiple sources, including the data warehouse, transactional database, excel and external sources.
• Responsible for providing technical support to the users of the enterprise reporting, visualization and analytics tools.
• Collaborate with power users and management teams to build Tableau visualizations that support key decision making using Tableau Desktop. For example, I developed a dashboard (“Seat Heat Map”) that visualizes the auditorium layout for each theatre and displays key metrics such as attendance, revenue and capacity utilization for every seat in that theatre.
• Create SQL queries to extract data from the data warehouse to fulfill data report requests, create and publish data sources to Tableau server.
• Create calculated fields and sample visualizations for users to use to explore data source.
• Serve as day to day Tableau server administrator. Maintain security, troubleshoot incidents, manage custom admin views. Backup administrator for upgrades/patches
• Converted from contractor position to full time after one month.

Confidential, Kansas City, MO

Sr. Business Analyst

Responsibilities:

• Responsible for gathering and documenting business requirements, and either creating or assisting with the creation of reports and dashboards.
• Worked closely with the Information Technology group to develop the business intelligence (BI) warehouse.
• Responsible for ensuring the integrity of information being reported by performing validation between source systems and BI warehouse.
• Constructed reports/analysis and dashboards in OBIEE based on user requirements. Worked collaboratively with IT to assist in the development of new ETL jobs and make changes in existing ETL jobs.
• Interpreted data and transform it to meaningful information.
• Gathered and analyzed end user requirements for Supply Chain Corporate KPI dashboard. Designed and implemented dashboard using OBIEE.
• Designed and developed repository modifications (from physical layer to presentation layer).
• Routinely trouble shoot data issues and perform ad - hoc report requests using SQL Developer.

Confidential, Lawrence, KS

Systems Analyst/Sr. Research Analyst

Responsibilities:

• Provided senior leadership of the university with timely and pertinent data/analyses to support the planning and management of the research enterprise.
• Responsibilities included working with Research and Graduate Studies to assure collection of appropriate and consistent information about sponsored project activities.
• Additionally, worked with academic and research units to provide data to meet their various planning and management needs.
• Identify, design and implement solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of administrative decision support and analysis and help maintain the university's administrative decision-support technical architecture.
• Designed and developed a robust Tableau dashboard for both KU Lawrence and KUMC campus that analyzed University Research funding. The dashboard provided key information/analytics for University Administrators, Deans, Directors and Researchers on the level of funding received, top researchers, areas targeted for improvement as well as top funding sources.
• Developed a highly interactive Tableau dashboard for Human Resources which visualized salary breakdown for each college/division on campus then further by gender, race, tenure and job classification. This resulted in department/division heads the ability monitor their compliance with federal and state reporting requirements.
• Was co-lead on a project that transformed Tableau into a managed service offering for consumption across the KU campus for Research Administration, Finance, HR and Shared Service Centers. Served as the Administrator for the enterprise server.
• Utilized Automic for the enterprise job scheduling of all SAS jobs to build the data marts. Responsible for ensuring jobs were running as scheduled, error free and tables were loaded twice daily. Responsible for the migration of each job, updating of the master schedule and related Linux scripting.
• Portal content management and development of BI application reporting, using SAS Enterprise BI (SAS Web Report Studio, SAS Enterprise Guide, Base SAS).
• Maintained user account profiles and managed user group roles.

Confidential, Manhattan, KS

IT Planning Coordinator/Student System Coordinator

Responsibilities:

• Responsible for the oversight of Information Technology projects for the Information Systems Office at Confidential .
• Coordinated functional leads for the PeopleSoft Student Information System. This included documentation, security administration support, and data analysis and administration.
• Developed a project prioritization methodology for the entire IT organization.

Confidential, Lawrence, KS

Financial Systems Administrator

Responsibilities:

• Responsible for the implementation, configuration and support of the PeopleSoft Financials and Grants modules.
• Served as a co-lead on the project to upgrade PeopleSoft Financials.
• Served as Project Manager for all internal financial system projects. Met routinely with all levels of management and staff to determine business needs, develop requirements and write system specifications.
• Developed an automated financial reporting suite using PeopleSoft nVision.
• Managed the setup and configuration for all of the PeopleSoft Financials and Grants modules implemented for the research business unit.
• Trained staff on newly developed software or changes to existing systems.
• Functioned as the primary liaison between IT and end-users within the organization

Confidential, Lawrence, KS

IT Administrator

Responsibilities:

• Administered bank’s website and on-line banking cash management software.
• Developed an internal program for various software programs utilized by the bank.
• Developed customized commission reporting tools for loan department.
• Interacted with various types of users, ranging from customers to officers and the Board of Directors, to effectively manage all of the bank’s software projects.

Confidential, Lenexa, KS

Sr. Project Manager

Responsibilities:

• Served as the lead Business Analyst/Project manager for the design and implementation of an automated freight billing audit system.
• Managed development of Accounts Payable, Collections and Billing systems, including the implementation of on-line payment and credit checking through Dun & Bradstreet.
• Supervised Quality Assurance and EDI staff.
• Routinely loaded freight carrier data via SQL.
• Troubleshoot data and provide ad-hoc reporting analysis via SQL.