Professional Summary:

• Business Intelligence professional with over 7 years of experience in Software Design, Development, Integration, Implementation of BI and Database Platforms.
• Involved in SDLC of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• 3 Years of experience working on Tableau 7.x/8.x Desktop, Server, Reader , creating various Reports and Dashboards using different functionalities.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations Table Calculations, Hide Columns, Creating/Using Parameter, Totals and Formatting Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding using Tableau Desktop.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Improved Reports performance in tableau using extracts and context filters.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Experience in Software Development Life Cycle SDLC that include duties like providing documentation on design, testing and migration from development to production.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.
• Team player with good communication and interpersonal skills. Productive interaction with business partners to identify business information needs for reports

EXPERTISE

Experience:

Confidential

Sr. Tableau Developer

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 IDT for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Experience on writing SQL Queries.
• Strong verbal and written communication skills, ability to work effectively with user departments.

Environment: Tableau 8.1/8.0, Tableau Server, Oracle, Microsoft SQL Server, Microsoft Office, Microsoft Visio, Windows 7

Confidential

Tableau Administration /Developer

Responsibilities:

• Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• 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.
• Administration of Tableau and server maintenance, Tableau server backup activity. Consolidate multiple data silos that exist on campus to one location. Scheduled data extracts on a daily basis. Sophisticated stored procedures and triggers to provide complete technical solutions. Worked with all levels of development from analysis through implementation and support.
• Created groups and users in Tableau server. Used commands in Tabcmd and Tabadmin utility tool.
• Migrated Workbooks and Tableau upgrades/migration works. Implemented new features in Tableau to the existing Workbooks and Dashboards.
• Created Business Model to support Ad hoc Reports for User Access based on Requirements. Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Managed Security privileges for each subject area and dashboards according to user requirements. Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations. Used the Catalog manager and maintained the web catalog to manage Dashboards and Answers. Responsible for documenting the OBIEE framework and track the progress.

Environment: Tableau Server, Tableau Desktop 6 7, Desktop Reports, Web Intelligence Reports, MS SQL Server 2000, T-SQL, Access 2000

Confidential

Tableau Developer

Responsibilities:

• Gathered Business Requirements by interacting with Business Users, Project Manager and SMEs
• Analyzed metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Created reporting standards and naming conventions document.
• Provided 24/7-production support for Tableau users.
• Created new mappings and updating old mappings according to changes in Business logic.
• Used Informatica to populate the data mart from large flat files and relational databases.
• Created complex transformations using Joiner, Update Strategy and Lookup, Expression etc.
• Involved in the development of Informatica mappings between Source system and Warehouse.

Environment:Tableau Server, Tableau Desktop 6 7, Desktop Reports, Web Intelligence Reports

Confidential

Business Objects Developer

Responsibilities:

• Managed and developed Business Objects 6.x XI R2 infrastructure including CMC, CMS, WEBI, DESKI, Designer and Supervisor.
• Provided Business Objects troubleshooting, architecture, configuration, system enhancements, audit reporting, business report development and universe design development.
• Worked on requirements gathering and developing into functional and technical documentation.
• A demonstrated knowledge of business processes, translating requirements, data analysis and validation.
• Progressive level of responsibility in Business Objects administration, development, system documentation, production support and disaster recovery.
• Successfully improved change controls processes, end user support and DESKI upgrade implementations reducing environment maintenance.

Environment: Business Objects, SQL, Ms Office suite, Ms Visio, Power Designer

Confidential

Data Analyst

Responsibilities:

• Responsible for installation, configuration and administration of Oracle 8i/9i Database.
• Responsible for Cloning and administration of Oracle database products in different environments.
• Responsible for Performance tuning and Optimization.
• Created Users, security, backup, recovery and tuning.
• Writing SQL Loader control scripts and stored procedures.
• Loading data into database using SQL Loader utility for telecom billing and processing the detail call records.
• Written Database Triggers, Stored Procedures using PL/SQL.
• Successfully created and debugged many PL/SQL procedures, functions and Packages for the application.
• Analyzing requirement of client, generating and designing reports.
• Creating Data Structures i.e. tables views and applying the referential integrity.
• Designing Data conversion/Interface with the use of SQL Loader, and Open Interface, and convert data.
• Managing Rollback Segments and Temporary segments.
• Maintained Local Reports Server and local Test beds of oracle 9i on RHEL 3.0.
• Ability to summarize millions of transactions within limited time.
• Ability to move large quantities of data in and out of other enterprise systems by using Apex Data Loader.
• Providing meaningful analysis based on available data.
• Responsible for Analyzing and trouble-shooting technical issues related to data.
• Responsible for preparing business case for new project or scope items.
• Performed data Analysis to Assess Scope items.
• Pulling data from various sources in Oracle, Access.

Environment: Oracle Database 8i / 9i, SQL Plus, SQL Loader.

Confidential

Reports Developer

Responsibilities:

• Understand the Business Requirements.
• Analysis and design of the requirements from the business users.
• Created Reports, prompts and Filters using forms.
• Created dashboard pages and sections.
• Created Reports with graphical representation such as Bar charts, pie charts
• Report formatting and layout as per the requirements.

Environment: Ms.Access, Excel