SUMMARY

• Over 8+ years of experience in Information Technology and a wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation of the business technology solutions.
• Expertise in using Tableau 7, 8.1, 8.2, 8.3, 9.0(Tableau Desktop and Tableau Server).
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Implemented Data blending on multiple data sources and generated interactive dashboards.
• Used Performance monitoring tool of tableau desktop to analyze the performance ofdata heavy dashboards and implemented the best practices to improve the end user experience.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Experienced in various Cognos tools such as Cognos 8 BI Suite(Framework Manager, Report Studio, Cognos Connection, Metric studio, Query Studio, and Event Studio), Report Net, Impromptu, Power Play Transformer; Impromptu Web Reports(IWR), Access Manager, and Cognos EP series 7.
• Involved ininstallation, configurationandadministrationofCognos series 8 suite, Report Net.
• Well - versed in developingreporting applicationsusingCognos 10BI components (Framework Manager, Business Insight, Business insight advanced, Report Studio, Query Studio,Analysis Studio, and Cognos Connection).
• Developed and PublishedPackagesusingFramework Manager- Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Experience inDeployment(Export, Import) using Framework Manager into Cognos Connection and Implementedsecurityat different levels inFramework managerandCognos Connectionto restrict access.
• Expertise in Report building usingReport studio,Query Studio, andAnalysis Studio.
• Complex Report building experience inReport studioby usingfilters customized prompts,conditional formatting, drill-through, Cross tab,bursting, Master/details queries, andHTML Scripting.
• Deliveradvanced/ complex reporting solutionssuch asDashboardsand Standardized Reporting (including theburstingof reports globally) using Cognos. Created complexDashboardswith Area charts, Pie charts, Cross tabs and Multi promptsinReport Studio.
• Expertise inOLTP/OLAPsystem study, analysis,E-Rmodeling and developing database schemas likeStar schemaandsnowflake schema.
• Experience in DesigningTransformer modelsand developing for corporate data for buildingMultidimensional Cubes (MOLAP/OLAP/ROLAP).
• Extensively worked on Relational databases likeSQL server 2000/2005/2008 , DB2,Oracle 11g/10g/9i, andMS Access.
• Having knowledge onETLtools likeInformaticaand all Informatica Designer tools including (Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer).
• Extensive knowledge on various Internet related platforms with specialization inSQL, PL/SQL, VB, HTML, DHTML, and XML.
• Strong Inter personal communication skills, Ability to provide appropriate attention to details and effective troubleshooting skills, and ability to work in a team.
• Provided extensiveEnd User TrainingandSupport.

TECHNICAL SKILLS

BI Tools: Tableau (Desktop 7x to 9x, Tableau server and Tableau Online) Cognos 10.2, 10.1&Cognos 8.4 BI (Report Studio, Query Studio, Analysis Studio, Metric Studio, Transformer, Framework Manager).

REPORTNET 1.1(MR 2): Cognos connection, Frame work Manager, Query studio, Report studio, SDK.

ETL Tools: Informatica

Operating Systems: Windows 95/98/NT/XP/2000, UNIX, Sun Solaris, Linux.

Languages: SQL*Plus, PL/SQL, HTML, DHTML, JSP.

Databases: Teradata, Aster, ORACLE 9i, 10g, 11g, DB2, MS SQL Server 2000, and MS-Access.

GUI: Developer 2000, Crystal Reports, JavaScript, Erwin, Vision.

Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point.

Data Modeling Tool: Erwin 4.1, Visio 2000.

Database Tools: Toad, SQL Navigator.

Other Tools: Directory Tool, Server Administrator Tool, Deployment Tool, Capabilities Tool, Schedule Management Tool.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Access/Oracle SQL Server/Teradata Asterfor design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Involved in creating Data Blending in case of merging different Data Sources.
• Involved in creating various Dashboards with different type of Visualizations using Heat Maps, Tree Maps, Dual Axis Charts, Highlight Tables, Histograms, Geo-Maps, Scatter Plots etc., in Tableau Desktop.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business users, Program Managers and End users.
• Building, Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Built Complex Formulae in Calculated fields, Performed various Table calculations for achieving desired results.
• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data at bottom.
• Customized the tooltips and labels, to user understandable format wherever necessary.
• Utilized the Pages card shelf effectively to create animated visualizations for a time-spanned data.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Built Stories in Tableau with various Data points to narrate the data to the end users.

Environment: Tableau Desktop 9.0, 8.2, Tableau server, Teradata Studio Express, Teradata Aster, Oracle, SAS 9.3

Confidential, Newark, NJ

Tableau/Cognos Developer

Responsibilities:

• Defined best practices for Tableau report development.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, IPad).
• Created calculated fields using Tableau for implementation of color coding and proper aggregations for data coming from SAP BW.
• Created extensive joins for data blending from several different data sources.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Built complex formulas in Tableau for various business calculations.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Customized Cognos Connection with appropriate reports and security measures
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Installed of Cognos 10.2 in windows environment with IIS Application Server
• Created User groups, Roles in Cognos Connection to implement the Security Features.
• Created Ad-hoc, List, Crosstab, Charts and Drill through Reports by using Query Studio and Report Studio.
• Created dynamic filter by using Value prompts, Cascading prompts and Tree prompts.
• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Developed Dashboards which can be easy for the users to understand and navigate.
• Involved in the Deployment of reports from Dev to Production
• Involved in Conditional Formatting like highlighting the data and to show or hide the data.
• Customized Cognos reports based on user specifications.
• Involved in Performance Tuning of the reports.
• Updated the reports according to the client requirements.
• Involved in the Testing of the reports.
• Developed SQL Scripts for testing the reports & developed Stored Procedures to build the Reporting Database for Exclusive Reporting.

Environment: Tableau 8.3, Cognos 10.2, 10.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Cognos Report Net 1.1 MR2, Cognos Impromptus, PowerPlay 7.2, Cognos Transformer 7.2, Teradata, Oracle 9i/10g (SQL, PL/SQL), JavaScript, SQL Server 2005

Confidential, Warren, NJ

Tableau/Cognos Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• 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.
• 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.1
• Extensively worked on Cognos 10.1/10.2 environment.
• Migrated report studio reports and FM package from Cognos 8.4 to Cognos 10.1/10.2.
• Involved in testing and validating data in new or converted reports generated in Cognos 10.1/10.2 report studio against the Oracle DB.
• Involved in Deploying reports, packages from Development to Production environment.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists using Cognos connection in PRODUCTION.
• Involved in implementing Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed Standard Reports, Charts and Master Detail Reports using Report Studio.
• Created Active reports with different data decks and data cards.
• Create additional reports on an ad-hoc basis as requested by business users.
• Created chart, crosstab weekly, daily reports using summary page and page breakup functionality.
• Provide data profiling reports and troubleshoot anomalies discovered in data sets.
• Create SQL queries using Oracle SQL Developer to verify accuracy of Cognos reports.
• Created daily, weekly jobs in Cognos scheduler and published reports to SharePoint portal.
• Production Support which involves solving user problems and ETL data load issues.
• Resolved data conflicts and inappropriate use of data.
• Training and guiding end user to help understand BI reports and reporting parameters.
• Designing SharePoint site, providing report links for easy access to the end users.
• Member of BI change control process, approving changes deployed from Cognos Dev to QA and Prod environment.
• Send weekly BI team updated to the project manager.

Environment: Tableau 8.1, Cognos 8.4/10.1/10.2 Report Studio, Query Studio, Analysis Studio, FM, HP Quality center 11 Bug tracking tool, RELAY, Share point, JavaScript, Oracle SQL server 9i, Teradata, Windows XP.

Confidential, Greensboro, NC

Sr. Cognos Developer

Responsibilities:

• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio and created scorecard reports using the Metric Studio.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio& models in
• Framework Manger and development of any new Reports.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Worked on Analysis Studio to develop multi-dimensional reporting. Analyzed Business requirements from the analysts.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Developed reports using System Development Kit (SDK) by java scripts and Eclipse at the back end.
• Customized Reports usingHTML and JAVA SCRIPTS.
• Upgrade the report and packages version of COGNOS from 8.4 to 10 and participate in the regression testing and unit testing.
• Knowledge in working with Active Reports.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to
• Summary reports and Summary to Detail reports.
• Developed Dash board reports to display all the information related to environment using Summary reports.

