SUMMARY

• 8 Plus years of total IT experience in Analysis, design, development, administration, and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, OLAP, Client/Server and Web applications on Windows and Unix platforms
• Expertise in Tableau, Oracle, and MySQL
• Using the Tableau Desktop for the Data Analysis, Data Visualizations, and Data Discovery and for the data explorations.
• Using the Tableau server Product for publishing the dashboards to server, user management, user security and administration, Content Restriction as a Tableau Content Administrator.
• Experience working as a Tableau analyst, Tableau Developer and Tableau Administrator and experienced as in using the Tableau BI Products Tableau Desktop and Tableau Server.
• Expertise in creating Report Inventory, Report Mapping document, Report Business Requirement Documents (BRD), Reports Functional Requirements Documents (FRD), Use cases diagrams and report inventory document.
• Experience in creating various visualizations in tableau for dashboards using tableau various charts and graphs.
• Extensive experience on building dashboards using Tableau and involved in requirements gathering/analysis, design (Mock ups, Proto types, frame works), development, testing and production rollover of reporting and Analysis projects.
• Knowledge on various data analyzing techniques, reports efforts estimation, Reports development planning.
• Built various SQL scripts to run a variety of ad hoc reports as per the client's request.
• Evaluated and analyzed the volume of customers and performance cycle periodically by building high - level queries in Oracle to render logical statistics.
• Experienced in Performance Analysis and SQL query tuning, designing scalable applications from scratch and maintaining existing ones.
• Experienced with Data Warehousing, Fact and Dimension tables, Star and Snowflake schema.
• Extensively used Tableau and MS Excel for Data Analysis and to create Reports.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Experience in the design and deployment of Unix Shell Scripts.
• Experience in gathering and creating Business Requirements and translating business requirements into technical requirements and writing functional and technical specifications.
• Performed various types of testing, such as functional, system, regression and user acceptance testing.
• Experienced in, Documentation, and Implementation in a business environment.
• Solutions-oriented IT Professional with around 8 years of experience and proven success designing, implementing and integrating cost-effective, high-performance technical solutions to meet challenging business needs.
• Solid technical background with a solid history of delivering outstanding customer service.
• Genuine commitment to quality and customer satisfaction
• Have proven knowledge of data analysis and won accolades for providing the best solutions that helped the organization in making important business decisions.

TECHNICAL SKILLS

BI/Visualization Tools: Tableau server, Tableau Reader, SSRS, Tableau Desktop, Micro strategy, Tableau Public, SSRS.

Programming: Python, R, XML, HTML, SQL, PL/SQL

Utilities: MS Office Suite, MS SharePoint, MS Project, TFS

Databases: Teradata, DB2, Oracle SQL Server, MS Access.

OS Platforms: Windows Server, Windows

ETL Tools: Data stage, SSIS, SAS Enterprise, SAP BO

Data Modeling tools: Power Designer, ER Studio, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Responsibilities:

• Involved in gathering requirements from end users, involved in modifying various technical and functional specifications.
• Responsible for making reports using Tableau desktop, Teradata according to the user’s requirements.
• Responsible for maintaining reports in Tableau server, entity relational data modeling, giving appropriate access to users monitoring performances.
• Developed restricted user access to Tableau reports according to the user’s requirements at worksheet level.
• Developed different visualizations using bars, lines, scatter plots, bubbles and histograms based on the requirements.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in using complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle, SQL Server, Teradata for designing and modeling of Tableau application.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Developed different strategies for improving the performances of Tableau reports.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Worked on loading excel files into the SQL server database using the SQL server integration services.
• Worked on grouping to rollup products to their specific lines of business for reporting.
• Responsible for validating the database, writing queries and getting appropriated data for reports.
• Worked on making metadata tables to load the excel files into the SQL server database using Stored Procedures.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, MySQL, ETL, SSRS, SharePoint, SQL Server and Windows.

Confidential, Denver, CO

Responsibilities

• Interacted with stakeholders to understanding of the business objectives and gather functional requirements.
• Created interactive dashboards using Actions, Quick filters, Hierarchy (drill down) and Parameters.
• Helped identify trends, correlation and patterns in complex data using data mining in tableau.
• Connected multiple data sources using data blending, unions and joins in tableau.
• Proficient with restructuring data using data interpreter, pivot, custom split, changing data type and names of columns.
• Published secured workbooks by creating user filters so that only appropriate teams can view reports.
• Excellent understanding of Data modeling (Dimensional and Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases.
• Worked on Tableau administration tasks such setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Worked on Tableau Desktop, by creating Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Created procedures to ensure the quality, usability and accuracy of reports.
• Created Packages to group logically related column types and to transfer data.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Validated tableau reports by writing SQL queries and comparing to results from DB.
• Worked on Agile methodologies.
• Scheduling the monthly/weekly/daily reports to run automatically.

Environment: Tableau Desktop, Tableau Reader, Tableau server, Oracle, SQL, Flat files, SQL server, MS-Excel, Statistical files, Microsoft access and Extracts.

Confidential

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Conceptualized and developing novel reports, dashboards & KPI scorecards on Tableau.
• Involved in completing Software Development Life Cycle (SDLC) including System Requirements Collection, Design, Coding, Development, Testing, Maintenance and Enhancement in variety of technological platforms.
• In charge of the team that built the shared Tableau Platform over the virtual environment.
• Converted pre-existing Excel based reports to Tableau dashboards
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Defined group level security standards for Tableau.
• Designed the strategy for Automated Software Delivery through Silent install for Tableau.
• Accessed & transformed datasets through filtering, grouping, aggregation, & statistical calculation.
• Connected different data sources to extract uniform data & created views that delivered important insights.
• Developed Tableau data visualization using cross tabs, box plots, histograms, scatter plots, line graphs, geographic map, pie charts and bar charts to show the relationship, dispersion, comparison and trend to accomplish the project goals.
• Designed and deployed graphic visualizations with drill down and drop-down menu option and parameters using Tableau to meet the certain purpose required by the management.

Environment: Tableau Server, Tableau Desktop, MYSQL Server, MS SQL Server, Oracle