SUMMARY

• Over 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Extensive experience working as a Business Intelligence Consultant with specialization in reporting tools such as Tableau, SSRS, Cognos.
• 4 years experience of creating dashboards, list reports, charts, complex calculations and filters using Tableau.
• Integrating Tableau dashboards with Microsoft Sharepoint. Configuring AD Server for security.
• Administering Tableau Server, including load balancing, user profiles’ and data sources creation.
• Deployed the reports andscheduled themfor the use of end users and customers. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau. End to end experience in designing and deploying data visualizations using Tableau.
• Good knowledge of the full SDLC, including various methodologies such as Waterfall, Agile SCRUM
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases Oracle, SQL Server and client/server applications. Extensive working experience inPackages, Procedures, Cursors and Triggers.
• 4 years of experience in Cognos 10 Framework Manager Modeling, OLAP modeling using Cognos10 Transformer, Cognos10 Connection, Report Studio, Query Studio.
• Actively implemented Cognos 10.2 BI implementations for two projects
• Involved inTrouble Shooting, Performance tuning of reports, tuning long running SQL and PL/SQL queries for better performance and resolving issues.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split and Derived column.
• Experience with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
• UtilizedBest PracticesandProven MethodologyinBI developmentprocess.
• Possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau 8.2, 8.3 (Server, Public, Desktop), Cognos 10.2, SSRS

Languages: PL/SQL, SQL, SQL Plus

Applications: Oracle, SQL Developer

Databases: Oracle 8i/9i/10g/11g,MS SQL Server 2000/2005

Operating Systems: Windows XP/7/8, MS-DOS, Sun Solaris, Linux

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0

Packages / Tools: MS Office, Toad, Putty

PROFESSIONAL EXPERIENCE

Confidential, MO

Sr.Tableau Admin/Developer

Responsibilities:

• Develop, support, maintain, and test, Developer Suit (Form, Report), SQL/PL-SQL, Program Design, create and maintain data model and data
• Create Tableau software (BI), dashboards, data analysis, visualization, report,
• Tableau development lifecycle from gathering requirements and designing solutions, through developing code
• / reports, to testing and release / deployment
• Design, create and extend application layer to manage the CMS data repository and ETL(Extract, Transform, and Load) feeds from multiple sources
• Design, develop and support complex performance and capacity charts and reports using Tableau Tool.
• Expertise with data architecture, data interoperability and data analytics using Tableau and SQLs.
• Assist Seagate DBAs and Application Developers with Oracle SQL troubleshooting, performance tuning and enhancements
• Responsible for RFP (Requests for Proposals) data visualization creation in Tableau Desktop.
• Published views and dashboards in Tableau Server for auditor review.
• 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.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups

Environment: Tableau Server v8.1/8.2, Tableau Desktop 8.1/8.2, SQL Server 2008/2012, Oracle

Confidential, FL

Sr. Business Intelligence Developer (Tableau/Cognos/ Informatica)

Responsibilities:

• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Technical oversight of the entire Tableau Server infrastructure from user setup to performance tuning
• Server installation, upgrades, server tuning, troubleshooting system issues
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling with Quick Filters for on demand needed information with just a click of a button.
• Worked with Business Intelligence data visualization tools with specialization on Tableau. Developed, Designed and supported interactive Tableau Dashboard reports.
• Created advanced BI visualizations using both Tableau and IBM Cognos BI platforms.
• Created nearly 75 very complex reports using Cognos Report Studio.
• Created 20+ dashboards using Tableau and integrated them with sharepoint.
• Responsible for security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication
• Responsible for evaluating various RDBMS like OLTP modeling, documentation, and metadata reporting tools including Erwin, and Power Designer Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Participated in normalizing the database to put them into the 3rd NF of the ODS.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Trained technical and non-technical users on the use of Cognos tools.
• Extensively used prompts, drill-through, master-detail query relationships, conditional formats, grouping and sorting, Bursting features of ReportStudio to generate efficient and user-friendly reports.
• Extensively worked with DBA on creating indexes, partitions, and Materialized Views where needed.

