SUMMARY

• 10 years’ experience in IT industry in Support, Analysis, Development, Reporting and Testing.
• Good knowledge and experience of Insurance, Retail, Engineering, Construction & Health sector Domains.
• Expertise in Oracle 10g, SQL Server 2000, MS Access and DB2.
• Experience with using Excel features like VLOOKUP, Pivot Tables, and Macros for reporting.
• Strong experience with Tableau, QlikView design, development & Administration
• Experience with Data Warehouse Environments.
• Experience in developing dashboards out of Bigdata.
• Experience in Loading and Extracting Hive data to Tableau using Hive connection drivers alongside other data loads by data blending
• Working experience on AWS strong ability to articulate and organize data elements into a diverse set of visualizations using Tableau.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Good knowledge & experience on performance tuning of Tableau Dashboards.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc.
• Worked on the development of Dashboard Reports and Key Performance Indicators (KPI Reports) for management using Tableau.
• Experienced in developing Rich Interactive Reports and dashboards integrating various reporting components from multiple sources.
• Experience in handling Online Analytical Processing (OLAP) Data.
• Managed and trained a team of 6 on Reporting & Dashboard Development.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Excellent analytical and problem solving using BI tools and SQL debugging skills.
• Good analytical, technical and business skills in architecting and designing using ETL applications.
• Experience on Data Cleansing and Data standardizations.
• Good understanding and hands on experience of Master Data Management (MDM).
• Good understanding and experience of SOA (Service Oriented Architecture).
• Experience with Confidential Service Manager, ServiceNow, Remedy and good understanding of SLA
• Knowledge and experience on CMDB.
• Trained in ITIL practices and implemented in resolving incidents and issues on Data Quality.
• Experience on various technologies like web services, XML, SOAP & REST.

TECHNICAL SKILLS

Reporting & ETL: Tableau 10.2,10.5 Tableau server 10.2,10.5 QlikView Desktop 12.0, QlikView Access Point, QlikView Management Console, Power BI 2.5, SSRS, SSIS and Informatica.

Statistical Languages: R Language

Database: Oracle, SQL Server, T - SQL, Mongo DB, IBM DB2, MS Access, Hive, SAP HANA

EAI Technologies: TIBCO BW 5.x, TIBCO EMS 4.x, TIBCO Administrator 5.x

Languages: XML (XSD, XSLT, X-Path), AWS, Java, JSP, SOAP, WSDL

Operating system: Windows, Unix, Solaris and Mainframe

Tools: Star Team, Clear Case, TOAD, SQL Developer, SOAP UI, HPSM, ServiceNow, Initiate Inspector (MDM), MS-Office, IBM Rational Team Concert, HPQC, Java JDK, Putty, Visio, MS SharePoint

MDM Technologies: IBM Initiate, IBM Inspector

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Senior Tableau Developer

Environment: Tableau 10.5, Tableau server 10.5, SSRS, SSIS, Oracle Application Express 9.0, Taleo, PeopleSoft, Hive, Oracle 11g, MS Excel, SQL, T-SQL, Informatica, UNIX.

Responsibilities:

• Worked with advisors across & outside the team to understand the Data Sources.
• Suggested changes to source data formats to maintain consistency for new onboarding Hotels.
• Analyzed user and business requirements, attended periodic meetings for changes in the requirements.
• Built dashboards using the Data Extracts & Live connections from multiple sources
• Created KPI’s, YTD, YOY, Seasonality, Revenue Contribution, Occupancy, Price Comparison, Length of Stay, Forecast & Revenue Management reports as part of Analytics.
• Participated in end-to-end tableau projects with direction from Management.
• Enhanced existing data visualizations and streamlines their ease of use with a focus on database linkage, automating analytic processes when appropriate.
• Created training Documents for existing visualizations and newly optimized Dashboards.
• Processes and explored Tableau for Query Improvements, ad-hoc pricing, space & BI analysis.
• Defined ways to visualize things differently including geo-locations.
• Translates business requirements into analytic methods and visualizations with direction from the Management.
• Practices data quality procedures & assists in quality assurance efforts for assigned projects including data verification and transformation
• Ensured success stakeholder and final acceptance of visualizations and analysis products assigned.

Confidential, Woodlands, TX

Lead Tableau Developer

Environment: Tableau 10.2, Tableau server 10.2, SSRS, SSIS, Oracle Application Express 9.0, Taleo, PeopleSoft, Hive, SAP HANA, Oracle 11g, MS Excel, SQL, T-SQL, Informatica, UNIX, .Net Corporate IT is Rapid Application Development (RAD) team established within the organisation’s IT to support the Construction site management and HR team for quick and rapid access to Applications and Reports on Site management, Progress, Finance, Employee mobility & Timesheet Analysis.

Responsibilities:

• Gathered requirements on frequent basis from multiple users.
• Analyzed user and business requirements attended periodic meetings for changes in the requirements and documents.
• Redesigned / Maintained existing dashboards using multiple data sources by Data Blending with more meaningful data insight and presented them to users.
• Maintained existing 30+ HR Analytic dashboards on rapid changing requirements from HR and Site Users
• Connected to SAP HANA Data Sources and built dashboards on Live & Extracted Data.
• Worked on performance tuning of Dashboards.
• Identified Slow Workbooks, Longer Rendering dashboards and tuned them for optimum performance.
• Suggested, Presented and Implemented the advantages of using data extracts (TDE) instead of live connection for quick response of dashboards
• Identified and removed unneeded dimensions, reduced no: of records, Fields, Filters & Strings as part of performance improvement.
• Extensively involved in User Acceptance Testing of dashboards before deployment.
• Migrated existing dashboards from using Excel data sources to Oracle DB.
• Changed live data connections to TDE for better and quick dashboard responses.
• Scheduled data extracts daily.
• Created Employee Timesheet Dashboards with micro insights for HR.
• Gathered & loaded data into Tableau from various data sources (SQL SERVER, Oracle, .CSV, Excel files and Cloud).
• Maintained and Supported changes on existing dashboards based on site user requirements.
• Developed dashboards on Candidate Requisitions, Employee Mobility, Hourly Analysis by Activity, Employee Time sheet Analysis and Employee Hiring Analysis.
• Hands on experience with Splunk for Tableau log analysis.

Confidential, Houston, TX

Lead Tableau Developer

Environment: Tableau 9.3 & 10, Tableau Server 9.3 & 10, QlikView Desktop 12.0, Qlikview Server 12.0, Qlikview Management Console, AWS, SSRS, SSIS, Power BI 2.4, Anaplan, Omega Compensation, Hive, Confidential Service Manager, Oracle 11g, MS SQL Server, SAP HANA, Informatica, UNIX, .Net, Talend.

Responsibilities:

• Created complex SQL queries before and after enriching data for data quality.
• Actively involved in requirement gathering sessions with business analysts, business stakeholders, Subject Matter Experts (SME), developers and sponsors.
• Gathered, Analyzed and transformed business requirements into BI solutions.
• Gathered & loaded data into Tableau from various data sources (SQL SERVER, Oracle, .CSV, Excel files and Cloud).
• Designed, developed, implemented and supported Tableau dashboards
• Developed dashboards with multiple data connections including Hadoop/Hive, SAP HANA having Single Node & Multi Node architecture by data blending.
• Working with transforming huge volume of data from Hadoop/Hive.
• Involved in trouble shooting of performance issues associated with Tableau reports.
• Delivered advanced/complex reporting solutions and Standardized reporting using Tableau.
• Developed SQL scripts to load relevant data and set analysis to create customized Tableau reports.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Developed complex SQL queries and functions to fetch data for reporting and to accomplish several computations.
• Used incremental loading concepts to delete, insert and update records and highlighted items changed by scheduling the reports using Tableau Server.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box-Whisker charts, Scatter Plots, Geographic Map, Pie Charts, Bar Charts and Density Chart.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Configuring and creating reports based of Hive.
• Responsible for creating Ad-hoc reports for on the go requirements of held data throughout inbound and outbound data.
• Micro Analysis of held sales data reports for further insight of data for Management and Business Teams
• Implemented Star schema & snow flake schemas in Tableau Data sources.
• Developed Linked Tables, Concatenation and solved the loops issues.
• Responsible for training and giving guidance to team for development and maintenance of the system and reports
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Analyzed the database and provided detailed information on the operational sales data.
• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards
• Scheduled Data Extracts of SAP HANA, HIVE & Oracle when dealing with large Data Sets where required.
• Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed
• Got involved into Administrative tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Confidential, Northbrook, IL

Senior Tableau Developer

Environment: Confidential Quality Centre ALM 11.0, SOAPUI 5.1, Restful and SOAP, ASP.NET, AWS, Tableau 8, Tableau server, Python, Web Services, XML, XML Schema, XSD, WSDL, Oracle 11g, MS Excel, SQL, T-SQL, Informatica, UNIX, .Net, Mainframe, IBM Initiate, IBM Inspector, Accord Insurance standards.

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developed, documented, and reported data quality goals and standards.
• Created SQL queries for monthly audits to check if the data sync between systems and reported the missing data using Tableau Dashboards.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Queried production database for non-sync data, reported using Tableau
• Responsible for interaction with business stake holders, gathering requirements for Reporting and converting them into solutions using mock data.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Generated and ran SQL queries to further pinpoint client's data issue using dashboards and worked with third party data vendors to obtain corrected files.
• Served as a Software Tester to improve the usability, integrity, and reliability of the company’s new database system. (ICS/CDW)
• Created Reports for executives to show quality and quantitative trends to define key metrics
• Created and maintained production and quality training materials.
• Investigating and analyzing the incidents with in time period and doing root cause analysis of issue, if required raising problem record and working with problem management team.
• Supported TEST Environment for developers on TEST DATA requirements.
• Handling 24/7 support and the on-call support with priority 2 & 3 as per the SLA specified requirements.
• Used HPSM and ServiceNow to work on incidents and resolve them with in time frame.
• Used ServiceNow for creating automated reports on the incidents occurring weekly and monthly for team metrics.

