Carol Allain Email & Phone Number

Rolling Meadows, Il, Us

Bowie, Md, Us

Tampa, Fl, Us

Boston, Massachusetts, Us

• Self-trained to use the RxSense Client-portal and associated database tables in order to provide root-cause analysis of client data and processing issues. • Initiated a more streamlined SOP process, creating and maintaining formal data layouts and documentation for onboarding new client pharmacy claim eligibility data.• Worked directly with external clients to assist with incoming pharmacy eligibility data for pre- and post-implementation. In-depth data analysis required my expert knowledge of T-SQL, Excel, and ETL tools to import and merge various sources of data against RxSense’s client portal’s system database. • Heavy data analysis required for creating bug tickets into Jira as well as providing input into priorities during our daily Agile stand-up meetings.Position Eliminated due to reorganization

Lisle, Il, Us

* Improved data efficiency and results, heavy use of T-SQL and ETL (Extract-Transform-Load) via SSIS to import and merge many different sources of data into one output for easier reporting in Excel or as for import into other reporting tools. * Working very close with many different departments to set up more streamlined processes within the SQL data processing and provided much needed documentation. The end result provided more accurate data in a much more timely and accurate manner.* Set up new SFTP data transfers for a new corporate-wide endeavor to replace their legacy source systems. This required heavy use T-SQL within SSMS and SSIS to set up more streamlined processes to make their job functions more efficient and accurate.* Being a huge proponent of documentation, took it upon myself to clean up old, outdated information and produced a more detailed approach to the analyses required. This resulted in my finding and fixing data issues and setting up regular automated tasks to complete items faster than originally designed.Position Eliminated

Beverly, Massachusetts, Us

* Triaging issue tickets from the prior production roll-out. * Organizing all documentation in order to prepare for a Global migration of expense tracking data. * Using Toad on an Oracle-based system to determine data issues supplied from 3rd party vendors.* Key responsibilities with full-scale Quality Assurance Testing and assisting with User Acceptance Testing on all data fixes or upgrades.*Project Contract completed 12/31/2015

Schaumburg, Illinois, Us

* Within Specialty Pharmacy, Briova Rx, provided Business Systems Analysis and Data Analysis for 20+ ad-hoc reporting into Excel projects using Oracle SQL via Toad for Oracle. This required initial in-depth data analysis against pharmacy data from within a 3rd-party system, ScriptMed by Creehan and excellent communication skills for off-site End-Users. This data included, but is not limited to, prescription data, financial data, and survey information. * Huge effort to build new, more efficient data tables, including the automation of importing and integrating outside Excel data in order to incorporate additional information in relation to the pharmacy data. * Final project was utilizing SQL Server 2008 to build data tables, and parameterized Store Procedures in an effort to reduced the number of steps required to make processing the reports more efficient for those settting up the Tableau reports.*Project Contract completed 3/27/2015

Chicago, Illinois, Us

*Project Contract Canceled prior to initial 18month sign-on due to dept. reorg. * Assisted the US Operations Restaurant Technology Team to provide analysis of the efforts associated with the various product upgrades and enhancements. These products are required to go through internal system quality testing for hardware and software before they are installed in the McDonald's restaurants.* Streamlined documentation revolving around data for manual testing efforts and Business-User analysis reporting. * Worked on defining a high-level strategic plan that defines the department's testing efforts for better tracking by upper-management. * Began the data conversion from current MS Access and Excel into a more streamlined SQL Server database.

Addison, Il, Us

Decided to pursue a different career path.Continue the work I started as a Contractor-To-Hire with the additional responsibilities of:* Working with the New Web team to adapt business processes to learning new systems in which the company direction is heading in order to lead those in my group in understanding how the new systems operate.

Bellevue, Washington, Us

Brought in as a Contract-To-Hire position in a Technical Business Analyst capacity to utilize my technical and business skills to determine and document the many gaps that exist between the two in-house Direct-Sell Consultant web-based systems.* Provide Business Requirement Documents for various ad-hoc requests as well as be a part of the seasonal changeover that occurs in this type of business. * Responsible for coordinating the many manually processed E-Mails that are sent out to the Direct-Sell Consultants that alert them to upcoming promotions, incentives, or awards achieved. * Responsible for assisting the Quality Assurance areas with data retrieval and analysis as needed for accurate testing and assistance with User-Acceptance Testing(UAT).

Buffalo Grove, Il, Us

My position was eliminated after only a few short months.* Using SQL Server 2005 and SQL Server 2008 SSIS and SSRS, responsible for investigating and fixing issues with data processing jobs in which printing jobs containing personalized-client information are dependent upon.* Responsible for modifying and creating new reports that allow both internal and external clients to analyze data and purchases made for personalized print material.* Solely responsible for documenting all processes using flowcharts and outlines for upcoming conversion to SQL Server 2008.

Chicago, Il, Us

This short-term project completed as scheduled.* Responsible for building an interface data between data stored on Oracle tables and the Legal Department’s Case Management System, TeamConnect Enterprise System by Mitratech, which has data stored on SQL Server 2008. This involves working with multiple departments for requirements gathering and heavy data analyses within both SQL Server and Oracle tables in addition to building SSIS DTS Packages in order to pass data from Oracle into SQL Server. * Responsible for documenting all interface processes as well as testing and reporting all defects within HP Quality Center

Addison, Il, Us

This position was sadly cancelled after only 30 days.Responsible for documenting the current manual data processing functionalities and providing a way via SQL Server 2005 SSIS to automatically produce the 10-15 various data files needed for gift card processing for various clients and third-party processors.

