We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

SUMMARY

  • Solid understanding of Software Development Life Cycle including Waterfall, RUP and Agile, Product Owner, (SCRUM) Methodologies.
  • Strong Soft Skills, communication, written and verbal qualities within the work function and day to day areas.
  • Ability to facilitate Crisis Management, Compliance, Quality Assurance, Defect Tracking and System Integration.
  • Skilled in creating and transforming Business Requirements into Functional Requirements and designing business models using Use Case Diagrams, Sequence Diagrams and Activity Diagrams.
  • Strong Experience in Cloud, Deep Learning, Predictive Analysis, Regression, ANOVA, T - Test, TDD, BDD, Analyzing Quantitative data and Big Data Technologies like AWS, Devops & Hadoop Data Lake, HiveQL, Kafka
  • Experience and skilled in E-Commerce platform for various Domains like Sales Order Management and web-based product enhancement including creation of Personalization/Customization of business needs
  • Worked on various International and Domestic Business Units for its Accounts Payable, Asset & Non-Asset (Logistics), Cost Center, Accounts Receivable, ETF, Mutual Funds, Property Management and Mortgage, Annuities, Insurance and Mortgage, Tax and Revenue (US GAAP GDPR, IVA, etc.) Data and its migration with Big Data Technology like Lambda Architectures and creating Resting Data Batches
  • Experience in Financial tools and data like, SAP FICO, Kronos, Oracle Peoplesoft, FileNet (P8), McKesson & Great Plains Financial Module AP, AR, GL, JE, Cost Accounting, Supply Chain Profit/Loss (Margin Analysis) GL modules
  • Solid experience in SQL Query Tools like Teradata SQL Assistant, SQL Developer, SQL Management Studio, MS SQL MGMT Studio, DB2 Oracle SQL developer, SAP (FICO).
  • Worked in engaging the AWS cloud services as Elastic Cloud Computation for the migration of the Legacy in house system and successfully migrated the data with end user AWS Cloud Training.
  • Analyzed data from Inventory Planning, Accounts Payable, Accounts Receivable, Cost Center, SUPPLY CHAIN, Asset & Non-Asset Management, Journal Entries, Demand Forecasting, Margin Analysis, Tax (including US GAAP, GDPR, IVA etc) data for it to be migrated and integrated
  • Expert to work with “super” and end-users to identify and resolve functional/technical and /or process issues within CRM like Pega Sales and Marketing Modules and Microsoft Dynamics GP, Microsoft 365
  • Solid understanding of the Master Data Management concepts like Hierarchy, Harmony, Stewardship etc.
  • Strong experience in tools like Hadoop Data Lake, Kafka, R Language, Statistical Analysis, Predictive Analysis, Lambda Architectures, Hue, Sqoop, Hive OL, Oozie, Jenkins, Impala, DB2, Linux-Unix, SQL
  • Expert in the content management of the Ui front end system through Adobe Content Management as well as training users in them being able to use the Front End of the given application
  • Business Analyst and train on system functions, identify, design, and develop system updates in support of business requirements
  • Complete knowledge of working in a Data Warehouse Environment for ERPS like Oracle, Peoplesoft, SAP FICO (for the Master Data Management)
  • Created Data Flow Diagrams for Content Management Systems to include the product enhancement and content change including categorization, organization (WSY/WIG), PCI, checkout, pricing and account management.
  • Successfully Deployed the Virtual Cloud environment in the form of Amazon Elastic Cloud Compute AWS
  • Worked on coordinating with Business Analysts, IT Leadership and business representatives to brief up with operational issues and initiatives with a potential Risk impact.
  • Experienced in facilitating JAD Sessions, User Group Meetings and gathering System Requirements using Rational Rose, Rational Requisite Pro and MS Visio.
  • Worked on the Point of Sales (POS) system for digital interface upgrade, assisted in Digitization and its strategies using AEM, CMS, Content Strategy etc.
  • Coordinated with Analysts, Managers, Developers and Testers for complex projects during the SDLC.
  • Facilitated Change Management across entire process from project initialization to testing through project delivery, software development & implementation, management in diverse business & technical environments in accordance to the Agile Methodology.
  • Highly proficient in writing SQL queries and reporting the results to the business team.
  • Proficient in design/execution of Test Strategy, Test Plan, Test Scenarios and Test Cases based on the requirements for the applications.
  • Worked on the Testing Lifecycle including Black Box, Gray Box, White Box, Unit Testing, TDD, BDD, Parallel Testing, Usability Testing, Performance, Load, Stress Testing.
  • Proficiency in conducting GAP analysis, User Acceptance Testing and SWOT Analysis.
  • Hands-on in Test Plans Development, Test Conditions, Test Cases, Test Data Creation and Analysis

