Summary
Overview
Work History
Education
Skills
Professional Summary
Certification
Tools
Domain
Timeline
Generic

Vijiraja Gopalan

Pembroke Pines

Summary

Seeking a challenging and responsible position in a leading IT firm to utilize and further enhance knowledge base as well as prove an asset to the organization's growth and success.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior Business Intelligence Developer

ChenMed LLC
11.2022 - Current
  • Standardized data definitions and metrics across the organization by establishing comprehensive data dictionaries, leading to more accurate reporting and analysis.
  • Designed and implemented end-to-end data pipelines using SSIS, Snowflake and SQL queries ensuring efficient data with ETL process.
  • Design and deliver reporting and analytics to support healthcare financial analysis on SQL and Snow flake platforms.
  • Implemented Analytical Data Model in Snow flake and providing insights by creating multiple dashboards in Power BI.
  • Collaborated with cross-functional teams to gather business requirements and translated them into effective BI solutions using Snowflake.
  • Developed custom ETL scripts to transform and clean raw data, improving data quality and integrity using SQL and Python Scripts.
  • Automated routine data tasks and processes, reducing manual effort and increasing overall efficiency using batch and Python Scripts.

Business Intelligence Specialist

NTT DATA Services
07.2022 - 11.2022
  • Design and deliver reporting and analytics to support healthcare analysis on no-sql/oracle/sql server platforms
  • Worked closely with team as BI Lead and design the data model/dashboards in Qlik Sense as per the Business requirements
  • Involved in Qlik Administration to setup/configure nodes and implement all the admin activities through admin console
  • Involved in Qlik N-Printing to generate reports in the form of Excel, Html, Word, PDF and Power Point presentation
  • Developed Mashup extensions for internal dashboards in Qlik and provided data insights to the Business
  • Created extracts using Informatica IDQ and analyze the data using Qlik Reporting
  • Created Scorecards and data profiling dashboards in Informatica IDQ for Data Quality/Governance team.

Systems Integration Specialist

NTT DATA Information Processing Services Pvt Ltd
11.2021 - 07.2022
  • Involved in support, maintenance and administrating the Business Intelligence Applications, system level security, system level performance monitoring and tuning and automation of production activities
  • Design and deliver reporting and analytics to support healthcare analysis on no-sql/oracle/sql server platforms
  • Worked closely with team as BI Lead and design the data model/dashboards in Qlik Sense as per the Business requirements
  • Involved in building Data extracts for high volume of Data using Qlikview and creating qvw's and qvd's
  • Involved in Qlik Administration to setup/configure nodes and implement all the admin activities through admin console
  • Involved in Qlik N-Printing to generate reports in the form of Excel, Html, Word, PDF and Power Point presentation
  • Developed Mashup extensions for internal dashboards in Qlik and provided data insights to the Business.

Senior Data Engineer

Ascendum Solutions India Pvt Ltd
06.2021 - 11.2021
  • Designing and developing enhancements for existing data warehouses and data marts using ETL (Extract, transform and Load) methodologies using SDLC and Agile methodologies
  • Involved in developing Power BI reports and dashboards from multiple data sources using data blending
  • Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers,etc
  • Also, using different transformation inside edit query into clean-up the data
  • Apply DAX functions to implement the Business rules on the data and develop Power BI reports based on the requirements
  • Worked closely with team as Module Lead and complete the projects within deadlines pertaining to design and development deliverables.

Systems Integration Senior Analyst

NTT DATA Global Delivery Services Private Limited
02.2019 - 06.2021
  • Involved in support, maintenance and administrating the Business Intelligence Applications, system level security, system level performance monitoring and tuning and automation of production activities
  • Design and deliver reporting and analytics to support healthcare analysis on no-sql/oracle/sql server platforms
  • Involved in creating Data Extracts using Oracle ODI using Packages and interfaces and adhoc reports using Mark Logic No SQL
  • Involved in building Data extracts for high volume of Data using Qlikview and creating qvw's and qvd's
  • Involved in Data Profiling the databases and create Dashboards and insights using Qlik Sense
  • Involved in Qlik Administration to setup/configure nodes and implement all the admin activities through admin console.

Associate Consultant

KPMG Global Services
05.2018 - 01.2019
  • Involved in Data Analysis and creating Tableau Dashboard as per requirements
  • Involved in Data Profiling the databases and create data insights for the Business
  • Part of Data Governance Team and proposed new Data Quality/Strategy solutions for the databases maintained for all the applications
  • Created Alteryx Workflows to automate and schedule the data load process
  • Created SOP's and design for Data Mart's for high volume of data
  • Involved in POC for use cases using Python Packages.

