SUMMARY

• Around Seven years of experience in IT Industry with strong background in analysis, design, development, Administration, testing, documentation and implementation of Applications in building data warehousing solutions using Cognos Analytics 11.x, Cognos 10.2.2/ 10.2.1/ 10.1/ 8.4/ 8.3/ 8. x Suite/7.0 (Report Studio, Active Reports, Query Studio, Analysis Studio, Business Insight, Framework Manager, Cognos Connection, Power play, Transformer).
• Data modelling experience using Cognos Analytics 11.x Framework Manager with concepts of Star Schema/Snowflake modelling, FACT & Dimensions tables and Logical & Physical data modelling.
• Worked on Medicaid, TANF, SNAP and other State programs.
• Created and updated Multi - Dimensional PowerPlay Models/Cubes Using Transformer.
• Administered Cognos Connection to implement Security among Cognos applications.
• Created Complex reports in Report Studio and created Ad-Hoc reports in Query Studio.
• Worked on complex Active reports in a multidimensional environment using Cubes.
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building.
• Sound working knowledge of building Complex reports, Burst Reports, Drill Through reports, Cascading Reports, Cross Tab Reports and Summary Reports.
• Interacted with Customers for requirement gathering, effective analysis and also to provide end-user .
• Expert level with developing OLAP models using Powerplay Transformer, DMR models in Framework Manager, Multidimensional reports using MDX Functions in Report Studio.
• Experience implementing, configuring, testing the Cognos Application, tuned for performance to increase the processing efficiency.
• Good Knowledge of various heterogeneous and legacy sources like Oracle, DB2, Flat files into staging area.
• Involved in creating and working with PL/SQL stored procedures.
• Expertise inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
• Extensive work on Data Extraction with Oracle, SQL Server, Db2 & MS-Access.
• Extensively worked on building prompts and prompt pages using Java Script.
• Excellent Team Player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem-solving skills.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos Analytics 11.x/10.2.x/ 10.1/8.4/8.3/8. x Suite/7.0, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Active Reports, Data Manager, Power Play Transformer, Business Insight, Cube Designer, Crystal Reports 2008/XI/ 10/9.0, BOXIR3/R2/6.0 /5.1, SSRS

Data Visualization: Tableau 10.x

Databases: Oracle 8i/9i/10g/11g,SQL,PL/SQL,MS SQL Server 2008/ 2005/ 2000 , Informix, DB2 UDB 7.x/8.x,MS Access 97/2003/2007/2010 , Teradata v2r6/v2r5/v2r4.

Operating systems: Windows 2003/ 2000/ XP/ NT 4.0, Unix, Linux.

Development Languages: Visual Basic 5.0/6.0,VB.Net,C#.

Web/Application Servers: Microsoft IIS, Tomcat, Apache.

Web & Scripting Technologies: HTML/DHTML, XML, Java Script, Perl and VB Script.

ETL: Informatica Power Center 10.x, IBM Data Stage 8.x, SSIS 2012

PROFESSIONAL EXPERIENCE

Confidential, Bismarck, ND

Cognos BI Developer

Responsibilities:

• Gathered and involved in obtaining the Business requirement documents along with business analysts and developed complex reports based on the requirements and going through multiple discussions with the team.
• Extensive experience using IBM Cognos Analytics (V11) Report studio, Active reports, Workspace and Workspace Advanced and Framework Manager to build Dashboard and Reports.
• Created Framework Manager Models including relationships, filters, aggregations, rollup processing, calculations, organized folders, merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer, and have setup data/object security and successfully published the packages.
• Migrated existing code to Cognos Analytics 11 and tested the reports in all the scenarios by installing life cycle manager to compare report output with old and new version.
• Created sample data module by using excel data and joining with existing packages to develop the report.
• Created new dashboard and stories using new UI in Cognos Analytics 11.
• Setup report bursting and scheduled it to run on the 1st of every month.
• Created interactive dashboard reports for the management to give multidimensional view of the business.
• Design and Developed using best practices for performance of complex report layouts/multi-page Summary List, Chart, Discontinuous Crosstab reports using features like Conditional blocks, cascading, Master - Detail, Drill Through, Variables Filters in Report Studio to meet business requirements.
• Used set operations like union and joins at query level in report Studio to display data as required by business.
• Developed FM modeling Layer with Star schema, Parameter Maps for enhanced performance, implemented macros to build the dynamic functionality to enforce dynamic behavior.
• Ensured clear query paths by resolving ambiguous relationships and loops. Have Strong knowledge on appropriate relationships between Query Subjects and defined Determinants when required.
• Worked and validated the reports on database objects like Queries, joins to test and review the data integrity between Cognos and Oracle database.
• Used JIRA tool during sprint and daily Standup to raise the change in the requirement of the projects assigned and to fix the bugs.

