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.
• Deployed various features of Amazon Web Services to build a cloud - based, multi-service computing application.
• 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.
• Have developed an enhancement of a cloud-based application to monitor inventory, handle orders and track vendors allowing for an increase in terms of supply chain functioning efficiency.
• This enhancement was designed with AWS services to construct a multi-service serverless architecture.
• Strong functional knowledge of various AWS modules for cloud computing including AWS Lambda, AWS EC2, AWS S3, Amazon API Gateway, Amazon Kinesis and Amazon Dynamo DB.
• 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 Lucid Charts 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, Lucid Charts

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

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

Cloud Computing: Amazon Web Services, Microsoft Azure

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

PROFESSIONAL EXPERIENCE:

Confidential, Ada, MI

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, Jersey City, NJ

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 a cost-benefit analysis to study the suitability of AWS EC2 & Lambda 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 methods of improving inventory &order management and tracking vendor performance with maximum permissible efficiency.
• 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 ER diagrams, activity & use case diagrams using Lucid Chart to explain interactions between DynamoDB resources with Lambda functions and the functioning of the application 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 AWS Kinesis Data Firehouse to process incoming information from the current application and to forward the results and files to their respective destinations.
• Modeled data structures (documents) in AWS DynamoDB using AWS DMS.
• Performed SQL queries to monitor data from RDBS, and imported data to DynamoDB using AWS DMS.
• Aided developers to in corporate business logic in DynamoDB for better analytics and performance of the application.
• Categorized and tagged objects in Amazon S3 to allow for quick referrals and improved analytics.
• Maintained APIs between the internet and virtual cloud using Amazon API Gateway to allow for a well-ordered communication between the application and external devices (browser, phone, tablets).
• Ensured APIs comply with business rules and follow best practices for security by employing DEVOPS.
• Documented APIs using Swagger and tested CRUD operations with HTTP requests and verified that response, response time and error codes were within expectations.
• Facilitated automated testing for APIs with SoapUI for load, error, functional & performance and rectified the issues.
• The modules of the application were developed & merged with AWS Serverless Architecture Management (SAM).
• Connected the Order and Inventory modules to PowerBI to allow for 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 cloud during module integration, using AWS CloudWatch to 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, AWS Lambda, AWS DynamoDB, AWS Cloudwatch, AWS DMS, Amazon API Gateway, AWS SAM, SoapUI Open Source 5.4, Sharepoint 2016

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 in corporate 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.

Confidential

SQL Developer

Responsibilities:

• Helped deploy, upgrade, manage and extract data from the database for reporting purposes.
• Executed various SQL queries for data modification to maintain integrity in terms of data quality.
• Cleaned the database regularly by deleting all duplicated data and cleaning incomplete data.
• Established new relationships as needed to integrate data from multiple sources.
• Backed up the databases using bulk operation to migrate data across different servers.
• Recorded all modification queries and database maintenance for future referrals.
• Documented relationships of various RDBS resources to map the interactions between data stored.