Naresh Manohar Sakare

INFIHIVE Technologies

Mar 2025 - Jun 2025 • 0.3 yrs

Client: Direct ChassisLink, Inc. (DCLI), USA Environment: SQL Server, Query Optimization, Performance Tuning Optimized SQL reporting solutions supporting 200,000+ leased chassis and high-volume logistics transactions across North America. Reduced report execution time by 75%, from 20+ minutes to under 5 minutes, through SQL tuning, database refactoring and execution plan optimization. Refactored 30+ complex SQL queries by replacing nested subqueries with optimized JOINs and efficient filtering techniques. Applied SQL Server query hints including FORCESEEK, RECOMPILE and OPTIMIZE FOR to improve execution plans and query performance. Partitioned 7 high-volume production tables using transaction date and region-based strategies, significantly improving query scalability and I/O performance. Redesigned materialized and reporting views, minimizing redundant computations and improving indexing efficiency . Performed execution plan analysis to identify bottlenecks, missing indexes and inefficient joins, improving reporting responsiveness across business users.

Nityo Infotech

May 2024 - Jul 2024 • 0.2 yrs

Client: State Street Domain: Banking & Financial Services Developed and managed 25+ Snowflake database objects, including tables, stages, sequences, file formats and views. Built ETL pipelines to ingest trade transactions, fund, broker and client data from A WS S3 into Snowflake staging and reporting layers. Performed ETL transformations, business validations and data integration to support downstream financial reporting. Developed 20+ SnowSQL scripts to automate business reporting and improve data accessibility for reporting teams. Created optimized reporting views, enabling faster access to investment servicing and fund accounting data. Collaborated with report

Hexaware Technologies

May 2021 - Jun 2023 • 2.1 yrs

Client: Northern Trust Domain: Financial Services Developed and maintained 50+ Snowflake database objects, including tables, views, sequences, file formats and internal/external stages. Designed ETL pipelines for LDI, CFS and RTT applications, processing portfolio, equity and financial transaction data within Snowflake. Developed 30+ SnowSQL scripts supporting business reporting and analytical workloads. Built stage, integration and presentation layer data models for enterprise reporting solutions. Automated bulk data ingestion from A WS S3 using Snowflake COPY commands and partitioned large source files to improve loading efficiency . Implemented 10+ Snowpipe-based real-time ingestion pipelines with automated A WS SQS event notifications and policy configuration. Performed business validations and data transformations using Python (Pandas) to improve data quality and consistency . Leveraged Snowflake capabilities including Time Travel, Zero-Copy Cloning and Secure Data Sharing to support development, testing and production environments. Contributed to cloud data platform modernization by improving ingestion automation, reporting readiness and operational efficiency

Tech Mahindra

Nov 2018 - Nov 2019 • 1 yrs

Developed and enhanced 25+ database objects, including stored procedures, materialized views and tables, to support product enhancements and change requests. Built ETL pipelines to ingest quotation, order and site data from WallGarden into Snowflake for supply chain processing. Implemented business rules converting approved quotations into customer orders, improving order processing automation. Developed aggregation logic for order quantities, installed items and pricing to generate accurate line- item and order-level valuations. Improved query performance by 60–70% through clustering keys, materialized views and Snowflake warehouse optimization. Implemented 10+ Streams for incremental data capture and change tracking. Migrated enterprise data from Oracle 12c to Snowflake, ensuring data integrity and minimal downtime. Created reporting views supporting business intelligence and operational reporting

J Connect Infotech

Jul 2017 - Dec 2017 • 0.4 yrs

Domain: Finance Designed technical specifications for ESAP , XSAP (Europe) and India transaction processing modules. Developed external tables and staging architecture for automated financial data ingestion and cleansing. Created UNIX shell scripts to automate transaction file processing and scheduled production jobs. Standardized deployment, validation and production release checklists, improving deployment consistency . Supported QA and production releases while ensuring compliance with development standards.

Accenture

