Post Job Free

Resume

Sign in

Management Software

Location:
Allentown, PA
Posted:
July 01, 2015

Contact this candidate

Resume:

Tisha Braxton

**** ******* *****

Bethlehem, Pennsylvania 18020

610-***-****

Email: acqjae@r.postjobfree.com

Objective: To obtain a progressively challenging position that will utilize my diversified technical and professional skills, as well as my strong organizational skills and ability to work well with people.

Computer Skills:

SQL Server COGNOS SAP Revitas (I-Many CARS)

Microsoft Office Suite MS Project MS Visio SharePoint

Oracle SDLC CMDB Sarbanes-Oxley (SOX)

GE ConnectR Ariba IDX Validata

EHR Service Now BMC Remedy Lotus Notes

ECP WinZip WS-FTP Pro

Professional Experience:

METLIFE, Bridgewater, NJ

METRICS DATA CONSULTANT II, October 2013 – Present

Run complex reports on schedule and provide data analysis prior to delivery to the business management using Cognos and MS Access.

Maintain databases, ensure integrity of data, and remain current on applicable business functions and technology tools.

Develop and document work instructions for the Cognos Report Management Process for the development and management team showing how to promote reports from the Development environment to the Production environment.

Track, analyze, and report Cognos operational metrics information to management and business partners.

Ensure individuals have accurate security access for the Cognos environment that is needed.

Consult with business partners to determine data reporting, analysis, and timing needed for current and future reports.

Ensure all marketing survey reports are produced and published to the SharePoint site on a timely basis.

ALLIANCE LIFE SCIENCES CONSULTING GROUP, Somerset, NJ

BUSINESS ANAYST, August 2012 – September 2013

Developed and documented requirements and contract modeling for implementing Revitas (I-Many CARS) enterprise wide system for managed care contracts.

Responsible for interpreting customer business needs and translating them into operational requirements, and working with developers to ensure the requirements were met.

Responsible for evaluating, analyzing, development, testing, reporting, and support of the enterprise wide Revitas CARS system implementation thru the entire software development life cycle (SDLC).

Created before and after process flow diagrams to document the impact of implementing the new Revitas system.

Responsible for performing data validation, contract validation, test script creation, user acceptance testing, and creating training and system design specification documentation.

Performed system training for Validata and the new Revitas system to the customer.

Created map sets, validation rules, severity rules, aberrant quantities rules, and segments for Validata.

Created spreadsheets for all contracts to be implemented into the new systems.

Created and maintain reports for Validata and Revitas.

JOHNSON & JOHNSON INFORMATION TECHNOLOGY SERVICES, Raritan, NJ

I/T ASSET MANAGER, August 2011 – August 2012

Updated asset events throughout the entire IT asset lifecycle from procurement to retirement in the Configuration Management Database, ensuring accurate and complete accounting of both hardware and software assets.

Implemented a new global enterprise wide CMDB throughout Johnson & Johnson. Responsible for performing data validation, user acceptance testing, and creating training documentation.

Worked with Finance to ensure all expired assets were removed from all financial books, including the general ledger.

Acted as a liaison between the HP Vendor and Johnson & Johnson to communicate all pertinent information dealing with HP’s contract requirements, such as reconciliation dates, entitlements, contract renewals, discrepancies, and regulatory issues.

Became familiar with all contracts language and performed monthly reconciliations with the HP vendor to ensure all asset inventory was captured and in compliance with the support contract requirements.

Planned and forecasted the budgets of all hardware and software asset projects using roadmap spreadsheets.

Ensured change management process is followed when new assets or changes to existing assets were added to the system.

Developed reports using SQL and MS Excel to ensure accuracy of all assets in the system.

Managed all global contract purchase orders that came thru the Ariba system.

Provided customers and management with prompt responses and resolutions to urgent production problems.

Developed new documentation where necessary to support all asset management and configuration processes.

SANOFI-AVENTIS, Bridgewater, NJ

CONTRACTS ANALYST, August 2007 – August 2011

Managed all aspects of managed care regional and national customers, GPOs, long term care, and oncology customers contracts including analyzing terms and conditions to set up contracts, plan membership, contract amendments and discount structure maintenance appropriately using iMany CARS.

Verified all products, memberships, and plan data submitted by the customer complies with contract requirements and consult with customer and account managers to resolve any discrepancies.

