Saket Kumar Email & Phone Number

Hackensack, Nj, Us

Hackensack, Nj, Us

San Jose, Ca, Us

Engineered complex data solution for large volumes of information covering relational, dimensional datasetImplemented Data transformation operations in a high-volume data environment, reducing data load time by 25% in Snowflake and DBTCreated 50+ comprehensive snowflake views/tables for Data Science and MLOPs teamsDeveloped 10+ user-defined functions and procedures in Snowflake using PythonUtilized Snowflake's Snowpipe feature to build data pipeline for continuously ingesting data from AWSAutomated renew sales opportunity report by creating 10+ backend APIs for sales audit team, reducing their effort by 60%Performance Analysis of complex SQL queries

Mumbai, Maharashtra, In

Mumbai, Maharashtra, In

Mumbai, Maharashtra, In

Mumbai, Maharashtra, In

Database tuning• Offshore DB Lead and Escalation Manager for EDPS Team• Handle critical activities in direct coordination with the Client• Develop reusable components for improving the performance and ease the usability of the Application• Reviewed data models and data flow diagrams from the Application Team• Ensure the information architecture and visual design reflects the customer's needs.• Extensive experience in fine-tuning code for Query optimization and tuning.Advised multiple development teams for designing applications for optimal performance in Multi-Terabyte and high load environment.• Strong ability to build Analytical and complex queries in SQL.• Proficient in using bulk operations (bulk collect, forall etc) and oracle collections such as PL/SQL records, associative arrays, nested tables and varays in PL/SQL.• Very good hands on experience with TKPROF, Raw Trace, ASH, AWR, OEM.• Experience in getting better execution plan via using appropriate hint such as use_nl, use_hash, index , full, driving_site etc.• Experience in performing range, list, hash and composite partitioning to improve concurrency and ease of administration.• Mentor & guide the team wherever required in terms of technical & functional issues and queries• Conduct Capacity Analysis on Production Databases with respect to Load, new Infra, DB Parameter• Work in sync with DBA, Application Team, Oracle for SRs raised• Tune SQL queries with objective as: reduce LIOs and Execution Time• DB Monitoring of Production and Release Databases• Monitor CPU, Load, Memory Utilization for Production DB• Identify Sessions where CPU has spiked and trace queries• Propose new strategies for performance tuning and process• Data Engineer in Google cloud platform.• Designed initial level of predictive analysts model(POC) using PythonResult oriented and solution focused combined with problem solving and decision making abilities

Pune, Maharashtra, In

PROJECTS UNDERTAKEN : [Leading automobile industry] 1) Project: PTLC - PandA Tech Life Cycle Duration: July 2013 – September 2013 Expertise: Business Analyst ,Oracle Developer. Languages: SQL ,PL/SQL , ProC, VBScript. RDBMS: Oracle 11g GUI: Forms 11g, Reports 11g. Role: Business Analyst, UAT expert, Project developer.My Contribution:I worked for the launch of the project in Middle east and China-7 instances. Total of 8 instances out of 20. My role was to cordinate with client with the UAT of various functionality of the project. I was supposed to introduce/develop any new development as per requirement. I travelled to Shanghai, China for the launch period as China is the biggest entity of Ford Asia Pacific and Africa region.Launch in Middle East and China was done successfully and was duly appreciated by business owners and individual countries as well.2) Project: PandA Application Managemenet. Duration: May 2010 – Till Date Role: Team Lead. Expertise: Business Analyst ,Application management APA. Languages: SQL ,PL/SQL , ProC, VBScript. RDBMS: Oracle 11g GUI: Forms 11g, Reports 11g. Role: Sr. Software Engineer – Support and Bug Analyst, Team lead, Business Analyst

Bachelor'S Degree, Computer Engineering

Education record