SUMMARY:

• Senior consultant with 9.5 years of experience in Development and Support projects in Digital Media (2 year), Insurance (1 years), Retail (3 years) and Life Sciences (3 years)
• Tableau developer with 3 years of experience in creating complex visualization dashboards, workbooks and worksheets using different data sources, Excel files, google sheets, charts, multi - layered maps and multiple input controls
• Experience with Tableau workbook objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting and other KPI’s.
• Experience in creating hierarchies, Measures, Slicer Dimension, Filter Function, Calculated Member, Aggregate functions (sum, YTD, MTD), Joins and KPI’s.
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau Server
• Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS)
• Have done performance tuning in tableau server by implementing clusters and re-routing the server user traffic
• Have improved complex dashboards performance by generating performance report and working on problem areas
• Experience in designing Tableau Layouts to make consistent and professional optimized look to clients.
• Performed Tableau Admin activities like - scheduling extracts, user management (assigning roles/groups to business users)
• Proficient in building SAP BO universe and WEBI reports
• Expert in creating Universes with Measures and Dimensions Objects, Join conditions, Filters, LOV's, Aliases, Contexts, Aggregate Awareness with various back end sources like Oracle, Teradata.
• Expertise in scheduling regular and customized reports generation using SAP-BO CMC
• Experience in daily data loads using Informatica work flows
• Hands-on in QlikView and Qlik Sense visualization tools
• Expertise in building Dimensional and Relational Models using Framework Manager in Cognos
• Proficient in creating advanced Reports using Cognos report studio
• Worked on Creating Users, Groups and Role in Cognos Using Access Manager
• Generated and published cubes using Cognos Transformer and create batch scripts using scheduler for incremental loads of Cubes
• Implemented SSO in Cognos web portal
• Worked on capturing requirements for complex projects involving multiple functional areas and multiple stake holders
• Good experience in writing unit test cases, Integration test cases and System test cases.
• Good in-depth Knowledge on Data Ware Housing concepts
• Extremely efficient in roles that demand rigor, a high level of drive and dedication and a focus on delivering business outcomes through the use of standard methodologies and best practice.
• In depth knowledge of Waterfall and Agile methodologies and thorough understanding of various SDLC phases - requirements gathering, design, development, testing, release and support

TECHNICAL SKILLS:

BI Tools: DBMS / Web application

Operating System: Servers

Language/Scripts: Tableau 9.x/10.x suite (Server, Desktop)

Sap BO 3.x/4.x Suite (Webi, UDT/IDT): Cognos 8.x/10.x Suite (Reporting, Modelling, Cube)

Oracle 9i/10g, SQL Server 2005, Teradata 14/15: Google sheets

Windows 2008 Server: Windows 2003 Enterprise ServerXP, Windows 7, Unix

Application Servers (WAS, Tomcat), Web Servers (IIS): PL/SQL, SQLXMLHTML

PROFESSIONAL EXPERIENCE:

Confidential, Emeryville, CA

Sr. Tableau Developer

Responsibilities:

• Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system. Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules
• Results-focused approach with regards to design and development of Tableau software applications to support reporting and Business Intelligence initiatives
• Have improved complex dashboards performance by generating performance report and working on problem areas
• Building executive, adhoc, and custom dashboards and publishing to Tableau server.
• Testing, monitoring performances, cleaning unused dashboards
• Conducting kick off meetings, status calls, walk thru sessions and trainings to business users
• Created best practices, publishing checklists and repository backups etc.,
• Created schedules, Tasks, Groups, Users, Permissions on Tableau server.
• Conducting performance tuning, applying user and data source level securities upon need
• Worked on different Tableau objects like straight tables, line charts, bar charts and pivot tables etc for dashboard design.
• Worked on set analysis and advanced aggregation functions.
• Created dynamic and cascading prompts using Business views
• Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields to compare and analyze data in different perspectives.
• Experience in creating sets, joins,filters, global filters, quick filters, context filters, table calculations, calculated measures and parameters.
• Experience in creating various views in Tableau by different charts such as maps, bars, lines, cross tab, donut, pie and highlight tables
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau as needed
• Executed and tested required queries and reports before publishing.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Tableau 10.4.2 desktop and server, HP Vertica 8.1, Alteryx 11.8, Windows 7

Confidential, Sunnyvale, CA

Sr. Tableau Developer

Responsibilities:

• Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system. Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules
• Results-focused approach with regards to design and development of Tableau software applications to support reporting and Business Intelligence initiatives
• Have improved complex dashboards performance by generating performance report and working on problem areas
• Building executive, adhoc, and custom dashboards and publishing to Tableau server.
• Testing, monitoring performances, cleaning unused dashboards
• Conducting kick off meetings, status calls, walk thru sessions and trainings to business users
• Created best practices, publishing checklists and repository backups etc.,
• Created schedules, Tasks, Groups, Users, Permissions and Subscriptions on Tableau server.
• Conducting performance tuning, applying user and data source level securities upon need
• Created Data Extract files ( tde), Data connection files ( tds), Database connection in Tableau
• Worked on different Tableau objects like straight tables, line charts, bar charts and pivot tables etc for dashboard design.
• Worked on set analysis and advanced aggregation functions.
• Created dynamic and cascading prompts using Business views
• Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields to compare and analyze data in different perspectives.
• Experience in creating sets, joins, hierarchies, filters, global filters, quick filters, context filters, table calculations, calculated measures and parameters.
• Experience in creating various views in Tableau by different charts such as maps, bars, lines, cross tab,donut, pie, heat maps and highlight tables
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau as needed
• Executed and tested required queries and reports before publishing.
• Running Informatica Workflows using workflow manager and monitor them using workflow monitor
• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Tableau 10.2 desktop and server, Google Sheets, Teradata 14,15, Windows 7, HP ALM (Quality Center), ServiceNow, Informatica 9.x,10.x

