Technical Support Data

Sathya Subramanian

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

Skype Id: *.**********@*****.***

Contact No: 469-***-****

Visa Staus:Authorized to work for any employer (H4 EAD)

SYNOPSIS

3+ years as a Tableau Developer and Server Administrator

4 years in SAP Business Objects and Crystal Reports.

2 years as a Technical Support Engineer

Strong Exposure to Enterprise Data Warehousing (EDW), Strong understanding of Data Modeling and very good at Complex Data Analysis and Facts & Dimensions

Tableau Experience:

3+ years of Tableau experience with extensive knowledge as a Tableau Developer & Server Administrator with strong understanding of Tableau Architecture, providing the best practices for deployment and maintenance of Enterprise class dashboards on Tableau Server.

Extensively involved in design and development of Tableau visualization solutions using operational dashboards, reports, workbooks on various flavors of RDBMS like Oracle, MsAccess and MS SQL Server.

Very good at implementing Tableau visualizations and dashboard design with best practices to facilitate in-depth analytics and decision making among business users.

Tableau Server experience includes - configuration of Tableau software, setting, managing users, License Administration and Tableau Services.

Worked closely with Windows Admins and BI data teams to evaluate the Hardware and Software requirements to implement Tableau Software at Enterprise level.

Extensive experience in complex Data Analysis of large data sources, studying relationships among data tables to understand the data flow of various Businesses – Key for Report writing.

Very good at building custom SQL queries comprising of Aggregations, Hierarchies, and excellent in performance tuning.

Played many key roles in various stages- Reports developing, Testing, resolving data issues, Data modeling and complex Data analysis.

Active team player and individual with excellent communication, Interpersonal skills, self motivated, fast learner and good listener.

SAP BO Experience:

Solid experience in various versions- BO R2/6.x and all BO components- Web Intelligence (WEBI), Universe Designer, BI Launch Pad, Xcelsius, Desktop Intelligence, Promotion Manager, Publishing Wizard.

Excellent in BO reporting solutions using various flavors of RDBMS and SAP OLAP (BI/BW) databases.

Involved in heavy interaction with clients/end users, BI teams to analyze Business requirements, gathering reporting needs in order to process Business solutions effectively.

Extensively worked on Design and Developing Semantic Layer (BO Universes) with various functionalities like Aggregate navigation, row level and table level Securities, cascading LOV's.

Huge experience in creating Web Intelligence (WebI) reports for adhoc reporting and publishing them to BusinessObjects Enterprise.

Expertise in designing Complex Crystal Reports including Cross-tab, Conditional, Drill-down/summary, Top/Bottom N, multiple Subreports, Conditional formatting, Summaries and Complex formulae.

Good at creating Dynamic Cascading prompts, Business Views, List of Values (LOV’s).

Extensively worked in end-user requirements, business data requirements- studied, analyzed them.

TECHNICAL SKILLS

Tableau Software

Tableau Server, Tableau Desktop versions 10.x/9.0/8.x, Tableau Reader and various tableau files like .twb, .twbx, .tde, .tds

Other Business Intelligence tools

BusinessObjects R2/6.x, CMC, CCM, Crystal Reports for Enterprise 4.0, 2008/XI R2, Universe Designer, Web Intelligence, BI LaunchPad (InfoView), Crystal Xcelsius, Information Design Tool (IDT), Universe Designer, Business Analytics, Dashboard Manager, Live Office, SAP BO Explorer,Dimensional data modelling (Star and Snow flake schemas)

Databases & tools

Oracle 10g/8i, SQL Server 2008/2005/2000, MS Access

Programming & Scripting

SQL, PL/SQL

Operating Systems

Windows XP/2003/2000/NT/7/8/10pro/2003 Server

Ticketing Tools

Remedy,Service Now

EDUCATION

Bachelor of Engineering, Dept. of Information technology

Kerala, India.

Professional Experience:

Worked as a Tableau Developer in Vistra Energy,Irving,U.S.A on Tableau from (sep 2015-Till Date)

