Jahnavi Gunturu
Work Status – US: H*-EAD
*******.*******@*****.*** 480-***-**** San Francisco, United States
PROFESSIONAL SUMMARY
* ***** ** ********** ** a business analyst with an expertise in data analytics, business intelligence and Reporting and specialized in the banking domain
Experienced in customer facing roles as a business analyst and a product marketing specialist
Strong domain experience in the banking industry with an understanding of the Business Operations and the banking laws and regulations
Working knowledge with complex customer data related to financial crimes and AML and developing business critical insights and dashboards using Teradata, SQL, Microsoft Excel and Tableau.
Developed smart operational dashboards and reports for customer risk analytics, to track the KPIs, perform trend analysis and monitor the financial crimes business group’s initiatives
Business Intelligence lead focusing on UX, effective data visualization using Tableau, customer experience and improving the adoption
Experience in working with text-analytics based applications written in Python and leading the QA for the NLP models developed
End-end UAT planning and execution that include requirements analysis, strategizing test plans, writing test cases, signing off acceptance criteria, conducting A/B testing and acting as a subject matter expert for any support
Responsible for creating, managing and optimizing SQL databases and ETL jobs based on the project needs
Responsible for conducting stand-ups, monitoring the team’s sprint velocity, defect tracking and management
Experienced with Microsoft Excel (Pivot tables, VLOOKUP, Macros), Tableau Desktop, Server and Teradata SQL assistant (advanced queries)
A very effective translator of business requirements to technical requirements and vice-versa
SKILLS
Tableau Digital Analytics Microsoft SQL server AML Teradata A/B Testing UAT Quality Assurance Text Analytics Python Agile Methodologies Defect Management Product Owner Requirements Analysis Banking Microsoft Visio Microsoft Excel Microsoft SharePoint Sales support and marketing Financial Crime analytics Customer Relationship Management
WORK EXPERIENCE
Analytics Consultant, Financial Crimes
Wells Fargo
08/2019 - Present
Subject matter expert working cross-functionally for several projects in the Financial Crimes Operations and Customer Risk management domain, to adhere to the Bank Secrecy Act and Anti-Money Laundering regulations
Structured large data sets and performing complex SQL analyses for ad-hoc requests, recurring reports, identifying anomalies and impact analysis using Teradata and Microsoft tools
Business Intelligence Lead managing BI requests, defining processes and implementing analytics tools and dashboards end-end
Developed proof of concept analytics tools that achieved 90% feature adoption rate among the internal customers
Building the analytics for risk management to assist Wells Fargo's Line of Businesses(LOBs) in managing their high-risk customers.
Tools: Tableau Desktop, Microsoft Excel and Teradata SQL Assistant
Developing interactive dashboards using Tableau to provide analytics for the AML Systems with adherence to the Bank Secrecy Act, as amended by the USA Patriot Act
QA Lead, working with the line of businesses to analyze the product functionalities and UI workflows, in order to plan the Test Strategy and A/B test plans along with the teams and stakeholders involved and signing off the acceptance criteria
Collaborated with various business groups to assist with data collection, A/B test development and reporting
Performed QA for the NLP Models developed using Python for a text analytics based project
Conducting daily standups to ensure UAT progress, address blockers and clarify the requirements
Responsible for executing test plans and scripts, reporting the results and managing defects using the Application Lifecycle Management(ALM) tool
Business Analyst, Digital Analytics
Bank of America
04/2018 - 08/2019
Developed solution-driven dashboards using Tableau Desktop, to analyze the usability of the applications by the customers
Provided monthly/quarterly campaign reports & performance insights. Designed and developed core marketing and business metrics to create insightful automated dashboards and data visualizations for tracking and extracting useful business insights
Worked with the UX team and helped with Wireframing for the organization's tools and business applications along with defining the acceptance criteria.
Implemented custom SQL queries in Tableau to optimize ETL processes to improve the performance of data delivery
Worked on Business Intelligence standardization to create database layers in Teradata that can be used for the development of various Tableau reports/ dashboards
Worked with product and engineering teams as well as stakeholders to groom, plan and prepare project artifacts such as Business Requirements Documents(BRD), Functional Requirements Documents(FRD) and Software Requirement Specifications(SRS)
Worked with the test teams to ensure the test plans are well defined for effective test-driven development
Smoke testing for all the business scenarios in Development and Pre Production servers
Ensured adherence to operational and regulatory policies and procedures
Knowledge of applicable customer due-diligence, banking laws, regulations, company policies and procedures
Product Marketing
MP Advertising
01/2018 - 03/2019
Marketing and consulting firm that offers sales, customer acquisition and management for many fortune 100 businesses
Achieved 75% customer acquisition with a focus on leading market and competitor analysis using Microsoft Excel and Tableau
Ensured a high rate of customer retention through regular follow up, customer on-boarding support
Primary consultant with a 100% score for client care every quarter by deepening customer relationships through a thorough analysis of their needs and offering appropriate competitive market research analysis to customers.
Business Analyst
Genems Systems
10/2016 - 12/2017
Software services in the Health Care and ERP domains
Implemented Tableau dashboards to evaluate project goals, resource management and identify gaps in the business processes
Gathered and analyzed large amounts of data, summarized insights from the analysis, and clearly communicated analytical findings in a cohesive story
Performed data validation and quality assurance on stakeholder reporting
Built a few modules for the User interface of a health care application using Angular 2.0, CSS and JavaScript
Programmer Analyst
Cognizant
07/2014 - 08/2016
Evaluated user requirements and feedback and helped prioritize, develop, deliver features, and bug fixes using Microsoft Team Foundation Server
Prepared the reports for Test Summary, Daily Status, Weekly Status, Defects and Root Cause Analysis
Maintained and scheduled Tableau Data Extracts using Tableau Server and also responsible for implementing Change Requests received for existing Tableau dashboards
Maintained the development processes for ETL jobs and reports by effectively gathering requirements, designing, peer code reviewing and unit testing before releasing builds to QA
Worked with Microsoft Excel and SQL to query, analyze, and present data for various business functions. Also, responsible for bug fixes and feature enhancements for C# applications
EDUCATION
Master of Technology – Software Engineering Scrum Alliance Certified Scrum Product
SRM University CSPO®
06/2012 - 05/2014, India
Bachelor of Technology- Computer
and Engineering Owner
JNTUK University
06/2008 - 05/2012, India