Summary

IT professional with diverse Business Systems Analysis experience, SQL database development analysis, BI development, business requirements elicitation, development of technical specifications, technical writing, change management, gap analysis, risk management, troubleshooting and issue resolution. Adept and experienced with all phases and methods of System Development Life Cycle SDLC, primarily focused on web - based solutions in a .NET environment and applications involving relational databases. Flexible problem solver, able t communicate effectively at many levels eager t undertake new projects and challenges.

• UML Data Flow, Workflow Process Modeling
• BRD, FRD, HLD Composition
• Use Case User Story Development
• In-Depth Data Analysis Troubleshooting
• Full Test Cycle Development, Execution, Analysis, Management Reporting HP Quality Center
• Agile SCRUM Methodology Experience
• SQL Development 16 years through v2012R1
• Release Notes Systems Documentation
• SharePoint Server 2007, 2010 2013 with migration
• Gap, CBA ROI Analysis
• MS Dynamics ERP including AX, GP CRM
• Salesforce.com multiple implementations
• Help Systems Author/Technical Writing Experienced in SOX Compliance Requirements
• Change Management Issue/Defect Management
• Visual Studi 2005/2008/2010 with TFS.
• Crystal/Business Objects Development
• SAS70 Compliant Systems Development
• Joint Application JAD Development Experience
• Risk Analysis and Mitigation Planning
• MS Project, JIRA, Rally, Innotas, TeamPulse

CONFIDENTIAL Analyst

• Responsible for developing, maintaining and supporting process improvements for the Corporate ERP systems including MS Dynamics GP Great Plains and MS Dynamics CRM, and integrated systems.
• Finalized BETA release of new Payment Requisition System with full integration and auto-posting with MSDGP across 45 corporate entities, including Job Costing integration with GP and WennSoft, custom workflows and related system notifications t support existing business processes, bringing 2012 Olympic Idea t fruition as an enterprise-wide multi-national system.
• Assisted the ERP Team with implementations, upgrades, and 3rd party products.
• Worked primarily with the financial accounting department GL, Bank Rec, Fixed Assets and shared services A/P, A/R, Collections with regard t integrations and process improvements, addition t New Site Development Team for custom MS Dynamics CRM projects.
• Delivered excellent service through actively learning the company's business and business processes, responding t the needs of the internal customers, and following through on commitments.
• Maintained a standardized project requirement request process, including templates and forms, used by end users when requesting a new process improvement / project.
• Worked with requesters/ business partners t define process improvement / project scope and objectives and assist where needed in development of ROI and Business Justification analysis.
• Developed business process models and IT functional documentation for areas of responsibility.
• Prepared functional specifications for new process improvement and/or system development and/or changes t be developed.
• Provided detailed technical requirements submitted t IT for project development.
• Involved with the implementation planning for new software enhancements, upgrades, system processes and/or 3rd party products from a functional perspective.
• Actively managed, and maintained project plans Microsoft Project, JIRA and Innotas for current initiatives.
• Responsible for developing, maintaining and supporting process improvements for the Corporate ERP systems including MS Dynamics GP Great Plains and MS Dynamics CRM, and integrated systems.
• Finalized BETA release of new Payment Requisition System with full integration and auto-posting with MSDGP across 45 corporate entities, including Job Costing integration with GP and WennSoft, custom workflows and related system notifications t support existing business processes, bringing 2012 Olympic Idea t fruition as an enterprise-wide multi-national system.
• Assisted the ERP Team with implementations, upgrades, and 3rd party products.
• Worked primarily with the financial accounting department GL, Bank Rec, Fixed Assets and shared services A/P, A/R, Collections with regard t integrations and process improvements, addition t New Site Development Team for custom MS Dynamics CRM projects.
• Delivered excellent service through actively learning the company's business and business processes, responding t the needs of the internal customers, and following through on commitments.
• Maintained a standardized project requirement request process, including templates and forms, used by end users when requesting a new process improvement / project.
• Worked with requesters/ business partners t define process improvement / project scope and objectives and assist where needed in development of ROI and Business Justification analysis.
• Developed business process models and IT functional documentation for areas of responsibility.
• Prepared functional specifications for new process improvement and/or system development and/or changes t be developed.
• Provided detailed technical requirements submitted t IT for project development.
• Involved with the implementation planning for new software enhancements, upgrades, system processes and/or 3rd party products from a functional perspective.
• Actively managed, and maintained project plans Microsoft Project, JIRA and Innotas for current initiatives.

