PROFESSIONAL SUMMARY:

• Have 8 years of experience as a Business Analyst on multiple projects related to Supply Chain.
• Hands on knowledge of business analyst deliverables, roles, responsibilities and function.
• Well versed with AWS modules for cloud - based computing to develop virtual applications.
• Integrated Salesforce and JD Edwards to smoother platform to operate and manage supply chain.
• Gathered experience from operations analyst to senior business systems analyst traversing through multiple supply-chain projects focused on improving operational performance and efficiency.
• Well versed with supply chain related analytics, such as calculating vendor performance, methods to improve supply chain efficiency, better manage inventories and handle orders. Have used and customized tools and integrated different platforms together to achieve the same result.
• Have developed cloud-based applications to monitor inventory, handle orders and track vendors allowing for a drastic increase in terms of supply chain functioning efficiency. These applications were designed using 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.
• Integrated CRM Salesforce and ERP Oracle JD Edwards 1 to bring about a seamless collaboration between the two platforms allowing for a noticeable decrease to response times of consumer queries, and providing better analytics with JD Edwards, hence improving real-time management.
• Strong knowledge of various processes of software development including agile-scrum and waterfall.
• Performed multiple feasibility, risk, cost-benefit & GAP analysis for better project understanding.
• Created multiple deliverables BRDs, SRSs, project plans, test plans & RTM to monitor requirements.
• Conducted JAD session, brainstorms, focus groups, interviews & surveys to gather requirements.
• Created activity & sequence diagrams with Lucid Charts to confirm business users’ requirements.
• Have tracked project issues using project management tools such as Atlassian JIRA and HPALM.
• Decomposed epics to user stories as per INVEST & DEEP criteria using slicing techniques. Estimated and prioritized user stories with techniques such as MoSCoW, KANO, Planning Poker, Dot Voting.
• Created conceptual and logical data models, documented migration plans, mapped source & target systems, profiled extracted data to clean and convert to target format.
• Knowledgeable 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.
• Utilized Informatica to perform ETL operations and transformations from source to target systems.
• Operated basic SQL commands such as CREATE, SELECT, INSERT, ALTER, UPDATE and DELETE.
• Knowledge of HTML and CSS to create static web pages.
• Documented & tested REST and SOAP APIs (XML & JSON) using SWAGGER, POSTMAN & SoapUI.
• Conducted automated functional, performance, black box, integration, regression and smoke tests to ensure applications work as required by business users.
• Facilitated multiple UA testing, gathered users, catalogued tests and reviews and ensured all applications met user needs, and satisfactions.
• Have documented and generated multiple reports using reporting tools such as Tableau, MS Excel, MS Office to inform higher ups clearly on project status, expected progress and financial requirements.
• Self-motivated, adaptive and able to work in a team or independently as per a deadline.
• Excellent organizational, communication and interpersonal skills.

TECHNICAL SKILLS:

Requirements & Modeling: Atlassian Jira, HP ALM

API Tools: SoapUI, POSTMAN, Swagger

Languages: SQL, XML, HTML, JSON

Office & UX: MS Office, Tableau, Lucid Charts

Database: AWS DynamoDB, Oracle, Excel, Informatica Powercenter

Software Development: SDLC, Spiral, Waterfall, eXtreme Programming (XP), Agile modeling

Collaboration Tools: Sharepoint, Confluence

Cloud Computing: AWS Lambda, Kinesis Data Firehose, Cloudwatch, Amazon API Gateway

PROFESSIONAL EXPERIENCE:

Confidential, Ada, MI

Sr. Business Systems Analyst

Responsibilities:

• Worked in agile framework to allow for rapid development of a cloud-based architecture application.
• Performed an “AS-IS” GAP analysis, a risk analysis and cost-benefit analysis, to find the required places of improvement, applicability & practicality of the modifications and to calculate an approximate budget.
• Performed a feasibility study to understand the compatibility of AWS EC2 and AWS Lambda towards the architecture of the project.
• Gathered requirements using techniques such as interviews, document analysis, brainstorming and focus groups to build a satisfactory application capable of matching the project scope.
• Facilitated and managed meeting sessions with committee of SMEs to discuss possible methods of improving order management and tracking vendor performance.
• Hosted JAD session to capture business rules to be implemented within the design 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.
• Developed ER diagrams, activity & use case diagrams using Lucid Chart to explain interactions between the DynamoDB resources 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 accurate forecasts regarding project completion.
• Resolved various conflicts of requirements that could have resulted in scope creep, worked together with the team in defining acceptance criteria and aided with estimation & prioritization of user stories using techniques MoSCoW, KANO, Planning Poker and Dot Voting.
• Attended daily scrum sessions to firmly understand project status and features under development.
• Acted as a proxy product owner during sprint planning and sprint review meetings when required.
• Established guidelines for AWS Kinesis Data Firehouse to process incoming information from the current application and 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.
• 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.
• 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.
• Carried out automated testing for APIs using SoapUI for load, error, functional and performance.
• The various modules of the application were developed and integrated using AWS SAM and AWS Cloudstar.
• 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 satisfied.
• 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, Jersey City, NJ

Sr. Business Systems Analyst

Responsibilities:

• Worked in an agile environment responding to enterprise needs as they arise.
• 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.
• 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 and ERP applications.
• Performed requirement gathering by analyzing existing documents, brainstorming with SMEs, interviews with developers and constructing prototypes to understand the project demands.
• 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 the various stories as per business value, with the ‘Definition of Done,’ and cataloging the various user stories as workflows for reference to xpi Integration Platform.
• Developed business process models for a better understanding of workflows via concept models.
• Aided the developer team by providing knowledge of business rules resulting in improved development time and performance of workflows within xpi.
• Recorded all workflows created within xpi to allow for easy future referral for development purposes.
• Ensured the business rules of the enterprise and best possible practices were implemented with regards to security of communication between the CRM and ERP platforms.
• Ensured the integrated workflows meet the standard performance by conducting automated load tests, scale tests and performance tests for various test cases and test scenarios.
• Carried out exhaustive functional testing and smoke testing to ensure workflow operates 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 any issues that cropped out during testing for rework and maintenance.
• Reported performance metrics and progress with reports generated with the aid of Tableau.
• Updated all workflows which may have changed due to modifications in Salesforce during project 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 satisfactorily designed.
• 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/ Admin

Responsibilities:

• Interacted with business users, to understand the requirements expected from applications.
• Performed AS-IS analysis to better understand the upgrades needed to the previous application.
• Performed rapid requirement gathering using techniques such as interviews, surveys & focus groups.
• Worked together with SMEs to design user roles, profiles and records in a manner which facilitates establishment of role hierarchies and sharing rules.
• 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 to allow for easy reference while development.
• Documented source and target systems and profiled extracted data to comply with target system.
• Aided developers with design of migration plans and migration execution to not affect business action.
• 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 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.

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.