ad0sw3@r.postjobfree.com

+1-415-***-**** San Ramon, CA LinkedIn

OBJECTIVE

Results-driven Business Systems Analyst with over a decade of versatile experience across quality analysis, business intelligence engineering, and project management. Adept at bridging the gap between business and technology stakeholders, ensuring successful project outcomes. Skilled in translating complex technical concepts into clear, actionable insights for non-technical audiences. Proven track record of contributing to over 20 projects in various capacities. SUMMARY OF QUALIFICATIONS

• Expertise in driving cross-functional initiatives with multiple stakeholders.

• Strong experience in requirement gathering, analysis, implementation etc.

• Performed Data Analysis and Validations as per the requirements.

• Proven ability to successfully work for multiple requirements, design, and development approaches and methodologies (Agile).

• Good hands on experience in working with Tableau 10.x (Tableau Desktop, Tableau Public,Dashboards).

• Experienced in end to end software testing lifecycle, defect reporting, root cause analysis & test management.

• Designed and produced meaningful, effective Data Visualizations using Relational and aggregate data sources.

• Sound knowledge and understanding in Data warehouse, ETL and BI concepts, design and implementation.

• Proven analytical and problem-solving abilities, with a strong proficiency in MS Excel, MS PowerPoint & Tableau.

• Extensive experience as a Business Systems Analyst, specializing in requirements gathering, business process optimization.

• Exceptional communication skills, with the ability to convey technical details to non-technical stakeholders and vice versa.

• In-depth understanding of the software development lifecycle and project management methodologies.

• Strong project management skills with a history of successfully leading cross-functional teams. EDUCATION

Master of Science in Analytics, Northeastern University, Boston, MA GPA : 3.9/4.0 (JAN’20 - DEC’21) Bachelor of Engineering in Industrial, SRKNEC, India GPA : 3.5/ 4.0 (MAR’07- MAR’10) SKILLS

Programming and visualization Tools : Tableau, MicroStrategy, Microsoft Excel, SQL, Microsoft powerpoint, PowerBI Tools/Software : JIRA, HP ALM, Azure Synapse Analytics, Databricks, Microsoft Excel Databases : My-SQL,MS-SQL Server 2010, Oracle9i

Functional skills : Data Analysis, Business Analysis, Project management, Requirement Gathering, Project Management, ETL Operational Competencies : Agile/Scrum framework, Confluence, KPI Formulation, Process Optimization, SDLC PROFESSIONAL EXPERIENCE

BUSINESS ANALYST, BANK OF THE WEST (MAR’22 - AUG’23) Client - Bank of the West, CA

The LIBOR (London Interbank Offered Rate) which was a benchmark rate that has been used to calculate interest in a variety of financial contracts and used around the world for decades for short-term loans got phased out and was replaced by the Secured Overnight Financing Rate (SOFR) and this critical transition involved a pivotal role to facilitate a successful and compliant transition from LIBOR to SOFR, mitigating risks, and ensuring the stability and continuity of operations within Bank of the West Responsibilities :

• Conducted a comprehensive impact analysis to understand how the LIBOR to SOFR transition will affect various business areas, including contracts, financial products, and risk management.

• Collaborated with stakeholders to gather detailed requirements related to the transition, including system changes, process adjustments, and regulatory compliance.

• Worked with the IT team to align existing systems and processes with the new SOFR-based calculations and reporting requirements, ensuring a seamless transition without disruption to operations.

• Developed a data migration plan to convert existing LIBOR-based data to SOFR, ensuring data integrity and accuracy during the transition.

• Ensured that all activities related to the transition comply with regulatory guidelines and requirements, providing documentation and reports as needed to demonstrate adherence.

• Identified potential risks associated with the transition and implement risk mitigation strategies to minimize the impact on business operations and financial products.

• Communicated effectively with internal and external stakeholders, including clients, regulators, and industry partners, to provide updates on the transition progress and address any concerns or queries.

• Developed training materials and conduct training sessions for internal teams to educate them about the implications of the transition and how it will impact their daily operations and decision-making.

• Conducted thorough testing of systems, processes, and data conversions to validate the accuracy and functionality of the new SOFR-based infrastructure, ensuring that it meets the required standards and delivers expected outcomes.