Created trending analysis reports for account managers to present to customers and upper management for contract renewals using MS Access and COGNOS query cube reporting.

Analyzed chargebacks and rebates payments utilizing reporting tools to compare variances of quarterly sales, quarterly rebates, utilization and market share trends.

Built and maintained metrics, dashboards, and reports used to track contract and payment statuses.

Verified all rebate and chargeback payment checks were produced and issued to customers using SAP FI Module.

Loaded prescription data utilization submitted by customer into the data pre-processor (ECP) within allotted timeframe of submission receipt.

Processed the calculation of quarterly and monthly market share payments using IMS data and ensured the market share trends were in line with product expectation using MS Excel and MS Access.

Developed and document test plans, test scripts and test data, as well as performed data validation and user acceptance testing on new and existing software and applications.

Analyzed rebate overpayments to determine the cause and work with customers to ensure amount overpaid is retrieved without conflict.

Performed membership analysis on GPO members to assign appropriate class of trade and contract eligibility and randomly audit members to ensure members meet eligibility criteria.

Analyzed and processed quarterly administrative fees associated with GPO contracts.

Documented SOPs for the rebate and payment processes for knowledge transfer to peers.

Participated in Account Team Meetings to develop and maintain excellent working relationships with customers and account managers.

Performed Wholesale Acquisition Pricing (WAC) changes to products when necessary.

Maintained ongoing communication with Contract Assessment, Contract Development, Finance, Legal, and IT.

Prepared budget and Sarbanes-Oxley reports for upper management.

Supported and comply with all Sarbanes-Oxley requirements.

JOHNSON & JOHNSON HEALTH CARE SYSTEMS INC., Piscataway, NJ

SENIOR FINANCIAL ANALYST, October 2006 – July 2007

Managed contract rebates for pharmaceutical companies, hospitals, and managed care facilities that use Johnson & Johnson health care services.

Communicated effectively with all pharmaceutical companies, hospitals, and managed care facilities that use Johnson & Johnson health care services.

Analyzed incoming contracts and amendments to ensure accuracy and timely loading of contracts through the contract systems.

Gathered, analyzed and processed data as it pertains to the rebate and payment processes using MS Access, MS Excel, and COGNOS query cubes.

Provided customers with prompt response and resolution to urgent production problems.

Processed payment contracts to identify all that qualify for rebates.

Documented SOPs for the rebate and payment processes for knowledge transfer to peers.

Validated rebate adjustments and exceptions using MS Access and MS Excel formulas and researched problems that arose.

Performed regression and user acceptance testing on new and existing software and applications.

Ran and reformatted reports using MS Access and COGNOS BI on customers contract product and pricing to process payments and validate rebate adjustments and exceptions.

Worked with Finance and Accounts Payable to calculate and validate rebate amounts and process checks to send out to all that qualify for a rebate.

Complied with all SOPs and compliance standards as it pertains to the rebate and payment processes.

CITIGROUP CORPORATE AND INVESTMENT BANK, Warren, NJ

BUSINESS ANALYST, July 2005 October 2006

Collected and analyzed metrics across GFITech and execute monthly reporting within MS Access and MS Excel of all GFITech activities.

Assisted in the development and implementation of policies and procedures to enhance the control environment and the management of risks by fostering process improvements including quality, efficiency and effectiveness of the SOX testing processes.

Created and enhanced processes to ensure compliance with Self-Assessment and Operational Risk Policies and Procedures, Information Securities Policies, and Continuity of Business Policies by performing SOX control tests.

Prepare detailed documentation of testing performed in compliance with requirements of SOX 404.

Guided and educated internal business users about the importance of software license compliance.

Developed documentation for GFITech Software License Management.

Ensured all key risks and related control processes are identified and adequately monitored using MS Access.

Investigated effective resources and cost estimation to enable business partners to reach their stated goals and objectives.

Coordinated vendor engagements and problem reporting to ensure effective problem resolution.

Performed regression and user acceptance testing on new and existing software and applications.

Developed and improved workflows and business processes to enhance use and adoption of technology solutions.

Developed and presented proposals and recommendations for work plans to all levels of audiences, including management and executives.

Developed appropriate documentation and presentations in support of initiatives.

