SUMMARY

• Around 7 Years of Experience in Programming, Analyzing, Designing, Testing, integration and deployment of enterprise architecture - based components and business applications and Business Intelligence.
• Extensive experience in creating UI visualizations with Tableau Desktop and Tableau Server in various versions of Tableau.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Utilized all Tableau tools including Tableau Desktop, Tableau Reader and Tableau Server.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Strong understanding of project life cycle and Software Development Life Cycle (SDLC) methodologies including Waterfall and Agile.
• Experience in different BI tools (Tableau, SAP Business Objects, Qlik View, Jaspersoft, Power BI).
• Having in-depth knowledge of various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graph, scattered plot, Geographical Maps, Gantt Chat using show me functionality.
• Expertise in configuring Repository, Create/Manage Dashboards, Reports/Answer, and Building physical, Business model and Presentation layer.
• Maintenance and enhancements of current Jasper report including SQL code utilizing complex queries and views using Jasper Server and iReport.
• Experienced in Business Intelligence/Business Objects (BI/BO) enterprise solutions that include Business Objects Administration, Server Monitoring, Report deployment, Security, Report/Dashboard development, Documentation, Production Support and End user training.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle. Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Experienced in analyzing the BI Needs, interpreting business user requirements and translating them into reports.
• Active participation in Business Intelligence activities related to the data warehouse (TERADATA), ETL and report development methodology.
• Designing and developing the Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.
• Experience in Performance Tuning & Optimization of SQL statements.
• Develop and deliver high-quality, tested code based on requirements and user-experience discussions
• Strong problem solving and planning skills, with an ability to work independently or along with Team in an agile environment.
• Quick learner, self-motivated, excellent interpersonal skills and highly motivated towards learning New Technologies.

TECHNICAL SKILLS

Database Systems: Oracle 11g, Oracle 10g, Oracle 9i, Teradata, MS SQL Server, MS Access

ETL Tools: Informatica, Data Services Integrator

Reporting Tools: Tableau Desktop & server, Jaspersoft Studio, Jasper Server, BO, QlikView, Power BI

Software’s/Utilities: SQL*Plus, SQL*Net, SQL*Loader, PL/SQL, Import/Export, UNIX Shell Scripting, MS Azure, Agile, TOAD, ERWIN, SSIS, SQL Developer, Jira, Jenkins, Putty.

Scripting Languages: Java Script, Python, HTML

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX.

PROFESSIONAL EXPERIENCE

Confidential - Fort Washington, PA

Tableau Developer

Environment: Tableau desktop and Server, Power BI Oracle, PostgreSQL, MYSQL, Java Script, SQL*plus, SSIS, Agile.

Responsibilities:

• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Migration of Power BI to Tableau.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Performed detailed data analysis to Provide detailed business and data requirements including complex data.

Confidential - Denver, CO

Report Developer

Environment: Tableau desktop and Server Admin, T-SQL, SQL*Plus, MYSQL, Java, web services, Confluence, SVN.

Responsibilities:

• Involved in the publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting training to the user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• In charge of the team that builds tableau architecture and dashboards using Tableau Desktop, Tableau Server and Tableau Online.
• Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Install upgrade Tableau server and server performance tuning for optimization.
• Administer 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.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• 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.
• Worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.

Confidential - Salt Lake City, UT

Report Developer

Environment: Tableau Desktop & Server, Jasper studio & server, web Intelligence, Java, Teradata, HTML, SQL*Loader, XML, Putty, SVN, WinSCP, SharePoint.

Responsibilities:

• Creating Dashboards and Analytics using Tableau Desktop & Tableau Online/Server Administering Tableau Server.
• Managing Tableau Admin activities like folder creation, user permissions, data extracts, automating queries.
• Designing & deploying the end to end process of Data Visualization using Tableau.
• Creating & developing Tableau Data Visualization reports for KPIs.
• Developing Tableau workbooks from multiple data sources using Data Blending.
• Creating & administering users, groups, projects, sites creation, giving rights and publishing workbooks.
• Well served with SQL Analyze the functional and technical requirements of the project.
• Work on generating various dashboards in Tableau server using a various data source.
• Install upgrade Tableau server and server performance tuning for optimization. understanding design (HLD, LLD) & develop the proposed solution/technology.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Prepare Dashboards using calculations, parameters in Tableau.
• Proof-read all documents and maintain the accuracy of information and preparing SOP.
• Responsible for Developing Dashboard and preparing ad-hoc Reporting.
• Collaborate with Management to identify report requirements, design features, and specifications in implementing Jasper Reporting.
• Designed and developed various Jasper reports including Crosstabs, Tables, Charts using Jasper soft studio and Deployed in Jasper Server to represent Red Flags.
• Improved the Business Objects query performance by tuning the Queries. Involved in Business Objects Support, Problem Solving, Troubleshooting and developing End User Notes.
• Worked closely with Business Leads and SME’s to design and approve sample reports.
• Worked on defining the scope of development effort to build reporting universe and reports.
• Produce documentation of Reports and the development process as needed to support the system.
• Exported the Jasper reports to various formats such as PDF, EXCEL, CSV, and XLSX to support different business unit’s requirements.
• Executed various date logics calculations including adding, subtracting months or days from parameter date and formatted the dates as per the needs of the business user.
• Published Reports, workbooks and data source to the server and export the reports in different Formats.

Confidential - Austin, TX

Tableau Developer/Admin

Environment: Tableau Desktop developer, Admin, SSIS, SQL Server 2008R2/2008/2005, Enterprise manager, Crystal Reports, XML, MS Project, Big Data, MS Access 2000 & Windows Server 2000.

Responsibilities:

• Interacting with business users to understand the functionality and their requirements.
• Responsible for Tableau Server Administrative functions, upgrade, installations, configuration, license management, backup of servers and load balancing techniques.
• Configured Tableau Server processes to maximize the server performance.
• Involved in the publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Creating action filters, parameters and calculated sets for preparing Dashboards and Worksheets in Tableau
• Advanced level knowledge with tableau table and window calculations.
• Managing the Troubleshooting process, Performance tuning of reports and resolving issues within Tableau Server and reports.
• Providing technical and analytical expertise while responding to specialized report requests requiring higher-level data analysis and data management services.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to performing ETL and publish data to the reports/dashboards.
• Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries, and transformations.
• Directly responsible for the Extraction, Transformation, and Loading of data from Multiple Sources to Data Warehouse.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using Tableau.

Confidential - Saint Louis, MO

Business Intelligence Developer

Environment: Tableau Desktop, Business Object s, Amazon Redshift , R, MySQL, Agile, ITSM.

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Crosstabs, Heatmaps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in a tooltip.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands-on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administrative tasks such as Setting permissions, managing ownership and providing access to the users and adding them to the specific group.