• Maintained detailed documentation of the transition process, including changes made, challenges faced, and solutions implemented. Generated reports to provide insights into the progress of the transition and its impact on the organization.

• Continuously monitored the effectiveness of the transition, gather feedback from stakeholders, and identify areas for improvement to optimize processes and ensure long-term sustainability in the post-transition phase.

• Led end-end conversion of critical rate index across more than 10 line of businesses through SQL analysis & power BI reports

•

DEPUTY MANAGER, INFOCEPTS TECHNOLOGIES LTD, INDIA (JUN’21 - JAN’22) Client - NBCU Digital, NYC

Responsibilities :

• Collaborated with IT stakeholders to clarify and document business requirements, enabling the development teams.

• Worked closely with development teams to ensure software features aligned with business requirements and provided expected benefits.

• Translated business requirements into test scripts, validating software functionality and quality.

• Acted as the first line of defense during testing, ensuring overall software quality and eliminating significant bugs before release.

• Assisted in transitioning software solutions into production by providing informed training content. AASTHA CHACHRA

ad0sw3@r.postjobfree.com

+1-415-***-**** San Ramon, CA LinkedIn

• Continued to support business partners post-implementation by remaining responsive to maintenance and improvement opportunities.

• Led second phase of AMS migration of more 1000 micro strategy reports involving thousands of datasets.

• Analyzed data to identify trends, patterns, and insights that can inform business decisions.

• Used Tableau's features to perform data exploration, filtering, and calculations.

• Collaborated with business stakeholders to gather and document their data and reporting requirements. BUSINESS ANALYST, GLOBAL LOGIC (JAN’21 - MAY’21)

Client - SPOK, VA

Leading global leader in healthcare communications, providing clinical information to care teams to improve patient outcomes. Responsibilities :

• Responsible for understanding user requirements and creation of BRD & FRS documents.

• Translated business needs to development team.

• Worked closely with clients and developer to get QA fixes in every release.

• Responsible for UAT and JIRA management.

• Optimized dashboard performance and usability for end-users.

• Worked with data engineers and IT teams to integrate and clean data from various sources into Tableau.

• Ensured data accuracy, consistency, and reliability to support accurate reporting and analysis.

• Reported KPIs on Tableau Dashboard, created ad-hoc reports on the fly.

• Responsible for supporting business taking better decisions through storytelling and recommendation of KPIs via Tableau.

• Managed a team of 7 people, providing estimation, planning, and delivery for a complex client.

• Collaborated across teams, including development, business, product, sales, and management.

• Monitored projects in JIRA, managed user stories, and led SCRUM meetings.

• Created ad-hoc Tableau reports to support business decisions and recommend KPIs. BUSINESS ANALYST, INFOCEPTS TECHNOLOGIES (MAR’16 - JAN’20) Client - NBCU Digital

Responsibilities :

• Responsible for understanding user requirements and work with business analysts at the client’s end.

• Designed the QA plan, Test Cases, SQL scripts and QA summary report.

• Supported ETL validations by running SQLs on TeraData and Athena environments.

• Queried data as part of RCA on TeraData and all layers involved in Migration. Client - VERTEX PHARMACEUTICALS

Global bio-technology company that invests in scientific innovation to create transformative medicines for people with serious and life-threatening diseases. Traditional excel and power point reports that were being generated by Managed Market team at Vertex helped in measuring SPs’ / SDs’ performance for Vertex’s products, across various healthcare parameters needed to be replaced through a web based reporting platform for easier performance evaluation through interactive Tableau dashboards and reports. Responsibilities :

• Performed end-end lead business analyst operations starting with requirement gathering, stakeholder management, collaboration with cross-functional teams, creating artifacts post requirement elicitation like process flow, data modeling, BRD and getting client sign off.

• Analyzed data on SQL server to check the ETL transformations as well as dashboards to display correct data.

• Analyzed tableau reports, dashboards on web and iPhone/iPad to display correct data as well as functional driving

• Supported UAT

• Work closely with data scientists and data engineers to ensure seamless integration of diverse data sources, including laboratory data, clinical trial data, and regulatory information. Ensure data accuracy, security, and compliance with industry standards.

• Developed dashboards for utilization management and created essential metrics

