Murali Swarna

ETL Informatica Data Governance Consultant at Ardor IT Solutions
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Nolensville, Tennessee, United States, US
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Ana Hodge

Murali is an amazing Informatica developer. When he first joined my team as a consultant, he required minimal training and knowledge transfer as he came prepared with an impressive skill set. Not only was his expertise in development showcased, he also displayed critical thinking and problem solving skills that proved to be invaluable. He will make a wonderful addition to any MDM or Data Management/Governance team.

Subramanyarao Yeleswaram

Murali has excellent skills in BI space Informaica ETL, IDQ, AWS Cloud, Tableauetc. He delivered few cortical projects in Nissan. He is very quick learner with no time he learnt new technologies in Nissan and implemented.

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

  • Tableau Analyst
    Tableau Software
    May, 2020
    - Nov, 2024
  • Amazon Web Services Cloud Practitioner
    Amazon Web Services (AWS)
    Apr, 2020
    - Nov, 2024
  • Amazon Web Services Solutions Architect Associate
    Amazon Web Services (AWS)
    Nov, 2020
    - Nov, 2024

Experience

  • Ardor IT Solutions
    • United States
    • IT Services and IT Consulting
    • 100 - 200 Employee
    • ETL Informatica Data Governance Consultant
      • Feb 2022 - Present

      Tools: Informatica, IDQ, Axon, DPM, CDQ, CAI, CDI and EDC Database: Azure Data Bricks, Data Lake, Azure SQL Developer • Experience in data profiling, data standardization and develop IDQ rules • Experience in creating data cataloging pipelines utilizing informatica EDC, AXON and IDQ • Experience in defining the roles and responsibilities for data governance stakeholders • Develop maintain and support application business glossary business intelligence data integration data modeling and database management resources in Informatica • Experience implementing AXON and EDC for creating business glossary and technical metadata along with data quality management in IDQ • Experience in DC, IDQ and Axon product installation. • Write, update, and maintain software codes and programs using Informatica IDQ, Axon and EDC Show less

  • Tech Mahindra
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Informatica Developer
      • Oct 2020 - Feb 2022

      Client: NissanProject: Custom and Trade MigrationDatabase : DB2(Mainframe), ADABAS, Oracle and AWS Postgre SQLTools: Informatica Power Center, Power Exchange and CleoNissan is moving the Customs and Trade compliance functionality to a SaaS based GTM solution. This will sunset the current applications in place that are a combination of legacy mainframe and client server technologies. The applications to be replaced with this new solution are NIS, CTC and MS-Access databases Development and testing ETL codes with Informatica and Oracle. Involved in Development activities according to the design documents, which should be in par with the client requirements. Creating ETL’s or mappings as per the business requirements. Create complex mappings, sessions, workflows for final installation and release to the client Reviewing the mapping and sessions and sequence of the workflows and sessions. Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data. Show less

    • AWS DI Technical Consultant
      • May 2020 - Sep 2020

      Client: Next EraTechnologies: AWS DMS, S3, Talend, ECS, ECR, SNS and Cloud Watch events.Contribution Data migrated from Oracle to Aurora using AWS DMS We have migrated 6 Oracle DB and 50 Tables using DMS SNS Notification’s, SNS topics and DMS event subscriptions enabled Enabled cloud watch logs and archived logs in S3 bucket. Enabled supplementary logs with help of DBA team’s Having knowledge on DMS endpoints

    • Business Intelligence Consultant
      • Oct 2019 - Apr 2020

      Client: NissanDatabase : Oracle and HiveTools: Tableau, Informatica IDQ, AXON, EDC, Bit Bucket and CleoProject: Service Workflow Suite – Bigdata Analytics ImplementationNissan has insourced all their data from various dealer management systems (Dealer Logix, Dealer FX, Maritz, LMS etc.) and landed it in their Bigdata environment to learn about various nuances at the processes being implemented at closely 300 dealerships. Nissan been able to replace manual analytics with automation from this project and using this data to implement machine learning in few use cases.Significant Deliveries:• 150 data pipelines from various DMS systems and few internal sources.• Data Modelling in Bigdata Environment and layered architecture to preserve all data and filter latest data for Analytics needs.• Data Quality measures using Informatica Data Quality Tools.• Implemented CI/CD pipelines in Bit Bucket from scratch.• Tableau Dashboards.• Implemented services to receive/expose Tire profile data & battery data in AWS.• Manage onshore & offshore development teams. Show less

    • Business Intelligence Consultant
      • Apr 2019 - Sep 2019

      Client: NissanDatabase : Oracle and HiveTools: Tableau, Informatica IDQ, AXON, EDC, Bit Bucket and CleoNissan is one of the largest manufacturing company in building cars and trucks. ICAR/NCAR is an application for which Nissan wants to build the visualizations in tableau. These reports are primarily deals with claims and incentive rates of each vehicle. The reports already built in BO. We have redesigned all ICAR/NCAR Reports to TableauNissan NCAR/ICAR Project - Redesigned ICAR NCAR Business objects reports into Tableau. Redesigned Business objects reports into Tableau (4 Dashboards). Enabled User filters for Dealer level security reports. Created action filters, scorecards using stack bars, bar graphs, scattered plots, geographical maps, grant charts using show me functionality, parameters and calculated sets for preparing dashboards and workbooks/sheets in Tableau. Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop. Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop Show less

    • Business Intelligence Consultant
      • Apr 2018 - Mar 2019

      Client: NissanDatabase : Oracle and HiveTools: Tableau, Informatica IDQ, EDC, Bit Bucket and CleoThe EQUIP TCS Data Quality Project Plan will provide a definition of the project, including the project’s goals and objectives. It is Web-based version of applications developed in collaboration with TCS/FQI and NNA-IS. These applications helps in tracking Data Quality for each attribute in the Ichigen Database against Warranty claims, Vehicle parts and Primary failed parts information across models. Specifically the new web-based form will utilize Informatica’s analyst and Data Quality to collect the data from the EQUIP DataMart, BDE and BIDW owned by TCS/FQI and Tableau for reporting functionality. Creating Data Quality Rules or mapplets as per the business requirements. Create complex Rules, profiles, scorecards for final installation and release to the client Reviewing the Scorecards and profiles. Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data. Designed, Developed and Implemented Tableau Business Intelligence reports Responsible for dashboard design, look and feel and development Combined data sources by joining multiple tables and used data blending Created Customized and Interactive dashboards using multiple data sources  Involved in production deployment planning and implementation. Show less

    • Informatica Developer
      • May 2017 - Mar 2018

      Client: TelenorIFRS15 is a new set of Financial Reporting Standards (IFRS15) that has been published by the International Accounting Standards Board (IASB) in May 2014. Companies in all industries and geographies are required to comply with new rules regarding the way revenues are recognized. Mandatory implementation date is 1.1.2018 with comparative 2017 figures. The accounting system should be IFRS 15 compliant to collect 2017 figures starting 1.1.2018 for reporting in 2018.Telenor BUs has selected vendor Legerity as provider of the new IFRS15 software solution that will enable Telenor to comply with the new IFRS15 regulation at a corporation level. Other business units in Telenor Group are also participating of setting up IFRS15 project organizations and system implementations that will support the group wide effort. Development and testing ETL codes with Informatica and Oracle. Involved in Development activities according to the design documents which should be in par with the client requirements. Creating ETL’s or mappings as per the business requirements. Create complex mappings, sessions, workflows for final installation and release to the client Reviewing the mapping and sessions and sequence of the workflows and sessions. Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data. Show less

    • Informatica production support
      • Nov 2016 - Apr 2017

      Clent: GEAPDWH Project basically deals in the finance domain of GE. The B2P corresponds to buy to pay. So all buy and payments related to any PO and Invoice is maintained in the project. The MENAT corresponds to Middle East and the Turkey region. There are 13 regions (GGO).The project generally deals in the AP and the PO module. Technically the subject areas are the Invoice Header, Invoice Line, and the Purchase order. Ideally for any B2P one PO header has many Invoice headers and one Invoice Header has many Invoice lines. But practically in normal scenario one PO header has many Invoice header and the vice versa is also true. So in a project scenario or even for our project we have resolved the conflict by introducing the PO line associated to the Invoice Line to Maintain the same granularity of the record. Show less

    • Business Intelligence Analyst
      • Apr 2014 - Oct 2016

      Client: MasterCardMasterCard is in the process of payments by promoting new, safer, and more convenient ways to pay, accelerating the displacement of cash and checks through electronic payments like credit cards, Debit cards.The Main purpose of this project is to implement the Business Intelligence Reporting System using WebFOCUS Reporting tool for all of their MasterCard transactions from various categories like tracking all the transactions done by mobile devices, other MasterCard devices, internet transactions, ATM machine transactions, etc. They are trying to implement some set of Reports which provides the information relevant to the specific category. Show less

  • Visteon Corporation
    • United States
    • Motor Vehicle Manufacturing
    • 700 & Above Employee
    • BI Application Software Spec
      • Jul 2010 - Jan 2014

      Visteon Corporation is a leading global automotive supplier involved in design, engineer and manufacture of innovative climate, interior, electronic and lighting products for vehicle manufacturers, and also provides a range of products and services to aftermarket customers. With corporate offices in Van Buren Township, Mich. (U.S.); Shanghai, China; and Kerpen, Germany; the company has more than 170 facilities in 24 countries and employs approximately 47,000 people. With the move toward greater plant autonomy, corporate speed, and flexibility comes the requirement to give people throughout Visteon the ability to access and report on data across any number of systems without having to depend on a centralized group. > Working on Visteon Internal Reports and involves development of reports in Webfocus 7.7.03 > Interface with business customers and management for scope, estimates, requirements and project deliverables. > Responsibilities Direct interaction with Customers, Requirements Analysis, Effort Estimation, Handling Technical issues, Performance Optimizations, Reviewing Presentation of dashboard reports > Supporting ETL Jobs to load data in Dataware housnig using IWAY DMC 7.7.02M > Scheduling ETL and WebFOCUS Jobs. > Creating dashboards. > Extensively working in developing UI Screens and reports. > Developing all materials related to UAT plan, test cases, and data in conjunction with input from users > Performing system testing. Show less

  • Ford Motor Company
    • United States
    • Motor Vehicle Manufacturing
    • 700 & Above Employee
    • WebFOCUS Developer
      • Jun 2009 - Jul 2010

      Worked at client location - Ford Motors converting existing Business Object reports to WebFocus reports. Performed Analysis of the existing Business Objects Universe and Report requirements. Developed Master Files and Business Views for the existing Universes in Business Objects. Designed and Developed BI reporting solutions (ad-hoc reporting, static reports, dashboards) for existing Business Objects reports. Scheduled Reports in Report Caster. Performed Unit Testing and developed Test strategy, Test Plan and Test Case documents.  Analysis of B.O Reports, Universe and Developing the Master File and Reports in WebFOCUS.  Developed functionality for printing the reports as per the user’s choice.  Designed and developed functionality of exporting the reports to different formats like HTML, DHTML, PDF, Excel.  Involved in designing TSD (Procedure Documents), Unit-Test cases, Checklist, Code Review Project 2: The EDW Business Owner Report details the relationship between the business owner(s) and the Databases and Data Objects (Tables, Views, Macros) they own in the EDW along with their associated Security Attributes.  Create Dashboard Applications, launch pages, and report in the WebFOCUS Managed Reporting Environment.  Interface with business customers and management for scope, estimates, requirements and project deliverables.  Developing all materials related to UAT plan, test cases, and data in conjunction with input from users.  Ensuring that all data is available for testing.  Creating Manifest for objects developed. Show less

  • Amtex Systems Inc.
    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Executive Solution Developer - WebFOCUS
      • Aug 2007 - Jun 2009

      Project1: Worked on Visteon Project which involved development of reports in Webfocus. Played a major part in data migration project from Flat files, Oracle, SAP, Progress/QAD, DB2 to Oracle and Excel using I-Way Datamigrator tool. Worked on Conversion Project ACE Hardware which involved development of reports in Webfocus using Focus Language core commands from existing in Micro strategy reports. Extensively worked in developing UI Screens and reports. Performed system testing. Project 2: Ace Hardware Corporation is the No.1 Hardware cooperative in US. This company are the manufacturers of Outdoor living, paints, home goods, electrical goods, hardware items etc. Ace data warehouse especially designed to maintain entire company’s data and to monitor the performance of the Business. The Main Intention of this project is to convert the reports which are already in Microstategy to WebFOCUS 7.1.4. Micro strategy Conversion – All Customers information and Sales information for department stores reports. Monthly Sales Contribution for Corp Stores, BIC Stores and All Other Stores. Closely inspect the MSI launch page and its instructions regarding parameter input some parameters are multi-select versus single select. This information is needed to Properly process the launch page variable values and have a direct effect on the utility procedures. The reporting tools provide on demand reports to business users who use the information to study service usage patterns, design more competitive, cost-effective services and improve customer service. Professional Development: Trained by IBI staff on WebFocus 7.6.4 and was awarded with Certificate of Achievement upon course completion for the following courses 351 - Building Reports with Report Painter. 354 - Building Reports with Report Painter. 360D-Managed Reporting Content Development with Developer studio. 361 -Managed Reporting Administration. 362 - Building a Web Focus Dashboard. Show less

Education

  • Anna University
    B.E, Electrical, Electronics and Communications Engineering
    2001 - 2005
  • Viveka nanda jr colleage
    Board of Intermediate, Maths, physics, chemistry
    1998 - 2000

Community

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