Vinoth Sivaperumal

Developed and implemented a new data architecture standard resulting in a 25% increase in data accuracy and a 20% reduction in data processing time. Collaborated with stakeholders for a new product launch, defining data requirements leading to a successful launch with a 95% customer satisfaction rate. Designed and maintained highly scalable and secure databases leveraging AWS best practices and security configurations. Captured clickstream data from various websites and stored it in AWS S3 data storage via AWS Kinesis Firehouse. Integrated data from diverse sources using AWS services like AWS Kinesis, S3, and Lambda, ensuring data consistency, accuracy, and reliability. Established data governance policies and procedures aligned with AWS best practices and compliance regulations. Designed and implemented data solutions leveraging AWS services like Redshift, Aurora PostgreSQL, and S3 for scalability, cost-effectiveness, and advanced analytics capabilities.

Led the data modeling and database design for Medicaid MMIS system information, new implementation, and legacy eCAMS into Evobrix MMIS system. Developed database objects such as Packages, Procedures, Views, and Functions. Ensured adherence to Oracle PL/SQL coding standards and conducted internal code reviews. Rewrote database object code and SQL queries for performance tuning purposes. Participated in the design and development of provider enrollment, Member Enrollment, Managed Care, and Third-party Liability Insurance systems. Analyzed, designed, and developed the Claim Sure project to identify fraudulent claims submitted by Providers. Also, worked on the Audit Studio project to identify overutilized and maximally utilized insurance copy limits.

Participated in the database data modeling and data engineering/architecting for both Michigan and Washington State systems. Developed database objects such as Packages, Procedures, Views, and Functions. Ensured adherence to Oracle PL/SQL coding standards and conducted internal code reviews. Participated in the Claim Sure project to identify fraudulent claims submitted by Providers. Also, worked on the Audit Studio project to identify overutilized and maximally utilized insurance copy limits.

Conducted database data modeling, created Entity-Relationship Diagrams (ERD), and prepared Structures script based on requirements. Analyzed Business Requirements Documents (BRD) and performed analysis of database design and functional requirements. Developed database objects coding based on functional requirements, including Packages, Procedures, Functions, etc. Supported team members in addressing technical challenges within the project, providing assistance and guidance as needed. Worked on SEO (Search Engine Optimization) related tasks to improve the visibility and ranking of relevant content. Rewrote code and queries based on performance tuning requirements to optimize database performance.

Conducted Database Data Modeling, created Entity-Relationship Diagrams (ERD), and prepared Structures script based on requirements. Analyzed Functional Requirements Specifications (FRS) documents and performed analysis of database design and functional requirements. Developed database objects coding based on functional requirements, including Packages, Procedures, Functions, etc. Supported team members in addressing technical challenges within the project.

Analyzed Enhancement Requirement documents and performed analysis of database design and functional requirements to understand the scope of enhancements. Developed database objects and Oracle Forms coding based on functional requirements. Followed Oracle PL/SQL and Power Script Language coding standards to develop efficient and maintainable code. Provided support for other product databases such as MySQL and Sybase SQL Anywhere 7 Database, assisting with database-related tasks and troubleshooting issues as-needed.

Developed and maintained highly scalable and secure databases leveraging AWS best practices and security configurations. Captured clickstream data from various websites and stored it in AWS S3 data storage via AWS Kinesis Firehouse. Integrated data from diverse sources using AWS services like AWS Kinesis, S3, and Lambda, ensuring data consistency, accuracy, and reliability. Established data governance policies and procedures aligned with AWS best practices and compliance regulations. Designed and implemented data solutions leveraging AWS services like Redshift, Aurora PostgreSQL, and S3 for scalability, cost-effectiveness, and advanced analytics capabilities.

Led the development and implementation of a new data architecture standard resulting in a 25% increase in data accuracy and a 20% reduction in data processing time. Collaborated with stakeholders for a new product launch, defining data requirements leading to a successful launch with a 95% customer satisfaction rate.