Business Analyst Power Bi

Name: Anuj Tewatia

Email Id: *************@*****.***

Contact no: +1-623-***-****

Professional Summary: Results-driven Business Analyst with 15+ years of proven experience across Wealth & Investment Management, Banking & Finance, Healthcare Benefits, and Retail domains.

Adept at translating complex business requirements into actionable solutions, with hands-on expertise in Python, Java, SQL, and automation tools.

Demonstrated success in KYC/AML compliance, mortgage and loan operations, credit card systems, digital onboarding, asset and wealth management, and capital markets initiatives.

Strong knowledge of financial instruments including equities, bonds, fixed income, and mutual funds. Proficient in investment banking processes and front, middle, and back-office operations. Experienced in regulatory compliance (FINRA, SEC, GLBA, FATCA, FDIC), risk management, and data governance strategies to ensure audit readiness and operational accuracy.

Experienced in regulatory reporting and compliance-focused data analysis, ensuring accurate and timely reporting aligned with financial regulations.

Expert in leveraging Agile and Waterfall methodologies to deliver full lifecycle project management.

Skilled in the use of JIRA for backlog grooming, sprint planning, and user story management.

Adept at creating BRDs, FSDs, UAT scripts, and regulatory reports.

Proficient in data visualization and reporting using Power BI and Tableau, with practical experience in database querying and ETL using MySQL and SQL Server.

Led numerous cross-functional teams across digital transformation projects, including implementation of automated trading platforms, loan origination systems, credit risk engines, and wealth portfolio analytics.

Recognized as a subject matter expert and go-to liaison for business and technical stakeholders, with exceptional leadership, documentation, and communication skills.

Domain & Technical Skills:

Domains: Wealth & Investment, Banking & Financial, Healthcare Benefits, Retails.

Tools & Technologies: Power BI, Tableau, Python, Java, MS Visio, Excel, PowerPoint, Word, JIRA, Selenium WebDriver, MySQL, Swimlane.

Key Skills: Agile & Waterfall Methodologies, Requirement Elicitation, Gap Analysis, UAT, RCA, RACI Matrix, Change Management, Leadership.

Educational Background:

Master of Science in Business Analytics, Grand Canyon University Phoenix, AZ.

Master of Business Management, Grand Canyon University, Phoenix, AZ.

Associate Degree in Business Management, Glendale Community College, Glendale, AZ.

Bachelor's degree (B. Com) in Pass, Delhi University.

Professional Experience:

Client: KeyBank, Ohio (Remote). Mar 2022 – Till Now

Role: Senior Business Analyst

Project: Ineligible Accounts for Withdrawals

Project Description:

Implemented a system to identify and manage ineligible accounts (frozen, fraudulent, suspended, unclaimed) to comply with FINRA, FDIC, and other financial regulations, optimizing processes across retail banking, credit card operations, and deposit management.

Key Responsibilities:

Conducted gap analysis to optimize processes for handling ineligible accounts related to loans, credit card charge-offs, and dormant asset accounts.

Utilized Requirement Traceability Matrix (RTM) to ensure end-to-end coverage of compliance and operational rules.

Developed audit protocols and automated business rules to identify red flags related to KYC/AML violations in withdrawal requests.

Ensured adherence to FDIC unclaimed property regulations, reducing compliance risks in account suspensions and estate processing.

Generated regulatory reports (e.g., SARs) via Tableau and SQL-based queries for improved risk and compliance visibility.

Partnered with capital markets desk to execute secondary market MBS trades and manage pipeline exposure.

Utilized Bloomberg, Intex, and proprietary analytics tools for MBS performance tracking and reporting.

Integrated data governance standards with account management and fraud risk processes, ensuring data lineage and accuracy.

Worked on the end-to-end lifecycle of regulatory reports, including requirement gathering, documentation, validation, and submission to regulatory bodies.

Collaborated with Risk, Compliance, Legal, and Front/Middle/Back Office teams to define protocols for identifying suspicious activity and frozen accounts.

Designed and maintained Swimlane diagrams, workflow models, and BRDs/FSDs to manage eligibility logic for wealth, mortgage, and loan accounts.

Applied SQL queries for data validation and report generation to ensure clean identification of ineligible records.

Delivered training to operations and compliance teams on workflow handling of flagged accounts.

Technologies & Tools: JIRA, Tableau, SQL, MS Visio, Excel, Python, Java, Swimlane

Achievements:

Automated eligibility validation and reduced unauthorized withdrawals by over 30%.

Strengthened compliance posture and risk control by aligning data protocols with FDIC, FINRA, and internal governance.

Improved operational efficiency and reduced manual interventions through process automation and UI enhancements.

