SUMMARY

• Over 5+ years of experience in analysis, design, testing, development, documentation and implementation of Business Intelligence Applications using Cognos BI tool.
• Experienced in various Cognos tools such as Cognos 11,10 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.
• Experience in Cognos BI Server Installation and Configuration, configuring database server and web server connectivity for use with Cognos.
• Adept at creating metadata with relational model and dimensional model from data marts using Framework Manager.
• Experience in developing medium to complex Congo’s reports using data from various internal databases in SQL Server and Oracle. Develops medium to complex Cognos reports using data from various internal databases in SQL Server and Oracle.
• Experienced in migrating reports from Impromptu to ReportNet.
• Extensive experience in developing detailed functional documents and technical design for reports.
• Experience in upgrading reports from Cognos 8 to Cognos 10.
• Experience in developing customized templates for uniformity in reporting.
• Developed BI reports extensively in report studio by creating various Drill - Throughs, Cross-Tabs, Dashboards, Master Detail and Summary reports.
• Experience in working with business intelligence tools that included system analysis
• Experience in data warehousing principals and experience generating reports from large data sets
• Experience in creating scorecards by using Metric Studio for performance evaluation.
• Experience in creating dynamic dashboards with analytical knowledge and best practice to meet teh business needs.
• Expertise in reporting using Star schema model.
• Experience in Tableau reporting.
• Extensively used Cognos 11,10.x features like Conditional Blocks, Master Detail, Drill through Bookmarks, Conditional Formatting, HTML, Cascading Prompts and Tree Prompts.
• Developed various kinds of prompts and filters to increase retrieval speed without compromising on teh scope of teh reports.
• Proficient in Performance Optimization of reports and Multidimensional Cubes.
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man.
• Experience in writing complex SQL queries
• 3 years of experience working with visualization tools like Tableau and OBIEE.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6.x/7.x/8.x,10.x.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on teh development of Dashboard reports for teh Key Performance Indicators for teh top management.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles,
• Histograms, Bullets, Heat maps and Highlight tables.
• Expertise in Pareto charting, advanced calculations, work with demographic and geographic fields.
• Experience in creating ODBC, XML, Native Metadata Data source connections.
• Experience in setting up Security prototype for Cognos Business Intelligence environment by incorporating data level, object level and package level and report level security.
• Adept at using relational databases like Microsoft SQL Server, Teradata and Oracle with Cognos.
• Have a clear understanding of Data Warehouse architecture and building Dimensional Models.
• Very good in writing SQL queries for data validations.
• Strong Experience using PL/SQL and MDX in development and testing of reports, analyzing data in tables, Cardinalities between tables and joining tables.
• Good knowledge of Software Life Cycle Development process, with focus on Agile Scrum, Waterfall and Iterative mythology.
• Expertise in OLTP/ OLAP system study, analysis, E-R modeling and developing database schemas like Star schema and Snowflake schema.
• Knowledge in SAP BW, SAP BO, SAP HCM, OBIEE, SAS.
• Performed Unit testing (White box testing) for teh developed codes and provided signoff from teh Dev box before moving to QA environment.
• Involved in deploying teh code from Dev to QA, QA to UAT and from UAT to Prod.
• Quantitative Finance background with strong mathematical aptitude and deep research skills.
• Extensive knowledge of sales, marketing, supply chain and finance KPI’s.
• Experience in interacting with end users, SMEs and BAs to gather requirements for reporting.
• Excellent oral and written communication skills.
• Excellent team player with self-motivation and experienced in task prioritizing and time management.

TECHNICAL SKILLS

BI Tools: IBM Cognos 11.0.10, 10.2.1/10.2/10.1 , Cognos 8.x Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Event Studio, PowerPlay Transformer, Cognos Workspace Advanced, Cognos Workspace, Business Insight Advanced, Business Insight and Framework Manager. Tableau 9.x

SDLC Methodologies: Waterfall, Iterative, Agile/Scrum

Databases: MS SQL Server 2008/2012, Oracle 9i/10g/11g, DB2, MS Access, Sybase ASE/IQTeradata 14, 13, V2R12, V2R6

Database Tools: TOAD, Rapid SQL, Query Analyzer, SQL Developer, SQL Assistant

Data Modeling: ER/Studio 3.5/4.0, Erwin 7.3/4.1, Power Designer

ETL Tools: DataStage, Informatica Power Center, Ab Initio, SSIS

QA Tools: HP ALM, Quality Center 11/10, Rational Clear Quest

Languages: SQL, PL/SQL, HTML, DHTML, JSP

Web Servers: IIS, Apache Web Server

Operating Systems: Windows 2000/NT/XP/Vista/7/8, Server 2003/2008/2012 UNIX, Ubuntu

PROFESSIONAL EXPERIENCE

Confidential, Chattanooga, TN

Cognos Developer

Responsibilities:

• Worked in multiple phases of Software Life Cycle starting from teh requirement analysis to production delivery.
• Single point of contact for client for all reporting & 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 Dimensions and Hierarchies for providing drill downs & ups in Analysis Studio.
• Created list, crosstab and chart reports and implemented drill-though 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.
• Extensively used filters, calculations, conditional variables, multiple queries for data extraction in reports.
• Created conditional variables to change teh graph headers and list column headers based on teh user parameter selection.
• Created multiple Report Pages usingPage Breaks and grouping/sorting.
• Created Burst Reports, distributed and scheduled reports in Cognos Connection.
• Used Union, Intersection, Except, and Join between queries in query explorer.
• Developed several active reports of Dashboard with tab control in Report Studio
• Deployed reports, models and cubes from Development to Test and Production environments.
• Developed Stored procedures and user defined functions using PL/SQL.
• Performed Unit testing and data validation of various reports that were developed in Cognos.
• Involved with making changes in teh reports generated as business requirements changed and carry out validation and verification of teh reports.
• Carried out performance tuning of reports, both on data base side and Cognos report and modeling side.
• Used Business Workspace / Insights and Business Workspace / Insights Advanced to arrange individual reports into dashboards.
• Upgraded reports from Cognos 10.2 to Cognos 11.
• Worked on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all teh environments.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups and scheduled instances for reports in Tableau.
• Developed teh free form SQL reports, reports, standard reports and Dashboard reports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tab dmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Environment: Cognos 11.0.10,10.2.2, 10.1 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace, Cognos Workspace Advance), Tableau 9.1, Tableau Server v8/v7, Teradata 14/12, Teradata SQL, Free Form SQL, SQL Assistant, Framework Manager, Oracle 11g, and SQL Server 2005/2008, Informatica, TFS Version Control.

Confidential

Cognos Developer

Responsibilities:

• Installed and configured teh Cognos 8.4 /10.2.2 BI applications with its complete suite of tools.
• Installed and configured Framework Manager Client tool to build metadata models for teh reports.
• Provided overall administration, configuration, security, and maintenance for teh Cognos environment. Monitor system utilization and performance, troubleshoot and contact IBM support when problems arise, plan and test for system patches or upgrades, and offer new ideas for improvements.
• Installed fix packs or hot site on Cognos 8.3/8.4, Cognos 10.
• Setup Cognos Custom roles based on business user requirements for power users and consumers.
• Troubleshoot teh environment in case teh BI server goes down, if not contacted teh DBA in case of teh down time of teh content store database.
• Configured Single Sign-on for Cognos 8.3/8.4/10.1/10.2.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in
• Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Security validation of user access/Data source access through Cognos Access Manager.
• Involved in Requirement gathering from Business Users.
• Analyzed teh requirements provided by teh clients and Developed specification documents for reports as per client requirements.
• Developed new reports in Report Studio upon requests from business users.
• Created and published Packages using Framework Manager.
• Implemented data level security, object level security and package level security using teh Framework manager and Access manager.
• Designed & developed multiple reports using various templates like list reports, crosstab reports, chart reports, and complex reports with conditional blocks, static choices in prompt.
• Extensively used various Prompts, Drill-through, master-detail relationships, conditional formatting, grouping and sorting features, layout calculation of Report Studio to generate efficient and user-friendly reports.
• Deployed packages, folders and reports from a development environment to Testing and Production environment.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Interacted with teh End users on a regular basis for resolving issues pertaining to teh reports.
• Created list, crosstab and drill through reports for departments like claims, billing, and members/subscribers.
• Created Burst Reports and Multilingual Reports based on groups of users & Preferences for our various partners.
• Defined hierarchies according to business requirements for Drill ability.
• Created some Complex interactive reports using conditional formatting.

Environment: Cognos 10.1, 8.4, Tableau Desktop 7, Tableau Server, Teradata SQL, Free Form SQL, Teradata V212, SQL Assistant, Business Objects, Transformer 8.4, Report Studio, Query Studio, Event Studio, Analysis studio, Oracle 11g, DB2, SQL Server 2008/2012, HP Quality Center 10.0, Remedy, TOAD.

Confidential

Cognos Developer

Responsibilities:

• Analyzed teh functionality and business requirements and transformed teh Functional Design Document into Technical Design Document.
• Conducted User Interviews and documented their query, business analysis and reporting needs. Understood data and business logic with reporting viewpoint.
• Installed Multi-Server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments.
• Install/setup Cognos 10.1 software, Upgraded teh Cognos 8.4 content to Cognos 10.1 Troubleshoot upgrade problems/fix issues.
• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
• Used Dimensional modeling (DMR) and Snow flake / Star Schema modeling technique to develop models.
• Implemented Row Level Security in Framework Manger, Data Level, Object Securities and Package Level Security in Framework Manager Models.
• Designed Reports using most of teh Report studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, and Drill Up).
• Developed complex Report Studio reports and Dashboard reports with dynamic drill down, expand collapse, on-click sort, Freeze headers & footers, hiding teh same page prompts etc., using HTML, Java Scripts, Conditional formatting, stored procedure etc.
• Used Business Insight and Business Insight advanced to create teh dashboard report widgets and other user interface functionalities.
• Developed and distributed complex Active reports using report studio for teh senior management.
• Created and managed agents using Event studio, which monitors teh data and performs teh task when an event occurs.
• Developing OLAP Analysis Studio views of analysis from dimensional modeled packages.
• Analyzed all reports and standardizes these reports using Power Prompts and Charts.
• Used Cognos Connection for scheduling and bursting reports across teh Business segments and provided additional security to published cubes as well as reports.
• Developed teh mapping specifications from teh business requirements and teh data model. Involved in data modeling and design of teh data warehouse.

Environment: Cognos 8.4, 8.3 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio, Business Insight and Event Studio), Cognos Transformer 8.4, Oracle10g, SQL Server 2008, Toad.