CONFIDENTIAL

Contract Business Systems Analyst

• Document the business case, objectives, scope, and assumptions for e-commerce platform, including integration requirements with Salesforce.com SFDC, Zuora, NetSuite and multiple payment gateways for international e-commerce in multiple currencies.
• Responsible for establishing and following project standards, including document management/storage, communication methods, status reporting, risk and issue identification and time keeping.
• Conduct interviews, requirement elicitation sessions, task analysis, workflow analysis and a variety of analytical and product management techniques t understand and interpret business needs.
• Proactively communicate and collaborate with internal and external customers t analyze information needs and deliver functional, GUI, screen and interface requirements.
• Critically evaluate information gathered from multiple sources and reconciles conflicts, decomposes high-level information int details, abstracts up from low-level information t a general understanding, and distinguishes user requests from true needs.
• Accountable for mapping and analyzing processes, business process re-engineering and process improvement required t arrive at an optimized solution.
• Experienced nearly 20 years in all phases of SDLC, following various methodologies, including Agile, XP and Scrum .
• Utilize JIRA and Confluence by Atlassian for Agile Project and Requirements Management, with Scrum and Kanban planning tools.
• Collaborate with developers and subject matter experts t establish the technical vision and analyzes tradeoffs between usability and performance needs.
• Interact professionally with a diverse group of executives, managers, and subject matter experts in various business departments and throughout the IT organization.
• Participated in the development and execution of QA and end-to-end integration testing.
• Developed and delivered end-user technical training.

CONFIDENTIAL

Contract SharePoint Data Analyst

• Performed analysis for ongoing audit and migration efforts, as well as at the request of management requests, utilizing Axceler Control Point reporting tool. Reporting included security, audit, content, storage, configuration etc. throughout multiple farms.
• Gathered, analyzed, and normalized relevant data related t and from business processes, functions, and operations in order t evaluate data credibility, and determine ownership and content type.
• Evaluated and gathered data required t perform data security audit and migration requirements for over 1500 SharePoint 2007 Sites in multiple farms across many business units worldwide.
• Provided Tier 1 end-user support for Business Level Site Administrators.
• Utilized InfoPath, SharePoint Lists and SharePoint Surveys t gather, store, analyze and manage data collected throughout the project.
• Created single-source data repository t determine allocation of SharePoint users across divergent corporate entities ADT and Tyc, from 5 different sources.

CONFIDENTIAL

Contract Senior Business Systems Analyst

• Performed Business Process Analysis, necessary t prepare UML business process flows and Use Cases.
• Prepared Business Requirements documents and Test Plans for interim and major system enhancements for proprietary Crew Production System CPS, including integration with MS Dynamic SL MDSL .
• Data analysis utilizing SQL Server 2008 R2.
• Executed QA cycle using HP Quality Center 11.0, executing manual and automated tests, reporting results using standard and custom reporting.
• Assisted with full implementation of CPS system, including integration with MDSL for out-of-state subsidiary, including two-week dual system, followed by cutover and post implementation testing and troubleshooting.

CONFIDENTIAL

Contract Senior Business Systems QA Analyst

