Sandeep Majumdar
#91204 Nikoo Homes
Bhartiya City ,Bangalore-560064
- /--PROFESSIONAL SUMMARY
Digital Solutions Generalist with 17+ years of extensive subject matter expertise in Cloud Data Solutions, Data
Engineering,Database Management, Database Operations, Data Warehousing methods, processes, strategies, and developing cost
effective digital transformation solutions to meet requirements & objectives. Excel at adapting management style, emerging
technologies, and best practices to marry IT solutions with business needs. A Lifelong Learner,Behavioral Economics Enthusiast
and Digital Evangelist who champions OKRs & KPIs while harnessing and driving performance combining people,process &
technology.
QUALIFICATION HIGHLIGHTS
Cloud Consulting ,Data Engineering, Database Operations, Data Security and Digital Transformation
● Delivered value added solutions on Public Cloud Infrastructure(Azure,GCP) and Private Cloud (Openstack) using
various IAAS,PAAS & SAAS tech stacks for distributed and large scale Ecommerce Program
● Spearheaded Data Engineering & Data Pipeline Solutions for Digital Marketing Campaign Management of a
Omnichannel Ecommerce Retailer leveraging MSSQL, Azure Data Platform( Azure Data Factory, Azure SQL Data
Warehouse (SQL Pools), Blob Storage, Databricks, Stream Analytics, Synapse,Power BI ,Excel,Azure Logic Apps
,Google Marketing Platform (Google Analytics,Google Ads) for Marketing Analytics & building Analytics Solution
using Clickstream Events & Behavioral Data from CDP (Customer Data Platform)
● Spearheaded Data Infrastructure Solution, Data Security Solution & Data Management solution for a major
internet gaming company, This included business and IT infrastructure process establishment and requirements
analysis developing the transition plans to implement them..
● Delivered Data Engineering solutions on Microsoft Azure with Azure Data Factory, Azure Power BI, Azure Logic
Apps, API integration from multiple systems.Familiar with Kappa, Lambda Architecture for pipeline
● Developed DW(DataWarehouse) ,Data Integration and ETL workflow solutions for BI(Business Intelligence),
Analytics & Data Visualization Projects based on business problems for a Automotive Components Manufacturing
and Managed Healthcare Organization.
● Spearheaded Data Security Risk Framework & Database Operations for the largest U.S.Based Investment
Bank.Participated in Transition Management of Data Security Operations Project from Onsite- to Offshore.
● Business Analysis & Solutions Planning :Performed an analysis of business requirements, drivers and resource
consumption across multiple platforms and developed a macro level capacity planning methodology using natural
business forecast units for a major online gaming company.
● Data Migration Solution from On-Prem to Azure via VM Lift-Shift, Cloud Data Workload,SQL Server Migration,
SSIS package migrations, Participated in workload planning, migration, and implementation projects. These
projects ranged in size and scope that included migrations to newer technology operating environments, storage
technologies, and workload processing.
● Effective Infrastructure Workload Planning, Data Capacity & Site Reliability Planning for Availability &
Performance of OLTP Application Databases, Minimizing Latency for Reporting Data Warehouse,
Datamarts,OLAP, BI & Reporting Services, Data Management,Efficient Backup & Disaster Recovery Strategy, Risk
Mitigation Strategy, Data Security, Ransomware Recovery Strategy, Performed effective resource utilization analysis,
and implementation of multi -vendor tools, migrating data workload to cloud aligning it to appropriate technology.
.
PROFESSIONAL SKILLS
TECHNICAL
●
●
●
●
●
●
●
Digital Operations Management
Data Security,Compliance,Governance
Solution Design & Transition,
ITSM, Service Strategy, Design, Transition
Problem, Change, Release, Configuration
Service Desk, Service Level, Capacity,
Performance, Business Recovery, Financials
Tech Due Diligence + Onboarding
Training & Knowledge Management
●
●
●
●
●
●
●
●
●
Cloud & Digital Infrastructure Architecture
Digital Evangelism
Digital Marketing Management
Planning and Performance
Operational Assessment and IT Outsourcing
Disaster Recovery Planning
Hybrid Cloud Management
Cloud Workload Analysis & Cost Optimization
Data Engineering & Management (ETL,DW,BI, & Analytics)
BUSINESS
●
●
●
●
●
●
Digital Strategy & Roadmap
Enterprise Agility
Digital Marketing & Branding
Business Analysis
Strategic Initiatives
Project Management
● Team Building & People Management
● Cost Benefits Realization
● Profit & Loss Management
● Strategic IT Sourcing
● Vendor Assessment & Management
● IT Transformation
PERSONAL
●
●
●
●
●
●
Life Long Learner
Articulate
Forward Thinking
Proactive
Respectful
Calculative Risk Taker
● Thoughtful
● Entrepreneurial
● Rational
● Growth Mindset
● Resourceful
● Influential
TECHNOLOGY & TOOLS AWARENESS
Azure Compute (VM,ACI,AKS,App)
E-commerce (Woo/Presta/Magento)
Loading Data(polybase/bcp)
Azure Data Factory
ECM Enterprise content management Logistics & SCM
Azure Data Lake Storage Gen1/Gen2 EAI Enterprise application integration MQ - Kafka,Rabbit
Ad Ops (A/B testing,Taboola)
E Learning Management Systems
Marketing Automation
AdWords/AdSense
EIS Executive Information System
(Marketo/Hubspot/Mautic)
Active Directory(ADConnect,Intune)
Email Servers
MSBI(SSIS,SSRS,SSAS,Excel)
APM (AppDynamics,Splunk)
Enterprise Architecture Model -Sparx
Mobile OS(Android/IOs
Application Server (Apache/Nginx/IIS) EHR
Modeler ERWin,Visio,EA
API Management & Integration
ERP Enterprise resource planning
Monitoring AppDynamics
API Gateway
E-commerce infrastructure
MDM (MDS)
AWS (EC2,S3,Route53,IAM,RDS)
E-supply chain , routing, scheduling
MS-Office
BI Business intelligence PowerBI,MSBI ETL Talend,Informatica,SSIS,MSBI
MS-Project
Blockchain(Ethereum,Smart Contract) Executive dashboard
MYSQL
B2B & B2C Ecommerce
Event Hub
NOSQL- Cosmos DB
Change management
Financial modeling(SAAS/Startup)
Network Security Group
Control Panel (Plesk,CPanel,WHM)
4GL Fourth generation languages
OLAP online analytical processing
CDN(Azure/Akamai/Cloudfront/)
Freight management Systems
Omnichannel Commerce
Contact mgmt/CRM (ACT,Hubspot)
GPS global positioning & tracking
OS : Linux,Ubuntu,Windows
CMS Content management systems
GitHub/Gitlab/ Azure Repo
Oracle
Config Auto(Chef,Ansible)
GCP Data Stack( BigTable, BigQuery, Orchestration(Kubernetes)
Cloud Security (AD,Sentinel )
Dataflow, Pub/Sub, Looker)
Payment Gateway
Data Center Migration
Google Marketing Platform
PAAS(Azure Platforms,Azure Function)
Database administration
Graphic Designing
Packaged Apps (Bitnami/Sandstorm)
Data Analytics(Azure Synapse Analytics) High availability -Cluster Node
Performance Tuning
Data Management(Catalog,MDM)
HDInsight Clusters (Hadoop/Spark)
Pen Testing ,SQL Injections
Data Governance(Atlas,Purview)
Hosting (Hostinger,Hostgator,GoDaddy) Planview
Databricks (Spark-SQL)
HTML
Photo processing
Data warehouse & Data Lake (Azure)
Infra Automation - ARM,Terraform
Photoshop
Data Visualization(Tableau/PowerBI)
IAAS (DO,AWS,Azure,GCP)
Presentation
DMP (Bluekai)
IDE( VS Code)
Prototyping
DevOps(Azure Devops)
ITIL
TSQL
Digital Marketing(PPC,SEO,SMM)
Lean Management
Peoplesoft
DAAS (Azure SQL)
Lake Management (Kylo,Upsolver)
Polybase (ELT,Eternal Table)
Python,PHP
Project management
Product Management
Program Management(Benefit Analysis)
Quality management
Reporting
RAD Rapid application development
RAID
RDBMS Relational database mgmt
RPA Process Automation(UIPath)
Schema management
SAAS Ops
Scripting(Python,VBScript)
Scraping(Scrappy)
Serverless( Azure Functions)
ServiceNow
Snowplow
Spreadsheet (Google Sheet./ Excel)
SQL Server
Spark ( DeltaLake, SparkSQL)
Synapse Analytics (SQL DW)
Social Media Management
System monitoring -Azure Monitor
Test data generation
Route planning & optimization
UML, Visio , Draw.io
WCM Web content management
Web analytics Google Analytics
Wordpress,WooCommerce
Windows
Word processing
Warehouse Management Systems
Web Application Firewall (Azure WAF)
PROFESSIONAL EXPERIENCE
Principal - Cloud & Data Solutions
Xenisys , Bangalore, KA
Aug 16 - Present
I played the role of a principal consultant consulting organization on onboaridng cloud solutions. These positions
included developing, closing, and delivering value-add cloud services including IAAS ,PAAS & SAAS. I consulted
Startups and SMBs Business,Product Managers, Marketing Managers with Cloud Adoption,CDP Integration, SnowPlow
Integration for Behavioral Data & Events Capture, Security Assessment,Data Engineering,Analytics
Integration,Marketing Automation, Cloud Assessment,Digital Strategy, Digital Roadmap, Digital Marketing, Digital
Analytics.
●
●
●
●
●
●
●
●
●
●
●
●
●
●
●
Advising and engaging with customers providing strategic direction to accelerate their Cloud Adoption, Cloud
Workload Migration, Modernization & Cloud native implementation with a focus on azure data platforms
Creating cloud native bespoke solutions for multiple use cases, enabling Professionals on project rollout and
phasing of projects.
Product Management of Datanadi- A managed CDP solution on Azure for Marketers to unify their customer
data and to offer personalized campaigns. Engaged in the solution of Data Fabric by integrating all data
layers for implementation.
Led Data Ingestion Solution to Move Large Scale Data Workloads in Parallel from Azure Storage, Data lake,
HDinsight to SQL DW pool to Compute Nodes using Polybase technology of MPP Platform. MDM solution
designing of Master Data Hub on Azure to deliver high-quality, trusted data across the Azure Data Platform
leveraging MDS & Profisee kit.
Led Cloud Data Migration Project plan by aligning people, process and technology and rationalizing with
business objectives
Development of cloud architecture diagrams using Visio & Draw.io,diagrams.net and building proofs of
concepts on proposed architecture. Hands-on architecture design and reviewing with other experts
Evaluate Technology,Cloud Services ,Software Products and recommend solutions,technologies,systems to
satisfy business requirements as per budget. Running Discovery & Assessment based on frameworks.Also
influence decision for software and technology selection with right data points & Conducting Proof Of
Concept(PoCs) , PoV(Proof of Value) and MVP( Minimum Viable Product) Engaging with MSPs to establish
Cloud COE by creating Playbook, Best Practices, Templates, Process,Collaterals, Operational runbooks,
Frameworks for Cloud Readiness Assessment, Skill Readiness, Cloud Architecture Modeling, Cloud Security
Assessment, Cloud Data Management and Cloud Adoption.
Consulting CoEs to establish Cloud & Digital COE by Creating Collaterals for Sales Enablement,Presentation
Decks,Playbook,Operational Runbook, Pre-Sales Solution Architecture Document, Cloud Governance
Framework and delivered customized cloud solutions to a variety of customer base using Cloud Adoption
Framework (CAF)
Evaluating Platforms, Software, Solutions (PAAS,SAAS)from ISVs, COTS creating PoCs for Software
selections, Recommending Solutions for Decision making process of Build, Buy or Lease.
Overseeing Data Engineering & Data Pipeline Projects of COE leveraging Azure Cloud Data Platform & SQL
Formulate Strategy & Execution Plan for Azure Arc-CMP- A multi cloud management platform for
provisioning, orchestrating across public cloud & private cloud, Cloud Data Management,Cloud Backup, Web
Application Security Firewall , GRC, Cloud Monitoring & Management.
Training,Staffing,Mentoring Team in COE to meet customer’s pipeline and growth strategy of client..
Formulate Digital Strategy, Creating Roadmap and Presenting Solutions to customers
Creating Decks for multi cloud(Azure,AWS,GCP,OpenStack,DigitalOcean) & Hybrid Cloud Economics.
Development, Marketing, and Delivery of Digital Strategy Consulting and Cloud Consulting Services.
Delivery Manager- Digital Operations
Cognizant Technology Solutions
Account 1 -Omnichannel Ecommerce
Kohls, Milwaukee,WI
Nov 2010– Jul 2016
●
Participate in Solution Selection, Vendors Coordination, Enterprise Rollout Migration Plan, Building PoC &
Pilot Onboarding, Due Diligence, Vendors Selection, Validation with Enterprise Architecture
alignment,Architectural Discussions and Integration feasibility and Influencing Stakeholders Decisions.
●
Spearheaded Data Engineering & Data Pipeline projects for Creating CDP PoC to unify Customer Data
from multiple data platforms to build customers profile & Personas, Data Integration of CDP(Customer
Data Platform) with Marketing Automation leveraging transactional,behavioral & demographics Data and
Product Information Management(PIM) System with all possible business use cases & KPIs.
Plan, Estimate,Managed, Execute Digital Transformation projects under Omnichannel Ecommerce program
doing POC, Due-Diligence, Rollout & Onboarding of Google Cloud , Product Information
Management(PIM), and Database Security Auditing & Assessment Projects for transition from Traditional
Ecommerce to Omni Channel Ecommerce on GCP.
Analyzing the Kohls data and Designing the solution for moving data to Google Cloud Bigtable and bigquery
Evaluating & Recommending tools & technologies, such as Cloud Data Fusion for ETL/ELT data pipeline,
Apache Airflow for data cleansing and transformation as a job scheduler for hadoop jobs and for loading data
in bigquery for Analytics to serve product recommendations to their customers.
Integrate Customer Data Platform with Enterprise Data Lake using industry best practice Data Hub and Spoke
model architecture.Custodian of Data Collection and ingestion into Customer Data Platform, standardization,
unification and segmentation of customer profiles.Partner with Marketing business unit to help CDP power
marketers create targeted personalized marketing campaigns
Design data acquisition pipeline frameworks to automate high-volume and real-time data delivery into Cloud
Marketing Data Spoke.Work with Marketing Product Owners and Stakeholders to gather data requirements and
deliver data products in a collaborative and agile environment
Work with Marketing Analytics Team to understand their advanced analytics use cases requirements and enable
certified ready-to-use amplified datasets for them to consume and run statistical, AI/ML models
Provide Data Operations support for all Advanced Analytics solutions used by Marketing Analysts
Design data APIs and data delivery services that support critical operational and analytical applications for
internal Marketing business process operations.Serve as gatekeeper of quality controls for all the Marketing data
jobs developed in-house
Led and managed core team, program, and project collaterals of action items, issues, and risks. Conducting and
Managing Daily Scrums, Scrums of Scrums, Collaborating,coordinating with CIO & PMO office, Business
Stakeholders, Offshore Team ,Onsite Resources,Team Managers,Enterprise Architect, Vendors, Scrum Master
& Product Owner of Omnichannel Commerce to execute multiple projects in parallel.Coordinated all meetings
with stakeholders,cutting through red-tapism and organizational bureaucracy with constant negotiations for
go/no-go,timelines & budget.
Hiring & Delegation of Task to Project Team on Planview to ensure projects go-live on time & on budget.
Rollout Splunk for Security Operations Team for Security Log Analysis to automate monitoring, and analyzing
of big data generated across Ecommerce System including logs, user behavioral data & web traffic for any
security issues or incoming threat detection
Working closely with Enterprise Architect to roll out Data Governance Framework & Data Privacy Policies, LP
(Loss Prevention) Programs across the organization.
●
●
●
●
●
●
●
●
●
●
●
Account 2 Project Manager- Data Management & Security
JP Morgan, New York/Tampa, FL
● Managing Data Security & Data Management Projects in IT Risk & GRC Line of Business in accordance with
SOX, ISO 27001 guidelines. I was accountable for implementation of managed IT Risk Product and rollout of
framework across JPMC LOBs & CF.
● Participated in evaluation,selection of technology solutions for Data Management Capabilities including
Metadata Management, Data Privacy & Security, Master Data,Reference Data, Data Catalog, Data Lineage,
Data Discovery Map, Category,Business Terms & Glossary Management to democratize data for data driven
programs.Worked with vendors to create PoCs, Plan & Run Sprints and Pilot Rollout.
● Ensure effective decommissioning of old DBs of Applications, technology & services that are deemed `end of
life` - to confirm the remove of all operational facilities, and redundant equipment, whilst ensuring any
operational dependencies are effectively managed.Ensure that appropriate lifecycle resourcing, training, tooling,
support and documentation is delivered with a formal project sign-off from all key stakeholders.
● Represent the Data Operations team at all project meetings to define and implement service acceptance criteria
for both new and changing services.Coordinated with various teams to resolve issues on Cognos Reporting,
Informatica Powercenter Workflows post integration of Enterprise Apps with AppDynamics.Provide fully
documented services, which are updated and maintained throughout the life of the service and are aligned to
best practice.
● Developed end to end Risk ,Governance and Compliance framework, support structure, including Processes,
SLAs, KPIs, WLAs and BSS monitoring commensurate with business requirements and priorities.Act as a
gatekeeper function that ensures effective Transfer to Operations in compliance with the Service Readiness
Process (SRP) for all new services introduced via the business project lifecycle.
● Work with Project Managers, Business Owners, Service Owners, Managed Service Partners, Operations teams
and 3rd parties to ensure that projects are delivered in compliance with the SRP.Ensure that any new 3rd party
contracts contain an agreed support schedule which aligns with the proposed support model and is backed up
with SLAs managed through regular service reviews.Interface with the Project Support Office to ensure
adequate Service Transition and Back Office Operations Team coverage across all relevant work requests.
Account 3 - Delivery Manager
Healthways,Nashville,TN
● Managed global teams including DBAs, Data Warehouse, BI and ETL Engineers for Mission Critical Data
Operations,Business Process & Production Support of 40TB of Healthcare Data.; developed staffing plans,
managed workloads,defined deliverables, hired resources, conducted performance reviews, and ensured
compliance with established company policies.
● Responsible for Managing,Engineering,Maintaining and Governing PII Data of a Major Healthcare Service
Provider adhering to HIPAA Compliance & Guidelines
● Deliver IT Operations Services using ITIL best practices that focus on the people, process, and technology,
and information perspectives of providing business solutions within the IT infrastructure. This includes all
aspects of ITSM best practices and methods from analysis, architecture and design, planning, implementation,
and support.
● Develop, and deliver value added Service Management solutions that specialize in the Digital Enterprise,
Customer Centricity, Service Management and Service Support best practices, Transformation, ITIL, SIAM
and Governance. This includes solutions based on best practices that focus on the people, process, technology
and information perspectives of providing integrated organization wide business solutions within the IT
infrastructure for all aspects of ITSM best practices and methods from analysis, through architecture and
design, to planning, implementation, and support.
Consulting & Pre-Sales Activities
●
Develop, refine and maintain roles as a Solution Architect with in Digital Operations & Infrastructure
Services COE doing Consulting, Digital Solutiotioning , Creating Solution Architecture & Overview
Document, Solution Presentation to Customer, Response to RFP, Participate in Deal Cycle,Due Diligence
of IT Opportunity aligning with Capability & Pricing Benchmark., Service Delivery Lifecycle, and
Preparing Digital Governance to Digital IT Outsourcing Projects, Transition Management to Delivery
●
●
●
●
●
●
Handling Pre Sales process including RFP Qualification, Requirement Analysis, Pain Point Analysis,
Proactive Proposals, Solution Demos,Technical Presentations, Answering Queries of Customers, Training
Business Partners and post sales migration and deployment. by BANT Analysis (Budget,Authority, Need &
Timing ) by working closely with Service Delivery, Account Management & Sales.
Occasionally Provide account management, planning and provisioning of value added service and
technology solutions to the COE team. Create Business Cases for Marketing CoE with right data points.
Develop, refine, and maintain “trusted advisor” relationships with designated new and existing Digital
Infrastructure customers at an Executive CXO level for value added service and technology solutions that
is aligned to meet their business requirements
Develop, enhance, and maintain proactive leadership role of proficiency in leveraging and understanding
business specific knowledge relative to a assigned vertical line of business
Provide Thought Leadership level of proficiency in specific Digital Infrastructure Service to proactively
leverage them in Developed, marketed, and delivered customized technology business solutions to a
domestic customer base. Specialized in the application of storage technology infrastructure solutions.
Digital IT process creation, IT assessments, IT management , implementation and roll out and oftentimes
included developing Use Cases, ROI, TCO, Governance and Cost Benefit Analysis leveraging best
practices, methodologies & framework such as ITIL. Also, used ITSM holistically in the areas of people,
process, technology and information across the organization and integration for those ITIL process areas
Senior Consultant- Database Infrastructure
December 2008– October 2010
Icronex Technologies Gurgaon/San Jose
● Architecting & Engineering ETL & SQL SSIS Workflows to move data across heterogeneous databases & DW
to ensure effectiveness in SSRS reporting. Building conceptual, logical & physical database designs using tools
such as ErWin Data Modeler, Visio. Generate DDL to create Databases as per forward engineering rules.
● Select infrastructure components such as GPUs or CPUs based on the Data processing job/compute needs
● Logical DW Modelling, Fact dimensional modeling (Star schema, Snowflake schema), transactional
modeling and SCD (Slowly changing dimension) for Marketing & Analytics Datawarehouse.
● Large Scale Data Loading Solutions for SQL Datawarehouse using various tools, Integrating with DMP
● Building the Data Pipelines for Marketing Operations Team for Campaign management & Mass Email Ops.
● Architect and Provision of the servers in virtual and physical environment .OS installation and
upgradation.File system creation, extension and reduction as and when required.Vulnerability patch
management on Linux servers for MYSQL Database
● Engineer schedule and orchestration for batch and near-real time data loads into the Marketing Data Spoke
● Data Center Migration :Performed data center migration and server consolidation from On-Premise Tier 1 DC
to Managed Tier 3 DC,I did entire workload planning, migration, and implementation projects for a large
gaming company based out of Costa Rica. These projects ranged in size and scope that included migrations to
newer technology operating environments, storage technologies, and workload processing
● Planning and Implementation of storage architecture for databases on SAN,NAS and Power vault in corporate
data center as well as shared data center
● User Security Group management, Active Directory Management, Server Security Hardening, Mounting
Storage Drives on Windows / Linux servers with CIFS and NFS.
● Network Configuration and bonding in Server Systems.OS Hardening. Reviewing daily checklist for core
production servers.Working with Security, Storage, Network and other IT departments to ensure smooth
processes including providing status reports to higher management, detailing deliverables and overall project
status.Inventory management, Change management & Incident management as per ITIL standards
● Performing Snapshots, Cloning, Cold migration and Hot migrations.Performance monitoring VMS & ESXi
Servers using virtual center.
● Own the responsibility for control, scanning, hardware and software access control, and security briefings.
Coordinate PCI-DSS Auditing, & Certification for all Gaming Websites, Security policy and system risk for
assigned systems, developing and maintaining of incident response, proactive emergency planning, continuity of
operations planning.
Technolgy Specialist
August 2007 – Nov 2008
Microland , Bangalore
I was SME of Database Tower enabling the team to keep customers' database infrastructure at optimal performance.
● Worked on Enterprise Server software for large-scale organization with all possible configured high availability
options like Always On, Clustering, Replication, Mirroring, Log Shipping and supporting daily administrative
activity and exhaustive monitoring for availability.Configured maintenance plans for backups, database
optimization, Administration of SQL Server Agents, managing SQL Jobs, SSIS Jobs and SSIS package creations
and deployment, known to other tools like Integration Service, Reporting Service, and Analysis
Services.Configured with backup and recovery options available with SQL Server.Set up SQL Server
Integration Services, SSIS packages Development, SQL Server Reporting Service and Analytical Service
experience will be an added advantage including upgrade/migration.
● Worked as a Subject Matter Expert for the Data Engineering Team. Set up best
practices,processes,knowledgebase for team to adhere,Installation and configuration of database server,
replication, log shipping.Coordinate with L1,L2,L3 during escalation I wrote automated scripts for automated
monitoring.Preparing of RCA and working on Problems Training and Team motivation Made the DR plan and
site for SQL server.Created auto database maintenance jobs of all SQL Server databases and auto alert to
stakeholders .
● Responsible for keeping a database for optimal performance of OLTP & OLAP Applications. Also
Responsible for Auditing of Incidents, Doing RCA of Critical Problems, Change Management to compile
with SLA and ITIL process Managing & Contributing to KEDB with configuration ,troubleshooting
guidelines, training and mentoring team members
Consultant Database Operations
Syncata(Acquired by Snap-On),Noida
April 2006 – July, 2007
Worked as a Lead Data Engineer on a large environment and infrastructure having multiple SQL Server Instances.
● Lead Data Engineering Team for Delivering Projects & Programs. Have expert knowledge on all area of,
administration, configuration, monitoring, migration, advance performance tuning, backup/restore and
recovery option, user and security administration of SQL Server, MYSQL and Oracle Database Instance and
worked on latest releases
● Creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables,
common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2008R2/2008/2005.
● Loaded legacy source data from MSSQL, MySQL, Oracle, Access, and SQL Server DB into SQL Server 2008
R2 staging DB using SSIS Import & Export Wizard and VB scripts, SQL Server Migration Assistant (SSMA)
and SSIS packages. Created MDM DW for Complete,Clean, Consistent and Current Data for BI.
● Engineer and performance tune ETL jobs to move data from a variety of source systems and file types to fit
into dimensional data models.. Utilize advanced SQL within ETLs when necessary to achieve proper metric
calculations or derive dimension attributes
● Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager),
Enterprise Information Management (EIM),Resource Planning, Coding, Debugging, Testing, Deployment,
Support and Maintenance of business applications using SQL Server DTS, SSIS and SSRS Performance tuning
of MS SQL Server using various tools like Performance Tuning Advisor, SQL Profiler, Index tuning wizard,
Various DMV and various DBCC commands, system procedures, extended procedures, strong knowledge of
query optimization and query analysis, performance manager. full-text indexing, partitioning, indexed views,
Transact SQL (T-SQL) Coding, XML Queries, PL/SQL development experience with stored procedure,
function, trigger, view, and other.
● Wrote Business Logic Stored Procedures T-SQL, PL/SQL, PowerShell Scripting and other Scripting and other
development options available with SQL Server/Window Environment.
● Working with heterogeneous databases, multiple databases. Address and Resolve Technical Issues related to
Databases and provide 24- 7 support with international clients handling large databases and aware about prosand cons- with real-time experience.
System Analyst -Data Infra
July 2003– Nov 2005
Net4 Data Center, Noida
● Performed data migration using tools like Data import/export, BULK INSERT and BCP between different
heterogeneous systems and SQL Server. Involved in creating Jobs, SQL Mail Agent, Alerts and Scheduled
DTS/SSIS Packages
● Security Hardening of Database Infrastructure, Implementing Security Best Practices and Managing User
Permissions for multiple Mission critical Databases.
● Requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server
Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance
of business applications using SQL Server DTS, SSIS and SSRS
● Writing scripts and code in ASP, VB Script and MYSQL for Net 4 Hosting Ecommerce Website on IIS
Application Server and Win 2003. Used Microsoft Visual Studio IDE to Code,Debug,Run.
● Migration of Databases between different servers across data center.Planning, Configuring and Automating
Maintenance of Databases.Routine monitoring and troubleshooting of jobs, automated maintenance tasks,
error, space, performance counters, alerts etc.Capacity Planning, space management, Hardware Selection on
budget, vendor coordination and negotiations.Planning and Configuring Backup of various databases.System
Integration of applications to database server and troubleshooting issues.Participate in Index suggestion, query
performance testing, query deployment on production.Creating SSIS and scripts to work with heterogeneous
data sources and destinations as per business requirement.
EDUCATION
MBA: International Business
IIFT,New Delhi
BE : Computer Sc Engg.
RSS University,Raipur
Certification : ITIL V3 | Microsoft Azure
PMP | NLP
Keywords :
Domain : Marketing, Managed IT, Solution Architect, Cloud Solution Architect, Pre-Sales,Project Management, Product Management, Data
Solutions Architect, Data Engineering , SQL DBA, Data Warehouse, BI Consultant,CIO, CTO
Cloud : Microsoft Azure, AWS,GCP,Google Cloud , IAAS, PAAS, SAAS, IPaaS , Digital Ocean, Vultr , Alibaba
Compute : VM Scale Sets, Resource Group, Blob Storage, Azure Purview,App Service (Linux),Azure Functions,Container Registry, Container
Instances,ACI, Docker Image, Kubernetes, AKS, App Service,Migration, DB Migration Service, Site Recovery,Azure Batch,Infrastructure as Code,
ARM,Terraform,Azure Migrate
IAM Security : Azure AD Connect, Active Directory, AD DS,Intune, Endpoint Manager, Defender,Key Vault, Sentinel
Networking : Virtual Network, VPN Gateway,Application Gateway, Load Balancer,DNS, Express Route, CDN, Firewall,Bastion, JumpBox, VNet
Peering
IT Management : Monitor, Azure Advisor, Azure Arc, App Insight, Backup, Azure Blueprint, Azure Policy, Cost Management, Azure Portal, Cloud
Shell, Powershell, CAF Cloud Adoption Framework, Multi Cloud,Hybrid Cloud
DevOps : Azure DevOps, VS Code,
Data Analytics : Data warehouse, Synapse Analytics,Azure Data Factory, ADF, Data Explorer, DataLake, Data Lake, DeltaLake,Databricks,
HDInsight,Event Hubs,Stream Analytics, Azure Analytics Services, Data Catalog, Azure Data Studio, SQL Server Data Tools , SSDT
Analytics,Data Architect, Cloud Data Architect, Data Model, Data Pipeline, Data Science, Data Manipulation,Master Data Management, MDM, Data
Quality Services, Data Cleansing,Data Enrichment,Data De Duplication,Scheme,Big Data, Spark,Polybase, Kafka, BigQuery, Data Warehouse, Data
Mining, Data Architecture, Data Engineering, Data Management Data Operations, Database Administration, Data Security, Data Governance, GRC,
DBA,Replication, SSIS, SQL, MDS, OLAP, Python, Power platform,Power BI, Excel,Insights , DataOcean
Database : SQL Server, MYSQL,ORACLE,Cosmos DB,Apache Cassandra
Integration : API Management, JSON,XML,REST API, Logic Apps, Service Bus,
AI ML : Azure Machine Learning,Bot Service,Cognitive Services, Cognitive Search,Open DataSets
Blockchain : Azure Blockchain Service
Industry : Retail, Ecommerce, Logistics, Manufacturing, Supply Chain , Healthcare, Banking, Financial Services, IT ,Travel , Media
Management : Business Strategy, Decision Making, Project Management, Product Management , Program Management, Program Management,
Marketing, Leadership, Lateral Leadership, Change Management, Human Resource Management, HRM, Organizational Design, Global Trade,
SEO,SMM, Marketing Analytics, Google Ads, Facebook, Campaign, Hubspot, CRM, Blog, Youtube, Google Tags, Ad Platform, Marketing Platform,
Marketing Automation , Cost Benefit Analysis, Benefit Realization , Relationship Management , Business Analysis
Sales Enablement : PreSales Cycle, RFP, RFI, RFQ, Proposal, Sales Discovery, Probing, Need Analysis, Business Analysis, Synthesis, POV, POC,
MVP, Recommendation, Delivery, Technology Evangelism, Negotiation , Win Rate, Conversation Rate, Winning ,Whitepaper, Sales Pipeline
Management
Roles: CIO, CxO, CEO, IT Director, Program Manager, Principal, Practice Head, VP, SVP, Director, CTO, COO, CDO,Enterprise Architect