Worked as a Tableau Developer in HCL TECHNOLOGIES,INDIA on Tableau from (Jan 2013- Mar 2014)

Worked as an Application Specialist in Cranes Software International Ltd,INDIA on Business Objects from (Jan2011 – Dec 2012).

Worked as a SAP BO DEVELOPER in Unisys,INDIA on Business Objects from (Jan 2009–Dec 2010).

Worked as a Technical Support Engineer in CLI3L,INDIA from (sep2006-Dec2008)

Project:1

Organization: Vistra Energy,Dallas,U.S.A

Duration: Sep 2015-till date

Role:Tableau Developer

Vistra Energy is an electric utility company headquartered in Energy Plaza in Downtown, Dallas,Texas,United States.

The company traces its history to the beginnings of electric service in northern Texas.

Responsibilities:

Understand the customer requirements and technical specification documents.

Developed Tableau Dashboards for visualization solutions.

Responsible for interacting with stake holders, gathering requirements and managing delivery.

Developing data model to create reports and dashboards.

Worked on Individual Axis, Blended Axis and Dual Axis concept while working with reports.

Created Work sheet by using calculations and aggregations.

Created parameters using customized calculations.

Created reports using conditional formatting.

Involved in refreshing the Data Extracts and Auto updates in Dashboards.

Created Filters, Groups, Sets on Tableau Reports.

Worked with Live and Extract connection.

Publishing sheets and dashboards on server Using Tableau Desktop.

Developed complex reports and visualizations using Tableau Desktop as per requirements.

Created Cascading reports in Dashboard.

Created Tableau work sheets by connecting TDE.

Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).

Experienced with creation of Users, Groups, Projects, Workbooks and the appropriate permission sets for Tableau Server logons and security checks.

Created Parameters to achieve desired functionality.

Experienced in creating dashboards and various chart views in tableau.

Experienced in creating Filters, quick filters, table calculations, calculated measures and parameters.

Created Users, Groups and Set Permissions on Server.

Formatted the Reports as per the Client requirement.

ENVIRONMENT:Tableau Desktop, Tableau Server, SQL, Windows 10 pro

Project :2

Client:CNA Insurance,Chicago,U.S.A

Organization: HCL TECHNOLOGIES,INDIA

Duration: Jan2013-Mar2014

Role:Tableau Developer

Continental Assurance Company of North America was founded in Detroit in 1897. The purpose of the company was to provide accident and health insurance to railroad industry employees

Responsibilities:

Involved in gathering the requirements and analyzing the requirements and interact with the customer to find the proper information.

Responsible for Preparing the Report Design specifications based on the User’s requirement.

Extracted data from various sources and performed data blending.

Created different type of charts.

Created worksheets and dashboards by using custom queries and multiple tables.

Created various interactive customized dashboards and stories.

Applied various types filters like Data source filters, Quick filters and Context Filters.

Created table calculations, calculated fields and parameters.

Publishing sheets and dashboards on server Using Tableau Desktop.

Developed complex reports and visualizations using Tableau Desktop as per requirements.

Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.

Executed and tested required queries and reports before publishing.

Validate the data for each report and review the reports.

Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.

Updating the weekly status and tracking the query sheet

Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.

Create, customize & share interactive web dashboards in minutes with simple drag & drop.

Created incremental refreshes for data sources on Tableau server.

ENVIRONMENT :Tableau 8.0/9.0, MS Excel, SQL, Windows

Project:3

Client: IFFCO, Sharjah

Organization: Cranes software International Ltd,INDIA

Duration: Jan 2011 to Dec2012

Role: Application Specialist

Description:

IFFCO is a food processing company having 100+ products, located in sharjah. It maintains all its resource planning using an ERP package called BAAN with the back end database as SQL Server. All its ad-hoc reporting is done on transactional database. There is a BO reporting database which is created based on the report requirement on which actual universes are built. Each and every product has its own universe.

Responsibilities:

Interacted with Business Users and Business Analysts to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Reports.

Coordinating with end user communities to understand their requirements.