Client: Morgan Stanley, (Remote). Sept 2019 – Jan 2022

Role: Business Analyst

Project: Digital Wealth Management & Automated Trading Platform Deployment

Project Description:

Spearheaded the implementation of a next-gen digital wealth management and automated trading platform, integrating KYC/AML, portfolio analytics, and digital onboarding, while ensuring alignment with GLBA, FINRA, and SEC regulations.

Key Responsibilities:

Led KYC/AML integration into the digital onboarding pipeline, ensuring compliance for HNW individuals and institutional clients.

Collaborated with compliance, risk, and finance teams to interpret regulatory guidelines and translate them into actionable reporting requirements.

Defined workflows for loan origination, credit card fraud detection, and mortgage servicing as part of wealth client services.

Collaborated with the Front Office (Advisors, Portfolio Managers), Middle Office (Risk & Compliance), and Back Office (Settlement, Operations) to define seamless STP workflows.

Created BRDs and FSDs for systems managing asset classes including equities, fixed income, mutual funds, and bonds.

Collaborated with securitization teams on residential mortgage loan pooling and investor presentations

Defined rule engines for risk scoring, trade compliance, and automated rebalancing using AML parameters and exposure thresholds.

Engaged in capital markets and investment banking initiatives tied to digital wealth services and structured products.

Utilized SQL to query client and trading data for testing automation and audit trails.

Participated in JIRA-based Agile ceremonies, including sprint planning, grooming, and retrospectives.

Conducted UAT to validate new features, including KYC verifications, order validations, and trading engine logic.

Gathered and analyzed business requirements for the development and enhancement of regulatory reports to ensure compliance with frameworks such as Basel III, MiFID II, and CRD IV.

Worked with the Data Governance team to ensure proper data mapping, lineage, and classification in portfolio management tools.

Technologies & Tools: JIRA, SQL, MS Visio, Python, Java, Tableau, Power BI, Document Management Systems

Achievements:

Enabled real-time portfolio performance tracking and 20% increase in trade execution volume through automation.

Enhanced client trading experience via seamless onboarding and transparent reporting.

Mitigated risk of compliance violations, ensuring full adherence to FINRA, GLBA, SEC, and AML standards.

Client: Dell Tech, Austin, TX. May 2018 – Aug 2019

Role: Business Analyst

Project: Automated Asset Tracking Correction System

Project Description: This project focused on designing and implementing an end-to-end solution to automate and streamline the Asset Tracking process, including error correction and approval workflows across front, middle, and back offices.

Key Roles & Responsibilities:

Mapped end-to-end asset movement workflows across front, middle, and back offices using swim lane diagrams.

Conducted requirement gathering sessions with stakeholders from front, middle, and back offices to understand pain points and define automation needs.

Created User journeys, epics, and user stories.

Designed and documented workflows for asset movement, error detection, correction, and approval processes.

Collaborated with development teams to build a robust tool that integrates seamlessly with existing systems.

Ensured tool adhered to SOX controls for accounting standards for asset tracking, implementing audit trails for all corrections.

Developed and executed test cases for functional, regression, and user acceptance testing (UAT) to ensure the tool met business requirements.

Prepared project artifacts, including Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), and process flow diagrams.

Conducted requirement gathering sessions with stakeholders from front, middle, and back offices to understand pain points in the existing asset movement process.

Designed and documented workflows for asset movement, error detection, correction, and approval processes to ensure seamless operations.

Achievements:

Reduced manual errors in asset movement processes by 40% through automation.

Improved approval turnaround time by 30% by streamlining workflows.

Client: Classico Wines, Phoenix, AZ Sep 2017 – March 2018

Role: Business/Data Analyst

Project: Inventory Management Optimization for Cost Effectiveness

Project Description: I worked on this capstone project as a business analyst for inventory management processes to achieve cost effectiveness by reducing excess inventory, minimizing stockouts, and improving overall operational efficiency.

Key Roles & Responsibilities:

Conducted a comprehensive analysis of current inventory management practices to identify inefficiencies and areas for improvement.

Performed root cause analysis to understand the factors contributing to overstocking, stockouts, and increased carrying costs.

Collected, cleansed, and analyzed historical inventory and sales data to identify trends and patterns.

Developed data models using techniques such as Time Series Forecasting, Simple Linear Regression, and Moving Averages to predict future demand and optimize inventory levels.

Collaborated with supply chain and operations teams to implement inventory optimization strategies, including Just-in-Time (JIT) inventory practices.

Designed and implemented a dashboard for real-time monitoring of inventory levels, stock turnover rates, and cost metrics.