Environment: Tableau Server, Desktop 8.1/7.2, Administrator 7.2, tabcmd, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007,MS Access, Windows 2007 server, java 1.5 platform, Teradata, Microsoft office 2007

Confidential, FL

Tableau Developer/Analyst

Responsibilities:

• Involved in creating dashboards and reports in Tableau 6.1.
• Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Created incremental refreshes for data sources on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau server and documented upgrade plan from Tableau 6.0 to Tableau 6.1
• Created and assisted users in Tableau dashboard development.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating reports as per user requirements using MS Reporting Services 2005/2008R2.
• Involved in writing complex SQL queries using table joins (inner and outer).

Environment: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008, Oracle 11i, MS suite

Confidential

Cognos Developer

Responsibilities:

• GatheredUser requirementsand reviewed them from atechnical perspective and conducted meetings with end users to establish business rules,schedule deliverables and identify potential issues that could impact the development effort.
• Understanding of relational database structures, theories, principles, and practices.
• Implemented modeling in Framework manager
• Implemented Relational modeling in Framework Manager and created query subjects, relationships, filters and calculations in the model.
• Setting up the security in frame work manager at package level, Query subject level.
• Created various Reports based on Technical Specification.
• Created drill thru reports and enabled the drill-thru feature on the current master reports to manage more complex business reporting requirements.
• Involved in the design and development of reports in Report Studio
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Used JavaScript for customizing the search options and Prompt controls.
• Involved in testing of reports with the existing live data via VPN.
• Developed ad-hoc reports, drill through reports and created master detail relationship to burst a crosstab report using Report Studio
• Designed model using power play transformer and created multiple cube views.
• Deployed the packages and reports from Dev to QA and QA to production environments
• Documentation of the report results and updated daily with the testing results.
• Participated in the testing of the developed reports and reported the defects.
• Played as a good mentor to the newly joining team by giving knowledge transition in both technical and functional areas.

Environment: Cognos 8.1.2 MR1, ReportNet 1.1, Framework Manager 1.1, Cognos Report Studio 1.1, DB2.0, Report Studio 1.1/8.0

Confidential

Cognos Developer/Administrator

Responsibilities:

• Trained Business Analysts on using the new features of Cognos 8 Report Studio and Query Studio so effectively that client would need less Report Studio Licenses compared to ReportNet’s earlier version.
• Provided technical assistance, training and mentoring to Users and Business Partners for automating tasks and Job Scheduling.
• Installed and configuredCognosReportNet 1.1 MR2.
• Actively participated in the installation and configuration of Cognos 8
• Worked closely with the client’s security team and deployed MS Active Directory Server as an authentication source. Also worked closely with the IIS Web Server‘s team in establishing SingleSignOn between ReportNet and AD Server.
• Used Cognos Connection for organizing, securing, scheduling and distributing reports
• Created user accounts using Cognos connection and then determined capabilities for the users.
• Configured an another namespace Cognos Series 7 using Cognos Configuration apart from MS AD Server as there were some Impromptu users who got CRN licenses for ReportStudio/QueryStudio.
• Built models and published packages to the ReportNet Server by embedding required security in FrameworkManager.
• Performed migration of Cognos impromptu reports to CognosReportNet 1.1 using Cognos migration utility tools. This included formatting the reports and correcting them to run against the corresponding ReportNet package
• Migrated the existing CognosReportNet Reports 1.1 MR2 to Cognos 8.
• Created nearly40 different reports to explore the new advanced features of Cognos 8. This included 30 report studio reports.
• Developed complex reports (list, crosstab, chart, drill through etc,.) in Report studio by developing filters, calculations, prompts, conditions in reports.

Environment: Cognos 8.1 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Oracle 9i, TOAD and Sun Solaris Server.