DBMS and ETL

• 19 years of information system delivery and management experience in Life Science, Insurance, Pharmacy Benefit Management, Retail and
Hospitality sectors in multi country multi lingual projects
• A motivated team player with analytical, problem solving, documentation and team management skills with grooming and maintaining 50
member data team
• Experienced in CTO/VP level coordination for new business channel discussion and suggesting best possible technology solution converting
to major integration project
• Experienced in 3000 user CRM and 5000 user DW/Data Lake Management for NYSE listed Fortune 100 and Fortune 500 company
• Experienced in account, customer and address data deduplication and unique id generation with match and merge process across OLTP
systems like CRM, ERP, ODS, business sandbox
• Experienced in sales cycle automation development involving transactional entities like opportunity, objectives, leads, campaigns, meeting,
budget, territory alignment, speciality assignment, segmentation, KOL management in 60 country multi lingual 24x7 Siebel CRM
application in life science domain with custom translation capture and automation of application language conversion in UK and India
• Experienced in Email integration, ODS/MDM/CRM batch integration, ETL Disaster Recovery environment set up in network isolation
mode and successful Enterprise DR execution, application server upgrade, ETL server and upgrade, batch job modification, scheduler tool
upgrade, onsite/offshore based batch monitoring for insurance giant in North America serving 3000+ users in CRM
• Experienced in billion row claim, eligibility data processing and reporting, management of planned/unplanned database/ETL/scheduler
outage for multi state HIPPA compliant pharmacy benefit management provider in North America
• Experienced in SSIS to Clover ETL based Vertica data migration for demand planning backend ETL system, Clover ETL and Python/shell
script based upstream/downstream data integration from 200 batch to 2000 batch rapid growth cycle for NYSE listing, self serve business
sandbox data mart development with Github project and automated sandbox code deployment setup for 100+ business units, inhouse DQ
tool management and data quality dashboard management, 3 node to 16 node Vertica database cluster upgrade, Clover 4.x to Clover 5.x -
Clover 5.6 to Clover 5.11 version upgrade for 10+ ETL server infrastructure, load balancing and automated secondary ETL server failover
development, server space management with IP whitelisting for 3rd party API based vendor integration, on premise to Snowflake data
migration in AWS, supply chain technology representative for new payment/shipment/invoice/route/weather/zipcode batch integration/
ongoing data reporting and upstream order data integration in DW for retail giant in North America
• Built Enterprise Data Operations team from scratch in onsite/offshore model and owned daily data operations, batch monitoring, data quality
and process improvements for data warehouse business partners serving 24x7x365 leadership SLA for open for business and other critical
data metrics like google analytics, clickstream, eCommerce, transporttion, shipment, inventory, daily growth in customer and sales data,
high sales peak period batch monitoring and change management with 5000 user base for on premise data warehouse and cloud data lake
• Experienced in Agile Scrum and Kanban pipeline build with new Jira instance setup, moving Excel based project management to Jira based
project management with custom Python code based timesheet management, OLTP backend system upgrade and day to day management,
new OLTP feature development, webp image conversion and data structure realignment for CDN deployment planning with 15 times
reduction in image storage space and 66% improvement in website loading time, Meta API and Google Tag Manager integration, SEO
improvement, no code self serve inventory management system deployment, system & data architecture build for host and guide integration,
new development server build, new OLTP development environment built, new Gitlab and Jenkins CI/CD pipeline setup, Power BI
dashboard build for expiring room price reporting, cron job and server email based reminder process, fullstack application wireframe
development using cloud tools and Apache/Python Django framework in hospitality sector for multi state homestay provider SaaS platfom
in India
• Experienced in new database server, legacy/PHP/Python based application server, ETL server setup and migration from Windows to
AIX/RHEL/CentOS Linux
• Experienced ETL Development using Informatica Powercenter 7.1-8.6-9.1 /Clover 4.6-4.8-5.1-5.6-5.11 / IBM Datastage 7.x-8.x-9.x-11.3
and databases like Oracle 9i-10g-11i-12c/DB2/SQL Server 2016/MySQL 5.x/ HP Vertica 9.2-9.3.1/Snowflake and scheduler tools like CA7-
Autosys-Robot-Control M
• Experienced in Enterprise ETL migration from Informatica Powercenter 8.6 to Datastage 9.x, ETL version upgrade from Datastage 9.x to
Datastage 11.3, Clover 5.1 to Clover 5.6 - Clover 5.6 to Clover 5.11, CA7 to Autosys scheduler migration, shared drive data movement to
low cost data center for cold storage and archival
• Experienced in Docker container based database, internal POC/test application setup