SUMMARY OF QUALIFICATIONS

• Experience supervising Dynamic Object-Oriented Requirements System DOORS for gathering requirements into modules that contain trees of text objects qualified with user defined attributes cross linked together using directional links.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Enterprise Data Warehouse
• Extensive managing experience in Client Server, Web-based, Multi-Tier applications using technologies like ASP.NET, .NET, SOAP, Web services, SQL, Oracle, VB, ASP, IIS, HTML, XML, ActiveX, .Net .
• 3 years of experience in Dimensional Data Modeling, Star Schema/Snowflakes schema, Fact and Dimension tables, Physical logical data modeling using Erwin 3.5
• Adept at creating, editing and coordinating extensive communication networks through the facilitation of joint application development JAD sessions and joint requirement planning JRP sessions and interviews, written correspondence, reports, implementation requirements, project status reports, oral presentations and emails, to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts. Good experience in developing testing scenarios and testing scripts
• Extensive experience with System Development Life Cycle SDLC using Waterfall as well as Agile Methodologies
• Familiar with Sarbanes-Oxley Act SOX compliance requirements
• Adept using Gap Analysis techniques to gain a clear understanding of the AS IS of the system and additionally derive new user scenarios to understand the potential TO BE system
• Adept in creating Narrative Use Cases, Use Case diagrams, Sequence Diagrams, Activity Diagrams, State Diagram, Flow Diagrams and other related UML diagrams. Extensive knowledge experience using of MS Project
• Extensive experience in Gathering Requirements, analyzing them, doing Business Process Model, writing Business Requirements Document BRD , Use case Specifications, Technical/Systems Design/Systems Requirements Specification SRS , Data Dictionary, Business Continuity Plan BCP , Workflows.
• Over 25 Years of experience in Business Analysis, System Analysis, Quality Analysis, and Project Management with extensive experience in the system design, implementation and integration strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills in diverse domains like Federal, State, and County governments.
• Hands on experience in Development and Implementation of Business Intelligence solutions using Business Objects XI and Crystal Reports XI

TECHNICAL EXPERTISE

• Methodologies: Erwin, Rational Unified Process RUP , Erwin Data Modeling, GUI, Rational Requisite Pro, Rational Clear Quest, Rational ClearCase, Waterfall /Iterative/Agile.
• Software/Databases: MS Office Suite, Rational Suite, Sharepoint, Requisite Pro, Rational Clear Case, MS Project, Erwin, Mapper, Progress, Accela Automation, Oracle 8i, Oracle 7.x, MS Outlook, MS Visio, Crystal Reports 2008, XI R/2, XI, 10, 9, Excel, Business Objects WebI, Universe Designer, Business Objects XI REL2, Crystal Enterprise 9,10, Visual Basic Crystal Reports. Corda Dashboard, SSRS, SSIS, Dynamic Object-Oriented Requirements System - DOORS , VisiSuite Project Planning
• Operating Systems: MS Windows XP, 9x, NT, 2000,

PROFESSIONAL EXPeRiENCE

Business Analyst/Data Modeler

Confidential

• 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.
• 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.
• 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.
• 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
• 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.

Business Analyst/Data Modeler

Confidential

John was responsible for the following:

• 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

• 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

Business Development Manager

Confidential

• Capturing and indexing images whether they originated on paper, electronic format, or hand-written
• 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

Business Analyst

Confidential

worked as a business analyst to assist in creating an accessible digital archive for the Bucks County Domestic Relations Office. Based in Doylestown, Pennsylvania, the Domestic Relations Office of Bucks County assists the public to administer, collect, and enforce court orders to establish child and spousal support obligations. The County must track thousands of cases to ensure fulfillment of all court-ordered obligations. A customized electronic document ECM system was developed and current data was migrated to the new system to support the processing of more than 16,000 open cases per year.

Confidential

Project Manager / Business Analyst / Data Modeler for the OCYF initiative of accessing Phase 1 and maintaining Phase 2 it's twelve independent systems consisting of five outdated and different IT platforms. These platforms included Progress, SqlServer 2000, Mapper, etc. These assessments were presented in the form of a Application Profile Evaluation Report APER for each system plus a Summary APER. The APER format was designed by John. The purpose of the assessments was to determine the pros, cons and risks of maintaining the current systems as is, upgrading to the latest version or completely redesigning to a new platform. The APER also summarizes the key impact areas and the observations that inhibit the applications and processes from continuing to function properly to address the required Child Welfare functionalities. Phase 2 consisted of data modeling and migrating to new versions and/or changing existing systems to maintain desired functionality. John designed and implemented a change control system that was developed to ensure proper signoff by all affected parties. John was responsible for managing a team consisting of a SQLServer, SSRS, Mapper, and Progress programmer/analysts. John was also 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.

Confidential

duties included project planning, administration and tracking. John believes that the closer he gets to the end users the better he can accomplish the project goals. He has used this theory to his advantage and success with every project that he manages. He also believes that getting very close to all technicians helps him to understand technical issues and is comfortable in presenting technical findings in such a manner as to be understandable to upper management. He was responsible for overall engagements and monitoring of progress to ensure projects were effectively executed. John is also familiar with the Sarbanes-Oxley Act SOX compliance requirements. The Software Development Life Cycle SDLC Agile Methodology was employed using eXtreme Programming Result Oriented Approach as opposed to the Water-fall Methodology due to the short period of time allocated 6 months . John lead the Project Review Board PRB meeting with senior management to communicate the scope, schedule, and cost of project. He managed and mentored a team consisting of a technical architect, business analysts, technical leads, DBAs and project coordinators by participating and/or leading all technical and/or user meetings. John was responsible for weekly and ad-hoc upper management reports and lead all user interaction and requirements management meetings. John operated in the following technical environment: SQLServer2000, MQ Series 5.2, .NET, Mainframe Data, Windows 2000, and Web Based Interface. Tools used included: MS Project, PowerPoint, Excel, Visio, Accela Automation. John was also responsible for interacting and coordinating with the contractor responsible for the main application that EIRD was feeding into. This project was completed on time and on budget due to John's excellent management skills involving interaction and coordination with other project participants and the Agile Methodology and eXtreme Programming approach of SDLC to successfully complete the project in a very short time frame given the volume and complexities involved.