Sandeep Majumdar

Sandeep Majumdar

$90/hr
Azure Data Engineering
Reply rate:
-
Availability:
Hourly ($/hour)
Location:
Bangalore, Ka, India
Experience:
15 years
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
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.