SUMMARY

• 10+ years of experience in development and implementation of Business Intelligence Applications using Cognos BI tool and other Business Intelligence applications.
• Over 3+ years of experience with Tableau.
• Extensive experience inTableau Desktop, Tableau Server in various versions of Tableau 6, Tableau 7, Tableau 8x,Tableau 9x and also Tableau 10.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large visually compelling and actionable interactive reports and dashboards.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Developed KPI’s and dashboards based on reports, spreadsheets and charts.
• Worked on data blending and increased the dashboard performance by extracting data.
• Extensive knowledge on various reporting objects like Hierarchies, Filters, Calculated fields, Sets, Groups, Parameters, etc., in Tableau.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Expertise in publishing reports using Cognos Report Studio, Impromptu and Report Net.
• Worked with all modules of Cognos including Framework Manager, Report Studio, Analysis Studio, Query Studio and Cognos Connection.
• Adept at creating metadata from data marts using Framework Manager.
• Developed detailed design documents for reports.
• Experience in developing customized templates for uniformity in reporting.
• Detailed experience in creating List, Crosstab, Repeater and Customized reports and experience in creating drill up/down, drill through reports.
• Developed various kinds of prompts and filters to increase retrieval speed without compromising on the scope of the reports.
• Experience in setting up Security prototype for cognos business intelligence environment incorporating row level, object level, data level, and package level and report level security.
• Have a clear understanding of building Dimensional Models, Data warehouse architecture.
• Adept at using relational databases like MS SQL Server 2000 and 2005 and Oracle with Cognos and having excellent skills in writing SQL queries.
• Experience in interacting with end users to gather requirements for reporting.
• Experience in creating ODBC, Native Metadata Data source connections
• Experience working in Data warehousing applications
• Good knowledge of Software Life Cycle Development process.
• Excellent oral and written communication skills.
• Experience in prioritizing and managing individual and group tasks and deadlines.

TECHNICAL SKILLS

BI TOOLS: Tableau 10/9x/8x/7/6, IBM Cognos 10.2.1/10.2.0/8.4/8.3/8.2 (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Power Play Studio, Transformer), Report Net 1.1 MR1/MR2/MR3),Cognos Suite 7.x(Impromptu Catalogs, Impromptu Web Reports, Upfront).

OPERATING SYSTEMS: Windows 9x/XP/2000/Vista/7,Unix.

DATABASES: Oracle 9i/10g/11g, Db2, Microsoft SQL Server 2003/2005/2008 ), Teradata, MS ACCESS, ANSI SQL,PostgreSQL 9.5

TOOLS: Cognos Administration, Erwin, Toad for Oracle Xpert version 11 and Toad for SQL Server 5.5.

PROFESSIONAL EXPERIENCE

Confidential, Chelmsford MA

Lead BI Developer

Responsibilities:

• Involved in gathering business requirements by closely working with business system analyst and financial analysts for Enterprise Data warehouse (EDW)applications
• Created action filters, parameters and calculated sets in Tableau to see trend analysis of how products are performing.
• Developed Tableau visualizations and dashboards using Tableau Desktop for Solution View Project.
• Developed Tableau workbooks from multiple data sources using Data Blending and scheduled them to run weekly
• Designed, developed Business Intelligence and Performance Management technical solutions per business need using Cognos 10.2.1
• Worked closely with Data Warehouse/ETL architects and other Cognos developers to lead the Cognos solutions to conclusion.
• Reviewed complex modeling situations and implemented solutions with variety of tools including framework manager, transformer, report studio, query studio, analysis studio, Workspace advanced.
• Implemented best practices for Business Intelligence applications to drive better solutions for users via self - service.
• Involved in designing models with Relational Data using Framework Manager from multiple data sources.
• Created Database Layer, Business Layer and Presentation Layer by defining appropriate cardinalities and relationships between query subjects in Framework Manager.
• Created Professional Services cube using Transformer and created some analysis as POC for professional services users.
• Created complex reports using Report studio and adhoc reports using query studio.
• Created visualizations using workspace advanced.
• Effectively trained users by explaining them in-depth about the functionality of workspace advanced.
• Configured ODBC connections for PostgreSQL and create POC FM model using the PostgreSQL data source and verified the data against existing EDW data source.
• Created multiple data source connections in Cognos administration.
• Improved the performance of the reports.
• Created views in the database.
• Deployed the reports from DEV to UAT and from UAT to PROD.
• Involved in Unit testing and User Acceptance testing.
• Involved In post-production support by resolving the incidents which were created/opened through service now tool.

