Avinash Sharma Email & Phone Number

Bengaluru, Karnataka, India

Team Leadership• Leading the data insights team for “Marketing & Functions” with 6 FTEs to support data driven decisions• Mentoring and guiding team member, fostering a data-driven culture within the organization.• Created team engagement plans to increase partnership across the globe and explored opportunities with R&D• Defined team goals, performance metrics, and growth strategies.Data Strategy & Architecture• Designed data architecture to optimize BI reporting framework for Sensitive Data and Home lending servicing team • Developed and executed data strategy that aligns with the company’s broader business goals. (Delta lake, Databricks)• Led the design, development, and maintenance of data infrastructure, including data warehouses, pipelines, and reporting systems. (SQL Server, Teradata, oracle, delta lake)• Ensured data governance, security, and integrity across all analytics operations.Business Intelligence & Reporting:• Lead the development of interactive dashboards, reports, and data visualizations that provide stakeholders with real-time insights into business performance. • Designed highly effective visualizations using Tableau for multiple projects. (Marketing Expense Analysis, FTC to FTE Conversion, Late Fee Analysis, Voice of Customer Analysis, CCB financial health)• Collaborate with cross-functional teams and managed relationship between technology, and management team, to outline timelines and milestones to align reporting with target end stateAdvanced Analytic & ML• Created an ML solution that won an innovation award for identifying variance drivers and producing natural language commentary (PyTorch, PySpark, Databricks, AWS, Tableau)• Created data transformation layer using python & PySpark)• Performed statistical analysis and using results to improve models• Partnered with stakeholders to understand their needs and designed and developed robust analytical data solutions to analyze Indirect expense allocation

❑ Led the “Home Lending – Serving” data analysis team with 6 FTE’s to support data driven decisions❑ Defined project requirements by identifying business needs, stakeholder’s requirement and market compatibility❑ Analyzed business requirements, design and creating technical specification to design source discovery project❑ Designed data flow architecture for “HPE & TSD 1308” process and creating end-user interface using visualization tools such as Tableau & SSRS❑ Designing and developing ETL workflows and datasets in Python, Alteryx, SSIS, SAS.❑Worked on project pipeline management, adhering to SLA’s and updates within JIRA❑ Mentored and guided the team members to ensure solutions are designed and delivered as per the client’s requirement without impacting business

Bengaluru, Karnataka, India

• Effectively provided highly complex data reporting, trending and data comparison • Owned complete development and maintenance of KPI’s, metrics and standard dashboard to assist campaigned data analysis• Built DataMart and OLAP system to provide multidimensional analysis for the performing mortgage campaigns • Accountable for business requirement gathering initiated /executed multiple meetings with various stakeholders across globe• Completed transition of email campaign process and improved the existing frameworks by optimizing the entire data transformation stage• Created process flow document for all the assigned project • Directed preparation of ad-hoc reports upon requests from stakeholders also supervised program and projects on-behalf of management

Bangalore

Bengaluru, Karnataka, India

Bangalore

• Worked on various projects which involved Data warehousing, Data modeling, Designing and creating Dimensions, Facts for OLAP Cubes• Designed reports which involved Tabular or Matrix data view and Charts by using reporting features like Drilldown, Drill-through, Sub Reports, parameterized reports (SSRS)• Proficiently suggested comprehensive design of dashboards and created attractive UI• Handled Performance tuning and data validation also implemented complex business logic in most simplified way• Effectively designed trend for KPI metrics and executed data validation and insure the authenticity of report • Performed unit testing, defect fixing, report deployment also performed Cube processing and created various set of Ad-Hoc reports

Bengaluru, Karnataka

• Worked on implementation of database design for data warehouse, and data cleansing • Designed report distribution system by integrating SSIS Package with SSRS report server• Prepared Standard and Ad-hoc reports for Business Analysis Process and involved in Package Deployment and Package Scheduling• Audited the historical data to ensure data integrity and defined metadata standards for the data warehouse• Responsible for attractive GUI designing using C#, .Net and implemented the Business Logic for the GUI• Created reports using SSRS for displaying various sales and budget detail based on clients requirement

Master'S Degree, Business Analytics

Bachelor Of Technology - Btech, Electronics & Communication

12Th