PRAVEENKUMAR Ramasamy

Working as Data Engineer for Maintaining,Enhancing and Modernize current Pre-Clinical Safety and Small Molecular Registration Data Warehouse in Research and Development Portfolio.Working closely with Data Scientists for creating Data Marts and Data Warehouses in On-Prem and Cloud.Design and Develop Data warehouse applications and ETL jobs in databases like Oracle, SQL Server and No SQL (using materialized views, packages, procedures, triggers, functions, synonyms etc.)
Responsible for having a concise understanding of the end-to-end operational data warehouses, including system integrations, data quality and harmonization rules, understanding of downstream information.
Design data model for data marts and warehouses using TOAD, Erwin data modeler and SQL Developer tools.
Expertise in advanced analytical SQL functions and performance tuning SQL queries.
Develop Unix shell scripts, Python and Java scripts for file/data processing activities.
Visualize data using business intelligence tools like QlikView, Spotfire etc.
Dedicated team player who can interface with stakeholders from variety of internal IT disciplines (DBAs, architects, data scientists, infrastructure teams).

Technologies/Tools:Oracle/AWS/Informatica

Domain:Automotive Manufacturer

Product Quality and Service Support(PQSS) Application is a combination of Dealer facing and Corporate users mainly deals with Service History, Warranty information , Special Service Campaigns, Technical Information Systems, Parts Recovery Systems, User Manual and Documentum with many internal data integration dependencies on Vehicle Data Warehouse, Customer Central, Claims Processing System, Toyota Motor Corporation,NHTSA,NAPO,Sirius XM,Q360 etc.

Roles and Responsibility

Acting as Application DBA/ETL lead by handling requests from Business, Application and Reporting Teams across all PQSS Applications along with working on Cloud Modernization Projects like GTS+,CAT,LEO as Data Engineer.

Engaging in Modernization of moving Applications from OnPrem to Cloud (AWS),activities includes Dynamo DB design, initial/incremental data migration from On-Prem to S3/Dynamo DB and data flow design in cloud using AWS services like Database Migration Service, Pipeline, Lambda, Streams,SQS etc

Participating in business requirements and functional requirements gathering, which involves review of existing systems configurations and operation methodologies as well as understanding evolving business needs.

Create database objects like tables, views, materialized views, procedures, functions, packages, trigger and synonyms etc.

Develop Informatica mappings including source to target flow for new business requirements and modify mappings in production to support Applications.

Coordinate with Operations team for migrating DB and ETL jobs to higher environments from Development for UAT/Production.

Responsible to improve database performance issues by performance tuning. Perform schema level and table level data refreshes from Production to lower environments.

Trouble shooting data reconciliation issues proactively.

Responsible to work with functional teams to make sure required data has been extracted, loaded, performed the unit testing and fixed the errors to meet requirements.

Weekly code review and promotion with every release.

Involved in Documentum application upgrade which includes VBlock to Exadata migration with 11g to 12c upgrade.

Effective planning of DB modernization like Exadata/Cloud migrations, upgrading to latest DB versions, parameterization and automation on DB jobs.

Technologies/Tools:Oracle, Oracle Warehouse Builder, Unix, Azure

Tryg Developed a new complex data flow for DK Fraud Detection Project using data from new source systems along with existing data from Large Datawarehouse system built using Data Vault model (Hub, Satellite and Links)

Roles and Responsibility

Involved in KT phase with client SME’s to understand the current architecture and data flow of Tryg legacy data warehouse.

Acted as Senior Data Warehouse developer by creating Mappings and Procedures

Acted as Data Analyst for implementing Fraud Detection project by extracting complex data structures, creating reports from the extracted data for Business users review.

Involved in POC for migrating on-premise (Oracle) OBIEE reports to Azure Cloud Power BI reports.

Created source and target transformations/mapping for ETL team.

Understanding the business functionality & Analysis of business requirements.

Review of the documents and ensure its prompt delivery to the Business for approval.

Built Automated tools on mappings and jobs creation.

Raised technical/functional risks/issues/concerns on regular basis with internal as well as external stakeholders in timely manner and provide regular technical updates about the project.

Learnt Data Vault modelling method which has been implemented in Data Warehouse

Technologies/Tools:Microsoft Sql Server, SSIS,Team Foundation Server

Domain:Insurance

Roles and Responsibility

Involved in Data Analyst role for extracting data from complex source systems by scheduling regular meetings with Business users and source system SME’s.

Prepared Source Target mapping document which will have the business logic need to be implemented, column name mappings etc. for ETL team.

Acted as DB developer by creating stored procedures which has been consumed by Application Team (Microsoft .Net) to build the front-end Application (called Global Placement Platform).

Handled Migration, Integration and maintenance of DB objects like Tables, Functions, Procedures from Development to Higher Environments using Microsoft Visual Studio’s Team Foundation Server.

Understanding the business functionality & Analysis of business requirements.

Review of the documents and ensure its prompt delivery to the Business for approval.

XML format data loading into Sql Server tables for Data Analysis.

Technologies/Tools:Microsoft Sql Server, Informatica

Domain:Healthcare

Roles and Responsibility

Involved in successful POC for Data gathering/mapping by comparing with other source systems which has been handled by other vendors and by scheduled meetings with Business Analyst/Client SME’s.

Involved in design and development of Stored procedures in Sql Server and Informatica mappings.

Prepared test data along with unit test cases and provided support for intermediate environment before implementing in Production environment.

Developed Jobs for historical and incremental loads.

Developed a new script to handle complex business and network rules which has been applied in existing Virginia source system but not applied in EPDSV2 system (in CFF file), hence new script has been developed to overcome gap on network related information of VA providers.

Handling the C2.0 activities of the project effectively like capturing the timelines, quality of delivery of each resources across cross functions involved in that project

Technologies/Tools:Teradata BTeq scripting,WLM

Domain:Healthcare

Roles and Responsibility

Involved in two releases with first release for performance improvement and second for enhancements in all subject areas

Handled the enhancement work in most of the subject areas (Medical, Provider &Stoploss) without impacting the performance and data quality.

Acquired extensive knowledge on all subject area (both data and scripts) in short span of time that helps prompt reply to queries raised by client.

Prepared Impact Analysis Documents on enhancements being made to ensure data quality and list down impacted jobs/objects.

Effectively communicated with Front end/Application team(Java) for data issues/queries from both sides to expedite the progress effectively.

Technologies/Tools:Oracle, Unix

Domain:Travel & Hospitality

Roles and Responsibility

Involved in preparing design document, impact analysis document, coding and Unit Testing.

Effectively analyzed, provided quick and permanent resolutions for the issues of varying severity.

Involved in Impact analysis of existing data granularity and new source system.

Pre-requisite and steps needed for production implementation has been handled such as if switch off or decommissioning not happened for existing system then DW jobs should accept data from both source systems.

Ownership of ETL activities and Working on Client requests about enhancements/ Modifications in the application

Analyzed ETL mappings, process flow, Oracle SQLs, Procedures and modified the same for performance enhancement.

Involved in Salesforce source system integration project with existing Legacy Data Warehouse.