Product Support Tech Advisor 1

IMS Health Global Delivery Center
07.2017 - 05.2018
  • Involved in migration/upgrade and consolidation of Oracle Databases in all the applications
  • Involved in all major areas of application and worked closely with clients to establish problem specifications and requirements
  • Issue fixes reported by the user and involved in further enhancement
  • Proposed enhancement in Database and Application server consolidation
  • Involved in Data Analysis and creating Tableau Dashboard as per requirements.

Application Development Analyst

Accenture Solutions Private Limited
06.2014 - 06.2017
  • Worked as Application Analyst which involves in Development/Maintenance changes of the systems
  • Regular Service requests involved creation of adhoc reports using SQL queries and PL/SQL objects like Functions, Procedures, Cursors,etc
  • Worked on OBIEE Repository and BI Publisher to create adhoc reports as per Business requirements
  • Handling maintenance requests involving enhancements and bug fixes to end user applications
  • Involved in environment enhancement case studies, automation proposals and implementation of new versions of the applications supported
  • Involved in performance tuning and query optimization in Views and Packages
  • Involved in data integration/migration for application upgrade and unit testing
  • Involved in Functional and Technical Design Document Preparation & provided Walk through to the Business.

Education

Bachelor of Technology - Information Technology

Karpagam College of Engineering
Coimbatore, Tamil Nadu,India
04.2014

Skills

  • Qlik Sense
  • Power BI
  • Informatica IDQ
  • SQL
  • Python
  • Snowflake
  • Data Warehousing
  • Data Visualization

Professional Summary

  • A self-motivated & a result driven Business Intelligence Engineer, having 9+ years of total experience in delivering analysis involving large amount of data in Databases, Data Warehouses and BI Reporting.
  • Delivered data summaries and involved in data profiling to identify data anomalies and reports for Business Insights and recommendations regarding data-related decisions/projects.
  • Worked on building the data warehouses and developed analytical data models using Snowflake to provide data insights and decisions to the Business.
  • Worked on the Development/Maintenance of Dashboards containing high end visualizations using multiple BI Tools like Qlik Sense, Power BI, Tableau, and OBIEE.
  • Worked as a part of Development/ Production Support assignments of SQL, PL/SQL, SQL Server, Oracle Reports,
    UNIX which involved Maintenance, Code Modifications as well as Agile Development.
  • Have working knowledge in ETL Tools like Oracle ODI,SSIS,SSRS,Alteryx ,Informatica IDQ to transform and clean raw data, improving data quality ,integrity and data profiling .
  • Developed and automated routine data tasks and processes, reducing manual effort and increasing overall efficiency using through custom batch SQL Scripts and Python.
  • Worked as BI Lead by managing team and have collaboration with Business Analysts and Clients to fulfill their requirements.


Certification

  • Qlik Sense System Administrator Certification- February 2021 release
  • Analyzing and Visualizing Data with Microsoft Power BI
  • Coursera - Data Visualization and Communication with Tableau
  • Oracle Certified Associate Exam- 1Z0-051 Oracle Database: SQL Fundamentals I

Tools

TOAD, TOAD Data Point, SQL Developer, Microsoft SQL Server, Microsoft PDWs, Mark logic SQL, Oracle ODI, Informatica IDQ, Alteryx, OBIEE, Oracle BI Publisher, Tableau, Qlikview, Qlik Sense, Power BI, PL/SQL, Unix, Basics of Python, ITSM, Putty, JIRA, Service Now, HP ALM

Domain

  • Healthcare
  • Investment Banking
  • Communication, Media and Technology

Timeline

Senior Business Intelligence Developer

ChenMed LLC
11.2022 - Current

Business Intelligence Specialist

NTT DATA Services
07.2022 - 11.2022

Systems Integration Specialist

NTT DATA Information Processing Services Pvt Ltd
11.2021 - 07.2022

Senior Data Engineer

Ascendum Solutions India Pvt Ltd
06.2021 - 11.2021

Systems Integration Senior Analyst

NTT DATA Global Delivery Services Private Limited
02.2019 - 06.2021

Associate Consultant

KPMG Global Services
05.2018 - 01.2019

Product Support Tech Advisor 1

IMS Health Global Delivery Center
07.2017 - 05.2018

Application Development Analyst

Accenture Solutions Private Limited
06.2014 - 06.2017

Bachelor of Technology - Information Technology

Karpagam College of Engineering

Similar Profiles

CREATE PROFILE
Vijiraja Gopalan