Aug 2010 - Apr 2017 • 6.7 yrs

Domains: Telecom | Retail | Products | Life Sciences Developed and maintained 150+ database objects, including PL/SQL packages, procedures, functions, views, indexes and database links. Delivered ETL enhancements, production fixes and change requests across multiple enterprise applications. Reduced SQL execution time by 80%, improving query performance from 10–15 minutes to 2–3 minutes through SQL optimization and indexing. Designed SQL *Loader control files and automated bulk data loading for text and CSV files. Performed Oracle database performance analysis using A WR and ADDM reports to resolve production bottlenecks. Supported enterprise production environments by resolving 300+ production incidents, performing root cause analysis and deploying permanent fixes. Created migration scripts for Oracle data cleansing and SQL Server to Oracle migration activities. Designed technical architecture, unit test plans and deployment documentation for multiple application releases. Developed and maintained Technical Design Documents, Functional Specifications, Process Documents, RTMs and Audit documentation. Collaborated with onsite teams across requirement analysis, development, testing, deployment and knowledge transfer .

Future Focus Infotech Pvt. Ltd

Jun 2010 - Jul 2010 • 0.1 yrs

Developed SQL reports supporting daily and weekly operational reporting. Automated production SQL scripts for address validation and customer data synchronization. Supported Oracle production databases by maintaining customer and residential address consistency . Assisted production operations and database administration activities for telecom applications

Melstar Technologies

Sep 2009 - Feb 2010 • 0.4 yrs

Domain: Telecom | CRM Developed PL/SQL procedures, packages, functions and tables for new product enhancements. Automated batch processing using SQL *Loader and UNIX shell scripting. Improved SQL execution performance by 80%, reducing runtime from 5 minutes to under 1 minute. Supported production batch monitoring and coordinated with DBAs for CRM application support. Resolved critical production issues involving database links, snapshot errors and batch failures. Prepared module-level technical documentation and performed peer code reviews to improve development quality .

Wipro

Jun 2006 - Aug 2009 • 3.2 yrs

Domains: Telecom | Retail | Media | Products Developed 100+ PL/SQL procedures, functions, views and materialized views supporting enterprise applications. Designed logical and physical data models using ERwin for legacy application modernization. Improved SQL performance by 80%, reducing execution time from 12 minutes to approximately 2 minutes. Participated in the complete SDLC, including requirements analysis, development, testing, deployment and production support. Resolved production issues related to deadlocks, batch failures and database locking. Automated BOLT transaction reporting and generated operational dashboards for business stakeholders. Managed SQL *Loader-based bulk data imports for SONY-BMG media sales processing. Prepared technical documentation, process documentation and knowledge transfer materials. Conducted peer code reviews to ensure coding standards and application quality .

Government of Karnataka

Oct 2001 - Jul 2006 • 4.8 yrs

Domain: Government | Water Resources Developed statewide MIS applications supporting technical, civil and social infrastructure monitoring. Managed and coordinated a team of 10 programmers across multiple district project units. Consolidated and validated project data from district offices for centralized MIS reporting. Generated management reports supporting project monitoring and decision making. Coordinated infrastructure setup, Oracle installation and application deployment across multiple district offices. Conducted stakeholder review meetings, user training and knowledge transfer sessions. Supported procurement planning by defining hardware and software infrastructure requirements.

Hindustan Latex Family Planning Promotion Trust (HLFPPT)

Feb 1999 - Jul 2001 • 2.4 yrs

Domain: Healthcare | Manufacturing Developed and enhanced Oracle-based Integrated Management Information System (IMIS) modules covering Production Planning, Manufacturing, Stores, Finance, Marketing and Sales. Developed PL/SQL procedures, functions, Oracle Forms and Pro*C programs supporting business operations. Modified operational and management reports to meet evolving business requirements. Conducted system testing, user acceptance support and end-user training across multiple business departments. Collaborated with business users to deliver application enhancements and improve operational efficiency .