Environment: Cognos Suite 11.0.8 (Report Studio, Active reports, Query Studio, Analysis Studio, Cube Designer, Active Reports, Framework Manager), Oracle 11g, JIRA, Windows 7.

Confidential, Chicago, IL

Cognos BI Developer

Responsibilities:

• Gathered all the end user requirements and developed reports accordingly.
• Created dashboard reports for the management to give multidimensional view of the business.
• Developed very complex Active reports in a multidimensional environment using Transformer Cubes.
• Saved and distributed the active report (.mht) through emails.
• Created transformer models and built cubes based on the requirements and also created drill through reports for the cubes.
• Altered calculations in the Report studio for the Active report and Making enhancements of the reports based upon the requirements of the user.
• Created the calculations, filters and prompts in framework manager and user defined functions, procedures and packages at the database level as per the requirements.
• Designed standard reports in report studio and also developed ad-hoc reports in query studio
• Created functions and procedures at the database level to simplify complex business logic in reports.
• Scheduled the reports to run monthly based on the updates of the cube using schedule management tool in Cognos connection.
• Designed required Packages in Framework manager using database tables, views and stored procedures.
• Organized metadata into star schema groups to best suit the business model.
• Documented all the processes and created data dictionary.
• Generated stored procedures to use in the framework manager to create the required packages.
• Created burst reports to distribute reports to different end users.
• Modified the existing report based upon the change request by the user.

Environment: Cognos Insight (10.2), Cognos Analysis Studio (10.2), Cognos Report Studio (10.2), Cognos Transformer (10.2), Cognos Framework (10.2), Cognos Query Studio (10.2), Oracle 11g, SQL Developer, TOAD, Active Directory, IBM Info sphere Data stage, Unix AIX

Confidential, WA

Cognos BI Developer

Responsibilities:

• Analyzed the business requirements and developed models using Cognos framework manager & Adaptive warehouse and published packages for reports development.
• 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.
• Generated reports using Conditional Styles, Conditional Blocks, render Variables.
• Bursted and Scheduled the reports according to the user requirement.
• Migrate ETL code from Environment to Environment and validate the changes.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Developed very complex Active reports in a multidimensional environment using Transformer Cubes.
• Developed stored procedures and user defined functions using PL/SQL
• Involved with business users in query studio and report studio, suggested business users how their information can be effectively displayed by using different graphs and charts in Dashboards.
• Worked on all Production issues and incidents related to the reports/data, and also troubleshooting data related issues in the reports.
• Created Dimensionally Modeled relational data (DMR) in Framework Manager.
• Created Scheduled Jobs by scheduling multiple reports in a job.
• Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports & dashboards.
• Created associated data source/cube in Cognos 10.1.1 portal and configured connection to the Power Cube.

Environment: Cognos 10.2, 10.1.1 and Cognos 8.4 (Adaptive warehouse, Adaptive Analytics, Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced), Oracle, Datastage, Unix, windows 2008 server.

Confidential, Monterey Park, CA

Cognos Developer

Responsibilities:

• Extensively worked very closely with business partners to pay particular attention to detail and accuracy, and be able to recognize key requirements, analyze business scenarios, define and implement successful business strategies into Cognos BI.
• Implemented metadata modeling in Framework Manager and published multiple packages relational and DMR. Developed central modeling Layer (Framework Model) with Star and Snowflake schema groupings, Parameter Maps for enhanced performance.
• Developed Complex reports using Report Studio which includes various report types ranging from simple lists, crosstabs and chart through complex dashboards, drill-through, master-detail and conditional formatting.
• Created standard filters, calculation prompts, and conditional blocks in the reports to validate the integrity of the data based on end user needs.
• Created reports in report studio multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting.
• Used detail, summary and context filters to focus a report by excluding unwanted data. Used Grouping & Sorting features of Report Studio
• Created new power cube connections and secured migrated cubes by creating relevant roles and groups in Cognos 10.2 environment
• Extensively used parameters and a variety of prompts to help users in customizing the information in the reports to suit their own needs.
• Expertized in writing SQL queries and commands for retrieving the data from the specified tables according to the user requirement.
• Involved in testing and Validating the reports and models.
• Coordinate with Software Testers and Release Management to integrate the final work product into the production environment and provide off hours support as required.