PROFESSIONAL EXPERIENCE

Sr. Business Systems Analyst

Confidential

Responsibilities:

  • Orchestrate stakeholder engagement with the external EDI customers like Brookdale Senior Living, Nestle/Starbucks and McDonalds to integrate EDI transaction sets like EDI 850(PO), 855(POK), 856(ASN) 810(Invoice), 977(Functional Acknowledgement), inbound/outbound EDI 810 Invoice & Procurement.
  • Lead customers like Starbucks/Nestle with the EDI messaging integration for customer master data & equipment with more than 25k annual processing messages as well as Invoice with more than 11k annual processing transactions by identifying the data gaps and aligning with RESTFUL WEB SERVICES and WEB API.
  • Work towards the IFS (Field Service Manufacturing)-Coupa customization for customer Starbucks/Nestle to send master data for its forecasted demand planning & forecasting to accommodate the blanket Inventory Purchase orders through RESTFUL services; group line item into provided categories to generate these scenarios in form of transaction set in IFS (Field Service Manufacturing)/FSM.
  • Responsible for driving assigned EDI partner McDonalds as a part Web API communication to include 810 EDI invoice transaction for both Inventory Invoice and procurement data (after demand forecasting). Labor line items as a part of the EDI 810 segment and DTD (document type definition) will be translated to validate their drop-down menu with amount summed to a total.
  • Engage with the Coreflex Mond EDI analyst & larger team of architects and developers to map and translate the parts referred by McDonalds’ 810 Invoice against their part number to be summed in total while customizing, configuring and testing in IFS (Field Service Manufacturing) Application for the same specifications.
  • Review the ‘As-Is’ state of SAP IDOC (source document format) to x12 EDI (as target document type) transformation for McDonalds 810 invoice and create a test IFS XML, JSON output in reference to SAP x12 to validate the IFS(Field Service Manufacturing) Application output for Coreflex Mond cloud platform to process it as full cycle iteration.
  • Work in assisting the development and UAT phase activity for external EDI partner called Brookdale Senior Living for Transaction set EDI 810 to achieve the end state production by creating outbound invoices for the customer and validate it by comparing the ‘As-Is’ state with respect to SAP based XML file to be translated into ‘To-Be’ state in IFS (Field Services Management) XML, relay the same to Coreflex & SAP FICO for full cycle processing.
  • Working in close connection with the external EDI partner called Coreflex to use its cloud platform termed Mond for it to be able to produce the Brookdale Senior Living 810 outbound invoice as XML and JSON to flow with WEBAPI and RESTFUL MESSAGE QUEUE SERVICES to the customer partner to met with its Demand Forecasting as well as Inventory & Procurement Management.
  • Lead merger and acquisition activities to decommission Alpro entity into Smart Care legal entity and discover the historic data like Procurement, Inventory Management, Demand Forecasting, Commercial Finance/ Master Data/Contracts, Sales, Supply Chain, Customer Service, Marketing and Communication, IT etc.
  • Drive requirements with Apro I.T. point of contact & Smart Care stakeholders to capture for Smart Care specified inventory list, active applications, on-going and recurring contracts, building leasing and ownership details etc.
  • Responsible for assisting in cutover activities & crisis management to include FSM & Apps10 build and test phase to validate the phase gates for readiness to have go-live strategy as pilot effort; cutover to ensure the production pilot is a stable platform for Big Bang release. Also, to ensure & identify bug fixing in pilot production issues, liaison with the IFS ERP architect and developer for bug fixes.
  • Assist in leading the post go-live phase to maintain the FSM & Apps10 application (Coupa) by creating the Standard Operating Procedure to be utilized across the board in Smart Care organization as well as support in re-org changes.
  • Responsible in creating Microsoft Teams Wiki for functions like billing and Warranty, Credit/AP/AR, GL, JE Finance, Field Service & Mobile, Supply Chain, CSA (Customer Service Assistance) Procurement & Dispatch, Pricing & Contracts, Sales & Marketing, System Admin (IT).
  • Highly engaging in executing the Leadership strategy to go live in Minneapolis district and then carry the strategy forward with Big Bang Approach to go live with all EDI partners, their platform and integrations with the release in rest of the U.S.
  • Participate in leadership meeting to track internal integrations application development team to check the readiness for the IFS/FSM application for it to take the XML format and integrate with external partner Mondcloud to change MQ format into required EDI output for full cycle run with EDI partners.
  • Work with team leadership to engage with (COTS) SAP EDI partner to get samples for message transaction & also retain X12 format once simulated to IFS/FSM inbound/outbound message with AS2 connection. Essentially IFS to also have connectivity tools as SAP FICO
  • Extensively work as a Business Analyst with Project Management skills in close association to the Project Leadership to comprehend the external integration project plan with its bottoms-up planning approach to translate it into JIRA epics, features, stories (Product Backlog Item) simulated from top-down approach.
  • Liasioning for generating test transaction scenario in IFS (Field Service Manufacturing)/Apps10 for EDI transaction set to validate the test scenario by orchestrating with EDI technical analyst, IFS (Field Service Manufacturing) developer and ERP architect

