Ram Godavarthi

Data Quality Consultant at BAR360 - Bringing the essence out of the Data
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Port Macquarie, New South Wales, Australia, AU
Languages
  • English -
  • Hindi -
  • Telugu -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • AWS Partner: Accreditation (Technical)
    Amazon Web Services (AWS)
    Oct, 2021
    - Nov, 2024
  • Talend Studio Explorer
    Talend
    Oct, 2020
    - Nov, 2024
  • EDB Postgres ADvanced Server 9.5 Associate
    Enterprise Db
    May, 2017
    - Nov, 2024
  • Hortonworks BigData Ecosystem
    Cloudera
    Jul, 2016
    - Nov, 2024
  • Microsoft Certified: Azure Administrator Associate
    Microsoft
    Dec, 2022
    - Nov, 2024
  • Microsoft Certified: Azure Data Engineer Associate
    Microsoft
    Dec, 2022
    - Nov, 2024
  • First Aid, Emergency Life Support & CPR
    St Johns Ambulance
    Apr, 2017
    - Nov, 2024
  • BigData101
    Big Data University
  • Data Science 101
    Big Data University
  • ITIL V3 Foundation
    ITIL Certified
  • LOMA 280 - Principles of Insurance
    LOMA
  • Sun Certified Java Programmer
    Sun Microsystems

