Nicole Shoop Email & Phone Number

San Diego, California, Us

Epic certified in COGITO, Clarity, and Caboodle report writing. Assist the team with tickets for emails, reports, Excel.

San Diego, California, Us

Responsible for assisting the Revenue Cycle Applications Project and Development team with- gathering and documenting specifications from stakeholders of all levels (end users to leadership) via meetings and workflow shadowing- designing and working closely with the developers by validating financial, data analytic, and productivity reports- presenting and obtaining approvals of the final reporting for the Hospital Revenue Cycle Applications department from leadership- generating ad hoc data based on extracts from Epic Hyperspace and Clarity, as well as from MS SQL Server Manager, using SQL and VBA Macros within Microsoft Excel

Consultant in the Revenue Cycle Applications department.

New York, Ny, Us

Consulting Business Analyst for the Dealer Financial Services department at AHFC. Projects include:-As lead Business Analyst, gathering requirements, assisting with scope documentation, designing, testing, and implementing a legacy system upgrade and enhancements project.-Directly working with 3rd party vendor to implement their product.-Building Access 2010 databases as working interim systems to assist with daily tasks while legacy systems are being upgraded or created, causing vast improvements in productivity with a quick turnaround.Completed projects:-Analyzed existing Access 2003 databases in order to perform necessary upgrades for migration to Windows 7 and Office 2010. Provided recommendations on improving the current process and Access database once the migration has completed.-Assisted the Senior Business Analyst on the reporting project by writing the Requirements documents, assisting the PM with the Scope, working with the developers on the design and development of screens, testing the new environment, creating training sessions and documents.

Long Beach, Ca, Us

Responsible for assisting the Mitsubishi Motors of North America's Incentives Department with supporting the Senior Incentives Specialist and assisting with testing, query building using SQL Analyzer and MS Access, and data validation of the new system being built, as well as assisting with tasks as needed during the new system developmentAlso responsible for assisting the Mitsubishi Motors of North America's Incentives Department with daily, weekly, 10 day, and monthly incentive, lease, and contest payments and awards and for maintaining current and past incentive, lease, and contest information for the United States and Canada. Duties include:Setting up new incentives programs and contests for the U.S.A. and Canada in the legacy system, validating the programs are properly calculating and paying dealer incentives, and completing J-SOX compliance testing for the U.S.A and Canada.Assisting with the review, research and processing of dealer exception requests for incentive monies.Developing and distributing ad-hoc reporting as needed to the zones in Canada and the U.S.A.Performing daily, monthly, quarterly, and annual reporting, filling, and basic administrative tasks such as photocopying and scanning.

Responsible for assisting the Development Director with administrative and general tasks. Duties include:Creating flyers and mailings using Publisher and InDesign.Maintaining the AuctionPay/Greater Giving event database, including generating reports.Creating standard operating procedures for the departmentResponsible for assisting the Development Director and the Parent Group with pre-event, event night, and post-event tasks for the annual fundraising event. Duties included:Creating a customized day planner with ads using Adobe Creative Suite.Working with the volunteer auction team, which includes training of and maintenance of data in the AuctionPay/Greater Giving and BidPal databases.Assisting the Development team with event check-in and auction redemption.Heading the post-event activities, including accounting reconciliations, clean-up, and reporting.Assisting with hardware set-up and clean-up at events, and providing technical assistance as necessary

Responsible for development of working prototype applications using MS Access. Duties included:Gathered requirements and, using VBA and SQL, developed full-scale working beta applications for Warehouse Management, Productivity Tracking, and Sales Bids.Developed technical documentation and user manuals for the new applications.Trained users on new applications upon implementation.

