Parikshith Gari Email & Phone Number

West Sacramento, California, United States

DCI Donor Services is a federally designated non-profit organization responsible for the evaluation and procurement of deceased donors’ organs and tissue recovery for transplantation and research.• Led the development of Data Warehouse (DW) infrastructure for TDS, SDS, and NMDS, including Organ, Tissue, and Eye/Tissue Banks. Managed a team to create detailed data models, establishing a foundation for advanced analytics and reporting.• Defined KPIs during data modeling to enhance efficiency and business performance. Enabled data-driven decision-making and process improvements through strategic insights.• Aligned data and reporting across business units, using DW insights to support growth and operational improvements. Synthesized complex data sets and led cross-functional teams to generate actionable insights.• Managed SQL DBs, ETL processes, and Power BI environments both On-Prem and in the cloud. Ensured seamless data management and analytics capabilities, leading a team of developers to support business decisions.• Increased Organ Donors by 15-25% and Organ Transplants by approximately 15% year-over-year since 2019 by translating data insights into significant improvements.• Engineered scalable BI solutions to handle growing data volumes and evolving requirements. Applied project management skills to ensure solutions were flexible and responsive to changing needs.• Optimized database schemas and ETL processes, maintaining high data quality and integration from diverse sources. Implemented effective data governance through metadata management and access controls.• Enhanced BI query performance and system efficiency. Collaborated with analysts and users for comprehensive documentation and support, demonstrating strong team management and leadership.• Streamlined workflows with Power Apps and evaluated visual analytics tools like Tableau to improve data representation and reporting.

West Sacramento, California, United States

This role's responsibilities overlap with my current role.

San Ramon Ca

Donor Network West is a federally designated non-profit organization like my current organization and is also responsible for the evaluation and procurement of deceased donors’ organ and tissue recovery for transplantation and research.• Actively contributed to the workstream planning process, spanning from inception to the delivery of BI solutions, ensuring a seamless journey from technical design to testing and implementation.• Delved into business and functional requirements, skillfully translating them into robust, scalable solutions, thereby driving operational excellence and efficiency.• Fostered close collaboration with BI Analysts throughout the implementation phase, offering timely support and maintaining transparent communication with key stakeholders.• Implemented cutting-edge data structures, leveraging best practices in data modeling, processes, and technologies, to optimize performance and drive innovation.• Championed automation, data governance, and the adoption of best practices, laying the groundwork for sustainable growth and development.• Spearheaded the design, development, implementation, and maintenance of ETL processes, reporting mechanisms, and interactive dashboards, empowering stakeholders with actionable insights.• Achieved significant milestones including the reconstruction of the Data Warehouse to enhance query optimization and processing time, as well as orchestrating the seamless transition from SQL Server 2012 to 2016 and the adoption of Tabular Modeling.• Pioneered the rollout of Sisense and Power BI as advanced analysis and visualization tools, empowering end-users with intuitive and powerful reporting capabilities.

Boise, Idaho Area

Micron Technology, Inc. is an American global corporation based in Boise, Idaho which produces many forms of semiconductor devices. The company's subsidiaries design and produce computers, semiconductors, and related products.• Monitored Strategies, Processes, and Procedures to ensure Data Integrity, Optimized and reduced Data Redundancy, and maintained the required level of security for production and test databases.• Engaged with users to help understand their needs and find a reporting solution that will help them make effective decisions. • Query tuning based on query execution plans, statistics, and profiling.• Designed, developed, and implemented ETL process in SSIS to collect daily, weekly, and monthly information from SQL Data warehouse and create specific Data marts for different OLAP models for the Supply Chain area.• Developed various objects like schemas, tables, indexes, views, complex stored procedures, triggers, functions, and Data Marts while maintaining Referential Integrity• Improved Performance of the database by creating clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.• Crated strategies and logic for table partitioning based on the requirements of whether to archive or remove unnecessary data based on date, time & type.• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in DW.• Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, and Sub-Reports.

Dallas/Fort Worth Area

A company that manufactures and sells a range of color and black & white printers, multifunction systems, photocopiers, digital production printing presses, and related consulting services and supplies.• Played a key role in integrating Sales Force into our existing ecosystem.• Proposed & involved in implementing practices leading to a decrease in turn over time and improving efficiency.• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube, or an Excel pivot table.• Designed and developed complex Stored Procedures, and SSIS packages to perform day-to-day ETL from different sources into the Data Warehouse.• Wrote SQL Scripts for SSRS report development, Tableau reports, Dashboards, and Scorecards and handled the performance issues effectively.• Performing day-to-day DBA activities like Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, and implementation.

Shelton Ct

Easy Care/ Quality of Life Care delivers comprehensive clinical and social services directly to medically complex patients and their caregivers, including family and/or friends and family with serious types of cancers. Easy Care is a community-based hands-on, nursing, and nurse practitioner-driven intervention program that functions at all levels of the care continuum. • Convert data from Legacy system to SQL Database.• Day-to-day activities include Data Warehousing, Data Migration, Performance Tuning, Job scheduling, database security, creating/modifying SSIS packages, SSRS reports, and Stored Procedures. Data collected/handled from heterogeneous sources.

Oaks, Pa

SEI Investment is a global provider of asset management, investment processing, and investment operations solutions. SEI provides products and services to institutions, private banks, investment advisors, investment managers, and affluent individuals. My primary scope was to modify and create new reporting portfolio on Reporting Service SSRS. We generate different sorts of reports including static, ad-hoc, and drill-down and drill-through. Also participated in migration from Crystal Reports enterprise to SSRS.

Master Of Science (M.S.), Civil Engineering

Bachelor Of Technology (B.Tech.), Civil Engineering

KL University is a Deemed to be University under Acharya Nagarjuna University Served as President of ACES (Association of Civil.

High School Diploma

Elementry To Middle School