Ms Sql Power Bi

RAJKUMAR M

****************@*****.*** +1-949-***-**** California USA

Summary

With over 5 years of extensive experience in data analysis utilizing MS SQL, Tableau, Power BI, Snowflake, data modeling, business requirements, and technical documentation.

I have a robust background as a developer in the healthcare and banking industries.

My expertise includes working with Tableau Desktop and Tableau Server solutions within enterprise environments and administering databases like MS SQL and NoSQL databases such as MongoDB.

I am proficient in various database technologies, including MS SQL, Oracle SQL, PL/SQL, MongoDB, NoSQL, and DB Visualizer.

I have developed diverse visualizations such as bar charts, line charts, pie charts, maps, scatter plots, Gantt charts, bubble charts, histograms, bullets, heat maps, and highlight tables.

My strong experience with Agile SDLC methodologies includes writing user stories and participating in daily stand-up meetings.

I possess comprehensive knowledge of data visualization, specifically in designing and developing interactive Tableau dashboards.

I have experience creating DDL, DML, and transaction queries in SQL for Oracle databases and have been involved in different phases of the data visualization development lifecycle, from gathering requirements to testing and implementation.

My roles have encompassed gathering/analysis, design, development, testing, and production rollouts.

I have a solid background in Spark SQL and Python programming for data manipulation and analysis within the Databricks environment, where I have implemented data governance and security best practices to ensure compliance and data privacy.

My skills include predictive modeling, customer segmentation, and cross-department collaboration to ensure data accuracy and integrity.

I am proficient in analyzing missing data and dummy variables, exploring correlations through imputation methods such as iterative imputer using SAS and Python.

Additionally, I have utilized SAS for extensive data analysis, cleansing, and modeling, generating actionable insights through advanced statistical techniques.

I have created advanced statistical models using SAS to extract insights and trends, supporting data-driven decision-making.

My experience extends to cloud databases and data warehouses, including SQL Azure, Snowflake, and Google Cloud Big Query. I am familiar with fundamental Python libraries, including NumPy, Pandas, SciPy, and Matplotlib.

My responsibilities have included various data mapping activities from source systems to Teradata.

I have analyzed business requirements documents (BRD), functional requirements documents (FRD), test strategies, and test data preparation.

Additionally, I have coordinated user acceptance testing (UAT), prepared manuals, and trained business users.

I possess excellent communication, interpersonal, and analytical skills, with a strong ability to perform both as part of a team and individually.

Skills

Databases: MS SQL Server, MS Access, Oracle 18c, 19c, Teradata, MongoDB compass, No SQL Manager.

Programming Languages: C, Visual Basic, and C++, VB 16.0, SQL, Python

Operating Systems: Linux, UNIX, Windows

Project Management Tools: Google Shared Services,

Software: Microsoft Office (PowerPoint, Excel, Word and Access), Visio, SQL Reporting.

Google Tag Manager, Google Analytics, Ads

Methodology Agile, Waterfall, Scrum

Reporting Tools: Tableau, Power BI, Cognos, Snowflake, Splunk and Jupyter Notebook.

ETL Tools: INFORMATICA, SSIS, SSRs

Experience

02/2022 - Current

Universal Music Group

CALIFORNIA, USA

Sr Data Analyst /Python Developer

Worked with the Data Engineering team to analyze and validate large amounts of data in GCP Big query

Creating reports which use calculated fields, LODs, Groups, Sets, geo-coding and hierarchies using Tableau Desktop

Provided support in managing and maintaining digital analytics, opportunity identification and prioritization, hypothesis generation, test setup, and reporting

Responsible for reporting and analysis of digital platforms and marketing campaigns against a holistic set of KPIs and benchmarks

Collected and analyzed data from multiple sources such as customer databases, web analytics, market research, and surveys

Created reports and dashboards to track key performance indicators

Implementation of the Database Quality Assurance in Prod/Stage/Test/Dev environments using the SQL scripts

Leveraged SAS software to conduct comprehensive data analysis, including data cleaning, transformation, and statistical modeling

Developed and testing the Data Visualization Reports, Dashboards using Tableau based on user requirements

Overcame challenges like migrating the data from MS SQL to MongoDB

Worked on MongoDB environment and created a backup and recovery has performed

Handling the huge data by the XML format and provided it to the end users

Creating queries for source and target validation from various systems like SAP to GCP data lake for huge amounts of financial and raw data

Experienced in building and managing Databricks clusters in cloud environments such as AWS, Azure, and Google Cloud Platform, optimizing performance and resource utilization

Worked in the UMX project to create alerts and visualizations for users of an internal dashboarding application which displays Artists and Tracks statistics from various streaming platforms like Spotify, YouTube, Apple Music, and using Airflow, Python, SQL

Created reports for the A&R (Artist & Repertoire) and Marketing teams using SQL and Domo, through which the teams managed to sign new artists into the company and for collaboration purposes

Created SQL queries for schemas, views, stored procedures, and functions for data migration

Involved in the project from planning stage to pushing codes to production

