Navdeep Goyal

NAVDEEP GOYAL Technical Data Manager |Data Engineering | -- Data Warehousing | BI & Analytics | Data Integration & Modernization | Snowflake | AWS Cloud & Scrum Practitioner JOB OBJECTIVE Seeking a Technical data manger role in data engineering or data platform management where I can leverage my 19+ years of IT experience in project management, data warehousing, business intelligence, analytics, and cloud-based data modernization. Aiming to drive scalable data solutions using tools like Snowflake, AWS Cloud, and modern data integration practices to support strategic business goals. CORE COMPETENCIES Project Delivery Management PROFILE SUMMARY       Stakeholder Management Strategic Planning & Execution Cloud Data warehousing Data Engineering Data Visualization AWS Cloud Computing Agile Scrum Framework Scope Management Risk & Issue Management EDUCATION   Master of Computer Applications (MCA) from Jiwaji University, Gwalior, Madhya Pradesh in 2001 Bachelor of Science (Physics, Chemistry & Mathematics) from Barkatullah University, Bhopal Madhya Pradesh in 1996 CERTIFICATION & COURSES     SnowPro Core Certified [Certificate] AWS Cloud Practitioner Essentials [Certificate] Certified Scrum Master (CSM) SAFe Agilist [Udemy] Navdeep Goyal     Effectively led and managed data projects with a strong focus on cost control and budgeting—allocated budgets across sprints, monitored cost variances, and implemented corrective actions to ensure delivery within budget Experienced in JIRA administration, with a proven track record of managing end-toend administrative tasks including project configuration, user and role management, workflow customization, and schemes. Proficient in driving and managing Data Engineering/Data wareshousing IT Projects including testing & verification of configuration and baseline data, integration with provisioning development, deployment, testing and production support. Possess advanced expertise in cloud data warehousing and proficiently drive data with ETL Pipelines design to build Snowflake warehouse and Oracle, SQL Server onpromises databases Demonstrated extensive experience in successfully managing and delivering IT projects, utilizing Agile (Scrum)/Waterfall SDLC processes, and fostering strong customer relationships across Life Sciences, Telecom and Banking domains. Strong understanding of SAFe principles, gained through formal online training; understanding of Agile Release Train, PI Planning, and Lean-Agile practices in scaled enterprise environments. Exhibited exceptional leadership and collaboration abilities, prioritizing customer satisfaction and ensuring successful project delivery Experienced in contributing actively throughout across SDLC development phases by tracking technical issues and solving problems Managed mitigation of risk factors through careful analysis, spearheaded change effectively in rapidly evolving global business environments Experienced in managing production support team for data projects. Skilled in utilizing JIRA Service Management tool to effectively track and resolve support issues, ensuring high system availability and operational excellence. WORK EXPERIENCE Apr 2022 - Present: Sr. Manager – Project/Program Management, Altimetrik, Pune Jul 2010 - Jan 2020: Associate Manager, Accenture, Navi Mumbai Jun 2005 - Jun 2010: Technical/Sr. Technical Associate, Tech Mahindra, Pune Jun 2003 - Jun 2005: Software Engineer, Nucleus, Noida PROJECTS Project Period Role Team Size Platform ALM tool Methodology Domain Organization : SSOT and Advanced Data Analytics : Jan’23 To Till Date : Technical Data Manager : 24 : Snowflake, AWS S3, Power BI, Python, Bit-bucket : JIRA/Confluence : Agile using Scrum Framework : Life Sciences : Altimetrik India Pvt. Ltd., Pune Project Description: This project aims to create Single Source Of Truth (SSOT) cloud data management platform by integrating master and transactional data sources leading to consistent cloud data platform and data driven decision making followed by providing data visualization capabilities using Power BI tool to build dashboards comprising Financial and Commercial KPIs to perform advanced data analytics to improve business decision making skills. TECHNICAL SKILLS **Hands-on Experience**       Methodologies: Agile(Scrum, Kanban), Waterfall ALM Tool: JIRA & Confluence Cloud DWH: Snowflake (SnowSQL, Warehouse configuration, data loading) RDBMS: Oracle, SQL server Programming Lanuages: SQL, PL/SQL ETL Tool: Informatica Power Center **Project Management Exposure**          Cloud DWH: Snowflake Data Modeling: Dimensional (Conceptual, Logical, Physical) Data Visualization: Power BI Cloud Platform: AWS (ECS, Fargate, S3, RDS) Big Data Technologies: Spark, Pyspark Framework DevOps &Containerization: Docker Programming Lanuages: Python (data validation & loading) ETL Tool: Databricks using Pyspark SCM Tool: Bit-bucket **Strong Conceptual Understanding**     Scaled Agile Framworks (SAFe) Data modeling (Conceptual, Logical and Physical) Dimensional Modeling(Dimensions, Facts and Start/Snowflake Schema) Cloud Platform: AWS(IAM, Glue, Lambda, EC2, Redshift, RDS etc.) Project Period Role Team Size Platform ALM tool Methodology Domain Organization : Analytical And Resource Visualization (ARV) : May’22 To Dec’22 : Technical Project Manager : 12 : AWS ECS/Fargete, Databricks (Pyspark), AWS RDS (SQL Server) : JIRA/Confluence : Agile using Scrum Framework : Life Sciences : Altimetrik India Pvt. Ltd., Pune Project Description: The objective of this project is to enhance the client’s resource management platform capabilities by migrating their on-promises Java based web applications as containerized application using AWS ECS and few existing Talend ETL jobs which have been reaplced with new ETL pipelines created in Databrics using Pyspark and AWS RDS used as database over AWS cloud. Project Period Role Team Size Platform ALM tool Methodology Domain Organization : Aggregate Spend Repository (ASR) : Jan’18 To Jan’20 : Technical Project Manager : 14 : Oracle EBS, SAP BO, ETL-Informatica Power Center, SharePoint, : JIRA/Confluence : Agile using Scrum Framework : Life Sciences : Accenture Solutions Pvt. Ltd., Navi Mumbai Project Description: The objective of this project is to enhance the functionality of ASR system which is used by client for collection, aggregation, and reporting of any financial expenses engaged with Healthcare Professionals and Organizations. This ASR system works to report any financial transactions between physician or hostpitals with applicable manifacturers that participate any federal healthcare programs. Project Period Role Team Size Platform ALM tool Methodology Domain Organization : Lash Fusion Solutions System : Jan’16 To Dec’17 : Technical Associate Manager : 15 : Oracle DB, Informatica Power Center (ETL), MDM : JIRA/Confluence : Agile using Scrum Framework : Life Sciences : Accenture Solutions Pvt. Ltd., Navi Mumbai Project Description: The objective of this project to create Data Management Platform (DMP) to support batch data processing, long term data storage, analysis and operational reporting. Data management platform is a multi-tenant database which consists of raw layer and standard data wher Raw layer is primarily used to staged the data and Standard layer will be one of the source for Operational and analytical reporting. Project Period Role Team Size Platform Domain Organization : Application Development & Maintenance System (ADMS) : Jan’13 To Dec’15 : Application development & Support Manager : 25 : Oracle DB, SQL Server, SQL, PL/SQL, Informatica Power Center (IPC) : Life Sciences : Accenture Solutions Pvt. Ltd., Navi Mumbai Project Description: The aim of this project is to provide application development and support coverage for multiple applications based on different technologies for life science client which is one of the leading manufacturer company to produce medical devices in US. Project Period Role Team Size Platform Domain Organization : XL Enterprise Management Information System (XLGS EMI) : Jul’10 To Dec’12 : ETL Tech Lead : 12 : Informatica Power Center (IPC), SQL, PL/SQL, Oracle DB : Life Sciences : Accenture Solutions Pvt. Ltd., Navi Mumbai Project Description: This project introduces EMI system to support management reporting, risk management and business analytics at the enterprise level for that will identify the data elements required for management reporting and analytics, integrate the existing data warehouses. Project Period Role Team Size Platform Domain Organization : SPDR System : Sep’06 To Jun’10 : ETL tech lead : 10 : Informatica Power Center (IPC), Oracle DB, SQL, PL/SQL : Telecom : Tech Mahindra Limited, Pune Project Description: SPDR application extracts the customer and revenue information from EDW and sends to RUSS (stands for Revenue Usage Sourcing System) system. RUSS sends it to SAART (Sales Account Assignment and Results tracking) system and finally SAART system sends data to ACES system for compensation calculations. I joined this project as test lead. Project Period Role Team Size Platform Domain Organization : Goldmine Support System : Jul’05 To Aug’06 : Sr. Software Developer : 20 : Unix, Oracle Database : Telecom : Tech Mahindra Limited, Pune Project Description: This project aims to provide production support services that comprises of 4 different inter dependent subsystems like LOAD [Load Organized Derive Engine providing an integrated view],ONCE [Online Network Characteristics Environment],AMIS [Access Network Management Information System] and SEAM [Structured Environment Array of Marts] Project Period Role Team Size Platform Domain Organization : Finance Against Securities (FAS) : Jun’03 To Jun’05 : Software Engineer :6 : Developer 2k, Oracle DB, SQL, PL/SQL, CVS : Banking : Nucleus Software Exports Limited, Noid [Product Based company] Project Description: This project introduces the business needs of providing credit limit to at individual customer or corporate level against pledging of financial securities. Nucleus is basically product-based company and FAS is one of the most leading product of Nucleus company that had been sold to other banks as domestic clients for Nucleus.