SUMMARY:

• Ability to create new SharePoint 2013 sites, adding and configuring libraries, lists, site settings, navigation, search and assigning permissions and access rights
• Using SQL Server Management Studio 2012 and SSRS, knowledge of creating tables, inserting data, modifying/manipulating table structure, and correlating subqueries
• Experienced Business Analyst with more than 10 years of experience in the fields of Information Technology, Organization, System and Quality Analysis
• Conducted review sessions on a regular basis with QA and development teams for preparing status and delivery of operational reports
• Diverse experience includes developing reporting and procedural standards
• Adept at developing models for inventory and purchasing, establishing protocol for inventory analysis, conducting SQL testing, and creating ad hoc reporting procedures, Data Marts
• Skilled in converting legacy reports to more contemporary programs such as Crystal Reports, Business Objects, Excel, Access, Tableau and SQL, and condensing number of reports to simplify processes
• Defined and documented process flows for a databases

TECHNICAL KNOWLEDGE:

SharePoint 2013

SQL Server Management Studio 2012 and SSRS

Tableau

Account Receivable and Payable Reporting and Analysis

ERP Software Packages (Microsoft Dynamics, Oracle E - Business Suite, SAP Business One)

Crystal/Business Objects Reports

Office Suite including Access, Excel, Word, Project, Outlook

Experienced in developing spreadsheets including Pivot Tables, V-Look Ups, etc.

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, Texas

Business Analyst

Responsibilities:

• Prepared strategic trend reports to measure KPI, and indicated to management Key Performance indicators
• Established project plans in accordance with project management framework
• Reported on relevant research in support of all Business Segments in an effort to provide in - depth reporting analysis
• Analyzed company performance versus competitors and industry benchmarks
• Defined and documented business needs and objectives, current operational procedures/problems, input/output requirements as to ensure in competitiveness and positive performance
• Created month end reports and procedures

Confidential, Fort Sam Houston, Texas

Operations and Planning Specialist

Responsibilities:

• Analyzed and reviewed a wide variety of related operations and recommended changes to improve efficiency, while prioritizing a large volume of data and daily required assignments
• Defined and executed quality metrics and reporting procedures
• Managed numerous projects relating to reporting and analysis of DoD MEDCOM data
• Performed qualitative and quantitative analysis from databases by performing complex retrieval of medical data from standard DoD databases utilizing SQL/SSRS, MS Access, MS Excel and additional applications, connecting via ODBC, for further customization and more efficient data analysis
• Using SharePoint 2013, created a new site and inserted an Excel Dashboard for SharePoint users
• Added and configured SharePoint lists, sites, and created custom forms
• Configured SharePoint Site Administrating Settings
• In SQL Server 12, created tables with constraints, modified table structure and created back ups
• Inserted data in established and newly created SQL tables
• Developed table views for database users
• Utilized Tableau and SAP Business One for Reporting
• Resolved issues or Pain Points that were relevant to processing large amounts of data

Business Analyst

Confidential, San Antonio, Texas

Responsibilities:

• Performed ad hoc analysis and research on client practice and office developmental opportunities
• Developed a standard, structured and best practice approach to the selection of new technology including client security
• Created CRM database to prepare firms legal directory submissions for relevant representative works
• Independently scoped and managed time sensitive projects from start to completion

Confidential, San Antonio, Texas

Senior Financial Analyst

Responsibilities:

• Analyzed Charge Account Data in relation to metrics such as RBRVS and RVU’s
• Utilized Oracle E-Business and Tableau for Operational and Financial Reporting
• Involved with financial/billing analysis of Medicare Advantage (MAPD)
• Established Corporate table structure for reporting to management utilizing SQL/SSRS, Crystal Reports, Excel and Access
• Interacted with all departments at the facility as well as centralized support departments such Vanguard, information systems, accounting, billing, office, etc. to insure accurate reporting, and departmental communication
• Created Dashboards using Crystal and Business Objects Reports for Financial reporting
• Assisted in the management of a Workflow application for automation of business processes

Business Analyst

Confidential, San Antonio, Texas

Responsibilities:

• Created Technical Business Rules for the Data Migration Project, which assisted the Project Management team with present and future development goals
• Utilizing MS Visio, mapped the Data Migration processes to facilitate the Data Architect in creating accurate strategies
• Gathered requirement information and provided Technical Writing experience to analyze into clear documentation for executive members and staff
• Combined numerous reports into manageable quantity
• Provided Executive Reporting using SQL in adjacent to Crystal Reports 2008 to provide accurate Financial Statements; therefore, diminishing the report time
• Joined and sub selected data to retrieve from stated SQL Server Performed a merge into Crystal Reports Also converted and merged into SQL Enterprise
• Developed Business Object Reports
• Created procedures and reports to assist employees within the US to track marketing and inventory resources
• Developed models for Inventory and Purchasing-(Physical Count, Transaction History and Reordering)
• Created reports and Dashboards utilizing Excel
• Converted all legacy databases into SAS 9.1 Reporting adjacent to Crystal/Business Object Reporting

Confidential, San Antonio, Texas

Business/Financial Reporting Analyst

Responsibilities:

• Performed Analyst services for company providing wound healing technology to the medical industry
• Provided communication for Oracle conversion within the department and to the rest of the company concerning government rules and regulations for HIPPA
• Performed GAPP/Data and Cost Analysis of accounting programs, using Account Payable data, and additional Oracle applications for financial reporting
• Billed HCFA 1500 forms and Medicare/Medicaid Electronic Funds Transfer, Electronic Sum Transfer and Electronic Invoicing using a Clearing House
• Defined and documented process flows for Oracle 9i and 11i for Billing
• Developed reporting and procedural standards for financial/reporting statements
• Conducted a crosswalk between the Billing Application and the HIPAA Implementation Guide
• Provided EDI interfaces with Commercial and Government Insurance Payers that included Medicare and Medicaid