Deepak M

• Experienced in Snowflake object development, including tables, views, stages, functions, streams, pipes, and stored procedures.
• Designed and maintained scalable data models and schema structures for efficient data solutions.
• Implemented task trees to automate incremental loads, backups, and auditing using Streams, Time Travel, and Fail-safe for recovery and compliance.
• Developed and optimized ETL/ELT pipelines, integrating data from Oracle, AWS S3, and other sources.
• Created dynamic, metadata-driven stored procedures and CDC frameworks using Streams for real-time data processing with minimal latency.

• Migrated data from the Oracle Database to Snowflake using flat files as part of the application migration process.
• Utilized Snowflake for data transformation and processing, ensuring compatibility with both structured and unstructured data formats.
  Handled data cleansing, validation, and enrichment as part of the ETL workflow.
• Developed Snowflake objects such as warehouses, schemas, databases, tables, views, pipes, stages, and scaling policies.
  Configured data loading using COPY INTO commands, with error handling, file formats, and all applicable copy options.
• Optimized ETL processes and SQL queries to improve performance and reduce processing time.
• Developed stored procedures and user-defined functions to enhance data processing capabilities.
• Implemented Snowpipe for seamless data ingestion from AWS S3 to Snowflake, ensuring continuous data integration between Oracle and Snowflake.

• Implemented customization features by developing Oracle packages, collections, and stored procedures.
• Designed and optimized PL/SQL packages, functions, triggers, and exception handling for efficient data retrieval and migration.
• Improved performance using indexing, partitioning, tracing, and query optimization techniques.
• Translated business requirements into analytical SQL queries, utilizing joins, operators, and advanced functions.
• Documented database configurations, best practices, and compliance guidelines to ensure maintainability, and knowledge sharing.
• Provided technical support and strategic guidance on database-related issues, fostering effective collaboration with team members and stakeholders.

Worked on mobile handset testing and qualification projects to ensure devices meet industry standards for functionality, performance, and network compatibility. Involved in hardware and software validation, interoperability testing, and compliance verification to deliver an optimal user experience before deployment.

Key Responsibilities:

• Prepared functional test cases covering all possible scenarios, and executed end-to-end device testing.
• Reported and tracked defects using Mzilla, Ufzilla, and Bugzilla.
• Conducted field testing to validate network performance and call scenarios.
• Tested circuit-switched calls and network interoperability across Intel, Spreadtrum, and MediaTek chipsets.

Testing, Provisioning, monitoring operations of SDH equipment's
* Executing Test cases by provisioning circuits using VCG for Giga bit Ethernet traffic Hands on
experience in Signal
* Generators, OMNI BER, ANT-5, E1 Analyzer and Ethernet Traffic analyzer equipment
* Hands on Experience on JTAG, BDM, BDI, PICKIT3, Lattice software
* Testing of SDH/ Ethernet Products up to STM64 capacity
* Responsible for testing and Debugging of TJ1100-CPR4, TJ100CPE, MC4, MC4L, TJ1400, , TJ1260,
TJ1270 products of Tejas Networks.