We provide IT Staff Augmentation Services!

Cognos Developer/ Bi Analyst Resume

Tampa, FL

SUMMARY

  • Experience in Business Intelligence, software design, development, testing and support.
  • Experienced working as Cognos Administrator/Modeler/Developer in Business Intelligence arena.
  • Having 3+ years of working experience in Business Intelligence using Cognos 8.4/10.1.1/10.2.1 BI Suite (Report Studio, Query Studio, Framework Manager, Cognos Workspace Advanced, Analysis Studio), ReportNet.
  • Worked as a Java Cognos 8.4/10.1.1 SDK Developer for the re - design of Cognos automated applications using Java API and related tools.
  • Created Adhoc reports using Query studio and Trained power users to use Query Studio for Adhoc reporting.
  • Working Experience in Data Mart Architecture, Data modeling and Dimension Modeling using Star Schema and Snowflake Schema.
  • Experienced in building Relational and Dimensional Models using Framework Manager in Cognos 8/10.
  • Hands on experience in administering, deploying, and maintaining Models, Reports, and cubes.
  • Implemented various security levels when developing Framework models.
  • Implemented Third Party Security with LDAP and use them in creating Data Level, Object Securities in Framework Manager Models.
  • Created complex statistical and financial reports, Executive Dashboards, Tabbed reports using Report Studio.
  • Knowledge on Migration of Cubes from Version 7.4 to 8.4/10.1.1 assisting Sr Developers.
  • Experienced in Performance tuning and optimizing of the reporting solution.
  • Utilized Best Practices and Proven Methodology in modeling data, ETL and other BI development process.
  • Experience in working with web servers like Apache, IIS etc.
  • Worked extensively on ETL process (Informatica, Abinitio) to help build Data Warehouse for reporting requirements.
  • Worked on Reporting Services such as SSRS. Scheduled reports for Daily, Weekly, Monthly on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Strong skills using SQL queries on Sybase, Teradata, DB2, Oracle, MySQL and SQL Server.
  • Experience in writing SQL, T-SQL, PL/SQL Packages, Stored procedures, Functions, Triggers and Cursors as per the business needs.
  • Good knowledge in data warehousing concepts (Star schema, Snow Flake Schema, Fact Analysis).
  • Effectively worked on Change Management, Problem Management, Configuration Management and Release Management Processes and developed reports to see the performance of those processes under Business perspective and Familiar with multi-tiered BI environment and Development.
  • Participated in design discussions and review sessions with client solution architect team.
  • Working with individuals from diverse backgrounds and various disciplines, ability to communicate ideas in a clear and concise manner, mastery of verbal and nonverbal communication, knowledge of technical writing, willingness to listen and compromise to reach goals, conflict resolution.
  • Knowledge in Micro strategy, Qlikview, Tableau.

TECHNICAL SKILLS

BI Tools: Cognos 10.2.1, 10.1.1,Cognos 8.4 (Framework Manager, PowerPlay Studio, Report Studio, Query Studio, Cognos Workspace Advanced, Transformer, Cognos Configuration, Cognos Connection, Analysis Studio, Metric Studio), MicroStrategy 9.2.1 (MicroStrategy Web, MicroStrategy Intelligence Server), SQL Server Reporting Services (SSRS), Scheduler, IWR, PPES, Upfront, ReportNet 1.1, Visualizer, Crystal Reports.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Databases: Oracle 10i/11g, SQL Server (2005/2008/2012 ), DB2, MS Access 97/00/XP/03, SYBASE, TERADATA

Web Servers: Microsoft Internet Information Server (IIS) 4.0/5.0/5.1/6.0 , Apache Tomcat Server 4.1/5.5.

LDAP Servers: Active Directory, Sun One Directory, Apache Directory.

Programming skills: Basic C & C++, HTML, SQL, PL/SQL, UNIX shell scripting

Microsoft Tools: MS Excel/Word/PowerPoint/Access, Visio, Outlook.

Operating Systems: Windows NT/2000/XP/2003, UNIX (AIX, Solaris), Linux

Others: Informatica ETL Tool, TOAD, ERwin, Palisade Decision Support tools, AutoCAD, PRO-E.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Cognos Developer/ BI Analyst

