Vinay Ramidi

Experience

• 

  AP Online Limited

  Jan 2004 - Jan 2011

  Senior Software Engineer

  In this project my roles are combination of SQL/Oracle DBA role, SQL Developer role & SSIS/SSRS Developer role.Looking after daily backup and integrity checking on databases.Implemented failovers like log shipping, mirroring and replication.Managing 30 databases with largest size of 200 GB processing more than 1 million transactions in a month and automated most of the jobs to increased productivity.Monitoring query execution plans, creating new indexes and recreation of indexes and stored procedure to improve performanceGiving training to new Kiosks and guide those whenever they face functional and technical problems while doing the transactions.Building the good relationship with departments and updating their sites whenever they required which we maintain in our server.Granting / removing access for all databases for different users as per requirement.Conducting T-SQL programming and queries to perform day-to-day tasks including altering tables, creating indexes and stored procedures.Transferring data and job scheduling using linked servers.Utilising DTS Designer and wizard to extract, transform & consolidating the data from separate sources into single and multiple destinations.Writing stored procedures, triggers and user defined functions for automation.Interacting with developers, hands on programming experience with VB, .NET & ASP.Fixing SQL server blocking problem and several other issues related to sql server performance.Creating database backup plans and performed full, incremental and differential backups of database and transaction logs.While doing the transactions, if kiosk facing any problem solves that as and when required and same thing as to post in department database server without fail.Extracting data from multiple different data sources, applying the business rules and loading into Data Mart. Tunjukkan kurang

• 

  HANODALE

  Apr 2011 - Jan 2013

  Business Intelligence Consultant

  Worked for Denoso Database Upgrade Project. Migrated AS400 data, MS-Access, SQL Server 2000 and SQL Server 2005 into SQL Server 2008R2. Analysis the business flow from the Current ETL Processes (DTS & SSIS) and developing/rewriting SSIS packages into SQL Server 2008R2.Analysis & Proposed Implementation of Backup and ArchivingSQL Server 2008R2 Installation, Configuration and Security Schema ImplementationData Warehouse Design, Implementation & Tuning.SSIS Tuning, Testing, Scheduling and Deployment.Rewriting the Stored Procedures, Views and Tuning the Performance Designed SSRS reports for various KPI analyticsImplemented the High Availability techniques (Replication), Disaster Recovery and Maintenance Plan in the new system.Providing the technical support when ever have the problem.Also worked for TIMES DOT COM Client, CTrack Client, KoBank Client, BPHealthCare Client, MegaTrack Client, E@Works Client and also handled in house projects. Tunjukkan kurang

• 

  MIMOS Berhad

  Apr 2013 - now

  Data Warehouse Architect

  MIMOS BERHAD is the Malaysia's R&D Oranisation. Worked on different open source techologies like Pentaho Suit, Hadoop, Shell Scripting, Big data tools.Worked on Data Warehousing POCs on SOCSO, MyHDW, DOS and other Government Department Services. With this managed to get MyHDW project. Build Malysian Healthcare Data Warehouse system. Which is the trusted source of truth of comprehensive healthcare portal of Malaysia.The primary data sources are SMRP1.1 and SMRP 2.0 which includes Inpatients, Daycare and Labour Room of Malaysian Government Hospitals and Clinics. Build this system in 2 Phases. In the Phase 1 it has 2 iterations, 1st iteration is the historical data load which has healthcare information up to until Dec, 2016 and 2nd iteration is incremental data load which started from 1st Jan, 2017 until now. In the Phase 2, itegrated other source system of Outpatient, Clinical Support Services, Family Health, PRIS, NOR and Oral Health.Designed the Malaysian Health Reference Data Model (MyHRDM) by conducting the Workshops with Subject Mater Experts, define concepts and build the relations between the concepts. Designed the dimensional modelling (dimensions and facts) by using the Kimball dimensional modelling techniques. This model can be extendable for further phases.Preparing the ETL mapping documents and logic for all the stages which includes from source to ODS, ODS to staging and staging to dimensions and staging to facts. Created the ETL framework, which can be easily organize and develop the ETL Jobs and ETL Transformations.Based on source to target mapping document and Architecture, guiding the ETL team in development activities and ETL testing team in their testing scripts.Implemented Error handling and Audit tables.Deployed and scheduled the Pentaho Jobs in Linux Server.Reviewing and testing the ETL team work, and resolving the development issues.Resolving Maintenance issues based on SLA Tunjukkan kurang