• Developed QA Sanity Reports in Tableau that gave a picture on pass/fail scenarios on all tables in one document

• Introduced QA reporting through monthly dashboard metrics checks.

• Streamlined document templates through QMS implementation.

• Served as an SME in the pharmacy domain, reporting and recommending KPIs in healthcare.

• Guided and mentored a team of 4 resources to train them on the regulatory and compliance measure associated with healthcare

• Mitigated risk by identifying a critical KPI validation error, saving millions of dollars.

• Streamlined all document templates from BRD, FRS and all STLC documents through QMS implementation

• SME in pharmacy domain to report and recommend KPIs in all P’s across healthcare domain

• Published case study for Vertex pharmaceuticals business flow for all functions benefiting their guidance and patient support system

• Monitored closely the performance of speciality pharmacies on Vertex drugs and increased heir patient count by 45% BUSINESS ANALYST, COGNIZANT, INDIA (JAN’11 - JAN’16) KEYBANK

KeyBank is a leading bank at Ohio, offering a range of financial services, including retail banking, commercial banking, investment management, and corporate banking solutions. The bank provides various products and services to individuals, businesses, and institutions, including checking and savings accounts, loans, mortgages, credit cards, and wealth management services. The landscape evolved over numerous projects to advance their data and analytics tools and capabilities for crucial decision making Responsibilities :

• Analyzed banking data

• Collaborated with cross-functional teams including DEV, product manager, project manager and design teams

• Stayed unto date with Federal Bank updates and legal teams to ensure regulatory and compliance measures are well adhered

• Performed various testing (smoke, stress, integration) in all environments (SIT, DEV, PROD and UAT)

• Managed QA lifecycle in HP ALM.

• Monitored quality across multiple environments and conducted various testing types.

• Automated manual processes to optimize data delivery.

• Monitored quality across multiple environments and conducted various testing types. ad0sw3@r.postjobfree.com

+1-415-***-**** San Ramon, CA LinkedIn

• Supported the Data Product Team and the business partners to conduct due diligence of current state of data and analytics needs

• Worked with business partners to translate their business problems into data requirements ACADEMIC PROJECTS, NORTHEASTERN UNIVERSITY, BOSTON MA (JAN’20 - DEC’21) Story Telling and application through Tableau: Analyzed Airline On-Time arrival datasets and performed data profiling; communicated complex data information and insights by creating a dashboard by systematic use of visuals like bar charts, heat maps, scatter plots and proposed business decisions for a specified audience Capstone Project: Designed and implemented entire project roadmap for Keva Health sponsor to show KPIs related to patient and physician engagement for their Remote Patient monitoring platform in 2 dashboards through Tableau SUMMARY AND ACCOMPLISHMENTS

• Led QMS implementation across 20 clients and 100+ projects.

• Utilized dashboard development skills for internal performance evaluation.

• Monitored specialty pharmacy performance, increasing patient count by 45%.

• Excellent project leadership skills, proactive, create plans, processes to facilitate effective issue resolution.

• Expertise in reporting and presenting essential project management KPIs.

• Skilled in identifying and prioritizing deliverables & delegating assignments.

• Received appreciation from client for weekend and extended weekdays support.

• Received appreciation on successfully delivering the HMDA Feb’14 release project with 100% compliant to quality.

• Received numerous appreciations on effective communication & presentation skills & case study on Lean Methodology.

• Received LS client appreciation on identifying blockers in almost every sprint.

• Received accolades in reporting major data bugs.

• Received SPOT award at InfoCepts for outstanding delivery in projects.

• Received SYNERGY team award for overall team performance @InfoCepts.

• Star of the Month Award - June 2013 and March 2014.

• Received Client Appreciation on Quality work on Test Strategy & Test Design in ECP project. CERTIFICATIONS

• ISTQB Foundation Level

• L0 Software Testing, Cognizant Certified

• L0 Performance Testing, Cognizant Certified

• IELTS – 8.0 band

• MicroStrategy 10 Certified Analyst certification

• MicroStrategy 10 Certified Designer certification

• MicroStrategy 10 Certified Platform Administrator certification

• MicroStrategy 10 Certified SDK Developer certification

• Pharma 1-0-1 Domain certification – Internal

• ICDA certified

• Planned Tableau certification

Contact this candidate