Keely Collier

San Antonio, TX

Summary:

Over *1 years Business Data Analyst experience.

Over 5 years Project Management experience.

** ***** ** **********.

Draft business requirements documentation.

Object oriented development/applications skill.

Experienced in MS Office Suite, Finance/General Accounting, Record Management System, Vlookups, SQL, Developed queries using Oracle 9i, PL/SQL, SQL Server, MSAccess, Reporting, Rapid Application Development (RAD) Methodology and SDLC.

Education

Keller Graduate School of Management

Project Management Master 2015

W/Distinction

DeVry University

BS, Computer Information Systems 2003

Summa cum Laude

University of Texas at San Antonio

BS, Political Science 1987

Professional Experience

Phenom San Antonio LLP San Antonio,TX Nov 2017– Present

Project Manager/ Sr. Business Data Analyst

Responsibilities for managing application project systems and Business requirement specifications (SRS) from the initial Kick-off phase to the post sign-off implementation phase for several vendors. Developed reports for Tech Skills on Wheels, Nissi Corporate Training Solutions, and The Inspiration Center.

Eliciting requirements, creating test plans, creating test cases that cover all requirements.

Executing system testing and facilitating user acceptance testing.

Interfacing with appropriate IT teams to resolve defects found during testing.

Steering project requesters to standardized solutions.

Responsibilities also included gathering business requirements and building programming specification for the creation of the applications and Crystal Enterprise v XI. Conducted weekly JAD sessions, end-user requirements workshops, and interviewing techniques.

Produced and presented using the following tools: Microsoft 365 Suite (Word, Excel (Pivot Tables), Powerpiont, Access DB and Sharepoint).

Worked with several Schools in the SAISD creating a platform for encouraging college readiness in the area STEM (Science, Technology, Engineering, and Math) curriculum.

Citibank San Antonio, TX Mar 2017– Oct 2017

Project Manager/ Sr. Business Data Analyst

Created a positive client experience, by focusing on the client’s perspective; supporting their needs; and prioritizing the CRM mission with partners and stakeholders

Supported the relationship and the CRM Lead by creating Client Relationship Analytics (CRA) business decks and Power Point presentations

Provided the client with visibility into the GIDA services they received and made them aware of any systematic issues GIDA encountered

Worked with Financial Applications using Excel and other Microsoft suite tools in alignment with Agile processes.

Prepared documentation and analytics that presented the business needs and impact to GIDA Operations

Support the GPO – CRM & Business Advisory in meetings, and ad hoc requirements related to Client Relations

Participated in regular meetings with other CRM analysts and CRM Leads within the product for knowledge sharing and standardization purposes

Worked in partnership with on-site Service Delivery Managers / Operation Teams

Worked with Economic Capital Risk Modeling skill-sets Created joins on tables and views on an Access database, using custom formulas, sub reports, and parameterized reporting.

ITIL Incident reporting and Training and Implementation.

ITIL Knowledge Management Process and ERP support tools

Facilitated partner meetings, documented minutes, client responsiveness and reported progress

Produced and presented using the following tools: Microsoft Suite (Word, Excel (Pivot Tables), Powerpiont, Access DB and Sharepoint).

Nissi Corporate Training Solutions LLC, San Antonio, TX Nov 2014 – Mar 2017

Project Manager/ Sr. Business Data Analyst

Develop Business Requirements and Program Specifications for clients.

Analyzed data and created reports for peers and upper management.

Perform Visual Basic and JAVA enhancements to front-end applications.

Assist with Conceptual / Functional Specifications using Rapid Application Development (RAD) Methodology and SDLC.

Worked with Financial Applications using Excel and other Microsoft suite tools.

Assist with technical artifacts which were deemed necessary for traceability.

Created Test Plans / Cases for quality assurance maximization.

Produced reports.

Created joins on tables and views on an Access database, using custom formulas, sub reports, and parameterized reporting. Incorporated custom functions.

City of San Antonio / San Antonio Police Department, San Antonio, TX Nov 2013 – Oct 2014

Senior Data Analyst/ALM Business Manager

Assisted the Project Manager with various projects ranging from concept to closure.

Worked on various special projects for the City of San Antonio/San Antonio Police Department was very instrumental in the DWI (Driving While Intoxicated) project. Used Agile (Sprints) for some of the small projects

Assisted with the (RFCSP) Request for Competitive Sealed Proposal process.

Created business analysis management plans for special projects in compliance with State and local standards. In addition, created users stories, test schedules and managed tester during Quality Control/Quality Assurance sessions.

Created several joins on tables and views on an Access database, using both standard / custom formulas, sub reports, and parameterized reporting. Exposed to ETL /Agile and Teradata

ITIL Incident reporting and ITIL Knowledge Management Process (Training and/or Implementation)

Managed unit testing, systems integration testing and user acceptance testing pre upgrade. Provided a Black box/White box testing methodology.

Gathered reporting SQL scripts writing and used advanced Excel tools (Vlookups and Pivot Tables).

Bank of New York Mellon, San Antonio, TX Jul 2012 – Jul 2013

Business Data Analyst

Provided technical training to upper management and core team of Business Analysts stateside and abroad.

Decommissioned 10 legacy systems and migrated to one all-encompassing system.

Worked with Financial Applications using Excel and other Microsoft suite tools.

Exposed to IBM Unica 8.0 and ITIL procedures also and ERP support tools

Trained end users to test the functionality of the new system.

Nissi Kinte Investments, LLC, Arlington, TX Jan 2008 – Jul 2012

Business Data Analyst/Programmer

Develop Business Requirements and Program Specifications for clients.

Analyzed data and created reports for upper management.

Perform Visual Basic and JAVA enhancements to front-end applications.

Assist with Conceptual / Functional Specifications using Rapid Application Development (RAD) Methodology and SDLC.

Assist with technical artifacts which were deemed necessary for traceability.

Created Test Plans / Cases for quality assurance maximization.

Produced reports in SQL Server, MS Excel and MS Access.

Arlington ISD, Arlington, TX Oct 2003 – Oct 2007

Junior High School Reading Teacher (Highly Qualified Grades 4-8)

Taught reading/comprehension strategies crucial for students to maximize scores on state-mandated exams.

Co-taught English, History, Science, and Math classes.

DC Technologies, Irving, TX Oct 2002 – Sep 2003

Business Data Analyst (BA)/Programmer

Developed Business Requirements Document (BRD) and Program Specifications for third-party vendors.

Queried Oracle 8i, SQL Server, and MS Access; using simple to intermediate-level joins. Reports were generated from these queries.

Performed Visual Basic and JAVA enhancements to front-end business applications.

Worked with Financial Applications using Excel and other Microsoft suite tools.

Wrote User Manual and documented procedures.

Created Test Plans and Test Cases for quality assurance maximization.

Previous Employment:

DC Technologies, Part Time Entry Level Programmer Oct 2001 – Jul 2002

Bank of America, Credit Card Specialist Mar 2003 – Aug 2003

DeVry University, Faculty Assistant Nov 2000 – Mar 2003

Verizon, Business Data Analyst Oct 1997 – Oct 1999

Austin Legal Assistance Services, Legal Assistant Aug 1991 – Aug 1999

USAA Business Analyst 1985 – 1990

Contact this candidate