Analytics TeamResponsibilities include all aspects of performance reporting.

Text book database development for 4th through 12th grade charter school English, Math, Science and Social Studies curriculum. 4 week project.

Environment: LAN, Microsoft Windows, Cloud Tools: Salesforce CRM, CVM Solutions, Excel, Word, Microsoft 365, Outlook• Responsible for reviewing and analyzing data integrity in CVM Solutions and Salesforce CRM databases• Processed and updated CVM and Salesforce databases with member certification and re-certification application submissions.• Updated and maintained Excel membership spreadsheets.• Created Work Instructions for entering new member certifications and recertification in Salesforce.

Environment: IBM, LAN, Oracle Tools: MS Access, SAS-JMP, QUMAS®, TrackWise®, JDE, Cognos (Query & Report Studio), MS Excel, Word, Visio, WinLIMS, NuGenesis, Powerpoint, MS Project, ScienTek, Livelinks, OpEx, Data ExplorerQuality Assurance - Regulatory Compliance Department• Developed Access Database Data Entry system that served as a repository for Production, DoE and Confirmation Batch Record data for statistical analysis. • Created and maintained Product Status files - Excel based data repository used for statistical analysis, evaluations, investigations, CAPAs, root cause analysis, Product Scorecards and User requests. • Performed trend analysis of analytical data using SAS JMP and Excel. • Created and modified Laboratory Information Management System (LIMS) APR report configurations in order to generate and download analytical test results by product. • Used WinLIMS Data Explorer for creating SQL for data extraction. • Ran Crystal Reports to generate data for statistical analysis and reports.• Extracted data from JDE to create reports for Manufacturing Annual Product Review reports (APR). • Created Packaging Annual Product Review reports (APR). • Created and updated Standard Operating Procedures (SOPs), process flows and workflow instructions related to Product Status files. • Created and executed test cases for verifying data integrity for the migration of Product Status Excel spreadsheets to reports utilizing Cognos, (Query & Report Studio), part of the Corporate Oracle Data Warehouse. • Query, ETL and Adhoc file and report generation from multiple systems. • Operational Excellence Certified White Belt (OpEx). • Responsible for reviewing and analyzing data integrity

Environment: IBM, LAN, Oracle Tools: MS Access, SAS-JMP, QUMAS®, TrackWise®, JDE, Cognos (Query & Report Studio), MS Excel, Word, Visio, LIMS, NuGenesis, Powerpoint, MS Project, ScienTek, Data ExplorerStatistics Department• Performed trend analysis of analytical data using SAS JMP and Excel. • Generated Product stability graphs for Annual Product Review reports(APRs). • Assisted in the development of Product Historical Overall Assessment Reports. • Microsoft Access System design, development, implementation, enhancement, maintenance. • Created Standard Operating Procedures (SOP) for the Microsoft Access Database System that served as a repository for Quality Control Analytical Data for statistical use. • Created and executed test cases for verifying data integrity for the migration of the Product Status Excel spreadsheets to reports utilizing Cognos, (Query & Report Studio), part of the Corporate Data Warehouse. • Responsible for reviewing and analyzing data integrity• Developed an Access Database Data Entry system that served as a repository for Production, DoE and Confirmation Batch Record data for statistical analysis for the Diltia 052 Optimization Project, Cartia B2B Project and Metoprolol and other commercial products. • Built and managed a team of 6 individuals during the data entry process for the Diltia 052 Optimization Project. • Developed an Access Database system for tracking the daily status and tasks related to TWRs (Trackwise Reports), assigned to members of the Quality Investigations and CAPA Team. • Assisted with the generation of Annual Product Reviews,(APR).• Assisted in the generation of Monthly Product Scorecards.• Created and maintained Product Status Excel Managed Spreadsheet files.• Created and maintained Stability files utilizing data download from ScienTek Stability system.• Created work instructions for various application utilized by the department.

Environment: IBM, LAN Tools: Visual Basic, MS Access, PeopleSoft, JDE, QUMAS®, MS Excel, MS Word, Visio, Technical Services/ Process Development Department• Created and revised Experimental and Packaging Batch record documents. • Small Systems Development - Microsoft Access System design, development, implementation, enhancement and maintenance of User online screen and reporting Database System for tracking FDA submission Packaging, R&D and Experimental Batch Records and QC Results. • Enhancement and maintenance of online screen and reporting Database System for document number assignment and tracking of Product Justification, Development, Evaluation and Validation Protocols and Reports. • Generated Purchasing Requisitions utilizing JD Edwards System.• Updated department's employees time in PeopleSoft HR Payroll system. • Adhere to CGMP’s, SOP’s and OSHA guidelines.• Tracked and maintained Sample Swab results for production equipment.• Created Cleaning Validation protocols and reports. • Enhanced the department’s Microsoft Access database system for maintaining the swab results for the cleaning and validation of equipment by developing user-friendly data entry screens and reports.

Environment: COBOL II, IBM MVS, IMS, DB2 Tools: COBOL II, IMS DB/DC, DB2/SQL, TSO, JCL, File-Aid, OS/2, MS Word, SPUFI, MS Excel, Visio, Outlook 2000, Access 2000Served as a Quality Assurance Programmer Analyst on the Order to Deliver II (OTD2) and Customer Knowledge System I (CKS) Implementation Projects• Analysis, programming, and maintenance of the Customer Database using DB2 and COBOL II and SAS. • Created test scenarios and cases, generated SQL.• Executed test cases during the testing process.• Conducted test case reviews. • Developed and maintained Microsoft Access based Defect Tracking System in order to generate Daily Defect Tracking reports, and Daily and Weekly Integration Test Team’s Status Reports. • Assisted in editing the Integration Test Team's Testing Strategy documents and the System Integration Test Plans.

