Angel L. Knotts - Ccent, Itil, Pm, Sas Email and Phone Number

• Collaborated with the Financial Investigation Unit on Mandatory project identifying and eliminating process gaps • Analyzed and documented highly sensitive processes into a home-grown application (MPL) which automated how processes, databases and views would be negatively affected if necessary data could not be received. • Identified the source of data, data owners, how the data is processed, storage space required for data storage.• Became the SME for around 100 tables/views for audit validation, inquires and required documentation. • Utilized SQL to gain intimate knowledge the data quality, data format, purpose of each column/field in every table/view.• Worked with developers to identify data sources, create timelines of events for Audit and create attainable goals as it relates to automating manual load process • Created, collaborated and became the SME for required documents such as BRD, HLD and other process documents.• Documented current and projected future training requirements, data flow and overall team structure via MPL, Word and Visio.• Assisted in the Metadata documentation and inquiries relating to naming conventions, definitions, and overall purpose.• Assisted incoming contractors with understanding the data, processes and transitioning into the team • Contracted via Signature Consultants

• Works Streams included - 2 Technical refreshes - Oracle DAN refresh and SQL DAN refresh- Configuration management- Get Qualys reports and remediate as needed- OAR project (Oracle Audit Remediation) which has 19 workstreams- Database vault which is an Oracle tool that requests access for DBAs on certain databases- SQL remediation project - access and separation of duties - DBAA (database authentication access) project - seeing when access is appropriate and when its not- Cyber risk projects- Enterprise patching program project - creating automated tasks to move from patching twice a year to every 90 days on the databases• My daily responsibilities revolved around implementation which included:- Daily meetings on the 6 - 7 work streams in which I create requirements for, and met with PMs and the SMEs on these projects to gather the requirements and documents needed for implementation- Worked with the Enterprise Security teams to ensure the audit remediation projects occurred databases, SQL and Oracle.- Writing communication to DBAs that include the BRDs and FRDS that have the specs for the projects. - Created training/planning collaboration for DBAs- Participated in the pilots for difficult implementation process to identify observe forecasted obstacles- Deciphered which type of reporting is needed per workstream- Use home grown application, DB Smart, which is their system of record used to store the data on the databases in EDM• Contracted via TekSystems

• Analyzed the banks Consumer Lending and Data Warehouse (The W) data via SQL & SAS queries on the Teradata Platform.• Reviewed recently approved Project Charters and Business scopes for department impact and estimated size and resources needed. • Worked large scale agile integration projects with downstream customers that have required waterfall testing procedures • Identified underlying principles, reasons, or facts of information by recognizing differences or similarities, and detecting changes in circumstances or events.• Tabulated and submitted initial estimates based on complexity of tables, new/ remediated fields, transformation logic etc.• Oversaw all aspects of the project, worked closely with upper management, data custodian, data owner, architect, general ledger, as well as other departments to ensure communications, deadlines and deliverables met the customers’ expectations.• Created documents such as bulletins, High Level Design (HLD), Traceability, Validation Test Plans, Change Controls, Project defect, Business Requirements Documents (BRD), etc.• Utilized analytical skills to analyze data, make design decisions, and solve problems that come up during a typical work day.• Researched, verified and validated production and test data to determine whether systems or processes have met validation criteria or to identify root causes of production problems.• Created test scripts for the performance qualification processes to ensure compliance with internal or regulatory requirements. • Reconciled identified amount fields to the banks General Ledger within banks required projects. • Data Mapping Specifications such as data migration, data integration, data lineage and simple transformation logic. • Metadata Specifications such as creation, remediation, and clean-up.• Monitored data daily from testing phase, thru deployment and the warranty period, also responsible for the deliverable sign-off. • Contracted Via TekSystems

• Involved in all aspects of the GIS-IAM Key Controls: Provisioning, Authentication, Authorization, Review, and De-provisioning. The OnBoarding to CSDB was directly involved in all 5 Controls & UAT.• Analyzed in many highly sensitive Applications (App). Some Apps intel over 3.4 million resources.• Analyzed in the OnBoarding of hundreds of applications in the Central Security Database (CSDB).• Managed and Trained incoming employees in application testing, GIS-IAM Key Controls & stakeholder relationships.• Collaborated with stakeholders, identified system requirements, beta testing, deliverables, freeze date & milestones.• Key member responsible for onboarding resource entitlements, determining the appropriate method, transmission. mainframe file formats, entitlement descriptions, and reporting accuracy for all resources required into the CSDB.• Responsible for guiding application teams through the development, testing, and delivery of finite requirements.• Worked with a SQL Server focused team utilizing Agile Methodology to deliver an alternative solution to CSDB onboarding such as Cloud.• Administered the Enterprise Access Review Tool to create and generate reports for entitlement review.• Led meetings with application teams to define and clarify the process, timeline, and to assist in troubleshooting as needed.• Coordinate internal resources and third parties/vendors for the flawless execution of project and stakeholder satisfaction.• Develop a detailed project plan to execute, monitor and track progress ensuring technical feasibility.• Manage changes to the project scope, project schedule, end-user testing & project costs.• Abided by the corporate governance framework and utilizing design requirement document (DRD).• Contracted via Signature Consultants