• Responsible for analysis and review necessary t refine business requirements, define functional requirements and specifications, and provide traceability throughout the SDLC lifecycle.
• Involved in most aspects of the project life cycle, including requirements gathering, functional specifications, high level design review, development input and feedback, testing management execution, data mapping, documentation of integration requirements and internal training for enterprise level Pricing Promotions system.
• Supported internal business partners and 3rd party vendor consultants, in relation t business application needs, working closely with business partners and IT members t understand end-to-end business processes.
• Performed business analysis by participating in business requirements reviews, and preliminary design sessions.
• Responsible for researching, analyzing and documenting business requirements as provided by business partners for use in designing, integrating and implementing custom built and integrated OTS applications.
• Initiated and maintained ongoing gap analysis, providing input t business case scenarios for project approval.
• Developed Use Case library as part of ongoing gap analysis and supporting functional specification documentation, with traceability from business requirements, t use cases, t system functionality, test coverage in HP Quality Center and Test Cycle execution.
• Accountable for review, feedback, modifications and final approval of all test case drafts presented by 3rd party vendor off-shore team, prior t inclusion in Quality Center Test Plan.
• Maintained Use Case Test Case development ongoing state and status details, with effort estimates and target delivery dates for weekly and on-demand review with Portfoli Manager and IT Director.
• Acted as mentor and coach for four Business Analysts over nearly 6 month contract, training tw newest contractors t take over QA test execution after only 6 weeks on the project.
• Maintained shared project notebook with Microsoft OneNote 2010, t provide background information resource for current, new and future analysts and other team members.
• Utilized the following systems and tools on this project:
• MS Office 2010 with Visi 2010 and OneNote 2010
• IBM iSeries AS400 Enterprise System related DB files
• SQL Server
• HP Quality Center 10.0
• Lotus Notes
• Clarity Project Management
• Enterprise Document Management EDM custom solution

CONFIDENTIAL

Contract Business Systems Analyst

• Lead Business Systems Analyst for 16-week phase of new integrated solution t support Florida Virtual School Admissions and Registration A R processes.
• Elicited business, functional and system requirements as facilitator of approximately 48 Requirements Elicitation and JAD sessions over 9 weeks, involving 60 project stakeholders.
• Prepared and distributed Meeting Minutes for each of the approximately 48 sessions indicated above within 48 hours of each related session.
• Composed 7 detailed Business and 7 Functional Requirements documents BRD FRD in parallel with requirements elicitation and JAD sessions.
• Ensured adherence t SIF Schools Interoperability Framework standards was addressed in all requirements and design documentation.
• Ensured compliance with Florida Department of Education FLDOE data reporting requirements was addressed in all related documentation.
• Performed Business Process Analysis BPA of existing Admissions and Enrollment related processes.
• Documented BPA results utilizing BPMN standard for as-is and proposed business processes.
• Developed Business Rules Management System BRMS and Business Rules Engine BRE Policy and Vocabulary guidelines.
• Composed, verified and linked 1100 Business Rules t associated requirements and data and user interface UI elements.
• Provided collaborative input, working with Enterprise System Architect, t compose and Non-Functional Requirements NFR Document.
• Provided collaborative input, working with Enterprise System Architect, t compose and revise Systems Integration and Data Migration High Level Design HLD Documents and Entity Relationship Diagrams ERD .
• Composed and collaborated with Enterprise System Architect and Solution Development Team on data integration, and ETL documentation.
• Developed SharePoint Use Case Library comprised of UML Use Case Diagrams and 275 related Use Case narratives.
• Decomposed high-level business and user requirements int functional requirements specified in an appropriate level of detail suitable for approval by executive stakeholders and use by Design, Development and QA teams.
• Identified quality attributes, external interfaces, constraints and other nonfunctional requirements.
• Participated in peer reviews and inspections of project management, requirements, design, architecture, integration and quality assurance QA documents.
• Managed requirements Traceability Matrix, tracking requirements from BRD through t UAT, including traceability t Use Cases/User Stories, Test Cases and Business Rules.
• Composed Risk Management Plan and managed RAID log and mitigation plans for the project.
• Managed changes t baseline requirements through application of change control processes and tools such as SharePoint, Microsoft Project and Axosoft OnTime.
• Provided Project Management support by developing shared project team virtual on-line notebook using Microsoft OneNote 2010, Windows Live and SharePoint, as well as newly created project deliverables status reporting documentation.
• Prepared weekly status reports and supported PM resource time tracking.
• Trained and provided onboarding guidance and knowledge transfer for offshore business analyst.

CONFIDENTIAL

Data Analyst Business Systems Analyst

