SUMMARY:

• IT professional with overall 12 years of experience, over 4+ years mainly with full range of BI technologies like Tableau 10.x/9.x/8.x/ 7.x, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server 2005, SSIS, SSAS, SSRS, MS Performance Point Server 2007 (PPS 2007) and Informatica .
• Expertise in Tableau reporting while creating reports and dashboards using different datasources coming from multiple sources.
• Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data.
• Created dashboards using different types of charts like bar chart, line chart, dual axis charts, pie charts, map charts with layers, funnel and pyramid charts etc.
• Created parameters to dynamically control the visualizations and created complex calculated fields using LOD functions.
• Creating extracts and live connection to load data and refreshing extracts periodically to publish dashboards on Tableau server.
• Implemented row level security in dashboards to limit data based on user access.
• Hands - on experience with Tableau suite of products- Server, Desktop,ETL, OLAP analysis and reporting processes using Tableau, MS SQL Server 2005 and BO. Working knowledge of ETL processes of SSIS Packages, MS DTS, OLAP analysis SSAS cubes and SSRS reporting applications (Operational and Business Intelligence).
• Involved in implementation and maintenance of high performance BI solutions-, ETL, analysis (OLAP) and reporting of techno-commercial solutions for Biz D’Risking Ops.
• Good knowledge of Business Intelligence/Data Warehousing BIDW Fundamental architecture concepts, dimensional modeling, requirement gathering.
• Strong experience in various top ranked vendor BI specific tools such as Tableau & MS BI.
• Strong skills with Business Intelligence application stack including Tableau Desktop/Tableau Server/Tableau Public/SSIS/SSAS/SSRS, Performance Point Server, multi-dimensional cube building, OLAP/MOLAP and have the solid experience in data warehousing/BI environments.
• Versatile team player with excellent analytical and presentation skills.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandTableau desktop report
• Experience in Installation, Configuration and administrationof Tableau Server in amulti-serverandmulti-tierenvironment.
• Along with Tableau, I do have good skills on other tools like Qlik Sense, Spotfire and Power BI.
• Involved in upgrading Tableauplatforms in clustered environment and performing content upgrades.
• EstablishedBest Practicesfor EnterpriseTableauEnvironment and application intake and development processes.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Expert in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008r 2/2008/2005.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS:

Tools: Tableau Desktop 10.5/9.x/8.2,8.1,8.0/7.X/6.X, Tableau Server, Tableau Reader,Tableau online,Tableau Administration, Spotfire, Power BI, QlikSense, Alteryx

Operating systems: Windows XP/2003/2007, Windows Server 2003/2008, UNIX

Programming Languages: HTML,SQL, T: SQL,PL/SQL, Java, JQuery, C and C++

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, MS Access 2000,Teradata,Oracle 11g/10g/9i/8i/8.0.

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

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

Operating Systems: UNIX, Linux, Ubuntu and Windows

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, Illinois

Sr. Tableau Developer

Responsibilities:

• Developed highly polished executive level dashboard prototype regarding total sales views, and Top Payers.
• Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment in the developed dashboards.
• Created Bar Charts, pie charts, box plots, scatter plots for patient statuses, sales, and payers illustrating the total value change with respect to several weeks ago data.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the POC.
• Prepared project documentation and supported business users for various requirements to develop multiple reports accordingly
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Involved in creating a Dual-Axes Bar Chart with Multiple Measures.
• Extensively using Alteryx tool to combine and prepare data and then exporting as .tds source.
• Developed the Reports like Patient Status Metrics, Top Payers, Top Prescribers on Total Patients, Dormant Patients, Days Between Refills, Active Patients, and Total Shipments by Prescriber, Etc.
• Validated data between Tableau and Oracle Data base by writing SQL queries.
• Created schema on Tableau by joining different tables to eliminate materialized views and flat structures on oracle data base.
• Published finished Dashboards to tableau online.
• Involved in tables design in Oracle data base.

Environment: Tableau Desktop 10.5, Tableau Server / Administrator, SAP ABAP, SAP BI 7.3, Alteryx.