Sr. Business Data Analyst

Confidential

Responsibilities:

  • Prepare functional requirements by translating the technical requirements and analyzing them to turn into Financial Data Modelers and Massaged data cubes for business acquisition
  • Draft User Stories under its heading Epic and Feature in the Scum format in AWS/Sales Cloud environment.
  • Performed Data testing & Data Quality check for Compliance for clients like GEICO; RiverSource, etc.
  • Prepared business process maps of the Process Mining and Data Mining from the ingested data in Quantitative and Machines Learning environment by creating batches to build insight from user interaction data with various systems using the BPMN notation.
  • Performed Data Mapping to map the source data from multiple system across, in-house Applications, Middleware and third-party vendor system software through Web API, RESTful web services, FTP, SFTP protocols to destination system-though file transfers like xml, JSON, etc.
  • Successfully Migrated the source data to the Virtual Cloud Environments like AWS a part of Cloud through continuous integration and development by Devops.
  • Worked with Data Migration of various International and Domestic Business Units (including catering to Federal Clients) for the data pertaining to Accounts Payable, Annuities (including Federal Clients), Accounts Receivable, Mortgage, Cost Accounting, Profit/Loss, ROI, DPO, Tax and Revenue of various Latin Counties in IVA, European counties in form of GDPR and Global Privacy Regulations (US GAAP).
  • Prepared process flow diagrams of the Data Flow & Mapping from the ingested data in Quantitative and Machines Learning environment by creating Batches and its interaction with various systems using the BPMN notation.
  • Trained Users to use the front end of the Accounting Middleware as well as created the UI front end through the use of Content Manager in AEM.
  • Performed Data Mapping to map the source data from multiple system across the End Client Software, Middleware and Third-Party Vendor system software to destination system as the backend data warehouse.
  • Work with various Business Analyst Leads, Directors and Team Mates to contribute towards a large-scale project and the fulfillment of Data Migration of International and Domestic Financial Systems.
  • Analyze the data mapped from the source system as International and Domestic Business Unit System as well as Government and Federal Units and convert it to migrate it to the destination ERPs like SAP FICO, Infor etc. for US reporting.
  • Create Vision Q and A Reports for various International Business Unit Systems for to derive their Chart of Accounts and Ledger Details in the ERP Infor.
  • Mapped the Vision Q & A reports to the SQL database that ran data in the background layer to build SSIS reports of various database from different Business Units for International Data Migration to the Data Lake
  • Parallelly created SQL reports for the Source Database through SSIS for the reports to an analyzed for Data Migration
  • Performed Financial Data Modelling for the migration of the data from one system to another in the form of condensed and messaged data for profit/loss valuation.
  • Prepared user documentation for the Unit Testing with the User Acceptance Criteria and testing lifecycles.
  • Worked extensively with Compliance, Accounts Payable, Accounts Receivable and Chart of Accounts, Cost Accounting, Tax and Revenue (including IVA, GDPR, Global Privacy Laws, US GAAP), within the largescale ERP.
  • Successfully deployed the data in Cloud Virtual In-House environment for Development and Production through AWS EC2- Elastic Cloud Compute.
  • Tested templates for electronic fund transfer, payment reimbursement, payment requisition form for the Vendor Management System for various extended warranty clients
  • Expertise in performing the Unit Testing on Cost Center data from the local reporting unit to the U.S GAAP to translate the EU Tax rules from GDPR into US GAAP unit through the ERP Cost Center Import Management System
  • Worked and prepared for the Month End Check Reports for each of the Internal Business Unit for its Insurance and Mortgage data & reporting the book-keeping (P n L) entries for the accounting periods.

