Deepak Manchanda Email & Phone Number

New York, Ny, Us

I manage development projects for our major clients in insurance, banking, and lending services. My role includes leading a team that supports data centers for direct and digital marketing operations and playing a lead architect role in the server infrastructure and database architecture. I focus on redesigning or re-engineering business flows of data for existing legacy components to ensure seamless operations.I manage projects for migrating legacy applications to new trending technology and robust fracture from on-premise. I conduct and evaluate new technologies, creating proof of concepts for clients and implementing them as a client wins. I have successfully implemented capabilities like Snowflake, secure data sharing, peer-to-peer blockchain, etc. as some of my recent wins I am a liaison between offshore and onsite support; I ensure end-user support, technology operations, and infrastructure. I lead clients and major external IT audits-SOC 2, PIC DS, etc.I plan and budget technology operational and capital costing for the year, marinating vendor relations for periodic reviews.

New York, Ny, Us

I successfully managed several key product development projects for our major insurance and banking clients. Additionally, I led a team to support data center operations for direct and digital marketing operations. One of my proudest accomplishments was leading a project to migrate the entire data center from one location to another, resulting in significant cost savings and reconciliation. I was also responsible for rolling out technology policies and procedures to newly acquired entities and handling audits and compliance for the BU. As a key liaison between offshore and onsite support, I successfully managed business-critical projects for new client wins and ensured the smooth operation of our technology infrastructure. I also planned disaster recovery tests and activities, working closely with our corporate business continuity team. In addition, I supported our key clients for our healthcare application hosted in our environment. I was also responsible for ensuring compliance with our technology components and services, including conducting assessments and pen tests and reporting to senior leadership.

New York, Ny, Us

In my previous role as DB Practice Lead for EXL's Enterprise and Business Platform Applications, I played an instrumental role in various projects. This included overseeing the maintenance and setup of Disaster Recovery Centers, from planning to testing. As a Project Manager, I successfully led end-to-end solutions, starting from requirement analysis to production roll-out. Additionally, I effectively managed a team of application developers and database administrators, providing BAU support for enterprise-wide applications. I was also responsible for ensuring compliance with technology components and services, conducting application assessments and pen tests, and reporting to senior leadership.

Server Database Administration, specializing in MS SQL Server 2000, 2005, and 2008. My responsibilities have included managing core database administration, handling upgrades, and overseeing key production databases for major clients. I ensured backups, performance tuning, high availability, maintenance, and change management of schema, as well as lower environment (Testing/Dev) refresh and load testing. Additionally, I have expertise in database partitioning and archiving strategies. I am also experienced in working in 24x7 rotating shifts for production support of OLTP databases.Primary role to ensure the smooth operation, security, and performance of the organization's SQL databases. Oversee installation, configuration, backup, and recovery processes, monitor database usage and capacity, optimize database performance, and provide technical support to end-users. Additionally, data modeling, database design, and ensuring data integrity and consistency.

Los Gatos, Ca, Us

My role included data warehousing and database design, requirement gathering, design and implementation of data mart for reporting, development of ETL using SSIS, data modeling, dimension modeling, and creating ROLAP schemas for cubes using SSAS. Projects like the vehicle Insurance industry provide the complex transformation from source data, file uploads, data loading to staging and production environments with incremental and full loads.Design and develop data warehouses, which are centralized repositories of data from various sources, ensuring data consistency, integration, and easy access for analysis.Create and manage data models, ETL (Extract, Transform, Load) processes, and data integration pipelines to extract data from different systems, transform it into a consistent format, and load it into the data warehouse.Collaborate with business stakeholders to understand their reporting and analysis requirements, and then design and develop BI solutions using tools like dashboards, reports, and visualizations.

Reston, Va, Us

Worked as Technical Consultant core into Development of Data Mart for US based Client. The main responsibility included • Technical Requirement gathering, solution design- ER logical and physical schema. • Dimensional modeling• ETL development and data Mart implementation.• Develop strategies to Extract Data from sources like SAP, Hyperion, ESSBASE using MS SQL Server DTS.

Noida, Up, In

• MS SQL Server Database Support, Development,• Database Design and Data-warehousing.• Worked on Travel and Supply Chain Management Domain.• Worked as software engineer in SQL coding which included writing complex store procedures for data loads

Noida, Uttar Pradesh, In

• Support in Manufacturing ERP application • Support of Database- Sybase, data migration from Sybase to MS SQL Server,• Implementation and support to user of application - ERP (Enterprise Resource Planning) mainly focused on domains like Production Planning, Finance, Purchase, Stores, Sales. • Support of MS SQL Server on various client sites

Bachelor Of Business Administration - Bba, Business Administration And Management, General

Information Technology- Certification, Information Technology

Pgdsm- Mba (Diploma), Marketing/Marketing Management, General

High School Diplola, Cbse (A.I.S.S.C.E)