We provide IT Staff Augmentation Services!

Business Analyst Resume

San Antonio, TexaS

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

Hire Now