SUMMARY

• Over 8 years of total IT experience in Analysis, Design, Development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, OLAP, Client/Server and Web applications on Windows.
• Expertise in Tableau, Business Objects, Oracle, MySQL and SPSS Clementine.
• Technically hands - on commercially experience mainly with creating the dashboards and reports using Tableau Desktop tool and building various dashboard development activities such as Dashboard layout design and development, Tableau Extracts, Tableau Actions, Tableau Dashboards color coding and formatting, Tableau designs, proto types and Tableau mock up reports, Wireframes, Frame works, Design documents (HLD, LLD), Data mapping documents and reporting.
• 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.
• Experience working as a Tableau analyst and Tableau Developer 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.
• Having experience on various data analyzing techniques, reports efforts estimation, Reports development planning.

TECHNICAL SKILLS

AREA: BI - Tableau, SAP Business Objects.

TOOLS: USED: Tableau suite of tools which includes Tableau Desktop, Tableau server, Tableau Online, Tableau Public SAP Business Objects XI R2, XI 3.x Minitab, Microsoft Excel, Power Point

DATABASE WORKED ON: Oracle 9i, Amazon Redshift SQL Server 2000

PROGRAMMING LANGUAGE: SQL, PL/SQL, UNIX, ASP .NET, HTML

PROFESSIONAL EXPERIENCE

Confidential, NJ

Tableau Developer

Responsibilities:

• Involved in reviewing requirements and data sources form AWS Redshift, MS Excel for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Interacted with Strategic Development Team, Business analyst and Nurse Managers to analyse business needs and developed technical specifications.
• Created custom reports for the reconciliation of source and target of dashboard data where source is data mart and target is AWS redshift.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and Drill downs along with user level security.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Interacted with business to understand data requirement and ETL team to understand data load and data distribution.
• Thorough analysis, unit testing and integrated testing with other applications before deployment to the production server.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: s & Tools: Tableau Server, Tableau Desktop, Manual Testing and also by using Tab Jolt, AWS Redshift, MS Excel, Power Point

Confidential

Responsibilities:

• Gathered business requirements and reporting requirements after working with Business user and business analyst.
• Worked with Architect team and Data Modeller to understand the data flow requirement.
• Created Technical Design Document from Functional Requirement Document (FRD). worked on ETL Informatica transformations effectively including - Source Qualifier, Connected -Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings for fact and dimension data load.
• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Populated and maintained Fact and Dimension tables in Daily Data Star Schema.
• Extensively worked on ETL Informatica performance tuning to tune the data load and worked with for SQL query tuning etc.
• Involved in unit, performance and integration testing of Informatica jobs.
• Involved in performance tuning of the ETL Informatica process by addressing various performance bottlenecks at the extraction and transformation stages in sources, mappings, and sessions and successfully tuned them for maximum performance using best practices.
• Implemented Error handling and E-mail notifications using pre-session, post-session commands.
• Used Informatica Workflow Manager to create, schedule, monitor and send the error messages in case of process failure.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using Tableau Desktop
• Published views and dashboards in Tableau Server for auditor review.

Environment: s & Tools: Oracle SQL Server, Informatica Power center, Tableau Server, Tableau Desktop, MS Excel

Confidential

Business Object Developer & Reporting

Responsibilities:

• Participation in business requirements and functional analysis
• Designing BI solution taking into account the business and technical requirements.
• Participation in the development of strategies and plans for BI solutions.
• Designing and developing Universes, designing canned/ad-hoc reports, scheduling the processes using Business Objects XIR2/ BOXI 3.0
• Designing and Developing Customize Queries for Adhoc Reports using BO
• Work directly with business users to elicit business requirements then analyse/translate into functional requirements and develop specifications
• Participation, supervising and reviewing technology diagnosis and assessment activities
• Created drilled reports on data for analysis and prediction of business.
• Point of contact for raising and resolving Business Objects related issues such as Invalid Query Result, Query validations and Customization in Queries.
• Involved in Web intelligence/Desktop Intelligence reports creation Analyzing business requirements, developing business logic using BOXI and Clementine and resolving production issues.
• Making Control charts in Minitab.

Environment: s & Tools: Business Objects XI R2/R3.x, Oracle, SQL Server, Clementine Server, Web I, Minitab, MS Excel