Summary

Business Systems Analysis with a strong background and designing business solutions from inception to production. Develop System and Functional requirements, develop Use Cases, Matrix Traceability, Wireframes and master Test Plans. Maintain data encryption, adhere to compliance standards and create Enterprise Process Models.

Professional Experience

Confidential

Sr. Business Systems Analyst

• Lead JAD sessions with Clinical, Staging Migration teams in preparation for new system implementations.
• Gather requirements and create Use Case Scenarios.
• Coordinate and maintain work flow documentation for the clinical upgrade team.
• Create comprehensive client systems assessment documentation.
• Lead training sessions for assessment engineers on the entire assessment lifecycle.
• Facilitate technical and business process review sessions on best practices as required by management with field engineers.
• Create architectural layout of client's clinical suite and Infrastructure environments.
• Develop and maintain training materials for all new implementation projects.
• Assist Assessment engineers with business process requirements and systems requirements.
• Deliver weekly project status reports for multiple projects to senior management.
• Attended weekly project managers meeting to review / discuss business process impact changes.
• Work with technical field engineers to review various client software/system test plans in preparation for upgrades.
• Work with functional requirements and translate them into systems system requirements for engineering teams.
• Create and update Visio diagrams of application infrastructures to include connectivity data between infrastructure and software applications.
• Create SQL queries in various database inventory systems to validate the integrity of Enterprise data.

Confidential

Business System Analyst

• Lead JAD sessions with Migration teams in preparation for new system of creating/handling move packets for the client.
• Assist management with problem and process analysis and decision-making support that guided policies and procedures for various move packet projects.
• Participated in client interviews, needs analysis, risk analysis, design requirements and project management for various projects.
• Created various spreadsheets and documentation to enhance production of client move packets.
• Analyze various IT systems including hardware, software, and networking components in preparation for migration activities.
• Assist project managers in conducting user interviews with application owners at Boeing and the creation of standard migration requirements documentation.
• Provide SDLC deliverables on a weekly basis.
• Create and update Visio diagrams of application infrastructures to include connectivity data between infrastructure and other applications.
• Analyze discovery dependency data and inventory information with current inventory and work flow systems.
• Held training sessions for migration analyst on the process of analyzing and documenting data retrieved from Boeing applications.
• Create SQL queries and modify application data using select, insert, update and create statements.
• Query server inventory system and database inventory system to assess if current systems meet the requirements of the new datacenters.
• Extract and load data for application migration analysis by senior migration analyst.
• Maintain data integrity in Dell's application migration tool Transformation Manager.

Confidential

Project Manager / Business Analyst II

• Scheduling and coordination of multiple projects.
• Managing contractors and IT teams that maintain various enterprise systems.
• Developing, maintaining, and monitoring the project budgets.
• Leading weekly project meetings.
• Delivering presentations to management and stakeholders.
• Documenting As-Is processes and developing To-Be scenarios.
• Research system requirements to produce feature test strategies.
• Negotiated, coordinated, and managed scheduled dates with external organizations insuring internal dates could be met without impact to end dates.
• Provided timely project documentation to all project shareholders.
• Defining, scheduling, and coordinating project training activities.
• Identifying and mitigating risks.
• Providing SDLC deliverables on a weekly basis.
• Serving as a liaison between the business stakeholders and various technical teams.
• Worked with infrastructure management to conduct an as-is assessment of the infrastructure environment.
• Worked with infrastructure management to develop an Infrastructure Capabilities Improvement Plan which addressed major issues with Network Monitoring, Content Filtering, Firewalls, Enterprise SAN Improvement, and Disaster Recovery.
• Facilitated enterprise break/fix and help desk service migration JAD sessions.
• Managed fiber construction activities of one hundred plus sites around the city of Atlanta.
• Created Use Cases to clearly define various process models.

Confidential

Business Data Analyst

• Participated in the requirements, design and test phases of various projects.
• Work with Lawson group to gather requirements for various system upgrades.
• Install Oracle 10g databases in UNIX and Windows environments for production, QA, and testing purposes.
• Create and construct normalized tables in Oracle database to allow the IEP department to view student information on real time basis.
• Install patch sets on Oracle databases to meet recommended patch set upgrades.
• Link SQL Server databases to Oracle databases to migrate data for integration and analysis.
• Create Oracle indexes for Lawson developers using Toad software.
• Held training sessions for developers on the use of Oracle products.
• Extract and load data for payroll upgrade testing by the Lawson developers.
• Load tables with student information provided by the IEP department, using SQL loader.
• Query database using Truncate, Insert, and Create statements to ensure data integrity.
• Create and load tables with student data to be integrated into the school district's website.
• Create and construct programs to refresh development databases for payroll and HR testing by business analyst.
• Work with the data team and ETL developers to develop Best Practices and approaches to sustain the environment including software as well as hardware.
• Create standard documentation for the ETL processes to construct the Integration Competency Center.
• Assist sr. data architect in conducting user interviews with business leaders and the creation of standard business requirements documentation.
• Worked with the sr. data architect to begin laying the foundation for an enterprise data warehouse by conducting an as-is assessment of the current architecture.
• Develop data models using Erwin and Visio.
• Implementation team member of the Data Integration Competency Center, which houses data from various source systems.
• Extract and analyze student athletic data to assist the student services department with securing funding for the school system's athletic department.
• Collect and present metrics on the health of the school system's databases.
• Maintain BSI updates to payroll tables in the production and development environments.
• Install Lawson front end software on workstations for school district contractors.
• Install SQL Server database to allow for the installation of the Sagent ETL tool.
• Monitor various SQL Server databases using the Microsoft SQL Server Management Studio.
• Assist with the creation of the Integration Competency Center data model using Erwin.

Technical Skills

• Hardware: IBM RISC 6000, Hewlett Packet HP/UX , Gateway VX900, Dell GX240, HP ProLiant
• DL360, HP ProLiant DL380, HP ProLiant DL580
• Operating Systems: AIX v5.4, UNIX, Linux, Redhat 5.x, Windows 2000/NT, Windows/XP, Windows 95/98,
• Windows 7
• Programming Languages: ASP, PL/SQL, HTML, JSP, VBscript, JavaScript, SQL, Shell Script
• Web Technology: HTML, FrontPage
• Database Environment: Oracle 10g 9i, SQL Server, Microsoft Access
• Applications: Oracle Enterprise Manger, Oracle Database Console, Cognos v8, SQL Plus,
• SQL Loader, Erwin r4.1, Toad v8, Smart Notifications Lawson v8.0.3,
• Rational Rose, Visio, MS Office, Microsoft Project, MS Share Point, Free Mind,
• Carebridge, Microsoft Office Communicator 2007 R2
• ETL Tools: Sagent ETLv3.0, SQL Loader, SQL, Toad, Microsoft SQL Server Management Studio