Sanjana Katragadda
Hyderabad
Summary
Software professional with 7+ years of experience in Reporting, Dashboard development, Data Analysis, Project Management, Application Management and Process improvement. Proven track record of successfully streamlining business operations and reducing costs. Adept at analyzing data to identify trends and developing strategies to improve efficiency.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Control Management Specialist (Sr. AVP)
Wells Fargo
10.2022 - Current
- Single point of contact for Issue Management related activities from offshore.
- Generated 20+ Issue Management reports using Microstrategy,Tableau, Sql, SAS and Excel on a Daily/Weekly/Monthly/Adhoc basis.
- Helped meet changing demands by recommending improvements to business systems or procedures.
- Generated Audit reports, Integrated Risk & Control Reporting slides and presented it to higher management in a clear and concise manner.
- Saved 16-20 hours of time per month and reduced manual efforts by automating 5 reports.
- Built dashboards in Tableau to test and analyze Data Quality and RAU Data.
- Enhanced the report generating process by migrating data source for multiple reports to use SQL and SAS instead of Microstrategy, reducing the number of tools and effort involved thereby reducing cost and improving report performance.
- Worked with PwC and changed the backend of reports to use SQL and Python, and maintained reports in PowerBI.
- Identified and decommissioned duplicate efforts on similar reports.
- Reduced operational costs by identifying areas for improvement and implementing cost-saving measures.
- Delivered successful projects within deadlines through effective time management.
- Developed strong relationships with stakeholders, ensuring clear communication and alignment on project objectives.
- Optimized workflow efficiency through the introduction of innovative process improvements.
Analyst 1 (BI and Application Management)
Bank Of America
07.2016 - 10.2022
- Gathered and documented business requirements from Management and translated them into report specifications for the MicroStrategy/ Tableau/ Apptio platform.
- Maintained all financial records of the bank in Apptio which helped in analyzing the cash flow, cost cutting and comparing trends with competitor banks.
- Developed a highly interactive Release Analysis dashboard that shows multiple stats for each release.
- Developed a fully interactive Code Quality Dashboard for a comparative view across teams. Filed a Quick Hit on this.
- Generated Key Performance Indicators (KPI’s) and created Attributes, Metrics, Filters, and custom groups. Manipulated attributes and their properties, used joins and unions to meet business requirements.
- Embedded handcrafted SQL statements in BI Platforms. Worked on solving performance issues.
- Built a workflow for Human capital risk analysis using Alteryx, to clean and manipulate the data, and loaded the data into Tableau to display trends.
- Performed exploratory data analysis on given data using python.
- Developed a tool using COGNOS SDK and Java to automate the movement of 50,000+ reports saving 92+ hours of time and manual effort.
- Worked on admin tasks such as providing access to reports, restricting user’s role, maintaining groups, migration of reports, creating datalink jobs to copy/move data, scheduling alerts when jobs are successful etc.
- Installed and configured Cognos 10.x components on LINUX and Windows, maintained all necessary business productivity functions of a Cognos system.
- Worked with the IBM Accelerated Value support team/ SAS team for proactive resolution of any product related issue.
- Worked on 30+ types of Application governance deliverables.
- Coordinated decommission, upgrade and implementation efforts in various environments.
- Performed retrofits on LLE’s and scans for risk items.
- Participated in Disaster Recovery and ARC exercises to ensure Business Continuity.
- Provided support and liaised between internal groups (Support, Development, DBA) for various application management tasks and improved existing internal procedures.
- Optimized core processes to improve business performance and operational agility.
- Increased efficiency by streamlining data analysis processes and implementing automation tools.
- Supported budgeting processes by providing accurate forecasts and timely variance analyses.
- Reduced operational costs with thorough analysis of vendor performance metrics and contract negotiations.
- Utilized data visualization tools to effectively communicate business insights.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Participated in requirements meetings to understand business needs.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Upheld security and confidentiality of documents and data within area of responsibility.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Reduced operating costs by automating manual data processes using scripting languages such as Python or R.
- Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements.
- Trained junior analysts on best practices, improving overall team performance and productivity.
- Utilized advanced query optimization techniques to enhance database performance and reduce latency issues during high-traffic periods.
- Collaborated with stakeholders to identify business needs and data sources.
- Developed and implemented data governance policies and procedures.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Implemented business intelligence solutions to increase operational efficiency.
- Collected data from wide-ranging sources.
- Monitored and optimized SQL server performance.
- Ensured compliance with industry regulations and internal policies through careful design of security protocols within the BI infrastructure.
- Assisted in budget planning activities by providing accurate projections based on historical trends and current market conditions.
- Reduced operational costs through the identification of inefficiencies revealed in-depth analysis of business processes.
- Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
- Validated results and performed quality assurance to assess accuracy of data.
- Improved internal knowledge sharing by developing comprehensive documentation outlining standard operating procedures for various tasks.
- Queried databases for information needed for report processing.
- Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
- Assisted in decision-making processes by presenting accurate, data-driven recommendations to stakeholders.
Education
B.E - Civil Engineering
National Institute of Technology
Warangal05.2016
Skills
- Business Analysis and Reporting
- Data Visualization and Presentations
- Data Analysis
- Process Improvement
- Project and Application Management
- Software Development Life Cycle (SDLC)
- Agile
- Analytical Thinking
- Attention to Detail
- Adaptable
- Excellent Communication
Additional Information
- Ranked among the top 0.5% of students in the AIEEE examination with an All India rank of 5854, in 2012.
- Lead the Digital Academy training program at Bank of America.
- Conducted Career Fair events, Town hall and fund raising events.
- Volunteered for CSR activities - Magic Bus India, Blood Donation Camp (Donor), Lake Cleaning etc.
Technical Skills
Power BI
Tableau
Microstrategy
SQL
SAS
Excel
Alteryx
Powerpoint
Certification
Certified Microstrategy Analyst
Data Science and Business Analytics - Great Learning
Timeline
Senior Control Management Specialist (Sr. AVP)
Wells Fargo
10.2022 - Current
Analyst 1 (BI and Application Management)
Bank Of America
07.2016 - 10.2022
B.E - Civil Engineering
National Institute of Technology
Similar Profiles
PATRICIA M. SCHERERPATRICIA M. SCHERER
Regional Bank Private Banker II at Wells Fargo Bank / Wells Fargo AdvisorsRegional Bank Private Banker II at Wells Fargo Bank / Wells Fargo Advisors
Andrew S. HollenbachAndrew S. Hollenbach
Collateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NACollateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NA
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
SAI SUSHMA INDRANI KANISETTYSAI SUSHMA INDRANI KANISETTY
Project Engineer at Wipro TechnologiesProject Engineer at Wipro Technologies