Nikhil

- Understand business requirements and create reporting analytics solutions aligned with those needs.
- Collaborate with essential stakeholders, forging relationships to analyze and present crucial metrics.
- Develop user-friendly dashboards using Data Studio and Looker to cater to stakeholders.
- Construct data models in LookML, empowering stakeholders for independent BI exploration.
- Establish expandable data pipelines and data lake structure using a Continuous Integration/Continuous Deployment (CI/CD) approach.
- Craft BigQuery data pipelines in DBT to unveil fresh metrics and insights within the reporting layer.
- Assist in addressing spontaneous or pressing inquiries from diverse division stakeholders through the composition of intricate BigQuery SQL queries.
- Used Airflow to schedule tasks that pull data from databases, files and load it into a centralized data storage system.
- Set up alerts and monitoring Airflow tasks to be notified of pipeline failures or delays, allowing to address issues promptly.
- Created logical data models using dbt that provide a consistent and structured view of the data and also applied techniques to large datasets like Partitioning the Table, Implementing the Incremental Loads,
- Implemented tests case within dbt to validate the accuracy of transformations and data models, ensuring that there is no duplicity occurring.

Efficiently responded to ad hoc requests from multiple stakeholders, conducting in-depth analysis of complex data sets using advanced statistical techniques, hypothesis testing, and machine learning algorithms to identify trends, patterns, and insights that informed business strategies.
Performed Data Analysis and Data Profiling using complex sql.
Designed, developed, and implemented complex business rules and solutions that addressed client's needs and provided valuable insights utilizing their data.
Developed and maintained interactive, user-friendly dashboards and reports using Looker and Data Studio, delivering presentations that effectively communicated actionable, data-driven insights to both technical and non-technical audiences.
Used LookML to model and define data relationships for more complex analysis.
Collaborated with cross-functional teams including product managers, product teams, and other business units to gather data requirements, provide analytical support, and translate business questions into data analysis tasks to work towards actionable insights.
Also worked on statistical analysis like Descriptive, diagnostic, predictive, prescriptive, and a/b testing analysis.
Developed predictive models using machine learning techniques to forecast customer behavior, churn rates, or other key metrics and evaluated model performance to improve accuracy.
Slashed customer churn rate by 40% by applying business risk models which increased revenue by 8%.
With advanced analytics, I analyzed and visualized customers spending patterns (Spend Analytics), management and product development teams were able to introduce new products based on insights drawn, this has an incremental revenue of 5%.
Developed a snapshot report that helps determine the propensity for customers to renew subscriptions upon expiry, the deployment of this model into production with the accompanying CVM intervention helps increase the renewal rate by 27%.
Created logical data models using dbt that provided a consistent and structured view of the data and applied techniques to large datasets like partitioning the table and implementing incremental loads for improved performance.
Interacted with external clients to understand business requirements and objectives and provided comprehensive solutions that addressed their needs.

Involved in Planning Defining and Designing data based on business requirements and provided documentation.
Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
Transformations of requirements into data structures, which can be used to efficiently store, manipulate, and retrieve information.
Collaborate with data modelers, and ETL developers in creating the Data Functional Design documents.
Installed and configured Enterprise gateway and Personal gateway in POWER BI service.
Created Workspace and content packs for we users to view the developed reports.
Scheduled Automatic refresh and scheduling refresh in POWER BI service.
Wrote calculated columns and measures queries in POWER BI desktop to show good data analysis techniques. Created Reports using POWER BI.
Automated POWER Query refresh using POWER shell script and Windows task scheduler.
Used various sources to pull data into POWER BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
Ensure that models conform to established best practices including normalization rules and accommodate change in a cost-effective and timely manner.
Used SSIS and T- SQL stored procedures to transfer data from OLTP databases to the staging area and finally transfer into the data warehouse.
Developed and Deployed data transfer packages to the appropriate destinations using SSIS.
Experience in creating jobs, Alerts, SQL Mail Agent, and scheduling SSIS packages.
Created SQL server configurations for SSIS packages.
Responsible for creating reports based on the requirements using SSRS 2008-R2.
Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
Designed and created Report templates, bar graphs, and pie charts based on the financial data.
Involved in SQL performance tuning.
Data modeling as per customer requirements using the Erwin tool.
Developed, implemented, and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes, and Views.
Developed and implemented procedures to ensure the quality, usability, and accuracy of reports.

Responsible for developing insights, reports, and dashboards on the customer service provided across different business units.
Developed Enterprise reporting Suites /Ad-hoc reports for higher management to Identify, analyze, and interpret trends or patterns which help to gauge the performance of their underlying business units.
Provided Actionable insights for senior executives by developing Revenue, and price model Dashboards which aided in improving decision-making time by 50%.
Developed Reports/Dashboards for business on Purchase orders, Invoice order processing, and customer invoicing, giving them 40% faster resolution of any downstream gaps to minimize penalties.
Developed dashboards and control reports that illustrate key trends in assigned verticals and cater to the specific needs of their line of business.
Analyzed the historical documentation, supporting documentation, screen prints, and e-mail conversations, presented the business and wrote the business requirements document, and got it electronically signed off by the stakeholder.
Wrote the test cases and technical requirements and got them electronically signed off.
End- to End responsibility on Design, Build, maintain Dashboards in SSRS.
Providing business insights to stakeholders and internal teams like Finance, Product, and Marketing.

Involved in Planning Defining and Designing data based on business requirements and provided documentation.
Created Ad-hoc reports using SQL server reporting services(SSRS).
Developed and Deployed data transfer packages to the appropriate destinations using SSIS.
Gathered report requirements and determined the best solution to provide the results in either a reporting services report or an Excel pivot table.
Designed and created Report templates, bar graphs, and pie charts based on the financial data.
Created Reports from Data Warehouse using SSRS i.e. Drill down, Drill Through, Sub reports, Charts, Tables.
Experience in creating jobs, Alerts, SQL Mail Agent, and scheduling SSIS packages.
Responsible for creating reports based on the requirements using SSRS 2008-R2.
Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
Developed, implemented, and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes, and Views.
Developed and implemented procedures to ensure the quality, usability and accuracy of reports.