Documented the implementation of all new applications and the problems/solutions with existing ones.

CHUBB GROUP OF INSURANCE COMPANIES, Warren, NJ

BUSINESS SYSTEMS ANALYST, February 2001-May 2005

Project leader on an enterprise wide Asset Management Inventory project which saved the entire Chubb Corporation over 2.5 million dollars by implementing a system using MS Access and MS Excel of reclaiming unlicensed copies of software from users and servers. Responsible for data reporting and manipulation within MS Access, user communications, software removal execution, and reporting the final results for the initiative using MS Access and Excel.

Appointed to install and configure the Niku application on 2 servers. Created, administered, developed business requirements, and budget scorecard for the application in both the test and production environments. Documented the installation and configuration process for knowledge transfer to peers. Performed application training to all customers using the application.

Responsible for interpreting customer business needs and translating them into operational requirements, and working with developers to ensure the requirements were met.

Implemented product enhancements through the entire software development life cycle (SDLC).

Created before and after process flow diagrams to document the impact of implementing new applications.

Managed project timelines by using Microsoft Project.

Coordinated vendor engagements and problem reporting to ensure effective problem resolution.

Consulted with business customers and developers to analyze the requirements on the implementation of applications into the Infrastructure throughout the entire software development life cycle (SDLC).

Created specifications detailing the functional and business requirements for new applications and/or new functionality in existing applications.

Developed and documented test plans, test scripts and test data.

Performed regression and user acceptance testing on new and existing software and applications.

Researched effective resources and cost estimation from both the business and technology perceptive to recommend new products or upgrades to existing ones.

Primary support for all patch management and patch security issues associated with Microsoft Office Suites.

Installed all critical patches associated with Microsoft Office Suite.

Prepared budget and Sarbanes-Oxley reports for upper management.

Performed network tests on new applications to ensure bandwidth availability and network performance.

Developed stored procedures using Structured Query Language (SQL) to perform testing of new applications.

Ensured the transition of applications throughout the entire development life cycle.

Documented the implementation of all new applications and the problems/solutions with existing ones.

Developed a monthly management report for all upper management.

DUN AND BRADSTREET CORPORATION, Murray Hill, New Jersey

SENIOR SYSTEMS ANALYST, June 1998-January 2001

Responsible for developing and testing mission critical enterprise software solutions including Enterprise Application Integration, Web Services and enterprise portals.

Daily activities included integration with vendor products and Kaiser provided solutions. Debugging these solutions and documenting results.

Created test plans, executed test plans, and documented results of tests plans.

Upgraded Access 2.0 databases to Access 97.

Maintained maintenance, security, backups, recovery, and support on the Hyperion application and Access database.

Updated Hyperion database daily to mirror the Oracle General Ledger database during the monthly accounting close.

Analyzed Business Groups and Customers requirements, procedures, and problems to help automate processing and improve existing systems.

Supported production process of the databases involving sales, revenue and budget changes.

Designed and tested reports for the Oracle application using Structured Query Language.

Developed and documented test plans for reports in the Oracle database.

Analyzed and resolved day-to-day problems with Oracle and Hyperion applications.

Developed a monthly management report for all upper management.

THE PRUDENTIAL INSURANCE COMPANY OF AMERICA, Newark, New Jersey

PROGRAMMER ANALYST, June 1997-June 1998

Developed stored procedures using Structured Query Language for the Financial Reporting System.

Designed and tested reports for the Financial Reporting System using Smartstream Reporting, Crystal Reports, Microsoft Access, and Structured Query Language.

Designed and tested reports for the Financial Reporting System using Smartstream Reporting, Microsoft Access, and Structured Query Language.

Developed and documented test plans for the reports in the Financial Reporting System.

Analyzed Business Groups requirements, procedures, and problems to help automate processing and improve existing systems.

Automated job streams through the use of Smartstream Job Scheduler.

Loaded daily allocations to the appropriate databases.

Supported production processing of actual allocations and budget.

Involved in Year 2000 compliance testing and upgrading current applications for Year 2000.

Education:

MORGAN STATE UNIVERSITY, Baltimore, MD

Information Science and Systems

Bachelor’s of Science Degree

RARITAN VALLEY COMMUNITY COLLEGE, Branchburg, NJ

Electronic Health Record Program



Contact this candidate