Confidential, St. Louis, MO

Lead BI Developer (Tableau)

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Copied data from SQL server to Oracle thru .CSV files using SQL developer tool.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Foundefficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Implemented Data modeling as per the requirement and created new Data Mart.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Environment: Tableau Desktop 8.2 and 9.0 Tableau Server, DB2, Oracle SQL Server, Teradata, MS Access, Win Server 2008 R2, Active

Confidential, Findlay, Ohio

Tableau Developer

Responsibilities:

• Involved in full life cycle implementation for MII, which includes gap analysis, requirements gathering, development, testing, reporting, reconciliation and go - live.
• Understood the business challenges and translated them into requirements and developed Reporting Queries according to Business Requirements.
• Worked on MII (Manufacturing Integration and Intelligence) Module to develop performance reports by using Capacity Planning for day, shift and crew.
• Created entire process steps for MII Module in BI system for three different location plants (Findlay, Texarkana and Tupelo).
• Worked extensively on BEx Analyzer (RRMX) and Browser for building queries.
• Reviewed basic SQL Queries and edited inner, left, and right joins in Tableau Desktopby connecting live/dynamic and static datasets.
• Created views inTableauDesktop that were published to Internal Team for review and further data analysisand customization using Filters and Actions.
• Used Open Hub Destination and BEx Queries as a source for Tableau.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the Views and Dashboards were displaying the changed data accurately.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Tableau reports are mainly used for production floor reporting.
• Performed performance tuning for InfoCubes/queries through partitioning, aggregates and compression.
• Data loaded to BI info provider, validations done, unit tested and transported to Quality then to Production.
• Written ABAP code for data source enhancement and also in BI data modeling like Start Routines, Filed Routines and End Routines.
• Developed Reports like: Returns per Customer, Top Customers, Billing Documents and Incoming Orders per Calendar Year and Month.

Environment: Tableau, SAP BEx, SAPBI, and SAP ECC6.0, Functional: SD, MM, and MII.

Confidential, Plano, TX

Tableau Developer

Responsibilities:

• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Created pie and bar charts and combined them into dashboards to show top content viewed by customers in each category including sports and news channels allowing interaction between the two charts for drill down analysis.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Created line charts to show over time in a breakdown of daily, weekly, quarterly, and yearly parameter numbers of viewers watching a particular sports channel.
• Blended data from multiple databases such as MS Excel and Oracle SQL database by assigning primary key from each databases.
• Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly.

Environment: Tableau Desktop 7, Tableau Server, Oracle SQL Server, MS Excel.

Confidential

Finance Operations Manager

Responsibilities:

• Prepare analysis on various P&L and cash components, such as operating expenses and capital expenditures; participate in the process and management of the capital processincluding ROI, NPV and IRR analyses.
• Research variances from forecast in weekly/monthly/quarterly results working with various departments to determine if tends warrant changes to forecast
• Lead financial, variance, and trending analysis for key profitability drivers and metrics.
• Interpret results and articulate actionable recommendations to maximize profitability and ensure financial targets are achieved.
• Monitoring financial performance by measuring and analyzing results; recommending corrective actions; minimizing the impact of variances.
• Participating in the development of the Company’s strategic plans and programs.
• Preparation of timely and accurate analysis of budgets, forecasts, financial reports, perational metrics and analytics, and financial trends to assist the Executive Team, and ther senior executives in performing their responsibilities.
• Striving to continually improve the budgeting and forecasting process by partnering with department leaders and managers on financial issues impacting the budget.
• Developing and maintaining a reliable cash flow projection process and reporting mechanism that includes minimum cash threshold to meet operating needs while maintaining flexibility.
• Acting as an advisor and providing strategic input from a financial perspective on any contracts the Company may enter.
• Providing financial analysis to leadership on decision making in regard to investments, new services, or potential acquisitions and resulting integrations.
• Establishing credibility throughout the organization as an effective problem solver and viewed as approachable and as a mentor to people in financial issues.
• Updating job knowledge by remaining aware of new regulations; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Accomplishing other duties and or assignments as may be assigned
• Build vendor management function from the ground up
• Review and qualify existing vendors to ensure minimum requirements are up to
• Standards
• Analyze qualified vendors to properly add them into the vendor assignment program.
• Provide analytical reporting for all clients to ensure SLAs are met
• Develop departmental goals and ensure achievement
• Negotiate rates and build/maintain subcontractor relation
• Effectively manage all escalations by vendors and internal employees to ensure all expectations are met.
• Create and maintain vendor management related documents
• Hold regional meetings in high volume market. Prepare the future of service ecosystem - how to scale operation globally
• Cross-functional collaboration with Risk and Payments Operations teams to implement scaled support business goals during the planning process
• Establish analytical framework for your team: partner across stakeholders to define measurement approach, quantify and evaluate success, and develop KPIs and guide tracking efforts for ongoing measurement and reporting.
• Work independently with end users to define concepts and under direction of Project Managers.
• Assist with implementation and user acceptance testing
• Conduct regular and ad hoc analysis of program and industry performance and identify product enhancement opportunities.
• Manage compliance to all agreed upon SLA’s
• Ensure client support tickets are resolved

