SUMMARY:

• Over 15 years of experience in Designing, Developing, Administering, and Supporting Business Intelligence applications and Testing.
• Extensive experience with BI and Data warehouse techniques using Tableau, OBIEE connecting multiple databases like Teradata, SQLServer, Oracle etc.
• Participated in the Agile planning for Team Foundation Server to make sure that our team sprints satisfied backlogs.
• Exposed to BI/DW assignments in various domains like Retail, Healthcare, Banking and Telecom.
• Thorough understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Strong knowledge of Dimensional Modeling like Star Schema and Snow Flake Schema to fit Query, Reporting, and Analysis requirements.
• Experience in configuring, monitoring, upgrading and maintaining systems hardware, software and related infrastructure.
• Handling of tableau migration and scheduling.
• Install tableau server from end to end.
• Involved in integration of Tableau JavaScript API Filters in web application.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Extensive knowledge in various reporting objects like Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters, Level - of-Detail (LOD) expressions etc., in Tableau.
• Experience in using Tableau functions (Logical, Number, String, Type Conversions, and Table Calculation, LOD) when creating the calculated fields.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Restricted data for users using Row level security and User filters.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Designed and setup user security for the entire landscape to facilitate windows AD login and used Tableau CMD for various Dashboard migrations from one environment to another.
• Accountable for Service Level Agreements (SLA) for customers.
• Used Python To manipulate the data and connect it with Tableau to build analytical dashboards and story points.
• Involved in Extract-Transform-Load processes using Datastage and Amazon Redshift for Financial Reporting and Risk Analytics and Designing Risk Management plans.
• Experience and Working knowledge in Hadoop HDFS Admin Shell commands.
• Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Worked on AWS EC2 Instances Provisioning, VPC setup, Auto scaling for availability of EC2 Instances and availability of applications.
• Experience in Production and Technical Support activities and managing production rollouts.
• Worked on multiple projects from requirement gathering to training end-users.
• Hands on working experience Linux environment with Apache Tomcat, experience on Amazon AWS.
• Experience working with ANSI SQL, PL/SQL, SQL*Plus, SQL*Loader, and UNIX and Korn Shell scripting.
• Involved in writing detailed as well as high level documents for reports and repository design.
• Identifying and removing bottlenecks in order to improve the performance of dashboards and reports.
• Experience troubleshooting ETL jobs, bug fixing and addressing production issues like performance tuning and enhancements.
• Collecting detailed patient information including personal and financial using Allscripts Patient Manager and Allscripts EMR.
• Worked on Manual Testing and Automation
• Experience working with various operational sources like Informix, SQL Server, DB2 and Flat files.
• Performed data analysis for user enablement of forecasting and strategic planning.
• Influencing and rapport building with stakeholders to help them achieve their Analytical goals.
• Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.

TECHNICAL SKILLS:

BI Tools: Tableau 10.x/9.x/8.x, DataStage8.x, Oracle Business Intelligence Enterprise Editions 10.1.3.x, Microsoft Power BI.

Languages: SQL, UNIX Shell Scripting, HTML.

Databases: Teradata v15/13/12, SQL Server 2000/2005, DB2, MS Access, Oracle 9i/11i

Operating Systems: Linux (Red Hat) AS4, Unix, WINDOWS 95/98/2000/NT/XP, 7, 8, 10

Dimensional Modeling: Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables

Application Software: MS Word, MS Excel, MS Access, MS Power Point.

Oracle TOAD; Teradata Utilities: SQL Assistant, BTEQ; DataStage Suite: Designer, Director, JSON

PROFESSIONAL EXPERIENCE:

Confidential, Livonia, Michigan

Tableau Developer/Admin

Roles and Responsibilities:

