SUMMARY:

• Around 9+ Years of experience in IT include extensive Functional and Technical experience in, Data Modeling, Business Intelligence (BI) product development and Reports Generation.
• Strong Experience in Data warehousing project life cycle such as Data modeling, Data extraction, Reporting and Dash boarding.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies, worked in ETL Tool Data Stage.
• Strong in SQL, PL/SQL, T - SQL, Stored Procedures, Database Triggers and SQL * Loader.
• Experience in gathering Business requirements, Analysis, Design, Development, Testing and Implementation of Cognos applications and End-user training.
• Proficient in Cognos 10/8 BI software Installations, Configuration and Administering the Cognos Connection for security.
• Client facing / consulting skills, such as the ability to work with the business partners to translate business requirements into potentially complex technical solutions that meet or exceed those business needs.
• Strong knowledge in TM1.
• Strong Knowledge in using Java, HTML, MS Visio 2003, MS Excel 2003.
• Proficient with accessing data in TOAD, Teradata SQL Assistant, MS SQL Server 2005 and implementing data solutions utilizing PL/SQL.
• Good knowledge in UNIX Shell scripting
• Excellent Verbal and Written Communication Skills have proven to be highly effective in interfacing across business and technical groups.
• Strong knowledge in Retail, Finance, Marketing and Human Resources.
• Proficient in RDBMS concepts, dimensional modeling, relational databases such as Oracle and MS SQL Server.
• Highly motivated, innovative, ability to adapt quickly to change, reliable & responsible.

WORK EXPERIENCE:

Sr. Cognos Developer

Confidential, Shelton, CT

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.
• Used Dimensional modeling and (DMR) Relational modeling techniques to develop FM models.
• Experience working with databases including oracle 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 8.4/10.2.2.
• 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.
• Good knowledge on the use of Cognos11.
• Configured Single Sign-on for Cognos 8.4/10.2.2/11.
• Created a work space from existing report content and extended report analysis with work space advanced.
• Created multiple Report Pages using sections, 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.
• Designed and developed OLAP cubes using Microsoft SQL Server Analysis services.
• 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.

Environment: Cognos 11, 10.2.2, 8.4 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace, Cognos Workspace Advance), Tableau, Transformer, Framework Manager, Oracle 12c, and SQL Server 2012, Informatica, TOAD.

Sr. Cognos Developer

Confidential, Montville, NJ

Responsibilities:

• Cognos 10 installation and configured IIS, content store (SQL server database), security (namespaces), WebServer setup. Followed best practices in configuring the server and setting up the environment.
• Involved in requirements gathering from business users, report design, report development, and support of all client/server layers and components of the data warehouse.
• Planned an approach for functional documenting, categorizing and packaging the requirements.
• Involved in Designing and creating various models and Publishing packages in Framework Manager.
• Design & development of the reports using Cognos Report studio, Analysis Studio, Query studio, and Event Studio.
• Developed advanced reports using Report Studio.
• Developed active reports using Cognos 10 version in various environments.
• Created Dashboards in Report Studio to display the data interactively to the end users as per the business requirement.
• Added Prompts, Cascading prompts, filters, Conditional style, Drill Through to the reports using report studio.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed Burst reports, Drill through reports, Master Detail reports, in Report Studio based on the business requirements
• Developed Complex dashboard reports for various reporting requirements and also created multi page reports by using Cascading prompts, conditional formatting and page rendering.
• Tested and validated the report output against the database to measure performance of reports.
• Created Scorecards and metrics by using metric studio.
• Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source.
• Identified various dimensions and measures required for the generation of a cube.
• Published the Cubes to Cognos 8 and using Analysis Studio to analyze the data and creating the reports in Analysis Studio and Report Studio based on the published cubes.
• Involved in the Installation of Cognos components in various environments and also involved in Go Office Installation.
• Customization of Cognos connection using SDK.
• Maintained Roles and Groups in Cognos 8.4 and scheduled reports to publish, and managed Cognos Connection.
• Developed cube models in Power Play transformer, creating cubes and publishing the cubes to Power Play web and Cognos 8.
• Developed various HR reports - MTD, QTD, YTD, last fiscal year, current fiscal year reports.
• Exposure on Cognos development Software development kit like SDK in order to customize reports.
• Involved in move the developed reports from Dev to UAT and UAT to production.

Environment: IBM Cognos 10/ 8.4 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Connection), Power Play Transformer 10, Informatica 8.1 power center, SSRS, oracle10g(SQL, PL/SQL), DB2 v8, HP-Unix.

Sr. Cognos Developer

Confidential, Peapack, NJ

Responsibilities:

• Worked on complete life cycle of Cognos 8 Administration and Cognos BI (Installations, Security, Configurations, Migration and deployment.
• Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions
• Worked on technical design specs for Framework manager, and reporting as per the requirements.
• Created Relational and dimensional models using Framework Manager. Provided Data level security in Framework Manager.
• Worked on multiple database, and multiple data source in Framework Manager to generate reports
• Created standard reports in Cognos Report Studio, and Analysis Studio.
• Responsible to build the Framework Manager Models and packages as per the business requirements.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio.
• Worked on various reports like, List, Crosstab, drill-thru, multi-query, master/detail, prompted, dashboards, port lets, and tabular reports.
• Designed complex reports with union queries, and SQL queries
• Improved long running reports performance thru writing SQL queries, resolving complex joins in framework manager, filters, and using stored procedures.
• Written java scripts for report prompts automation.
• Expertise to understanding, analyze, Cognos, data warehouse(OLAP), and OLTP data
• Designed transformer models, and PowerPlay cubes using PowerPlay transformer.
• Worked on PowerPlay studio to slice/dice Cognos cubes,
• Worked on performance tuning to maintain fast performance of the cubes and Transformer models.
• Recommended to do the complex database calculations in the database to improve report query performance.
• Provided customer training in Report Studio, and Query Studio

Environment: Cognos 10/8.4, Report Studio, Framework Manager, Query Studio, Event studio, Powerplay Studio, Analysis studio, Powerplay transformer8.4, Teradata12.0, and Oracle10g, Informatica, zLinux

Cognos Developer

Confidential, Malvern, PA

Responsibilities:

• In Production Support for Cognos Reports.
• Solving the issues and scheduling the reports.
• Gathering the requirements from users.
• Communicating with the users from different countries (Australia, Hong Kong.) for production issues.
• Changing the reports according to the requirements.
• Worked on filters, groups and prompts in 10.2.
• Scheduled reports using Event Studio.
• Wrote queries in SQL Developer for testing purpose.
• Developed reports using Tableau Desktop.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created rich dashboards using Tableau Dashboard.
• Built models containing query subjects, query items, name spaces and folders.
• Tested and fixed various bugs in the report, drill-through reports.
• Created complex reports using Report Studio, Analysis studio.
• Developed Standard Reports, List Reports, Cross-tab Reports, Drill through Reports and Master Detail Reports using Report Studio.
• Worked on JavaScript code in some of the reports.
• Deployed packages, folders and content store from a development environment to test and then to production environments.

Environment: Cognos 10.2, Report Studio, Event Studio, SQL, PL/SQL, Oracle 11g, SQL Developer.

Cognos Developer

Confidential, Basking Ridge, NJ

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the Cognos 8 Server.
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3.
• Upgrading of reports from series 7.1 to series 7.3
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments(development, testing and production)
• Deployed the reports from development to QA and QA to production using deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 port lets.
• Administer user access protocols and created user accounts and access privileges

Environment: Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler, XML and Windows NT/4.0

Cognos Developer

Confidential, Long Island, NY

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the Cognos 8 Server.
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3.
• Upgrading of reports from series 7.1 to series 7.3
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments(development, testing and production)
• Deployed the reports from development to QA and QA to production using deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 port lets.
• Administer user access protocols and created user accounts and access privileges

Environment: Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler, XML and Windows NT/4.0

Cognos Developer

Confidential, New York City, NY

Responsibilities:

• Worked on framework manager to import metadata from multiple data sources and to create subject matter Models, create and publish packages to ReportNet server.
• Involved in design and development of Joins, filters, calculations, prompts and conditional variables in Packages in Framework Manager.
• Involved in scheduling and Administering Cognos ReportNet reports using Schedule Management in Cognos Connection.
• Created Projects, Models (layers, relations, cardinality, Query subjects, star schema and packages) and Published Packages using Framework manager.
• Created Metadata Modeling by using multiple data sources in Cognos 8 BI Modeling.
• Created and maintained issue tracking and Change control documents.
• Used Report Studio to create standard reports and complex reports with drill through, master detail relationships, cascading prompt, complex layout, conditional formatting, and user interactions. Created Calculations, Prompts and conditions in Reports
• Peer Reviewed Design and Code of other Developers, prepared defects list and modified design docs and Code as per defects list
• Worked on summary reports and detail Reports.
• Developed standard historical reports in Report Studio for use of Call center Mangers.
• Worked on scheduling and publishing the report to the Cognos Connection.
• Secure Cognos Connection and setup ReportNet Security by assigning user to the groups and roles defined in Cognos Namespace.
• Worked on Security access to clients (using Access Manager and Report Net with LDAP also worked with Data Access, Object Access, and Package Access in Frame Work Manager).
• Created drill through reports with different parameters and associated with the summary reports to get the details.
• SQL Tuning to enhance the performance of the reports.
• Created Prompts, Calculations, Conditions& Filters and creating New Jobs using Impromptu Administrator.
• Administered ReportNet server with the primary objective of tuning server performance to optimize speedand efficiency.
• Created Models by using various data sources in PowerPlay Transformer.
• Created User Classes and Users in Access manager and provided the user credentials
• Created extremely big OLAP cubes.
• Used PowerPlay Enterprise Server to publish the cubes and Impromptu reports to the Upfront.
• Working closely with the ETL Team in the troubleshooting the data issues worked with Maintenance and Production support team in Scheduling activities
• Deploying the packages and reports to production environment.

Environment: Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio), ORACLE10g, TOAD 9.1, IIS, Windows 2003 Server. Power Play Transformer 7.4, SQL HTML, Cognos data manager, Informatics 8.5, Erwin 4.0