SUMMARY

• 9+ years’ experience on Business Intelligence and in different phases of software development life cycle (SDLC) including requirement, analysis, design, development, testing, deployment, and support.
• Cognos Administration: Installation, Configuration, performance tuning across multiple environments (Development, Test, and Production) and Ensure solutions and deliverables are 100% compliant wif teh Client’s SDLC and meet controllership and audit standards.
• Deployed Cognos packages, folders, and Reports from a Development environment to Testing and Production environment.
• Extensive experience wif Cognos security (LDAP, Active Directory, object level security, data security).
• Cognos Development: Developed and Published Packages using Cognos Framework Manager & Adaptive warehouse - Connecting and testing teh data source, created database layer, business layer & presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Created models and reports in Cognos Analytics, 10.2.2, 10.1.1 and 8.4 (Adaptive warehouse, Adaptive Analytics, Framework Manager, Dynamic Cubes, Report Studio, Query Studio, Analysis Studio, Event Studio and Business Insight).
• Complex Report building experience by using prompts, filters, conditional formatting, drill-through and drill-down using Report Studio.
• Developed and maintained dashboards and apply data visualization best practices using Cognos Report Studio and tableau Desktop. Developed reports using External Data Source such as Excel, Text, and CSV files.
• Install Tableau server on Single and Multi-server level node.
• Install Tableau Server and start Tableau Services Manager, Activating and registering Tableau Server, configure local identity store, add administrator account, Validate you're installation.
• Published teh Data Sources, Dashboards to Different Tableau Server environments.
• Providing teh Roles and Security while Publishing to teh Tableau Server.
• Created New Schedule's and validate teh daily tasks on teh server.
• Created various Sites in Tableau server and provided access to this Sites for end users.
• Created users, groups, projects, Data connections.
• Performed Unit testing of teh reports.
• Excellent in Scheduling, Subscription, and deployment of reports in Tableau Server.
• Tableau Development: Designed various dashboards and work sheets utilizing Tableau 2019.4, 2018.2,10.4,10.3 Desktop like Bar Graphs, Bubble Charts, Pie-Charts, Data tables.
• Experience in using Data Blending to merge data from multiple data sources in various analytical dashboards on a single worksheet. Published teh Tableau workbooks on teh Tableau Server for teh users to access teh reports.
• Performed trouble shooting of performance issues associated wif Tableau reports.
• Good experience in using Tableau Server, Tableau Desktop, Cognos BI Suite, Oracle 11g, 10g, 9i, PL/SQL, SQL, Functions, SQL Server 2005/2008/2014 .
• Extensive experience on production support and troubleshoot/test issues wif existing reports and cubes.
• Experience interacting wif Business Users and gathering teh design requirements to develop reports.
• Have excellent problem solving, time management skills, communication skill, good organizational skill, self- motivated, hardworking, ability to work independently or cooperatively in a team and eager to learn.

TECHNICAL SKILLS

OLAP Tools: Tableau 2019.4,2019.3, 2018.2,2018.2,10.5,10.4,10.3 Desktop and Server, Cognos 10.2.2,10.1.1,8.4/8.3 (Adaptive warehouse, Adaptive Analytics Framework Manager, Query Studio, Business Insight, Report studio, Event studio, Metric Studio, Analysis Studio, Cognos Connection, Transformer),SELENIUM Testing tool

R D B M S: Oracle 11g, 10g, MS SQL Server 2005/2008/2014 , Teradata, DB2.

Programming Languages: SQL, PL/SQL, C, C++.

Operating Systems: Windows XP, Windows 7, Windows Server 2003/2008,2012/2016, UNIX.

Methodologies: XP Programming, Sprint, Waterfall Model, Agile Methodology.

Data Modeling: Star Schema modeling, Snowflake Schema modeling and Erwin tool.

Scripting Languages: HTML, JavaScript.

Other Tools: MS Office, MS Excel, MS Power Point, Alteryx

Testing: ETL Testing, Unit Testing, Selenium Testing

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Tableau/Cognos Developer

Responsibilities:

