Sql Server Data

KUMAR

**********@*****.*** 408-***-****

SUMMARY:

• Over 7+ years of IT experience in Design, Development, Integration, Implementation and Maintenance of MS Business

Intelligence, Informatica and Tableau Platforms.

• Having 4 years working with Tableau, creating visuals, building dashboards, and customization to meet needs of end-user

• Experience in configuring reports from different data sources using data blending esp. on Vertica, Teradata

• Extensive knowledge of Business Intelligence platforms and processes across Supply Chain, Finance, Insurance and Healthcare

industries

• Extensive experience on Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6/7/8.

• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, and Physical

and Logical data modeling

• Got trained about the future additions in Tableau 9. Active participant in Tableau User group meetings

• Well versed in query optimization for performance tuning and monitoring of processes.

• Extensive knowledge on visualization of data and knowledge of tools such as tableau.

• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc... Data visualizations and interactive

dashboard which helped business get a good handle on the team's productivity.

• Worked on different table calculations for different Scorecards.

• Worked closely with Tableau support team during tableau server upgrades to 8.1

• Worked on data blending and increased the dashboard performance by extracting data.

• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics

Reports.

• Deployed tableau server in clustered environment by adding worker machines

• Extensive Knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating users, sites and projects..

• Very good experience in Leader ship, SDLC process and agile – SCRUM, waterfall methodologies.

• Broad experience in resolving universe issues like Loops and Traps using Alias and context.

• In-depth knowledge in building/maintaining Repository, Universes and creating adhoc reports.

• Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports.

• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.

• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat

maps and Highlight tables.

• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008,

2005 and 2000.

• Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures,

constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.

• Hands on experience in Data warehousing development using ETL tools such as Informatica Power Center and developed

Informatica Mappings and Workflows with Worklets & Tasks using various Transformations for ETL of data from Multiple Sources to Data

Warehouse

• Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services

(SSRS).

• Good knowledge of Hadoop ecosystems, HDFS, Hive, Pig, Sqoop, Map Reduce, Flume, Oozie.

• Experience training end users through online and in-class sessions.

Tools Tableau Desktop 8.3/8.2/8.1/7/6, Tableau Server 8.2/7/6,Tableau Reader,

MicroStrategy 9.2.1/9.0.1/8.1.1/8.0.1 (Administrator, Desktop, Web, Architect), MS Office, SSIS, SSAS,

and SSRS. Informatica Powercenter 8.6, 9.1, Hadoop

Operating systems Windows XP, NT/2000, Windows Server 2003/2008, UNIX

KUMAR

**********@*****.*** 408-***-****

RDBMS Oracle 12C/ 11G/9.x, SQL Server, MS Access, Teradata 12.0, Vertica

SDLC Tools Perforce, Team Foundation Server (TFS)

Languages SQL, MySQL, MsSQL, HTML, C, Java Script

Methodologies Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

Work Experience

Sr. Tableau Developer/Admin eBay Inc., Milpitas, CA October, 2014 - Present

RESPONSIBILITIES:

• Installation and configuration of Tableau Server Cluster(Primary, Worker, Backup Primary) and its processes (SQL Server, Application

Server, Data Server, Data Engine, Background Tasks, and Repository). Configured SMTP, SSL and Windows AD.

• Handled Tableau admin activities like granting access, managing extracts, patches, upgrades and installations.

• Created users, groups and domains from Active Directory and created different license levels for each user.

• Took backup of the Tableau server on regular basis by using Tabcmd, Tabadmin commands also developed restoration procedures to

restore the server during system failures.

• Created extracts for improving the performance. Used different Mark types and Mark properties in views to provide better insight into

large data sets.

• Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views,

Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop to provide better data visualization.

• Worked in Migration project Tableau 7.0 to Tableau 8.0. Worked with the Tableau desktop users in migrating their local desktop

workbooks to Tableau 8.0.

• Created adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used

Excel, flat files, CSV files to create Tableau adhoc reports.

• Generated Tableau dashboards with combination charts. Used custom SQL connections, filters, quick filters, sets, parameters and

calculated fields within Tableau reports to facilitate automated data visualizations.

• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile

data.

• Involved in requirement gathering, reviewing requirements and data sources for design, development, and testing and production

rollover of reporting and data visualization projects using Tableau

• Performed super user trainings in Basic and Advanced Tableau Desktop. Participated and organized various super user symposiums to

promote the usage of Tableau

• Involved in Data extraction by Informatica which cloud is designed to support the delta changes.

• Interact with users and super users to gather requirements for reports and worked with the business intelligence team to develop

business critical reports.

• Understanding of Hadoop architecture and underlying framework

ENVIRONMENT: Tableau Desktop 7.x/8.x, Tableau Server 7.x/8.x, Tableau Reader 7.x/8.x, SQL Server 2005/2008/2012, Designer, BI,

Dashboard/Xcelsius, Informatica PowerCenter 9.1, Informatica cloud Scheduler, Crystal Reports 2008/2011, SQL.

Tableau Consultant/Admin MedImpact, Sandiego, CA August, 2012 – October, 2014

