SUMMARY

• Goal Oriented Professional having around 8 years of experience as a Business Systems Analyst, working closely with technical analysts, functional analysts and business users through all the phases of System Development Life Cycle (SDLC) delivering cost - effective, high performance technology solutions to meet challenging business demands.
• Sound domain knowledge with solid technical, modeling, documentation and testing skills.
• Industry Domain Expertise in Supply Chain processes like procurement strategy, purchasing options, strategic sourcing, supplier discovery, accounts payable integration, process improvement spanning over wide range of modules such as Order Management, Purchasing, Manufacturing, Demand Planning, Inventory etc.
• Sound knowledge of Procure-To-Order, Procure-To-Pay and Source-To-Pay process alignments and integration with legacy systems such as Oracle ERP and SAP ERP to analyze organization-wide operations and implement effective business solutions to improve overall Supply Chain performance.
• Extensive experience working in end-to-end Systems Development Life Cycle Governance and Collaboration including analysis and review of business and software requirement specification, design, development and testing techniques in waterfall, Agile - Scrum and Scrum-Waterfall hybrid methodologies.
• Strong understanding of gathering, analyzing and documenting business & Data requirements, functional specifications, AS-IS state of existing business process flows, business process mapping & modeling.
• Proficient in conducting elicitation techniques such as Document Analysis, Focus Groups, Prototyping and Joint Application Development sessions to analyze the business needs and coverage early towards the design which is acceptable to the customers and feasible for the developers to implement and execute.
• Proficiency in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and transforming them into functional and non-functional specifications.
• Experience working with diverse and non-collocated end users, technical as well as functional teams to bridge communication gaps and co-ordinate the smooth processing of day-to-day tasks.
• Collaborated with Project Manager on creating Work Breakdown Structure (WBS) to define and group project’s discrete work elements using MS project and achieving the milestones by tracking change impacts & schedules.
• Hands-on experience in creating Use Cases, Data Flow Diagrams, Entity Relationship Diagrams, Flow Charts and UML Diagrams such as Use Case, Sequence, Activity Diagrams using MS Visio.
• Experience in conducting GAP analysis, SWOT analysis, Cost benefit analysis and ROI analysis.
• Scrum Master experience facilitating Scrum Ceremonies-Daily Scrum, Sprint Planning, Review & Retrospective Meetings. Maintained scrum reports-Burn Up/Burn down Charts, Velocity Chart, Impediments
• Excellent working knowledge of RDBMS such as Oracle, MS SQL Server, MS Access and skilled at writing SQL DDL and DML queries to create Tables, Views, Stored Procedures, Functions, Triggers etc. to retrieve reports.
• Strong Knowledge of Data Modeling (Conceptual, Logical and Physical Design) and Dimensional Data Modeling in designing Database Schemas, Data Marts and Data Warehouse Schema Design.
• Hands-on experience in OLAP Operations such as Roll-Up, Drill-Down, Slice, Dice and Pivot.
• Hands-on experience in Data Analysis, Data Mining, Statistical Data Mining, Extract/Transform/Load (ETL), Business Intelligence, Data Visualization and Master Data Management through technologies such as Informatica PowerCenter, Informatica MDM, SAS Base, SAS E-Miner, WEKA, R Studio, Tableau and QlikView.
• Detailed Understanding of C, C++ and Java Programming languages along with Object Oriented Programming.
• Adept at working with SOAP (XML, WSDL) and RESTful (XML, JSON) web services, Technical Writing for API documentation using Swagger API, IO Docs & perform Client-side/Server-side request-response validation.
• Sound knowledge of holistic system functioning in Multi-tier and Service Oriented Architecture (SOA) devising artifacts necessary for data transmission at different layers of architecture.
• Interacted with the Architects, Developers to ensure functional implementation of business requirements and the QA Team in executing Test Plans & Test Case scenarios, Test Logs, Test Objectives.
• Experienced in preparing and executing system test plans and UAT test plans, test status reports, requirement traceability matrices (RTM), functional traceability matrices and defect matrices.
• Worked with SMEs’ to understand Key Performance Indicators (KPIs), and Service Level Agreements (SLA) to enhance application performance through data exchange between external Web services.
• Experienced at conducting user training, knowledge transfer sessions, facilitating meetings and preparing project plan, deployment plan, migration plan, Maintenance & Support Plan and disposition plans.

TECHNICAL SKILLS

Project Methodologies / Frameworks: SDLC, Waterfall, Agile-Scrum, Scrum-Waterfall Hybrid.

Business Modeling Tools: MS Visio, MockUps, Wireframes (Balsamiq), Lucidchart, draw.io

