JOHN JEYARAJ.S
Mobile: -/-
E-Mail:-
PROFESSIONAL OVERVIEW
Having 6 years of experience in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
Experienced in development and design of reports, dashboards and Advanced Visualization in Tableau Desktop and Tableau Server.
Hands on experience in Microsoft Office & Microsoft Excel
Hands- on with creating solution driven dashboards by developing different chart type including Geo Maps, Symbol Maps, pie charts, Bar charts, Tree maps, Gantts, Bubble Charts, Area Chars, Scatter Plot, Histogram in tableau 9.1
Database experience in Microsoft SQLSERVER 2008R2/2012 and Oracle 10g.
Hands on experience in ETL tools such as Microsoft SSIS 2012 and Shiloh Data Loading.
Hands on experience in Analysis tool such as Microsoft SSAS, Mondrian Schema OLAP.
Experienced in performance tuning and troubleshooting of reports and resolving issues with Tableau server and reports.
Created various Tableau Reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade,
and Parameterized reports that involved conditional formatting.
In depth knowledge of Software Development Life Cycle (SDLC).
Strong in Data warehousing concepts, Dimensional Star Schema and Snowflake Schema methodologies and proficient in understanding business processes / requirements and translating them into technical specifications.
Excellent problem solving, analytical ,interpersonal skills and ability to perform independently or as part of a team.
CAREER RECORD
Currently working in Data Semantics PVT LTD, Bangalore
Growth Path:
Previously worked with Software Paradigm Infotech., Mysore as Programmer Analyst
and Distil Information Pvt Ltd., Chennai as Software Engineer
PROFESSIONAL EXPERIENCE:
Employee – DataSemantics
Client: Philips
Role: ETL Expert
Customer Type: Healthcare
Responsibilities:
Extracting data from Salesforce to SQL Server 2012 using SSIS with Cozyroc Components.
Profiled data from the source, and transformed the data to meet the user’s requirement.
Reviewing and Testing Packages and Fixing Bugs.
Creating Data-Driven Packages in SSIS 2012 as part of the automating the process for the referral process.
Developing and optimized database structures, stored procedure, Dynamic Management views, DDL Triggers and user defined functions and SQL scripts for performing automation tasks
Working on the ETL documentation for the packages
Employer -Software Paradigm InfoTech, Programmer Analyst
Client: Energizer Battery
Role: Tableau Developer and Data Analyst (Microsoft SSIS & SSAS)
Customer Type: Retail
This project involved creation of the Tableau reports for Sales and Inventory which helps the business users to monitor the performance of the overall Sales business. Increased functionality made interaction with the reports easier and more efficient allowing users more time to react to the information presented.
Responsibilities:
Worked with advance analysis such as Table Calculations, Calculated fields such as KPI's using various functions (SUM, IF, MAX, MIN, AVG, ATTR, DATE Functions, etc), Parameters, Sets, Background Images, Logos, Totals, Forecast, Trend Lines, and Dual Axis to make robust reporting.
Generated Tableau Dashboards with various types of filters, parameters and calculated fields.
Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
Build complexity reports in advanced charts like Waterfall charts, Funnel charts, Bump charts, Control Charts
Effectively used data blending feature in Tableau when there were more than one database's involved
Involved in Technical design document such as Project Solution Document and Technical Scope Document
Created packages, Schedule and Manage ETL operations for Sales and Inventory using Microsoft SSIS.
Software Paradigm InfoTech, Programmer Analyst
Client :Hershey Kroger
Role : Data Analyst (Microsoft SSIS & SSAS)
Customer Type : Retail
The Hershey Company is the leading North American Manufacturer of quality chocolate and non-chocolate confectionery and chocolate-related grocery products. This project maintains Customer Details, Points of sales, seasonal sales and predictive analysis. The data is generated using ETL process to make it understandable
Responsibilities:
Involved in Technical design document such as Project Solution Document and Technical Scope Document
Built packages and Manage ETL operations for large data volume using Microsoft SSIS.
Excellent in High Level Design of SSIS Packages for integrating data using OLEDB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert , Merge and union all
Expert in creating Star schema & Snow flake schema cubes using SSAS.
Extensively worked on OLAP cubes using SSAS.
Created and Managed OLAP Cubes using SSAS.
Used Performance Point Server to create reports and dashboards.
Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes
Employer -Distil Information PVT LTD,
Client :Bugshan Group [AL-Talayi] - [Onsite]
Role : BI Consultant
Customer Type : Auto Mobile Industry
Bridgestone is a Tyre manufacturing company for heavy vehicles under the Bugshan Group, which has multiple branches and Regional in and around KSA. This project maintains Sales, Purchase (Supply Chain) and stock with lots of historical data. This project aims to verify the target sales and bonus on monthly, quarterly & yearly basis on regional and branches wise Information's. The data is generated using ETL process to make it understandable. The tool for ETL includes SSIS. The report will be in the form as per the user expectation and also effective in terms of data.
Responsibilities:
Interacted with the client to gather business requirements and functional analysis
Created Project Scope Document and Technical Solution Document
Built SSIS packages and Manage ETL operations for large data.
Developed and reviewed Cognos reports and also involved in Cognos portal development
Created data sources, managed and deployed content in IBM Cognos connection
Managed user access management in access manager
Worked as a SQL Server 2008 R2, ETL developer
Employer -Distil Information PVT LTD,
Client :Bugshan Group [AL-Athar]
Role : BI Consultant
Customer Type : Auto Mobile Industry
AL-Athar is a specialized in the distribution and promotion of quality international products in cosmetics, perfumery and luxury accessories. This project is to create number of dashboards and the reports to help the business users to monitor the performance of their overall sales and commission that deals with all the ERP Applications. This helped the business users to compare the last 10 years comparison sales and helped them to plan the budget for the future
Responsibilities:
Created dashboards which would depict the real usage of the sales and commission data in terms of Goal and Attainment
Created Alert reports for users and maintained the user privileges
Created the database structure based on the dimensions and measure
Client: SES [POC]
Role: Tableau Developer
Responsibilities:
Provided multiple demonstrations of tableau functionalities and efficient data visualizations approaches using Tableau to the Senior management at the Client
Designed and developed the most suitable User Interface such as Dashboards, Multiple Charts types, Trends, Custom requests for Excel Export and objects for Management Dashboard
Prepared complex Calculated fields for the business logic, Field Actions, Sets and Parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports
Prepared histograms, Pie Charts, Box Plots, Scatter Plots for inventory management, Background Maps illustrating the potential revenue change, destination flown across different geographic markets.
Client: Elixir [POC]
Role: Tableau Developer
Responsibilities:
Provided multiple demonstrations of tableau functionalities and efficient data visualizations approaches using Tableau to the Senior management at the Client
prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
Experienced in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles
Used Trend Lines, Reference Lines to describe the data
SCHOLASTICS
MCA : 2009
Bishop Heber College, Trichy, Tamil Nadu, India
BCA: 2003
St. Joseph College, Trichy, Tamil Nadu, India
PERSONAL DOSSIER
Date of Birth20th June 1986
Current Address238,Hanumappa road, New Tippasandra, Banglore, Karnataka
Languages KnownEnglish, Tamil