Involved in the preparation of design specifications documents for reports.

Developed ad-hoc report which includes standard report, cross tab reports and summary according to the requirements.

Generated reports using calculations, variables, drill functions, @functions and combined queries etc.

Interacting with users in resolving various issues like formatting, data, security issues etc.

Developed reports in webi and deski using various functions.

Created users, groups and managing all CMC content.

Deployed BO universes and reports in secure environment from one server to another using import wizard.

Configured send the reports to the users as per the requirement.

Have experience in scheduling the reports using CMC

Environment: Business Objects XI R2 (CMC, CMS, DeskI, Web I), Windows7and SQL Server 2000/2005

Project :4

Client: Humana, Louisville, KY

Organization: Unisys,INDIA

Duration: Jan 2009 to Dec2010

Role:SAP BO DEVELOPER

Description:

Premium Billing System (PBS) of Humana Health Insurance replaced their existing Legacy Billing system with a lot more new features. The Major partitions of the system are Billing, Cash Posting Retro, Collections and Reconciliation. To support its functionality PBS interfaces and exchanges data with different external systems like Customer Interface, Sales Management, General Ledger, Broker Commissions and Letter System. A data warehouse was built by extracting data from different sources and various analytical reports were generated using business objects reporter.

Responsibilities:

Interacted with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.

Created user objects including Dimensions, Details and Measures.

Developed complex reports using features like slice and dice, Drill capabilities and complex freehand SQL.

Formatted reports as per the user requirements using all the facilities in Business Objects, which allows the users to analyze the data.

Scheduled reports using Broadcast Agent.

Performed Production Support and documented all the reports.

Environment: Business Objects 6.5, Web Intelligence 2.7, Broadcast Agent, Oracle 9i, Windows NT.

Project :5

Project Name: CAREHELP ANALYST

Organization: CLI3L,INDIA

Duration: Sep2006 to Dec2008

Role :Technical Support Engineer

Responsibilities:

Created tickets in Remedy ticketing system and followed up on tickets to provide resolutions for end users.

Reset the passwords of users in SAP system

Increased ease of access to the desktop interface by unlocking accounts, resetting passwords (SAP,CITRIX passwords), and assisting users experiencing difficulty with Windows applications and browser navigation.

Implemented VPN Connection using MYIDENTITY TOOL.

Provided technical support for corporate users to include setting up computers, passwords, rights and responsibilities using Active Directory (Computers and Users)

Managed Remedy ticketing systems to organize and completed nearly 500 tickets a week.

Assists users in accessing their O365 email from both the Outlook client and Web client from their desktop

Performed SCCM Installation for more than 1000 corporate users using BOMGAR JUMP CLIENT & SKYPE

Performed O365 Installation and Configuration for more than 100 corporate users using Remote Desktop Connection

Performed Troubleshooting O365,SCCM & SKYPE Issues with end users

Assists the users to Configure Skype Account for Business

Created tickets in SERVICE NOW ticketing system and followed up on tickets to provide resolutions for end users.

Managed Service Now ticketing systems to organize and completed nearly 100 tickets a month

Notified customer of issue status and follows-up with customers to ensure problems have been resolved satisfactorily.

Provided technical support for corporate users to include setting up computers, passwords, rights and responsibilities using Active Directory (Computers and Users)

Provided support for smart phones such as Android,Iphone .

Assisted users in accessing their email from their mobile device

Used Share Point for VE TRACKER & TROUBLE SHOOTING MANUALS

Answered user inquiries regarding computer software,O365,SKYPE,ONE NOTE etc to resolve problems..

Configured, monitored, and maintained email applications or virus protection software.

Responsible for documenting and updating all customer correspondence and relevant internal information in support tickets via ticketing system.

Used Active Directory to reset passwords and add/remove computers from the network

Provided help to the users via remote assistance, over the phone and in-person

Environment /Technology: Windows 7/8/8.1,SAP, O365,REMEDY, SERVICENOW, SKYPE, BOMGAR, RDC.

Contact this candidate