Summary
Overview
Work History
Education
Skills
Certification
Hobbies
Languages
Timeline
Generic
RAVI S M

RAVI S M

Bengaluru

Summary

Experienced Data Architect with 17 years of expertise in developing data solutions for the energy, banking, and automotive industries. Skilled in Data Vault 2.0 design, dimensional modeling, and cloud migration, specifically with Snowflake. Proven leadership in overseeing onsite and offshore teams to meet technical needs and business goals. Proficient in data governance, utilizing Informatica tools for effective data quality processes, and promoting team growth to tackle changing business demands. Committed to delivering cutting-edge data strategies for improved operational efficiency and enhanced business intelligence.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Associate Principal

LTIMindtree
08.2024 - Current
  • Spearheading data modelling and analysis activities as a Data Architect.
  • Gathering requirements from the business owner and report owner.
  • Feasibility analysis and effort estimation for SOW and billing.
  • Sprint planning and backlog creation.
  • Profile the data sets to understand the business insights.
  • Leading the design and development of data flow.
  • Understanding the technical landscape of the client's technical eco-system and guide them towards their business goals.
  • Overseeing the transition of Enterprise reports from QlikView to Tableau and Power BI.
  • Creating data models for cloud migration to Snowflake.
  • Training and mentoring team members on Data Modeling and analysis.
  • Working closely with the Management on providing timely statuses.
  • Identifying or foreseeing the risks associated with the sprint or project phase and highlighting them beforehand.

Data and BI Lead

TotalEnergies
08.2022 - 07.2024
  • I work as a data management specialist in the energydomain.
  • Data warehousing, modelling, Data provisioning, Data integration, Data analysis and Data Governance are the areas of expertise.
  • I work on Power usage Forecasting, billing, invoicing and usage management.
  • Generating MI reports on billing and payments.
  • I design data marts and develop data pipelines using AWS, Snowflake, Snowpark, and Python.
  • I create proof of concepts and diagrammatic representations.
  • Additionally, I follow security best practices, handle application upgrades, and document design, development, deployment, and postproduction support.
  • Lastly, I establish standards and best practices for Python scripting and Snowflake.
  • The design also involves Data governance and data provisioning to the business users.

Technology Lead

Infosys
12.2014 - 07.2022
  • Company Overview: A leading specialist financial services group which makes loans, takes deposits, trades securities and provides advice and investment management solutions to a wide range of clients and is listed on the London Stock Exchange.
  • Performed the ETL Lead role at onsite location in the process of setting AIRB compliant Data warehouse for downstream reporting and analysis using the most advanced Data warehouse methodology called Data vault 2.0.
  • Understanding the requirements (Business Specifications) created technical specifications document for the offshore and onsite to coordinate and make them understand the technical design adhering to requirements.
  • Developed mappings, Mapping configurations and workflows in Informatica Power center.
  • Developed an incremental load logic mapping to update the target system and synchronize the data back in source with the target system.
  • Automated deployment process of packaging the Informatica and oracle code through GIT, TeamCity and then running the deployment through Octopus.
  • Co-ordinating with Business analysts in helping them analyze the data lineage and hence the continuous optimization and effective utilization source data for accurate reporting.
  • Worked on data governance activities of the project with data governance team.
  • Setting up human tasks in Data quality developer for data review of exception records from data stewards.
  • Mentoring team members and groom them up.
  • Lead the team from the front by taking ownership of Epic and user stories.
  • Data quality exceptions reporting set up automation through Oracle and Informatica.
  • A leading specialist financial services group which makes loans, takes deposits, trades securities and provides advice and investment management solutions to a wide range of clients and is listed on the London Stock Exchange.

Senior Software Developer

WIPRO TECHNOLOGIES
03.2011 - 11.2014
  • Company Overview: An American global advertising, marketing and corporate communications holding company, headquartered in New York City.
  • Lead the ETL Lead role at offshore location, understanding the requirements (Business Specifications) created ETL specs for the offshore to co-ordinate and make them understand the requirements.
  • Created Unit test plans and verified the test results.
  • Project requires Linux file pre-processing for all the incoming files and hence have to configure linux environment by writing shell scripts based on the requirement.
  • Has knowledge on AWK in unix.
  • Designed mappings to load stage, Dimension and fact tables in sequence.
  • Analyzed the data models of the source systems to develop comprehensive mapping specifications.
  • Designing a Database for the loading Staging Area.
  • Extracted data from SQL Server, Oracle, flat files to pull it into the Staging area.
  • Produced specifications for mapping from various source Systems to Data Warehouse.
  • Performed Informatica Administrator functions like creating repository, Groups Users, Folders, giving permissions on the folders to the users, taking backup of repositories, etc.
  • Extensively used Informatica client tools-Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager.
  • The objective is to extract data stored in different databases such as Oracle and to load finally into a single Data Warehouse as well as to provide data to upstream teams.
  • An American global advertising, marketing and corporate communications holding company, headquartered in New York City.

System Engineer

IBM
09.2010 - 03.2011
  • Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
  • Designed Batch Control process to run the Data Stage sequences in batches for restart ability and recoverability.
  • Writing ETL queries for the upstream and downstream documents according to the business rules.
  • Preparing Test data.
  • Running data stage jobs and master sequences.
  • Monitoring and raising bugs and fixing possible ones.
  • Taking necessary action in case of failure.
  • Created Test cases, Test plans, implement the solution with extensive documentation.
  • Initiated extensive documentation for the Production Support process improvements.
  • Created shell scripts in UNIX to automate batch jobs.
  • Efficiency displayed Team-coordination and ensuring customer satisfaction by providing extensive support.
  • Working with System Analysts to identify the proper sources for required data elements and to determine the accuracy of the data.
  • Assisting the systems analysts in source data analysis and in creation of the functional specification documents.

Consultant

Capgemini
06.2008 - 09.2010

Education

Bachelor of Engineering - Electronics And Communications Engineering

Dayananda Sagar College of Engineering
Bengaluru, India
06-2008

Skills

Data Warehousing
Data Management
Extract Transform Load (ETL)
Amazon Web Services
Automation
Data Quality
Data Vault Modeling

Data Cleansing

Data Migration

Data Profiling

Dimensional Modeling
Octopus Deploy
Teamcity
Data Analysis
Data Lineage
Deployment Automation
Git
Snowflake
Mentoring
Credit Risks
Risk Analysis
Modelling Skills
Python (Programming Language)
Data Integration
Data Mart
Data Pipelines

Innovation and creativity

Data-driven decision making

Operations management

Data Modeling
Shell Script
Test Planning
Business Communication
Cloud Computing
Data Architecture
Production Support
Customer Satisfaction
Coordination Skills
Gitlab
Consulting
Scheduling
Business Requirements Gathering

Certification

  • AWS Certified Cloud Practitioner
  • Snowpro Core- Snowflake

Hobbies

Playing Tennis

Football

Chess


Languages

English
Advanced (C1)
Hindi
Upper intermediate (B2)
kannada
Advanced (C1)

Timeline

Associate Principal

LTIMindtree
08.2024 - Current

Data and BI Lead

TotalEnergies
08.2022 - 07.2024

Technology Lead

Infosys
12.2014 - 07.2022

Senior Software Developer

WIPRO TECHNOLOGIES
03.2011 - 11.2014

System Engineer

IBM
09.2010 - 03.2011

Consultant

Capgemini
06.2008 - 09.2010

Bachelor of Engineering - Electronics And Communications Engineering

Dayananda Sagar College of Engineering

Similar Profiles

CREATE PROFILE
RAVI S M