Confidential, Northbrook, IL

Tableau Developer

Environment: TIBCO EMS, TIBCO BW, TIBCO Administrator, Tableau 6.1, SQL Server, SQL, OBIEE 10.1, DB2, Mainframe, .Net, XML, WSDL, XSD, Web services, SOAP, Informatica, UNIX, Putty, Windows 7

Responsibilities:

• Developing Integration scenarios for all the enhancements in the projects.
• Co-ordinating with testing team in various test phases and bug fixes.
• Bug fixing various incidents reported in Live Environment.
• Understanding the concepts and principles of SOA.
• Optimized the team's metrics through consistent production and quality performances.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently from Oracle Database.
• Administer user, user groups, and scheduled instances for reports in Tableau using Oracle Database.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Retrieving data using advanced SQL statements for DATA QUALITY.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Built dashboards for measures with forecast, trend line and reference lines.
• Developing test cases for unit testing and supporting the BW code on various testing environments.
• Deploying the BW engines on various test environments including development environment.
• Used HPSM and ServiceNow to work on incidents and resolve them with in time frame.

Confidential

Incident Support Analyst

Environment: Confidential Quality Centre ALM 11.0, Java JDK 1.6, SOAPUI 5.1, Restful and SOAP, ASP.NET, C#, Web Services, XML, XML Schema, XSD, WSDL, Oracle 11g, MS Excel, SQL, Windows7, UNIX, Putt, TIBCO BW 5.x, TIBCO EMS 4.x, TIBCO Administrator 5.x

Responsibilities:

• Developed and maintained the Incident/Problem/Change Management processes.
• Inherited ITIL process (Service Now application) in all phases.
• End to end management of all Incidents, Changes and Escalations.
• Reviewed the efficiency and effectiveness of the Incident, Problem and Change Management processes.
• Logged Categorized, Prioritized, and Escalated and closed all Incidents with in time frame.
• Has managed and supported all application tools with in the team(SOAP UI, TIBCO EMS and TIBCO BW )
• Ensuring SLA is met by preparing and logging Incident reports.
• Communication with Business Clients and first point of contact/interface for application issues and outages between Business and Technology Team.
• Publishing new incidents in the Problem Management report and updating the same in Known Error Database and Root Cause Analysis report.
• Creating Knowledge base documents to L1 support team (Front line office (ATSC)).
• Involved in on call support.
• Documented the steps and procedures for all the resolutions and added to internal WSS for further reference to coworkers.
• Had trained and mentored 5 new resources within the team.

Confidential

QA Engineer

Responsibilities:

• Managed the test preparation activities and execution effort for all PeopleSoft HCM modules.
• Worked on various customized PeopleSoft applications for IRL, UK, US and Canada.
• Developed unit testing scripts/ integration testing scripts, created training documents and playable recordings and published them to central repository using UPK.
• Created or reviewed all test preparation deliverables (e.g. requirements, test cases, test scenarios, test data, etc.) and completed all test preparation tasks by the planned code drop date.
• Created Business Requirements for all the work units in Quality Center 9.2 for North American Payroll, Time and Labor, HR, Self-Service and Benefits.
• Created unit testing scripts with UPK and integrated them with Mercury Quality center.
• Prepared the Fit-Gap analysis of specific Payroll business processes in relationship to
• PeopleSoft Human Resources, North American Payroll, Benefits, Timekeeping functionality.
• Executed different Pay Periods in different environments to validate the results in Payroll and Benefits.
• Heavily involved in test execution, regression testing and defect retesting.
• Applied risk-based testing and concentrated on the critical business areas of Payroll and Pay Rate calculations.
• Wrote PS queries using PS Query tool to extract various Payroll, Benefits, Time & Labor and HR related data for validations in regard to the testing scenarios.
• Tested Time and Labor Self-service application security and setup.
• Tested the Set up and Configuration of Time & Labor rules.
• Involved in Regression testing of various modules like Time and Labor, Core HR, North American Payroll and Global Payroll.
• Great understanding of running the entire downstream process from Payroll to Financials GL.
• Involved in setting up of Integration Broker for Person Basic Full Sync and Work Force Sync.
• Involved in loading and converting bulk data from external system into PeopleSoft through BizTalk.
• Involved in End to End UAT & parallel test.
• Created test cases, scenarios and data templates for the Automation team.
• Created objects and repositories in QTP for the Automation scripts.