• Serve as the Laboratory Supervisor designee as it relates to project for up to 25 employees.• Oversaw hundreds of mini projects that ensure international customers were well informed and received researched deliverables in timely manner.• Scheduling and coordination of projects to provide problems solving solutions to increase productivity.• Synthesizing raw data into actionable insights.• Responsible for the accuracy, integrity and transfer of test results.• Perform complex analysis on reagent usage thereby increasing reagent yield.• Monitor and ensure data entry is accurate in vendor database.• Executes proposals while providing immediate and accurate feedback to director and vendor.• Closely monitors new procedures providing detailed analysis and quality check of all work completed.• Utilize both SQL & SAS to organize, standardize and manage data.

• Initiate, plan, execute, monitor and close a project which successfully increased retention of students discharged due to positive drug screens within Job Core.• Collaborate with several departments to ensure a flexible, ease of use, comprehensive deliverable which met all the stakeholders desired goals.• Identifying gaps and opportunities for improvements among existing processes and reports.• Monitored and maintained databases and ensured data was reliable.• Trained operations as to Extraction of quantifiable & qualifiable data sets via SQL queries for data merge & interpretation.• Planned, organized and directed administrative and technical functions of the lab.• Configuring resource assignment matrix, RACI chart, and complex spreadsheets.• Organized, and interpreted numerical data and analysis of population characteristics.• Issued recommendations to director for patients by performing detailed analysis of all related data and documentation.• Assisted in additional processes and procedures implemented thereby resulted in a lower number of patients with positive screens further increasing student retention.• Oversaw most day-to-day procedures and met Federal Department of Labor expectations.• Worked collaboratively with owner and offsite lab directors as it relates to stakeholder satisfaction.• Transition deliverable to operations team.

• Key initiatives include data consolidation, legacy network migration and modernization efforts.• Increased productivity by 430% thereby skyrocketing profits.• Initiated, Planned, and executed administrative and technical functions of the lab.• Streamed lined processes such as preparation of samples, instrument, sample testing and reading.• Oversaw day-to-day operations ensuring a seamless transition.• Supervised personnel, conducted and oversaw quality assurance and quality control • Resolved project conflict and managed vendor relationships.• Performed complex analysis on urinalysis samples.• Worked collaboratively with key stakeholders and lab director to ensure timely compliant deliverables.• Analyzed and evaluated chemical and microscopic components while reviewing initial and final data results to ensure. quality deliverables.

• Collaborated with team to determine requirements and strategized technical solutions.• Restructured functionality of designs to ensure accurate translation and universally accurate testing.• Integration of UGA and Nanjing data sets utilizing SQL queries; Data merging & Metadata. • Trouble shoot an agar gel that would effectively allow only BFB to grow in test environments • Formulated over 10 different agar gels

• Contributed researcher for an NSF grant project entitled “PIRE: Genetics of Invasive Species Exchanged Between the Southeastern U.S. and China, Taiwan and Hong Kong”.• Utilized Metadata techniques to locate the when and by whom a particular set of data was collected.• Data analysis & SAS Studio to merge & formulate data in a tabular form.• Summarized scientific data into basic terminology for all audiences.• Utilized data analysis to gain an understanding and theorize possible environmental solutions.• Designed statistical models to provide insights.• Applied technical knowledge in determining locations of different species.• Utilized quantitative research to generalize hypothesis results from a sample to the population.• Traveled through 20+ cities throughout China in search of specific invasive plants.• Achieved significant progress in locating a reagent that worked best with the invasive plant kudzu.• Summarize scientific data into basic terminology for all audiences• Utilized data analysis to gain an understanding and theorize possible environmental solutions • Design statistical models to provide insights • Applied technical knowledge in determining locations of different species • Utilized quantitative research to generalize hypothesis results from a sample to the population • Traveled through 20+ cities throughout China in search of specific invasive plants• Significant progress in locating a reagent that worked best with the invasive plant kudzu • Utilize contemporary testing methodologies to process DNA of Kudzu (pueraria plant) & perform procedures for PCR, nanodrop of DNA concentration• Actively participated in the collection and preservation of thousands of samples

• Collaborated with Discovery place Planning and Executing creative lesson plans and projects for STEM program.• Taught Math, Science and STEM program• Assisted teachers in accomplishing daily goals

star talk is a government funded program that assists students in learning new languages • Collaborated with University and teachers to ensure successful program• Assisted in teaching intermediate Chinese to high school students• Tutored students in need of attention• Worked one on one with students vocabulary and pronunciation

Observer of Genome Sequencing Analyst II • Performed basic molecular lab duties in a high throughput sequencing lab• Collaborated with various research areas• Observed the set up and operation of the automated DNA sequencing machines and DNA sequencing process

Contract position• Communicated with customers and businesses in helping fulfill their financial needs • Accomplished in wholesale and retail products• Team leader in sales• Collaborated with manager in building team morale

Top 10 sales person for two of my three month careerAfter watching the company downsize for two months straight I felt that It was in my best interest to change careers.

• Communicated with customers and businesses in helping fulfill their financial needs • Accomplished in wholesale and retail products• Team leader in sales• Collaborated with manager in building team morale

• Top in sales• Designed creative, budget conscious, ways to emphasize our appreciation for our employees, involving contacting venders, scheduling times and locations, making travel arrangements and created PowerPoint presentations• Collaborated with the Education Department in creating employee training and process development • Developed and delivered training presentations• Assisted the acting manager • Assisted in new Bilingual Department adjusting and understanding insurance production (2006) • Advisory Committee (2005) and appointed people to meet with the Division Manager• Volunteered as a first notice of loss (2004 – 2005), Recognition Committee (2003 – 2004)

Transferred to Electronics Department (which consisted of protecting Wal-Mart's Major assets)Elevated to the lost prevention team Also worked on the district level: Shoe department redesign