SUMMARY:

• Highly detail - oriented with excellent communication and documentation skills.
• Expertise in analyzing business requirements and transforming them into technical solutions.
• Knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
• Technical proficiency in database design, business modeling and software application development.
• Configure and manage data security on Enterprise Data warehouse, Data marts and interfaces.
• ERP knowledge on Oracle 11g and its new utilities including BI Server, Answers, Delivers and Publisher.
• Knowledge of SQL and Data mining concepts using Oracle SQL Developer, Toad and Microsoft SQL.
• Proficient in Microsoft suite of products including MS Word, MS Excel (Vlookups, Pivots), PowerPoint and MS Visio
• Extensive knowledge of Sage ERP Solutions (MAS 90, MAS 500)
• Extensive Knowledge in developing Crystal Reports
• Extensive knowledge of Tableau server, Tableau Server and Tableau Reader.
• Ability to prioritize and remain focused.

TECHNICAL SKILLS:

• OBIEE 11g, Oracle.
• Financial Software (MAS 500, ORACLE GL/AP/AR, MIMS,S2K)
• Intermediate SQL
• MS OFFICE ((Word, Access, Excel, Power Point, Outlook)
• Waterfall, Agile, SDLC
• Tableau, Salesforce,
• MS SQL Server Management Studio tools.

PROFESSIONAL EXPERIENCE:

Confidential, Frisco, Texas

Sr. Business Analyst

Responsibilities:

• Work cross-functionally on departmental performance related to Cash, A/R follow-ups and patient/Insurance refunds.
• Communicates effectively with all levels in the organization including internal/external customers.
• Participate in various integration options using Tableau Desktop, Tableau Server and Tableau Reader to minimize overall end user licensing requirements.
• Prepare Dashboards and visualization using calculations, parameters in Tableau
• Performs data analysis, with data modeling exposure.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration
• Extensive knowledge in various reporting objects like Hierarchies, Facts, Attributes, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau. OBIEE.
• Apply problem-solving and process engineering skills to remap existing process flows to increase efficiency and to minimize processing errors.
• Participate in internal and external meetings to discuss ongoing trends and issues regarding the administration of front end revenue cycle processes.
• Act as a mentor and coach to other team members across the organization.
• Develop financial models and financial analysis for insurance and patient payments.

Confidential, Dallas, Texas

Business Analyst

Responsibilities:

• Participated in the creation of complex financial reports and application programs to retrieve data as requested.
• Proactively collaborated with team to create efficiencies in data retrieval and analysis, improves the quality of information and data integrity, and ensures proper documentation of all reports
• Support client bad debt reporting and analysis.
• Review procedures created by Operations Analyst and recommend revisions as needed.
• Develop and maintain procedures and documentation for the users of the reports and applications created by the reporting team.
• Identify critical process opportunities for enhancement and propose tangible solutions to avoid repeatable errors.
• Complete special projects and provide project support as requested by senior leadership
• Performed data extraction from SQL Server databases by utilizing the full suite of MS SQL Server Management Studio tools; MS Access; and MS Excel
• Participation in Market Operations Councils.

Confidential, Frisco, Texas

Business Analyst 

Responsibilities:

• Part of the Oracle North America business intelligence team.
• Extensively gathered requirements from all users, experts, and key personnel to understand the current functionality of the existing system.
• Participated in the development of the business process transformation vision and strategies by assisting with the implementation of best practices and efficient operations of the organization
• Served as the Applications developer developing the solutions agreed upon by Business.
• Perform data mining utilizing Oracle SQL developer and MySQL.
• Provided ad-hoc analytics reporting for business by using Oracle OBIEE platforms.
• Researched best industry practices and implemented best practices via template and process improvement.

Confidential, Irving, Texas

Billing & Cash Posting Manager

Responsibilities:

• Verify payment accuracy based on a contract with payors and prospective payment rates
• Review contracts for appeals and refund requests
• Audits and analyzes managed care reimbursement of patient accounts
• Created data up-loads/data feeds in the billing system.
• Actively participated in special projects related to process automation and various process improvements initiatives.
• Designed and implemented internal Sales commission payment process and approval..
• Fully responsible for tracking and reporting key performance metrics for senior management.
• Assigned system super user access and acted as internal resource for system issues and user access/security changes.

Confidential, Irving, TX

Corporate Accountant/Analyst 

Responsibilities:

• Book revenue and expense journal entries.
• Prepare Monthly Financial Pack that Includes Balance Sheet, Cash Flow Statement and Income Statement
• Preform month-end revenue and expense accruals.
• Perform General Ledger and Balance Sheet reconciliations.
• Handle complex inter-company transactions.
• Process Fixed Assets Depreciation
• Update Lease amortization schedule
• Prepare monthly Prepaids Amortization Schedule.
• Extensive research on reconciling items.