Project Management: Rally, JIRA, TFS, HP ALM, Confluence

Operating Systems: Windows, Linux, Unix

Application/Web Servers: Oracle WebLogic, SAP NetWeaver, Apache Tomcat, Red Hat JBoss

Database & Tools: Oracle 9i, 10g, 11g, MS SQL Server 2000, MS Access, Oracle SQL Developer, Toad, WinSCP, Putty.

Programming Languages: C, C++, Java, Java Script, SQL, XML, JSON, R, SAS, HTML

Data Warehousing & Tools: Data Modelling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down, Pivot & Informatica ETL, SAP BODS, SAP Business Objects Lumira

Reporting/BI: Tableau, IBM Cognos, Microsoft Power BI, QlikView

Defect Tracking / Testing Tools: HP QTP, UFT, ALM, LoadRunner, Junit, Cucumber, SoapUI, Postman Rest Client, Swagger, JIRA.

PROFESSIONAL EXPERIENCE

Confidential, Estero, FL

Business Systems Analyst

Responsibilities:

• Co-ordinated meetings with the Business Owners, Director - IT, Project Manager, Tech lead and Risk Analysts, as a prerequisite, to perform and document high-level project analysis.
• Conducted a high-level requirement gathering sessions with Business Owners for requirement elicitations via JAD Sessions, Interviews, Focused Groups and Brainstorming Sessions.
• Assisted the Technical and Functional Analysts in preparation of Business Requirements Document (BRD/HLD), Functional Requirements Document (FRD) and System Requirements Specification (SRS/LLD) to enable the development team to better understand business needs and techno-functional requirements.
• Prepared GAP analysis, Interface Analysis and Risk analysis via Document Analysis to understand the new business model and additional functionalities to be incorporated.
• Created various Business Flow, Data Flow and Logical Architectural diagrams in MS Visio.
• Used Visio to draw the UML diagrams such as Use Case, Sequence & Activity diagram as well as ER diagrams.
• Actively participated in document reviews, plan setup, plan configuration and incorporated them in Business process re-engineering and Business process modeling using Activity diagrams and Swim-lane diagrams.
• Created Mock-ups and Wireframes to represent ASCP front-end and process flows to the business owners.
• Prepared a data requirement template by performing a detailed analysis of existing legacy systems such as Oracle EBS 11i, Demantra 12.2.x and departmental planning performed through Excel Planning Spreadsheets to assist functional analysts in setting up ASCP and developers in PL/SQL coding.
• Created Data Mapping Specification for source to target mapping and Data Dictionaries in Excel.
• Assisted DBAs in installing and configuring the Database and several Data Stores such as Application Data Store, Stage DB tier, Operational data Store and Planned Data Store and prepared SOP artifacts of each.
• Analyzed the fields and datatype requirements for necessary forms in Oracle EBS modules such as Inventory (INV), Order Management (OM), Purchase Orders (PO), Bills of Material (BOM) and Work In Progress (WIP).
• Worked on n-tiered web architectures, SOA and analysis of their associated technologies such as web services and data flow between different layers through technologies such as XML, SOAP, WSDL, REST and JSON.
• Prepared a feasibility plan of integrating Oracle Fusion Middleware 12c (WebLogic Server) to the several source systems such as Demantra, Excel Planning Spreadsheets etc. and Oracle’s OLAP Analytic Workspace (AW).
• Gathered requirements and documented Web APIs (JSON documentation & XML documentation) using Swagger, IO docs for JSON & XNSDOC for XML to assist developers in their development.
• Assisted back-end developers with creation of schemas, tables, views, materialized views, triggers, stored procedures and functions using SQL Developer as a front-end programming workbench.
• Used XSLT to generate XML/HTML code from XML.
• Worked with Data Warehouse Architects to perform the data extraction, cleansing and visualization of demand planning and departmental planning data collectively by slicing and dicing the data using Oracle’s OLAP AW.
• Prepared and provided DBA team with migration document to migrate the data and application files such as reports, forms, workflows etc. within the SOA before UAT begins.
• Prepared and executed test cases, test scenarios and tracked defects in HP Unified Functional Testing (HP UFT).
• Conducted functional black-box testing for unit, integration and regression of different modules within SOA.
• Used Swagger UI to look for the list of APIs & validate implemented functionalities with a goal to identify gaps.
• Worked as a part of API testing and measured the data flowing between request and response.
• Actively assisted the product owner in prioritizing the product backlog grooming User Stories INVEST criteria. Participated in various Scrum ceremonies like Sprint Planning Meeting, Daily Stand-up Meeting, Sprint Review Meeting, Sprint Retrospective Meeting, Backlog Grooming.
• Extensively used JIRA to record and maintain the artifacts such as Product backlogs, Sprint backlogs, user stories / Data stories, Impediments list, tasks, defects and issue tracking.
• Performed non-functional testing such as stress and volume testing to verify if system withstands high load and scalable enough to transit to UAT. Performed user provisioning in the ERP to take care of authentication and authorization entailing security testing.
• Wrote test plans, test cases, and test scenarios and traceability matrices used by the Quality team for User Acceptance Testing (UAT) and conducted it in conjunction with QA team.
• Analyzed and visualized the data in Tableau integrated with OLAP AW and provided insights to the functional team for setting up ASCP in planning server.
• Worked with production staff to map detailed current As-Is processes and detailed the To-Be processes.

