Data Project

Jay

Mob: 862-***-****

Email: *****.*****@*****.***

Summary:

Over 7+ years of experience as a Software Engineer/ Consultant in the development of Data Warehousing and Reporting Solutions.

Experience in working with Tableau 9, Tableau 8.x, MSBI (SSRS, SSIS) SAP HANA.

Have good understanding of Relational Database concepts and possess strong knowledge in writing SQL queries in SAP HANA,Greenplum,Teradata, Oracle and Db2

Worked as a Tableau Developer as well as Tableau Administrator managing Projects, Users, Groups, Extracts, and Workbooks. Have provided End-to-End solutions on Tableau from Installation till deployment of Dashboards to users on Tableau Servers.

Good understanding and experience working in Waterfall, V-Model, Agile software development life cycles

Created, executed Test Sets and maintained documentation of test results using Quality Center.

Knowledge in JIRA

Business Skills/ Technical Skills:

Operating System

Windows 7 vista/XP/2000/NT/9x

RDBMS

Greenplum,DB2,Oracle 10g,Teradata,SQL Server 2000, SAP HANA

BI Tools

Tableau 9,Tableau 8.x( Desktop and Server),MSBI(SSRS,SSIS) Greenplum, HANA Modeling

Languages

SQL, PL/SQL, MDX and core Java

Web Technologies

HTML,DHTML,XML

Tools

Toad, PL/SQL Developer, SQL*plus, WINSQL, MS-VISIO, Share Point, Visual Source Safe 2005, Visual Studio 2005, MS Office 2007.

Education:

Master of Science in Information Technology from University Of Salford, United Kingdom.

Master In Computer Application from Bharathiyar University, India.

Bachelor of Science in Computer Science from Bharathiyar University, India.

Work Experience:

Project Name: Sourcing Knowledge Platform

Client: Walmart

Duration: June 2014-till date

Role: Tableau Developer

Location: Bentonville, AR

Software Used: Tableau 8.3, 9.0 Greenplum, SAP HANA

PROJECT DESCRIPTION:

This is an Analytical project for Walmart-US which provides sourcing information on whether the items are procured from Domestic or Import channel. Various analytical Dashboards were created in comparison to previous year to show the trend/pattern for KPI metrics like Sales, Retail cost, Maintained Margins etc by MTD and YTD across various channels, SBUs, Dept. & categories.

Responsibilities:

Created Tableau dashboards on Big data Analytics platform of Greenplum and SAP HANA broadly for two major business one providing the sourcing analytics for Pharmacy Domain and the other for General Merchandise.

Created Interactive dashboards combining multiple views pointing to different tables through Data Blending. Also created story boards on dashboards.

Worked closely with business users and gathered requirements from them, created technical specifications, estimation documents.

Created Created complex views using Table Functions, Dual axis charts, combination charts, applying various types of actions (filter, highlight, url).

Created geographic dashboards and used actions to display the drill through reports specific to the location selected on the map.

Created various types of filters, Context filter to improve performance, cascading quick filters.

Used parameters to filter across multiple data sources.

Imposed security at Dashboard level as well as implemented row level security in views.

Worked on migrating the Tableau Dashboards pointing from Greenplum to SAP HANA Datasource.

Create calculations including string manipulation, advanced arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.

Project Name: MVNO

Client: Phones4U

Duration: May 2012 to March 2014

Role: Junior Tableau Developer & Administrator

Location: Stoke-on-Trent, UK

Software Used: Tableau 8.0, 7.0, Oracle 11i, Excel

PROJECT DESCRIPTION:

This phase of the project will be to introduce a process that can be used by the retail estate to process applications to the MVNO upon selection of the MVNO from the network selection screen. If proven successful within the retail estate the network will then expand to the ECTS channels utilizing the APIs created for this phase

Responsibilities:

Worked closely with business users and gathered requirements from them, created technical specifications, estimation documents.

Created Data sources, Extracts, published data sources to tableau server, refreshed extract in Tableau server

Created different Interactive views with Quick Filters, Parameters, and Action filters to dynamically visualize and analyze the data.

Used different Mark properties in views to provide better insights into large data sets.

Created Interactive reporting dashboards by combining multiple views and published to Tableau Servers

Reshaping of data in Excel for use in tableau and creating dashboards using the same.

Performance tuning of Dashboards.

Embedding tableau views into PowerPoint for presenting them to Senior Management.

Project Name: Brite Phase 1

Client: British Gas

Duration: December 2011 to March 2012

Role: SSRS Developer

Location: Chennai

Software Used: MS SQL Server 2008/2005, SSIS 2008/2005

PROJECT DESCRIPTION:

To build an enterprise data warehouse for the Centrica - BGB to their Sales data and develop the BI reports for their business needs.

Responsibilities:

Involved in preparing technical specification document showing all the necessary steps to be taken for the project and scheduling Technical design meetings with team leader and manager. Involved in installation and configuration of MS SQL Server 2005 and 2008.

Modified the existing SSIS packages to meet the changes specified by the users.

Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes/key and SSIS Configuration Scripts.

Updated the existing stored procedures to eliminate cross server joins.

Involved in cleaning up and archive the redundant data from production server.

Maintained the table performance by following the tuning tips like normalization, creating Indexes.

Created Views as per the technical design.

Involved in developing ad-hoc queries.

Involved in Upgrading DTS packages to SSIS. Creating flowcharts for DTS packages for review.

Generated Complex reports like reports using Cascading parameters, Snapshot reports Drill- Down Reports, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on Business Requirement Document.

Project Name: LMP

Client: Chennai Silks

Duration: December 2006 to July 2008

Role: SSRS Developer

Location: Chennai

Software Used: MS SQL Server 2005, SSIS.

PROJECT DESCRIPTION:

The objective of the project is to develop a Loyalty Management Product (LMP). This Product is intended for retailers selling directly to consumers.

Responsibilities:

Transformed data from different data sources like different data bases to SQL Server 2005 using OLE DB connection providers by creating various SSIS packages. Data is transformed from hub (ODS) to data warehouse.

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for residential, business, large business users.

Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS.

Migrated the data from the appropriate databases to end database and maintained batch log files.

Involved in the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).

Implemented AD HOC reporting with the report builder for the end users.

Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.

Involved in identifying and creating data sources and data source views in SSAS.

Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.

Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.

Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.

Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.

Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.

Worked Extensively with the business, business analysts, or systems analysts to gather information needed to accurately triage and manage Online Help Desk incidents related to our SQL and .NET applications

Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of consumers.

Project Name: TMS

Client: KPN Travels

Duration: September 2005 to November 2006

Role: Test Analyst

Location: Chennai

Software Used: Excel

PROJECT DESCRIPTION:

The travel management system is basically used to manage the tours and travels details. The project maintains the customer ledger, login form, fuel details, general trip sheet and other travels trip sheet, owner details, owner statements, quotation outstation details, RC entry,To and Fro travels details, travel details, vehicle details and voucher details.

Responsibilities:

Preparing Test data, Test Scenarios and designing Test Cases.

Reviewing and executing Test Cases.

Defect logging and Defect Reporting.

Performing various types of testing like System Testing, System Integration Testing, Regression Testing and Browser Compatibility Testing.

Participating in daily scrums to report testing status and ongoing activities

Participation in sprint reviews & retrospective meetings for project improvements

Be the liaison between the business units, technology teams and support teams

Preparing Daily Status Report.

Contact this candidate