Environment: Cognos 8.4/10 (Framework Manager, Cognos Connection, Query Studio Report StudioMetric Studio, Analysis Studio, Cognos SDK, Transformer and Event Studio), JavaScript and HTML, Oracle Data Integrator (ODI), Oracle Database 10g, Cognos Transformer 8.4, Teradata, Windows XP Professional, JavaScript, VB Script, T-SQL, XML and HTML.

Confidential, Chester brook, PA

Sr. Cognos Developer

Responsibilities:

• Involved in gathering and analyzing requirements and preparing the Specification document as per the Business requirement.
• Created Meta data model using Cognos8.4 Framework Manager.
• Creating star schema grouping for better understanding of the model & facilitate multi-fact (cross-fact) reporting.
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting,
• Support loop joins, optimize data source, and identify dimensions and facts.
• Implementing concept of hierarchies by defining dimension (regular, measure) to enable analysis on relational data source.
• Implemented different types of hierarchies (balanced, unbalanced, ragged).
• Expertise in developing active reports by using Cognos 8.4
• Adding business rules by defining different kinds of calculations and filter.
• Creating prompts with query macros by including references to parameter maps.
• Developing the reports using various templates like list report, Cross-tab Report and Chart Report using Report Studio and Query studio.
• Created simple and Complex reports with multiple prompts using Report Studio.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio& models in Framework Manger and development of any new Reports.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Tested and validated report output against the database to measure performance of reports. And Created Scorecards and metrics by using metric studio.
• Built DMR and Cubes in Transformer Using IQDs, Packages, reports, etc., as a data source.
• Customize reports using Cognos SDK and integrated with Portal.
• Pre-sort, clean, consolidate Data for faster process in transformer
• Developing the shell scripts to load the data in Backend Reporting tables.
• Import and export statements are used in writing the SQL scripts.
• Based on proto type refining the model by creating dimension map (dimensions, drill down path, alternate drill downs) and measures.
• Have been involved in creating cubes using Transformer
• Diagnosing and resolving any design problems using techniques like show scope, count, reference and by generating categories
• Handling unbalanced hierarchy by using sub-dimensions
• Creating cube groups where the child cubes were intended for different users.

Environment: Cognos 8.4 (Report Studio, Query Studio, Analysis Studio, Framework Manager), Access Manager, Transformer, Oracle 10g, MS SQL server 2005, Windows Server 2003

Confidential, Cleveland, OH

Cognos Developer

Responsibilities:

• Understood the source system and interacted with users to acquire the elaborate technical and business requirements and required documentation for clear understanding and traceability of requirements.
• Installation and configuration of the Cognos 8.1 in Development environment.
• Experience in building models using Framework Manager & creating simple to complex reports in
• Report Studio. Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Created Star schema dimensional model.
• Created Dashboard reports using the Cognos Report Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Extensively worked on Cognos Report Studio Active Reports.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Deployed Cognos OLAP Cube from Testing Environment to Production Environment using Batch script.
• Involved in writing Stored Procedures and imported into Framework Manager to create complex reports.
• Trained end users effectively to use reporting tool, to build and customize their ad-hoc reports.
• Implemented Cognos SDK code for extracting the report schedules defined by power users.
• Worked on Java Script to perform Prompt page validations.
• Created the reports with data level security.
• Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.
• Involved in creating the User Training manual to help the Business Users understand the reporting architecture.
• Documented the Lessons Learnt and Best Practices.
• Deployed the Cognos content from Development environment to UAT/Production environments

Environment: Cognos 8.1 (Report Studio, Analysis Studio, Query Studio, Cognos Connection), Power Play Transformer 7.x, Power Play Enterprise Server7.x, Cognos Impromptu Administrator 7.x, Access manager, Report Net 1.1, Framework Manager, IWR, Upfront, SQL Server 2000, DB2, DTS.