Skills

Employment History:

Confidential

Business Analyst/Subject Matter Expert

Responsibilities:

• Responsible for reviewing, reformatting, redesigning, and finalizing the Lockheed Martin EPA requirements document. He developed the template for the process and oversaw the development of all categories of requirements.
• Responsible for the EPA CICS functionality testing for the EPA Client, Configuration User Interface, and Barr EOM and Barr Kiosk. Testing results were documented and distributed to all concerned. He also headed a team to identify any job using DIL or DOL files through CICS.
• Gathered and documented requirements for business systems of project and processes creating web based solutions.
• Performed detailed data analysis using sorting, filters and pivot tables to derive a good set of findings
• Designated as the coordinator for the Validation process and the 508 compliance. He developed a Validation Test Plan consisting of test scripts relevant for Validation as well as a separate 508 Test Plan. He also tested all aspects of these test scripts and conducted regression testing after modifications. He completed the TSO forms to move the CICS files, programs, and JCL to Validation.
• Designated the coordinator for the DBOPC Batch process. He met with the DBOPC Project Coordinator to determine which forms were relevant to EPA, conducted meetings, completed forms, and made the submissions.
• Monitoring budgets and Preparing accounting statements and reports
• Preparing, reviewing, submitting a variety of reports, reconciliations, and statements to and from internal departments, financial institutions, and external agencies
• Provided database maintenance and management support in Lotus Notes, Access environments for tax, auditing, consulting, and billing environments
• Provided excellent customer service in a fast-paced environment with the ability to multitask. customer service skills, multitasking, familiar with fast paced work environment
• John researched the Sharepoint site to identify the technical specifications for the three Java mainframe programs that support the EPA Secure Print Batch Adapter. He coordinated all Batch adapter testing.
• John initiated through the QA2 process the System Release Certification SRC process for EPA. He completed the initial form and once the relevant EPA Programs and JCL were transferred he submitted the SRC for further processing.
• Tested the EPA process from beginning to end until the results were deemed suitable for transfer into Validation. He then tested in Validation to validate the EPA process.
• Utilized all Microsoft Office applications Excel/Access/Word/Power Point/Visio/Project.

Confidential

Business Analyst/Data Modeler

Responsibilities:

• Gathered requirements from Subject Matter Experts from the HRM, Payroll, Financial, and Budget Departments Financial Analysts and Business users for better understanding of the business and IT processes of the current system and the infrastructure needs by using SIPOC and RACI tools.
• Experienced in handling range of financial analysis, accounting reconciliation, and data management.
• Performed detailed data analysis using sorting, filters and pivot tables to derive a good set of findings
• Authored the Business Requirement Document BRD and analyzed the possible technical solutions and translated them into functional requirements and Business requirements using RUP.
• Prepared, analyzed AS IS and TO BE of existing architecture by performing Gap Analysis, created workflow scenarios, designed new process flows, documented the Business Process and various Business Scenarios and activities of the business from the conceptual to procedural level.
• All Business Requirement Documents, Business Diagrams, Spreadsheets and Specifications updated to Sharepoint to facilitate sharing and tracking of projects tasks.
• Created and maintained the Narrative Use Cases Business and System Use Cases and modeled Use Case Diagrams, Activity Diagrams, State Diagrams, Business Flow Diagrams, Data Flow Diagrams using MS Visio, revised functional specifications and other core materials throughout the SDLC.
• Monitoring budgets and Preparing accounting statements and reports
• Preparing, reviewing, submitting a variety of reports, reconciliations, and statements to and from internal departments, financial institutions, and external agencies
• Provided database maintenance and management support in Lotus Notes, Access environments for tax, auditing, consulting, and billing environments
• Directed and managed the Change Control process for the project as a whole by facilitating group meetings, one-on-one interviews and corresponding through emails with work stream owners to discuss the impact of change request on the project.
• Created Logical and Physical data models for Staging, Transition and Production Warehouses using Erwin 3.5
• Provided excellent customer service in a fast-paced environment with the ability to multitask. customer service skills, multitasking, familiar with fast paced work environment
• Worked with the developers assisting them in writing SQL queries for creating reports using Crystal Reports and Business Objects Webi.
• All phases from design, development, testing and production used the Agile Methodology
• Assisted in the development of quality assurance artifacts including Test Plans, Test Cases and conducted User Acceptance Test UAT for successful implementation and made sure that all the requirements were met.
• Utilized all Microsoft Office applications Excel/Access/Word/Power Point/Visio/Project.

