Vinay Sequeira Email & Phone Number

Mumbai, MH, IN

Mumbai, Maharashtra, India

Greater New York City Area

Managed 14 team members to support 30 clients and 50 audit contractors on CMS’ Operational Analytics ApplicationProvided technical leadership to grow the CMS Contract helping win extension for cloud migration (18 months-$1.5 million) and contract renewal (3 years-$25 million)Implemented three-zone architecture, automated backups, multi-region disaster.

Greater New York City Area

Migrated CMS’ Operational Analytics Application from On Premises datacenter to AWS Cloud (70 TB of data)Provided solutions and strategy to resolve latency issues encountered during data migrationProjected, planned, controlled and tracked Annual AWS bill of $2.5 million USD

Greater New York City Area

Managed a team of 4 developers for CMS' Operational Analytics Contract across multiple program areas like Vendor Management, Policy Payment Reports, External Data Gathering Environment (EDGE), Re-Insurance, Risk Adjustment and Risk CorridorsDesigned and implemented a framework to convert XML files stored in Oracle blob columns into relational data and load.

Greater New York City Area

Performed data modeling and analysis, Designed and developed analytical reports for CMS Operational Analytics' Vendor Management Module in Oracle PL/SQL, Led 2 developers in supporting Vendor Management and Payment Reports Module

Mumbai Area, India

Managed 3 software developers on large data set enrichment operations; data modelling, database design, loading data, performing fuzzy lookups, rules-based classification, extracting reports and insights using SQL Server, Developed and Implemented Data cleansing and ETL routines for spend analysis using Talend Open Studio and SQL Server

Mumbai Area, India

Managed 7 developers supporting 3 clients (Equity Insurance, Service Insurance and Daimler Financial Services) across applications i.e. Data Warehousing, Documentation Engine and Legacy Application Maintenance, Provided daily updates to Client, Project Management, Resource Allocation, Capacity Planning.Resolved critical incidents, trained and mentored.

Mumbai Area, India

Led a team of 3 developers on building a data mart in Informatica and Oracle, Migrated Informatica PowerCenter/Oracle data warehouse to SSIS/SQL Server slashing annual license costs by 75%, Led Development on an SSIS project to build a new data warehouse, Trained and mentored developers on Data warehousing and SSIS

Mumbai Area, India

Worked on Informatica PowerCenter Version Upgrade project, Migrating ETL mappings and schedule from version 5 to version 7, Provided post-implementation support, designed and developed new analytic reports and data feedsSupported Motor Broking and Insurance Applications, worked on change requests, projects and performed code reviews

Mumbai Area, India

Underwent training in CGI proprietary legacy systems, UK based Insurer's Motor Insurance Broking Application, analyzed systems, performed code fixes, and resolved application bugs.

Mumbai

Provided billing and technical support to customers of a US based B2C website offering internet based fax solutions