Constructed and implemented multiple-table links requiring complex join statements

Created data pipelines using Python and Airflow to schedule queries, apply transformations, filters, preprocessing data, then pipelining data into the target database tables.

Environment: SQL, Tableau, Python, Visual Studio Code, XML, JSON, MS Office Suite - Excel, Domo, MongoDB, No SQL and GCP Big query.

07/2022 - 01/2023

CVS

TEXAS, USA

Sr Data Analyst /Tableau Developer

Worked in gathering cost optimization Business Requirements after interacting with the Manager and development team to build up a solution

Intake, load and integrate volumes of raw, complex health care data from various health plans and disparate sources

Reconciled a 50% discrepancy in client health plan cost after resolving complex data mapping issue

Creating graphs by using data blending, filters, actions, Hierarchies feature in Tableau

Developed and maintained data pipelines using SQL queries and Python scripts

Utilized analytic tools such as Power BI, Tableau, Spark, Splunk, and Jupyter notebooks to interpret data and draw meaningful insights

Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Geographic Map and Bar Charts, Tree Maps, Pie Chart, dual axis charts and developing attractive dashboards

Configuring Microsoft SQL server and identified the dimension, fact tables, and designed the data warehouse using star schema

Created and Configured Dimensions, Attributes, and Hierarchies using SQL Server Analysis Services (SSAS)

Developed and executed SAS programs to analyze large datasets, ensuring accuracy and efficiency in data processing

Converted reports into interactive dashboards in Tableau and Power BI that were presented to Business Users, Program Managers, and End Users

Responsible for creating and changing the visualizations in Tableau, Power BI reports and Dashboards on client requests

Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently

Involved in modeling activities that included building star schema as per the business requirements

Worked on building the SSIS packages to extract, to transform, and loading the data in database scheduled intervals and create Jobs in SQL Server Agent that would run regularly to Load data into the Database.

Environment: MS Excel, SQL Server 2014, T-SQL, SSIS, SSRS, Power BI Desktop, Tableau, MS Access, Snowflake.

04/2019 - 08/2021

Virtusa Corporation

INDIA

Data Analyst

Wrote a complex SQL, PL/SQL, Procedures, Functions, and Packages to validate data and testing process

Worked on Data Mining and data validation to ensure the accuracy of the data between the warehouse and source systems

Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment

Publish daily, weekly, and monthly reports to different management levels

Provided training and support to team members on SAS tools and techniques, fostering a culture of data-driven decision-making and continuous improvement

Implemented advanced statistical models using SAS to uncover trends, patterns, and correlations within large datasets enabling strategic planning and business optimization

Perform the data connection activities, visual analytics using Tableau

Creating reports which use calculated fields, LODs, combined field, bins, sets, geo coding and hierarchies using Tableau Desktop

Worked in generating and documenting Metadata while designing OLAP systems environment

Involved in data mapping document from source to target and the data quality assessments for the source data

Involved in development and implementation of SSIS, SSRS and SAS application solutions for various business units across the organization

Designed both NF data models for OLTP systems and dimensional data models using star and snowflake Schemas

Designed and Developed Oracle, and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing

Involved in Data profiling and performed Data Analysis based on the requirements, which helped in catching many Sourcing Issues upfront

Wrote DDL and DML statements for creating, alter tables and converting characters into numeric values

Developed and maintained data dictionary to create metadata reports for technical and business purpose

Involved in Normalization / De-normalization, Normal Form and database design methodology

Developed SQL queries, Ad Hoc for Extracting data from production databases to build data structures, reports.

Environment: SQL, PL/SQL, OLAP, OLTP, SSIS, SSRS,3NF, Tableau

08/2017 - 03/2019

Amazon Development Center

INDIA

Data Analyst (Intern)

Performed data analysis and data profiling using complex SQL on various sources systems and answered complex business questions by providing data to business users

Wrote SQL targeting performance and recommended to define indexes on the tables as per the requirement

Performed report validation writing SQL queries using TOAD on an Oracle database

Generated Data dictionary reports for publishing on the internal site and giving access to different users

Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for application

Developed Data Migration, Transformation and Cleansing rules for the Integration Architecture using OLTP

Performed data profiling in the source systems that are required for Data Marts

Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding

Worked with internal architects and assisted in the development of current and target state enterprise data architectures

Performed testing on a data warehouse platform, including data integrity and data validation

Analyzing complex business problems and issues using data from internal and external sources to provide insight to decision-makers

Worked with Data Analyst for requirements gathering business analysis and project coordination

Worked with business analyst to design weekly reports using combination of Crystal Reports

Applied various data mining techniques Linear Regression & Logistic Regression, classification, clustering

Produced report using SQL Server Reporting Services (SSRS) and creating various types of reports.

Environment: SQL, PL/SQL, TOAD, ORACLE, SSIS, SSRS.

Education and Training

05/2018

India

Bachelor of Science in Industrial Engineering

Vellore Institute of Technology

Certifications

Google Analytics Certification

Contact this candidate