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