Confidential, NJ

Tableau Developer

Responsibilities:

• Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system. Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules
• Results-focused approach with regards to design and development of Tableau software applications to support reporting and Business Intelligence initiatives
• Gathering user requirements, analyzing, designing and efforts estimations
• Building executive, adhoc, and custom dashboards and publishing to Tableau server.
• Testing, monitoring performances, cleaning unused dashboards
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support
• Integrated information from several data sources, Excel, Oracle, SQL Teradata
• Created server-based Tableau workbooks(twb), Packaged workbook (twbx), dashboards and applications from scratch based on client needs
• Worked with end users to explain Tableau workbooks, creating ad-hoc reports
• Recreated BO reports in tableau as per business requirement
• Trained developers on Tableau in terms of best developing and design practices
• Coordinated an employee training program for various Tableau applications and basic troubleshooting principles
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Tableau.
• Testing reports using review checklists for Quality Assurance before delivering to the end users
• Developing, Maintaining, Troubleshooting and updating Reports in Business Objects
• Creating package report and very complex and critical Business Objects reports as per user request

Environment: Tableau 10.1, SAP Business Object 4. x (Webi Report), IDT, SQL, NoSQL, Teradata 14,15, Windows 7, HP ALM (Quality Center), ServiceNow, Informatica 9.x

Confidential

Report Developer

Responsibilities:

• Working as a BI analyst/SAP BO Developer.
• Created functional specification documents, based on the technical specification documents for universes and reports. Facilitated universe design-walk through before promoting the universe to Q.A (UAT).
• Used short cut joins to bypass intermediate tables and improve query performance.
• Implemented object level, row-level security at the universe level by creating relevant restrictions on user groups.
• Modified existing Business objects auditor canned reports and created customized auditing reports to keep track of report run times and volume of data churned by report/user.
• Developing, Maintaining, Troubleshooting and updating Reports in Business Objects
• Creating complex reports in Business Objects
• Scheduling monthly, quarterly and annually reports as per business requirement in Business Objects
• Creating objects as per business requirement in UDT
• Perform Unit testing of reports against database and posting them to the repository
• Adding users as per business requirement in SAP BO CMC
• Performing Ad-hoc data loads in Informatica

Environment: SAP Business Objects 3.x(Webi Report),UDT 3.x,SQL, NoSQL, Oracle 11i,Windows XP, HP ALM(Quality Center),Informatica

Confidential

Report Developer

Responsibilities:

• Interacting with Business users and Stake holders and gathering requirements and building reports using Business Objects
• Managing new enhancements end to end, from Requirements gathering till delivery.
• Estimating Cost and timelines for the enhancement requests.
• Maintenance of existing Business Objects reports.
• Adding users as per business requirement in SAP BO CMC
• Performing Ad-hoc data loads in Informatica
• Mentoring new team members and providing them process and technical knowledge.
• Providing weekly status updates
• Managing and tracking all Incident, Problem Tickets, Change Request, Release tickets in Remedy to closure.
• Handling Internal Remedy Audits for Change Request, Problem Tickets.
• Interacting with multiple teams and closing the tickets on time so as to avoid any SLA breach.
• Actively involved in UAT
• Coordinated in training sessions and demonstration of SAP BO tools to End-users
• Involved in creating Technical Design documents

Environment: SAP BO 3.x(Webi Report),UDT 3.x,Informatica 9.x,SQL, NoSQL, Oracle 10g,Windows 2003,Remedy.

Confidential, Houston

Report Developer

Responsibilities:

• Design and Development of Reports, Cubes and Framework Model using Cognos Framework manager.
• Verify and customize the imported metadata (setting relationships and cardinality).
• Create Report studio reports and use these source files as data source to create cubes by using power play transformer in Cognos.
• Generate the cube and publish cube for analysis using Cognos transformer.
• Analysis of Cubes and Models using Analysis Studio.
• Generating Reports using Report Studio
• Creating Groups, Roles and adding users using Access Manager
• Report validation and testing
• Actively involved in UAT
• Implemented SSO on Cognos web portal

Environment: IBM Cognos 8.4 (Framework Manager, Report Studio, Access Manager), SQL, Oracle 9i, Unix server, Windows 2003

Confidential, Houston

Report Developer

Responsibilities:

• Design and Development of Reports, Cubes and Framework Model using Cognos Framework manager.
• Verify and customize the imported metadata (setting relationships and cardinality).
• Create Report studio reports and use these source files as data source to create cubes by using power play transformer in Cognos.
• Generate the cube and publish cube for analysis using Cognos transformer.
• Analysis of Cubes and Models using Analysis Studio.
• Generating Reports using Report Studio
• Creating Groups, Roles and adding users using Access Manager
• Report validation and testing
• Actively involved in UAT

Environment: IBM Cognos 8.2 (Framework Manager, Report Studio, Access Manager), SQL, Oracle 9i, Unix server, Windows 2003