SUMMARY

• Business Intelligence Cognos Professional with Over 8 years of complete BI project life cycle experience using various Cognos and Tableau versions.
• Experience in software design, development, integration, implementation and maintenance of Business Intelligence and DB2 database platforms.
• Experience in Administration, Design, Development and Deployment of data warehousing and business intelligence applications using COGNOS 11X, 10X, 8 BI Suite, ReportNet.
• Extensively worked on Cognos tools such as Cognos Series 11x, 10.2 BI, Cognos ReportNet v1.1 MR2(Report Studio, Query Studio, Framework Manager, Cognos Connection) Impromptu, Power Play, Upfront and Cognos Query.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in Data Warehousing and Business Intelligence area in various domains.
• Strong hands on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.
• Good knowledge of Data Warehousing concepts, RDBMS and multidimensional schema (Star Schema and Snowflake Schema).
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Involved in Full Life Cycle Development of Reporting Projects, which included requirements gathering/analysis, design, development, testing and production roll - outs.
• Defined best practices for Tableau report development and DB2 database scripting.
• Involved in Requirement gathering from Business Users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Developed reports using free form SQL as per the user’s requirements.
• Worked on migrating reports from Cognos 10.x to latest versions and Tableau using Gap analysis.
• Preparing Dashboards using calculations, parameters in Tableau 7.0/8.1 and involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRS on SQL Server (2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Experience in developing complex reports (List, CrossTab, Chart, Singleton Repeater, Active Reports) using drill-through, prompts, master-detail, burst options, dynamic filtering.
• Provided 24x7 production supports for applications based on Cognos products.
• Experienced in gathering of User requirements and responsible to provide efficient end-user training and designing report specifications.
• Excellent analytical, coordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly

TECHNICAL SKILLS

BI tools: IBM Cognos 11.1.1,11.0.9,11.0.7, 11x, 10.2.2/10.2.1 /10.1, 8 BI Suite (8.1/8.2/8.3/8.4 ), Active Reports, Report Studio, Framework Manager. Tableau 7.x/8.x Desktop and Server.

Databases: SQL Server, Oracle 11g, Oracle 10g, DB2

Languages: SQL, PL/SQL, Java-Scripts.

Packages: Microsoft Office Suite, Visual Studio.

Data Modeling Tools: Erwin 4.1, Visio 2000.

Other Tools: Directory Tool, Server Administrator Tool, Deployment Tool, Capabilities Tool, Schedule Management Tool, InfoBurst, SAP Desktop Intelligence, SAP Business Universe, TFS, JIRA.

PROFESSIONAL EXPERIENCE

Confidential, Gahanna, Ohio

Cognos Developer

Responsibilities:

• Migrating reports from SAP Business Objects to Cognos Analytics.
• Understanding existing reports in BO and implementing standards to develop model in framework manager.
• Developed complex framework model that includes parameter maps & session parameters.
• Involved in developing complex reports which includes complex queries, calculated fields.
• Implemented self-service reporting to end users & had one-one interactions with business to help them understand & develop adhoc reports.
• Implemented Framework Manager Security for row level access and package access based on the Department, Region and Store Level.
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, charts, master-detail, maps, various calculations and joins using tabular sets and models.
• Extensively worked on Active reports to create static reports for offline users.
• Performed burst of Reports against the regions, districts, and stores for delivering by email; appropriate outputs to the concerned business users in Cognos Connection.
• Created several different types of Ad-hoc (simple list, grouped list, section heading, crosstab, and nested crosstab) reports and represented data graphically by charts using Query Studio.
• Implemented prompt validation and added various functionalities to prompt pages using JavaScript in order to extend and customize the reporting functionality, visualization and presentation experience.
• Created Cube and partitioned cube manually; added User Class views, Dimension Views, and Drill through capability using various data sources in Transformer to be analyzed in Analysis Studio.
• Created agents and added tasks in Event Studio to run reports based on specific business criteria.
• Performed scheduling and maintenance of reports using Cognos Connection and third-party scheduling tools.

Environment: Cognos 11.1.1, 11.0.9, 11X, Cognos 10.2.2 (Framework Manager, Report Studio, Analysis studio, Query Studio), HTML, DB2, Oracle 11g, SQL Server 2016, JIRA.

Confidential, Columbus, OHIO

BI Developer/Administrator

Responsibilities:

• Gathering & documenting requirements from business users & modelling data as per the requirements for developing dashboards & reports using Cognos 11x.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and SnowFlake Schema.
• Developed complex dashboards for business for various projects using Cognos report studio, Workspace with calculations, global filters depending on the requirements.
• Involved in providing Cognos BI self-service training to various product owners to make them develop their own ad hoc reports.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Built SSIS package as a part of extracting, transforming & loading the data to BI database.
• Proficient in using lookups, SQL tasks & other components in SSIS; deploying packages in SSIS & automating them through JAMS.
• Built cubes using SSAS for the business & deliver them through SSRS for Self-Service reporting.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Expertise in implementing row level security & data level security for framework packages.
• Worked on implementing report level security as per user class.
• Worked for production support in resolving numerous service now tickets for dashboards/reports & self-service packages.
• Created a master framework using Framework Manager and published several packages for developers and power users to access data.
• Implemented Row-level security, by importing the security tables and joining them to the existing dimensional tables, using the Sessions parameters and parameter maps.
• Experienced in administering the created reports and assigning permission to the valid users for executing the reports.
• Package development and designing using transformations such as derived column. conditional split, lookup, execute SQL task.
• Experienced in enhancing, creating framework manager models to build reports.
• Built SSIS packages to extract, transform & load data as per business needs.
• Involved in completing & delivering multiple dashboards & reports to business users.
• Developed and successfully deployed multiple initiatives with Executive Dashboards with charts and reports with easy navigation into subsequent reports by drill down feature.
• Experience in Deployment (Export, Import) using Framework Manager into Cognos Connection.
• Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Extensive one to one interaction with end users/Business analysts to identify their needs and wants, then translate the functional requirement into reporting requirements, design and business data flow.
• Expert in all stages of Software development life cycle (SDLC) which includes requirement analysis, design, development, testing and documentation.
• Strong troubleshooting and production support skills and coordination/ interaction abilities with end users.
• Self-motivated and enjoy working in a technically challenging environment.
• Possess excellent communication and interpersonal skills.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Migration to 11.0.0 from 10.2.2: Exporting & importing Cognos content from version 10.2.2 to version 11.
• During the upgrade performed troubleshooting the dashboards, maintained a detailed upgrade plan, created test, dev & prod environments, applied new features wherever applicable.
• Created a test plan to test the performance of existing reports & dashboards after migration.
• As a part of migration full content store export deployment is performed; Outlined a project timeframe for the same; Assigned tasks to the available resources for this; Estimated production shutdown time & backup plan is maintained in case of any issues faced (but as planned appropriately the migration went smooth).
• Applied all configuration fix packs needed & conducted minimum testing. Maintained documentation regarding the migration plan & execution.

Environment: Cognos 11.0.7,11X, Cognos 10.2.2 (Framework Manager, Report Studio, Analysis studio, Query Studio), JavaScript, HTML, SQL server 2016, Oracle 11g, TFS

Confidential, Flint, MI

Sr. Cognos Developer

Responsibilities:

• Communicated with departments to define business strategy to create centralized reporting capability for analytical and ad hoc reporting
• Wrote requirements specification documents and designed report mockups.
• Created metadata models, used data extracted from multiple DBs, and created joins and cardinality; assisted in designing DMR models; deployed packages; created filters, calculations, conditions, and layouts; developed imports/ exports to deploy reports and implemented security/access management.
• Worked on performance tuning and scheduled reports to run at non-peak hours.
• Interfaced with users during testing to verify data accuracy.
• Built BI reports, models, dashboards, and templates for merchandising, sales audit, warehouse management, inventory optimization, and other areas.
• Worked with users, to define reporting requirements for various services and processes using Cognos 10.2.2 series, organized reporting applications like Report Studio into different folders in Framework Manager for sales and distribution department.
• Generated Transformer Models using Cognos Transformer and ability to generate the resulting cubes using Transformer for multi OS platform
• Created Calculations, Filters, Drill through, Cross-tab for easy access to run the reports, handled several drill down and visualized dashboards.
• Created groups and users, roles, folder deployment, grant access permissions, scheduling reports and setting up default prompt values.
• Created user groups for distribution and assigned security based on different roles for those who used dashboard and Scorecard (metric studio).
• Created complex views and appended tables into SQL server and expertized in maintaining database.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/ using SQL Profiler, Query Analyzer
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration
• Created cubes using Cognos Transformer and maintained them on dev, test and prod environments.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• As a part of production support team resolved tickets & performed troubleshooting framework models & dashboards.

Environment: Cognos 10.2.2, Cognos 10x (Framework Manager, Transformer, Report Studio, Analysis Studio, Query Studio, Java Script, HTML, SQL server 2012.

Confidential, Austin, TX

Sr.BI developer

Responsibilities:

• Interacting with the Business Users, Suppliers teams for understanding the as-is process flow and new business requirements or enhancement activities.
• Documenting the Business Requirements for report development, coding, testing, and passing it to peer review.
• Designing, constructing, unit testing the Framework Manager Models, Report Studio reports and Stored Procedures.
• Creating Technical Design Documentation for Reports, Framework Models and Stored Procedures.
• Creating Test Cases for Reports, Framework Models and Stored Procedures.
• Modified framework models as a part of production support to meet the business requirements.
• Updated the framework models whenever there are any new tables or security changes required to be done for business.
• Providing data level security when needed. Worked on session parameters in FM package.
• Developing the reports/Stored Procedures/Framework Models as per the Technical Design documents.
• Migrating all the Objects from Development to Staging and then to Production after the testing Phases. Playing a developer role and a Quality System Support Analyst role for some issues in the missing parts and Reports/Logic in Stored Procedure and other Maintenance issues received from users.
• Designed Freeform SQL reports for meeting specific needs.
• Played a master role in writing stored Procedures for the Reports and improving up the performance of the Reports.
• Creating the bridge between the clients and users for various issues and challenges.
• Solving the issues independently for design, development of Technical specifications and coding the reports and stored procedures.
• Creation of OLAP Transformer Cubes from IQD’s /Cognos Connection Package.
• Customizing user class security views in Cube by user classes / Roles.
• Providing Access to users, Suppliers, Business Analyst and engineers for the Integrating the Cognos reports.
• Built variety of Executive Dashboards for a quick glance of various attributes/KPIs for Executive management.
• Upgraded all DEV, UAT and PROD servers with the latest Cognos 10.2 software.
• Developed various complex reports using List, Crosstab and Chart objects.
• Used HTML and JavaScript to improve the look and feel of the reports.
• Migrated Reports, Packages, Cubes and folders from one environment to other (DEV, UAT & PROD) upon user requests.
• Created Data Connections in Cognos Administration, to connect various cubes through Framework Manager.
• Created various roles to access the reports for different levels of users. Worked extensively to achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
• Involved with the Solutions Architect and the QA team for validation and verification of the development.
• Created Technical design documents and transferred technical knowledge specific to Cognos tools and existing data model to other team members.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• As a part of my project, worked developing complex dashboards using Tableau 9.0.
• Extensively worked on building, publishing customized interactive reports and scheduled reports using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau users.
• Expertise in writing large/complex queries using SQL.

Environment: Cognos 10.2.1, Cognos 10x (Framework Manager, Transformer, Report Studio, Analysis Studio, Query Studio), Tableau 9.0, Tableau 8x, Java Script, HTML, Oracle 11g

Confidential, Newark, NJ

Sr. BI developer

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Experience in designing reports using freeform SQL. Configuring, developing, designing and maintaining SQL and Oracle databases. 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.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Deployed Cognos OLAP Cube from Testing Environment to Production Environment using Batch script. Experience working on dynamic cubes.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI. Converted Cognos based reports into tableau reports . Gathered user requirements, analyzed and designed software solution based on the requirements.
• Delivered solution-oriented complex reports using Report Studio, ad-hoc reporting interfaces using Query Studio, multi-dimensional analysis & visualizations from OLAP cubes using Analysis Studio, created checkpoints & alerts in Event Studio, and developed scorecards, metrics in Metric Studio.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Involved in migration projects to migrate data from data warehouses on pl/sql and migrated those to Teradata. Used Freeform SQL feature where we can use both single-pass and multi-pass SQL queries to generate reports. Converted multi-pass SQL statements into derived table or common table expression syntax that can be completed in a single pass.
• Worked in multiple phases of Software Life Cycle starting from the scratch to production delivery. Migrated the Cognos reports from 8.4 version to 10 version.
• Single point of contact for client for all reporting & SQL database questions/concerns. Created and published packages for different subject areas with best practice, using Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Created DMR model with Dimension and Hierarchies for providing drill downs & drill throughs in Analysis Studio. Created list, crosstab and chart reports and implemented drill-through conditions and Master-Detail relationships. Used various kinds of prompts like Value Prompt, Date and Time prompt, Cascading Prompts, etc. for better performance, also worked with customized prompts using HTML Items.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries. developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS)
• Took part in the migration from cognos 8 to cognos 10.2.2.
• Performed hardware inventory, software inventory, reviewed existing cognos environment & system architecture including any system wide customizations.
• Maintained documentation during migration.
• Part of Unit testing and data validation of various reports that were developed in Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Carried out performance tuning of reports, both on database side and Cognos report and modeling side.
• Used Business Workspace / Insights and Business Workspace / Insights Advanced to arrange individual reports into dashboards.

Environment: Tableau 8.0/8.1/8.2/8.3, Cognos 10.2.2/10.2.1, 10.1 (Report Studio, Query Studio, Analysis Studio, DB2, Event Studio, Cognos Workspace, Cognos Workspace Advance), SSIS, ETL, Framework Manager, Oracle 11g, and SQL Server 2005, MySQL, TFS Version Control.

Confidential, Somerset, NJ

Sr. BI Developer

Responsibilities:

• Automating the processes to import data from various sources into single centralized repository and utilized Cognos and Tableau to display the reports.
• Involved in migration of reports from Cognos 10.2 version to latest versions and migrating it to Tableau.
• Gathered user requirements, analyzed and designed software solution based on the requirements in SQL.
• Used free form SQL reports in stored procedures to return the dynamic columns
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop which were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created SQL server Reports using SSRS 2008.Identified the data source and defined them to build the data source views
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS)
• Worked on getting the user requirements and converting them into tableau visualizations.
• Designed and developed tables, and stored procedures and prepared the data for Tableau.
• Developed Dashboards using calculations, parameters in Tableau.
• Handled Tableau Admin activities granting access, managing extracts and managing user groups.
• Installed database Clients for SQL Server 2012/2014, DB2 and Oracle, established and tested database and content store connectivity on the Cognos Production environment.
• Acted as a bridge between the business users and technical users, translating the technical terms to business users and vice versa.
• Developed and maintained the technical design specifications of Metadata Layer presentation and Report specifications documents with best practices.
• Developed the Standard report templates, report specification and design, detailed dashboard and report design from high-level specifications, including visual layouts, master-detail and drill-down/drill-through relationships. Applying security to reports and to control user views; developing burst reports
• Developed List, crosstab, drill through, master-detail, chart and complex dashboard reports which involved Multiple Prompts, conditional formatting, Filters, multi-page, multi-query reports, which resulted in significant decrease of man-hour requirements while increasing the accuracy and amount of data presented
• Provided data security, object security and package access in Framework Manager, and also secured the folders by setting up access permission in Cognos Connection.
• Created SOP for migration of Framework Manager Packages, reports

Environment: Tableau 7.x/8.x, Cognos 10.1.1 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, SQL Server 2008/2012/2014