We provide IT Staff Augmentation Services!

Sr. Business System Analyst Resume

MI

SUMMARY

  • Extensive working noledge of all teh phases of Software Development Life Cycle (SDLC), and have experience in traditional waterfall, spiral and agile methodologies such as Extreme Programming (XP), Scrum, Kanban, ASAP and Scaled Agile Framework (SAFe 4.0) and Waterfall - scrum hybrid.
  • Highly skilled in structured planning methods for project evaluation including GAP Analysis, SWOT Analysis, Cost-benefit Analysis and Feasibility Analysis.
  • Experience in conducting Workshops wif Business Groups, Joint Application Development (JAD) sessions wif IT and Conflict Management wif Project team.
  • Excellent Business writing skills in writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications, Systems Requirements Specification (SRS), Functional Requirement Document (FRD), Data Requirements and Workflows.
  • Assisted Project Managers in preparing Project Plans, Project Schedules, establishing Milestones, Work Breakdown Structure (WBS), maintained RACI chart to manage overall project risks and mitigation plans.
  • Excellent noledge in dataflow analysis of teh system using use case diagrams, dataflow diagrams, state diagrams, activity diagrams, flowchart diagrams and collaboration diagrams.
  • Documented teh Functional and Technical Specifications requirements based on teh business flow for MM, HR, FI, CO, SD modules in teh existing Legacy systems.
  • Maintained a structured approach in organizing requirements to ensure dat critical business rules and requirements are met wif teh halp of Requirement Traceability Matrix (RTM).
  • Designedand implementedSQLqueries usingjoins,unions,outer joins, group byandaggregatefunctions to extract data from differentdatabasesfor timelyreportingandValidation.
  • Expertise in creating Data Models like Conceptual data model, Physical data model, and logical data model in teh form of entities and relationships to capture teh user requirements properly in teh underlying database.
  • Practical noledge of Data Warehousing architecture, implementation approaches, dimensional modeling and translating teh business requirements into various types of dimensions and performed source to target mapping.
  • Detailed understanding of application development in Microsoft Access and Excel, VB.Net, Mainframe Technologies, COBOL, JCL, SAS, HTML, CSS, SQL, SSIS, Forms, and Desktop applications.
  • Cultivated experience in working wif different web services such as HTML, WSDL, SOAP, UDDI, REST, JSON under various architectures like Three-Tier Architecture and Service Oriented Architecture (SOA).
  • Documented requirements for API development i.e. was responsible for technical writing using both XML and JSON. Used SOAP UI and Postman for API testing.
  • Adept at supervising Manual Testing, Automation testing, Black-box Testing, Sandbox testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, Security Testing, Load/Stress Testing and Performance Testing along wif User Acceptance Testing (UAT) and halped in designing and developing test plans and test scripts.
  • Experience in SAP BW and SAP BEx tools such as BEx Analyzer, Query Designer and Report Designer. Expertise and experience in areas of SAP HANA Modelling including S/4 Hana, SAP UI5 and Fiori, SAP Lumira, Dashboards, SAP BO Explorer. VB. Net and ETL tools.
  • Experience wif working in Test Driven Development (TDD), and Behavior Driven Development (BDD) environments.
  • Excellent communication, analytical and time management skills, wif capability to handle new technologies and situations and an ability to lead, manage and work in challenging environments.
  • Experienced in conducting Data Analysis using design of experiments in Minitab and Tableau for dashboards
  • Team player and self-starter wif excellent coordination, documentation, project planning and interpersonal skills wif proven ability to work under pressure, prioritize and meet deadlines.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-Scrum, Kanban, Waterfall-Scrum Hybrid, XP, ASAP, RUP

Requirement Management: Atlassian-JIRA, CA Agile, HP-ALM, iRise and VersionOne

Project Management Tools: Microsoft Office: Excel, Word, Lotus, VISIO, MS Project, PowerPoint, Web conferencing.

SAP Modules: SAP ERP, SAP ECC 6.0, MM, PP, ME, WM, FICO, MRP, SD, SAP Business Objects, SAP NetWeaver BW, SAP S/4 HANA, SAP Fiori 2.0, SAP Fiori

Business Modeling tools: Oracle Enterprise Report Builder, Crystal Reports, SAP BI Solutions, COGNOS BI, Informatica Power Center 8.x/9.x, SSIS, SAS

Modeling Tools: MS Visio, Draw.io, Google Drawings, iRise, Solman

Testing Tools: HP Quality center, Selenium, Load Runner, Cucumber, Swagger, SoapUI