Experience

  • BAR360 - Bringing the essence out of the Data
    • Australia
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Data Quality Consultant
      • Jun 2018 - Present

      Client: Essential EnergyProject: Regulatory Information Notices (RIN) OptimisationSummary: Essential energy provides regulatory reporting notices (RIN) to AER (Australia Energy Regulator) once every year in Oct. Approximately 40 authors (end users) work for around 3 months and contribute to this report through very complex processes by collating data from more than 30 different data sources. A lot of this data are handled manually, as a result there is very less confidence over the data and its quality. The RIN Optimisation project was kicked off to come up with a single data warehouse hosting this data and assess the quality of it across all possible dimensions, and then to automate the generation of all Rin reports using Talend ETL from the data warehouse. • Work with the SOlution Architects and perform a detailed study of system architecture and data framework of EE• Derive the data quality framework and do a PoC on few RIN tables using Microsoft DQS & Talend DQ• Generate a conceptual model for CIM (Common Information Model) and do a feasibility study to implement it in RIN automation• Document the data, logical & business rules for data quality and perform data quality assessment of all sanctioned data sources using appropriate technical solution (Talend DQ, SQL Server)• Build the custom data model for Data Quality specific to RIN tables holding the data quality results, along with the bad data mapped to each RIN table and subject area• Generate a data quality & data lineage dashboards on Power BI for Business users and Data Stewards to assess and take corrective actions• Build a data model to hold all the relevant metadata and dependencies for RIN tables and derive the control dashboard which shows the status of RIN reporting including interdependenciesTechnology used:Azure (IaaS) Data Lake with SQL Server 2016, Temporal tables in SQL Server, Talend ETL, Talend DQ, Power BI, Tibco Spotfire, Talend Management Console, ERWIN & SparkEA modeller Show less

    • BI Consultant
      • May 2017 - May 2018

      Client: Hyundai Mobis Parts AustraliaProject: Development & support of BI reporting solutions at Hyundai Mobis Summary: Development & Support of an end-to-end automated BI reporting solution for end users of Hyundai & KIA motors, giving them insights into the sales and inventory figures of the various automotive parts in the entire APAC region, using OpenText iHub & PowerBI.Responsibilities:• Understand the business data stored on the live system (DB2) and work with the business analyst & end users in identifying the KPIs and key measures• Model the OLAP datawarehouse with required dimensions and measures• Prepare SSIS ETL packages on SQL Server which would pull data from the live system into an OLAP datawarehouse• Maintain & Administer the OLAP database hosted on SQL Server 2014• Model and design SSAS cubes on SQL Server for analytics purposes• Use OpenText iHub and Power BI for designing and publishing reports and dashboards• Develop wrapper classes on C#.Net for interacting with OpenText RESTful services (REST API) on iHub portal• Develop JSPs for user interfaces to the OpenText & PowerBI reports• Develop java wrapper classes for providing interaction between iHub and portals• Design & Maintain the End User BI Portals which host the reports and dashboards• Develop AngularJS & Javascripts to integrate the dashboards into the BI portal webpages• Interact with OpenText & Microsoft support teams on regular basis in solving service issues and installing patch updates• Provide incident and problem management for BI portals and report usage• Provide support for batch jobs running on the OLAP database and BI systems• Regular maintenance on the iHub administration database hosted on PostgreSQL• User administration for iHub & PowerBI systems Tools Used: SQL Server 2014, DB2/400, PostgreSQL, SSIS, SSAS, SSRS, OpenText iHub, Power BI, Mi Platform UI , Angular JS, JavaScript, C#.Net, Java, JSP, WinSQL, AS/400, Visual Studio 2012, Eclipse IDE Show less

    • BI Consultant
      • Dec 2015 - Apr 2017

      Project: Fleet Office (AURORA) for Custom FleetThe project involved integration of a new Fleet management system called BYNX into their home-grown CMS. The reporting for the project was initiated as an open source BIRT. The key points were to have an Embedded reporting into their Fleet Management system, which was delivered using various API's and Web services.• Delivered integrated Reporting and Analytics using OpenText Reporting and Open source modules of BIRT• Built interactivity and customised the user experience with custom forms interacting with Reporting engine• Online viewing of reports was developed using Java Script API using HTML 5, CSS, JQuery, AngularJS, JSON, CMS and web DB interactions and the backend reports were developed using Delivery API (OpenText) with Spring, Hibernate and Java 7• Worked closely with clients Environment team in setting up multiple clustered services• Integrated OpenText, FileNet, CMS, EMS, and BYNX in cluster mode on Apache and WebSphere• Deployed dependent jars to Nexus server, from where Jenkins fetches the dependent jars• Documented integration process with Sequence, flow and other architecture diagrams• Implemented a standalone Scheduler using Control M, to generate reports using IDAPI, Spring- JPA• Discussions with enterprise, architects, Environment team, Application Development teams, Testing team, Helpdesk, Senior stake holders, delivery mangers, team leads, senior developers, heads of other departments and other senior members from the client company• Meeting clients on different project opportunities, gathering requirements, analyzing, and discussing on different target solutions, and preparing POCs• Meeting OEM vendors of BIRT such as Microfocus, Schneider Electric, IBM on usage of BIRT and the challenges faced by their clients• Preparing project estimates and necessary liaison with vendors and clients• Successfully delivered the Apache spark training at the Hortonworks Hadoop summit 2016 Melbourne Show less

  • Tata Consultancy Services
    • India
    • IT Services and IT Consulting
    • 700 & Above Employee
    • BI Analyst
      • Nov 2014 - Sep 2015

      Retirement Account MI, Lloyds Banking Group – Bristol, United Kingdom & Chennai, India.Role & Responsibilities:• Due-diligence of the technical architecture of the existing data systems and legacy MI system• Discuss with the enterprise architect team and understand the group architecture strategy and roadmaps• Instrumental in arriving at the data structures required to support the BI program and estimate the system capacity after discussions with the enterprise architects• Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the BI• Establish the ETL technical architecture and identify the suitable ETL and analysis tools• Worked with the group BI architects from other projects and defined BI strategy for Operations, Technical architecture, Hardware, Middleware & network requirements, Server & Client configurations• Produce architectural documentation for the BI solutions, Align with group architectural standards• Prepare backup, archival & recovery strategy and ensure it confirms with group security standards• Conducting Design walkthrough sessions with the Business SMEs, Enterprise architects, program manager and the BI reporting team and design signoff • Low Level Design for the reports identified for migration along with ad-hoc reporting requirements• Resolved semantic discrepancies in data definitions arising from multiple sources• Worked with the DBAs & developers for creation of staging databases, tables, stored procedures, DDL/DML triggers, views, functions, and cursors using T-SQL• Work with enterprise architect team regularly to determine space requirements• Work with the BI developers to arrive at the BI dependency plan, scheduling requirements to execute SSIS packages which were developed to update database objects and nightly loads of data• Work with the Data Warehousing teams & DBAs in understanding and finetuning the OLAP cubes Show less

    • Senior Developer
      • Sep 2013 - Nov 2014

      Workflow Automation Performance Reporting DashboardLloyds Banking GroupRole & Responsibilities:• Understand the existing reports on the legacy MI system• Understand the business requirements on the new reporting metrics and KPIs • Work with business analysts to validate the report layouts• Involved in database design and architecture of the application• Involved in creating technical design documents for the new dashboard application• Involved in changes to database and business layers• Dimensional data modelling using Star Schema for the various metrics related reports• Preparing SSIS packages to load from the legacy systems onto the new SQL server database• OLAP services & Intelligent cube design for advanced analytics and Trend analysis reporting• Report UI design specification to be used for report creation and testing• Deployment server configuration and running subscription services in various environments• Preparing SSRS reports from the SQL server database and deploying onto the dashboard• Updating the technical specification document with the reports added to the dashboard • Dashboard design--Utilised standard templates and added panels• Coordinating with test leads and testing teams• Unit/System Testing & validation of reports using Complex SQL, PL/SQL scripts• Raising change requests and liaising with release management teams in getting the same progressed • Provide handover to the application support teams with all necessary documents, knowledge repositories, and issue logsTechnology used:MSBI Suite (SSIS, SSRS), SQL Server 2008 R2, VB.Net, Visual Studio Data Tools, DB2, AWD, Pega, T-SQL, PL/SQL, JavaScript Show less

    • Technical Business Analyst, Developer
      • Jan 2013 - Sep 2013

      SAS to WPS MigrationLloyds Banking GroupProject Description:In order to reduce the license costs with SAS, LBG had decided to move all its SAS based systems to another SAS based platform, WPS. The vendor World Programming Ltd (WPL) would provide the necessary alternatives and frameworks to SAS compilers and screens. The core business logic written in SAS was not to be changed.Role & Responsibilities:• Work with the vendor WPL (World Programming System Limited) and perform requirement gathering from end-users on existing SAS applications (batch and interactive)• Due diligence and do ability for conversion of existing SAS components• Extensive requirement gathering from the end users• Documenting process documents for isolated systems with consultation from end users• Aided the lead developer with Impact analysis and preparing the Impact Analysis documents• Attending workshops with the vendor on solution design• Compiled the conversion document with help from vendor• Worked with the vendor World Programing System Limited (WPL) for conversion of SAS components• Coordinating the build and test phases with various teams across LBG (including bank)• Provided support for implementation and early/post life support of projectTechnology used:Base SAS, WPS, SAS Macros, Mainframe IXE framework, CICS, DB2, SAS EG Show less

    • Application Support Analyst
      • Jan 2009 - Jun 2013

      Application Support & Maintenance – SAS based applications, AWD (Workflow & Imaging)Scottish Widows PlcProject Description:Scottish Widows Plc is a leading Insurance and Pension provider in the United Kingdom. The project involved supporting and maintaining the production environments for all SAS based applications hosted on mainframes and also the workflow and Imaging software AWD. Role & Responsibilities:• Level 3 & 4 Application Support for SAS and Workflow based live applications for Scottish Widows Plc.• Operations – Monitoring the SAS batches and provide fixes (if any)• liaise with IT security teams and provide user access to SAS applications• Report extraction and data analysis using SQL Server Reporting Services (SSRS) • Overnight batch monitoring and support for critical batch abends• Incident Management – Handling high severity incidents and joining major incident calls• Problem Management – Deep dive into issues for root cause analysis, working with other teams to put a permanent fix in place• Change Management – Representing ADM in CAB meetings, assessing major changes to the infrastructure, reviewing change records raised by team, Change Champion for the team• Stakeholder Management - Provide regular updates to Service Management, Operation Support management and all stakeholders on regular basis• Vendor management – Regular catch up with AWD vendor DSTi to review the service provided for AWD and also to discuss any ongoing problem records / service tickets with the vendor• Offshore leverage – Ensuring offshore is provided with enough information to support the applications, and acting as their coordinator at onshore• Service Introduction – Assessing projects upon completion and entering post live support phase, estimating the support costs involvedTechnology used:AWD, AS/400, COBOL, Base SAS, SAS Macros, DB2/400, SQL Server, SSRS, Mainframes, JCL Show less

    • Technical SME, Developer
      • Oct 2011 - Jul 2012

      Workflow & Imaging Migration,Scottish Widows PlcProject Description:Workflow and Imaging is project which involves in decommissioning of AWD and migrating to PEGA. It involves modification of the systems which interact with AWD directly and migrating the AWD legacy data (which resides in DB2/400) to PEGA database. AWD is workflow system which is being used by 2000 plus users in Scottish widows. As part of this project, the data hosted on DB2/400 was to be migrated to Pega using staging databases on SQLL ServerRole & Responsibilities:• Onshore SPOC for migrating the technically related components of AWD to Pega• AWD technical SME for the migration project• Identified and documented the services and data to be migrated and any interdependencies• Responsible to manage and co-ordinate with the offshore team and to provide deliveries on time. • Creating and modifying necessary TSQL/PL-SQL scripts to extract data onto staging tables• Preparing SSIS packages for the tables to be extracted and loaded into the staging database on SQL Server• Creating and scheduling jobs on SQL Server Agent to run the packages and SQL scripts• Performing data cleansing on the staging database tables• Liaise with application support team regularly for validating the data extracted Technology used:AWD, AS/400, PL/SQL, SQL Server 2008, TSQL, UDB DB2 9.5, XML, Javascript, SSIS Show less

    • Application Support Analyst
      • Nov 2006 - Jan 2009

      Application Support & Maintenance – Ordinary Life Insurance Administration System (OLAS)Tata AIG Life Insurance Pvt. Ltd. Project Description:Tata AIG Life Insurance Pvt. Ltd. is a leading life Insurance and Unit Linked Insurance provider in India. The project involved supporting and maintaining the production environments for its policy administration system, OLAS and all other systems interacting with it. This system was rolled out from AIG Hong Kong recently and team had to work with AIG Hong Kong technical staff to understand the system functionalities and document the same. Team was responsible for supporting the overnight batches, performing health checks, documenting system design documents, ensuring the system availability, administering and authorising any changes to the system, identifying gaps in the systems and proactively propose enhancements etc. Role & Responsibilities:• Performing due diligence and participating in transition of application knowledge from customers• Ensuring the transition reaches steady state• Supporting the services on a 24 * 7 basis• Understanding the overnight batch flow on AS/400 (IBM I Series) and identification of improvements to it• Fine tuning of the overnight batches and various processes on the AS/400 (IBM I Series)• Automation of several recurring processes on intermediary systems• Visited various branch offices of Tata AIG Life Insurance Company Ltd to understand the system behaviour and identification of pain areas from various customers using the applications• Incident and problem management• Change management• Generation of Management Information reportsTechnology used:AS/400, COBOL/400, DB2/400, SQL, Java, Basic, Foxpro, HP SM7 Show less

Education

  • Jawaharlal Nehru Technological University
    Bachelor of Technology (B.Tech.), Computer Science and Engineering
    2002 - 2006

Community

You need to have a working account to view this content. Click here to join now