Akshita Sahni
Newark,CA
Summary
. Professional Business Analyst with advanced knowledge of portfolio asset management systems and skill in driving positive outcomes. Exceptional organizational, project management and leadership skills. Adaptable assessor of business health and product success with expertise in optimizing solutions for changing industry landscapes.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Business Analyst
FIRST REPUBLIC BANK
San Francisco, CA
04.2018 - 11.2021
- Utilized advanced Excel skills, SQL reporting and SSRS to generate aggregated reports, providing better insights for the company to make decisions
- Accomplished automation of various department databases through SCRUM model, Delivered user support and coordinated resolution of issues
- Established automated solutions for Tableau dashboards, key data presentation, and report generation for Quarter-End Reporting for Executives
- Developed an end-to-end understanding of the vulnerability data flows and related system processes/interfaces by creating SSRS dashboards, detailed project road maps, data model schema using SQL queries
- Responsible for UAT testing of the application using Desktop Analytics/ MS Azure to ensure functionality is developed as per the requirements for maximum end user’s satisfaction
- Collected, evaluated and compressed data and information from multiple sources, resolve conflicts and differentiate between actual and required user needs
- Met with stakeholders to establish favorable business relationships and support mutually beneficial interests
- Drafted reports on company financial metrics to assess successes and account for deficiencies
- Led cross-functional teams to analyze and understand enterprise-wide operational impacts and opportunities of technology changes
- Evaluated trends to understand competitive environments and assess current strategies
Project Manager/Analyst
POLLSIFY
San Francisco, CA
06.2017 - 05.2018
- Met project deadlines without sacrificing build quality or workplace safety
- Maintained relationships with material vendors to lower costs and diversify capabilities
- Identified plans and resources required to meet project goals and objectives
- Led project teams through design, construction and launch process
- Provided detailed technical and operational direction in project challenges, consistently meeting deliverables according to deadlines
- Accelerated progress by continually reviewing performance, budgets and project timelines
- Drove team success through shared vision and recognition of quality performance
- Facilitated communication between internal personnel, contractors and vendors for project cohesion
- Maintained clear communication with precise technical writing to document and inform critical processes
- Maintained compliance with regulatory parameters in complex projects with overlapping policies
- Developed and initiated projects, managed costs and monitored performance
Financial Advisor
UNIVERSITY OF TEXAS, ARLINGTON
Arlington, TX
01.2016 - 12.2016
- Established the scripts, on Python and R, necessary for fetching and parsing data records from the university databases for efficient account privilege grant operation
- Executed importing and exporting data into Hive using Sqoop
- Solutions Design Documents (SDDs), and Contingency Operations Plan
- Generated ad-hoc reports for clients and management on a daily and weekly basis using tableau
- Assigned monthly targets for different departments according to clients’ requests
- Accomplished analysis of massive data sets to determine optimal way to aggregate and report on it
- Performed quantitative forecasting on sales and inventory data to predict expense and sales cost of products, thus saved 5% of monthly budget
- Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server; enabling the management to understand the data on the fly with the use of quick filters
- Functioned as a liaison between management end-users, technical and information technology analysts, and students in the design, configuration, testing and maintenance of university management systems to ensure optimal operational performance
- Handled resolution of issues with the help of change management plans.
- Created business plan and identified target customers by interacting on phone and in person, handling basic inquiries and providing quotes
- Facilitated presentation and recommendation of services by optimizing client relationships
Education
Master of Science - Information Systems
The University of Texas At Arlington
Arlington, TX05.2017
Bachelor of Science - Information Technology
MAHARASHTRA INSTITUTE oF TECHNOLOGY
India05.2015
Skills
- Analytical Tools:
- ServiceNow, SAP Business Object, MS Project, MS Visio, OLTP tools, Alteryx
- Visualization: Tableau, Power BI, Informatica
- Programming: SQL, Visual Basic, Python, R
- Proficient in Tableau, Power BI, SAP , Informatica, JIRA, MS Excel, MS SQL Data Studio, Crystal Reports,
- Desktop Analytics, SSRS Report Builder, SSAS, SSIS
Certification
Excel 2016 The complete excel master course
Tableau 10 A-Z: Hands-On Tableau Training for Data Science
Professional SCRUM Master Certification
Professional SQL : Data Reporting and Analysis
Timeline
Business Analyst
FIRST REPUBLIC BANK
04.2018 - 11.2021
Project Manager/Analyst
POLLSIFY
06.2017 - 05.2018
Financial Advisor
UNIVERSITY OF TEXAS, ARLINGTON
01.2016 - 12.2016
Master of Science - Information Systems
The University of Texas At Arlington
Bachelor of Science - Information Technology
MAHARASHTRA INSTITUTE oF TECHNOLOGY
Similar Profiles
JEROME DERILOJEROME DERILO
Architectural Associate / Project Manager at First Republic BankArchitectural Associate / Project Manager at First Republic Bank
Kaberi PatraKaberi Patra
Data Analyst at First Republic BankData Analyst at First Republic Bank
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
Michael ChauhanMichael Chauhan
Crew Member at Chipotle Mexican GrillCrew Member at Chipotle Mexican Grill