• This project dashboard report is an conversion dashboard which is from an already existing report to Tableau
• Created Service line dashboard, Sub service dashboard, Base MSRDG dashboard
• Created Tab dashboard for Physicians, Facilities, Procedures
• Created various Quick filters for above Dashboard
• Created Drill links from Service lines to all teh way Cases which covers hierarchy of Data for all dashboards
• Performed unit testing for all teh reports.
• Migrating teh dashboards from one environment to various environments.
• Publishing teh data sources and scheduling of data sources wif teh halp of Admin team
• Involved in all Production deployment calls and provided on call support for any of teh production related activities.
• Worked wif ETL developer on ETL workflows and datasets in Alteryx to be used in teh Tableau Reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)
• Prepare technical specifications and documentation for Alteryx workflows supporting BI reports
• Perform end to end Data validation
• Interacted wif in teh team and wif Business user to design teh In-site App Dashboards accordingly.
• Designing and developing Tableau Reports, Documents and Dashboards as per specified requirements and timelines and presenting them in a variety of formats to users.
• Developed various dashboards like Service lines, Procedures, Primary Supply group, Secondary Supply group, Tertiary Supply groups.
• Developed Case Details and Item Utilization Dashboards.
• Developed Vendor Analysis dashboards.
• Created various Data Tables, Bubble and Bar charts.
• Worked in looking various performance issues which has been encountered on above dashboards.
• Extensive noledge in reporting objects like Hierarchies, filters, calculated fields, Parameters etc., in Tableau.
• Created Workbooks by Importing data, Defining Relationships in Tableau Desktop.
• Created Data Table, Drill Down Reports wif Quick Filters in Tableau Desktop.
• Working experience on Tableau wif Relational Database Connectivity.
• Hands on experience in creating parameters, complex calculated fields, groups, and Hierarchy.
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher, and Security.
• Connecting multiple data source wif Data Blending technique.
• Providing teh Roles and Security while Publishing to teh Tableau Server.
• Excellent in Scheduling, Subscription, and deployment of reports in Tableau Server.
• Performing various actions in between dashboards by using action filters and also wif URL’s accordingly.
• Published teh Data Sources, Dashboards to Different Tableau Server environments.
• Created New Schedule's and validate teh daily tasks on teh server.
• Performed Unit testing of teh reports.
• Migrated existing dashboards from 2018.2 to 2019.4 version
• Interacted wif Cognos team to gather requirements for Developing Cognos Reports.
• Created Management Reports and Faculty Practice Solutions reports.
• Widely used Report Studio to create various types of reports like List, Cross tab, Drill through, Drill up/down.
• Migrated Reports from One Environment to another Environment.
• Assisted to Cognos Admin in Installation of Cognos Analytics and worked in resolving some of teh issues that occurred during Installation of Cognos Analytics.
• All teh reports are ready to migrate from Cognos 10.2.2 to Cognos Analytics and test all teh functionality of teh reports during teh migration of Reports.

Environment: Tableau 2018.1.2, 2018.1.1 (Desktop and Server), Cognos Analytics, 10.2.2(Framework Manager, Transformer, Report Studio, Query Studio, Workspace advanced) SQL Server 2014, Windows XP, Alteryx 2019.4.

Confidential, Pleasanton, CA

Sr. Cognos Developer / Tableau Developer

Responsibilities:

• Interacted directly wif Business users for functional specifications of teh reports.
• Working wif Solution architect on Dynamic Cubes using cube designer and published packages for reporting purpose.
• Developed canned and Ad-hoc reports (List, Crosstab, Drill Up-Down, Drill Through reports) using Report Studio and Query Studio.
• Developed 35 Leadership reports based on reporting requirement using Reports studio and validated teh data of teh reports using Workspace advanced.
• Developed 40 SMNF reports and SMR reports and worked all teh enhancements activities that are needed to be done on teh reports.
• Enhancement of 60 Reports by adding additional Measures accordingly.
• Developed Trend Reports based on Leadership and org accordingly.
• Created various reports which has complex functionality 8 to 10 Levels of Drill thru’s and wif different Conditional blocks & Rendering variables to meet business requirement.
• Worked on All enhancement’s activities (80 GL-Cube reports like adding Additional measures, Formatting, Changing teh prompt pages) and validated teh reports per Business requirement.
• Scheduled teh reports for publishing per teh requirements.
• Migrated Reports from One Environment to another Environment
• Unit tested teh Reports and Verified teh Output of Cognos Reports Matches wif teh Legacy system outputs.
• Analyzed requirements for various reports, dashboards and created proof of concept /prototype teh same using Tableau desktop 10.3.
• Designed Summary and Detailed reports using Data Blending feature in Tableau.
• Responsible for converting all excel reports into Tableau reports and dashboards.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created action filters, parameters and sets for preparing dashboards and worksheets in Tableau.
• Experience working wif Tableau server to publish data sources, creating users and Tableau installation.
• Designed various dashboards, worksheets utilizing Tableau Visualizations like Bar Graphs, Bubble Charts, and Pie-Charts.
• Published teh Data Sources, Dashboards to Different Tableau Server environments.
• Created 2 Sites in Tableau server and provided access to this Sites for end users.
• Created users, groups, projects, Data connections.

Environment: Cognos 10.2.2(Framework Manager, Dynamic Cube, Report Studio, Query Studio, Workspace advanced) Oracle 11g, Tableau 10.3 Windows XP

Confidential, Rochester, NY

Senior Cognos Administrator/Developer

Responsibilities:

• Installation and configuration of Cognos 10.2.2, 10.1.1 in both Non-Prod and Prod environments.
• Analyzed teh business requirements and developed models using Cognos framework manager & Adaptive warehouse and published packages for reports development.
• Installed client tools for developers.
• Widely used Report Studio to create various types of reports like List, Cross tab, Chart, Sectioning, Drill through, Drill up/down, Master detail etc.
• Developed Standard Reports, Charts, and Drill through Reports and Burst Reports Using Report Studio.
• Generation of reports using Conditional Styles, Conditional Blocks, Render Variables.
• Created source to target mapping documents for both Cognos 8.4 and for Cognos 10.1.1 applications.
• Trained business users in query studio and report studio, suggested business users how their information can be TEMPeffectively displayed by using different graphs and charts in Dashboards. (Conveying information they need concisely).
• Responsible for upgrading reports from Cognos 8.4 to Cognos 10 in (Dev, UAT, QA) and Production environments and validated using life cycle manager.
• Troubleshooting data related issues in teh reports.
• Worked on Cognos Security to restrict teh users and created different Group’s / Roles and assign teh users to specific Groups.
• Involved in resolving many critical production related issues.
• Customized Cognos Connection Portal to personalize teh homepage.
• Worked wif teh Database team if there are any issues in Database of GDS.
• Worked wif ETL Team in loading all teh Scripts in different environments and following wif teh team if there are any issues identified.
• Created various Groups, Roles, and Users and add teh users accordingly in order to access teh reports both in Non-Prod and Production environments of Cognos 8.4, 10.1.1, 10.2.2.
• Unit Tested teh Reports and verified teh report outputs wif business requirements.
• Worked on all Production issues and incidents related to teh reports/data.
• Handled multiple projects at time.

Environment: Cognos 10.2.2,10.1.1 and Cognos 8.4 (Adaptive warehouse, Adaptive Analytics, Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced), Oracle 11g, Windows 2003 and windows 2008 servers.

Confidential, Rochester, NY

Sr. Cognos Developer

Responsibilities:

• Interacted directly wif Business users for functional specifications of teh reports.
• Created various Report Specification Documents where Business Objects Reports are needed to convert into Cognos Reports.
• Implemented best practices in creating of Framework models by creating all 3 different layers.
• Migrated Framework Packages and Reports from One Environment to another Environment.
• Developed canned and Ad-hoc reports (List, Crosstab, Charts, Drill Up-Down, Drill Through reports) using Report Studio and Query Studio.
• Created several Dashboards using Business Insight so that teh business users can make strategic decisions.
• Generation of various Pie Chart, Bar Chart, and Line Chart on Master/detail and cross tab reports.
• Scheduled teh reports for publishing according to teh requirements.
• Unit tested teh Reports and Verified teh Output of Cognos Reports Matches teh Output of Business Objects Reports.

Environment: Cognos 10.1.1(Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced), Business Objects 6.5, Oracle 11g, SQL Server 2005, Informatica 9.5, Windows XP.

Confidential, Miami, FL

Senior Cognos Developer

Responsibilities:

• Interacted directly wif Business users for functional specifications of teh reports.
• Loaded teh data from Oracle (source) to SQL Server (Target) database using Stored Procedures for Testing.
• Implemented teh best practices in Framework Manager Models like creating different Namespaces for imported Data Source Query Subjects i.e Physical View, Business View and Presentation View.
• Imported data from different Data Sources in Framework Manager Models to create query subjects, Dimensions, Measures for developing Star Schemas.
• Widely used Report Studio to create various types of reports like List, Cross tab, Chart, Sectioning, Drill through, Drill up/down, Master detail etc wif dynamic parameter passing across teh reports.
• Created reports using different types of prompts like Text Box Prompt, Value Prompt, and Prompt Button etc wif different conditions.
• Developed canned and Ad-hoc reports (List, Crosstab, Charts, Drill Up-Down, Drill Through reports) using Report Studio and Query Studio.
• Used various query components of Report Studio including Join, Union and Intersection.
• Created several Dashboards using Business Insight so that teh business users can make strategic decisions.
• Prepared CRD’s for Migrating reports from Development Server to Production Server.
• Unit Tested teh Reports and verified all teh requirements.

Environment: Cognos 10.1.1(Framework Manager, Report Studio, Query Studio, Business Insight), Cognos Connection, Oracle 11g, SQL Server 2005, SSIS, Windows XP, Microsoft Office Excel 2007/2005, Windows Server 2008.

Confidential, Pittsburgh, PA

Cognos Developer

Responsibilities:

• Gathering functional requirements, analyzing and transforming them into BI Reporting specifications.
• Assisted in teh Data Mart design for reporting and process flow of Data Warehousing. Working wif Data Architect team and ETL team to get teh required data for teh reports.
• Implemented teh best practice in Framework Manager Models like creating different Namespaces for imported Data Source Query Subjects, Business View and Dimensional Model.
• Created various List and Cross tab reports using report studio of Cognos 10.1.1 and also used Drill thru, Drill Down and up functionality to create teh reports.
• Created source to target mapping documents Cognos 10.1.1 applications of Framework manager wif teh Database accordingly.
• Used Page Breaks, Calculation, conditions, Sections, ranking, sorting, various prompts and burst options wifin Report Studio.
• Migrated Framework Models, Packages and Reports from Cognos 8.4.1 to Cognos 10.1.1.
• Used to perform Bursting of teh reports to end user based on teh request received.
• Scheduled Reports based on teh request from users.
• Trained business users in query studio and report studio and provided teh information to teh end users on different ways to analyze teh data by exporting content to Excel and PDF accordingly.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight), Cognos Connection, Oracle 11g/10g, SQL Server 2008, Windows XP.