• Installing the Tableau Server on Single Server, Distributive Installation on Development, Production Environments
• Setting Up the high availability of the System
• Setting up the groups, users, Sites, assigning the permissions to the projects and sites .
• Worked on creating schemas and connecting tableau to AWS Redshift and Hive
• Developed complex visualizations and dashboards and presented them to client.
• Publishing the tableau extracts to the server and maintains/monitors the scheduled extracts .
• Installing the patches as required on the server
• Configuring the Tableau Server with SSL security certificates from CA .
• Publishing the Tableau Data Sources and maintains the tableau data source connections .
• Involved in the performance tuning of the Workbooks by analyzing the SQL generated by tableau by monitoring the Log Files.
• Adding the worker nodes for the performance of the system and high availability.
• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications .
• Defined relationships, created actions, filters, parameters, data blending, hierarchies, calculated fields, sorting, groupings, live connections, in-memory in both tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Developed several worksheets filled with Bar, Line, Pie, Maps Charts and Highlight Tables for rich visualizations and analyzing of the data.
• Monitor tableau extract refreshes daily and troubleshoot the tableau server issues.
• Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes .
• Used Sheet filters to produce multiple chart types in a single view .
• Created/Developed reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Utilized Tableau visual analytics and best practices like Dashboard structure (Layout Components, Tiled and Floating objects), view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Used User Filters to perform the Row Level Security in Tableau.
• Created Bins for distributing of the data.
• Used detail filters and context filters to limit the data that is to be viewed in the sheet and dashboards based on the business logic.
• Implemented data blending and joins to work with data from multiple databases in a single view.
• Implemented best practices for better performance of the Dashboards and sheets.
• Performed Tableau dashboard performance recording and tuned layout and queries accordingly.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Trace, Stored Outlines.

Environment: Tableau 2018.1.1, Tableau Server 2018.1/10.x/9.x,Alteryx, MYSQL Server, Windows 2012, AWS, Oracle, Redshift,Hive Toad, Informatica, MS Office.

Confidential

Tableau Developer

Roles and Responsibilities:

• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Deep involvement with the design and advancement of Tableau visualization solutions.
• Extensive use of joins, blending, custom SQL, attributes, hierarchies, action filters, extract filters, data source filters, parameters, table calculations, LOD expressions, sets, groups, bins in Tableau Desktop.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons.
• Preparing Dashboards using calculations, parameters in Tableau and developing Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Access and change extremely large datasets through filtering, grouping, aggregation, and statistical calculation.
• Experience in standardizing Tableau for shared service deployment.
• Developed trend lines, statistics, log axes, groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Worked extensively on advance analysis actions, calculations, parameters, background images, maps.
• Create, customize &share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to MS SQL directly and created the dimensions, hierarchies, and levels on Tableau desktop.
• Performed SQL reporting with the ability to create SQL views and wrote custom SQL queries.
• SQL queries were used to extract data to Tableau from Amazon redshift data warehouse to perform visual analysis.
• Used data warehouse concepts and implemented Star Schema to handle simple queries.

Environment: Tableau 9.1, IBM-DB2, IBM Data stage, SQL Server 2008. Window 2008 R2, Windows 7, Excel, Flat Files7

Confidential, Panama, Florida

Tableau Developer

Roles and Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• 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.
• Used JavaScript API to format like switching and filtering views in dashboards published on the portals.
• Created groups and users in Tableau server.
• Implemented new features in Tableau 7.0 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.
• Involved in installation and upgrade of Tableau Server and Server performance tuning for Optimization.
• Web Data Connector JavaScript library was used to enable the app to interact with the Tableau API
• Involved in building Dashboards using parameters, sets, groups and calculations.
• Designed Views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Environment: Tableau Desktop 7.0, Tableau server 7.0, MS Office suite (Word, PowerPoint, and Excel).

Confidential, Washington D.C

Tableau Developer (Consultant Specialist)

Roles and Responsiblites:

• Developing a logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Analyzing requirement Specification document and preparing the Specification document as per the Business requirement.
• Developing the SQL scripts as per the business requirement.
• Preparing the Entity Definition Sheet for Reporting tables.
• 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.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.
• Develop and maintain dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Developed the customized and GUI interactive dashboards using multiple data sources.
• Creation of workbooks and dashboards those are accessible on different environments like any browser or tablet.
• Created Tableau sheets, Score cards, dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box, Whisker Plot, Stacked Bar, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts for making the decisions on.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Designed and developed many complex reports based on the requirements using complex calculations like Row-level calculations, aggregate calculations, filter Actions, URL actions, filters, trend lines, forecast lines.
• Employed complex calculations, parameters, action filters, and other advanced chart options to provide deep insights into out of voluminous and complex datasets.
• Applied various types of filters such as data source filters, quick filters and context filters.
• Generated tableau dashboards with forecast and reference lines, bands.
• Implemented data blending and joins to work with data from multiple databases in a single view.
• Used detail filters and context filters to limit the data that is to be viewed in the sheet and dashboards based on the business logic.
• Diagnosing and resolving any design problems using techniques like show scope, count, reference and by generating categories.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Tableau 8.2/8.3, Oracle 9i, Informatica, Teradata, Microsoft

Confidential , Minneapolis, MN

Tableau Developer/Tableau Admin

Roles and Responsibilities:

• Worked in coordination with Clients for feasibility study of the project in tableau and drawing up the timelines.
• Deployment of tableau Server in clustered environment by mapping server nodes to primary machine.
• Created Users, Groups and projects in tableau environment.
• Tableau installations, configuration and administration strong expertise with Tableau platform sizing, troubleshooting, tuning & disaster recovery
• Created and managed schedules for users.
• Created different views using a tableau Desktop that was published the business stakeholders for analysis and customization using filters and actions.
• Created Heat Map showing employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal. dimensions data from Oracle SQL Server and MS Excel.
• Developed metrics, attributes, filters, reports, dashboardsand created advanced chart types, visualizations and complex calculation to manipulate the data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Formulates and recommends standards for achieving maximum performance and efficiency of the DWH.
• Design interactive dashboards in tableau Desktop and published them to tableau Server.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Experience with tableau application performance monitoring, capacity planning, and tuning for multiple members on multiple projects.

Environment: Tableau Desktop 7, Tableau Server 7, Green Plum, MS SQL Server 8.2, SQL server 2012, DataStage 8.5, UNIX, Oracle, Mainframe, Windows 7, Teradata v14.01, Informix.

Confidential, Richmond, VA

DataStage Developer

Roles and Responsibilities:

• Created Detail Design Documents and Mapping documents based on High Level Design and specifications given by business.
• Designed and developed Enterprise Edition DataStage jobs based on requirement specifications given by Business.
• Designed and developed DataStage routines to simplify the design and improve the performance.
• Developed Shared Containers for reusability.
• Tuned PL/SQL procedure to improve the performance of ETL process.
• Developed jobs to read data from Flat Files received from external vendors.
• Developed Processes for ASG Zena Scheduling.
• Extensively used Dataset, Aggregator, Sort, Join, Funnel, Lookup, Merge, Filter and other parallel stages in developing the solution.
• Extensively used Enterprise/ODBC stages to read data from Oracle, DB2 and SQL Server databases.
• Extensively used Resource Estimation feature of DataStage to implement ETL solutions with good performance.
• Implemented restart ability in all DataStage sequencers.
• Understood and updated existing DataStage jobs to accommodate changes requested by users.
• Worked closely with Business Analyst in providing efficient solution with good turnaround time.
• Created Unit test plans and updated the documents based on the testing.
• Supported Quality Analysts during System/Integration testing phase.
• Supported business users during User Acceptance Test (UAT) and Post Implementation Phase.

Environment: IBM Info Sphere Information Server 8.0.1 (DataStage, Information Analyzer), SQL, Teradata, Unix shell programming, Windows XP, IBM DB2, Toad, ASG Zena Scheduler, Test Director 8.0.

Confidential, New York, NY

QlikView Developer

Roles and Responsibilities:

• Gathered, documented business requirement from the users
• Work on requirement specifications for the strategic KPI's that drive performance and profitability in the division
• Developed dashboards pertaining to KPI monitoring using QlikView
• Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs.
• Developed and maintained QlikView Load Scripts across multiple data sources.
• Create and manage ETL script generation using QlikView Script
• Optimizing applications by using QVD's, removing synthetic keys and circular loop.
• Created Set Analysis for Comparison analysis eliminating additional complex coding
• Scheduled jobs in QlikView Publisher for reloading of data and distribution of applications
• Loaded data into QlikView from Database, text file and also from excel file
• Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years.
• Created multi boxes, table boxes, and input boxes to fetch data based on the input given and Showed the statistics in bar charts and pie charts as per the client needs
• Created Layout themes and applied it to several documents
• Create test scenarios and run tests to find errors and confirm program meets specifications. Also, consult with clients to prototype, refine, test, and debug programs to attain client approval
• Enhanced QlikView dashboards as per client requests
• Trained end users and provided user support.

Environment: QlikView, Excel, SQL Server, MSSRS, MS Access, Active directory, Windows 2008 R2 Server.

Confidential, Philedelphia, PA

Sr.QA TESTER

Roles and Responsibilities:

• Designed, developed, and executed automated testing using Quick Test Pro.
• Investigated defects within WC Plus utilizing VB Script, JavaScript, ASP, SQL, and HTML. Supported the development of processes to automate data collection, data integration, and reporting.
• Collaborated with management, analysts, and performance improvement specialists to identify data discrepancies and data quality issues to advance data integration and reporting capabilities.
• Specialized in testing a major web application at the browser/server and database levels.
• Served as Test Expert for Wachovia’s Voice Response Unit, allowing banking transactions to be conducted over the phone.
• Set up and administered Wachovia Connection Testing Lab on a Network.
• Member of International Testing Qualification Board.