Web Service: SOAP, REST, AJAX, XML, JSON, WSDL, WADL, XSD, DOM

Reporting Tools: Tableau, MicroStrategy, MS office suite, Google Analytics, SAP Lumira, BEx Analyzer, Web Intelligence, Crystal Reports, Sap Dashboards - Xcelsius

Languages: COBOL, JCL, REXX, PL1, VSAM, CICS, SQL, CSS, XML, HTML5, SQL, .NET, ABAP

Databases: MySQL Server, DB2, Oracle Developer, PL/SQL, SAP HANA DB, Oracle 11i, SQL Server 2000, dbuniserv, QMF, SQuirreL

Business Skills: Conflict Management, Project Planning, Impact Analysis, Route Cause Analysis, Gap Analysis, SWOT Analysis, Fit/Gap Analysis, Delta Design Workshops

Other: FTP, SFTP, Accounts Payable, Accounts Receivable, Procurement, Vendor Management, Use Case Diagrams, Sequence Diagram, UML, Scrum, Agile Methodologies, MDM

PROFESSIONAL EXPERIENCE

Sr. Business System Analyst

Confidential, MI

Responsibilities:

  • Developed reports and suggestions after conducting GAP Analysis between AS-IS and TO-BE process.
  • Conducted JAD, Interview sessions, Fit/Gap Analysis, Delta Design & Solution Validation Workshops and questionnaires to elicit teh requirements.
  • Drafted Business Requirement Document (BRD), Functional Specification Document (FSD) and Solution Design Document wif teh halp of multiple teams involved in teh enhancement of teh system
  • Assisted Project Manager in performing Impact Analysis, Feasibility Study/PEST Analysis, Cost-Benefit Analysis and mitigate certain risks associated wif teh project and project output.
  • Developed Functional Specifications Document dat outlines required Characteristics, Measures and Business Rules. Prepared Data Flow Diagrams, Activity Diagrams, Swim Lane and Sequence Diagrams, Data Migration Approach and track them in SAP Solution Manager.
  • Created Wireframes, Mockups and Interactive Prototypes wif robust collaboration and Inline requirements, Agile requirements Management, ability to integrate wif teh tool of other platforms using iRise.
  • Recommended teh use of a cloud, shared infrastructure & application roadmap to reduce costs and improve how information flows supporting high levels of automation and ensuring a seamless end-user experience.
  • Worked wif HANA Data Models like Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union teh various Attribute and Analytic Views for report consumption wif time dimensions.
  • Managed multi-data source challenging reports by merging data from multiple Data Sources to Target data using Web Intelligence WEBI and SAP HANA Migration Cockpit.
  • Implemented SAP Best Practices Solution Builder for Solution configuration and tracking Integration and Development Requirements while building teh XSJS, XSOData and OData RESTful services.
  • Documented teh REST API requests and responses in XML format using SAP API documentation templates.
  • Used Prioritization and Estimation techniques for better time management and deliver quality results.
  • Developed Test scripts and involved in conducting Data Migration Testing, Regression testing and User Acceptance Testing UAT using SAP HANA Deployment Studio.
  • Developed reports using SAP Fiori 2.0 to communicate information using graphs, charts and other info graphical solutions to teh project team.
  • Conducted User Trainings and created Operation Manuals while handing over teh project to Production Support.
  • Executing Organization Change Management Plan while deploying teh system and when Data Migration is completed. Documented all identified issues during transition.
  • Expert in integrating SAP, Non-SAP data to SAP BI, SAP HANA by designing Data provisioning ETL techniques, data flow and reporting solutions wif Fine-tuned BW/HANA wif ABAP and recommended corrective action.
  • Knowledge of SAP S/4 HANA for real time reporting and positioning BW wif S/4 HANA CDS Views based on SAP best practices. Had created reports using SAP BO Analysis Office 1.3 and 1.4 for multidimensional ad-hoc analysis of Headcount Analytics data from SAP BW and HANA in Excel.

Environment: Scrum Hybrid, SAP S/4 HANA 1610, SAP Fiori 2.0, Crystal reports, BEx analyzer, SAP Lumira, Predictive Analytics, Xcelsius, SAP S/4 HANA Migration Cockpit (MC), ASAP 8 Methodology, Kanban board, JIRA, XSJS, XSOData, OData, SAP ECC 6.0, JCo, JavaScript, HTML5, XSJS, iRise, SolMan, Xcelcius, SAP UI5.

Sr. Business System Analyst

Confidential, Framingham, MA

