*Karthik Reddy*
*Sr. Tableau Developer/ Sr. Data Analyst*
*Phone No: **630-405-6452*
*Email: **s <surya...@outlook.com>chi...@neoprisminc.com
<chi...@neoprisminc.com>*
*Summary*
· Qualified professional with *8+ years* of extensive IT Experience
as a *Tableau Developer,* *Data Analyst, and Business Systems Analyst*
especially in Data Warehousing and Business Intelligence applications
in *Information
Security*, *Finance, Retail, Ecommerce*, and *Capital goods companies*.
· Extensively worked on *Tableau 9.x/8.x/7.x (Desktop, Server,
Mobile, and Public)*, *BusinessObjects,* *and Crystal Reports.*
· Expertise in BI/Data Warehousing concepts, designs, and project
implementations.
· Adept in business process improvement, re-engineering, change
request management, review process, and reporting escalation.
· Highly Proficient in *Agile*, *Test Driven*, *Iterative*, *Scrum*
and *Waterfall* *Software Development Life Cycle (SDLC).*
· Organized numerous *Joint Application developments (JAD)*, *Joint
Requirement Planning sessions (JRP),* Interviews, workshops and Requirement
Elicitation sessions with end-user/clients/stake holders, Subject Matter
Experts and the technology group.
· Strong understanding of *Data Warehouse *concepts,* Star Schema,
Snowflake Schema, *Business Process Analysis, Physical and Logical data
modeling.
· Hands on experience in *publishing* of various kinds of *interactive
dashboards*, and workbooks from Tableau Desktop to Tableau Servers.
· Highly proficient in design and development of *prototype
reports/ dashboards* in Tableau during the requirement gathering phase to
visualize the reports and clarify requirements.
· Expertise in *creating filters, quick filters, data source
filters, global filters, context filters, user filters* and *creating
Dashboards* for key Performance Indicators.
· Experience in creating Data Blending by merging data from
different datasets. Created visualizations using *Scatter plots, Gantt
Charts, Bubbles, **Geographic Map,** Histograms, Bullets, Heat maps
and **Density
Chart*.
· Expert in creating *Calculations* (*LOD,* *Cube Calculations,
Creating/using Parameters, Table Calculations, Totals*) and
*Formatting* (*Annotations,
Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting,
Shared Encoding*) using Tableau Desktop.
· Extensive experience in using *Tableau (Desktop/ Server),
Oracle, Teradata, Informatica Power Center, Business Objects Enterprise,
Business Objects Data Integrator, SQL Server, Oracle* *11g*, and *DB2*.
· Experience in *Normalization* and *De-Normalization* techniques
for both *OLTP *and* OLAP *systems in creating Database Objects like
tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
· Expertise in performance tuning of loading the *OLTP*
*Transactions* and *integration of the data into Data Warehouse (EDW)
*and *Data
Marts*.
· Experience in designing the data conversion strategy, development
of data mappings and the design of *Extraction, Transformation and Load
(ETL)* routines for migrating data from non-relational or source relational
to target relational.
· Expertise in writing *SQL Queries*, *Dynamic-queries*, and *complex
joins* for generating Complex Stored Procedures, User-defined Functions,
Views, Cursors and Triggers.
· *Flexible, enthusiastic* and project oriented *team player* with
excellent *communication skills* with leadership abilities to develop
creative solution for challenging requirement of client.
*Technical skills:*
*BI Tools *
Tableau( Desktop/Server/Mobile/Public) , Crystal Reports XI , XCelsius ,
Business Objects, Web Intelligence
*ETL Tools *
Informatica Power Center, SSIS, Teradata BTeq
*Databases*
Teradata, Oracle, SQL Server, DB2, MS-Access
*Database tools*
Teradata SQL Assistant, SQL Enterprise Manager, TOAD,
SQL Developer
*Applications*
Microsoft Office, ProClarity, AdobePhotoshop7, Adobe Illustrator, MS Visio
*Scripting Languages *
C, C++, HTML, SQL, PL/SQL, XML, VB
*Data Modeling Tools*
Power Designer, Erwin, ER Studio, MS Visio.
*Design/Version Control*
UML, Rational rose
*Operating Systems*
Windows Server 2000/2003/2008, Windows 98/2000/XP/VISTA/7, OS 400
* Professional work experience*
*LifeLock, Mountain View, CA
*
*September 2015 – Till Date Sr. Tableau Developer/ Sr. Data Analyst*
LifeLock is a leading provider of proactive identity theft
protection services for consumers and identity risk and credit worthiness
assessment for enterprises. The company is pioneer in identity protection,
leveraging unique data, science and patented technology and providing
identity threat detection, proactive identity alerts, and comprehensive
remediation services. The project is to contribute to the Reporting and
Analytics framework by defining KPIs, creating reports and dashboards that
are delivered on periodic basis (i.e., daily, weekly, monthly, quarterly,
etc.) and ad-hoc/ as-needed basis using Tableau.
* Responsibilities:*
● Worked with Business Users from different functional Units and
understand business challenges in terms of providing reporting solutions
across organization.
● Worked directly with BI Architect, Administrator, DW / DBA team and
Business Units to deliver solutions
● Updated BI Manager with any Reporting challenges and worked towards
creating solutions for the same.
● Prepared project reports for management and assisted the project
manager in the development of weekly and monthly status reports, policies
and procedures.
● Developed and maintained high level overview of the project and
design flows using MS Visio.
● Worked on Business Intelligence standardization to create database
layers with user friendly views in Teradata that can be used for
development of various Tableau reports/ dashboards.
● Designed, developed and published customized interactive reports and
dashboards using Tableau.
● Used Action filters, Parameters and LOD calculations, Quick Table
calculations, Sets, etc. for preparing dashboards and worksheets in
Tableau.
● Created Groups and Custom Hierarchies to meet the Business
requirement in Tableau.
● Effectively used data blending feature in tableau and defined best
practices for Tableau report development.
● Administered user, user groups, and scheduled instances for reports
in Tableau.
● Mastered the ability to design and deploy rich Graphic visualizations
with Drill Down and Drop down menu option and Parameterized using Tableau.
● Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps,
Filled Maps and Symbol Maps according to deliverable specifications.
● Consistently attended meetings with the Client subject matter experts
to acquire functional business requirements in order to build SQL queries
that would be used in dashboards to satisfy the business’s needs.
● Created various connections, Data foundations and Business layers
using Information Design Tool 4.1 (IDT) for AP Reporting.
● Converted WEBI Reports to Tableau Dashboards for Advanced
Visualizations.
● Developed formatted, complex reusable formula reports and reports
with advanced features such as conditional formatting, built-in/custom
functions usage, multiple grouping reports in Tableau.
● Executed and tested required queries and reports before publishing.
● Worked with Tableau administrator in managing Production, Test and
Development environments including installation of patches, security
administration and access controls in Tableau.
● Developed and reviewed SQL queries with use of joins clauses (inner,
left, right) in Tableau Desktop to validate static and dynamic data for
data validation.
● Performed data analysis on daily, weekly, and monthly scheduled
refresh of data based on that business or system change to ensure that the
published dashboards are displaying accurate and up-to-date information.
● Participated in weekly meetings, reviews, and user group meeting as
well as communicating with stakeholders and business groups.
● Provided support for Tableau developed objects and understand tool
administration.
*Environment: Tableau 9.x (Desktop./Sever), SAP Business Objects 4.1/4.0,
IDT, UDT, WEBI-BI: SAP BW Query Designer, Analyzer, Teradata, Oracle, SQL
Server, Teradata SQL Assistant, SQL Server Management Studio, Toad, SQL,
Microsoft Office Suite ( Word, Excel, PowerPoint, Visio).*
*First American Financials, Irvine, CA
*
*Jan 2014 – Aug 2015*
*Sr. Tableau Developer/ Sr. Data Analyst*
First American Financial Corporation provides financial
services through its Title Insurance and Services segment and its Specialty
Insurance segment. The Company’s core business lines include title
insurance and closing/settlement services; property data and automated
title plant records and images; home warranty products; property and
casualty insurance; and banking, trust and investment advisory services.
The project is to implement BI reporting solutions by creating reports,
dashboards, and scorecards in Tableau.
*Responsibilities:*
● Involved in defining the whole project life cycle, following RUP
methodology. Developed a vision plan that defined the primary goals and
objectives of the project. Analyze business requirements and segregated
them into high level and low level
● Actively involved in gathering requirements from end users, involved
in modifying various technical & functional specifications.
● Assisted Project Manager in developing design and specification,
according to the requirement and information gathered during JAD sessions
and other forms of information gathering methods.
● Implemented report development methodology for operational analytics
group.
● Provided business intelligence guidance to business operation analyst
groups.
● Created Tableau scorecards, dashboards using stack bars, bar graphs,
scattered plots, geographical maps, Gantt charts using show me
functionality.
● Prepared dashboards using calculated fields, parameters, groups, sets
and hierarchies.
● Creating data blending while designing a dashboard reading data from
different datasets.
● Extensively worked on Tableau dashboard and SQL query optimizations
and response monitoring.
● Used advance chart visualizations in Tableau like Dual Axis, Box
Plots, Bullet Graphs, Tree maps, Bubble Charts, Motion Charts, Water Fall
charts, funnel charts etc., to assist business users in solving complex
problems.
● Worked with Advance analysis Actions, Drill-Down Analysis,
Calculations, Parameters, Background images, Maps, Trend Lines, Statistics,
and Log Axes. Groups, hierarchies, Sets to create detail level summary
report and Dashboard using KPI’s
● Created and documented Standard Operating Procedures (SOP) for
Enterprise Monitoring.
● Installed Tableau Server 8.1 in Dev, QA, and Production environments.
● Deployment of Tableau reports, creating project folders and assigning
user/group permissions.
● Worked creating Aggregations, Calculated fields, Table calculations,
Totals, percentages using Key Performance Measures (KPI) and Measure.
● Utilized advance features of Tableau software like to link data from
different connections together on one dashboard and to filter data in
multiple views at once.
● Created actions in worksheets and dashboards for interactivity and to
compare data against different views.
● Created and managed tableau server groups and permissions.
● Assisted users to publish and collaborate reports via a web browser &
embed Tableau views in other web applications like SharePoint.
● Designed and developed aggregate data extracts for larger tables and
configured schedulers on the server to refresh the data.
● Restricted data for particular users using Row level security and
User filters.
● Consulting with business partners on reporting requirements and
deciding business strategies for slice and dice analysis.
● Responsible to facilitate load testing and benchmarking the developed
product with the set performance standards.
● Conduct demonstration for business users and interacted with end
users.
● Actively participated in clarification meeting with the Clients.
● Involved in Onsite & Offshore coordination to ensure the completeness
of Deliverables.
*Environment: Tableau Desktop 8.x/7.x( Desktop/ Server) , SQL developer,
SQL 2008, Oracle 10g, DB2, Microsoft Excel 2007, MS Access , Windows 2007
server, Microsoft office Suite ( Word, Excel, PowerPoint).*
*BJ's Wholesale Club, Westborough, MA*
*N*
*ov 2012 – December 2013 Data Analyst/Tableau Developer*
BJ’s Wholesale Club, Inc. is a leading operator of
membership warehouse clubs in the Eastern United States. The Company
currently operates 200 Clubs in 15 states from Maine to Florida and employs
more than 25,000 Team Members. The project is to implement Business
Intelligence Application to study the company’s performance across
various metrics by designing and creating Reports / Dashboards on customer,
supplier, Sales, and operations data using Tableau Reporting Services.
*Responsibilities:*
● Involved in creating dashboards by extracting data from different
sources.
● Created dashboard using parameters, sets, groups and calculations.
● Involved in creating interactive dashboard and applied actions
(filter, highlight and URL) to dashboard.
● Involved in creating calculated fields, mapping and hierarchies.
● Created drill through reports in dashboard.
● Involved in creating data blending in case of merging different
sources.
● Involved in creating a dual-axes bar chart with multiple measures.
● Involved in extraction, transformation and loading of data directly
from different source systems like flat files, Excel, Oracle and SQL Server.
● Working on generating various dashboards in Tableau Server using
different data sources such as Teradata, Oracle, and MS Excel.
● Extensively used data blending in Tableau.
● Performed Tableau type conversion functions when connected to
relational data sources.
● Maintained and Installed Tableau Server in all the environments.
● Created incremental refreshes for data sources on Tableau server.
● Monitored VizQL server, Application Server and data server activity
to track performance and system stability.
● Ability to authoring on Tableau server by changing mark types and
adding filters directly in a web browser.
● Administered user, user groups, and scheduled instances for reports
in Tableau.
● Hands-on development assisting users in creating and modifying
worksheets and data visualization dashboards.
● Created report schedules, data connections, projects, groups in
Tableau server.
● Extensively used Tabadmin and Tabcmd commands in creating backups and
restoring backups of Tableau repository.
● Involved in creating Stored Procedures, tables, and views for
applications.
● Involved in creation and updates of several SQL Index, Views, Complex
Stored Procedures, triggers and appropriate User defined functions.
● Documented complete server architecture and solutions to troubleshoot
performance, scheduling, and server related issues.
*Environment:** Tableau 8.x/7.x (Desktop, Server, Reader), Oracle,
Teradata, JavaScript API, SQL, Teradata SQL Assistant, Toad, UNIX, PUTTY,
Microsoft Office Suite (Word, Excel, PowerPoint). *
* Reputation Changer, Philadelphia, PA
*
*April 2011 – Oct 2012 Data Analyst/ Business Systems Analyst*
Reputation Changer is an American online reputation and brand
management company that provides internet search management by creating web
articles about its clients in order to have them overtake negative news,
and Wikipedia profile management. The project is to analyze existing BI
reports in Business Objects for various requirements and recreate the same
using Tableau Reporting Solutions.
*Responsibilities*
● Actively involved in gathering requirements from end users, involved
in modifying various technical & functional specifications.
● Gathered Business Requirements, Interacted with the Users, Project
Manager and SMEs to get a better understanding of the Business Processes.
● Developed and maintained data dictionary to create metadata reports
for technical and business purpose.
● Created action plans to track identified open issues and action items
related to the project.
● Designed complex risk reports, Score Cards, and Dash Boards using
BusinessObjects.
● Worked on exploring the dimensions such as Drill Down, Drill Up,
Drill down and up on nested categories, filtering the data etc.
● Designed filters, power prompts, and complex financial calculations
for various analytical reports.
● Analyzed various reports, dashboards, scorecards in BusinessObjects
and created the same using Tableau desktop server.
● Completed training in Tableau Desktop and Server.
● Designed and Developed various analytical reports from multiple data
sources by blending data on a single worksheet in Tableau Desktop
● Utilized advance features of Tableau software like to link data from
different connections together on one dashboard and to filter data in
multiple views at once.
● Created Prompts, customized Calculations, Conditions and Filter
(Local, Global) for various analytical reports and dashboards.
● Create and modify Interactive Dashboards and Creating guided
navigation links within Interactive Dashboards.
● Make use of filters and making them local and global accordingly.
● Publish the developed dashboard, reports on the Tableau Server so
that the end users having access to the server can view the data.
● Scheduled frequency and time to refresh data for the when sources are
publishes or extracted to server.
● Design and development of various reports and dashboards that can be
easily accessible through Tableau App in Ipads, iPhones, and other smart
mobile phones.
● Responsible to facilitate load testing and benchmarking the developed
product with the set performance standards.
● Actively participated in clarification meeting with the Clients.
● Created Test Cases and documented the Test Results.
● Involved in testing the SQL Scripts for report development, Tableau
reports, Dashboards, Scorecards and handled the performance issues
effectively.
● Involved in Onsite & Offshore coordination to ensure the completeness
of Deliverables.
*Environment: Tableau 7.x ( Desktop/Server) , BusinessObjects, Web
Intelligence, Teradata, Teradata SQL Assistant, Teradata Administrator,
SQL, PL/SQL, MS Project, HP Open View,*
*CNH Industrial,
Racine-WI
*
*Jan 2010 – March 2011*
*Data Analyst/ Business Systems Analyst*
CNH Industrial is an Italian company which through its various
businesses designs, produces, and sells agricultural and construction
equipment, trucks, commercial vehicles, buses, and special vehicles
(IVECO), in addition to power trains for industrial and marine applications
(FPT Industrial). It is present in all major markets worldwide. CNH
Industrial is focused on expanding its market through joint ventures. The
IT project at CNH is emphasized on various report related issues and fixes.
Design of Business Objects that is used for generating various reports,
dashboards related to customers, suppliers.
*Responsibilities:*
● Involved in Full life cycle design and development of Business
Objects Enterprise Applications
● Involved in gathering the requirements from Business Managers for
reports development
● Designed and developed Universes as per report requirements of
Business analysis
● Identified the Metrics and sub metrics, Key performance
indicators (KPI’s) for Dashboard development
● Worked on multiple data providers to develop the dashboards coming
from different sources
● Involved in bug fixing for invalid data flows, Work flows and
projects, testing of Stored Procedures and Functions, Testing of Data
Integrator jobs, and the Target Data Worked with Contexts and Aliases to
resolve the Loops in Universes
● Managed Users, Groups and their access privileges on the documents
● Extensively worked with BODI Transformations like Reverse Pivot, Map
Operation, Table Comparison, Effective Date, History Preserving, Row
Generation, Key Generation, Query, Case, Merge, and Pivot
● Modified the existing Universes by merging different Classes and
resolving the Loops and Chasm Traps by contexts
● Creating various UDF’s in the database for data retrieval in complex
reports
● Monitoring the daily job scripts for loading the data about business
transactions from source systems to EDW
● Designed Stored Procedures while generating the reports and tested
them against Oracle Database
● Identified critical areas of business risk and modified business
processes to reduce risk by using the Risk-Management Process
● Identifying & Managing risks, Resource analysis, Cost analysis, Post
project analysis & coordination among cross-functional teams & follow-up
with clients for settlement of project based issues
● Design, develop, test and enhance the Informatica mappings with
changes in the business requirements. Reverse engineer business
requirements from already developed mappings.
● Data Profiling to help identify patterns in the source data using SQL
and Informatica and thereby help improve quality of data and help business
to understand the converted data better to come up with accurate business
rules.
● Tuning SQL query performance, working with data warehouses, managing
metadata, and developing Web services using DB2
● Used Data Integrator Administrator for scheduling the jobs and
validation of the jobs before executing them
*Environment:** Business Objects Xi3.1, Xi r2, Crystal XCelsius 2008, QAAWS
,Designer, Desktop Intelligence, Web Intelligence, Oracle 9i, DB2,
Informatica Power Center, SQL Server 2005, Windows XP*
*CSG INTERNATIONAL, Bangalore ,
India *
*July 2008 – Dec2009 Business Objects (BOXI) Developer*
CSG International is a leading international financial services
organization. the company provide protection and wealth accumulation
products and services to the individual and the corporate customer around
the world. The project is to maintain Business Objects Infrastructure
hosting variety of BI capabilities for variety of Business units.
*Responsibilities:*
● Participated in project planning sessions with project
managers, business analysts and team members to
analyze business requirements and outline the proposed solution.
● Build the new universes as per the user requirements by identifying
the required tables from Data mart and by defining the universe connections.
● Used Derived tables to create the universe for best performance, and
use context and alias tables to solve the loops in Universe.
● Created complex reports stating revenue generation per year using
cascading and user objects like measure objects by using @aggregate_aware
function to create the summarized reports.
● Developed the reports in Reports Designer using Vertical stacked
chart, Pie Chart to view the quarterly metrics.
● Created parameter driven reports according to user requirements using
Web I.
● Developed the Quarterly Quality Metrics report for end users to view
Quarter wise using Drill Down feature.
● Generated Reports using the Universe as the main Data provider and
also using the personal data files provided by the users.
● Developed critical reports like drill down, Slice and Dice,
master/detail for analysis of parts benefits and headcount.
● Created complicated reports including sub-reports, graphical reports,
formula base and well-formatted reports according user requirements.
● Implemented Security Features of BusinessObjects like row
level, object level and report level to make the data secure.
● Provided the security access management by creating users/groups and
folders.
● Implemented the ETL process and business logic by using PL/SQL.
● Performed ETL coding using Hash file, Sequential file, Transformer,
Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively
used stages available to redesign Data stage jobs for performing the
required integration.
● Developed universe user documentation guide for the end users
reference.
● Adopt best in class practices and standards for development,
support, quality control and documentation.
● Provided training for end users for generating their own report
including complicated reports.
*Environment: BusinessObjects XIR2/6.5.1, Crystal Reports XIR2, Designer,
Desktop Intelligence, Web Intelligence, CMS, Oracle 9i, SQL, PL/SQL,
Windows XP.*
--
You received this message because you are subscribed to the Google Groups
"Companies Looking for IT Out Staffing & Recruitment" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to arunsinh+unsubscr...@googlegroups.com.
To post to this group, send email to arunsinh@googlegroups.com.
Visit this group at https://groups.google.com/group/arunsinh.
For more options, visit https://groups.google.com/d/optout.
