Data Developer

Name: Saketh

Ph.no: 312-***-****.

Mail id: ******.**********@*****.***

Professional Summary:

Over 5+ years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.

Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling

Extensive Experience in Tableau Desktop and Tableau Server in various versions of Tableau 6.0, 7.0, 8.0, 8.1, 8.2,8.3,9.0.3 as a Developer and Administrator.

Extensive experience in Installation, configuration, upgrade (simple Configuration, 3-server and 5-Server Cluster) and administration of Tableau Desktop/Server.

Solid understand of SQL and understand and have worked with various data source types like Oracle, Neteeza, SQL server.

Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management(Connections, Data Model, VizQL Model).

Skilled in Tableau Desktop for data visualization, Reporting and Analysis Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Used OData URL of Sales force connector table to connect to the Tables.

Experience in configuring reports from different data sources using data blending.

Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.

Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.

Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML

Improved Reports performance in tableau using extracts and context filters

Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables

Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production

Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

Designed and developed Applications in all the major versions of the PH and PH4, PH5

Experience on Object Oriented Programming (OOP) Concepts using PHP 5 and very strong SQL skills. Dealt With integrating PHP with database layers.

Experience with time-series data preffered.

Experience with Hive,spark,scala,R,matlabs.

Experience managing multiple,simulation projects.

Experience with practices of lean/agile ux.

Experience with bi tools like Tableau Desktop 8.1/7, Tableau Server 7, OBIEE 11g/10.1.3.4,

Experience in SAP BW BEX.

Technical Skills:

BI Tools:

Tableau Desktop 8.1/7, Tableau Server 7, OBIEE 11g/10.1.3.4,

ETL Tools:

Informatica 7.x/8.x (Power Center), Netezza, SAP HANA, and Hadoop.

RDBMS

Oracle 9i/10g/11g, MS SQL Server 2008, Teradata

Languages

HTML, XML, Python, Oracle.Java

Operating System

Windows 95/98/NT/2000/XP/7

FTP Tools

WinScp 5.X, FileZilla 3.5.x, Putty

Professional Experience:

Client: BlueCross BlueShield of Chico, CA April2015 - Till Date

Sr. Tableau Developer.

Responsibilities:

Develop various data connections from data source to Tableau Server for report and dashboard development

Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.

Combined visualizations into Interactive Dashboards and publish them to the web.

Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.

Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.

Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

Effectively used data blending, filters, actions, Hierarchies feature in tableau.

Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.

Ensured projects were completed on time and within budget.

Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.

Tableau server maintenance, Tableau server backup activity.

Consolidate multiple data silos that exist on campus to one location.

Scheduled data extracts on a daily basis.

Sophisticated stored procedures and triggers to provide complete technical solutions.

Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.

Resolved end user reporting problems through collaboration with IT and Operations.

Environment Support to User community, Service Request & Resolution.

Expertise in failed over activities in production Environments.

Involved in PHP, Javascript HTML and CSS.

I worked on XHTML, JavaScript, CSS, PHP MySQL,Agile/lean UX and gained experience with common

open source content management systems (Word Press, Drupal etc.), web design and coding standards.

I had exposure to technologies like PHP, ASP, JSP, HTML, JavaScript XML and Sql Server.

Development using PHP, HTML, CSS, JavaScript and Database Programming in MYSQL.

Environment: Windows XP, PHP. Tableau 8.1/7.0, Tableau Server,SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and JavaScript.

Client: Ingrame Micro, Reno, NV. AUG2013-Dec2014.

Tableau developer.

Responsibilities:

Gather and analyze the business requirements and then translate them to technical specifications.

Created different views in workbook to visually analyze data.

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

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

Created External filter, internal filter and Context filter to improve performance.

Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.

Created parameters and quick filters. Created sets to display top products based on their sale.

Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

Created Dashboards with interactive views, trends and drill downs.

Published Workbooks and Dashboards to the Tableau server.

Combined visualizations into Interactive Dashboards and publish them to the web.

Created groups and users in Tableau server

Used commands in Tabcmd and Tabadmin utility tool.

Migrated Workbooks and Dashboards from Tableau 7 to Tableau 8

Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.

Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau 7/8.0, Tableau 7 Desktop, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.

Client: Fannie Mae, Dallas, TX

Apr2012-July2013.

BI Consultant

Responsibilities:

Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.

Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.

Used MUD environment during development of the project.

Responsible for Creating the Physical Layer, Business Model and Mapping Layer and Presentation Layer in ANA Repository (.RPD) using Oracle BI Administration Tool.

Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions like Ago, To Date based on the Requirements.

Created Attributes and Metrics in the BMM layer.

Created Aggregated Tables to improve the Performance of the Reports.

Created Logical Tables, Logical Columns with Measures Calculated as per the Business need.

Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.

Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.

Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.

Created Business Model to support Ad hoc Reports for User Access based on Requirements.

Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.

Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.

Managed Security privileges for each subject area and dashboards according to user requirements.

Worked on Installation and up gradation of OBIEE 10.1.3.4.1 to 11.1.1.6.0.

Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations.

Used the Catalog manager and maintained the web catalog to manage Dashboards and Answers.

Test the reports and data in OBIEE against Micro strategy and validate them.

Responsible for documenting the OBIEE framework and track the progress.

Environment: OBI 10/11g, Informatica Power center 7.1.2/8.1,Oracle 11g, Microsoft Windows Server 2003, MS VISIO.

Viranchi Technologies, Hyderabad, India July 2011 – Aug 2012.

PL/SQL Developer

Responsibilities:

Created custom functions, stored procedures and packages to retrieve the data from tables.

Involved in creating synonyms to reduce the usage of base tables to securing the data.

Extensively used cursors, cursor for loops to fetch the data from different tables.

Involved in writing UNIX shell scripts.

Developed and deployed the User Interfaces using Oracle Developer 6i Forms.

Developed and deployed the reports using Developer 6i Reports.

Performed optimization of SQL queries (Used Explain Plan, TK-prof and Hints to tune SQL Queries.)

Environment: Oracle 8i, PL/SQL, Sun Solaris 5.0, Forms 4.5i, Reports 5, TOAD, SQL * Loader.

Contact this candidate