Responsibilities:

  • Participating in Global SAP Business Blueprinting- Creating Process Definition Document, User Requirements Specifications, Key Design Decision Description and GAP Analysis and Testing Strategy documents.
  • Analyzing customer “AS IS” business process and mapping ‘TO BE’ business processes.
  • Prepared Business Requirement Document (BRD) from teh elucidated requirements and halped teh Product Owner and Development Team in making User Stories by using Three C’s.
  • SAP Configuration of MM-IM requirements, including Plants, Storage Locations, MRP and Forecasting data. As well, teh Purchasing requirements for internal sources (Stock Transfer Orders), including Purchasing Groups and Special Procurement Types.
  • Developed mock-ups and wireframes along wif teh screen designs to make better UI designs.
  • Helped teh team to split user stories into tasks meeting teh SMART criteria. Values of collaboration and agile principals and explained teh team how important was to operate as a self-organizing entity.
  • Gathering MM and WM business process procedures (BPP) documentation for preparing Test Plan.
  • Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
  • Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to halp development of an accurate Data Warehouse Structure.
  • Assisted core team members for designing and configuration of SAP MM, WM, and SRM modules- Warehouse goods receipts and issues, cycle counting process, warehouse replenishment, warehouse management movement types, WM interface to QM and configuration of master data including material master, and bins/warehouses/storage locations.
  • Guided large development teams, including Backlog Refinement, Sprint Planning, Daily Stand Up, Retrospectives, Management Reporting, and presentation of Sprint results to teh Client
  • Actively involved in teh Testing functionality of Purchase Requisitions, Shopping Carts and Purchase Orders in DEV/ QA instances before Migrating to UAT and PROD Instances.
  • Working wif Integration Testing Lead to developing Testing scenarios; String testing, Integration Cycle Testing and Interface Testing for Make to Deploy (QM/PP), Procure to Pay (MM/SRM), Plan to Schedule, Order to Cash (SD), Hire to Retire (HR), Record to Report (FI) and Lead to Customer (CRM) business processes (BPs).
  • Used Postman to Test and Document SOAP & RESTful using GET/POST/DELETE methods.
  • Involved in providing Production Support, User Training, and problem resolution in almost all areas of SD, MM, PP, ME, FICO Modules and Cross-Functional Applications

Environment: Scrum Hybrid, ASAP Methodology, SAP systems, SD, MM, PP, ME, FICO, components and tools: SAP ERP R/3, ERP2005 / ECC6.0, SAP Solution Manager, HP Quality Centre, Quick Test Pro, IBM Rational Functional Tester, Load Runner, Jira, Database SQL testing

Sr. Business System Analyst

Confidential, Boca Raton, FL

Responsibilities:

  • Performed GAP Analysis by understanding teh AS-IS business process and TO-BE business process and created business process model and notation (BPMN).
  • Conducted several workshops wif teh business team to understand and document teh business purpose and data owners of all teh attributes and developed business rules for data migration.
  • Identified business requirements for Procure to Pay and Order to Cash cycles working closely wif teh business team and mapped them to teh Oracle application functionality.
  • Worked wif other Business Analysts to prepare Business Requirement Document BRD and Functional Requirement Document FRD by conducting data analysis using teh Data Extracts.
  • Worked wif other Process Modelers in creating Target Process Model TPM by understanding teh Standard Operating Procedures (SOP) and developed current and target state Process Flow Diagrams.
  • Configured teh Oracle Applications to meet teh client requirements and documented application set-ups.
  • Designed data models and conducted Normalization and De-Normalization of teh data as per teh Online Transaction Processing (OLTP) and Online Analytical processing (OLAP) frameworks for data analysis.
  • Coordinated wif teh other business analysts and assisted in Data modeling, Data mapping and Data extraction and Integration in teh data mart by using teh Informatica Power center from teh legacy systems.
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
  • Extensively used Informatica power center for extraction, transformation and loading process. Implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
  • Worked wif teh Development team to deliver teh implementation of P2P and O2C modules.
  • Prepared testing schedules and coordinated testing activities and worked closely wif internal business groups and third-party vendors to ensure teh successful implementation of new modules.
  • Managed teh testing process of teh application wif teh client and vendor resources. This included documenting positive and negative test scripts/cases, tracking and managing resolutions of issues, executing test scripts and documenting results.
  • Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result. Performed SQL validation to verify teh data extracts and record counts in teh database tables by writing complex SQL minus queries.
  • Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all teh Test Cases in Quality Center wif Pass/Fail/Blocked status. Extensively worked wif backend activities for testing several reports developed by BI tools. Wrote several complex SQL queries.
  • Involved in systems integration testing, web services API testing using SOAP UI.
  • Developed end-user documentation wif user manual and delivered end-user training.
  • Learnt and Understood OracleSOA Suite 11gtechnology and application adapters(Business Events, XML Gateway, and APIs), SMTP, and FTP Adapter, Database Adapter, EBS Adapter for integration and development of custom business processes using ESB/Orchestrator.