Environment: Tableau 10/9x,Cognos 10.2.1(Report Studio, Query Studio, Cognos Connection, Framework Manager, Transformer, Analysis Studio, Workspace Advanced), Oracle 11g,Toad for Oracle Professional (ver11.5.0.56),Windows7,PostgreSQL9.5,Teradata 14,Sharepoint.

Confidential, Newark DE

Sr.Cognos Lead

Responsibilities:

• Interact with the Line of Business for requirement gathering by participating in Joint Application design/development sessions to understand and document business requirements and development process.
• Working onTableauSoftware for generating the graphical representation of the warehouse data.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input toTableau.
• Designed Self-Refreshing Activity Monitoring Dashboards for Information Analytics & Innovation Portal.
• Optimized Tableau Workbooks and Background Tasks for Targeted Interactions Analytics
• Work with the line of business to define the business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting.
• Created various List Reports, Cross Tab Reports, Chart Reports, Repeater Drill-Down and Drill-Through Reports, Master-Detail Relationships in Report Studio.
• Created Complex reports using various prompts like Value Prompts, Date & Time Prompts, Text Box Prompts, Cascading prompts.
• Developed complex reports using Conditional Blocks, style and render Variables.
• Created and performed testing strategy and test plans for any changes to cognos reports.
• Coordinated with the line of business users for User Acceptance testing prior to releasing system changes to production.
• Involved in deployment of reports and packages from DEV to UAT and from UAT to PROD.
• Support unit testing, integration testing and user acceptance testing.
• Worked in Production support by providing quick resolution.
• Effectively documented each functionality of reports developed.

Environment: Tableau 8.2/8.1,Cognos 10.2(Report Studio, Query Studio, Cognos Connection, Framework Manager), SQL Server, Windows XP, Teradata 13

Confidential, Columbia SC

Sr.BI Developer

Responsibilities:

• Analyze and work with the client to refine requirements and design and develop reports and multidimensional views.
• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the One Carolina reporting Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau
• Created Framework packages with various security settings for capturing business intelligence metadata and published onto cognos connection.
• Implemented data level, package level security.
• Created various List Reports, Cross Tab Reports, Chart Reports, Repeater Drill-Down and Drill-Through Reports, Master-Detail Relationships in Report Studio.
• Created Complex reports using various prompts like Value Prompts, Date & Time Prompts, Text Box Prompts, Cascading prompts.
• Developed complex reports using Conditional Blocks, style and render Variables.
• Deploy packages and reports using cognos schedule management features.
• Analyze database execution plans and index structures to improve report performance.
• Document business requirements related to reporting and analysis.

Environment: Tableau Server v7/8, Tableau Desktop v7/8,Cognos 10.2(Report Studio, Query Studio, Cognos Connection, Framework Manager), Oracle 10g, Oracle ERP, Toad for Oracle and SQL Server, Windows XP.

Confidential, East Hartford CT

Sr.Cognos Developer

Responsibilities:

• Interact with the Line of Business for requirement gathering by participating in Joint Application design/development sessions to understand and document business requirements and development process.
• Work with the line of business to define the business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.
• Developed the mapping specifications from the business requirements and the data model.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Oracle server that can be used for development of various Tableau reports/ dashboards.
• Involved in administrative activities, doing deployment and monitoring schedules and jobs on Tableau server.
• Migrated Cognos dashboard report to Tableau visualizing dashboards using Tableau Desktop.
• Created simple report schemas for users to create their own Adhoc reports using Tableau.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters
• Involved in designing models with Relational Data using Framework Manager from multiple data sources.
• Created Database Layer, Business Layer and Presentation Layer by defining appropriate relationship between query subjects in Framework Manager.
• Created Model query subjects, Data Source query subjects as per the business requirements in Framework Manager.
• Publish the packages onto Cognos Connection.
• Enhance the packages by refining the Joins, Segmenting, Linking, Nesting and created filters at package level.
• Implemented Data level, Object level and Package level security in Framework Manager to achieve complex security standards.
• Generated various Ad-hoc using Query Studio
• Created various List Reports, Cross Tab Reports, Chart Reports, Drill-Down and Drill-Through Reports, Master-Detail Relationships in Report Studio.
• Created Complex reports using various prompts like Value Prompts, Date & Time Prompts, Text Box Prompts, Cascading prompts and Tree Prompts.
• Developed complex reports using Conditional Blocks, Conditional Variables and report bursting.
• Involved in performance tuning of reports.
• Worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency
• Scheduled reports to run on a monthly, weekly and daily basis and check for an execution status on a timely basis using Event studio and schedule Management in Cognos Connection and trouble shoot failed reports.
• Created and performed testing strategy and test plans for any changes to cognos reports.
• Coordinated with the line of business users for User Acceptance testing prior to releasing system changes to production.
• Involved in deployment of reports and packages from DEV to UAT and from UAT to PROD.
• Support unit testing, integration testing and user acceptance testing.
• Worked in Production support by providing quick resolution.
• Effectively documented each functionality of reports developed.