• Engaged t analyze the existing structure of organization's systems, identify bugs and recommend next steps.
• Supported ongoing operations requirements by implementing solutions for issues identified. Corrected existing VB Scripts, batch jobs and VBA Macros.
• Handled day-to-day operations such as immediate data changes and end-user issue resolution, t ensure accuracy of business functions.
• Enhanced existing with SQL Server 2008 SSIS packages, improving database performance, disk space management and integration with MAS90 Accounting package.
• Worked with SSRS, Crystal Reports, MS Excel, t meet operational Business Intelligence needs, providing issue resolution as well as new development.
• Conceived and initiated new development projects t more adequately address current and future business needs.
• Developed logical and physical data models along with data mapping and business rules using ER Studi Enterprise Architect and SQL Server 2008 R2 for new ODS and data warehouse.
• Acted as VSTS/TFS Administrator, utilizing Visual Studi Professional 2010.
• Acted as Project Manager, Database Designer and Business Systems Analyst for global development project t support distribution processes.
• Created data lineage documentation, providing detailed specifications for systems integration, along with associated ETL and business rules.

CONFIDENTIAL

Contract Business Systems Analyst

• Lead Analyst for SharePoint 2010 enterprise project for development of VPM Virtual Project Management Office.
• Responsible for requirements elicitation, business analysis, business requirements, functional and technical requirement documentation for Microsoft Dynamics AX ERP System and Website Development projects.
• Held Visual Studi TFS Administrator Role using Visual Studi Ultimate 2010, creating a customized Agile SDLC Process Workflow.

CONFIDENTIAL

Contract Business Systems Analyst

• Responsible for requirements elicitation, business analysis, business requirements, functional and technical requirement documentation.
• Development of Business Rules Engine requirements and specifications.
• Focused on Salesforce.com integration project with SAP, ODS and existing CRM system.

CONFIDENTIAL

Contract Business Systems Analyst

• Responsible for requirements elicitation, business analysis, business requirements, functional and technical requirement documentation.
• Execution and management of QA and UAT cycles, including Test Plan development and Test Case development, execution and reporting.

CONFIDENTIAL

Contract Business Systems Analyst

• Responsible for requirements elicitation, business analysis, business requirements, functional and technical requirement documentation.
• Diagram and document Business and Development requirements using UML authoring tools.
• Data analysis for multiple projects, with 6 different databases.
• Analysis, SQL development and PM support for multiple web development projects, throughout all phases of the SDLC, including front-end and back end integration with CampusVue and external partner systems.
• Extensive involvement in and management of QA and UAT cycles, including Test Plan development and Test Case development, execution and reporting.
• Detailed database comparisons between CampusVue, ODS and CRM with full documentation recommendations for architectural and data model changes and related SQL scripts.
• Responsible for identification, analysis and documentation of all data elements related t integration points, including extensive data mapping between all interfacing systems 6, including CampusVue, for the Simulated Degree Audit, KNEXT Data Mart Business Rules Engine projects with mapping as well as ETL specifications for internal and external interfaces.
• Development of expressions required t support implementation of Business Rules for Kaplan's Simulated Degree Audit, Course Equivalencies Award of Transfer Credit processes.
• Point person for all external and internal partner representatives, in addressing any integration questions and issues.
• Provide project management support by developing detailed Work Packages, Tasks, Use Cases, Iterations, Tasks, Defects, Test Cases, etc. for Agile Development support using Rally Project Management software and MS Project 2007, including reporting, reconciliation communication of same.
• SharePoint Administrator for KNEXT Team sites.
• Rally Project Management Tool Administrator for KNEXT Development team.

CONFIDENTIAL

Senior Systems Analyst