Environment: Scrum, Oracle 11g, SQL Server 2008, Star/Snow Flake dimensional designing, Rally, UML, MS Visio, MS Project, Data Migration, MS SQL database, PowerPoint and Excel, HP Quality Center

Sr. Business System Analyst

Confidential, Pennington, NJ

Responsibilities:

  • Interviewed Regional Plant, Banking, Supply Chain, and Finance Managers to gather System Requirements
  • Assisted in Project Planning & implementation and integration Road-Maps, for bringing productive results. Completed all necessary documentation including Project Charters, Project Management Plans, Product Backlogs, Sprint Backlogs, Sprint Burn-down Charts, Communication Management Plan, Project Cost Plan, Requirements Matrix, Project Staffing Plans and Project Budget Plans.
  • Created Mock-up Screens and Wireframes using UI Components such as Radio Buttons, Drop-down and Check boxes, and demonstrated it to stakeholders.
  • Developed Business Requirement Documents, functional requirements specifications, use cases, storyboards and GUI mockups.
  • Extensively used MS Visio for Process modeling, Process mapping and Process flow diagrams.
  • Constructed Requirements traceability matrix (RTM) to determine teh source of teh requirement, to ensure all requirements are met and to locate effected system components when there is a requirement change.
  • Implement Standardized Data Quality Processes including Data Profiling and Cleansing.
  • Accountable for Development and Testing activity to ensure development work meets teh required Quality Standard and Aligned wif teh approved Statement of Work (SOW).
  • Collaborate wif System and Business owner to identify Events, Correlation, and Pattern-Matching.
  • PreparedTestData and preformed Positive and Negative Testing used in Data Driven Testing.
  • Demonstrated ability in utilizingPostmanand SoapUI for testing web services (SOAP & REST API).
  • Documented teh REST API requests and responses in XML format.
  • Used RALLY Software Extensively in Agile Business Model wif 2-Week Sprints and Coordinate wif Offshore teams for Time Bound deliverables.

Environment: Scrum-Hybrid, SAP FICO, SAP, SAP PI, Web Services, SOA, API, REST, EDI, JSON, HTML, Swagger, XML, SQL, JavaScript, Jenkins, MS Visio, Tableau, Postman, LoadRunner.

Business System Analyst/ Mainframe & ETL Engineer

Confidential

Responsibilities:

  • Conducted JAD sessions to review teh business document wif a team of business end users, application developers, technical analysts and SME’s for Eliciting information.
  • Created detailed technical design specification document for enhancing teh batch programs, care was taken to re-use most of teh existing components/modules.
  • Ensure dat teh project documentation is maintained as per teh Project Life Cycle and all documents are version controlled and maintained.
  • Evaluated existing systems, business processes and user requirements to analyze, design, recommend and implement system changes.
  • Participated in Business Analysis, Data Analysis and Modeling, Data Migration, Data Cleansing, Developed functional business requirements into technical requirements.
  • Participated in consulting, software installations and configuration, new functionality and reports testing, users training and clients support.
  • Performed Source and Target Definitions in Informatica Power Center 8.6.1 Designer. Designed and developed Informatica Mappings for data load and data cleansing.
  • Analyzed data contained by teh databases using Structured Query Language (SQL and PL/SQL) and Tableau to confirm data accuracy and integrity of various reports
  • Using Informatica Power Exchange to extract mainframe files, performed row test and sending to node, checking data map in mainframe to make sure teh data map match.
  • Created Data Mapping (Source to Target Mappings) documents for Informatica 8.6.
  • Extracted transformed data from various sources such as Flat files, MS SQL Server and transferred data to teh target data warehouse Oracle 10g Database and Flat files.
  • Worked on validating teh conversion of outbound batch process for a customer application from Mainframe to ETL. Validated teh output files created by mainframe batch and ETL process are same and there is no deviation.
  • Managed teh testing process of teh application wif teh client and vendor resources. This included documenting positive and negative test scripts/cases, tracking and managing resolutions of issues, executing test scripts and documenting results.
  • Validated teh job flow and intermediate output files are same for ETL process and Mainframe batch.
  • Defect Creation, Management and Tracking Defects to closure using Defect Tracking Tools- HP ALM
  • Conducted training sessions for teh end users to halp them transition to teh new system.

