Data Analyst Senior

Kiran Kopperla

*************@*****.*** 404-***-****

PROFESSIONAL SUMMARY

Results-driven Senior Data Analyst with extensive experience at Deloitte, specializing in SQL, data visualization, and ETL processes. Successfully expanded reporting capabilities, enhancing data accessibility and decision-making. Proven ability to collaborate with stakeholders and lead teams, delivering actionable insights and optimizing performance for large datasets. CERTIFICATIONS

Certified Tableau Data Analyst

Databricks Certified Data Engineer Associate

SKILLS

SQL and database management

Data modeling

ETL processes

Informatica PowerCenter

Business intelligence

Data analysis

Data visualization

SQL querying

Data blending

Agile methodologies

Mainframe systems expertise

EXPERIENCE

Senior Data Analyst

Deloitte Atlanta Nov 2021-Current

Designed and maintained Tableau reports aligned with user requirements. Created advanced dashboards featuring filters, parameters, and calculated fields to track customer KPIs.

Implemented row-level security and user filters to manage data access effectively. Developed visualizations utilizing various chart types including line, stacked bar, pie, heat map, and waterfall.

Applied performance optimization techniques to improve chart loading speeds for large datasets.

Extracted data from multiple sources through joins and data blending methods. Published dashboards on Tableau Server, ensuring end-user accessibility and efficient report sharing.

BI Data Analyst

Bank of America Aug 2020-Nov 2021

Collaborated with stakeholders and cross-functional teams to gather business requirements and direct development efforts.

Presented business insights to management, incorporating feedback and performing forecast analysis.

Redesigned reports to include additional parameters, increasing data granularity. Updated SQL queries and created views/tables for Tableau integration as needed. Extracted data using Python modules to produce comprehensive reports. Automated report extraction on server, ensuring timely delivery without manual intervention.

Developed reports through data extraction from diverse sources utilizing joins and data blending techniques.

Monitored Tableau server performance, scaling resources by adding nodes when necessary. Data Analytics Lead

Deloitte May 2015-Jul 2020

Expanded application from five to over 30 configurable reports within four years. Collaborated with CPG Subject Matter Experts and clients to identify key business needs. Converted requirements into user stories while coordinating data visualization efforts with development team.

Presented business insights to stakeholders and integrated feedback into actionable solutions.

Partnered with Consulting Partners and Senior Managers during four major Polaris implementations.

Designed highly parameterized Tableau visualizations utilizing SQL data extracts for enhanced reporting.

Drove ETL design and developed robust reporting data models for effective data management.

Established Data Mart to store essential facts and dimensional data supporting Tableau dashboards.

Developer / BI Lead

IBM Mar 2006-May 2015

Managed BI and data teams, collaborating with stakeholders to define business requirements and deliver solutions.

Maintained scrum team, reviewed user stories with Business team, and prioritized work effectively.

Designed actionable visual reports for key stakeholders to facilitate data-driven decision- making.

Trained teams on Tableau techniques and best practices to enhance reporting capabilities. Demonstrated strong database and analytical skills, with proficiency in SQL and relational database modeling.

Applied Object-Oriented Programming principles to improve data management processes. Administered Tableau Server, overseeing user management, security protocols, report distribution, installation, and licensing.

Integrated Tableau dashboards into SaaS web applications, emphasizing scalability, performance, and security.

Support Analyst

Tata Consultancy Services Apr 2004-Feb 2006

Enhanced the existing code as per the new requirements by the client Performed System and Unit Testing

Performed supporting activities and documenting changes EDUCATION

Bachelor's: Computer Science

Madras University

PROJECTS

IL IES Family Healthcare and Benefits - The IES is a new public benefits eligibility and case management system. The IES implementation is a joint initiative by the Illinois Department of Healthcare and Family Services (HFS) and Illinois Department of Human Services (DHS). The Caseworkers will use the IES system to determine initial and ongoing eligibility for Medicaid, Food Assistance, and Cash benefits.

Polaris - Polaris is a highly configurable, Net Revenue Management tool that helps drive smarter pricing and profitability decisions at multiple levels of organization of CPG companies. It uses prescriptive and predictive analytics to connect disparate data sources for complex market analysis.

Retail store & Associate, 5G Store & Associate - Developed PoC product using iOS Swift to send customized alerts to customers based on their past purchasing history once enter the store. Generating alerts for associate to refill the stock on shelf. Human Capital - This product developed for assessing the skills of employees and to identify gaps before promoting to next levels or moving different groups, this would help to train the resources.

Banking Projects

Bank of America - Working with ETL, Data warehouse and Reporting teams on user experience and digital side analytics.

SunTrust - Worked on Payments, Deposits, Retail modules. Bank of Montreal - Exposure to Retail and Deposits in Canadian bank.

Merrill Lynch - Worked as Production support analyst.

Contact this candidate