Environment: COBOL II, IBM MVS, IMS, DB2 Tools: MVS, JES2, TSO/ISPF, IMS, MS Word, MS Excel, Oracle Office, MS Windows, JCL, File-Aid IMS, File-Aid MVS, DataAger, ONNET Host Suite 5.0, Hiperstation.Served as Test Factory Lead Tester on the 8 week CVC project. The project involved Y2K compliance testing of Edison's Customer Vending and Conservation application (CVC). The CVC application allowed the Customer Information department (CI) to communicate with the Family Independence Agency (FIA). It enrolled and terminated customers in the FIA based on data from CI. CVC also updated CI with the FIA information and posted payments to CI accounts. The CVC application also maintained nine databases and generated letters and reports.Responsibilities included: • Documentation - Creation of a Statement of Work document, Y2K Date Aging Assessment document, Weekly Team Status Report, CVC Meeting Minutes, and written communication to Users concerning the CVC application testing.• Aging the dates on batch input files and on Edison's IMS CASE enrollment database utilizing FileAid/DataAger. • Aging the Hiperstation Scripts used in the testing of the CVC application in Edison's Silver Lab.

Environment: COBOL, Meta COBOL, DataCom Tools: COBOL, Meta COBOL, DataCom, IDEAL, MVS, IMS, JCL, JES2, TSO/ISPF, QMF, MS Word, QMF, MS Excel, Visual Basic, Visio, AccessResponsibilities included: • Analysis, design, develop and maintenance of Meta COBOL and COBOL programs.• Developed Data Com online screens utilizing IDEAL.• Created documentation for Data Com online screens.

Environment: COBOL II, IBM MVS, IMS, DB2 Tools: MVS, JES2, TSO/ISPF, IMS, CHAMP, File-Aid, LAN, CA7, SPUFI, SQL, QMF, Visual Basic, Control-M, TELON, WordPerfect, Excel, Roadmap, CMM 2, and SLCResponsibilities included: • Analysis, programming, and maintenance of the Customer Database using DB2 and VS COBOL II.

Environment: COBOL II, IBM MVS, IMS, DB2, Oracle, Unix Tools: Oracle 7.1.3, SLC3, LAN/WAN, PL/SQL, SQL*PLUS 3.1, MS Project Plan, SQL, Visio 4.0, Crystal Reporting 4.5, Oracle data Browser 2.0, Excel, Designer/2000-2.5, Developer (Forms & Reports), InPower Tools 3.2, SLC, QMF, Visual Basic, MS Word, WordPerfectResponsibilities Included: • Technical design of AAM’s InPower HR/Payroll system and Labor Events Secured Employment Level Tracking (SEL) module.• Creation and maintenance of AAM’s InPower HR/Payroll Crystal and Oracle Reports.• Setup and maintenance of AAM’s InPower HR/Payroll Security Profiles and report for User access. • Report generation during the InPower Unit and Systems Test process.

Environment: COBOL, MVS, CICS, Assembly Language, LifeCom Tools: MVS, JES3, TSO/ISPF, CICS, Pan Valet, File-Aid, LAN, ART, OS/2, WordPerfect, Excel, Design 1, Project WorkBench, MS WordResponsibilities included: • COBOL programming and maintenance.• Analysis, design and creation and maintenance of French and English Canadian Insurance policies utilizing the LifeCom Database.

Environment: COBOL II, IBM MVS, IMS, DB2, SAS Tools: MVS, JES3, TSO/ISPF, IMS/DC, Pan Valet, File-Aid, LAN, CA7, OS/2, WordPerfect, Excel, Micro Focus COBOL II WorkBench and SLCResponsibilities included:• Programming, analysis and updating the Red Carpet Lease Customer Database using SAS, DB2 and VS COBOL II.

Environment: COBOL, IBM MVS, CICS, DB2, SAS, PeopleSoft Tools: MVS/XA, JES2, VTAM, TSO/ISPF, CICS, LAN, CA7, Easytrieve Plus, PIE/CICS, PIE/TSO, VPS, SAS, PeopleSoft HR/Payroll, DB2, COBOL, SQL, SQR WordPerfect, Excel, Micro Focus COBOL II WorkBench and SLCResponsibilities included: • COBOL programming and maintenance of the University's payroll and general ledger systems.• Integration of CICS, DB2 and PeopleSoft HR/Payroll systems with existing systems at the University using SAS, VS COBOL II, SQL and SQR. • Provided computer usage training for the User communality at Western.• Performed data analysis following information engineering methodologies using CASE tools.

Environment: COBOL, IBM MVS, CICS, DB2, SAS Tools: MVS/XA, JES2, VTAM, TSO/ISPF, CICS, CA7, DMS/OS, Easytrieve Plus, Keyfast, Omegamon, SAS, VPSResponsibilities included: • Operation and system monitoring.• Processed Staff and Student Payroll and General Ledger.• Helpdesk problem logging and documentation. • JCL set-up, • System backups/restores.• IPL’ing the System.• Documentation of Operator's SOP manual, shift schedules and General Ledger process.