Home

Vendhan Asokan - Data Architect

[email protected]

Location: Winston Salem, North Carolina, USA

Relocation: No

Visa: H4 EAD

Vendhan Asokan |Data Architecture & Analytics Enthusiast | |Digital Product Engineering | |Technology Leader & Solution Delivery Expert| Professional Summary With over 20+ years experience as a technology professional, I currently specialize in healthcare data frameworks as a Senior Data Architect. Key Achievements: #data-framework #de-identification-engine #workflow #manufacturing #subsetting #visualization Data Architecture Leadership: Pioneered the development of a robust #data-framework for healthcare data and analytics, resulting in a 65% increase in data accessibility and more informed decision-making. Strategically Developed DataMart s for High-Cost Claims and Appeals Reporting to support the creation of Machine Learning models. This #manufacturing initiative played a pivotal role in empowering senior leadership with data-driven insights, enabling informed decisions and significant cost-saving opportunities. Conducted Data Model Mapping to automate intricate #subsetting Workflows within complex Appeals and Claims Engines, such as FACETs, Mapping HEDIS Vendors to Applications. Resulting in a remarkable 99% reduction in setup delays associated with Member/Subscriber - Class Plan/Benefit, ICD9/ICD10 mappings. HEDIS Vendor File mapping (Dental, Member, Summary, Measure, Sub Measure, Result-set) Established robust metadata management protocols for Provider-Network DataMart s, significantly enhancing #visualization of Tableau reporting capabilities for new Provider information and Network mapping. Enhanced logical and physical data models for multiple data sources, facilitating streamlined data flow from Operational Data Stores to Claim Engines. These #workflow improvements resulted in optimized data management, heightened data quality, and reinforced data integrity. Complex Data Migration: Led a year-long initiative to orchestrate a tailored ETL (Extract, Transform, Load) solution for a significant bank merger. This #workflow involved intricate data conversion, including the transfer of Account and Customer Key data from the legacy bank to the new institution. The successful execution of this project facilitated the smooth operation of an OLTP (Online Transaction Processing) application, enabling real-time monitoring and reporting of Fraud & Anti-Money Laundering activities. Data Security: Oversaw the screening and audit of a unified #data-framework, serving as a #de-identification engine, to ensure zero leakage of PII, PHI to lower environments enterprise wide. Cloud Integration: Working exposure of #workflow with AWS (EC2 instances, Lambda, Health checks), Azure platform (Azure Databricks, Azure Data Factory, Azure Data Lake). Data-Driven Decision-Making: Utilized Tableau and Python to produce data processing #visualization and reports that empowered stakeholders, leading to a 20% increase in operational efficiency. Effective Communication: Specializing in #visualization of digital storytelling and delivering executive-level presentations that simplify complex technical concepts, facilitating informed, strategic decision-making for leadership. Academics: Class of 2017 Masters in computer science and information Technology (MCSIT), Winston Salem State University, NC, USA (3.96 GPA) Class of 2002 Master s degree in computer applications (MCA), Bharathidasan University, Tamil Nadu, India Class of 1998 Bachelor s degree in computer science (B.Sc.), The New College (Madras University), Chennai, Tamil Nadu, India. Technical Skills: Database Management Systems MS-SQL server (2016, 2014, 2012, 2008R2), Oracle (12c,11g,10g), AIX-UDB 9.x, Sybase 12.5, MongoDB, Postgres, NoSQL, Hadoop, MySQL DB Tools SSMS (SQL server Management Studio), SSDT (SQL server Data Tools), Toad Data Point, SQL developer, SQL plus Scripting Languages T-SQL, PL / SQL, SAS, Python, C/C++, Unix Shell scripting Data Integration SSIS, Azure Data Factory, Data Stage BI & Visualization Tools Tableau, Power BI Scheduling Tools SQL server Agent, Cron, Autosys, Lambda Code/ Doc Version Control Azure Dev Ops, Tortoise SVN, Git hub, Confluence, SharePoint, VSS Agile/Scrum Development Service Now, VSTS (Azure Dev Ops), Jira, Rally API - Web /Services Django, SOAP, REST services. Project Experience: Sr. Data Architect, Altius Technologies, Utah -USA May 23 ~ Till date o Analyze customer feedback data to improve product satisfaction. o Utilized advanced data analysis techniques to process and analyze diverse sets of customer feedback data. o Implemented data cleansing and preprocessing procedures to ensure data accuracy and reliability for analysis. o Applied machine learning algorithms to uncover patterns, trends, and correlations within the customer feedback data. o Developed visualizations to effectively communicate insights to stakeholders and drive informed decision-making. o Collaborated with cross-functional teams including product development and customer support to translate analysis findings into actionable strategies for improving product features and customer satisfaction. o Continuously monitored and evaluated feedback data trends to identify areas for optimization and refinement in product offerings. Sr. Data Architect, Office of Intelligent Automation CIGNA, CT- USA Jun 18 ~ Jan 23 Data Modeling Roles: o Conducted stakeholder interviews, gathering requirements from SMEs, Business Analysts, and other stakeholders, and subsequently translated these into detailed functional and non-functional requirements using workflow diagrams. o Extensive involvement in Data Modeling, System/Data Analysis, Design, and Development for both OLTP and OLAP. o Applied reverse engineering techniques to update data models based on new specifications. o Ensured referential integrity in OLTP data models for consistency and efficiency. o Developed data warehouse models, utilizing STAR schema for a more generalized approach, and implemented Snowflaking of dimensions to reduce redundancy. o Created data mapping, data governance, transformation, and cleaning rules for MDM architecture, spanning OLTP, ODS, and OLAP. o Collaborated closely with ETL, BI, and DBA teams to resolve data-related challenges during OLAP model implementation. o Structuring & Maintaining Data catalog, Knowledge Graphs, Data management. SME Roles: o Expertise in working in Provider, Network, Claims, Appeals areas in Healthcare / Insurance Domains. o Reviewed & Prepared Data Mappings from Source to Target applications for Over 40 + applications. (Ex. Appeals/Claim/Audit Platforms: FACETS, HEDIS, Vendor Files, ICD Codes) o Identify PII & PHI across DB s and Files and apply De-identification. o Participate in reviewing and resolving PHI issues in lower environments. Tools Evaluation o On the fly Data De-identification, Google Data Virtualization o Hyper Automation Tools: PDF to Text extraction, Machine Learning (exposure to NLP, Textract) o High-Cost Claims & Appeals, ICD9/ICD10 mappings - Machine Learning Tool implementation o Creation of Prototype designs Excellent Customer focus, attention to detail, research & analysis, ability to triage. Project Experience: (Cont.) Senior Lead Developer - Gamification of Courses (WSSU. NC - USA) Feb 16 ~ May 18 Environment: Python, Django, Lua, GIT, SVN, Trello, MySQL Preparing Specification documents Analyzing and implementing the enhancements Developing new interfaces for the system Design and Develop o Game elements such as badges, leaderboard, skills, levels, virtual currency, etc. o Evaluation elements - problem/questions include true/false, multiple choice, multiple answers, matching, and essay. Design, Development, Unit Testing & Bugs fixes SME / Lead Systems Engineer - SAS/ACTIMIZE AML Monitor Wells Fargo, NC - USA Sep 09 Jan 16 Environment: Search Space, Actimize, SAS-ECM, NICE-Actimize AML Monitor, SVN, Anthill, HP-ALM, Oracle, SQL Server, DB2-UDB, AIX, Linux Preparing Specification documents Analyzing and implementing the business enhancements (Ex. GAP analysis) Analysis on Alert dispositions, Identify false positives, Planning and Scoping of processes. Implementation and Enhancement of the existing system Participated in Actimize Product conversion assessment. Conversion of existing modules using Base SAS and SAS/Macros, SAS/ODS and SAS/SQL Extracting, manipulating data, and creating Data Sets from various sources like Excel, flat files, Teradata database, using PROC IMPORT techniques and SQL pass through facility. Involved in Search Space 6.2 and Actimize Product Support and Enhancement Implementation and Enhancement to the existing Autosys and Cron scheduling in the system. Involved in Code, Version maintenance and Release. Participated in Wachovia Wells Fargo Merger Activities Enhanced and effectively executed the region wise Bank Conversion and cleanup of modules involving millions of transactions and accounts. Successfully implemented in house UI/backend interface expansions. Wrote Performance tuned SQL queries to fix volume of data in Production without down time. Developing new interfaces to downstream systems Support to QA team for testing and validation Collection, centralization and understanding of users queries and issues. Queries and issues follow up, logging incidents. Maintained three environments (DEV, SIT/UAT, PROD) Synchronizing lower environments with PROD Senior Lead Developer - DSTi GEAM HiPerformance State Street Bank, MA - USA Sep 07 Aug 09 Environment: T-SQL, C/C++, Unix Internals, Informatica, Sybase 12.5, Solaris, Jira, SharePoint, Autosys Prepared Specification documents Analyzing and implementing the business enhancements Involved in DSTi HiPerformance Product Support and Enhancement Implementation and Enhancement to the existing Autosys scheduling in the system. Involved in Code, Version maintenance and Release. Used ETL methodologies for supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solution using Informatica Power Center, Power Exchange, Data Analyzer, Metadata Manager and Data Profiling Conducted 3 Releases at client location (HiPerformance V15.6.1, V15.7.1, and V15.8.1). Conducted Disaster Recovery Drills on Live environments. Maintained four environments (DEV, UAT, PROD, BCP) Project Experience: (Cont.) SMS/800 - MGI - DSMI, offshore India Mar 05 Aug 07 (ATOS Syntel Inc.) Environment: C/C++, SQL Server, Unix Internals, Tibco EMS, Oracle 10g, Solaris, Jira, Bugzilla, MS-VSS, Autosys Analyzing the existing system MGI/SCP Preparing specification documents Designing the Application Developing the application using C, C++, Unix Internals and Autosys Schedulers Interacting with the clients and team members to fulfill customer requirements. Documentation of the SMS/800 MGI Application Senior Software Lead Engineer - Artificial Intelligence Network - Alcatel, Texas - USA Nov 00 - Feb 05 worked in multiple projects for Client: Alcatel, Texas USA. with Axes Technologies (I) Pvt. Ltd., Chennai. (Now Tech Mahindra). Environment: Zilog8000, Java, C/C++, Shell Scripts, ClearCase, MS-Office, Sybase 12.5, Solaris Analyzing the existing system Preparing specification documents Developing and Supporting AIN application modules using Java, C, C++, Unix Internals, Tools for Version Control Interacting with the clients and team members to fulfill customer requirements. Documentation of the AIN Application development following ISO8001 process guidelines. Network Engineer / Systems Engineer - Axes Technologies (I) Pvt. Ltd May 99 - Nov 00 with Axes Technologies (I) Pvt. Ltd., Chennai, India (Now Tech Mahindra). Solaris/Linux/Citrix/Windows Server / Workstation Administration Network Administration and troubleshooting Developer Support and troubleshooting Server Administration, Server Backup and Maintenance ISO 9001 Documentation and Preventive Maintenance of Servers, Desktops and Network Keywords: cprogramm cplusplus quality analyst user interface business intelligence database hewlett packard microsoft procedural language Connecticut Delaware Massachusetts North Carolina South Carolina