• Managed and performed Business and Technical Analysis for multiple systems development projects.
• Project Management for multiple web development projects simultaneously, throughout all phases of the SDLC, including but not limited t design and redesign of front-end and back end integration of systems for the following consumer websites
• Project Management and Lead Business Systems Analyst responsible for management and analysis throughout all phases of the SDLC, including GDS Global Distribution System integration of Kerzner Central Reservation System KCRS with Expedia.com and Hotels.com Direct Connect API, communicating consumer travel bookings and resort inventory, rates and travel restrictions via Expedia's proprietary API, using XML and BizTalk.
• Created and maintained system design and end-user documentation.
• Project Management and Lead Business Systems Analyst responsible for requirements elicitation, business analysis, business requirement and technical documentation for GDS Integration with SynXis for interfaces with multiple Web Partners including Travelocity, Orbitz, Priceline.com, Sabre and Worldspan.
• Involved extensively in management of QA and UAT cycles, including test plan development, test case management, reporting, troubleshooting and resolution.
• Managed integration projects for KCRS t Micros Opera/OXI, Oracle based Property Management Systems for multiple resort location implementations beginning with Mexic Dubai, project t be used as the prototype design for future resorts in Cape Town, Morocc and beyond.
• Conducted business user training and supported business users in transition from UAT t Production environment.
• Provided key interface design direction based on analysis results for front end as well as key systems integration interfaces, including development of proprietary CRM/Contact Management Data Mart KCCM for integration with KCRS 2.0 release and further integration with EDW.
• Analyzed SQL stored procedures, functions and database architecture t support analysis efforts and aid in troubleshooting production issues.
• Diagramed and documented Business and Development requirements using UML authoring tools.
• Administrator of Issue and Change Management process utilizing Elementool online issue tracking.
• Prepared and managed detailed project plans with MS Project communicated project details and status via MS Project reporting and SharePoint workspaces.

CONFIDENTIAL

Systems Analyst/Technical Writer

• Managed documentation standards, process, and production.
• Developed and maintained data dictionaries for multiple databases on Dev, Stage, UAT Production platforms.
• Created and maintained development and end-user documentation.
• Evaluated the effectiveness of documentation, and sought ways t improve its delivery and economy.
• Created and maintained documentation standards and documentation processes.
• Utilized authoring tools such as RoboHelp, ApexSQL Doc, Data Architect, DocToHelp as well as full MS Office Suite.
• Analyzed and documented SQL stored procedures, functions and database architecture t complete reverse engineering documentation projects.
• Documented existing application code through use of Visual Studi VB.Net and UML authoring tools.
• Acquired thorough understanding of programming and software architectures.
• Responsible for analysis, design, development, implementation and maintenance of help systems and complete SDLC documentation in multiple environments.

CONFIDENTIAL

Contract Business Systems Analyst/PM

• Led web start-up project from concept t launch through the entire development life cycle.
• Developed business corporate strategy, including off-shore corporate and banking infrastructure.
• Created detailed project plans for multiple web-based applications required t implement and support new concept in online fantasy sports competition with real-time statistics procurement and calculations, managing individual projects according t business requirements and goals.
• Coordinated all project required cross-functional team deliverables for C, AJAX, SQL 2005 based .NET 2.0 Development initiatives.
• Played key role in SQL2005 System Architecture Design, Development documentation.
• Provided web-page wire frame and storyboard style functional and technical specifications for all systems design initiatives.
• Established web-based revenue management tools, including ACH processing fraud risk management.
• Managed stakeholder expectations and kept all stakeholders fully informed of project budgeting, forecasts, current status and risks.
• Implemented and managed SharePoint web portal for project management, team collaboration defect tracking.
• Worked closely with Development Team, System Architect, QA, banking and legal contacts, as well as other functional groups in various combinations for JAD sessions throughout complete systems development lifecycle.
• Supervised internet marketing, customer service and help desk resources, managing expectations and acting as escalation point for key issues.
• Planned and administered team meetings. Reported project status and issues. Communicated meeting agenda and results.

CONFIDENTIAL

Business Systems Analyst

• Communicated with management and end-users t achieve understanding of business requirements, and analyze business processes and software requirements t author SRS documents, functional and technical specifications, risk assessments, cost benefit analyses and operational process flows.
• Ensured Projects' SOX Compliance and adherence t SAS70 Standards throughout all phases of SDLC.
• Developed technical specifications, SQL stored procedures, test plans and follow-up necessary t provide client requested Data Mart/Data Warehousing solution within limited timeframe, employing diverse resources t realize a fully implemented and functional product, including daily subscription service data updates.
• Provided comprehensive application support for newly implemented mortgage origination application self-trained in use of application, developed script library providing workarounds for defects, data and user errors.
• Documented processes t facilitate training and management for team of 3 support and 3 business analysts.
• Completed extensive data analysis, sanitation and transformations DTS required for annual data submission t Federal Reserve Board on behalf of multi-national mortgage lending client for 2004 and 2005 independently managed ETL and reporting projects provided feedback and detailed specifications for future application and database architecture enhancements t improve reporting efficiency and data accuracy.
• Identified application and ETL defects, resulting in 10.8M savings t client in terms of E penalty fees.
• Monitored and managed incoming XML message handling and outbound message hub functionality t identify XML message generation defects and reduce outbound failures by 72 within first 6 months.
• Supported Project Management administration as needed, maintaining internal and external client relationships, project prioritization, scope change management, release management, while continuing t perform BSA duties.

