Salesforce Business Analyst

• Aug 2023 - Present

Business System Analyst

• May 2022 - Apr 2023

Led the implementation and integration of a new email marketing platform with CRM, e-commerce, and data privacy systems to streamline data flow, improve segmentation & targeting, and enable personalized email campaigns. Collaborated with cross-functional teams; including marketing, digital commerce, data privacy, and IT; to gather requirements, define project scope, and develop solutions to meet business needs and goals. Successfully orchestrated the platform implementation across multiple brands, adhering to project timelines, budgets, and quality standards. Scoped and managed the implementation of over 90 trigger and journey campaigns for five brands supporting customer engagement across purchase, site, and customer lifecycle activities. Conducted thorough testing and quality assurance of trigger and journey campaigns, ensuring accurate deployment, tracking, and reporting. Provided training and support to marketing teams on platform usage and data management. Developed and executed end-to-end email marketing strategies, resulting in a 2x return on email marketing spend. Managed email campaigns, including planning, design, scheduling, testing, and analysis of performance metrics. Conducted audience segmentation and targeting to deliver personalized and relevant email campaigns, resulting in a 3x increase in conversion rates. Conducted A/B testing on email campaigns to optimize performance, resulting in a 75% increase in open rates and a 60% increase in click-through rates. Analyzed email campaign data and provided actionable insights to optimize email marketing efforts and align with business goals. Show less

System Analyst

• Jun 2020 - May 2022

Supported the onboarding and implementing of new staff and patient-facing systems designed to automate and modernize the company’s Pharmacy Healthcare business.Gathered and documented data requirements for the new applications, reviewed existing data fields being processed, and identified data gaps.Worked in Agile environments and created User Stories for patient communications, website interactions, and staff activities.Facilitated Joint Application Development (JAD) Sessions with internal stakeholders to communicate data requirements, data gaps, and process changes required to support the new systems.Wrote complex SQL queries in Postgres to migrate data from Oracle to AWS using Python processes and performing data validation.Provided pharmacy claims, rebates, drugs, and other data to downstream stakeholder systems in the form of View, API, or JSON formats.Actively involved in Program Incremental Planning, PI refinement, and Backlog Grooming sessions.Guided onshore and offshore development teams and provided Knowledge Transfer (KT) and training sessions. Show less

Quality Assurance Analyst

• Mar 2021 - Jun 2021

Responsible for the validation and testing of a new claims system.Develop test cases, scenarios, and data for the application.Performed tests verifying XML Request & Response to validate the auto recoup data for the Overpaid Claim was accurate.Investigated and addressed system issues to enhance usability and improve functionality.Analyzed the front-end and the back-end data to maintain consistency for the downstream stakeholders and systems.Gathered the data requirement from stakeholder teams to create reporting dashboards and performed post-development testing to ensure data flow and dashboard accuracy. Show less

Software Engineer

• Oct 2019 - Jun 2020

Supported the Company’s successful migration from DB2 to OracleGathered business requirements from the stakeholders and analyzed the scope of work or features needing to be migrated.Implemented ETL processes using Informatica to ensure successful data flow between DB2 and Oracle.Constructed Stored Procedures in Oracle to maintain data consistency and integrity on daily job runs.Performed regression testing to ensure existing customizations and integrations worked as expected.

Analyst and Web developer Intern

• Jul 2018 - May 2019

Developed and executed stored procedures in MS SQL to produce financial reports based on requirements. Used MS Excel Pivot tables to generate large amount of reports to identify employees pay as per the apartments rented. Assessed Rentals data in MS SQL to understand renters spending behavior to interpret the neighborhood which rented maximum apartments which increased the revenue by 30%. Established a user-friendly agent analysis report in Tableau by analyzing financial data to provide revenue and profit generated by each agent to the company. Show less