Confidential

Process Specialist

Responsibilities:

• Manage the full accounts payable cycle from receipt of invoices to payment; including coding invoices, matching purchase orders, obtaining approval, and entering the invoices into the accounting system.
• Process employee expense reports, including verification of receipts and coding.
• Prepares batch check runs, wire transfers, and ACH transactions.
• Responsible for monthly accounts payable journal entries and balance sheet reconciliations.
• Ensure all accounts payable policies and procedures are adhered to including travel and related expenses, vendor approval and invoice processing.
• Responsible for IRS 1099 compliance and reporting.
• Responsible for imaging and record retention of all accounts payable documents.
• Manage vendor relations and build effective partnerships.
• Partner with Corporate Controller to identify and implement process improvements
• Process cash receipts and accounts receivable maintenance transactions.
• Assist team with gathering support for all audits, including pulling documentation.
• Investigates and resolves problems associated with processing of invoices and purchase orders.
• Receives, researches and resolves a variety of routine internal and external inquiries concerning account status, including communicating the resolution of discrepancies to appropriate persons. l employees to ensure all expectations are met.
• Create and maintain vendor management related documents
• Hold regional meetings in high volume markets
• Prepare the future of service ecosystem - how to scale operation globally
• Cross-functional collaboration with Risk and Payments Operations teams to implement scaled support.
• Manage data to track, forecast and report on performance and help to set aggressive business goals during the planning process.
• Establish analytical framework for your team: partner across stakeholders to define measurement approach, quantify and evaluate success, and develop KPIs and guide tracking efforts for ongoing measurement and reporting.
• Work independently with end users to define concepts and under direction of Project Managers.
• Assist with implementation and user acceptance testing.
• Conduct regular and ad hoc analysis of program and industry performance and identify product enhancement opportunities.
• Manage compliance to all agreed upon SLA’s.
• Ensure client support tickets are resolved.
• Process Specialist.
• Manage the full accounts payable cycle from receipt of invoices to payment; including codinginvoices, matching purchase orders, obtaining approval, and entering the invoices into the accounting system.
• Process employee expense reports, including verification of receipts and coding.
• Prepares batch check runs, wire transfers, and ACH transactions.
• Responsible for monthly accounts payable journal entries and balance sheet reconciliations.
• Ensure all accounts payable policies and procedures are adhered to including travel and related expenses, vendor approval and invoice processing.
• Responsible for IRS 1099 compliance and reporting.
• Responsible for imaging and record retention of all accounts payable documents.
• Manage vendor relations and build effective partnerships.
• Partner with Corporate Controller to identify and implement process improvements Process cash receipts and accounts receivable maintenance transactions.
• Assist team with gathering support for all audits, including pulling documentation.
• Investigates and resolves problems associated with processing of invoices and purchase orders.
• Receives, researches and resolves a variety of routine internal and external inquiries concerning account status, including communicating the resolution of discrepancies to appropriate persons.
• Assist in ad hoc projects as needed.