Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Ramesh Chiran Musoor

Olathe

Summary

Dynamic Software Engineer with extensive experience at Oracle, specializing in Big Data and Data Management. Proven track record in developing efficient ETL processes and implementing CI/CD pipelines. Adept at SQL development and fostering collaboration across teams, driving successful project outcomes while ensuring data integrity and performance optimization.

Overview

16
16
years of professional experience

Work History

Software Engineer II

Oracle / Cerner
Kansas City
01.2013 - Current
  • Worked as a lead for the offshore team and third party consultants(Neal Analytics) towards implementation of Big Data and Data Management platform for Cerner’s corporate data (Finance Module)
  • Developed processing pipelines using Databricks (Python) with visualization in PowerBI.
  • Incorporated Continuous Integration/Continuous Delivery (CI/CD) process including unit testing with Devops, Git repo pipeline for build and deployment.
  • Spearheaded a project, actively participated in the requirement gathering with business users and solution designer, Functional and Technical design discussion with Knowledge Architect, split into stories and completed successfully.
  • Created and modified Informatica mappings to create dimensions, facts, bridges using Informatica Designer, to extract data from various sources like Oracle, Siebel, Remedy, Navigator, PeopleSoft, Flat files and send the data to downstream applications, ODS (using Golden Gate Replication)performing required transformation.
  • Designed and developed complex mappings using various Transformations like re-usable transformations, and Mappings/Mapplets, Unconnected/Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedures in Informatica.
  • Worked on OBIEE upgrade project, owned a module Smart View for office. Wrote blogs on how to use the plugin elaborately. Implemented and gave presentations to business users in the Data Con.
  • Created Dashboards and reports as per the requirement after modelling in OBIEE.
  • Supported on-call rotation- Monitoring Nightly job and solving issues on the fly. Worked with Oracle creating Service Requests and testing the solutions provided by Oracle engineers, identify the failures and log tickets on Remedy UI and defects on JIRA.
  • Worked on release coordination as a part of on call responsibilities, written implementation steps for all the stories part of the release for CSM’s and DBA’s to execute and move code to production.

SQL Developer

Cocacola
Atlanta
01.2012 - 01.2013
  • Created tables, views and user defined functions.
  • Created new SQL Procedures for WCPPT Interfaces and optimised existing procedures for better performance.
  • Worked on CTE to solve a complex problem the users were facing.
  • Generated a Consolidated Documentation for both Total Volume and Scaled Target Volume interfaces.
  • Developed an SSIS package as per the user requirements, worked on FTP task, File system task, For each loop Containers to achieve the desired result.
  • Modified and trouble shoot DTS and SSIS packages in case of job failure and performance issues.
  • Writing the Unit Test Cases & executing those Test cases.
  • Deploying the Code and setting up the servers deploy in DIT, SIT, Prod servers.

Software Developer

Alameda Alliance for Health
Alameda
01.2011 - 01.2012
  • Provide core input to the COB process to ensure data ownership and data integrity during the projects’ planning, requirements, design, and testing.
  • Designed and built infrastructure for SSIS and SSRS by using standard templates for all BI development.
  • Extensively worked on Variable, Package Configurations and dynamically creating the destinations to load the data.
  • Involved in Daily loads (full and incremental) into staging, troubleshooting process, issues and errors using SSIS.
  • Worked on a monthly Maternity report and manipulated the output text file.
  • Worked on Automate 6 and Automate 8 to schedule the packages and reports.

Software Developer

Hawaii Medical Services Association
Honolulu
01.2010 - 01.2011
  • Created tables, views, user defined data types, and user defined functions, stored procedures.
  • Modified all the stored procedures and views that were part of a change in business requirement.
  • Created SSRS reports as per the user requirements, extensively worked on Groupings and other techniques like drill down and drill through.
  • Worked on Crystal Reports to convert them to SSRS reports and do the necessary changes to the TSQL at the backend.
  • Modified a DTS and SSIS packages as per the user requirement.
  • Created reports in MS ACCESS which involved VBA coding.

Education

Masters - Computer Science

National University
San Diego, CA
03.2010

Bachelors of Engineering - Computer Science Engineering

Sathyabama Institute of Science and Technology
Chennai, India
05.2006

Skills

  • SQL Development
  • ETL Tools
  • Reporting & BI
  • Cloud Platforms
  • Streaming & Messaging
  • Big Data & Processing
  • Programming
  • Version Control & DevOps

Websites

Timeline

Software Engineer II

Oracle / Cerner
01.2013 - Current

SQL Developer

Cocacola
01.2012 - 01.2013

Software Developer

Alameda Alliance for Health
01.2011 - 01.2012

Software Developer

Hawaii Medical Services Association
01.2010 - 01.2011

Masters - Computer Science

National University

Bachelors of Engineering - Computer Science Engineering

Sathyabama Institute of Science and Technology

Similar Profiles

  • Sudhakara Shankara Shettara

    Sudhakara Shankara ShettaraSudhakara Shankara Shettara

    Senior Scrum Master/Agile Coach/RTE (SAFe) at Cerner Corporation (Oracle-Cerner)Senior Scrum Master/Agile Coach/RTE (SAFe) at Cerner Corporation (Oracle-Cerner)

  • Vivek Kulkarni

    Vivek KulkarniVivek Kulkarni

    Partnership Analyst I at Oracle Cerner(Previously known as Cerner Healthcare Solutions)Partnership Analyst I at Oracle Cerner(Previously known as Cerner Healthcare Solutions)

  • Pavan B V

    Pavan B VPavan B V

    Technical Support Engineer at Oracle Cerner CorporationTechnical Support Engineer at Oracle Cerner Corporation

  • JOANNA CHILDS

    JOANNA CHILDSJOANNA CHILDS

    Branch Office Administrator at Edward Jones / Long Wealth ManagementBranch Office Administrator at Edward Jones / Long Wealth Management

  • Triston Shelley

    Triston ShelleyTriston Shelley

    Outbound Supervisor at Turn5 IncOutbound Supervisor at Turn5 Inc

CREATE PROFILE