PROFESSIONAL EXPERIENCE

Confidential

Associate BI Cognos Developer

• Build and run reports using IBM Cognos Software
• Create complex reports that require the creation of multiple queries in one report
• Troubleshoot non-functional reports
• Work with the Business Analysts to turn their criteria into a functional report
• Analysis of Cognos Data
• Basic SQL writing in Toad
• Assist the ETL developers with the Siebel Oracle system to determine what tables and linking's are needed to help them create packages

Business Data Analyst

• Build and run reports on Siebel Oracle using Crystal Reports for Sales Management
• Analysis of Cognos Data
• Basic SQL writing to create links in the Siebel system to allow the end users a brief count of items that need to be reviewed.
• Collaborated with Sales Management on gathering their report requirements

GSF System Administrator

• Receive and act on requests for maintenance, updates and testing on the Siebel Enterprise Application CRMS .
• Performs functions to ensure the continued operation and streamlining of the CRMS application for internal and external support for over 2000 clients.
• Build and run reports on CRMS using Crystal Reports and Access.
• Work with the tech support groups to troubleshoot report and Magellan Siebel issues
• Contact users in order to replicate the steps needed to reproduce errors they are experiencing

Confidential

• Mental Health Technology and Project Specialist
• Collaborates with staff to develop, implement, and maintain departmental database, information and outcomes systems. Develops reports to meet internal needs for information tracking and reporting including but not limited to productivity, intake, quarterly outcomes and operational plans. Develops reports for external contracts and other external purposes as needed i.e.: United Way .
• Serves as liaison to IT Department. Collaborates with IT staff to ensure that hardware/software applications are meeting departmental needs.
• Assumes departmental technical responsibility for Quality Improvement, ensuring that all Quality Improvement tasks, functions and assignments are addressed.

Mental Health Support Team Leader

• Responsible for daily work assignment and oversight of Mental Health Services Administrative Support Staff functions including Medical Records, Data Entry, Team Support and Auditing.
• Responsible for notifying clients regarding lapses in Medicaid insurance coverage and works with Billing Department and family to resolve lapses.
• Responsible to assist the Program Operations Manager in the development and updating of policies and procedures relating to all administrative service functions and responsibilities.
• Responsible for maintaining and updating administrative service productivity reports by tracking and measuring performance against established standards. Reviews, monitors and tracks all administrative service performance standards and prepares, distributes and reports individual productivity statistics to Program Operations Manager weekly.

Application/Database Specialist

Confidential

• Collaborates with staff to develop and implement agency application/database systems.
• Provides training to agency staff in the use of databases and agency supported software.
• Provides help desk support to agency staff on the use of applications.
• Structures information processes to ensure that information flow in practice is accurately captured by electronic systems. Initiates business process development initiatives as necessary.
• Collaborates with other IT staff to ensure the hardware/software applications are meeting agency needs and to reach resolution of staff problems concerning agency applications.
• Maintaining the agency website.

Confidential

Application Analyst II

• Collaborated with customer Cincinnati Bell to investigate needs for new development on the AS/400 Billing System.
• Analysized the new development that needed for requirement documentation.
• Managed the requirements for new development and corresponding call command to be issued.
• Analysized the data from the new development and verified all results.
• Verified all current process was running properly during testing procedures.
• Documented new development for all the appropriate departments affected by the testing procedures.
• Supported and directed the AS/400 Billing System, along with the Outside Billing Vendor.
• Liaison with internal/external customers on new report requirements assisting with business analysis.
• Developed Crystal monthly report to provide tracking stats on trouble tickets in the Support Magic system. New report provided daily statistics on a consistent basis.
• Maintained existing Crystal reports such as the daily activity reports, Variance account reports.
• Analysized the reports for data accuracy which minimized errors.
• Conducted troubleshooting techniques for new user problems by implementing new sign on procedures and incorrect data on reports
• Handled Quality Assurance Testing on new projects developed for the AS/400 Billing System.

Billing Production Analyst

Confidential

• Worked with customer to investigation needs for new development on the AS/400 Billing System.
• Analysized the new development that needed for requirement documentation.
• Communicated expected results and test scenarios with programmers on new development.
• Managed the requirements for new development and corresponding call command to be issued.
• Analysized the data from the new development and verified all results.
• Verified all current process was running properly during testing procedures.
• Handled Quality Assurance testing on all new projects developed for the AS/400 Billing System.
• Supported and managed the AS/400 Billing System, along with the Outside Billing Vendor.

Customer Service

Confidential

• Evaluated customer accounts to see if there was a better long distance product for them.
• Handled collections calls for customers that were 60, 90 and 120 days. Data entry for new customer accounts.
• Investigated customer's problems dialing long distance.