Arka Roy

About Arka Roy

Experience SummaryAn accomplished IT and Data Engineering leader with 18 years of total IT experience and 6-year specialization in Snowflake Cloud Data Platform architecture and migration. Specializing in the design, architecture, and management of Enterprise Data Warehouse and Cloud Data Platform initiatives. Proven track record in leading complex data migrations, driving digital transformation, and implementing data-driven decision-making across global organizations. Expertise in Snowflake, AWS, Azure, and legacy databases (DB2, IMSDB). Passionate about aligning data initiatives with business goals, fostering innovation in AI/ML, and enabling data-driven decision-making.Key Achievements:Team Leadership- Leading cross functional team of data engineers, BI engineers, architects and data analysts to deliver end-to-end data solutions that align with business objectives, ensuring the enterprise data strategy supports scalability, decision-making, and overall business growth.Cost Governance- Implemented custom Snowflake metadata monitors, resource monitors and standardized snowflake standards. Achieved $90k /year savings by right sizing warehouses, query optimization, redefining time travel on Table importance.Data Governance- Drove data privacy compliance by integrating OneTrust with Snowflake, ensuring CPRA compliance and implementing sensitive data masking policies, protecting customer data across systemsAdvanced Analytics- Integrated Google Analytics and Adobe analytics ecommerce data with snowflake to provide visibility to Business and work with inhouse BI reports /metrices previously built on clickstream.Operations- Introduced checkpoints and automated notifications for SLA streams. Focus more on permanent fix and work arounds mainly for critical path jobs using Snowflake offerings like time travel, account usage view, scaling up warehouse.Team management - Recruitment and onboarding processes. Monthly/Quarterly presentation to higher management and client. Value creation initiatives. Provide organization monthly metrices like Agile metrices, Team capacity utilization, customer feedbacks.

Experience

1. Senior Technical Manager (Specialist)

   HCLTech

   Jan 2024 — Present · Pune, IN

   Overview: Global Data Warehouse• Partnered with senior leadership to align data engineering initiatives with business objectives, facilitating data-driven decision-making across the organization.• Directed the redesign and migration of the Known Error Database (KEDB) to Snowflake, enhancing team efficiency and enabling robust operations metrices for monthly reviews.• Spearheaded data governance initiatives, ensuring data quality, consistency, and security while aligning with regulatory and business needs to drive strategic decision-making across the organization.• Collaborated with multiple business leaders to define and implement Standard Operating Procedures (SOPs) for both regular and high-priority data objects like legal data requests. It resulted in reduction in turnaround time and helping businesses.• Initiated and led a proof-of-concept for DBT migration, setting the foundation for future automation to replace legacy DataStage and Mainframe scheduling, targeting significant increases in data pipeline automation, governance, and developer productivity.• Managing a multiyear project focused on Digital Modernization, replacing commerce and OMS platforms with modern, cloud-first SaaS solutions, ensuring Business Continuity and Future proofing for ETL and reporting enhancements for new systems. Introduced Dynamic table to automate ETL pipeline as part of this project to speedup delivery.• AI Adoption- To meet organization goals started with PA repository for GDW team. Driving Agentic AI adoption through POCs and usage in new projects.• Working with Business client on POC to use Snowflake offerings like streamlit for their daily needs.

Education

• Dr.B.C.Roy Engineering College Durgapur

  Bachelor's in Technology, Electrical Enginnering

  2003 — 2007

• Bidhan chandra institution ,Durgapur

  Higher Secondary Education, science

  2001 — 2003

• DAV Model School Durgapur

  SSC, secondary education

  1991 — 2001

Skills

• Cobol
• Teradata
• Ibm Db2
• Requirements Analysis
• Job Control Language (Jcl)
• Imsdb