Environment: Waterfall Scrum Hybrid, Gap Analysis, Risk Analysis, MS Visio, Oracle EBS 11i, Demantra 12.2.x, Oracle SQL Developer, Oracle WebLogic Server 12c, Oracle OLAP AW, Swagger, IO Docs, XNSDOC, HP UFT, JIRA, MS SharePoint, Microsoft Office.

Confidential, Ada, MI

Business Systems Analyst

Responsibilities:

• Simplified existing Oracle applications to integrate the architecture & build for scalability utilizing Service Oriented Architecture (SOA) as framework and Applied the "As Is" and "To Be" process designs to identify any potential process gaps and as well as improvement opportunities.
• Facilitated JAD Sessions, Interviews sessions, Survey/Questionnaire and Focus Groups to Elicit Requirements with various stakeholders, business users & SME’s for understanding business requirements.
• Helped infrastructure team in developing lifecycle architecture for SOA processes testing & quality assurance.
• Built several Data Flow, Process Flow and Architectural Block Diagram in MS Visio.
• Worked with business owners to draft Business Requirement Document (BRD) for the specific business requirements and Functional Specification Document (FSD) to capture the functional requirements.
• Used Balsamiq to draw Wireframes to demonstrate the front-end screens to business owners and worked on Lucidcharts to draw use case diagrams and activity diagrams detailing the use cases and functional flow.
• Assisted in implementing and maintaining large and complex project schedules and WBS using MS-Project.
• Prepared a data requirement template by performing a detailed analysis of existing legacy systems such as Oracle EBS 11i and Coupa Professional 5.0 assist functional analysts to perform integration through Mulesoft ESB and assist developers in SQL coding using SQL Developer as a front-end development tool.
• Performed extensive analysis of Distribution Management Systems (DOM), Warehouse Management Systems (WMS), Order Management Systems (OMS) of existing legacy system to prepare mapping artifact of Procure-To-Pay cycle within Coupa Professional cloud application.
• Gathered requirements to integrate Master Data Management and prepared data requirement template along with integration architecture of Informatica MDM.
• Assisted DBA and Infrastructure teams in setting up Master Databases and Operational Reference Store (ORS) along with Hub Server, Cleanse Match Server and Services Integration Framework (SIF).
• Prepared the data mapping documents for data flow between landing tables, staging tables and base objects. Applied business rules and complex transformations for the data transfer from the data sources.
• Extensively used SQL scripts/queries for data verification at the backend.
• Worked as a part of API testing and measured the data flowing between request and response.
• Responsible for slicing epics by vertical slicing and creation of user stories with INVEST criteria.
• Responsible for tracking requirements, tasks, defects and impediments resolution using JIRA.
• Participated in scrum process including Daily Scrum Meetings, Sprint Planning Meetings and Reviews meetings and sprint retrospective and followed up on action items for continuous improvement.
• Coached team members on Agile processes. Maintained task board and produced daily burndown charts.
• Assisted the Scrum Masters and Product Owners in removing impediments and protecting team members from interruptions and distractions to maximize productivity.
• Created Feature files in Cucumber using Gherkin language for various scenarios and scenario outlines
• Worked on Cucumber framework used with Selenium java for performing acceptance testing
• Performed non-functional testing such as stress and volume testing to verify if system withstands high load and scalable enough to transit to UAT. Performed user provisioning in the ERP to take care of authentication and authorization entailing security testing.
• Wrote test plans, test cases, and test scenarios and traceability matrices used by the Quality team for User Acceptance Testing (UAT) and conducted it in conjunction with QA team.