Conducted cost-benefit analysis to evaluate the financial impact of proposed inventory management changes.

Provided training to stakeholders on the new inventory management system and forecasting tools.

Achievements:

Reduced inventory costs by 20% through optimized stock levels and improved demand forecasting.

Improved inventory turnover ratio by implementing data-driven inventory management practices.

Client: Discount Tire Company, Scottsdale, AZ Sep 2015 – Aug 2016 Role: Business & Quality Analyst

Project: Automation of Test Cases Using Selenium WebDriver

Project Description: As a Business and Quality Analyst, I worked on this project from requirement elicitation to automating test cases for Discount Tire’s web application using Selenium WebDriver.

Key Roles & Responsibilities:

Analyzed business requirements and functional specifications to identify test scenarios and create test cases.

Drafted Test Plan which included testing objectives, testing phases, scenarios and test environment after a thorough analysis of the business rules.

Developed automated test scripts using Selenium WebDriver with Java for functionalities like product search, pricing, discounts, and checkout processes.

Conducted functional testing, regression testing, and integration testing to ensure the application met quality standards.

Collaborated with developers to identify, report, and resolve defects using tools like JIRA.

Collaborated with stakeholders to gather and document business requirements for the web application.

Conducted gap analysis to identify discrepancies between business requirements and application functionality.

Created user stories, use cases, and process flow diagrams to guide development and testing efforts.

Perform Cross Browser Compatibility testing using Firefox Driver, Chrome driver, Internet Explorer Driver.

Participated in Agile ceremonies such as sprint planning, backlog grooming, and retrospectives to ensure alignment between business and technical teams.

Achievements:

Reduced manual testing effort by 40% through the implementation of automated test scripts.

Improved test coverage by automating 80% of critical test cases, ensuring comprehensive validation of application functionality.

Improved collaboration between business and technical teams by providing clear documentation and aligning testing efforts with business requirements.

Client: Nivansh LLC. Apr 2013 – July 2015

Role: Business Analyst

Project: New Market Expansion for Product Launch

Project Description: This project involved collecting and analyzing business requirements to support the company’s strategic initiative of expanding into new markets. As a Business Analyst, my goal was to understand the unique needs, regulatory requirements, and customer expectations of the target markets.

Key Roles & Responsibilities:

Conducted stakeholder interviews and workshops with internal teams (Marketing, Sales, Legal, Operations) to gather insights into market expansion goals and challenges.

Researched and analyzed market-specific regulations, cultural nuances, and competitive landscapes to identify key requirements for successful entry.

Conducted gap analysis to identify differences between current capabilities and the requirements for entering new markets.

Prepared Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs) to guide the development and implementation of market expansion initiatives.

Achievements:

Delivered a comprehensive set of business requirements that enabled the organization to successfully enter three new markets within the planned timeline.

Client: Aon Hewitt, Noida, India Sept 2003 – Dec 2010

Business Analyst

Team Developer

India Operation Manager Key Roles & Responsibilities:

Responsible for managing a team of Analysts & Team Member Also responsible for making sure that all the portions of ongoing service/client delivery work result in high-quality service for plan sponsors and plan participants.

Process scheduling, process flow, and delegating work to meet deliverables, tracking status of outstanding issues, Process Improvement and Associate Engagement.

Collaborate with Benefits Implementation Manager (BIM) to ensure proper handoffs to operations team. Ensures processing documentation is accurate and complete.

Reviews and signs off on escalated Benefits Analysts (BA) deliverables (e.g., data quality checks, client responses) to ensure ongoing adherence to standard operating procedures that ensure high quality and provide coaching and development of BAs to create a culture of continuous improvement.

Reports system defects to Lead Systems Analyst (LSA) via defect submission process and collaborates with LSA to mitigate participant damage/risk.

Achievements:

Successfully transitioned EFT Media Change project

Created Premium Macro Automation.

Client: Equinox Global Pvt Ltd, Gurgaon, India Apr 2001 – Aug 2003

Role: Business Analyst

Key Responsibilities:

Collected and analyzed Mortgage Loan data to evaluate territory performance resulting in new insights that allowed accomplish the goals.

Contributed to asset selection and pooling for residential mortgage securitizations.

Supported pricing and valuation of agency and non-agency MBS, including CMO structuring and tranche-level modeling

Used advanced Excel functions to combine data, create pivot tables and spreadsheets.

Developed long term business relationships with B2B customers through a weekly business meeting to understand customers’ business problems achieving new projects that boosted the company revenue.

Working cross-functionally to deliver system functionality to support streamlined and efficient processes.

Certification: Business Analyst Tools, Selenium WebDriver.

Contact this candidate