SUMMARY

• Have 7 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various phases of SDLC.
• Expertise in creating Triggers, Exceptional Expertise in Tableau installation and upgrading existing version.
• Reload, Reduction, Distribution Tasks with all kinds of security setting for distribution.
• Expertise in designing in Tableau with complex multiples data sources (SQL, Excel, Flat files) relational designs and optimizing applications
• 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.
• Expert in creating Universes with Measures and DimensionsObjects, Join conditions, Filters, LOV's, Aliases, Contexts, Aggregate Awareness with various back end sources like Oracle, SQL Server.
• Strong data analysis experience and proficient in development and tuning of SQL queries, stored procedures, views, packages using PL/SQL.
• Experience in creating hierarchies, Measures, Slicer Dimension, Filter Function, Calculated Member, Aggregate functions (sum, YTD,MTD), Relative Positions functions, Joins, Behaviors’, and KPI’s.
• Expert in creating complex Crystal Reports (XI and 2008) that include Cross tab, Drilldown, complex formulae, parameters, Sub Reports, On - Demand Sub Reports.
• Expertise in Cognos 8 BI Suite ( Framework Manager, Cognos connection, Report Studio, Analysis Studio, Metric studio, Event Studio and Query studio).
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Experience in designing Tableau Layouts to make consistent and professional optimized look to clients.
• Expertise in setting up server, publisher settings and configurations
• Profound troubleshooting experience of Business Objects application servers, services and associated Infrastructure components
• Experience with configuration and installation of various components of Cognos 8.x.
• Experience with migration from Crystal reports to Cognos 8. Worked with Crystal Reports 8.5
• Strong knowledge of Data Warehousing concepts &Dimensional modeling likeStar SchemaandSnowflake Schema.

TECHNICAL SKILLS

BI Tools: Tableau 4/5/6/7/8 Suite ( Server, Desktop, Reader ) Cognos 7/8/8.5

DBMS / Design: SQL Server2005, Oracle 9i/10g, DB2, TeradataMS Access

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

Language/Scripts: PL/SQL, SQL, C, C++, VB, XML, HTML

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Sr. Tableau Consultant

Responsibilities:

• Gathering user requirements, analyzing, designing and efforts estimations
• Building executive, adhoc, and custom dashboards and publishing toTableauserver.
• Testing, Monitoring performances, cleaning unused dashboards
• Creating Sites, Groups, Projects using TABCMD & TABADMIN commands
• Installation and ActivatingtableauPorts using TABCMD.
• Conducting kick off meetings, status calls, walk thru sessions and trainings to business users
• Created best practices, publishing checklists and repository backups etc.,
• Conducting performance tuning, applying user and data source level securities upon need
• Conducting POC fortableauserver setup for non-existingtableauapplications
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableauas needed
• Executed and tested required queries and reports before publishing.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau8.1 desktop/Server.
• Created schedules, Tasks, Groups, Users, Permissions and Subscriptions on Tableauserver.
• Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting 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 inTableauby different charts such as maps, bars, lines, cross tab, packet bubbles, scatter plot, heat maps and highlight tables.

Environment: TableauDesktop 8.2/8.1/7,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel, SERVLETS, HTML, JSP

Confidential, New York City, NY

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
• 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 Servers.
• Created server-based Tableau workbooks(twb), Packaged workbook (twbx), dashboards and applications from scratch based on clients needs
• Worked with end users to explain Tableau workbooks, creating ad-hoc reports
• 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
• Involved in migration of reports from Qlikview to Tableau 8.1 and was also involved in adding features to the interactive dashboards.
• Created interactive Dashboards and Business Presentations by importing data fromExcel sheetsusing Tableau.
• Used Import wizard to transport Dashboards, Assisted end user’s in generation of Live Office reports.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Tableau 5.2.7, MS Office, SQL Server 2005, Oracle 10g, TOAD, SQL, Tomcat/Apache, windows 2008

Confidential, Cincinnati, Ohio

Report Developer

Responsibilities:

• Working as a BI analyst/Tableau 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.
• 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.
• Worked on Tableau Desktop to create worksheet, dashboards and published them to Tableau server for end user use
• Created dynamic and cascading prompts using Business views.
• Designed systems design specification and publisher process documents.
• Worked on a plan to develop the process for remote systems administration and ongoing Tableau application enhancement and maintenance.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Created models in Transformer, built cubes and published cubes to Power Play server.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Worked on TOAD and BTEQ for Oracle and Teradata database systems for creation of adhoc queries and for improving various performance issues.

Environment: Tableau 5.0.8 (Desktop, Server), Cognos 8.3 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio) Oracle 10g, SQL, MS Office (Word 2007, Excel 2007, Visio 2007), Windows 2003

Confidential, Houston, TX

Report Developer

Responsibilities:

• Involved in the entire project life cycle from Analyze, Design and Development of reports
• Migrating reports and cubes from Cognos series 7 to Cognos 8
• Upgraded existing Cognos 7.1 catalog and reports to Cognos 7.4
• Migrated Cognos 7.4 catalog and reports to Cognos 8.1 using Cognos migration utilities
• Migrated numerous Cognos Series 7.1 cubes and models to Cognos 8
• Developed complex reports, standard Reports, Master Detail reports, Bursting reports, drill-through reports with calculated columns, filters, and prompts using Report Studio
• Created new enhanced reports using Report studio
• Created Adhoc reports using Query Studio
• Developed Portal Pages/Dashboards
• Managed Scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection in Cognos 8
• Report deployed from Development to Testing and production servers using Content Administration
• Documented Migration process
• Coordinated in training sessions and demonstration of Cognos tools to End-users
• Involved in creating Technical Design documents
• Involved in Reports Testing and UAT

Environment: Cognos 8 (Report Studio, Query Studio, Cognos Connection), Cognos 7 Series (Impromptu, Impromptu Administration, Power Play Transformer, Upfront), Oracle 9i, SAP, UNIX, TOAD, Windows XP.

Confidential 

QA analyst

Responsibilities:

• Analyzed the functional requirements and the master test plan.
• Created Test Cases for various forms of the application manually.
• Performed Functional Testing, Black Box Testing, and Regression Testing.
• Performed the Functional and Regression test using Skill test.
• PVCS Bug Tracker was used to keep track of bugs.
• Involved in submission of bugs through modification reports and frequent review of MR by conducting meetings during the development phase.
• Involved in Bug Reporting and Documentation of whole testing process.

Environment: MS Excel, QTP, Visual Basic, UNIX, Windows95, Manual Testing, and PVCS Bug Tracker.