Responsible for the design and development of multiple MS Access database applications. Duties included:As Project Manager, using MS Project to track the status and MS Visio to develop data flows, making recommendations to management on streamlining current procedures, on minimizing existing manual processes, on unifying departments by increasing the communication electronically, and on increasing efficiency and reducing deficiencies.As a Business Analyst, gathering requirements from stakeholders and working closely with users of all levels, and developing reports to measure performance, lead time, and other metrics, and giving the users the ability to develop a customized Ad-Hoc reporting systemAs a Developer, developing technical documentation and training manuals for the new applications, combining all redundant MS Access and MS Excel data sources into unified applications for data sharing purposesAs a Trainer, training users on new applications upon implementation, and training new developers on database design and development using SQL code and VBA programmingProjects:Production requirements tracking system for Publishing, which created a smooth transition of shared data between the five Publishing departments. Increased communications by unifying the process into one system, reduced paper output by 80%, and increased efficiencies 95% due to automation of processes.Work Package Tracking application, which was a process improvement that converted a manual task to a semi-automated task, increasing productivity by over 70%.TXT to XML conversion module, an application that will take a text file and will convert it to XMLAutomation of production for IBM flow sheets runs, an application that will drastically reduce hard copies needed to run data for the production group, eliminate data errors, and will provide simplified troubleshooting in case of data run issues.

Developed an automated process for Continental Data Graphics (CDG) which converted data in a raw flat text file from Boeing into useable data for CDG. This application eliminated the manual process of data entry, which reduced user-based errors 100%, and allowed a 75% faster response time to the final product's output to the customers. It also allowed the users to perform ad-hoc reporting tasks as well as produce canned reports as needed for metrics and billing purposes.

Developed a Microsoft Access application for the Finance Department of a large manufacturer in Luxemburg. This application replaced a manual process significantly reducing workload.Created training manuals and technical documentation.Responsible for automating and streamlining various accounting procedures in Microsoft Access, utilizing VBA and customized SQL queries for reporting purposes in the Cost Accounting department of a large manufacturer.Created three MS Access databases to automate end of month reports for management utilizing the system development life cycle. One database has minimized the run-time from 6 hours to 10 minutes, and the other two have minimized run-time by up to 75%.Developed and reduced workload on Obsolescence reporting from 5 days to 2 days using MS Access and MS Excel 2000/2003.Created a user-friendly ad-hoc querying program in MS Access, where users can create a query by selecting necessary criteria, save it, and recall it to re-run without having to access the backend.Developed formal desktop procedures for each position in the Cost Accounting department.Assisted the Inventory Accounting Director and the Cost Accounting Manager with various research and reporting projects for the Controller's office, the Chief Financial Officer, and the Chief Accounting Officer.Performed quarterly audits on four Sarbanes-Oxley controls.

Responsible for designing, developing, and maintaining multiple Microsoft Access tools utilizing VBA, which were implemented in offices throughout the world, including Tokyo, Singapore, and London for a large manufacturer.Streamlined the procedure for returning materials by creating a secure, automated signature program.Modified and took ownership of a database that generated confidential financial reports for senior management.Developed and implemented a database tool for the Tokyo office that assisted in automating operations in their sales offices. Also wrote a technical and a user manual and provided the training.Assisted in the development and implementation of various Microsoft Access tools used by the Customer Service Department.Responsible for the administration and maintenance of user access and intranet and extranet content.Managed tasks for all incidents relating to the extranet and intranet, delegating projects as needed to the various regions worldwide.Compiled quarterly statistical reports for management review.Trained users on posting content and created user manuals on various levels of administrative access.Participated in demonstrations of the intranet for the sales reps within the company.

Responsible for troubleshooting and maintaining the Microsoft Access database application with Oracle ODBC back-end for generation of Faculty Contracts at a large university.Significantly increased the performance of the existing database by re-designing the structure, tables, and forms.Trained users and created instruction manuals and technical documentation.Installed the database and related software (MS Access and Oracle Client) to the users' computers.Supervised a student assistant.Converted the database from Access 97 to Access 2000.Responsible for assisting the Vice President and the Director of Faculty Affairs with special projects that held tight deadlines.Compiled confidential data into Excel from the school's CIRS system using FOCUS programming and created complex spreadsheet reports using macros and VBA programming.

Assisted in creating a Microsoft Access front-end database application with Oracle ODBC connected back-end for the School of Management's Advisement Center at a large university.Converted raw data from flat, DOS-based PFS tables into normalized relational tables within Access.Designed, developed, and implemented the tool into a multi-user environment.Trained users and created user and technical manuals.

Masters Degree, Information Systems

Bachelor'S Degree, Business Administration And Management, General

Bs Degree, Business Administration/Cis