Kaberi Patra
Martinez,CA
Summary
Data analyst with over 10+ years of experience interpreting and analyzing data to help make data-driven decisions. Proficient in SQL and Data visualization tools like Tableau.Skilled in conducting thorough exploratory data analysis and employing techniques to identify trends and patterns. Proven ability to work collaboratively in cross-functional teams to deliver high-quality analytical solutions.
Overview
16
16
years of professional experience
Work History
Data Analyst
First Republic Bank
San Francisco, CA
07.2021 - 05.2023
- Perform data analysis, gap analysis, impact analysis, and root cause analysis (RCA) for MDM client data
- Involved in various data reconciliation, remediation, and RCA for the MDM Team.
- Create variance reporting by using Snowflake SQL, Tableau, Sigma, and YAMLs framework for multiple sources and targets which includes more than 100 client attributes
- Conducted ad-hoc data requests and provided analytics support to various departments.
- Generated reports and obtained data to develop analytics on key performance and operational metrics.
- Worked with internal teams to understand business needs and changing strategies.
- Collected, tracked and reviewed data to evaluate business and market trends.
- Provided technical support for existing reports, dashboards or other tools.
Data Analyst
Wells Fargo
San Francisco, CA
08.2019 - 07.2021
- Worked closely with Corporate Investment Banking to design, maintain, and update actionable and user-driven performance dashboards/Reports in Tableau, SQL, and
- Salesforce for QFC Stay Team
- Created reports for weekly, monthly, and quarterly Business service reviews across all verticals in
- Salesforce and Tableau
- Worked on Weekly Data remediation projects.Maintaining the accuracy of over 1 million documents and agreement terms data within the Salesforce document tracking system and document repository system for Dodd-Frank regulation
- Provided reoccurring and ad hoc reporting related to QFC record keeping and regulatory documentation requests.Research to assess our data quality, identify gaps and propose solutions.
Data Analyst
Workday INC
Pleasanton, CA
08.2018 - 04.2019
- Worked closely with business partners to design, maintain, and update actionable and user-driven performance dashboards in Tableau, and ServiceNow using Agile Methodology
- Collaborated with IT Engineering and Operations Leadership to develop and measure quantifiable
- KPIs and SLAs for IT Service Management data including Incident, Tasks, SLAs, Response,
- Resolution, Request, and Change Data
- (Includes Identity Management, Remote Service Desk,
- Local Walk-ups, AV, and Logistics)
- Review performance data to identify data anomalies, outliers, and trends and communicate these findings and suggested solutions/workarounds to appropriate
- Workday partners
- Created reports for weekly, monthly, and quarterly Business service reviews across all verticals in
- ServiceNow
- Involved in end-to-end development, such as ETL, Reporting, and creating Dashboards in Tableau
- KPIsDelivered: Average time to resolve an incident,% of incidents resolved within SLA, Average customer satisfaction, Average customer dissatisfaction,% of High
- Priority Incidents Resolved
- Average Time to Close a Change Request.
Data Analyst
Symphony Teleca
10.2011 - 07.2014
- Translate data from the structured database into information that helps companies measure key performance indicators (KPIs)
- Collaborate with key business users to collect information on business processes and perform requirement analysis
- Helped clients and management to make better decisions by statistically comparing historical data using reporting and analytics, resulting in customer acquisition and profit growth
- Analyzed the business data and business logic to create the proposed OLAP data model
- Designed the Excel add-in (rpm workbench) reports for Forecast planning, Demand Planning, and Operation planning reports
- Developed tables, stored procedures, and views, created ad-hoc and customer-specific visualization and reports using Tableau, and presented them to the end user
- O Created Monthly,
- Quarterly Forecasted Reports
- O Created Reports with KPIs Gross margin, Net Revenue, and Churn Rate GTM (Go
- To Market Solutions)
Data Analyst
10.2011 - 06.2012
- Conducted Business analysis, Requirements gathering to develop new Reports and
- Dashboards
- Created high-level design documents and technical specifications for Tableau
- Dashboards, Visualizations, and Reports
- Manage the planning, development, and design of the OLAP reports and the interactive dashboards
- Created Various Complex reports with the help of Symphony RPM and Tableau
- For Eg: Excel Add-in Reports for the Sales Head to check the Monthly and Quarterly Expected
- Revenue in advance.Created an OLAP report to show the best-selling product and its revenue by year, quarter, and month.
Data Analyst
Sigma Info Solution
10.2010 - 10.2011
- Successfully Interpreted data to conclude executive action and strategy
- Presented findings to the data team to improve strategies and operations
- Proposed solutions to improve efficiencies and reduced total expenses
- Used advanced Microsoft Excel to create Pivot Tables, used VLOOKUP and other Excel functions
- Created the data warehouse, OLAP cubes, and report bursting (both desktop and mobile compatibility)
- I was involved in designing and developing cross-tab reports, drill-down reports, and flash charts for reporting operational KPIs
- Helped to transition the entire company's reports from Crystal Reports to Micro strategy.
BI Developer
Cignex Datamatics
04.2009 - 09.2010
- Extracted, compiled, and tracked data and analyzed data to generate reports.Established a data warehouse to analyze the Statistical Data on the Cignex Recruitment and Helpdesk teams
- (reports consumed by H.R and the Higher Management)
BI Developer
DefTeam Solution Pvt Ltd
10.2008 - 03.2009
- Created different parameterized and operational reports for - every hour, every plant, and everyday data analysis
- Designed graphical reports to analyze power and revenue generation for various geographical locations
- Scheduled the reports for daily business data analysis across different geographical locations.
BI Developer
Acquinas Solution Pvt Ltd
10.2007 - 10.2008
- We have created reports that will give insight into the resource hiring, joining details, and salary information to help the human resource team in their smooth staffing process
- We created reports to show the statistics for the candidates recruited.
Education
Bachelor of Technology -
Biju Patnaik University of Technology, University of California
05.2007
Skills
- Programming:
- SQL, Python (Pandas, Numpy)
- Database Server: Oracle, DB2, SQL Server, MySQL, PostgreSQL, Snowflake, DBT
- BI Tools: Tableau, Tableau Prep, ServiceNow, Salesforce, Pentaho BI Suite
- Workbench and Report Designer), Symphony RPM (Analytic Workbench), Talend
- Data Integration, Pentaho Data Integration, Jasper soft, QlikView, SDK, Sigma
- Cloud Technology: Redshift, Server-less services, Big Query, Snowflake
Timeline
Data Analyst
First Republic Bank
07.2021 - 05.2023
Data Analyst
Wells Fargo
08.2019 - 07.2021
Data Analyst
Workday INC
08.2018 - 04.2019
Data Analyst
Symphony Teleca
10.2011 - 07.2014
Data Analyst
10.2011 - 06.2012
Data Analyst
Sigma Info Solution
10.2010 - 10.2011
BI Developer
Cignex Datamatics
04.2009 - 09.2010
BI Developer
DefTeam Solution Pvt Ltd
10.2008 - 03.2009
BI Developer
Acquinas Solution Pvt Ltd
10.2007 - 10.2008
Bachelor of Technology -
Biju Patnaik University of Technology, University of California
Similar Profiles
Carlos GonzalezCarlos Gonzalez
Specialist 1 at First Republic BankSpecialist 1 at First Republic Bank
Sean SchwartzSean Schwartz
Senior Preferred Banker (March 2021 - July 2024), Preferred Banker (August 2015 - March 2021) at First Republic BankSenior Preferred Banker (March 2021 - July 2024), Preferred Banker (August 2015 - March 2021) at First Republic Bank
Rijka MilovanovskiRijka Milovanovski
Preferred Banker at First Republic BankPreferred Banker at First Republic Bank
Octavio LimonOctavio Limon
Substitute Teacher at Swing SubsSubstitute Teacher at Swing Subs
Jay GandhiJay Gandhi
Manager of Enterprise Risk Management at UpstartManager of Enterprise Risk Management at Upstart