Sr. Business Systems Analyst

Confidential, Phoenix, AZ

Responsibilities:

  • Prepared Business Requirements Document and Functional Requirements Document by gathering requirements through detailed discussions with Business Users and Subject Matter Experts.
  • Deliver merger & acquisition of entities for Confidential and perform Land Survey with QUARP to for the property management of the acquired entity
  • Worked with the Garnishment Payment Module for the Payments; Inventory and Inventory Planning to register P/L in Great Plains ERP by transferring the JSON files using Restful webservices and REST API web services.
  • Worked with ERP Financial Tools like Oracle Financial, Oracle Workday, Great Plains, Microsoft Dynamics, McKesson, Energy Management System/ Prokarma to integrate it through Bitbucket & Java (J2EE) Restful API Web Services
  • Created content description in the Big Data Interface HUE through the help of Adobe Content Manager.
  • Worked extensively on dashboard tools like PowerBI as well as, with its module like Wealth Management, SUPPLY CHAIN; AP for Accounts Payable data, Profit/Loss, Cost Accounting segmental analysis, ROI, ETF, Mutual Funds, DPO, HR data, Garnishment Accounting, Residuals & Payroll data.
  • Worked on the data migration and conversion from the Oracle ERP with its module like Supply Chain, Procurement, Inventory & Demand, Compliance, profit and loss booking keeping module to create Journal Entries, Energy Management System and its Expense and Utility Module.
  • Worked with the Garnishment Payment Module for the Payments; in McKesson Inventory and Bookkeeping to register P/L in Oracle Workday ERP, created Day’s outstanding reports (DPO), also used margin tools like Margin Analysis to bring about the Profit Margins and the vantage point of the company
  • Successfully migrated financial data pertaining to ERP modules like Inventory Planning, Retail Planning, Demand Forecasting, Accounts Payable, Accounts Receivable, Cost Center, Cost Accounting Asset & Non-Asset Management, Journal Entry, Compliance, ETF, Mutual Funds, Taxes & Mortgages (US GAAP), Expense Accounts Receivable, Property Management & Mortgages, etc.
  • Experienced in the continuous deployment and continuous integration while Migrating the Finance and Accounting Historic Data to Integrate into legacy applications through REST, REST API (Jenkins).
  • Co-ordinated various UAT session in production environment
  • Experienced in creating Personas for the User Stories and UX design
  • Experienced in Big Data Ecosystem to perform ETL function through data ingestion in Lambda Architecture to create batches for the predictive analytics for Demand Forecasting into Hadoop Data Lake, Hue, Spark, Oozie, HiveQL, Impala, Oozie, Jenkins, Kafka, R-Language, DB2, Linux, SQL.
  • Created SSIS reports from the SQL database to check the integrity of the Data Migrated into Big Data Lake ecology through HiveQL, Impala, Oozie, Kafka, etc.
  • Worked successfully in a data warehouse environment to create Data Dictionaries, reference documents to the target data from the source/feeder data for Demand Planning using tools like logility.
  • Validated the quality of the data through integrity & completeness check
  • Facilitated Accountants, Managers, Directors as a part of catering to the Accounting Stakeholders
  • Performed pattern detection on the data to identify the anomaly and reported the same through Data Visualization tools like PowerBI for Dashboard & Reporting.
  • Pro-actively initiated the task process to get the job done and report to Sr Leadership
  • Performed the data query with the use of tools like Teradata SQL Assistant, SQL Developer, DB2, SQL Management Studio, MS SQL MGMT Studio, Oracle SQL developer
  • Ran SQL Queries for the test case scenarios and assisted the Business Users constantly in fetching the data with SQL Queries.
  • Mapped the data with the requirements to conduct pattern search.
  • Created Functional Specifications to migrate Terabytes of data through utilizing Machine Learning and Predictive Analytics to create Batches of the ingested data through Jenkins by extracting data using Kafka, Oozie, Logility and release the output into big data lake.
  • Conducted JAD Sessions for the Historic Data Migration to transition the project to chronological phases.
  • Managed changes in the Requirements with the help of Requirement Traceability Matrix and Impact Analysis.
  • Created SSIS reports from different data bases integrated into one intermediate database in SQL to validate the data and migrate the final production data to the Data Lake like Hadoop.
  • Prepared deliverables to manage the expectations of the Senior Leadership as a part of Crisis Management
  • Converted Business Requirements to Functional Specification.
  • Created Use Cases, User Stories, Activity Diagrams and Sequence Diagrams.
  • Performed GAP Analysis between the AS-IS model of the legacy system and TO-BE model to identify the Compliance gaps.
  • Managed changes with the help of Requirement Traceability Matrix and Impact Analysis.
  • Developed Test Cases and Test Scripts with System Integration Testing and User Acceptance Testing to assist with Quality Assurance.

