SUMMARY

• Senior Business System Analyst with over 20 years of experience in performing a complete range of information system analyst assignments including but not limited to gathering and management of business requirements, system user acceptance testing, maintenance and development of systems, user documentation and participation of the pre and post system implementation support
• Experience of all phases of information system life cycle (analysis, design, develop, test, implementation) to support system development initiatives and other related integration efforts
• Highly proficient in creating documentation using Unified Modeling Language (UML) diagrams such as Use Case Diagrams, System Flow Diagrams, SAD, and development of Whitepapers
• Extensive experience in developing Use Cases, User Stories, RTM, Test Cases, Testing conducting User Acceptance Testing (UAT) and expertise in designing and developing Test Plans
• Expertise in detail Enterprise Development application analysis and design, process and data mapping, process modeling, requirements gatherings (Business Requirements Documents), business rules, data modeling, Dimensional Data modeling, SQL, CRUD Matrix, and procedures and testing
• Client - server architecture using Oracle, DB2, relational database design, J2EE, ETL processes and workflows, Data Warehouse, Data Mining, Mainframe, JCL and COBOL
• Highly motivated team player with excellent interpersonal, analytical, technical, problem solving, attention to detail, time and team management, and self-organizing skills
• PMI Disciplines: Schedule Management, Process Management, Resource and Budget Management, Change Management

TECHNICAL SKILLS

System Analysis and Design: SLDC, UML, Waterfall, JAD, and Agile using XP, Pair Programming and Future Driven Development

Process and Data Modeling: Data Flow Diagram (DFD), Logical Data Model, Entity Relation Diagram (ERD), Interaction Model, Data Mapping, ETL processes and workflows, Flowchart/Process Model, Normalization, RDBMS, UML, and Use Cases

Database: Oracle, SQL Server, SQL, PL/SQL, DB/2, IMS and MS Access Workflow, Flowcharting, and Visio, SharePoint, Power Point, Access, Word, and MS Project

MS Office Tools: Programming Languages: Java, COBOL, FORTRAN, C#, and Pascal

PROFESSIONAL EXPERIENCE

Confidential, Lansing MI

Sr. Business System Analyst

Responsibilities:

• Facilitates different types of sessions for requirements gathering and documentation of functional and non-functional requirements.
• Created Project Charts, Project, Resource, Implementation, Communication Supplement plans, Functional Design, System Design, Coordination Task Lists, Test Plan, Test Type Approach, Release Notes, and Testing Cycle Exist Reports, Success Criteria for Go/No Go documents etc.
• Developed User stories, Product, and Sprint Backlogs
• Model business processes such as AS-IS/Physical and TO-BE/Logical Models.
• Develop functional and technical design documents.
• Writes detailed description of user needs, program functions, and steps required to develop or modify computer program as part of SEM0604 documents.
• Facilitated review meetings for Project Charts, Project, Resource, Implementation, Communication Supplement plans, Functional Design, System Design, Coordination Task Lists, Test Plan, Test Type Approach, Release Notes, and Testing Cycle Exist Reports, Success Criteria for Go/No Go documents etc. etc.
• Direct and coordinate work of others to develop, test, install, and modify programs in all projects by creating testing co-ordination tasks list, SEM0604, implementation plan etc.
• Provide support and make recommendations for information technology systems processes associated with software technology planning, development, implementation, system security, and interfaces for all projects.
• Provides support to development and testing teams.
• Develop the documentation for new process and procedures for logical system.
• Create and review Test Plan and Test Approach for each SIT and UAT cycles.
• Facilitates review meetings for functional and technical design documents, testing documents, release notes, etc.
• Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system for all Request For Change (RFC) and provide feedback in the weekly Local Change Control Board meetings.
• Sets up environment with correct application codes and data for each test cycle.
• Develops and Maintains user documentation such as Coordination Task Lists, Release Notes, Tester Cheat Sheet and Cycle Exist Reports for all SIT and UAT test cycles.
• Creates all change request for the Michigan Online Registration (MOR) and Branch Office System (BOS) systems. Reviews all change request to determine the impact on the MOR and BOS systems.
• Attend and participate in all Local Change Board (LCAB) meetings and reviews for MOOS to determine impact and risk on the MOR system.
• Plan and prepare technical reports, memoranda, and instructional manuals as documentation of program development as part of Release Notes for each build, Exit Reports for each testing cycle.
• Provides technical assistance and support for applications and hardware problems and for information sharing with external entities in a customer service environment such as issues with Idemia, PENSKI, AAMVA, etc. etc. from time to time.
• Participates in the pre and post system implementation support actives to determine if any service is down such as Uni Server, Document Server, CEPAS Server etc. etc.

Confidential, Detroit, MI

System Analyst

Responsibilities:

• Developed Business Requirement Document (BRD), RTM, SAD, Whitepapers, Implementation Plan documents, Users document for PMR Lite (new application for NASCO Processing System NPS)
• Developed Use Case Model, Activity and Class diagrams
• Developed current state/AS-IS State and future state/TO-BE State
• Conducted requirement gathering (JAD) sessions
• Involved in the development of System Integration and UAT Testing Plans
• Developed logical database design and data mapping documents
• Developed Use Cases, Test Cases, Business Processes, Implementation Plan and Ops Manual
• Planned and conducted requirements reviews with business partners, design/development teams for mainframe, Java team, database teams (Oracle and DB2) and IT managers
• Effectively communicate directly with both internal customers and external vendors
• Understand system architecture and the integration of system components
• Actively participated in all aspects of the system life cycle
• Actively participated in data modeling activities with developers and database administrators
• Worked closely with developers to determine appropriate system design changes/enhancements
• Worked closely with developers and the technical support team to deliver system enhancements and resolve QA/Test support issues
• Requested many DEWG forms for development of ETL process using EDDI (FTP), JCL and NDM

Environment: Mainframe, COBOL, CICS, Java, Data stage, Oracle, MS Project, Visio, SharePoint

Confidential

System Engineer / Business Analyst

Responsibilities:

• Developed Business Case and Vision documents
• Developed BRD, Use Cases, Test Cases, Business Processes and User Training Manual
• Developed Use Case Model, Activity and Class diagrams
• Developed current state/AS-IS State and future state/TO-BE State
• Conducted requirement gathering (JAD) sessions
• Developed Pre-Training Plan, and UAT Testing Plan
• Developed Implementation, Conversation, and Training plans
• Developed logical database design and Data Mapping documentations for different ETL processes between Confidential, RBC and SSQ for Data Ware operations related to Medical, Dental, and vision claims
• Effectively communicate directly with both internal customers and external vendors
• Analyze and troubleshoot QA/Test system problems effectively
• Understand system architecture and the system integration of different components
• Actively participated in all aspects of the system life cycle
• Perform data analysis using Oracle SQL
• Actively participated in data modeling activities with developers and database administrators
• Worked closely with developers to determine appropriate system design changes/enhancements
• Worked closely with developers and the technical support team to deliver system enhancements and resolve QA/Test support issues

Environment: MS Office, MS Project, SharePoint, MS Visio, Oracle, TFS, BI Reporting using Crystal Reports, Waterfalls .Net, C# and SQL Server

Confidential

Consultant

Responsibilities:

• Developed Project Charter, Work Breakdown Structure (WBS), Project Plan, RICA chart, and Resource Plan,
• Developed current state/AS-IS State and future state/TO-BE State
• Developed Business Use Cases
• Conducted requirement gathering (JAD) sessions to determine business processes list
• Conducted requirement gathering (JAD) sessions to determine the applications list
• Mapped Business Processes to the Applications for Business Continue and DR Planning for SLA
• Performed Gap Analysis between Business Continue and DR Plans
• BI Reporting using Crystal Reports on Business Continue and DR Activities

Environment: MS Office, SharePoint, MS Project, MS Visio, eBRP and BI Reporting using Crystal Reports

Confidential, Bentonville, AR

Team Lead / System Analyst

Responsibilities:

• Created and executed requirements management plan(Mainframe, Java, and .Net Development), - including timeline & effort estimates
• Facilitated JAD sessions for requirement gathering, requirement confirmation, validating requirement gathered, and documentation of functional and non-functional requirements by using ISDLC.
• Elicited analysis, and reporting requirements from business stakeholders to understand and Documentation their objectives and solution criteria
• Developed AS-IS Documentation for 401 K Matching Contribution, 401 K Profit Sharing, 401 K Stock Purchase, and Government Mandate for age 26 for Medical, Dental etc
• Developed future state/TO-BE Documentation using Use Case Modeling, Use Cases, and System Integration Modeling using Visio
• Developed Use Cases, Use Case Model, Activity and Class diagrams
• Developed GUI, Reports and Contribution File for Confidential - Confidential
• Documented the process of system integration of 401 K, Payroll, Human Resources Data Ware House using IBM Data stage and Confidential - Confidential
• Performed SWOT analysis, Risk and Impact Analysis, GAP analysis of requirements to determine missing functionalities
• Developed Documentation of Understanding (DOU), Scope Documentation, Business Requirement Documents (BRD) including Use Cases, Activity diagrams, Main/Basic Flow, Alternate Flows using Visio, Users Documentations
• Planned and conducted requirements reviews with business partners, design/development teams for mainframe, Java team, .Net team for customer facing application, database teams (Oracle and DB2) and IT managers
• Dealt with various queries and questions related to Mainframe, Java, and database teams
• Developed logical database design using ERD and physical database design based on logical database design including Data Dictionary for both DB2 and Oracle and CRUD Matrix for web-based application for customer facing application
• Built relationships with source system support teams of 401 K and Payroll to gain insights into data and processes that they manage
• Worked with offshore QA, Java and COBOL development teams to develop Technical Design Documents
• Mentored other Business Analyst

