SUMMARY

• Around 7+ 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.
• Hands on experience with Subversion to process the Framework Manager Models to commit the changes.
• Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.
• 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 in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL 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

Cognos BI Developer

Responsibilities:

• Responsibilities include Requirement Analysis, Designing, and Creating Data Services layer in downstream dashboard systems and Reporting Tools.
• Participated in scrum meetings and coordinated with requirements analyst to understand the business needs and implemented the same into a functional design.
• Developed queries, reports, packages, cubes, and end users applications to meet business requirements.
• Worked on trigger based scheduling with the help of Control M to deliver the reports to end users.
• Works with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
• Implemented the report level security to restrict the accessing of all reports.
• Conduct job duties and responsibilities according to the organizations business systems, development methodology and/or its systems development life cycle (SDLC) Methodology.
• Design, Develop and implement software applications, create system procedures and ensure that the developed applications function normally.
• Implemented bursting the reports to send the automatic emails to users.
• Used appropriate tools and technologies to develop and to test the logic changes needed various application programs.
• Using VB script worked on automation tool to compare the values between the Relational and dimensional package reports.
• Troubleshoot and provides users support for data analytic issues by reviewing programmed code and data source for flaws in design or integrity.
• Implemented various drill through functionality to navigate high-level formation to detailed information.
• Enhanced or maintained existing applications and analysis of data problem and implementation of fixes for defects reported in various applications.
• Created Cognos FM Reporting models, Dashboards, Reports, TM1 Cubes based on Business Requirements.
• Maintain and modify Programs, make approved changes by amending flow charts, develop detailed programming logic and coding changes.
• Perform Execution of functional test plan, validate test results, and prepare documentation and data for analysis.

Environment: Cognos Analytics 11.0.8 (Report Studio, Active reports, Query Studio, Analysis Studio, Cube Designer, Framework Manager), Oracle 11g, MotioPI, SDK Package, Windows 7.

Confidential

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

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 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.