Saakshit Shetty

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

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.

<p>Part of Data Infrastructure team for Youtube Business Intelligence(Google).<br>
Creating & monitoring workflows which chains together multiple SQL scripts and other types of operation into ETL-styled pipelines.<br>
Worked on data migration project to replace existing data with close to real-time data from an API server.<br>
Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.<br>
Developed and maintained tables, queries and views to support business needs and reporting requirements.<br>
Created comparison query using SQL/Python in order to compare data in PROD vs DEV environments for pre-production release.<br>
Involved in troubleshooting SQL queries, stored procedures, performance issues and workflow in development and production environment.<br>
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.<br>
Worked on a Governance project for the internal team which improved client relationship by creating actionable, objective and timely checkpoints for maintaining project health.</p>

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

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