Environment: Mainframe, COBOL, CICS, Java, .Net and SQ Server, DB2 as HOST, Data stage, TeraData, Oracle 11I, MS Project, Visio, SharePoint, HP Quality Center, Outlook, and WebEx

Confidential, Dearborn, MI

System Analyst

Responsibilities:

• Participated and facilitated Rapid sessions (JAD) for requirement confirmation, validating requirement gathered, and documentation of functional and non-functional requirements by using simplified Data Flow Diagrams.
• Developed Business Owner View (BOV) using many different processes modeling techniques based on Zackman Framework using Visio such as DFD, ERD, and Business Process Modeling.
• Developed future state/TO-BE Documentation using Use Case Model, Use Cases, System Boundary, System Integration Model using Visio and Consolidated User Table/CRUD Matrix.
• Developed traceability matrix.
• Wrote Use Cases, Activity diagrams, Main/Basic Flow, Alternate Flows using Visio.
• Wrote User Acceptance Test scenarios, functional Test Cases.
• Wrote system integration Use Cases and Test Cases.
• Dealt with various queries and questions related to Java, and Oracle
• Participated different meeting for facilitate completion of Application Control Review (ACR), SOA, EAA, etc.
• Worked with offshore database and Java development team
• Provided input in the development of Project Chart.
• Prepared report for outstanding issues related users authentication.

Environment: Java environment using Oracle 11I, MS Project, Visio, SharePoint, HPQC, Outlook

Confidential

Sr. Business & System Analyst / Project Manager

Responsibilities:

• Facilitated JAD, interview, and brainstorming sessions for requirements gathering and documentation of functional and non-functional requirements using USE Case, Context and DFD diagrams
• Modeled business processes such as AS-IS/Physical and TO-BE/Logical Models
• Developed User stories, Use Cases, Use Case Model, Activity and Class diagrams
• Developed Context and DFD diagrams and functional specifications for each sub-system to enhance their functionality using Visio
• Wrote the technical specification using flowchart/process model, class, activity diagrams etc
• Developed the documentation for new process and procedures for logical system
• Researched, analyzed and documented clear and complete business requirements/functional requirements for Production Support activities
• Created and reviewed test strategy and test matrices during QA and UAT cycles
• Handled the business change management issues regarding scope, schedule etc111
• Liaised with the business stakeholders, company heads, customer, end users during all phases of development, and software developers, and tester during the design and development stages
• Produced technical documentation, developer manuals and other related manuals and User Interface Design documentations
• Wrote technical specifications by mapping from AS-IS/Physical to TO-BE/Logical Models design
• Developed logical database design using ERD and physical database design based on logical database design including Data Dictionary, Data Mapping and CRUD Matrix
• Created Views on multiple tables for business to run ad hoc query using SQL
• Dealt with various queries and questions related to .Net and C#, and MS SQL Server
• Developed Work Breakdown Structure for the development of web business analysis, web project management, full system development life cycle custom development, online ordering system, B2B application, for Japanese electronics company
• Migrated Java based application to .Net Environment of an existing application of B2C using reverse engineering and documenting system interfaces
• Supervised system integration of in-house web-base system and online ordering system for Japanese electronics company as part of the ERP system
• Reporting using Crystal Reports
• Managed back-up, recovery and disaster management
• Managed project process and budgets

Environment: .NET environment using SQL Server 2005, Crystal Reports, SOA, SharePoint, XHTML, ASP, JSP, SOA, AJAX, MS Project, Visio and C#/JavaMemorial University of Newfoundland ~ St. John's, Newfoundland: Sep ‘04 - Apr ‘07

Confidential

Business Analyst / System Analyst

Responsibilities:

• Facilitated JAD, interview, and brainstorming sessions to gather and document functional and non-functional requirements using Use Case Modeling, Activity, Context and DFD diagrams
• Developed Use Cases, Use Case Model, Activity and Class diagrams
• Modeled business processes such as AS-IS/Physical and TO-BE/Logical Models
• Written technical specifications by mapping from AS-IS/Physical to TO-BE/Logical Models design
• Developed logical database design using ERD and physical database design based on the logical ERD design including Data Dictionary and CRUD Matrix
• Dealt with various queries and questions related to Java, and Oracle
• Created Test Case, and Test Case scenarios during UAT cycle
• Defined user dialogue, update processes, GUI, reports, and enquiry processes using Visio
• Coordinated development teams including business stakeholders, customer, end users local team and off shore teams
• Worked with JAVA and database offshore team

Environment: JAVA, J2EE, SOA, MS Project, Visio, XML, XSLT, SQL Server 2000 and JDBC