Business Analyst (supply Chain/ Hana) Resume
Atlanta, GA
SUMMARY:
- I would like to apply as Business Analyst in your company. I am certain that my skills and experiences are suitable with your requirements.
- I have experience working as a Business Analyst. I arranged business strategy plan for short term and long - term period.
- I also analyzed production, sales and marketing.
- I also have creative and innovative strategy for business plan.
- Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
- I am able to work in a team.
- My analytical skill is well developed. Research and analysis of data, market needs, and customer issues.
- Open to Team related tasks, team meetings, team interaction and conference calls.
- I hope that skills and experiences will give profit for your company.
- Years of professional experience in Ecommerce, Banking and Supply chain as a Business system Analyst, Supply chain analyst. Strong understanding of construction projects and operations.
- Connoisseur in documenting Business Requirements Document (BRDs), Functional Requirements Document (FRDs), Non-Functional Requirements Documents, Use Cases, Test Cases and User Interface Prototypes. Strong experience in RUP Business Modeling process.
- Experienced working on HANA FLOW graphs using data sources as HANA tables, HANA models.
- Experienced using Time Series Algorithms in HANA Flow Graphs which includes source and parameters as input, statistics and results as output.
- Worked on the extraction of data's from LO cockpit-SAP R/3, FICO and MM to BW, BW ON HANA / Native HANA/ BW4 HANA.
- Experience in using Unified Modeling Language (UML) for creating Use Case Diagrams, Business Process Model, Class Diagrams, Activity Diagrams, Sequence Diagrams, and work flow diagrams.
- First-hand experience in Waterfall and Agile (Scrum) methodology of Software Development Life Cycle (SDLC).
- Responsible in doing the Proper Data Mapping by querying the Murex Database with respect to the missing identifiers and mapping the same with the Identifiers Coloum.
- Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
- Developed business solutions for SAP Customer Master Data configuration to support new SAP Hybris Cloud 4 Customer Project.
- Served as knowledgeable functional/technical representative supporting presales of Ariba Buyer professional services and license sales.
- Developed business solutions by leveraging SAP SD HANA & Material Master Data configuration to support new e-commerce Hybris Project.
- SAP BW/4 HANA Modeling for ADSO and Open ODS, Extraction and loading of data from ECC SD and FI system.
- Reviewed configuration delivered best practice recommendations and collaborated with Ariba Shard services to prototype new business.
- Redesigned HANA Attributes Vies and HANA Analytical Views for Sales Stats Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA. Used ODATA services in NATIVE HANA application development.
- Managed sourcing and procurement process in Ariba system and various other tools to update email templates and supplier questionnaire in the online system.
- Experience working on Native HANA application development on HANA XS JS. Created a user-friendly UI as a part of the NATIVE HANA application development.
- Research and analysis of data, market needs, and customer issues. Developed training materials and documentation and conducted internal training classes for the new Ariba tool, design and execute Ariba automated messaging system and trained Suppliers in responding to Ariba events.
- Experience in all aspects of Supply Chain Management, Global Demand Planning, Aggregate Forecasting, Planning, Master Scheduling, Inventory Management, Risk Analysis, ROI Analysis and experience working for manufacturers, distributors, resellers, contract manufacturers.
- Analyze different business scenarios like Cost of Goods sold with optimal savings, Forward Purchases, Price Increase Risk, Supply Shortage Risk, Vendor Change, Conversions, Window Buy Ins, and provide recommendation and forecast to different user groups.
- Hands on experience in SAP HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views.
- Created SAP HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
- Project Managed multiple client projects consisting of various software applications; WMOS, Business Intelligence and Demand Planning.
TECHNICAL SKILLS:
Software/Hardware:
Methodologies: SDLC, QA Life Cycle, Waterfall Development, Agile Development, Data Extraction, Data Visualization, Complex Data Analysis, SQL/Macola ERP, Process Modeling, Gap Analysis, Change Management, Impact Analysis, Root Cause Analysis, SWOT Analysis, Project Planning, Budgeting and Scheduling, JAD Sessions. CCAR/DFAST/ICAAP/Risk Appetite Capital. Transportation Lifecycle Management (TLM), Warehouse Management Open Systems (WMOS).
Databases: Progress, MS Access, Oracle, SQL Server.
Supply Chain: Forecasting, Project Management, Strategic Sourcing, Demand Planning, Outsourcing, Logistics, Inventory management, procurement, Gap Analysis, Change Management, Impact Analysis, Root Cause Analysis, SWOT Analysis, SAP Ariba Solutions, SAP HANA, Project Planning, Budgeting and Scheduling, Ariba Buyer 8.2, SAP HANA 2.0, ECC 6.X, BI 4.X, SAP HANA 1.X, SAP BI 7.3, SAP Change Management. SAP Materials Management, Lumria, SAP SCM, SAP FICO, SAP HANA 1.0, SAP HANA2.0.
Operating Systems: Windows Server, RUP, Agile/ SCRUM framework, and Waterfall. SQL, HTML and XML. Database Oracle 10g/9i/8i, DB2, MS SQL Server Office Tools MS Office (Package), MS Visio, MS Project, MS FrontPage. Ecommerce Platforms SAP hybris, Oracle ATG, IBM WCS commerce, Magento, Fry's, Blue Martini. Oracle, Database, E-Business, Order Management, Oracle Forms, GS1 Model.
EMPLOYMENT HISTORY:
Confidential, Atlanta, GA
Business Analyst (Supply Chain/ HANA)
Responsibilities:
- Collaborated with multiple cross-functional teams (FL, RL, Invoice, and Finance) to gather all user requirements through meetings and JAD sessions; and documented detail Desktop Procedure which includes Use cases and process flow diagrams.
- Involved in Project Preparation, Business Blueprint, Realization, Final Preparation, GO LIVE and Support using SAP ASAP methodology.
- Creation of Configuration in SLT (SAP Landscape Transformation) and replicated the data from Source system to SAP HANA system.
- Experience in SAP Implementation, Support, Enhancements, Testing and Roll-out roles in SD and LE with requirements gathering, business process study, planning, gap analysis, creating functional specifications, documentation, blueprint preparation and post go-live support in various industrial environments.
- SAP BW/4 HANA Modeling for ADSO and Open ODS, Extraction and loading of data from ECC SD and FI system. Create calculated views in SAP HANA/ SQL Server/ Netezza.
- These HANA views are constructed by SLT Replication and TMS integration of non-SAP original sources.
- Created Lumira reports against SAP HANA sources and hosted training sessions for the end user on using Lumria tool. Participated in the WMOS application build, test, and deploy activities.
- Analyzed the complete Supply Chain, from receiving an order in OMS (Order Management System), WMOS (Warehouse Management Open System) and complete processing till final delivery to customer.
- Redesigned HANA Attributes Views, and HANA Analytical Views for FI, SD called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA.
- Configuration experience in SAP SD: Master Data such as customer master data, material master data & conditional master data, enterprise structure definition & assignment, order to cash (OTC) cycle such as order management, delivery, shipping and billing.
- Creation of Attribute views, Analytic views, Calculation Views based on replication data in HANA Modeler. Worked extensively on SAP layouts, smart forms and debugging of ABAP codes.
- Customized Ariba Buyer according to the business requirements while driving continuing improvement in application performance.
- Expertise in the SAP SD and MM modules with good knowledge in integration with Finance (FI), Production Planning (PP), Customer Service (CS) Warehouse Management (WM).
- Hands on experience in configuration and IMG settings, design and development of multiple SAP functional modules and its business process, gathering business requirements and design, development of functional specifications.
- Managing the entire RMA process including but not limited to planning, scheduling, coordinating, expediting and tracking materials issues to closure. This includes Next Business service levels with a consistent 98% On-Time delivery.
- Performed complete E2E Integration testing for the customers from Sales Orders to invoices and configured the Output listed as SAP EDI will transmit for 810/850/855.
- Identified key relationships, conducted interviews with various levels within Supply Chain organization, provide bi-weekly presentations to gain adoption of the fit/gap analysis.
- Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application.
- Acted as the primary point of contact to the client IT team, management, warehouse supervisors and software end users throughout designing, testing, implementing and supporting the WMOS product. Mapping the business process in line with the SAP SD functionality.
- Developed, planned, and coordinated a multitude of supply chain reports, presentations, and documentation with relevant KPIs to enable vendors and senior executives the ability to develop superior insights on key supply chain initiatives and decisions.
- Successfully implemented 1 Hot Pack and 1 HRSP upgrade each year since 2012 including the SAP HANA upgrade in 2016.
- The requirement is to identify and categorize reports by data subject matter and design corresponding SAP/HANA views to be accessed by fully customizable, filter- driven Spotfire user interfaces.
- Was hired into a turnaround scenario, including significant decline of sourcing activity via the Ariba software. Responsible for implementing.
- Performed cost benefit analysis for supplier efficiency programs and other supply chain projects that may affect Supply Chain KPIs.
- Positively collaborated on the SAP HANA upgrade project, upgrading and converting the SAP ERP Infrastructure to the SAP HANA Cloud.
- Responsible for ensuring that any new SAP HANA and ERP inherited HCM functionalities behaved as expected after the upgrade.
- Act as a main liaison in supply chain across all departments and 3PL (Third Party Logistics) to ensure process integrity and effective order flow to provide a strong customer support.
- Supply Chain departments to analyze design and recommend solution for procurement processes using Ariba tool.
- Analyze product availability based on lead-times to minimize negative impacts in Supply chain.
- Evaluates ordering trends to meet fill rates and arrival dates in Supply chain.
- Identifies, analyzes and interprets in Supply chain both technical and business opportunities.
- Analyze supply chain performance in conjunction with customers' system/ needs to improve the supply chain process. Track vendor performance and take necessary action for improvement.
- Analyzes product availability and communicates issues and recommendations to supply planner.
- Working closely with Inventory Management Team to develop key operational reports supporting optimization of operational metrics and data analysis.
- Identifying internal process improvement opportunities and implement improvement processes, particularly regarding supply utilization in collaboration with the analytics team.
- Manage all supply chain business data for manufacturer including, but not limited to, planning time fences, tooling capacity, production planning, shipping lead times and more.
- Responsible for developing strategic objectives that ensured supply chain efficiencies, reliability and responsiveness. Supported the Reengineering of a Supply Chain Management Gap Analysis.
- Production support for OTC (order to cash) SAP processes for US operations.
- Implemented company MRO parts catalog in SAP allowing each country to manage all supply chain requirements electronically through SAP.
- Supply chain operations to analyze the gaps and identify supply chain process improvement opportunities; role included survey development, supply chain policy analysis.
- Arranged quarterly training sessions for the team to enable efficiency in equipment distribution and explained about supply chain, importance of inventory management and impact on day-to-day operations. Strong knowledge of GS1 Model for Supply Chain Management.
- Supply Chain Optimization, Working Capital Optimization, Manufacturing RONA & ROIC optimization, Transportation and Distribution Network Optimization, Shared Services Outsourcing, Target Operating Model design, M&A Integrations. Focus industries: Consumer Products, Retail and Manufacturing.
- Used complex pre-defined and Ad-Hoc SQL queries for data validation, duplication, forward/reverse engineering for data mapping and ETL for data migration from the ERP/OLTP to the Data warehouse/OLAP system.
- Develop ad hoc queries and reports in SAP HANA for executive and C-level leadership. Transition reports from legacy systems into SAP HANA and improve runtime automation.
- Redesigned customer service order management, global ocean freight, import export, domestic transportation, warehousing, and supply network planning. Leveraged SAP experience across all functional areas.
- Elevated regional distribution centers strategic service advantage by converting push-driven supply planning to demand-driven pull system structure.
- Analyze supply chain performance in conjunction with customers' system/ needs to improve the supply chain process.
- Responsible for data mapping and data mediation between the source data table and WMO data tables using MS Access and MS Excel.
- Developed multiple tools using SQL, Excel and VBA for internal use of the Supply Chain team.
- Developed and maintained supply chain metrics to improve supply chain service, internal management and external vendor accountability.
- Documented High Level Business needs, Requirement Report, Project Report, User Stories, bug reporting and other project deliverables in synch with SDLC mandates.
Confidential, Eau Claire, Wisconsin
Business Analyst
Responsibilities:
- Expert in complete SDLC processes from requirements gathering, development, testing, production release and support.
- Proven track record in delivering results on time, utilizing formal software development methodologies, both Agile and Waterfall.
- Streamlined their processes for Archiving, SAP Stabilization, SAP Interfaces and SAP upgrade (HANA upgrade).
- Lead the system configuration, data conversion and system test to implement Ariba Category Management, Ariba Sourcing and Ariba Analysis in conjunction with Target's Retail business.
- Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
- Presented two options HANA (internal or on cloud) and RHEL/Oracle (internal or cloud). Prepared TCO and ROI for HANA.
- Worked on data migration tools like BDC, LSMW & IDOCs transferring and validating data between SAP and legacy systems.
- Immense testing experience in creating test plans, test cases, integration testing, functional testing, user acceptance testing (UATs).
- Worked on SAP P2P (Procur to Pay) including purchase order customization, MIGO (Goods Receipt) and MIRO (invoice receipt)
- System Analysis Development and Quality Assurance including Functional, Regression, Integration, System and Performance Testing of Client/Server and Web based Applications.
- 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.
- Lead the Ariba implementation and rollout of new applications and system enhancements and log enhancement requests and software defects with Ariba.
- Developed many Jobs (which include Workflows, Data flows, ABAP data flows etc.) in SAP Business Objects Data services which do the ETL between SAP BI/CRM/Oracle and HANA.
- Worked with IT on interfaces between Archer and Ariba and seamless integration on Vendor data including Contracts, Contacts into the Archer system.
- Performing in-depth GAP analysis, SWOT analysis, risk analysis, ROI analysis, PEST analysis, including good knowledge of process work flow tools and techniques.
- Developed Test scripts and involved in conducting Data Migration Testing, Regression testing and User Acceptance Testing UAT using SAP HANA Deployment Studio.
- Developed and supported in Extraction, Transformation and Load process (ETL) using Business Objects Data Services to populate the tables in SAP HANA.
- Interacted with the SAP HANA team to ensure seamless execution of the Global Implementation Project. Worked on S/4 HANA SLT, Data Base Models.
- Integrated 10-12 NON-SAP systems with SAP via PO using RFCs, IDOCs, and File system methodologies.
- Expert in integrating SAP, Non-SAP data to SAP BI, SAP HANA by designing Data provisioning ETL techniques, data flow and reporting solutions with Fine-tuned BW/HANA with ABAP and recommended corrective action.
- Responsible for all web development, E-commerce and optimization and web strategy and corporate website and self-service intranet site.
- Worked on S/4 Hana Landscape design with IT leads and explain to business top management to finalize the landscape and capture the GAP's from business and finalized the Landscape and Implementing S/4 HANA in On Premises.
- Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
- Held responsibility for creating business flow diagrams and charts for E-commerce using MS Visio.
- Designed and analyzed Business Process Model, Uses Case model and test procedures based on RUP methodology using Rational Rose.
- Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
- Authored Business and System requirements in an Agile/SDLC environment using effective listening, facilitation, and assertiveness.
- Executed client approvals and sign offs, impact analysis, design, UAT testing, defect management and remediation, following an internal framework of best practices.
- Wrote SQL queries, creating all necessary migration programs/scripts; queried the database to provide quantifications, reconciliations, and data to support business decisions and process improvement.
Confidential, Dallas, TX
Business Analyst
Responsibilities:
- Prepared Business Requirement Documents (BRDs) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype, Use Cases, UML Diagrams for overall system.
- Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
- Designed and developed Project document templates based on SDLC methodology.
- Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional Requirements and Functional Requirements to Systems Requirements.
- Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, Technical Specifications and/or Product Knowledge.
- Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the Project Manager and Technical Lead.
- Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the Business Requirements. Extensive experience in Business Process Modeling using Visual modeling tools.
- Proven track record in maximizing resource utilization and successfully delivering projects in Banking, Retail Merchandising and Financial domains using waterfall and agile SDLC methodologies.
- Knowledge of Base II, CCAR, DFAST, PPNR, ALLL, Credit Risk, Market Risk, operational risk, ACH, Liquidity Risk Modeling and Management, PD/LGD/EAD modeling, Quantitative Approaches including General Linear Regression, Time Series Analysis, Decision Tress, Classification and Cluster Analysis, and Principal Component Analysis.
- Development, implementation and maintenance of documentation standards for capital management broadly CCAR/DFAST specifically.
- Compilation, quality assurance and delivery of CCAR submission documentation.
- Management of forecast documentation delivery for CCAR/DFAST.
- Development and/or enhancement of next generation capabilities including CCAR and DFAST to a leading practice standard.
- Documented Federal Reserve CCAR stress test qualitative assessment for regulatory requirements and internal audits.
- Played Market Risk, Finance and CCAR SME role between Business Heads and sponsors from Risk & Finance.
- Evaluated the current systems/processes in place with regard to the generation and reporting of 9Q forecast in its current shape as part of the CCAR, DFAST, ICAAP and Risk Appetite remits to perform Gap Analysis.
- Responsible for overall status reporting to Sr. Business, Risk, Finance and Technology Leadership on state of the underlying CCAR projects.
- Engage with Finance, Risk and Capital planning to deliver CCAR/DFAST capital adequacy regulatory reporting and stress testing requirements twice each year.
- Face off with Regional Presidents and other business managers of the branch retail network. Assist in any financial related matters as needed.
- Strong background in CCAR Regulatory Reporting especially in FRY 9C, FRY 14M/Q/A, FFIEC 041, FFIEC 031 reports and the related schedules.
- Maintained a working knowledge of the Comprehensive Capital Analysis and Review "CCAR".
- Developed good practices for risk modeling procedures related to CCAR/DFAST.
- Developed and managed complex spreadsheets to aggregate firm-wide forecasts for the annual Dodd- Frank Act Stress Test (DFAST).