Environment: Waterfall Scrum Hybrid, Oracle database 11g, Oracle EBS 11i, Coupa Professional 5.0, MuleSoft ESB, MS Visio, Balsamiq, Lucidcharts, Informatica MDM, Services Integration Framework (SIF), Oracle SQL Developer, JIRA, Cucumber, Gherkin, Jerkins, UAT Testing.

Confidential, Seattle, WA

Business Systems Analyst

Responsibilities:

• Lead the definition and documentation of business and functional requirements.
• Conducted user/stakeholder interviews to execute the successful planning sessions.
• Provided best practice recommendations in the areas of Order Management System and CRM.
• Created Activity Diagrams & Sequence Diagrams using UML methodologies for easy understanding.
• Created requirement documentation, reviewed with user representatives, restructured the documents with the recommended priorities and obtained user signoff to start the project implementation.
• Analyzed present needs/recommendations and aided in preparing and presenting Return on Investments, business case proposals and Cost Benefit Analysis.
• Worked in conjunction with the team in assigning tasks with understanding of complexity & priority of the task.
• Assisted the Product Owner in converting requirements from BRD into User Stories by conducting User Story sessions and prioritizing Product Backlog Items (PBI) using various techniques.
• Implemented and supported Order Management System by defining and validating requirements relating to OMS and developing process flows to define functionality across the systems for proper EBPP implementation.
• As a Scrum Master, implemented Scrum Practices while handling team and facilitated Scrum Ceremonies like Daily Scrum, Sprint Planning Meeting, Sprint Review Meeting and Sprint Retrospective meeting.
• Tracked team’s velocity and progress during a Sprint using Sprint burn down & Release burn down chart.
• Helped the team in estimating the complexity of the user stories facilitating Planning Poker and Triangulation techniques and guided the team on adhering to the best practices of estimation.
• Assisted Business Intelligence (BI) team in creating dashboards using Tableau as required by the end users.
• The effort involved developing extensive SQL Queries and Procedures, utilized to perform database integrity testing, ensuring various data table entries, data validity, and data integrity.
• Performed logical data modeling and created ER diagrams and used SQL queries for managing database.
• Prepared Requirement Traceability Matrix (RTM) report to foresee the requirements associated with each use case within test plan ensure that every Business requirement is adhered to achieve the expected performance.
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans, execution of Test Cases and logged the defects for failed test cases using HP Quality Center.
• Assisted in deletion of defects and bugs, to meet requirements and deadlines for successful execution of project
• Played a key role in the planning and performing User Accepted Testing (UAT) along with business users

Environment: Scrum Methodology, HP ALM, Tableau 6.1.6, Microsoft SQL Server 2012, Mock-Up Screens, GAP analysis, UML, UAT Testing, MS Office Visio, PowerPoint, Word, Excel, Project .

Confidential, Santa Clara, California

Business Systems Analyst

Responsibilities:

• Analyzed and documented requirements gathered and authored Business Requirement Document (BRD), System Requirement Specification (SRS) for application configuration and integration.
• Assisted Project Manager in building Work Breakdown Structure to streamline the activities and demonstrate a strong projectile of integration opportunity.
• Analyzed present needs/recommendations and aided in preparing and presenting Return on Investments, business case proposals and Cost Benefit Analysis.
• Assisted Risk Analysts and SMEs in performing feasibility, impact and risk analysis of the stipulated integration and prepared corresponding artifacts such as risk register, risk management plan, feasibility report etc.
• Facilitated and conducted Interviews and Document Analysis with the business owners and functional analysts of every department making use of existing SAP ERP.
• Assisted the Lead Architect in building logical architecture of integration along with data flow diagrams.
• Analyzed source database, identified cardinalities and Created conceptual, logical data diagrams.
• Prepared a data requirement template by performing a detailed analysis of existing legacy systems such as SAP ERP 6.0 and SAP ARIBA 14s to assist functional analysts to perform integration through SAP NetWeaver and developers in PL/SQL coding.
• Gathered requirements for SOAP web services and RFC APIs, which were used for the integration through SAP NetWeaver Process Integrator as a middleware in Service Oriented Architecture.
• Documented Web APIs (JSON documentation & XML documentation) using Swagger, IO docs for JSON & XNSDOC for XML to assist developers in their development.
• Elicited requirements and assisted database administration team in preparing data requirements and data mapping artifacts to map the data between SAP BODS (ETL Toolkit) and Oracle 11g master database through BAPIs and IDOCs.
• Worked with ETL team in data transformations and visualizations in SAP LUMIRA.
• Co-ordinated unit testing, system testing, interface and integration testing and UAT in conjunction with QA team.