Confidential

Business Analyst/Data Modeler

Responsibilities:

• Planning a range of services, including network portals, managed network services, Internet access and remote access required to implement the Homeland Security Department's OneNet telecommunications contract using the VisiSuite COTS tool
• Gathered and documented requirements for business systems of project and processes creating web based solutions.
• Experienced in handling range of financial analysis, accounting reconciliation, and data management.
• spreadsheets consisted of vlookups, pivot tables and other advanced functionalities.
• Performed data analysis, root cause analysis, and benchmark results for both internal and external clients.
• Monitoring budgets and Preparing accounting statements and reports
• Preparing, reviewing, submitting a variety of reports, reconciliations, and statements to and from internal departments, financial institutions, and external agencies
• Provided database maintenance and management support in Lotus Notes, Access environments for tax, auditing, consulting, and billing environments
• Provided excellent customer service in a fast-paced environment with the ability to multitask. customer service skills, multitasking, familiar with fast paced work environment
• Conducting Data Modeling sessions to produce logical and physical data models for the data warehouse
• Designed and converted from the existing tracking system to a new VisiSuite format tracking system
• Utilized all Microsoft Office applications Excel/Access/Word/Power Point/Visio/Project.

Confidential

Business Development Manager

Responsibilities:

• Capturing and indexing images whether they originated on paper, electronic format, or hand-written
• Gathered and documented requirements for business systems of project and processes creating web based solutions.
• Experienced in handling range of financial analysis, accounting reconciliation, and data management.
• Performed financial data analysis such as end-to-end data mapping
• Provided database maintenance and management support in Lotus Notes, Access environments for tax, auditing, consulting, and billing environments
• Spreadsheets containing Pivot Tables and other lookup functions were used to analyze the service level of vendors at the distribution centers.
• Monitoring budgets and Preparing accounting statements and reports
• Preparing, reviewing, submitting a variety of reports, reconciliations, and statements to and from internal departments, financial institutions, and external agencies
• Converting the documents into usable, retrievable information by enhancing the scanned image
• Consigning the documents by providing users with a defined custom search criteria
• Developing the customer custom demonstration and coordinates as well as all presentations regarding all aspects of the eDoc Warehouse process
• Provided excellent customer service in a fast-paced environment with the ability to multitask. customer service skills, multitasking, familiar with fast paced work environment
• Utilized all Microsoft Office applications Excel/Access/Word/Power Point/Visio/Project.

Confidential

Business Analyst

Confidential

Responsibilities:

• Designed and implemented a change control system that was developed to ensure proper signoff by all affected parties.
• Gathered and documented requirements for business systems of project and processes creating web based solutions.
• Analyze the business metrics reporting needs and present the analytics data using Excel pivot tables etc.
• Experienced in handling range of financial analysis, accounting reconciliation, and data management.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Responsible for managing a team consisting of a SQLServer, SSRS, Mapper, and Progress programmer/analysts.
• Monitoring budgets and Preparing accounting statements and reports
• Preparing, reviewing, submitting a variety of reports, reconciliations, and statements to and from internal departments, financial institutions, and external agencies
• Responsible for weekly and ad-hoc management reports as well as leading all user interactions such as detailed interviews with OCYF user personnel, building APERs, reviewing assessments and presenting APERs for to exe3cutive management for approval.
• The APERs developed, updated, and presented by John are excellent examples of John's abilities in the areas of business writing experience, strong organizational skills, and strong customer-service focus as well as the ability to present technical information to senior management audiences.
• Provided excellent customer service in a fast-paced environment with the ability to multitask. customer service skills, multitasking, familiar with fast paced work environment

Utilized all Microsoft Office applications Excel/Access/Word/Power Point/Visio/Project.