Sr. Business Systems Analyst

Confidential

Responsibilities:

  • Prepared Business Requirements Document and Functional Requirements Document by gathering requirements through detailed discussions with Business Users and Subject Matter Experts.
  • Prepared Business Requirements Document and Functional Requirements Document by gathering requirements through detailed discussions with Business Users and Subject Matter Experts.
  • Develop user stories in JIRA board for the UI enhancement on the product description and pages in relevance to the project on Confidential .com
  • Process XML files into JSON contract files into interchange the data format and structure in a service oriented architecture (SOA) with POSTMAN.
  • Converted Business Requirements to the Functional Specification for the Manufacturing Line and the unit by translating the infrastructure as well as Supply Chain unit, call center unit (Call Records, IVR)
  • Administered Machine Learning Classifier to crawl for the customer data on Confidential .com to enhance the recommendation system for the user products.
  • Converted Business Requirements to the Functional Specification for retail product recommendations on Confidential .com and application using Machine Learning to recommend related products to end users.
  • Created visual presentations and Tutorials to explain and elicit the requirements gathering and translating them to functional requirements
  • Finalized the UI/UX design and converted into sprints with Story Boards to be used for the enhancement of the website and the application
  • Display strong and proactive relationship liaison to coordinate for JAD sessions for Product Catalog, Manufacturing and Production Infrastructure, Supply chain Categorization, order sequence and initiation on the E-COMMERCE retail platform.
  • Conducted testing session in the JIRA, Azure & Selenium environment—as Manual Testing environment.
  • Worked with Rest API and RESTFul services to bring the XML-JSON files as a part of UI/UX enhancement in the e-commerce backend for the PCI, configuration, PCI, Product Checkout, User Account, Payment, Categorization.
  • Provided Mapping Requirements specification to translate the data objects from one file type to another by creating the data maps and utilizing the JSON contracts (through POSTMAN)
  • Mapped customer data from the upstream/downstream of the system to conduct anomaly detection.
  • Worked on Point of Sales (POS) system for the e-commerce user interface digitalization.
  • Performed GAP Analysis between the AS-IS model of the legacy system and TO-BE model to identify the project gaps.
  • Conducted user training sessions for the E-Commerce portal to go live and update the dynamic changes.
  • Provided support to retail employees and managers by troubleshooting technical issues for the Content Management in Epicor Point of Sale System (POS) e- commerce Software.
  • Managed changes with the help of Requirement Traceability Matrix and Impact Analysis.
  • Created Use Cases, Activity Diagrams and Sequence Diagrams.
  • Developed Test Cases and Test Scripts with System Integration Testing and User Acceptance Testing to assist with Quality Assurance.

Hire Now