Data Project
Resume:
RENITA BANKS
**** ********* **** **** *****: 770-***-****
Conyers, GA 30013 Mobile: 404-***-****
Email: *********@*****.***
Professional Summary
Implementation Manager/Senior Business Analyst with 10 years of experience specializing in the management of data; modeling, developing, reporting and overall database and data warehouse management.
Strong experience in the Telecommunications industry.
Hands-on development experience with T-SQL, PL/SQL, Perl Scripting, Crystal Reports and Business Objects.
Strong database knowledge with SQLServer (00’, 05’, 08 R2), Oracle (8i, 9i, 10G, 11I, 12), and Business Objects (XI), Sybase, and Access.
Created Entity Relationship Diagrams (ERD) utilizing TOAD for Conceptual, Logical and Physical data models.
Experience in project management, which includes managing scope and cost for multiple concurrent projects.
Experience with developing and executing use cases and user acceptance testing procedures.
Experience and knowledge of supply chain best practice.
Experience and knowledge of accounting best practice.
Experience with developing SharePoint websites.
Experience in designing User Interfaces.
Experience working with Informatica to synchronize data from different systems.
Experience working with Oracle R12 EBS
Solid experience working with COGNOS reporting
Professional Experience
Delta Airlines – Atlanta, GA (08/24/2014 – 11/01/2017)
Lead Business Analyst – Mentor / Implementation Lead – Contract
Formulated and defined systems scope and objectives for complex business systems based on industry best practices
Acted as the liaison among the stakeholders to elicit, analyze, document, communicate and validate business and system requirements using industry leading practices within the business analyst profession.
Ensured all requirements are fulfilled by the technical design.
Reviewed the test plan, test cases and test scripts ensuring traceability to all requirements.
Developed recommendations to improve processes or techniques.
Determined the overall requirements gathering strategy and plans the requirements phase of the project including the work division strategy among the project BAs.
Managed the progress and quality of the requirements gathering activities and adjusts the plan as necessary.
Planned the risk response strategy to be used in monitoring and controlling all identified risks throughout the requirements process.
Lead moderately complex projects and participates in larger, more complex initiatives.
Solved complex technical and operational problems.
Acted as a resource for teammates with less experience.
Oversaw and coordinated the activities of multiple business analysts within a project.
Mentored other Business Analysts.
Conducted best practices around Business Process Model development.
Worked with counterparts to manage the relationship of the IT Team and the Business Partners.
Analyzed, managed, and reported on BA activities.
Managed cross project requirements and escalated issues within specified projects.
Managed program requirement interdependencies.
Requested the needed BA’s for a project and oriented them to work on the project.
Collaborated with developers to plan, design, develop, and deploy new applications and enhancements.
Researched software and hardware products to justify recommendations.
Delivered reports and recommendations to address system issues.
Trained end users.
Produced reports utilizing COGNOS.
Verizon Wireless - Atlanta, GA (January 2013 to 6/27/2014)
Implementation Manager/Senior Business Systems Analyst – Contract
Managed, directed, controlled, and reported on all aspects of scoping, requirements definition, design, development, testing, and deployment of projects.
Conducted JAD sessions and interviews with customer Subject Matter Experts and data stewards to understand the business process, business rules, and overall data requirements.
Participated in continuous improvement efforts to enhance performance and provide increased functionality of the newly created Oracle data warehouse.
Determined testing methods, cycles, phases, and conditions to meet objectives for the IT project.
Coached, mentored and lead personnel within a technical team environment.
Created Functional Approaches, Approach Frameworks, and Technical Design Documents for the Rating Project.
Collaborated with the Developers to ensure code was in alignment with the Functional
Approach documents.
Collaborated with Testing Teams to ensure test plans were in alignment with the Functional Approach documents.
Translated business ideas and data into relational data models utilizing TOAD.
Reviewed Release Notes and code for accuracy to ensure successful implementation for Enterprise Releases.
Created Enterprise Release plans for deployment of code created in the development stage of the Software Development Life Cycle.
Developed and designed SharePoint website.
Created functional approaches and design document for UI.
Assisted Testers with the creation and validation of test plans and pre-UAT testing documentation.
Managed change request processes including facilitating weekly meetings with business and technology teams to assist in timely and quality project completion.
Updated project plans, schedules and estimates.
Worked with project management to establish and communicate project roadmap and milestones.
Served as a liaison between the business stakeholders and the IT development, application and reporting teams with full life-cycle responsibility ensuring successful implementation of solutions that met business needs.
Earthlink - Atlanta, GA (February 2012 to October 2012)
Senior Business Analyst - Contract
Utilized Informatica to perform lookups to synchronize data from different systems.
Modeled, planned, coordinated, and administered Oracle database management systems, including base definition, structure, documentation, requirements, operational guidelines and protection.
Created requirements for the eGate UI.
Developed and designed UI for the eGate portal.
Translated business ideas and data into relational data models utilizing TOAD.
Normalized data to the 3rd and 4th normal form and was able to explain why 3rd may be enough for maximizing database performance.
Analyzed and determined information needs, elements, data relationships, attributes, data flow, storage requirements, data output and reporting capabilities.
Researched and evaluated alternatives and recommended solutions for data integrity.
Lead development and integration of multiple technologies in preparation to launch the online presence of a new telecom customer facing portal.
Managed, directed, controlled, and reported on all aspects of scoping, requirements definition, design, development, testing, and deployment of projects.
Lead a team focused on creating data stores for the new Oracle OLTP Operational Data Mart.
Ensured proper coordination between operational organization and process owners by defining conceptual and contextual levels of detail in the business process data models.
Analyzed source systems for erroneous, duplicative, data to resolve integrity issues related to the data.
Conducted JAD sessions and interviews with customer Subject Matter Experts and data stewards to understand the business process, business rules, and overall data requirements.
Performed data mapping for the integrity of the upstream and downstream data.
Created Use Cases to support the Operational Data Mart initiative.
Developed conceptual data model, taxonomy of terms, and a logical data model for the new Oracle 11g Data Warehouse.
Extracted data for analysis and interpretation using Oracle PL/SQL.
Developed workflows to address data extraction, data validation, data cleanings, data harmonization, business logic, exception handling and required data syndication activities to support Customer’s MDM requirements.
Created ad-hoc reports within the Oracle Data Warehouse utilizing Business Objects XI and PL/SQL Oracle 11g.
Performed validation procedures to ensure data quality.
Acted as data warehouse content expert and interfaced with end users.
Participated in continuous improvement efforts to enhance performance and provide increased functionality of the newly created Oracle data warehouse.
Created Access database to house business and data requirements for multiple projects.
Determined testing methods, cycles, phases, and conditions to meet objectives in the Operational Data Mart project.
Performed system, unit, performance, load, regression, stress and data interface testing for the Operational Data Mart.
AT&T Mobility Wireless, Atlanta, GA (August 2010 to January 2012)
Project Manager/Senior Business Analyst - Contract
Planned, coordinated, and administered database systems, including base definition, structure, documentation, requirements, operational guidelines and protection.
Queried data from Microsoft SQL Server, Oracle, Teradata and IBM DB2.
Developed data models and performed planning of architecture, functions, modules, recovery, standards, and implementation.
Translated business ideas and data into a relational model.
Normalized data to the 3rd and 4th normal form and was able to explain why 3rd may be enough for maximizing database performance.
Managed project with .NET technologies involving the creation of a kiosk to support customers.
Participated in continuous improvement efforts to enhance performance and provide increased functionality.
Lead a team focused on creating data stores.
Tested applications created for the customer merger project.
Managed multiple related projects directed toward strategic business and other organizational objectives.
Worked as an expert in Microsoft SQL Server and SQL Server Analytical Services, Reporting Services and Integration Services.
Built credibility, established rapport, and maintained communication with stakeholders at multiple levels, including those external to the organization.
Defined and initiated projects, and developed work plans to manage cost, schedule, and performance of component projects, while working to ensure the ultimate success and acceptance of the program.
Maintained continuous alignment of program scope with strategic business objectives, and made recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.
Coached, mentored and lead personnel within a technical team environment.
Presented daily Dashboard reports on the current program, future opportunities and client issues.
Translated business ideas and data into a relational model.
Provided business consulting, knowledge expertise in strategic performance management methodologies, process assessment work, and the application of technologies to the business.
Maintained the Sales & Ops Planning SharePoint site.
Translated business ideas and data into a relational model.
Created Use Cases to illustrate behavioral scenarios through one or more functional requirements.
Created ad-hoc reports utilizing various data sources.
Acted as a liaison with customers.
Performed other duties as assigned.
LGR Telecommunications, Atlanta, GA (February 2007 to April 2010)
Senior Business Analyst
Planned, coordinated, and administered database systems, including base definition, structure, documentation, requirements, operational guidelines and protection.
Developed data models and performed planning of architecture, functions, modules, recovery, standards, and implementation.
Worked with internal and external customers to develop and design, build and implement customer enhancements to the CDR reporting tool.
Lead a team focused on creating data stores.
Acted as liaison with customers.
Translated business ideas and data into a relational model.
Normalized data to the 3rd and 4th normal form and was able to explain why 3rd may be enough for maximizing database performance.
Participated in continuous improvement efforts to enhance performance and provide increased functionality.
Worked on change management team to review code and assign resources.
Lead a team focused on creating data stores.
Integrated multiple systems for inputting, processing, interpreting, and storing, for an existing client.
Queried data from Microsoft SQL Server, Oracle, Teradata and IBM DB2.
Coordinated management of multiple related projects directed toward strategic business and other organizational objectives.
Built credibility, established rapport, and maintained communications with AT&T stakeholders at multiple levels.
Worked as an expert in Microsoft SQL Server and SQL Server Analytical Services, Reporting Services and Integration Services.
Maintained continuous alignment of project scope with strategic business objectives, and made recommendations to modify the project to enhance effectiveness toward the business result or strategic intent.
Created functional requirements to define the functions of the software.
Developed code in PL/SQL to add new functionality to the software application.
Modified existing code to enhancement functionality of the software application.
Developed code in PL/SQL to automate the process of creating users for the software application.
Developed code in Perl Script in UNIX to automate processing of records.
Created Use Cases to illustrate behavioral scenarios through one or more functional requirements.
Analyzed business processes in order to document current and future operational procedures.
Published project communications, project schedules, and action items logs via the Project Mgmt WIKI page.
Documented processes and work flows via the OnTime software that communicated user expectations.
Created Design Requirements to identify the code needed for processes in the software.
Collaborated with business users, technical experts, and end users via weekly meetings to ensure customer satisfaction.
Monitored and troubleshot applications and systems resources to ensure compliance with system performance KPIs.
Monitored error log(s), user activity and resource utilization of the production environment.
Maintained system Metadata and liaised with team responsible for maintaining this data to ensure accurate and timely availability of this data.
Maintained and updated system and process documentation.
Documented and logged description of system events and resolution thereof.
Performed system housekeeping and reporting functions for the area of responsibility.
Designed and wrote VB scripts to monitor system applications and processes.
Performed post-QA, pre-production testing on patches or new releases of application software.
Applied new software revisions and patches.
Tested all upgrades of the CDRlive software.
Followed best practices for enterprise monitoring, troubleshooting and maintenance.
Maintained large feeds that were pushing data into the CDRLIVE application.
Participated in the design of data warehouse databases.
Identified and documented original data sources from transactional systems, user defined non-system data, or other sources.
Designed and developed ETL solutions using SQL Server 2005 Integration Services.
Developed SQL queries and the extract and load processes to move data from source systems into reporting systems.
Analyzed the data for completeness and accuracy.
Defined, created, tested, and deployed Analysis Services and models to support data mining and reporting.
Investigated customer problems referred by technical support.
Created ad-hoc reports utilizing various data sources.
Any other duties from time to time as assigned.
Internap, Atlanta, GA (October 2003 to February 2007)
Senior Operations Data/Reporting Analyst
Planned, coordinated, and administered database systems, including base definition, structure, documentation, requirements, operational guidelines and protection.
Administered, maintained, developed, and implemented policies for ensuring the integrity of the SLA Oracle 9i database.
Developed data models and performed planning of architecture, functions, modules, recovery, standards and implementation.
Acted as liaison with customers.
Created stored procedures to perform complex calculations using PL/SQL.
Migrated tables from SLA Access database to Oracle 9i database.
Developed processes to increase daily functions.
Provided recommendations for processes and assisted in implementing them.
Created a database to assist with daily processes.
Determined support costs and produced productivity reports for Management.
Produced reports for order completion to complete the Operations billing cycle.
Maintained integrity of the data produced from the analysis of the Internap ticketing software and ran custom reports against all Internap databases. These reports were used to determine support costs of specific Internap products as well as determine carrier-based statistics on the Internap network.
Performed technical documentation for Operations policies and procedures, reported key performance indicators for Operations, and documented specific project assignments.
Created Processing Manuals in RoboHelp.
Developed queries in Business Objects and Access as needed, which has an Oracle back-end.
Transferred data results from Business Objects and Crystal Reports into an Excel format.
Created pivot tables and charts from data results generated from Business Objects and Crystal Reports.
Developed SQL statements that selected specific data from the Oracle database to assist in resolving problems and general maintenance of the SLA database.
Utilized the Remedy ticketing system to extract data to create billing files for the billing system.
Calculated SLA credits from data obtained from the Remedy ticketing system.
Mapped network resources and managed application processes within Windows.
Normalized data to the 3rd and 4th normal form and was able to explain why 3rd may be enough for maximizing database performance.
Used the FTP Utility Program in UNIX to transfer files.
Developed VBScripts to add interaction to the Customer Website.
Designed and developed custom reports in Crystal Reports and Business Objects.
Coordinated and organized divisional, operational, and training meetings for the SLA database.
Worked directly with and effectively communicated with all levels of staff and management.
TTI Telecom, Atlanta, GA (April 2003 to October 2003)
Senior Business Analyst
Analyzed and documented legacy data utilizing Microsoft Excel and Access.
Participated in client meetings to evaluate best course of action and understand requirements for BellSouth DIA project.
Participated in Internal TTI strategy as well as give status of meetings.
Gathered requirements from users to create the Operations Support System.
Used requirements to create logical and physical application designs.
Tested application used by the users at BellSouth.
Morehouse College, Atlanta, GA (March 2002 to December 2002)
Web Consultant
Acted as liaison for Department of Web Technologies.
Conducted workshops to assist faculty and students with learning Dreamweaver.
Integrated multiple websites into a single website.
Utilized Cold Fusion to build web application projects
Verizon Wireless, Atlanta, GA (September 2001 to March 2002)
Data Analyst - Contract
Developed queries in PeopleSoft and created reports in Crystal Reports.
Accessed records via the Data Warehouse system.
Technical Summary
Programming: ASP, C/C++, COBOL, HTML, VB Script, JavaScript, Perl, RPG II, Java Applets, EDI, DHTML, PL/SQL
Applications: Office 2007, Front Page 2000, Adobe 5.0, ColdFusion 4.5, Microsoft Project, Microsoft Visio, Dreamweaver, Fireworks, Flash, Rational Rose Suites, Crystal Reports, Photoshop 7.1, RoboHelp, CDRLIVE Analysis and Reporting Tool, MS SQL Server 2005 BI toolset, Microsoft PowerPoint, Microsoft Excel, Word, and Access, OnTime, SharePoint
Operating Systems: Windows 2000/NT, Windows XP, Windows 95/98/ME, MS DOS, UNIX, RedHat Linux 7.1
Database: Oracle 8i/9i/10G/11I/12, Access 2000, PeopleSoft, Business Objects, Remedy Software, DB2, Oracle R12 EBS
Education and Certification
DeVry University, Atlanta, GA 2003
B.S., CIS, 2003 (cum laude), GPA 3.5/4.00
Certificate of Completion Crystal Reports 5.0
Certificate of Completion RoboHelp
Continuing Education Excel for the Power User
Continuing Education Managing Priorities
Continuing Education Leadership Skills
Continuing Education Effective Communication
Certificate of Completion IC Agile Certified Professional
Contact this candidate