CONFIDENTIAL

Application Systems Analyst

• Developed standard process and documentation set for client implementations and upgrades t improve efficiency, reduce upgrade errors and provide reduction in training time required for new Support Analysts.
• Independently managed caseload and client communication worked with users and management t translate business rules and needs int technical specifications and reporting requirements.
• Reached goals of seasoned analyst and achieved 6 month bonus after only 1 month in rotation.
• Handled troubleshooting of Campus2000 data inconsistencies, application errors and reporting functionality.
• Corrected data as necessary through the SQL scripting and SQL Stored Procedures Modified and created custom reports with Crystal Reports, SQL Views and Stored Procedures.
• Tested new product releases as needed, providing error and defect tracking via Rational ClearQuest system.
• Installed and upgraded applications remotely, performing SQL Server Backup, execution of stored procedures necessary t update database objects consistent with release or patch requirements.
• Participated in QA and UAT Test cycles for new Campus Portal CampusVue product.

CONFIDENTIAL

E-Commerce Project Manager

• Managed implementation of new corporate website within 30 days of initial launch goal, increasing web-based leads from 15 weekly t over 1000 through innovative search engine optimization, meta tag placement and site traffic management and analysis.
• Managed requirements gathering and development of realtor websites for approximately 80 of 1300 independent-contractor associates, achieving 100 roll-out of new associate sites in less than 90 days.
• Facilitated the data aggregation of 9 diverse MLS systems int single SQL 2000 Server data repository, utilizing custom DTS package designs and diverse data transfer methods, including ftp push/pull subscriptions, XML on-demand messages and flat file submissions.
• Assessed and translated business needs from end users and top level management int product specifications and requirements, in order t improve web-based software and data value.
• Initiated web package brand name PRIMA Prudential Real Estate Internet Marketing Advantage, later trademarked and used Prudential Real Estate Affiliates internationally.
• Designed and conducted software training and performed network troubleshooting throughout the state for 28 offices and 1500 contractors and employees.

CONFIDENTIAL

Self Employed

• Managed intranet, registering new users, assigning permissions and training new users.
• Assisted in design and provided initial implementation for intranet based project management and change control tools for new product development division within Motorola, using Access 97, VBA, Microsoft Front Page 2000 and MS Project.
• Conducted training for New Horizons, Computer Coach and other corporate clients on latest desktop applications.
• Designed Outlook/Exchange training program for Repath Macauley Woods Insurance, providing needs assessment, post training testing, network and software setup, for locations locally and out-of-state using LAN/WAN setup wireless networking.
• Daily network administration and support, firewall administration, virus protection, security analysis, hardware and software upgrades, hardware and software inventories and updates, daily backups for multiple servers, creation of new users and modifications t user accounts for Global Marketing Corporation.
• Windows 2000, Domin Server/Lotus Notes, SQL 2000 administration.
• Provided VB code review analysis for Asterix Software, designed standard and customized reports for individual clients using SQL and Crystal Reports.

CONFIDENTIAL

Technical Support Analyst

• Administered all phases of purchases from contract and addenda processing through closing and beyond
• Provided weekly, monthly and quarterly status reports for internal departments, corporate headquarters and financial institutions.
• Responsible for the design and implementation of new database system t integrate all information pertinent t sales, legal, accounting and construction departments. Upon completion, system was als used by outside counsel.
• Designed all reports, HUD-1 Settlement Statements, pre and post-closing forms, and mass mailings as part of real estate closing preparation with Access, SQL and Crystal Reports.
• Involved with all post-closing reconciliation and disbursements, including association fees, real estate taxes, verification of construction loan paydown, distribution of information internally and final coordination between buyers, customer service, attorneys and brokers.