Environment: Tableau 7, Cognos 10.2/10.1 (Report Studio, Query Studio, Event Studio, Cognos Connection, Framework Manager), Informatica 9.1.0, Oracle 10g, SQL, Toad for Oracle and SQL Server, Windows XP, Teradata 13

Confidential, Santa Clara CA

Cognos Developer

Responsibilities:

• Analyzed the business functional requirements and worked with the business units to define the strategy of the business and created centralized reporting capability.
• Worked on different projects that involved creating project plans, managing the project.
• Created Framework packages with various security settings and published onto cognos connection.
• Created Database layer, Business layer in the model by defining appropriate relationship between query subjects.
• Defined package level, object level securities to allow users create calculations over the query items.
• Modeled the metadata in the project by adding business rules such as filters and calculations.
• Build power cubes with package as source using power play transformer.
• Generated packages out of the cubes and published onto cognos connection
• Developed complex reports like multipage reports with master detail relationships, Prompts, Calculations and Conditions using cognos report studio In PDF and excel and adhoc reports using query studio.
• Created analysis from analysis studio using the cube packages as source.
• Created drill through definitions in the reports based of the cubes to drill down to detail level of the data.
• Created List, Cross Tab, Repeater, Chart reports and drill through reports in report studio.
• Perform day to day cognos administration and production support activities.
• Administering user access to reporting applications which includes setting up cognos security by assigning users to the groups and roles defined in the cognos Namespace.
• Giving Access to different folders, Packages, Reports based on the users request.
• Scheduled and distributed reports using Schedule Management In cognos connection.
• Worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Performed unit testing and documented test cases and detail design of the project.

Environment: Cognos 10.1/8.4, 8.3 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection, Framework Manager),Power Play transformer 10.1/8.3, Informatica, Oracle 10g, SQL, PL/SQL, Toad for Data Analyst 2.5, Windows 7/XP,Teradata 12

Confidential, Pittsburgh PA

Cognos Developer

Responsibilities:

• Involved in gatheringBusiness Requirementsfor the Model and for developing reports from the business users.
• Created Framework Manager Packages with various security settings defining the cardinalities and namespaces and published them onto Cognos Connection.
• Establishedrelationships and joinsbetween thequerysubjectsof the Model
• Implemented object level security for query subjects and query items to make them available only for the end users who are authorized.
• Developed complex reports using report studio by using multiple queries and joins.
• Created complex filters, Conditions and complex financial calculations for developing the reports using report studio as per the user requirements. Developed reports using various functionalities like Master Detail, Conditional Formatting, and Conditional Blocks.
• Enhanced reports with new features and functionality based on the business requirements.
• Developed List, Cross Tab, Chart and Drill Through Reports in Report Studio
• Worked on creating prompts and cascading prompts page and Implemented various parameters, filters, calculated measures, aggregations, conditions, & created reports using sub-queries and multiple queries
• Executed report bursting with ensuring data secrecy by defining the burst recipient groups.
• And involved in distribution of report through email and uploading to folders.
• Developed MultiPage Reports withPrompt pagesandConditional Variablesaccording to the end user requirements.
• Testing and improving report performance, performance tuning on complex reports on the report level.
• ManagedCognosConnection Portal and assigned users, roles and groups for authentication and authorization. Edited Governor Settings in Framework Manager to reduce resource requirements and improve performance in SQL execution.
• Worked on scheduling reports to run monthly, weekly and daily basis using cognos scheduler.
• Deployed reports and packages from development to UAT and from UAT to production using cognos administration.
• Support unit testing, integration testing and user acceptance testing.
• Worked in Production Support environment and manage issues by providing quick resolution.

Environment: Cognos 8.4, 8.3 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection, Framework Manager),Microsoft Visual Source Safe 2005, Oracle 10g, SQL, PL/SQL, Toad for Data Analyst 2.5, Windows XP.

Confidential, Deerfield IL

Sr.Cognos Developer

Responsibilities:

• Involved in analyzing and gathering requirements and provide input into project timelines and ensure adherence to project timelines.
• Designed, implemented technical solutions that address complex business requirements and served as a main technical support and perform root cause analysis for problems experienced within all the cognos reports/Models.
• Designed and developed/modified the Framework Manager model packages defining the cardinalities and namespaces
• Designed and developed complex cognos reports and dashboards per business requirements.
• Created list reports and cross tab reports, charts, Maps and drill through reports. Created complex filters, Conditions and complex financial calculations for developing the reports using report studio as per the user requirements.
• Created Multi page reports with grouping and sorting, creating -master detail relationships.
• Used Conditional formatting to discard unwanted columns in the report using style variables
• Used render variable on some report pages and also on List, Bar Graphs to render the list and the graph based on the user selection.
• Used Conditional blocks to display the graphs, crosstab and list based on selection of a value from the value prompt.
• Worked on creating prompts and cascading prompts for the dashboards.
• Experience in developing Dashboards for data management, data quality, and decision making ability and analyzing requirements. Knowledge of logical and physical data modeling and data warehouse architecture.
• Worked extensively in development of Framework Manager Model for development of dashboard style complex reports like Global Clinical Dashboard, Protocol Enrollment, Site Enrollment, Country Enrollment, Milestones and Management Reports throughout the project.
• Implemented Security prototype for cognos business intelligence environment incorporating row level, object level, data level, and package level and report level security.
• Identifying and implementing process improvements in the existing cognos reports/dashboards.
• Performed scheduling of the reports and created report view of a report for the users.
• Deployed reports and packages from development to test and from test to production using cognos administration.
• Worked with cognos support team and Involved in production support by resolving users problems.
• Effectively documented by explaining the functionality of each report /dashboard developed and also documented the framework manager model.
• Support unit testing, integration testing and user acceptance testing.

Environment: Cognos8.4, Framework Manager,CognosConnection, Report Studio, Query Studio, Analysis Studio, SQL Server 2005, Windows XP, Toad for Data Analyst 2.5, Oracle 11g.

Confidential, Pittsburgh PA

Cognos Developer

Responsibilities:

• Involved in business requirement gathering by interacting with managers across the Del Monte facilities to develop reports.
• Developed and published packages onto cognos connection using framework Manager.
• Developed complex reports using report studio.
• In order to provide optimal flexibility and usability all the reports are generated in Excel so that the users can further manipulate the data using Excel functions if they so choose.
• Created complex filters, Conditions and complex financial calculations for developing the reports using report studio as per the user requirements.
• Created Multi page reports with grouping and sorting, creating -master detail relationships.
• Used Conditional formatting to discard unwanted columns in the report using style variables and used render variable on some report pages to render the page based on the user selection.
• Developed List, Cross Tab, Chart and Drill Through Reports in Report Studio
• Worked on creating prompts and cascading prompts page.
• Created complex reports by using multiple queries and joins.
• Worked on scheduling and publishing the reports to cognos connection.
• Created executive summary report for higher level management.
• Designed and created dashboard style complex reports to provide information on key performance indicators.
• Worked closely with IBM cognos support team.
• Involved in Production Support which involves solving user problems.
• Involved in UAT by writing complex queries.
• Prepared User documentation describing the functionality of each report developed.

Environment: Cognos8.4, Framework Manager,CognosConnection, Report Studio, Query Studio, Analysis Studio, Power play studio, SQL Server 2005, Windows XP, Toad for Data Analyst 2.5, Oracle 11g.

Confidential, Bellevue WA

Cognos Developer

Responsibilities:

• Involved in gatheringBusiness Requirementsfor the Model from the business users.
• Actively participated indefining the scope of reporting andreport specification.
• Created and presented prototype Models and reports to high level Business users.
• Worked on Designing and developing complex reports.
• Participated in Tech. design review for BI applications to ensure appropriate use of Cognos
• Queried from different database tables as per the requirement.
• Designed and developed many packages using Framework Manager and published Packages using Framework Manager.
• Establishedrelationships and joinsbetween thequerysubjectsof the Model
• Implemented object level security for query subjects and query items to make them available only for the end users who are authorized.
• Worked extensively on creating the Model and publishing the package onCognosConnection for Reporting purposes
• DevelopedStandard Reports, Charts, Drill-Through Reports, Master Detail ReportsandBursting ReportsUsing Report Studio.
• Set up bursting options for reports.
• Created complex reports which involveQuery Prompts, Layout calculations, Conditions & Filters
• Developed MultiPage Reports withPrompt pagesandConditional Variablesaccording to the end user requirements
• Cognos Administration functions included managing content manager settings, setting routing keywords for server groups, setting routing keywords for packages and user groups and roles
• Set the report size limit for report data service, Performed Content Store Maintenance on External Namespaces and Created Cognos Groups and Roles.
• Scheduling and Distributing Reports throughSchedule ManagementinCognosConnection Portal
• Support the Development Teams for the Cognos related Issues.
• Involved inunit testing and Functional testingto finalize the Report Accuracy.
• Deploy all Reports and Packages from Dev environment to production Environment. Using Content Administrator.
• Wrote the sql statement for Data validation of Report Studio Reports.

Environment: Cognos8.4/8.3, Report Net 1.1 MR3, Framework Manager,CognosConnection, Report Studio, Query Studio, SQL Server 2005, Windows XP/ 2000.

Confidential, Boston MA

Cognos Developer

Responsibilities:

• Analyzed the Business functional requirements and documented the technical specifications.
• Created Packages with various security settings and published them onto Cognos Connection.
• Created Framework Manager Packages defining the cardinalities and namespaces.
• Modeled Metadata in the project by adding business rules such as filters and calculations.
• Implemented Cognos 8 distributed environments, Developed Dimensional Models for Cognos 8 Analysis Studios, Migrated Power Play cubes to Cognos 8 Framework Manager.
• Created DMR models in framework manager in order to create multidimensional reports in analysis studio and report studio.
• Defined security over packages, package level access and object level access to allow users to create calculations over the query items. Created Roles and Groups and assigned permissions to users in Cognos Name space for security.
• Migrated Power play 7.1 Cubes to Power play 8.1.1.
• Reviewed the existing Impromptu environment and made the necessary changes to them so that the migration to Cognos 8 would be successful.
• Served as the Subject Matter Expert in designing the migration strategy from Impromptu to Cognos 8.
• Developed complex reports in report studio in PDF and EXCEL format to meet the specifications given in the business requirements.
• Integrated various conditional prompts, cascading prompts, conditional variables in the report. Developed Prompt pages and Conditional Variables.
• Created multipage reports with master-detail relationships, Query Prompts, Calculations, Conditions & Filters.
• Recommended Indexes to improve the performance of the report.
• Used conditional formatting to discard the unwanted columns in the report.
• Created Public Folders, Private Folders, My pages and custom views in Cognos Connection.
• Securing cognos Connection and setup Cognos security by assigning users to the groups and roles defined in cognos Namespace.
• Implementing the plan to migrate from cognos 8.2 to cognos 8.4.

Environment: Cognos 8.4, Cognos 8.2,Cognos EP series 7.1, Report Net 1.1 MR3, Framework Manager, Report studio, Query Studio, Analysis Studio, SQL and MDX, Power Play Transformer Version 7.1/8.1, DB2,Windows XP.

Confidential, Boston MA

Cognos Report Net Designer

Responsibilities:

• Created projects, designed models for reporting and created published packages in Framework Manager from various data sources.
• Created Star Schema Layers, Business Layers, and Data Source - IQD layers in Report net Framework Manager Model.
• Performed a proof of concept for using Report net for the company’s reporting requirements.
• Installed Report net 1.1 MR1 and framework manager and configured Report net to the existing Environment.
• Developed complex reports using report studio with master detail relationships.
• Created an executive summary report with more than 80 queries and fine-tuned the report to run efficiently.
• Generated cubes using Cognos Power Play Transformer.
• Designed & created catalogs in Impromptu Administrator to create BI reports based on the analysis performed. Designed catalog folders for Cognos power users.
• Designed and Developed the Agent Profit Sharing reports and drill-through.
• Writing the test case and validating the report data.
• Writing the technical specifications for the reports.
• Participated in the process of Identifying BI tools for the future.

Environment: Cognos Impromptu Administrator 7.1 MR2, Impromptu Web Reports (IWR) 7.1, Cognos Upfront 7.1, Cognos Power Play Transformer, Cognos Power Play, Access Manager 7.1, Microsoft IIS, DB2,Oracle 8/9i, SQL server 2000/2005,MS-Excel, Dbase & MS Access.

Confidential

Cognos Consultant

Responsibilities:

• Created Power Play cubes using Transformer (Power Play).
• Reporter Operations such as Sum and Average.
• Exception Highlighting, Sorting, Ranking etc.
• Changing filters, layers and measures.
• Created Multi-Dimensional reports using Power Play.
• Created Business Mix reports and Top ten reports.
• Designed and developed multi dimensional cubes, Visualizations.
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Generated reports using Cognos Impromptu tools querying database.
• Created Filters, Conditions and Prompts in Catalog.
• Developed Impromptu Web Reports (IWR) and published them into Upfront.
• Created Impromptu Reports and published them to the PPES server.

Environment: Cognos Impromptu 5.0, Impromptu Web reports (IWR), Power Play, Transformer, Toad, DB2, Oracle 8.x, Windows 2000/ UNIX.