Environment: Extreme Programming (XP), Informatica Power Center, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Clear Quest Test Manager, WinSQL, HP ALM Tableau, PL/SQL, Data Migration, MS Project

Jr. Business System Analyst/ Mainframe Engineer

Confidential

Responsibilities:

  • Converted business requirements to system requirements and generating UML diagrams. Created VISIO diagrams and generating logic for Data driven application programming.
  • Extracting and documenting Business Rules embedded in COBOL (CICS and Batch) programs, third party utilities, and other data manipulation products. This includes both business and functional aspects of teh business rules.
  • Worked closely wif business teams to gather requirements and come up wif an optimized solution to enable smooth transition from Mainframe to SAP
  • Worked closely wif teh WEB team for developing new XML tags as needed by Web from mainframe for teh reports to be displayed in teh front end.
  • Involved in development/enhancement of applications using JCL, VSAM, COBOL, DB2, CICS. Follow coding standards while development of teh programs and jobs.
  • Established an interface between IBM Mainframe and SAP ERP system using Connect Direct (C:D) and RFC (Remote Function Calls).
  • Developed programs which deal wif MQ’s. Experience working on developing DB2 Stored Procedures, online CICS tools, SOLA (Service Oriented Legacy Architecture) templates.
  • Written programs written in COBOL for DB2 access to process data send from JAVA applications. Writing JCL and modifying JOB schedulers to accommodate new jobs.
  • Write new CICS programs to exchange information between Mainframe and SAP systems through MQ. Co-ordinate wif SAP team to prepare test plans.
  • Schedule Monthly cycles for customer change of Address received from Trillium.
  • Unit testing, system testing and debugging of teh programs. System testing using CICS screens, UAT support
  • Carried out teh Change Release (Regression Testing) test schedule where planned changes going to production were routed.
  • Involved in preparing test plans for Independent Unit testing and Work package testing. Testing teh Applications for teh business requirement and responsible for delivery from offshore.
  • Identified bottle necks in teh system and proposed enhancement to improve performance. Development of Tools to avoid Production Issues and for Performance Improvements
  • Conducted training sessions and created Knowledge Management documents for teh end users to halp them transition to teh new system.
  • Involved in production support activities. Ensured teh batch cycle gets completed in time. Also, fixed teh issues wifin teh time mentioned in Service Level Agreements (SLA).

Environment: Waterfall, UML, Rational Requisite Pro, Mainframe OS/390, IMS, FILEAID, DB2, Stored Procedures, SQL, JCL, VSAM, REXX, COBOL, IBM utilities, MQ series, Connect Direct, RFC, TSO/ISPF, SAP ERP, SD, FICO, MM.

System Analyst/Mainframe Engineer

Confidential

Responsibilities:

  • Good experience on Mainframes (DB2), Oracle, SQL and Microsoft Tools (Word, Excel, Access, PowerPoint and MS Project)
  • Understand and Support Online and Batch Systems such as: CICS, DB2, MQ, and IMS.
  • Fix Abended Jobs - Investigate jobs dat went down, calling when not able to fix. High for critical jobs, Low for non-critical jobs
  • Coded COBOL, CLIST and REXX programs to create customized reports from teh VSAM master files and to perform utility functions in teh package installation process.
  • Work involves fixing abends such as Space abends, File contention errors, VSAM space abends and DB2 abends. Also involved in monitoring teh Batch Cycles.
  • Used IDCAMS utility to create /copy VSAM Files from production
  • Assist programming community wif compile, link, JCL, REMEDY & TIVOLI issues
  • Automated tool development to delete GDG versions exceeding three for a Dataset. This also involves altering existing GDGs. Teh tool is developed as part of Infrastructure optimization
  • Responsible for tracking of trouble tickets and resolution of escalated support incidents.
  • Performed any JCL fixes and JOB restarts if any part of teh batch process failure.
  • Fixed to problems by own responsibility and rectifies errors by modifying teh system or databases.
  • Responsible for analyzing teh data present in VSAM file by mapping wif its associated ICOB copy book.
  • Coded and tested programs in COBOL. Designed SQL queries and testing using SPUFI.
  • Created and maintained documentation for supported applications.
  • Coordinates wif customers to resolve technical support issues. Reporting of status to project team and management.

Environment: z/OS, IBM MVS, TSO/ISPF, CICS, DB2, Oracle, PL/SQL, MVS, JCL, IBM UTILITIES, VSAM, REXX, SQL, SPUFI, SFTP, Axway server, REMEDY, ITSM

Hire Now