SENIOR BUSINESS ANALYST Resume Burbank, CA - Hire IT People

SUMMARY

Information Technology specialist with over 17 years of experience who combines a strong Development and solid Systems Analyst background in design and developing Applications, mapping and converting data into
ORACLE database, extensive knowledge in SQL and PL/SQL programming, writing store procedures, functions and design advanced Crystal Reports. Able to work well under pressure and is a good team player.

TECHNICAL SKILLS

Reporting Tools: Crystal Enterprise Reporting System, Corticon Rules Engine, Business Object/Crystal reports 11/SAP SE, Business Objects

Database: MS SQL Server, Oracle 12c/11i/10g, Tools Microsoft Access; Excel, SQL Developer; PLSQL Developer MS

Operating Systems: VMS, Windows 8/7/XP/

Languages: COBOL, BASIC, C++, HTML, XML Version

Control: Win CVS, Smart CVS.

PROFESSIONAL EXPERIENCE

Confidential, Burbank, CA

SENIOR BUSINESS ANALYST

Responsibilities:

Worked as Data Warehouse Analyst to track performance, loads and errors through overnight batch processes;
Participated in conversion process to migrate Legacy data into new Eligibility system;
Mapped data into ORACLE database and generate conversion SQL scripts;
Designed script in order to update configuration of the Claim systems based on new DOL regulations;
Point person to generate reports for the Board of Trustees for their quarterly Board meetings as well as other meetings.
Participated in Claims project to replace ICD - 9 into ICD-10 codes;
Generated numerous SQL scripts to extract data requested by QA team or executive management;
Provided any and all statistics and reports related to potential merger between the SAG Health Plan and the AFTRA Health Fund;
Generated Crystal Reports for Executive Management as well as all departments including Eligibility, Accounts Receivable, Contribution Compliance and Medical Claims. Reports are based on the user requirements to help the users with day-to-day tasks as well as tracking the adjuster productivity and efficiency. All reports follow team standards and development methodology from the specifications in order to meet the user expectations;
Administrated Enterprise Reporting System with configuration, distributions, deployments, tracking errors and re-starting services;
Deployed all requested reports through Enterprise Reporting System (SAP Business Object Enterprise) set up connections, distribution lists, configure and schedule reports to run at specific times based on the end-users request. Reports are generated in Excel or .pdf;
Use Corticon Rules Engine to design eligibility rules in order to determinate potential costs involved with any future Benefit Changes, generate Views and Crystal reports to identify current differences between the life Eligibility system and the test systems to ensure the rules in both systems provide the correct results;
Ran data extractions for the annual claims audit, participant census and the annual audit;

MANAGER CLAIMS HEALTH CARE SYSTEMS

Confidential

Responsibilities:

Administrated Claim systems through ORACLE database to track performance, maintain user security, and audit all claims processes including importing and exporting batches;
Generated PL/SQL scripts and store procedurals to change Health Benefits;
Configured system based on new Health Plan rules and regulations;
Design and developed Crystal Reports based on the user requirements to provide claims statistics, system performance, adjuster productivity, workflow and audit information to Claims Management;
Design and developed the process for the Hospital Discount project;
Researched and provided data for the Claims Appeals Department.

SENIOR DEVELOPER

Confidential

Responsibilities:

Part of design team tasked with creating all functionality for the Accounts Receivable Department based on the user requirement;
Developed in C++ Corporate Share Facilities applications and integrated them with AR Applications, built and deployed executable;
Worked with the QA team to verify results and review all errors and problems;
Responsible for deploying User Interface to the user;
Trained the users about new applications/programs;
Developed Contributions Compliance Application.
COBOL, BASIC programmer on Alpha VMS;
Generated different forms and applications for the various departments;
Tested and corrected any problems following user testing;
Developed FAM and DFAM through Legacy file to embed SQL script;
Created process to update payments information from Legacy files through server (C language)in the Web application (IWR) and Voice System (IVR) through VB script;
Responsible for creating Vendor files from Legacy environment for Medco, VSP, VO, Delta Dental.

We provide IT Staff Augmentation Services!

Senior Business Analyst Resume

Burbank, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship