Umesh K. Email & Phone Number

Frisco, TX, US

San Antonio, Texas, US

Banking, Insurance, Investments.

Worldwide, OO

• Helping clients as a solutions architect for their Data & Analytics, CDP, and Marketing needs and eliciting functional, and non-functional requirements, and pain points. Asses & document the current state architecture.
• Building and designing composable & bundled dual zone CDP Architecture for several clients based on their customer insights, profiling, IDR, digital marketing analytics, segmentation, feedback, and activation.
• Refactored CDM/CDP design in Azure and GCP-based cloud platforms and services to serve customer requirements.
• Designed and developed SEO/AWS/Snowflake/AI/ML-based Search.AI Capability to enable Organic Search, Clustering, Forecasting, content planning, and mapping against web-crawling data for retail/e-commerce clients.
• Produced GPD cloud warehouse & analytical solutions design (including LDM, HLD, & LLD) and developed 2 use cases using Azure tech stack (Azure Data Factory, Event Hub, Functions, blobs, SQL Server, Databricks, Azure.
• As part of the Architectural Review Board (ARB) team, worked closely with peer architects to review and evaluate the key technology and system initiatives being used across the enterprise and train each other.

Berkeley Heights, NJ, US

• Managed & mentored technical teams (onsite/offshore) to adopt agile processes of building and delivering End Products. Provided technical leadership and hands-on implementation role in the areas of data integration and.
• Assess and created solutions design artifacts for the GB information portal requirement by adding the capability of Digital Transformation, Data Modernization, Self Service Analytics per Pharma Client requirements.
• Developed DI frameworks using Matillion, S3, Snowflake, and Data orchestration using Airflow, DQ framework using PySpark, Storage in S3, Snowflake, and assist Dev/BI team for powerBI and Tableau-based reporting and.
• Created Epic and features to test each framework functionality, use cases, Code and Performance review, and open issues tracking of GB-product, track open issues, and assign to offshore for fix and deployment.
• As Sr. Manager supported Pre-sales activities, SOW preparation, Estimation, and Scrum of Scrum activities.Tools & Technologies: AWS, Matillion, Snowflake, Agile Scrum of Scrum (SOS), Research & Development, Patient.

Bangalore, Karnataka, IN

Successfully delivered several projects with budgets of $1 - $15 million for S&P 500 clients such as - Client: Cigna Health, Plano USA – Onsite - Jan 2020 – July 2021Role: Data Integration ArchitectEnvironment: Informatica 10.4, Teradata, Window Power shell, MS SQL Server, GitHub, U deploy, Jenkins and AWS.

Teaneck, New Jersey, US

• Managed and supported 5+ data warehouse and integration applications from end-to-end delivery.
• Engaged with customer executives in quarterly business reviews to assess progress against the data integration strategy roadmap, and plan for subsequent quarters.
• Produced Conceptual, Logical, and Physical Data Models, Low Lever data flow design documents using Visio/Erwin.
• Designed and developed ETL Specs, Data Ingestion, and data recon framework using Informatica PWC, Oracle DB, and Unix Scripts along with unit testing, review, and deployment support.
• Support the BI team on Cognos reporting and analytics requirements. Tools & Technologies: Informatica PWC, Oracle Seibel, MS- SQL Server, Erwin, Unix Shell Scripting & Cognos.Clients: Merck

Mumbai, Maharashtra, IN

• Served India-based General and Life insurance client projects by analyzing their BI/MIS Reporting and Dashboard requirements, Designed and introduced a restructured and streamlined process for the data loading, data.
• Developed scalable on-prem based Data Integration and BI solution to serve the purpose of EDW/IDW applications using ETL (OWB, Informatica, SSIS), DB (Oracle, SQL Server, and DB2) with Unix scripting and.
• Developed job automation and data validation framework as a value adds to support data quality and performance tuning for high availability and error-free code. Tools & Technologies: Oracle Warehouse Builder (OWB).