SUMMARY

• Experienced more than 8 years as a Business Systems Analyst on Supply Chain and Retail projects.
• Hands on knowledge of business analyst deliverables, roles, responsibilities and functions.
• Designed and deployed a Member Engagement platform with the use of Salesforce Community.
• Worked with Salesforce Sales, Service & Marketing clouds and integrated to JD Edwards Enterprise 1 modules.
• Well versed with supply chain related analytics related to measuring vendor performance, methods to improve supply chain efficiency, better manage inventories and handle orders. Have employed and customized tools and integrated different platforms together to achieve the same result.
• Designed and deployed a Member Engagement platform using Salesforce Community. The platform utilizes multiple Salesforce features, including Knowledge, Flows, Process Builders and custom Lightning Components.
• Connected Salesforce Sales, Service & Marketing clouds to JD Edwards Enterprise 1 modules of Order and Supply Chain management allowing for a noticeable decrease of response times to consumer queries, and improved analytics within JD Edwards leading to better working efficiency overall.
• Strong knowledge of various processes of software development including SDLC, Waterfall, Agile Scrum, Kanban.
• Performed multiple feasibility, risk, cost - benefit & GAP analysis for better project understanding, success and quality.
• Created multiple deliverables BRDs, SRSs, project plans, test plans & RTM to monitor requirements and progress.
• Conducted JAD session, brainstorms, focus groups, interviews & surveys to gather sufficient suitable requirements.
• Converted RFP documents to requirements and elicited clear requirements from difficult stakeholders.
• Created activity & sequence diagrams with MS Visio to confirm business users’ requirements and expectations.
• Have monitored and tracked project issues using project management tools such as Atlassian JIRA and HPALM.
• Decomposed epics to user stories meeting INVEST criteria using various slicing techniques with the development team.
• Assisted the team to create suitable acceptance criteria, estimate and prioritize user stories with techniques such as MoSCoW, KANO, Planning Poker, Dot Voting to allow for smooth development.
• Created conceptual and logical data models, documented migration plans, mapped source & target systems, profiled extracted data to clean and convert to target format.
• Good knowledge of warehouse architectures, helped setup dimensional models with snowflake and star schema. Created OLAP data cubes and performed various operations such as slicing, dicing and pivot to ensure data usability.
• Utilized Informatica to perform ETL integration operations and transformations from source to target systems.
• Operated basic SQL commands such as SELECT, INSERT, UPDATE, ALIAS, JOINS and PROCEDURES.
• Knowledge of computer languages including C++, SQL, Python, XML, JSON & HTML to work with developers.
• Tested API CRUD operations GET, PUT, POST and DELETE with the use of POSTMAN for functionality.
• Documented both REST and SOAP based APIs with the use of SWAGGER as per latest documentation standards.
• Facilitated automated functional, performance, black box, integration, regression & smoke tests to ensure quality.
• Facilitated multiple UA testing, gathered users, catalogued tests and reviews to ensure a satisfactory application.
• Generated multiple reports using Business Intelligence (BI) tools such as Tableau, PowerBI, MS Excel and MS Office
• Self-motivated, adaptive and able to work in a team or independently as per a deadline.
• Excellent organizational, communication and interpersonal skills.

TECHNICAL SKILLS

Project Management: Atlassian Jira, HP ALM

Collaboration Tools: Sharepoint, Confluence

API Tools: SoapUI, POSTMAN, Swagger

Languages: SQL, XML, HTML, JSON, CSS, Python

Office & UX: MS Office, MS Visio, Tableau, PowerBI

Database: AWS S3, Oracle, Excel, Informatica Powercenter, MySQL

Software Development: SDLC, Waterfall, Agile-Scrum, Kanban, Scrum-Waterfall, Scrumban, Safe

Salesforce CRM Platform: Sales, Service and Marketing Cloud, Knowledge, Flows, Process Builder

Supply Chain: Inventory Management, Order Management, Vendor Management, Materials Handling, Just-In-Time

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Worked in agile framework to allow for rapid development of a cloud-based architecture application.
• Performed GAP analysis, risk analysis and feasbility analysis, to find the required places of improvement, applicability & practicality of the modifications and to calculate an approximate budget.
• Performed cost-benefit analysis to study the suitability of Salesforce Community towards the application architecture.
• Gathered requirements using techniques such as interviews, document analysis, brainstorming and focus groups to build a satisfactory application capable of matching the project scope and stakeholder expectations.
• Facilitated and managed meeting sessions with committee of ‘subject matter experts’ to discuss possible services offered on the Community platform and the build of the functional components.
• Hosted JAD session to capture business rules to be implemented within the design and build of the application.
• Created prototype models to allow for improved understanding of the application architecture and to confirm with business clients, to ensure the application satisfies their needs and meets their expectations.
• Developed Activity, Sequence & use case diagrams using MS Visio to explain interactions between Salesforce Community and other platforms in terms of developer knowledge.
• Monitored progress of the overall project, tracked individual issues such as user stories, defects and technical debt using Atlassian JIRA, allowing for improved visibility of project status and accurate forecasts for project completion.
• Worked together with the team in defining acceptance criteria for user stories and aided with estimation & prioritization using MoSCoW for prioritization and Planning Poker for estimation of user story sizes.
• Attended daily scrum sessions to firmly understand project status and resolved potential conflicts and challenges.
• Acted as proxy product owner during sprint planning & sprint review meetings when required for unimpeded progress.
• Established guidelines for Knowledge statistics on News Articles set up with Salesforce Knowledge.
• Created an integration flow for documents to transfer between AWS S3 and Salesforce Community using Dell Boomi.
• Designed member profiles and permission sets to ensure members only have access to their relevant information.
• Designed process flows for custom components to incorporate business logic into Salesforce Community.
• Ensured APIs comply with business rules and follow best practices for security by employing DEVOPS.
• Tested APIs with Salesforce Inspector and evaluated CRUD operations with HTTP requests and verified that response, response time and errors were within expectations.
• Facilitated automated testing for APIs with SoapUI for load, error, functional & performance and rectified the issues.
• Connected the Community to Tableau to allow for a statistical report generation for Business Intelligence (BI).
• Performed smoke testing to ensure the modules are connected in the required manner and performed load and performance testing to understand application functioning and diagnose potential issues.
• Aided testers with test plans, test scenarios and test results to ensure all requirements were tested for satisfactory quality.
• Monitored the overall health of the platform during module integration, through repeated regression testing to identify and handle potential issues as they arise.
• Facilitated user acceptance testing, invited business users and catalogued reviews to ensure the application was user friendly, error free and met the expectations and needs of the end user.
• Collaborated with team members by sharing information and files using SharePoint to allow for better visibility.

Environment: : Agile-Scrum environment, JIRA 7.10, Salesforce Community, Salesforce Knowledge, Dell Boomi, AWS S3, SoapUI Open Source 5.4, SharePoint 2016

Confidential, Jersey City, NJ

Sr. Business Systems Analyst

Responsibilities:

• Worked in an agile Scrum environment responding to enterprise needs as they arose without disruption of work.
• Performed a feasibility study, risk analysis and cost-benefit study to understand the project scope, the potential complications and to select the best possible solution satisfying the integration problem between the two platforms.
• Created high level documents such as project charter, project management plan and finance reports.
• Conducted an ‘AS-IS’ GAP analysis to understand the structures of the CRM Salesforce and ERP JDE Enterprise 1.
• Met with stakeholders to understand their needs and gathered requirements by analyzing existing documents, interviews with developers and constructing prototypes to understand and confirm the solution requirements
• Recorded all issues such as epics, user stories, defects and technical debt in Atlassian JIRA and monitored the progression through the workflow of individual issues and the overall project progress.
• Assisted the team with prioritizing user stories as per MoSCoW and estimating with Dot Voting during product backlog grooming, and cataloging the various user stories as workflows for reference to xpi Integration Platform.
• Developed business process models with MS Visio for a better understanding of workflows via concept models.
• Recorded in End-User Guides all workflows created within xpi to allow for future referral for enhancement purposes.
• Ensured the business rules of the enterprise and best possible practices were implemented with regards to security of communication between Salesforce and JD Edwards Enterprise 1.
• Ensured the integration flows meet the standard performance requirements by facilitating automated load tests, scale tests and performance tests for various test cases and test scenarios with the quality assurance team.
• Carried out exhaustive functional testing and smoke testing to ensure integrations occurs as per business regulations to the best possible level in terms of performance and logic.
• Monitored the performance of all workflows during the testing process to ensure smooth operation, flagged and documented potential defects and bugs that cropped out during testing for rework and maintenance.
• Reported performance metrics and progress with reports generated with the aid of PowerBI to other team members.
• Updated all workflows which may have changed due to modifications in Salesforce clouds during project life time.
• Setup communication & notification channels within the integration platform in case of future discrepancies to transmit the error messages to the concerned party.
• Documented test plans and results to ensure all workflow requirements are well-designed and operate consistently.
• Performed UA testing by gathering relevant users, cataloging results and ensured future modifications of workflow can be carried out when required with existing documentation by any business analyst too.
• Confluence was used to mediate the project with team members to allow for better progress visibility and for better collaboration between team members.

Environment: Agile-scrum environment, Oracle JD Edwards Enterprise 9.1, Magic xpi 4.6, Atlassian JIRA 7.4, Tableau 10.3, Atlassian Confluence 6.3

Confidential, Phoenix, AZ

Salesforce Business Analyst

Responsibilities:

• Interacted with business users and stakeholders, to understand the requirements expected from the applications.
• Performed AS-IS analysis to better understand the required modifications to applications during Lightning transition.
• Performed rapid requirement gathering using techniques such as interviews, surveys & focus groups.
• Worked together with SMEs to design user roles, profiles and objects in a manner and facilitated establishment of role hierarchies and rule-sharing.
• Conducted user-story mapping sessions to develop user stories explaining application expectations, and facilitate estimation and prioritization that resulted in improved development process.
• Catalogued all requirements gathered in HPALM to facilitate monitoring progress of the project.
• Worked in agile-scrum environment as proxy product owner during sprint planning, review meetings.
• Attended daily scrum meeting to discuss with fellow team members progress on individual tasks, notify any change in application requirements and to resolve conflicts regarding application functionality.
• Documented ER, activity and use case diagrams to maintain relationships between objects.
• Implemented organizational, field, record and object level security rules to manage access rights and designed Salesforce standard, custom objects, fields and relationships to follow business rules.
• Established junction objects to maintain many-many relationships and defined lookup and master-detail relationships for the various objects to incorporate business logic into the application.
• Customized page layouts and templates that allow for faster navigation and access to information and documented all modifications made to the templates and catalogued all newly created objects.
• Determined tabs for various business user groups and set individual visibility to all information.
• Documented development of visual force pages to ensure development is per client’s needs.
• Catalogued Apex classes and triggers while working with developers to ensure appropriate best practices were followed and the implementation of business logic was as required.
• Documented APIs using Swagger and tested CRUD operations with HTTP requests using POSTMAN and verified that response, response time and error codes were within expectations.
• Facilitated unit, functional testing with HPALM to ensure the application satisfy the business demands.
• Managed UA testing by designing test catalogue and gathering end reviews from testers to ensure business users were satisfied with the usability and performance of the desired application.

Environment: : Agile environment, Salesforce, POSTMAN v3.2, Swagger 1.5, HPALM 11.53

Confidential

Business Systems Analyst

Responsibilities:

• Worked in Waterfall environment to develop an inhouse application with a three-tier architecture.
• Performed feasibility study and cost-benefit analysis to view the need and practicality of the project.
• Assisted in creation of various documents such as SRS, BRD, RTM and project management plan.
• Gathered requirements using interviews, document analysis, surveys and brainstorming with SMEs.
• Documented change requests, performed impact analysis and presented reports to the change approval committee and updated all documents when a change was approved.
• Created conceptual and logical models of the database entity structure and mapped entities with ER diagrams and documented keys to allow for easy reference while development.
• Documented source and target systems and profiled extracted data to comply with target system architecture.
• Aided developers with design of migration plans and migration execution to not affect business actions and processes.
• Mapped Oracle database with Informatica Powercenter to ensure a RDBS was designed to smoothly operate as per the business logic while incorporating information ported in from flat and csv files.
• Documented all ETL transformations and mappings performed while establishing the database.
• Developed test plans, test cases and test scenarios with QA team to ensure the designed application matches the requirements in terms of functionality, and for performance to be at a satisfactory level.

Environment: : Waterfall environment, MS Office 2013, Informatica 9.6.1

Confidential

Supply Chain Analyst

Responsibilities:

• Worked on shop floor as an operations analyst to ensure delivery of materials to the manufacturers.
• Monitored workers to ensure all operations and hand-offs run smoothly to manufacture best products.
• Forecasted production capability and material inventory by end of budget and time constraints.
• Performed Quality Analysis to ensure all manufactured products were within tolerance limits.
• Worked with product engineers to document all manufacturing activities involved for a product.
• Digitized product drawings to AUTOCAD to allow for easy reference and manufacturing analysis.
• Ordered and supplied materials to inventory and shop floor as and when needed to ensure continuous manufacturing capability is maintained.
• Interacted with workers to ensure manufacturing activities are performed as per the product design by coding CNCs to carry out manufacturing activities in the required order.
• Generated reports depicting individual progress per periodic intervals to record and document all progress for future referrals, predictions and analysis with the use of Tableau.