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 wif 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 wif 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 wif Drill Down menu option and Parameterized using Tableau. End to end experience in designing and deploying data visualizations using Tableau.
• Good noledge 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, Analysis Studio, 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 in handling business and technical issues & communicating wif both business and technical users and documented both logical, physical data models
• Experience wif Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
• Produced, communicated and sold technology roadmaps for maximum IT investment value. Aligned to product and technology lifecycles, internal plans and budgetary constraints. Evaluated desired states, trends and markets to identify opportunities and provide technology direction leadership. Recognized as an innovative thought leader and trusted advisor by colleagues, peers and leaders in both IT and business.
• UtilizedBest PracticesandProven MethodologyinBI developmentprocess.
• Possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented wif a desire to learn client's business requirements.

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, NC

Sr.Tableau Admin/Developer

Responsibilities:

• Worked wif business analyst and business users to understand Wireless Device Expense Policy for corporate expenses and per user expenses across enterprise.
• Defined and offered guidance on best practices for implementation and integration of the Tableau platform.
• Developed and document technical architecture, system designs and other technical implementation aspects.
• Planned and migrated nearly 15 dashboards from Cognos WorkSpace to Tableau.
• Connected to data sources and performed Data blending implemented on SQL Server Database to generate interactive dashboards.
• Researched and identified needs, goals, and business models by collaborating wif the end users, stakeholders and support partners.
• Created Expense Tracker reports to show historic data and plot future trends and identify potential opportunities for lines of business to manage costs.
• Developed Tableau visualizations using line charts, bar charts, dual axis charts.
• Generated dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
• Created ad-hoc reports to users in Tableau by connecting to various data sources to show expenses by devices and charge category.
• Published workbooks by creating user security and row level security.
• Created advanced charts like Waterfall chart and Pareto Chart.
• Handled Tableau admin activities generating access, managing extracts and installations.
• Performed troubleshooting to address connectivity issues.
• Experience on server administrative functions, Meta data model development, Performance tuning techniques and customization.
• Worked on dimensional modelling, ETL, SQL query rewriting and optimization using Oracle, SQL Server databases. Created MDX queries.
• Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
• Worked in agile, iterative team setting and experience wif other BI tools like Micro strategy, SSAS/SSRS and OBIEE.

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

Confidential, ND

Sr. Business Intelligence Developer

Responsibilities:

• Interacting wif business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Developed reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling wif Quick Filters for on demand needed information wif just a click of a button.
• Worked wif Business Intelligence data visualization tools wif 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 wif sharepoint.
• Responsible for security configuration including user / group setup, permissions, security roles, configuration of trusted ticket autantication
• 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 wif 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, Cognos 10, Microsoft Excel 2007,MS Access, Windows 2007 server, java 1.5 platform, Teradata, Microsoft office 2007

Confidential, IL

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 wif 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:

• GatheirdUser requirementsand reviewed them from atechnical perspective and conducted meetings wif end users to establish business rules,schedule deliverables and identify potential issues that could impact the development effort.
• Understanding of relational database structures, theories, principals, 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 wif 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 wif 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 noledge 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, CA

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, 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 wif the client’s security team and deployed MS Active Directory Server as an autantication source. Also worked closely wif 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 tan determined capabilities for the users.
• Configured an another namespace Cognos Series 7 using Cognos Configuration apart from MS AD Server as their 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. dis 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. dis 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.