Chaitanya Mannem
Development
Singapore , Singapore
Skills
Data Engineering
About
Chaithanya Mannem's skills align with Database Specialists (Information and Communication Technology). Chaithanya also has skills associated with System Developers and Analysts (Information and Communication Technology). Chaithanya Mannem has 8 years of work experience.
View more
Work Experience
Sr ETL Developer
United Overseas Bank
December 2018 - March 2020
Senior System Analyst
IHIS
December 2016 - December 2018
- Technologies: Informatica9.1, 10.1, Oracle, Python, teradata PROJECT 1: Health Insights * Health Analytics is large data warehouse with multiple DataMart's provides data to various applications and users in multiple hospitals, CFOs across Singapore. PROJECT 2: RISK MANAGEMENT SYSTEM This project is about the extraction of information on diseases from different users from various institutions. We extract the Excel files and transpose the data using informatica into staging followed by facts and dimensions. Then create the reports for these facts and dimensions according to the requirement of the users. Roles and Responsibilities: * Developing ETL mappings. * Involved in source tables data profiling to design business logic and Creating mapping documents. * Creating informatica mappings to implement changesrequests. * Creating Analysis, Dashboards using Obiee. * Developing teradata procedures, fload, mload utilities in order to implement in informatica pipeline * Interacting with users to fix the issues in order to get UAT sign off. PROJECT 3: MOH DRUGS DISPENSED This area of project is about collection of drugs dispensed data on daily basis from multiple hospitals, Poly clinics across Singapore. Roles and Responsibilities: * Developing ETL mappings to extract and load the data-to-data warehouse. Generating files for users on a daily, monthly basis. * These ETL mappings in turn include many transformations like SQL Transformation etc. PROJECT 4: OPERATION THEATRE MANAGEMENT SYSTEM OTMS is a real time application which is used in various hospitals to track the information about surgeries at granular level which are planned, performed such as surgeon name, operation duration etc. PROJECT 5: CR IMPLEMENTATION In IHIS I worked on various projects, while working on a few implementations CRs that extract data from various source systems and loading transformed data into DW. This work involves my effective collection of information regarding a change required from the users and implementing them in the mapping level.
Senior Software Engineer
MAGNITUDE SOFTWARE (Noetix Analytics Hyderabad)
November 2011 - November 2016
- Technologies: Informatica9.1, Oracle, SQL server, Teradata, Noetix MDM, SAP BO, Linux Noetix Analytics is data Analytics solutions products built using Noetix MDM which generates dimensional MDM as per the third-party reporting tools like OBIEE (RPD file), SAP BO (Universe). * Worked on end-to-end development to deliver the customer requirements for each report. * Analyse the Source system data like EBS tables and comparing the DW tables mapping to match the requirement and enhance the code using Teradata scripts, oracle scripts to fill gaps that blocks the user report requirement. * Developing informatica mappings, teradata sql scripts, utilities. * Involved in data profiling to identify the source columns from business requirement.
Education
