SUMMARY

• Highly skilled and results - driven Business Systems Analyst with 7+ years of experience across a variety of industries such as manufacturing, retail, and IT consulting services.
• Demonstrated expertise in analysing business processes, gathering requirements, and translating them into efficient technical solutions.
• Proven track record in successfully delivering end-to-end Salesforce projects, including customization, data migration, and system integration, to drive operational efficiency and improve sales effectiveness.
• Strong understanding of data modelling, ETL processes, and data governance principles, with a focus on developing scalable data warehouse solutions.

TECHNICAL SKILLS

Business Skills: Project Management, Requirement Elicitation, Release Management, Change Management, Risk Management, Defect Management, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, ROI Analysis, JAD Sessions, SWOT analysis, Stakeholder Analysis, Market Analysis, GAP Analysis, Root Cause Analysis, Feasibility study

SDLC Methodologies: Waterfall, Agile Scrum, Waterfall-Scrum hybrid, Scaled Agile Framework (SAFe)

Project Management Tools: JIRA, Confluence, MS Office 365 (Word, Excel, PowerPoint, Outlook, SharePoint), MS Project, Azure DevOps

Modelling Tools: MS Visio, Lucid Chart, Balsamiq, Draw.io

Database Management Tools: MS-Access, MS SQL Server, MySQL, PostgreSQL

ETL Tools: Informatica PowerCenter, SSIS, Salesforce Data Loader, MuleSoft Anypoint Platform

BI & Reporting Tools: Tableau, Power BI

Testing and defect tracking Tools: Micro Focus ALM, Postman, Swagger

CRM software: Salesforce (Sales and Service Cloud)

PROFESSIONAL EXPERIENCE

Confidential, Reno, NV

Senior Business Systems Analyst

Responsibilities:

• Worked closely with business stakeholders including sales, finance, and operations team to understand the current (as-is) business processes, pain points and desired outcomes.
• Documented data mapping and data transformations in MS Excel and identified defined the frequency of data synchronization between Salesforce and D365 ERP.
• Documented requirements for data encryption, access controls, or compliance with data protection regulations.
• Analyzed company’s sales data, historical trends, and market dynamics to identify patterns and correlations that can be used in the forecasting model.
• Created mockups of the user interface of the forecasting tool using MS Visio and presented to the stakeholders.
• Designed and developed data models to support complex business requirements using Salesforce's native data modeling tools, including custom objects, fields, relationships, and validation rules.
• Maintaineddata quality, by using data validation rules, formula fields and field-level security as part of the data clean-up process.
• Created process flow diagram in MS Visio using BPMN model to identify areas of improvement in the organization’s current processes and determine processes that can be automated in Salesforce.
• Automated manual business processes by leveraging native salesforce.com automation tools like process flows, workflows, and approval processes.
• Researched and found opportunities to utilize SFDC best practices, guidelines to improve system productivity, scaling, and monitoring.
• Extensively used JIRA and Confluence for documenting requirements, creating user stories, tracking bugs, and raising issue tickets.
• Assisted the Product Owner in vertically slicing user stories and prioritizing Product Backlog Items (PBI).
• Worked with Scrum Teams in estimating PBIs and creating well-defined acceptance criteria.
• Facilitated backlog grooming and sprint planning meetings, ensuring effective collaboration and alignment between cross-functional teams.
• Implemented SQL queries (select, insert, update, delete, sub-queries, joins, etc.) to retrieve and manipulate the data in the databases.
• Assisted the QA team to prepare Test Plans, Test Cases, Test scripts, and Requirements Traceability Matrix (RTM).
• Performed user acceptance testing (UAT) and ensured the test results meet defined criteria to meet the business objectives to receive sign-off from the business stakeholders.
• Collaborated with stakeholders to assess the impact of proposed changes, identify potential risks and challenges, and develop comprehensive change management strategies.
• Ensured the stability and reliability of the production environment by conducting thorough investigations, documenting, and prioritizing defects, and working closely with development and testing teams.

Environment: Waterfall-Scrum Hybrid, MS Visio, MS Office 365, SharePoint, JIRA, Confluence, Salesforce, Microsoft Dynamics 365, MuleSoft Anypoint Platform, MS SQL Server, Postman, Swagger, Tableau

Confidential, Princeton, NJ

Business Analyst / Project Manager

Responsibilities:

• Designed the flow of tickets and handling of different case types and statuses following Information Technology Infrastructure Library (ITIL) framework.
• Conducted data migration of Contacts, Accounts and Opportunities from legacy CRM to Salesforce using Data Loader.
• Built a brand-new sales pipeline from Lead creation to Opportunity Closed Won with client team.
• Created wireframes of the user interface of the web portal and mobile application using Lucid Chart.
• Defined project scope, objectives, and deliverables in collaboration with clients and stakeholders.
• Developed comprehensive project plans, including timelines, resource allocation, and budget management.
• Proactively identified and addressed project issues, risks, and dependencies, implementing effective solutions to keep projects on track.
• Facilitated scrum ceremonies such as daily stand-up, backlog grooming, sprint planning, sprint review, and sprint retrospective to ensure effective collaboration and communication within Agile development teams.
• Performed gap analysis by identifying the as-is and to-be processes and the capabilities of the Salesforce system to reveal configuration and customization requirements.
• Worked closely with the technical team in converting the functional requirements and non-functional requirements into technical specifications using UML diagrams like Sequence diagrams, Activity diagrams, and Use Case diagrams.
• Collaborated with the QA team to write Test Plans, Test Cases, and Test scenarios and performed UAT.
• Created training material for knowledge transfer to end users and evaluated end-user satisfaction via online questionnaire.

Environment: Agile Scrum, Lucid Chart, MS Office 365, MS Project, JIRA, Confluence, Salesforce (Sales and Service Cloud), Salesforce Data Loader, Postman, Swagger

Confidential, Mobile, AL

Business Systems Analyst

Responsibilities:

• Analyzed existing Salesforce reports and identified the data elements and metrics required for migration to the new Data Warehouse.
• Worked closely with data engineers and ETL (Extract, Transform, Load) specialists to extract data from Salesforce, transform it into a suitable format, and load it into the Data Warehouse.
• Collaborated with data architects and database administrators to design an optimized data model that supports the reporting and querying requirements of the business users.
• Defined report templates, data visualizations, and interactive dashboards to empower business users with self-service reporting capabilities.
• Collaborated with database administrators and performance tuning experts to optimize the performance of the Data Warehouse and ensure efficient and timely retrieval of data for reporting purposes.
• Defined access controls, user roles, and data-level security to safeguard the integrity and confidentiality of the data in the Data Warehouse.
• Created comprehensive documentation, including data dictionaries, report specifications, user guides, and training materials, to facilitate knowledge transfer and provide a reference for future maintenance and enhancements of the reporting solution.
• Created user stories, monitored project status, and handled change requests in Azure DevOps and communicated to the stakeholders at regular intervals.
• Addressed issues that arose during the go-live period by performing root cause analysis or collaborating with the development team.

Environment: Waterfall-agile hybrid, MS Visio, MS Office, SharePoint, Azure DevOps, Azure Synapse Analytics, Salesforce (Sales and Service Cloud), Micro Focus ALM, PowerBI

Confidential, Oakbrook Terrace, IL

Business Intelligence Systems Analyst

Responsibilities:

• Familiarized with data warehouse, data mart and Business Intelligence concepts by performing literature review.
• Analyzed Data mart business requirement and identified and located various sources for data extraction.
• Documented business, functional, and non-functional requirements and segregated them into Use Case Specification.
• Conducted exploratory analysis of the source system to determine data mapping and transformation requirements.
• Assisted in developing Conceptual and Logical Data Models with the help of Entity-Relationship (ER) Diagrams.
• Established Facts, Dimensions and identified a schema for the data marts.
• Conducted and participated in walkthroughs to discuss certain issue with the development, design, and QA team.
• Assisted in ETL design for the data load from sources to staging database in Informatica PowerCenter.
• Assisted in creation of OLAP cubes in Microsoft SSAS based on end-user’s Reporting and Analysis requirements.
• Executed SQL queries to retrieve data from database and validated as per requirements.
• Used Tableau to create standard and interactive reports based on business requirements to represent the customer purchasing patterns with different product preferences and prediction of the future outcomes by converting data into actionable insights.

Environment: Waterfall-Scrum hybrid, MS Visio, MS Office, SharePoint, Azure DevOps, MS SQL Server, Informatica PowerCenter, SSAS, Tableau

Confidential, New York City, NY

Business Analyst

Responsibilities:

• Conducted interviews especially with Shopify shop owners to perform problem and solution validation.
• Performed requirement analysis using MoSCoW and made requirement changes using input from interviews.
• Analysed existing conversion rate optimization apps to identify gaps and bring unique value proposition.
• Gathered ideas for UX hypotheses to conduct A/B testing from industry experts and Shopify CRO applications.
• Performed cost flow, cash flow, break-even analysis in MS Excel to generate pricing strategy for the product.
• Responsible for identifying and documenting business rules, creating Use Cases and conducting UAT.
• Worked on branding of the application by selecting potential design and color for the logo, and application name.
• Contributed to marketing campaign of the application by sharing UI/UX ideas for the landing page in the website.

Environment: Agile Scrum, Balsamiq, MS Office Suite, JIRA, Confluence, PostgreSQL, Google Analytics