RESPONSIBILITIES:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me

functionality.

• Worked extensively with Advance analysis Actions, 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 7.0 in Dev, QA, UAT and Prod environments

KUMAR

**********@*****.*** 408-***-****

• Created incremental refreshes for data sources on Tableau server

• Installed patches on the server and documented upgrade plan from tableau 8.0 to 8.1

• 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.

• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard

reports, adhoc, business views along with user acceptance test and data accuracy test..

• Access dashboards from any browser or tablet.

•Involved in license management SLA's with Tableau support.

• Coordinated database middleware issues with DBA's, system performance with System Architects. Integrate with Vertica to utilize the

fast data engine to cross the barrier of 500,000 rows for optimum performance

• Extensively used Tabadmin and Tabcmd commands in creating backup's and restoring backup's of Tableau repository.

• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards

• Defined best practices for Tableau report development.

• Provided 24/7 production support for Tableau users

ENVIRONMENT: Tableau Desktop 8.0/7.0, Tableau server / Administrator, tabcmd, SQL developer, SQL 2012, Oracle 10g, DB2,

Informatica 8.6,9.1 Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Tableau Report Developer Allianz Life, Philadelphia, PA September, 2011 – August, 2012

RESPONSIBILITIES:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects

• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric

dashboards to Tableau application.

• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.

• Scheduled the published dashboards from Tableau Server on weekly basis.

• Sending the dashboards to users by emails with the help of admin team with subscriptions.

• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of

the universes using Business Objects Designer module during development.

• Given training/demos to users on Tableau Desktop for development.

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.

• Administered user groups and scheduled instances for reports in Tableau

• Administered user, user groups, and scheduled instances for reports in Tableau

• Built complex formulas in Tableau for various business calculations.

• Resolved various performance issues and analyzed the best process distribution for different projects.

ENVIRONMENT: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL Server

2008, Oracle 11g, Toad, MS Office, Visual Studio 2010.

Informatica Developer Wells Fargo, Charlotte, NC January, 2010 – August, 2011

RESPONSIBILITIES:

• Worked with business analysts to identify appropriate sources for Data warehouse and to document business needs for decision

support data.

• Extensively worked with the sources which are extracted from Oracle, Flat files and XML files.

• Star Schema was used to design the warehouse.

• Worked extensively on Source Analyzer, Mapping Designer, Target Designer and Transformation Developer.

• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.

• Extensively used almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sorter,

Sequence generator transformations for developing the mappings to apply the business logic.

• Designed, developed and deployed new data marts along with modifying existing marts to support additional business

requirements.

• Configured and used FTP connection on workflow manger to access source and target files.

KUMAR

**********@*****.*** 408-***-****

• Schedule, Run and Monitor sessions by using Informatica Scheduler.

• Used PL/SQL whenever necessary inside and outside the mappings.

• Created, launched & scheduled sessions and tasks. Involved in the performance tuning of Informatica mappings.

• Wrote PL/SQL Packages and stored procedures to implement business rules and validations.

• Utilized UNIX scripts to schedule the Informatica workflows, which were in turn used by the scheduling team to schedule the

workflows using the Control M.

• Migration of Informatica objects from Development to QA and from QA to production and setting up the UNIX directories for

Parameter files and Logs.

• Created Repository folders, User accounts and assigned privileges using Repository Manager.

• Closely interacted with the reporting team which uses Cognos for generation of reports.

ENVIRONMENT: Informatica 8.6.1/8.1, ORACLE 10g, UNIX, XML, Flat files, PL/SQL, TOAD, Cognos 8 BI (Report studio, Framework

Manager), Control M.

SQL/SSIS/SSRS Developer HCL Technologies, Chicago September, 2007 – December, 2009

RESPONSIBILITIES:

• Designed SSIS package to load customer information from flat files.

• Devised, developed and implemented disaster recovery and archiving procedures.

• Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate

technological innovations.

• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and

security breach.

• Create Work flow / Process flow documentation

• Design, Modify, Deploy and Tuning of reports using SSRS 2005

• Installed custom fonts for reports to use, troubleshooting and performance tuning of reports

• Creating Jobs, scheduling them and setting up email notifications when job fails by configuring database mail

• Loading flat and excel files in SSIS 2005

• Implemented SCD type 2

• Resolved various customer service issues on a daily basis

• Installation and Troubleshooting the installation of SQL Server 2005

• Performance tuning of SQL queries by analyzing the execution plans

• Design SSIS packages to download files from FTP, unzip them, decrypt, then load them in to our tables and move the files

to archiving folder

• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized

views for remote instance

• Successfully deployed SSIS Package 2008 into Production environment and used Package configuration to export various

package properties to make package environment independent during upgrade

ENVIRONMENT: SQL Server 2005,2008, SQL Server Integration Services 2005,2008, SQL Server Reporting Services 2005,2008, Oracle

9i, VB.NET, C#, ASP.NET, Microsoft Visual Studio 2003.

EDUCATION

Master of Science in Information Sciences, Governor State University

Contact this candidate