Summary
Overview
Work History
Education
Skills
Domain
PROFESSIONAL SUMMARY
TOOLS
Certification
Timeline
Generic
Vijiraja Gopalan

Vijiraja Gopalan

Miami,FL

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

8
8
years of professional experience
1
1
Certification

Work History

Business Intelligence Specialist

NTT DATA Services
Miami , FL, US
2022.07 - Current
  • 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
Bangalore , Karnataka, India
2021.11 - 2022.07
  • 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
Bangalore , Karnataka, India
2021.06 - 2021.11
  • 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
Bangalore , Karnataka, India
2019.02 - 2021.06
  • 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
Bangalore , Karnataka, India
2018.05 - 2019.01
  • 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
Bangalore , Karnataka, India
2017.07 - 2018.05
  • 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
Bangalore , Karnataka, India
2014.06 - 2017.06
  • 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,TamilNadu, India
04.2014

Skills

  • Qlik Sense
  • Informatica IDQ
  • SQL, Data Warehousing
  • Data Visualization

Domain

  • Healthcare
  • Investment Banking
  • Communication, Media and Technology

PROFESSIONAL SUMMARY

  • A self-motivated & a result driven Data Engineer, having 8+ years of total experience in delivering analysis involving large amount of data in Databases, Data Warehouses and BI Reporting.
  • Worked on the Development/Maintainence of Dashboards containing high end visualizations using multiple BI Tools like Qlik Sense, Power BI, Tableau, OBIEE.
  • 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 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, Alteryx and data profiling through Informatica IDQ.
  • Worked as BI Lead by managing team and have collaboration with Business Analysts and Clients to fulfill their requirements.
  • Have basic knowledge in Python and interest towards working on Cloud/Analytical tools.

TOOLS

  • DB: TOAD, TOAD Data Point, SQL Developer, Microsoft SQL Server,Microsoft PDWs, Marklogic SQL.
  • ETL: Oracle ODI, Informatica IDQ, Alteryx
  • BI Reporting: OBIEE, Oracle BI Publisher, Tableau, Qlikview, Qlik Sense, PowerBI
  • Scripting Languages: PL/SQL,Unix,Basics of Python
  • Agile Tools: ITSM, Putty, JIRA, Service Now, HP ALM

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

Timeline

Business Intelligence Specialist

NTT DATA Services
2022.07 - Current

Systems Integration Specialist

NTT DATA Information Processing Services Pvt Ltd
2021.11 - 2022.07

Senior Data Engineer

Ascendum Solutions India Pvt Ltd
2021.06 - 2021.11

Systems Integration Senior Analyst

NTT DATA Global Delivery Services Private Limited
2019.02 - 2021.06

Associate Consultant

KPMG Global Services
2018.05 - 2019.01

Product Support Tech Advisor 1

IMS Health Global Delivery Center
2017.07 - 2018.05

Application Development Analyst

Accenture Solutions Private Limited
2014.06 - 2017.06

Bachelor of Technology - Information Technology

Karpagam College of Engineering
  • 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
Vijiraja Gopalan