Glen Allen, Va, Us

This project was cancelled after the PBM department was sold.* Responsible for the initial triage of incoming incidents and/or defects and incoming user requests for the PBM (Pharmacy Benefits Manager) system. * Responsible for prioritization, assignment, tracking, and completion of incoming incidents/defects, and/or user requests in regards to this PBM system. * Responsible for Reviewing/Approving the clarity/completeness of the Business Requirements which has on occasion included the process of gathering Business Requirements in order to create Functional Design Documentation in regards to Medical Part D enhancements required by government mandated guidelines proposed from CMS (Center for Medicare/Medicaid Services).* Using JIRA and Confluence to maintain dialogue on project work as well as using it to maintain documentation.

Chicago, Il, Us

I left this downtown Chicago company for a closer commute and better opportunities.* Saved the company many hundreds of hours of manual labor by automating the manual processes initially used to gather and produce data and reporting. * Work with business users to gather requirements, code using Oracle and/or T-SQL, test and implement reports to meet business information needs. * Responsible for daily operations of the Actuarial data-marts including, but not limited to, the creation and maintenance of data tables using T-SQL within SQL Server 2000 Stored Enterprise Manager and SQL Query Analyzer. * Heavy usage of DTS Packages to extract data from the corporate Oracle database in order to bring data into SQL Server 2000. * Initiate and conduct all detailed documentation of all processes, databases, and reports. * Responsible for maintaining the Risk Management Reporting ASP website which allows the Business Users to execute pre-determined queries that satisfy their reoccurring business needs.

My portion of this project was completed as expected within the allotted time provided. * Solely involved in the requirements gathering process which involved working with an off-site End-User via e-mail and phone to determine the desired functionality of a tracking system that would budget then monitor the expenditures of grant monies provided by the Federal Government to various Illinois Public Health Departments, Hospitals, and non-profit / private organizations. * All correspondence documentation was presented in a high-level flowchart in order to give the End-User a high-level picture of how the future system would function. * Use Cases, and screen layouts were incorporated into a System Requirements Specification (SRS) document within a strict two-week basis over the course of a 4-month period. * Acted as a liaison between the IT developer and the End-User to ensure that all functional requirements were completed properly. * Provided assistance to the Project Manager to help in determining the Project Schedule, Work Breakdown Structure (WBS), and identifying key risks as well as assisting in the maintenance of the Issue Log.* Provided some of my programming expertise to the developer in order to assist him in the creation of a mock-up system.

Orland Park, Illinois, Us

This 10-week short-term project was completed as expected.* Assisted the Project Manager in working with business unit End-Users to gather functional requirements that would greatly improve the functionality of a Cash Reporting WebFOCUS on-line/intranet application . * Modified this existing application using mainframe FOCUS, Dialogue Manager, JavaScript and HTML. * Provided documentation which consisted of outlines, flowcharts, and an End-User instructional document.* Created manual test cases for approval by End-Users to follow during User Acceptance Testing (UAT) to make sure that all deliverables were met on-time and on-budget for this tightly scheduled 10-week project.

Chicago, Il, Us

My position was eliminated. * Utilized Information Builders Business Intelligence(BI) / Reporting software WebFOCUS, including its core FOCUS and Dialogue Manager programming languages, along with HTML and JavaScript to develop various intranet applications that reported sales based on information provided on data-entry screens. - All data was extracted from DB2. - Reports were displayed on the intranet Business Intelligence Dashboards (BIDs). - Reports provided the ability to drill-down to PDF and Excel from within the HTML report. - Set up automated scheduling of these report generations using the WF Report Caster scheduling tool with report delivery being posted on the BID’s or e-mailed directly to the End-User. * Developed training materials in order to conduct in-house classroom training to train 70 Business Users to use the WebFOCUS Report Assistant tool saving the company approximately $20k in training dollars within a two-month timeframe and countless hours of IT labor. * Provided constant and dedicated support to these 70 Business Users by assisting them with their Report Assistant usage ensuring that the queries were streamlined and efficient in order to keep hardware running efficiently as well. * Key involvement with the Sales Data Warehousing consulting teams, assisting with the streamlining of data so that it can be accessed via WebFOCUS in a more efficient manner. * All systems created required participation and management of all phases of the Systems Development and Analysis Life Cycle (SDLC) in order to capture and document business requirements, develop program specifications, develop test plans, perform all levels of testing, and assist with production implementation.

Northfield, Il, Us

I left this position to pursue a long-term direct-hire closer to home and with great opportunities to grow and learn.* Possess knowledge at retrieving data from SAP via SQL+ within the WebFOCUS environment.* Utilized WebFOCUS, core FOCUS, Dialogue Manager, HTML, and JavaScript to develop various programs that report data extracted from various sources such as SAP, Oracle, DB2, and SQL Server in order to produce summary reports on the intranet in HTML, PDF, or Microsoft Excel formats. These reports also provided pivot tables to summarize Excel data or drill-down capabilities so that the Business Users could get to more defined details of the data being requested. * All systems created required the management and/of all phases of the Systems Development and Analysis Life Cycle in order to capture and document business requirements, develop program specifications, test plans and perform all levels of testing.

I left this position to move into a direct-hire position.Programming Languages / Software: WebFOCUS, core FOCUS, Dialogue Manager; HTML; JavaScript; SQL Server 2000 Enterprise Manager and Query Analyzer, MS SQL; DB2. Other

Northbrook, Il, Us

Bachelor Of Science-Computer Science, Management Information Systems

High School Diploma, Computers, Math, And Science