Ramneek Kaur

• As a strategic leader/architect, I drive IT value, optimize ROI, and successfully roll out data-driven enterprise and micros services within budget. Build/Design various products which helps increase digital business 40% YoY by continuous engagement with clients and reduce tech debt by 60%
• Leading 20+ direct reports; 2 horizontal teams (AWS, Snowflake) and 3 vertical data platform teams (MDM, Customer C360, CDP) supporting and building tech tools for marketing, retail business
• Built a Data Foundry of tools and accelerators to drive performance and campaigns using proprietary machine learning algorithm to assist in assessing noise, redundancy, relevancy, and diversity in data
• Expert in creating scalable, intelligent data platforms with continuous pipelines, ensuring data integrity through integrated policies and cloud-based and scalable architecture
• Orchestrate numerous digital transformations involving multiple clouds like AWS/Azure, snowflake, MDM, Salesforce, SFMC, CDP Platform (Tealium)
• Designed and developed forward-thinking systems , no-code Integrations, multi system alerts, self documenting applications detailing operation aspects, functions, capabilities and support Data governance and Integration policies
• Investigated new and emerging software applications to select and implement administrative information systems.
• Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.

• Lead Digital Twin/Thread Project that enhance Lexmark’s business capabilities by delivering high-performance, cost-effective printing/imaging solutions and services.
• Lead CCPA Compliance with the design, architecture, and development of a dynamic approach to process on-demand consumer requests for data deletion/retrieval/opt-outs, ensuring AAA’s compliance with the California Consumer Privacy Act (CCPA) and stay in sync with Data Governance databases.
• Created Cross-Platform Architectures by unified architecture that supports all platforms, both on-premise and cloud like AWS and Azure by leveraging different technologies like Databricks and Big Decision to connect real-time interoperable IoT devices.
• Empower business by enabling the manufacturing business to extend their services like MPS, CPM to partners/customers.
• Built robust Data Lake by maintaining a single source of truth with Azure Gen2 and delta lake (Databricks), equipped with BI tools like Snowflake, Databricks, Power BI for business analytics and operational queries.
• Reduced Time to Market by closing the loop between virtual models of printers/cartridges and their performance throughout their lifecycle, thereby reducing the time to market.
• Provide a comprehensive solution that includes a Business Glossary, Data Catalog, end-to-end data lineage, stringent data privacy measures, advanced Data Discovery, Metadata Management, and an enterprise-level common data model. This ensures a robust, well-documented, and secure data infrastructure with standardized data structures across the organization.
• Efficiently handle Service Now requests for Data Lake and Big Decision access, and ensuring the security of the data lake using POSIX Access Control Lists (ACLs) and Application Roles. This safeguards critical data assets and ensures timely and accurate response to data access needs.

• Manage a senior engineering team of developers, analyst and tableau/qlik developers at Harbor Freight Tools, providing enterprise reporting and self-serve data solutions to support the company’s rapid growth.
• Lead the migration of terabytes of data from Netezza to Pure-Data and designing a comprehensive data architecture including Data-Warehouse/Data-Lake/Data-Marts.
• Architect a centralized custom Security Model for various BI platforms and enhancing server architecture for 24/7 real-time reporting, along with establishing disaster recovery processes.
• Implement processes for data quality, governance, and performance, including automated procedures and notification processes for data anomalies.
• Facilitate cross-department training and knowledge sharing, enhancing business knowledge and fostering collaboration.

• Developed one of the largest and most critical reporting systems in the company, the Corporate Loan Activity Report (LAR), serving as the foundation for all reporting to Non-GSE investors and a key source for accounting data and loan inventory management.
• Designed and implemented, end-to-end automation for LAR Reporting, reducing over 80 hours of manual work monthly and improving overall data quality.
• Incorporated high levels of transparency between systems and established various audit channels for both internal and external auditors, with self-validation and exception routines to maintain data integrity.
• Created a self-deployment procedure that automatically scripts stored procedures and functions based on deployment environment, along with self-documenting, self-monitoring procedures to alert users on failures and unusual activities.
• Managed data dictionaries, data models, and metadata for various systems, collaborated with application developers in data modeling and E-R design, and performed tuning and automation of various applications using ETL packages.

Here’s a summarized version of your accomplishments:

• Successfully managed the end-to-end development of the “ORT Lite” project, a cost-effective online reporting tool for tracking business performance, while continuously improving its design.
• Led the data migration of the Sales Customer Management (SCM) system to Dynamics CRM software using SSIS, ensuring successful data mapping and development of the SCM Data Dictionary.
• Built a complex automation process across various platforms for Build-A-Bear using SQL Server 2005, .NET/C#, SSIS, and SSRS.
• Planned, designed, and implemented various quota management systems for well-known clients, and managed constant data loads through automated processes.
• Designed and implemented ETLs from various source systems to build real-time reporting systems, and developed various types of SSRS reports for internal and external clients.

• Developed Web based Wish-list Module for shopping cart
• Designed software requirements and implemented code for employee time tracking system.

• Responsible for collecting requirements, implementation, unit and integration testing for customized Reporting module
• Responsible for implementation of Desk-Manager product.