Environment: Waterfall Methodology, Oracle database 11g, SAP ERP 6.0, SAP ARIBA 14s, SAP NetWeaver, MS Visio, SAP BODS, SAP Lumira, System Integration & UAT Testing.

Confidential

Business Systems Analyst

Responsibilities:

• Understood state of art processes by interacting with stakeholders and documents analysis and performed GAP analysis to assist Project Manager in planning the transition.
• Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
• Prepared and validated Business Requirement Document (BRD) and assisted preparation of System Requirement Specification (SRS).
• Created Use Cases and built Use Case Diagram and Activity Diagram using MS Visio.
• Managed and tracked requirements using HP ALM through Application Life-Cycle.
• Worked on data analytics platform using SAS E-Miner, Weka and Rapid Miner to build Decision Tree, Neural Networks for analysis and Regression models to perform statistical predictions on market trends.
• Assisted Data modeling process by creating conceptual and logical ER diagrams using Vertabelo tool and designing database schemas to help development of an accurate Data Warehouse Structure.
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used Tableau as reporting tool.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Profiling.
• Generated periodic data reports for reconciliation, reporting using Excel & SQL/PLSQL Joins, views, procedures.
• Involved in implementation by assisting in the preparation of training module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.
• Sound ‘Change Management’ experience handling change requests at different phases of project by triaging the request, analyzing the impact of change on overall project life cycle and documenting appropriate Change Request Form artifacts.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.

Environment: Waterfall Methodology, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, Informatica, SAS E-Miner, Weka and Rapid Miner, MS Visio, MS Projects, HP ALM, Wireframes, Mock-Up Screens, MS SQL Server, SharePoint, GAP Analysis, UML, UAT testing.

Confidential

Oracle Apps DBA

Responsibilities:

• Cloned/Refreshed Test environment with Production environment.
• Performed Backup of Production environment.
• Used AD Utilities to monitor and apply patches to add functionality as required (using Adadmin, Adpatch, Adctrl, Autoconfig, Adident Utility).
• Coordinated with Oracle Support for resolving raised SR with functional team and implementation as per Oracle Support recommendation/Support.
• Performed Code Migration, Patching on EBS 11i Production and Non-Prods.
• Installed new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Experienced in installing and configuring applications like Discoverer, Hyperion, Wallet Manager, OBIEE, ODI etc.
• Worked as Liaison between onshore business team and offshore DBA and technical team to translate business specification requirements into technical plan of activities.
• Handled multi-tier architecture: Desktop tier, Application tier (Web server, Form server, Concurrent processing server and Administration server) and Database tier.
• Conducted Maintenance activities on concurrent processing requests and concurrent managers.
• Performed instance management such as bounce (shut down, shut up), cold and hot backup, assessment and testing of reports (.rtf), forms (.fmb) and workflows (.wft) .
• Executed sanity testing of databases, applications and listeners in order to comply to accessibility statuses.

Environment: Waterfall Methodology, Oracle database 10g, Oracle database 11g, Oracle E-Business Suite 11i, Oracle E-Business Suite R12, GAP analysis, Toad, SQL Developer, Unix Shell Scripting, Oracle ATS, MS Office Visio, PowerPoint, Word, Excel, Project .

Confidential

SQL Developer/DBA

Responsibilities:

• Administered and Managed Production Oracle databases and applications for Oracle Apps EBS (11i) and critical Database 9i.
• Managed 24*7 operations teams to work within defined SLA, outages are addressed rapidly, and efficiently & upgrades and enhancements are non-disruptive.
• Worked closely with Technical resources both inside and outside of database team, Development Managers and system stakeholders to translate business requirements into technical actions.
• Ensured infrastructure architecture standards for High availability, Efficiency and platform compatibility.
• Performed backup, restore, recovery and database configurations.
• Tracked record of all the critical activities being performed on Application and Database and built periodic Excel reports.
• User management of oracle apps user i.e. creating new user, managing existing users and assigning responsibilities.
• Led Monitoring and troubleshooting activities such as performance tune, query optimization etc.
• Wrote SQL queries to create Schema, Tables, Views, Materialized Views and built stored procedures, triggers and functions as per requirements.
• Maintained database for space i.e., monitoring free space in tablespaces, adding datafiles, remove core files/log files/archive files at specific interval etc.
• Generated Ad-hoc reports using SQL joins and aggregate queries in TOAD as per the requirement.

Environment: Waterfall Methodology, Oracle database 10g, Oracle E-Business Suite 11i, Mock-Up Screens, Toad, SQL Developer, Unix Shell Scripting, UAT Testing, MS Office Visio, PowerPoint, Word, Excel, Project .