Saakshit Shetty

Part of Data Foundations team for Supply Chain.
Performed system and requirement analysis, writing technical design documents and test plans.
Responsible for code changes, research and develop solutions for challenging new or unknown issues.
Working on data ingestion request from an API server and SFTP location.

Part of Data Foundations team for Supply Chain.
· Performed system and requirement analysis, writing technical design documents and test plans.
· Responsible for code changes, research and develop solutions for challenging new or unknown issues.
· Working on data ingestion request from an API server and SFTP location.

Part of Data Infrastructure team for Youtube Business Intelligence(Google).
Creating & monitoring workflows which chains together multiple SQL scripts and other types of operation into ETL-styled pipelines.
Worked on data migration project to replace existing data with close to real-time data from an API server.
Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
Developed and maintained tables, queries and views to support business needs and reporting requirements.
Created comparison query using SQL/Python in order to compare data in PROD vs DEV environments for pre-production release.
Involved in troubleshooting SQL queries, stored procedures, performance issues and workflow in development and production environment.
Created complex ad-hoc reports, sub-reports, linked reports, charts, drill through/drilldown reports and created large number of report models for users to create their own reports.
Worked on a Governance project for the internal team which improved client relationship by creating actionable, objective and timely checkpoints for maintaining project health.

Part of Data Intelligence team for Pitchbook Data.
Creating & analyzing KPI dashboards, monthly/quarterly/weekly reports for the senior management and dataset leads using Power BI to visualize important trends and goals for decision making.
Proficient in SQL reporting with the ability to create SQL views and write SQL queries highly recommended.
Querying large dataset from multiple sources using SQL and developing automated reporting in Power BI as per business requirement.
Migrated existing self-service Tableau reports and ad-hoc reports to Power BI.
Provide weekly demand forecasting, resource availability, monthly capacity planning for multiple individual projects to TLs and managers.
Documenting Power BI reports and training TLs to enable self-service for existing reports.
Queried and analyzed large volumes of data using SQL & Python and helped TLs to define intelligence needs, structuring subsequent information gathering efforts accordingly.
Responded to specific BI & ad-hoc requests from managers/TLs, creating dataflows & datasets in Power BI with requested information in easily understandable formats.
Developed customed calculated measures using DAX in Power BI to satisfy business needs.
Optimized system and platform performance capabilities in most efficient, practical way possible.
Creating a datamart in Alteryx Designer from multiple sources for analytical insights.

Part of the FTTx(Fiber to the Home and Enterprise) Operational Center team for Jio Gigafiber Rollout Program.
Conceptualized various analytical reports as a part of the project control team to monitor the progress of various KPIs.
Consequently, dynamic reporting through Tableau dashboards increased field productivity.
Co-ordinated with JIO analytics team to create data sources in Tableau Server for project monitoring.
Created action filters, parameters, sets and groups for preparing dashboards and worksheets in Tableau.
Data blending implemented on databases and generated interactive dashboards in Tableau.
Created Many TDE (Tableau Data Extract) for various Projects and Scheduled Refreshed on Tableau Server as per the Business needs.
Automated Daily, Weekly and Monthly report using Tableau Desktop 2019.1.3 and publish in Tableau Server to fulfill and overcome the gap against the plan.
Manipulation of data, running pivot tables, V-lookups and formulas in MS Excel and creating reports that manager consume.
Automation of reports in MS Excel which reduced processing time, response time and risk of error.
Data extraction as per management requirements from multiple production database using SQL queries in Oracle SQL Developer.
Manipulation and summarizing large volumes of structured and unstructured data using R programming for major business initiatives.
Training users to access Tableau dashboards and create reports in server using available data sources.