SUMMARY:

• OVER 20+ YEARS OF IT EXPERIENCE AS A BUSINESS ANALYST. Extensive experience in performing Business & Systems Analysis, Requirements Gathering & Gap Analysis, Change Request Mgmt.
• Document Version Control, Problem Notifications, Defects Resolution, Risk/Impact Analysis & Feasibility Study, Ticket Triage, Issue Resolution, JAD/RAD & Workshops, Scope Creep Mgmt., Business Intelligence, Global Data Warehouse & DataMart Build/Redesign, Data Modeling /Analysis /Mapping/Profiling, Business/Systems Process Analysis & Re - engineering /Redesign, UML Modeling, Use Cases, BRD, FRD, SRD, User Interface Specifications, Reports Analysis /Mockups/Specs, SDLC phases/RUP/ Agile/ Scrum /Waterfall methodologies, Test Cases/Scripts/QA/UAT, Project Mgmt., Leadership skills managing Onsite/Offsite coordination & allocating work efforts, Project Status Reports/Presentations, Templates Creation, Post Production Support & Training Documentation/Manuals.
• Involved in Data Migration from various Legacy Systems to a Centralized Web-Based System, Data Migration from multiple Systems to one “Integrated” Centralized Platform, and direct System to System Integration.

SKILLS:

BUSINESS & SYSTEMS ANALYSISJAD SESSIONS & WORKSHOPS, REQUIREMENTS GATHERINGREQUIREMENTS GAP ANALYSISBRD, FRD, SRD, USE CASESDATA ANALYSIS/ DATA MAPPING/ DATA PROFILING, DATA WAREHOUSE/DATAMART REDESIGNPROCESS ANALYSIS & REDESIGN, BUSINESS PROCESS RE - ENGINEERINGPROJECT FEASIBILITY / RISK / ISSUE ANALYSIS, UML MODELINGUSER INTERFACE ANALYSIS/SPECS, SDLC,WATERFALL,RUP,AGILE, SCRUM,RAD, ACTIVITY/WORKFLOWSREPORTING ANALYSIS / REDESIGN SIMULATION / MOCKUPS / SPECSCHANGE REQUEST/ VERSION CONTROL, DATA DICTIONARYPROJECT MANAGEMENT TICKET TRIAGE, ISSUE RESOLUTION TEST CASES / SCRIPTS/ QA / UAT/ POST PRODUCTION SUPPORT/ TRAINING / DOCUMENTATION

TECHNICAL SKILLS & TOOLS:

REQUIREMENTS MANAGEMENT TOOLS: Microsoft Office (MS Word, MS Excel, MS PowerPoint), Rational Requisite Pro, Caliber RM, Cogno’s Reporting, SharePoint, MS Project

BUSINESS MODELING & DESIGNING TOOLS: Microsoft Visio, Rational Rose, Rational Unified Process, Unified Modeling Language, Erwin

REPORTING TOOLS: Business Objects SAP (WEBI & DESKI version), Cogno’s, MS Excel (Pivots & Cube Reporting)

REQUIREMENTS COLLABORATION TOOLS: Dropbox, SharePoint, Shared Locations/Shared Drive, Lotus Notes, Outlook

DELIVERY METHODOLOGIES: Rational Unified Process (RUP), Agile, Scrum, Rapid Application, Development (RAD), Waterfall, UML

DEFECT TRACKING & TESTING TOOLS: Rational Enterprise Suite, Mercury’s Test Director, Rational Clear Quest, Rational Robot, Test Manager, Software Application Testing Life Cycle, Load Runner, QTP, Win runner

OPERATING SYSTEMS: MS Windows 95/98/NT/2000/XP, Sun Solaris, Linux/Unix, OS400

LANGUAGES: JAVA, JSP, C/C++, C# in ASP.Net, XML, Visual Basic, PL/SQL

SERVERS (WEB & APPLICATION): Web Programming, Microsoft IIS, Apache, IBM Web Sphere, Windows Server 2000, Business Objects SAP (WEBI & DESKI versions), Cogno’s

DATABASES: Oracle, MS Access, DB2, RDBMS, SQL Server 2008, Relational & Multi-dimensional Databases, OLAP/Cubes

SCRIPTING LANGUAGES: HTML, DHTML, XML, SQL, Batch Scripting, FTP

EXPERIENCE:

Confidential, Concord, CA

Sr. Business Systems Analyst

Responsibilities:

• Managed all meetings coordination efforts & produced all applicable requirements artifacts for end-to-end system integration projects, (i.e. integrating Project & Contracts data from CMiC to LaborChart, Employee & Certifications data from Workday to LaborChart and Trumpia, Epicor to Workday)
• Sole Owner for managing Enterprise One Migration to Cloud Reporting Environment and SharePoint Sites Migration to Cloud Office365, including Stakeholder Analysis & Impacts, Scope Definition, Project Planning & Scheduling with milestones, deliverables, & timelines, meetings coordination & communications, creating 35+ report specifications & mockups (new & modified), and producing 50+ data extracts in requested reporting formats, prior to E1 system shutdown. Archived 250+ SharePoint Sites to Cloud environment, handled all communication efforts to Site Owners, and coordinated all migration efforts with 3rd party vendor and provided periodic project status updates to upper management.
• Executed queries, produced Audit data extracts & reports requested by Auditors for Year-end PBC Audits
• Conducted research & analysis to quantify business opportunities and assisted in developing formal recommendations to management. Created Vendor Evaluation template covering all Qs pertaining to implementation strategy, functional, workflows, reports, technical architecture, system integration, & security for Legal department’s Contract Management system evaluation. Managed all vendor and BTech technical team’s meetings, communications, created online surveys and provided status updates to management & stakeholders for decision making. Also created Request for Proposal and evaluated vendor’s proposal in response to RFP
• Produced a set of standard theories, concepts, procedures, techniques, tools & templates for ‘Business Systems Analyst Toolkit’, including creation of all required BSA templates (including examples) for small, medium & large sized projects, along with BSA Overview, Glossary, BSA Basics ppt. and published these artifacts to SharePoint ‘BSA Site’. Also held training/KT sessions to train various groups & departments
• Coordinated meetings & communications w/ Financial Managers and maintained an ongoing FM request list, including system category, issue, status, impact to workflows, front-end screens, back-end data, reports and determined business value & weekly usage hours for projects prioritization
• Created an ‘Active Event List’ via Access database for Accounting Managers to keep up to date w/ weekly/daily to-do items. Also created an Organization Hierarchy Chart for Accounting Operations teams
• Managed overall MDM (Mobile Device Mgmt.) project, including creation of surveys, employee handbook MDM policies, Wishlist for 3rd party vendors evaluation, rose, bud, thorns and meeting coordination w/ internal technical teams (Security, IT Operations, Integration, Database Admins)
• Created complex functional & technical specifications providing end to end solution requirements & designs, reviewed & validated with business SMEs for signoff/approval, and for use by developers/testers
• Provided effective support of large projects and leadership of small/medium projects, dealing with all relevant issues, often without the guidance of the manager
• Solving business problems and furthers business success by applying IT methodologies, management practices, system development lifecycle and best practices through the definition of high-level solutions.
• Participated in end to end implementation planning including project management, issue & risk management, communication & change management
• Proactively suggested system enhancements to improve efficiencies and support business goals
• Created UML models, use cases, user stories, BRDs/FRDs, process flows, report specifications, context diagrams & charts to provide direction to business groups, developers, designers, 3rd party vendors
• Created Change Request template, handled all work & coordination efforts for all kinds of defects & change requests after post go-live implementation support, i.e. defect mgmt. via ticket triage system, requirements analysis, research, elicitation & stakeholder approvals for CRs, user interface screen mockups, forms data, field naming conventions, screen layouts & data flows, notifications triggers. Validated w/ stakeholder groups & received approval and coordinated CRs work efforts with implementation vendor/s.
• Work with the Business and Platform teams to identify current system capabilities & opportunities for process improvements. Reengineered business & system processes including ‘As-Is’ to ‘To-Be’ (i.e. approval, notification trigger, job setup, job status change workflows). Also created Financial & Operational business & system processes from scratch, i.e. Invoice Approval, Owner Billing Process, Owner Contract Approval, Change Order etc.
• Created test metrics, positive & negative test scenarios, test scripts for user interface regression CRP & UAT testing. Reviewed & validated the accuracy/completeness of test scenarios with stakeholder groups & received approval. Walkthrough test cases with developers & testers. Assist ERP systems end-users & testers with data conversion & data validation efforts
• Supported other departments, divisions, and organizations as a liaison to IT. Managed large and more complex projects coordinating with all groups of stakeholders, management & technical teams
• Created a ‘Requirements Traceability Matrix’ template for tracing requirements forwards & backwards for developers, testers & end-users

Confidential, Trenton, NJ

Sr. Agency Management Process Analyst

Responsibilities:

• Documented system processes for migration of three separate legacy systems (SBE Goals, Subcontractor Approval Process, WorkForce Program) to one centralized web-based system (Construction WorkForce Management System (CWMS)
• Enhanced system functionality/features via proposing UIS (User Interface specifications)
• Implemented 30+ new CWMS Reports & enhanced existing reports fulfilling the current needs of business end-users
• Created “As-Is” to “To-Be” Business & System Workflows for the replacement/conversion of existing Primavera Contract Management (PCM) system with the newly implemented PMWeb system
• Re-engineered MIS processes with MIS Project Analysts, System & Database Admins, including but not limited to Application Development, Helpdesk Mgmt., Website Posting, Purchasing & Procurement, Security, Change Mgmt., Disaster Recovery, Emergency Response for Compromised Computer, Smartphones Assignment, Report missing Property, & Third Party & IT Consultant Mgmt.
• Facilitated business & system process modeling and created specification documents and validated with project teams to ensure that processes are customer focused, consistent, effective & efficient
• Interfaced with ALL necessary NJSDA Departments & was solely leading to process identification, capture & documentation efforts as they related to management of school construction projects
• Conducted research & interviews, performed analysis on current “As-Is” processes
• Created documentation for all the necessary Business & Systems (“AS-IS” to “To-Be”) processes in form of SOPs &Workflows
• Consolidated all documentation into a centrally shared uniform method
• Assessed business models & its integration with software solutions, proposed formal recommendations to enhance/streamline processes within various Business & MIS units; hence, opening & maintaining lines of communication to improve Business Unit’s satisfaction with MIS
• Made recommendations for project enhancements or added features/functionality
• Coordinated with Project Managers to identify impact of business processes on system implementation and identified/documented required system process changes
• Tracked & provided Process Status Updates to MIS Management & Business Stakeholders and ensured timely delivery on new & improved Business/MIS System processes

Data analyst

Confidential, NYC, NY

Responsibilities:

• Performed feasibility analysis, executed SQL queries, data analysis, data mapping and identified data discrepancies in order to provide all the data out of one “integrated” platform (Google’s DoubleClick Publishers), while replacing previous separated sources: Ad Servers (DFP, Freewheel & Burst)
• Re-engineered the business & system processes to provide DFP as a Standalone Source for all Display & Video data integrations for all Networks (BET & Confidential ), Contracted “Booked” data to be sourced from (Ad Front Sybase Database), whereas the impressions on Advertisements “Delivered” data to be sourced from DFP Ad Server only; after TRAM Booked & Delivered data merge processes were performed, revenue calculations were done in ETL processes and stored in TRAM DataMart
• Redesigned the Cogno’s framework and Report Studio front-end reporting tools for Business Intelligence End-Users
• Scheduled the daily reports processing using Cogno’s Scheduler
• Executed live data SQL queries for data analysis/mapping/profiling out of DFP Query Tool & compared DFP data against DTF (Data Transfer Files), including custom targeting level, most granular (hourly created) data
• Applied advanced Excel modeling and data analysis techniques to transform detailed transactional level data into high-level data for financial reports & pivots
• Identified requirements gaps, proposed business logic for derivation of missing fields from new source system, performed data profiling to validate logic functions properly in all possible scenarios, created use cases, reports & pivots depicting new logic with data examples
• Developed a System-wide Data Dictionary with definitions, business logic, TRAM Targeted vs. Current Values
• Performed Impact analysis & made recommendations (Old source vs. New Source) for following: Changes in Data granularity, Data Terminology, Data Processes
• Performed impact analysis & redesigning of 40+ Business Intelligence reports and MRM Freewheel BI Queries (old source system)
• Proposed requirements for Ad Unit & Site, Advertiser & Agency Rollups, and Custom Targeting & Key Values (100+ attributes included)
• Proposed requirements milestones, deliverables, and tentative timelines.
• Verified adherence to project plan, deliverables and due dates accomplished
• Involved in creating & receiving business stakeholder’s signoff on following: BRD, FRD, Use Cases, Reports, pivots & data profiling business rules

Business analyst/technical writer

Confidential, ENGLEWOOD CLIFFS, NJ

Responsibilities:

• Held JAD sessions to eliminate variances & provide consistency in application development procedures
• The only key player to keep track of the various ongoing project’s status, create PPTs for Exec’s presentation to provide Actual vs. Expected progress, coordinate with project owners onsite & offshore, remediate hurdles & delays, provide issue resolution
• Created specification templates for Project/ Status/ BRD/ FRD/ SRD/ Technical/Reports
• Standardized IT department’s documentation practices by creating & disseminating Company’s Style Guide across enterprise
• Analyzed, evaluated and minimized discrepancies in technical documentation (Standard Operating Procedures, Work Flows, Work Instructions, User Manuals, Reports) across various IT team’s
• Improvised Page Layouts, Headers, Footers, Logos, Content Specification, Content Development, illustration, animation, on-line documentation & editing
• Ability to effectively communicate technical specifications & work instructions to a wide range of audiences from different IT spectrums
• Maintained knowledge base by collaborating with IT development teams and other supporting teams using Dropbox repositories
• Researched & compiled reference data, analyzed technical literature available, wrote descriptive copies, developed consolidated IT Glossary, Data Dictionary and verified technical information with related teams and departments
• Involved in business process re-engineering by streamlining existing IT team’s processes in correlation with standardization of technical documents, i.e. MTM Alert Ticket Triage & Change Management processes
• Resolved technical issues by collaborating with technical IT teams and business stakeholders during the development process of technical documentation
• Conducted documentation reviews and walkthroughs with IT teams, SMEs, developers, QA testers & other involved stakeholders for approval.

Systems / Data analyst

Confidential, NYC, NY

Responsibilities:

• Performed data profiling, data analysis, data mapping for new DataMart tables, Dimensions, Measures & Logic Calculations
• Performed feasibility analysis for introducing a new reporting tool Business Objects, structured the BO hierarchy folders/subfolders/attributes/standardized reports
• Involved in all phases of requirements approval, design, development, QA/UAT testing, Issue Tracking/Resolution, MTM Alert Mgmt., & post production support (training & manuals)
• Responsible for analyzing, gathering, documenting & finalizing business requirements via JAD sessions, simultaneously interacting with various stakeholders including Claims, Underwriting, Actuarial, Compliance & Finance departments
• Identification of the missing/inaccurate business requirements in current system, created new & modified existing fields after analyzing stakeholder’s needs
• Developed Future State Scope Definition, Global Data Warehouse Glossary, BRD, URS, FRS/FRD, Report Specification documents
• Involved in creating Test Conditions/Cases in several phases of project, i.e. Dev/QA/UAT testing of the newly introduced & modified requirements
• Wrote Test cases and Test Scripts for QA & User Acceptance testing. Pre-Analyzed, researched, evaluated, & gathered business requirements for upcoming JAD sessions in order to exceed the expectation of various stakeholders/departments
• Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders
• Helped testing teams in tracing/verifying requirements from BRD to testing artifacts, including Test Conditions, Test Cases, Test Execution Logs, Test Fail Logs/ Test Pass Logs, MTM Alert Tickets
• Analyzed the various existing Upstream Source Systems feeding data to Global Data Warehouse in various ways, including accessing Front End interfaces applications (Consoles), Source Systems Specifications, Glossary, Report & Source System Data Dumps/Extracts/Files/ Feeds & performing Back End SQL Querying
• Involved in requirements gathering for the integration of several new Upstream Source Systems feeding data to Global Data Warehouse and Downstream Source Systems fetching data from Global Data Warehouse

Business systems analyst

Confidential, Indianapolis, IN

Responsibilities:

• Planning, conducting, documenting, and directing the analysis of complex business problems and processes
• Development and implementation of internal and external workflows
• Translate Business requirements to Functional requirements and User Interface requirements
• Document results from requirements gap analysis. Meet with the business subject matter experts to ensure requirements meet expectations
• Create specifications (Use Case Narratives & diagrams, User Interface Specifications) for systems to meet business requirements
• Identifying, evaluating and developing systems and procedures, which are cost effective and meet user requirements Provide support to the development team for functional requirement issues
• Assist in the writing of the test plans, test conditions and test scripts
• Conduct functional manual testing of the system.
• Train and mentor new Analysts on internal processes and tools.
• Gathering Business and Functional Requirements, Business Requirement Document (BRD developing Use Cases, conducting Gap Analysis and preparing Training manuals.
• Assist in testing application to ensure that the application meets the functional requirements (traceability).
• Document software defects; conduct defect disposition meetings.
• Evaluate Helpdesk defects and issues for problem resolution and resolve tickets as either Unable to Recreate, FAD or logged in as Defect or Enhancement Request.
• Provided consultation to users in the area of automated systems.
• Maintaining and enhancing existing applications to accommodate changes in the business processes.
• Assist project manager with issues and risk identification in all phases of SDLC

SYSTEMS / DATA ANALYST

Confidential, Tampa, FL

Responsibilities:

• Interacted with clients to assess needs, identify key challenges, and define project scope and deliverables.
• Performed Problem Analysis, Research Solutions & presented recommendations.
• Responsible for gathering requirements by interviewing stakeholders, business partners, system end-users and documented BRD & FRD documents.
• Involved in documenting, organizing and tracking all project related documents.
• Acted as a subject matter expert in all aspects of project management including understanding current processes, identifying challenges, providing possible solutions, and project performance monitoring.
• Partnered with the business stake holders, process owners, users to identify their requirements, produced detailed specifications, planned the project deliverables with the software development team, defined QA plan and conducted User Acceptance Testing.
• Validated business requirements based on business requirement document (BRD) and defined scope of the application. Reported status, milestones, and project plan tracking to project management and project owners on a weekly basis.
• Executed SQL queries to test the database backend.
• Defining Test Cases, reviewing and maintaining Test Scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT).
• Involved in designing and documenting Test Cases against the application requirements.
• Evaluated application testing results and recorded the discrepancies on Test Director to track, analyze and generate reports.
• Reported Bugs through Test Director and categorized bugs based on the severity and interfaced with developers to resolve them.
• Coordinated work plans between project manager and client using Microsoft Project.
• Implemented and managed migration process.
• Scheduled and tracked progress of team members through project completion.
• Worked closely with the web development team to help them understand the requirements and supported the implementation efforts by answering questions of the developers related to the business or requirements.

Business/systems analyst

Confidential, Parsippany, NJ

Responsibilities:

• Responsible for defining the scope of the project, gathering business requirements, and document them textually and within models.
• Worked with Business Analysis team to prepare use case models based on Business Requirement Documentation gathered through interaction with users.
• Creating user requirements document for companywide reports by interacting with end users and developers.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• As a liaison between the Developers and Clients, was instrumental in resolving conflicts between business users and technical development teams.
• Involved in project planning, coordination and implementation of QA methodology.
• Performed business process mapping for change requests and new requirements.
• Normalized the data by reducing the redundancy and eliminated inefficient data storage processes.
• Ensured that data systems operate at a high level of performance, including integrity, reliability and availability.
• Responsibilities also included analyzing and testing the user interface & constantly redesigning the system to make it as user friendly as can be for the various business stakeholders & system end - users.

Business/systems analyst

Confidential, Brooklyn, NY

Responsibilities:

• I validated the requirements from both previous independent platforms are included in new centralized platform, along with more security, user-friendly environment, faster performance & with more convenience.
• Involved in analyzing and identifying of the current process flaws in the existing as-are systems.
• Proposed recommendations of business process re-engineering & improved processes for the future to-be-system.
• Interacted with clients to assess needs, identify key challenges, and define project scope and deliverables and performed Problem Analysis, Research Solutions and presented recommendations.
• Worked as a test lead on a project establishing QA processes, defining roles, developing test plan templates, defect tracking, troubleshooting & debugging of the application, coordination among team members and management of work assignments, creating status reports periodically and provided direction and leadership with strong interpersonal and team building skills.
• Involved in creating test plan, test conditions, test scripts & execution. Also, logging in the actual & expected test results.
• Delegated work to other BA/QA resources & provided weekly status reports to upper management on overall testing progress.
• Identified any risks for tasks completion on time & informed of resource allocation issues.
• Responsible for performing Integration and Regression testing and revalidation of functionality following changes to the software, developed extensive experience in preparation of test scenarios/conditions, test cases, documentation and execution of test scripts.
• Evaluated and documented all test results (defects/explanations) and performed thorough analysis for variations from the expected results.
• Used Rational Clear Case to track changes to multiple artifacts by versioning artifacts, associating requirements specific change requests to streamline the defect/change tracking process.

Business systems analyst

Confidential, Farmington, CT

Responsibilities:

• Wrote Business & Functional Requirements, including QA and UAT test plans for several different “old legacy system’s applications implementation, a major hardware upgrade, and a major consolidation of three legacy systems deployment into a new web-based centralized system.
• Acted as primary liaison between the client departments and Information systems IT department.
• Performed analysis, review, and estimation of client requests; prepared and reviewed system requirements, and client documentation.
• Project duties included multiple task project assignments, scheduling and tracking; facilitating meetings with all levels of the business community for requirements gathering, project development, design considerations, impact and risk analysis, and quality control of client acceptance testing.
• Experienced in Process Optimization and Business Process Reengineering, streamlining existing processes.
• Analyzed the existing as-is system, tracked defects, provided recommendations to make enhancements in the future to-be system.
• Planned and defined system requirements traceability to Use Case, Use Case Narratives, Use Case Diagrams and Sequence Diagrams.
• Involved in Implementation and post production support when the application went live.
• Created product documentation, including online help, user manual and training materials for UAT & other end-users.