Responsibilities:

  • Worked extensively with ETL team to analyze and build data warehouse for reporting requirement.
  • Leading a small team of 4 members and handling the project and reporting the manager.
  • Defines scope, plans, and deliverables for assigned projects.
  • Created project documentation for the complete project life cycle.
  • Created Relational and Dimensional Models in Framework Manager and cubes in Transformer using various data sources.
  • Extensively used Parameter Maps to connect to different Databases as Sybase doesn’t support multiple data source connections.
  • Implemented Data level security using session parameters and Parameter maps, and as implemented Package level security.
  • Implemented Data Entitlements at report level and at package level
  • Developed Financial Reports such as FFIEC Dashboards, CCAR Submission Reports, BAL Throughput Metrics and Flash Quarter End submission reports using Report Studio.
  • Hands on Experience with Content Migration such as Reports from one environment to other.
  • Creation of Dash Board Reports using Report studio MDX Functions and adding it to the portal page using HTML Items.
  • Very Good Knowledge on GAAP.
  • Worked extensively on Crystal reports.
  • Recommended very good alternate solutions to the team.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
  • Created reports using SQL Server 2005 & 2012 (SSRS), Microstrategy 9.4/8 and integrated into the web front end.
  • Performed quantitative analysis when required.
  • Created Dashboard reports using Cognos Insight in comparison with Qlikview.
  • Worked on Performance Tuning and load balancing of complex reports.
  • Developed Reports in query studio to meet the adhoc reporting requirements and later trained the users on how to develop their own reports
  • Using java scripts built tabbed reports, dynamic sorting based column header, hiding and showing objects.
  • Generated IQD files in Framework manager and designed Power play models in Transformer.
  • Created appropriate dimensions, manual levels and cube groups in the Transformer model.
  • Built Power Play Reports based on the cubes and published to Report Net Server
  • Published reports and cubes on Cognos Connection and gave required security privileges to end users as required.
  • Designed, developed and maintain Cognos Reporting solutions and PowerPlay (OLAP cube reporting) both for client and web versions of software.
  • Hands on training to generate reports in Cognos Workspace Advanced, Query Studio and Analysis Studio.
  • Coordinated with functional users for User Acceptance Testing (UAT) prior to releasing system changes in production
  • Implemented SDK based solution to run the reports from the Java based front end User interface.
  • Built a SDK solution to get the Database Query subjects and its lineage properties directly from the Cognos project file which reduces the manual effort of the developers.
  • A SDK solution to run a set of reports from the frontend interface where the parameters are predefined in DB which reduces the User work.
  • Involved in building MicroStrategy, Qlikview Reports.
  • Created Event studio reports based on the Basel run cycle, and sent emails to the user group on the data refresh.

Environment: Cognos 8.4/10.1.1/10.2.1 (Framework Manager, Report Studio, Query Studio, PowerPlay Transformer, Analysis Studio, IBM Cognos Workspace Advanced), ER Studio, SSAS, SSRS, SSIS, ERWIN, MicroStrategy Desktop 9.4.1, Access Manager, API, Oracle 10g, Sybase, Teradata, Excel, Access, Abinitio, UNIX, Erwin, Toad.

Confidential

Cognos/ETL Developer

Responsibilities:

  • Communicated with the business users to comprehend the requirements.
  • Designed Metadata Model using Framework Manager and published package in to the Cognos connection.
  • Learned to Perform Installation of Cognos 10.
  • Created standard filters, calculations, and conditions in Models.
  • Developed Complex Reports having many calculations, unions, Conditional blocks, variables etc., using Report Studio.
  • Created complex Cross tab, Parent-Child reports to evaluate the business performance tasks.
  • Developed reports in both PDF and Excel versions.
  • Developed Complex Reports using Report Studio including conditional blocks, conditional formatting.
  • Involved in web portal integration of the reports.
  • Created all kinds of Reports like List, Grouped List, Cross-tab, Nested Cross-tab, Mailing Labels etc.
  • Created Time Based Reports like daily, weekly, monthly and quarterly using Cognos Power Play, Cognos Impromptu.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
  • Created and modified procedures, triggers and functions.
  • Created reports using SQL Server 2008(SSRS), Cognos 10.1.1 and integrated into the web front end.
  • Created standard Impromptu reports to use them as IQDs for Transformer models.
  • Generated presentation reports such as animated, Dimensional reports etc.
  • Used Cognos Scheduler to update a report for specific or recurring times and dates.
  • Created multi page report based on multiple queries using Prompts and Parameters.
  • Involved in writing DDL scripts (SQL objects like tables, views, rules, defaults and user-defined data types) and creating DML scripts (Stored procedures & Triggers).
  • Scheduled and distributed reports using Schedule Management in Cognos Connection
  • Developed parameter driven reports.
  • Tested and improved Report Performance.
  • Created Bursting of reports using Report Studio, Cognos Connection Tested and improved Report Performance.
  • Extensively used Cognos 8 to develop the model and reports.
  • Implemented security at package level and database level.

Environment: Cognos 8.x & 10.x, Cognos Report Net 8.1 MR2 (Framework Manager, Report Studio, Query Studio, Analysis Studio), SQL, SSRS, SSIS, Windows XP, PL/SQL, WinSQL.

Confidential, San Jose, CA

Business Intelligence Consultant (Cognos)

Responsibilities:

  • Interacting with Business Users for gathering Business Requirements to develop the reports.
  • Understanding existing business model and requirements.
  • Creating and Publishing packages to Cognos 8 Environment.
  • Created reports with customized data with calculations, filters and summaries.
  • Created Value Prompts and Text Prompts to filter the Data in Report Studio.
  • Developed list, crosstab, chart reports involving multiple prompts, filters, multi-query reports using Report Studio.
  • Developed reports with Master-detail and Drill-through functionality to link one report to another.
  • Developed reports with various prompts including Cascading Prompts to dynamically select the values by the user.
  • Design, development, testing, and documentation of new Cognos reports and cubes
  • Deployed Cubes and Reports on PowerPlay Enterprise Server and also Published to Upfront which are developed by Sr. Developers.
  • Provided support to projects for new applications / report needs.
  • Maintenance and support of existing Cognos reports and cubes.

Environment: Cognos 8.2 ( Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos 7.3(Impromptu, Cognos IWR, PowerPlay Transformer, PowerPlay Enterprise Server, Upfront), Oracle10g/11g and SQL Server 2008 .

Hire Now