SUMMARY

• Over 5+ years of experience in IT industry with strong background in analysis, design, testing, development, documentation and implementation of Business Intelligence Applications in Data Warehouse environment with Cognos BI tool.
• Well - versed in developing reporting applications using Cognos Business Intelligence components like Cognos 10 BI Suite (Framework Manager, Report Studio, Cognos Connection, Metric Studio, Query Studio, and Event Studio), Cognos Report Net 1.1, Cognos Impromptu, Power Play Transformer, Impromptu Web Reports(IWR), Access Manager, and Cognos series 8 suite of tools.
• Installing and Configuring Cognos BI products such as IBM Cognos gateway, Cognos BI application server, Cognos content manager.
• Extensive experience in Metadata Modeling both Relational and Dimensional (DMR) using star and snow Flake models.
• Develop and maintain relational Cognos Packages using Framework Manager
• Involved in several migrations of Cognos versions: 10.2.1.11.0.9
• Hands on experience in upgrading reports from Cognos 10.2.1to Cognos 11.0.9
• Complex Report building experience in Report studio by using filters, customized prompts, conditional formatting, drill-through, Cross tab, bursting, Mater/details queries.
• Expertise in designing interactive dashboards, having user friendly capabilities such as dashboard prompts, navigation, drill-down, etc.
• Worked on Cognos Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos server.
• Developed various kinds of prompts and filters to increase retrieval speed without compromising on the scope of the reports.
• Created Dashboards in Report Studio involving a mixture of data coming from both the database and Power Play cubes.
• Experience in setting up Security prototype for Cognos Business Intelligence environment by incorporating data level, object level and package level and report level security.
• Good knowledge in Database development and proficient in writing database stored procedures, cursors and complex queries in MS SQL Server and Oracle SQL Developer.
• Involved in building the complex cubes and optimizing the cube creation.
• Have a clear understanding of Data Warehouse architecture and building Dimensional Models.
• Extensively used Oracle and MS SQL Server for Debugging, troubleshooting and testing the data level errors and cross- checking values by using SQL queries.
• Experience in creating ODBC, XML, Native Metadata Data source connections.
• Experienced in implementing large-scale applications with leading technologies in Business Intelligence and involved in complete software development life cycle (SDLC).
• Involved in OLTP/ OLAP system study, analysis, E-R modeling and developing database schemas including Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Performed Unit testing (White box testing) for the developed codes and provided signoff from the Dev box before moving to QA environment.
• Involved in deploying the code from Dev to QA, QA to UAT and from UAT to Prod.
• Quantitative Finance background with strong mathematical aptitude and deep research skills.
• Experience in interacting with end users, SMEs and BAs to gather requirements for reporting.
• Provided Production Support to the End Users on CLARITY PPM Application.
• High Initiative, self - motivated with and excellent communication, analytical and presentation skills, willingness and ability to quickly adapt to new environment and learn new technologies.
• Strong Analytical, Administration and Problem-solving skills dedicated to maintain the High-Quality Standards in work Delivery ability to work independently and able to work in Collaborative Team Environment.

TECHNICAL SKILLS

BI Tools: IBM Cognos 11.0.9/10.2.2/10.2.1 , Cognos 8.x: Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Event Studio, Power Play Transformer, Cognos Workspace Advanced, Cognos Workspace, Business Insight Advanced, Business Insight and Framework Manager., Report Net: Cognos Connection, Framework Manager, Query Studio, Report Studio, SDK, Cognos Query, Upfront, Crystal reports, and Jasper reports., Cognos Series 7: Upfront, PowerPlay Transformer, Impromptu Web Reports, Access Manager, Power Play Enterprise Server, Impromptu Administrator, Cognos TM 1 9.4/10.1/10.2.2 , Tableau 9.x

PPM Tool: CA Clarity PPM tool

Ticketing Tool: SERVICENOW

SDLC Methodologies: Waterfall, Iterative, Agile/Scrum

Databases: MS SQL Server 2008/2012, Oracle 8i/9i/10g, DB2, MS Access, Sybase ASE/IQ

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

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

ETL Tools: DataStage, Informatica Power Center, 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/10, Server 2003/2008/2012 UNIX, Ubuntu

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. Cognos Developer/Admin/Production Support

Responsibilities:

• Gathered and analyzed business requirements from the users and transformed them into business intelligence reporting specifications.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Involved in migrations of Cognos versions 10.2.1/11 and Configured Single Sign-on for Cognos 10.2.1/11.
• Hands on experience in Cognos Analytics 11.0.9 reports and dashboard.
• Hands on experience in Cognos Analytics Mapping enhancements.
• Used geographic dimension to visualizing critical business information in reports and dashboards.
• Used Dimensional modeling and (DMR) Relational modeling techniques to develop FM models.
• Experience working with databases including oracle SQL Developer and MS SQL server.
• Developed Complex reporting applications typically employed multiple query joins, cascading prompts, cube or relational drill-through, Master-Detail relationships, bookmarks and page sets.
• Developed reports producing multi-tabbed Excel outputs and PDFs with table of contents and bookmark links.
• Developed dashboards and reports by gathering requirements, used event studio to send out alert mails, Analysis studio for trends, comparisons and metric studio for score carding.
• Created HTML and Java Scripts to default the values in the prompts and to default the search options for the prompts in prompt page.
• Implemented Folder Level Security in Cognos 10.2.1.
• Extensively used filters, calculations, conditional variables, multiple queries for data extraction in reports.
• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.
• Created a work space from existing report content and extended report analysis with work space advanced.
• Created multiple Report Pages usingsections, Page Breaks and grouping/sorting.
• Used Union, Intersection, Except, and Join between queries in query explorer.
• Created active reports and used Work space advanced to create reports.
• Deployed packages, folders and content store from a development environment to test and production environments.
• Deployed reports, models and cubes from Development to Test and Production environments.
• Extensively used SQL loader and PL/SQL for extracting source data, transforming and loading into Data Marts, Banner ODS and Operational Data stores.
• Hands on Experince in ETL Data stage designer and director for trouble shooting data issues and monitoring sequence jobs and parallel jobs.
• Performed Unit testing and data validation of various reports that were developed in Cognos.
• Developed and Published packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relational ship between query subjects.
• Carried out performance tuning of reports, both on data base side and Cognos report and modeling side.
• Used SQL in TOAD for oracle to test and validate data in reports.
• Implemented Self- service oriented Reporting and Dashboards.
• Cognos Administration activities including Server configuration, Security, Upgrade, Patch Installations, implementation of change requests.
• Wrote simple to complex SQL queries in the process of unit testing of the reports.
• Involved in Scheduling and distributing the reports using Cognos administration.
• Created the export and import packages in content administration.
• Provided technical and functional expertise to the production support team for bug fixes and end user queries. Involved in fixing run time issues
• Provided Level 2 support to business users and executives and installed Clarity PPM Software in the users machines.
• Involved in resolving incidents faced by users in the CA Clarity PPM environment. Customers.
• Worked on incidents varying from project management, resource management, studio and admin.
• Completed the creation of users/groups, giving required access rights and maintaining them, and creating.
• Maintained logs (Incidents, Requests, Problems and CHG) of all issues in SERVICENOW.

Environment: Cognos 11.0.9,10.2.1,8.4 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace, Cognos Workspace Advance), Cognos admin, CA Clarity PPM Tool, SERVICENOW, Transformer, Framework Manager, Oracle 12c and SQL Server 2012, DataStage, TOAD.

Confidential, Atlanta, GA

Sr. Cognos Developer

Responsibilities:

• Participated in new development requests, enhancements and project initiatives aimed at providing operational reporting and analytic solutions per business requirements.
• Analyzed the business, designed and developed the Framework Manager models to meet the reporting requirements.
• Installed and configured the Cognos 8.4 /10.2.2 BI applications with its complete suite of tools.
• Created and maintained client-secured OLAP and financial reporting applications using IBM Cognos 10 Report, Analysis and Event Studios in SQL Server based environment.
• Installed and configured Framework Manager Client tool to build metadata models for the reports.
• Provided overall administration, configuration, security, and maintenance for the Cognos environment.
• Performed the migration of the reports from Cognos 8.4.1 to 10.1 and then to 10.2.1 environment and performed the complete testing end to end to make sure the complete content is working as expected.
• 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 the environment in case the BI server goes down, if not contacted the DBA in case of the down time of the content store database.
• Developed multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages.
• Developed new reports in Report Studio upon requests from business users.
• Implemented data level security, object level security and package level security using the 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.
• Created Cognos 10.2 Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, and have successfully published the packages.
• 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.
• Experience administering and thorough understanding of the Cognos platform and the components
• Deployed packages, folders and reports from a development environment to Testing and Production environment.
• Expertise in supporting Cognos web servers, Dispatchers, Content Managers & Implement Security on Cognos Roles and Groups.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Created Burst Reports and Multilingual Reports based on groups of users & Preferences for our various partners.
• Extensively worked on Dashboards using report studio including render variables, singletons, prompts, filters, Conditional variables, layout component reference and formatting the objects within report design.
• Defined hierarchies related to business requirements for Drill ability.
• Worked on the OLAP scripts for automating the cubes refresh process.
• Involved in writing Queries in SQL server. Trained end users effectively to use reporting tool, to build and customize their Ad-hoc reports.

Environment: Cognos 10.2, 10.1, 8.4, Transformer 8.4, Report Studio, Query Studio, Event Studio, Analysis studio, Framework Manager, Cognos Cube Designer, Netezza, Oracle 11g, UNIX, LINUX, DB2, SQL Server 2008/2012, TOAD.

Confidential

Cognos Developer

Responsibilities:

• Actively interacted with business analysts and developed reports based on the requirement; Created List Reports, Crosstab Reports, Master detail, Drill Down/Drill Up and Drill through Reports, Active Reports using Report Studio.
• Used Framework Manager to build models, packages, Query Subjects, Query items, Relationships, Calculations, Filters, Functions, Folders, data Sources and publish packages to the Report Net Server.
• Installed Multi-Server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments.
• Install/setup Cognos 10.1 software, Upgraded the 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.
• Extensively worked on IBM Cognos 8 Framework Manager, creating model and implementing best practices while resolving the loops and query items, namespaces, DMR (Dimensional modeling with relational data) and packages.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created Dashboards comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions and conditional formatting.
• Designing the metadata model using Cognos FM (with DMR functionality) and development of Cognos Report Studio Reports with drill up/down and drill-through functionality.
• Used Business Insight and Business Insight advanced to create the dashboard report widgets and other user interface functionalities.
• Created and managed agents using Event studio, which monitors the data and performs the task when an event occurs.
• Debugged and suggested solutions for problems in existing report designs.
• Used Cognos Transformer to build OLAP multidimensional cubes and used it in Dashboards.
• Developing OLAP Analysis Studio views of analysis from dimensional modeled packages.
• Used Cognos Connection for scheduling and bursting reports across the Business segments and provided additional security to published cubes as well as reports.
• Developed the mapping specifications from the business requirements and the data model. Involved in data modeling and design of the data warehouse.

Environment: Cognos 10.2, 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.