Environment: Cognos 10.2, Cognos 7, Tableau Desktop 9.0, Informatica, Oracle, SQL Server, Db2, Windows 2008, AIX

Confidential

Cognos Developer

Responsibilities:

• Built the metadata models using Framework Manager to best suit the Business Requirements for Supplier Management, Brokerage and Transportation Modules.
• Created multi-dimensional cubes using Transformer for analysis.
• Implemented cube security by using dimension views and user class views/customs views.
• Created standard report template for each business module.
• Created most commonly used calculations and filters in framework manager and organized metadata into different namespaces, query subjects and folders in business view.
• Created ad-hoc reports in Query Studio and Standard Reports in Report Studio.
• Implemented complex report logic by writing SQL queries and creating stored procedures in the database.
• Implemented prompt validation and added various functionalities like multi-select auto submit prompts, check box and radio button prompts (for better display) etc., to prompt pages using JavaScript.
• Scheduled reports, maintained public and individual folders, created users, groups and roles in Cognos Connection.
• Created complex reports using tabular sets and master-detail queries.
• Provided data security, object security and package access in Framework Manager. And also secured the folders by setting up access permission in Cognos Connection.

Environment: Cognos 8.2/8.4(Framework Manager, Report Studio, Query, Schedule Manager, Access Manager),Datastage, Oracle 9i/10g, PL/SQL, Db2, Microsoft Excel, Unixand Windows Server 2003.

Confidential

Cognos Report Developer

Responsibilities:

• Responsible for maintaining the entire Cognos Application which involves administering, applying patches, setting up user access and various other activities.
• Implemented Auditing to track user activity and to check the load balance on the servers.
• Upgrading Cognos Content stores and Audit Databases from Oracle 9i to Oracle 10g.
• Worked with the UNIX team to set up printers which in turn would enable users to print reports directly from Cognos Connection.
• Installed and configured Cognos Report net 1.1 MR2 and Cognos 8.2 on multiple servers. Used MS Active Directory Server for authentication
• Worked on nearly 15 models and created packages with security embedded in them.
• Migrated 100+ reports from Impromptu to Report Studio (C8). Report types include Lists, Crosstabs and Repeaters.
• Built models and published packages in Framework Manager to the Cognos Server.
• Performed all the tasks of deployment, installation, configuration, development and administration.
• Authored complex reports using Tabular Models, Tabular SQL, Tabular, Tabular Set and Unions.
• Worked extensively with Cognos Customer Support while applying hot fixes and fixing other known issues with Cognos 8.2

Environment: Informatica, Cognos 8.2, Framework Manager, Impromptu 7.4, SQL Server, Oracle 9i and 10g, Windows.

Confidential

Cognos Report Developer

Responsibilities:

• Created packages using multiple data sources in Framework Manager to meet the business requirement s for finance team.
• Involved in migration of Impromptu catalogs to Report net.
• Scheduled reports, maintained public and individual folders, distribution lists, users, groups and roles using Cognos connection in Report net.
• Created Business mix reports, Trend over time reports, Forecast reports and Charts in Report net.
• Created complex reports using multiple tabular models and tabular sets in Report Studio.
• Carried out bursting of reports to distribute reports to different end users.
• Provided data security, object security and package access in Framework Manager.
• Created the packages defining the business rules and calculations with folders to store filters, calculations and prompts.
• Developed complex reports using Impromptu with drill through capabilities, summarization, grouping and filtering
• Published reports to the upfront portal using IWR to provide accessibility to the end-users.

Environment: Cognos EP Series 7.3 (Impromptu, Upfront, IWR, Transformer, Power play), Cognos Report net, Informatica, Db2, Oracle, Windows XP, Unix.