Lead Cognos Developer Resume
New, JerseY
EXPERIENCE SUMMARY:
- Business Intelligence Developer with 7 years of experience in Reporting and BI Solutions
- 4+ years of IT experience as Cognos developer specialized in OLTP/OLAP/Data Warehousing, BI tools and in analysis, design, testing, development and providing business intelligence solutions
- 3+ years of experience as SAP Business Objects Developer
- 6 months of experience in Tableau Desktop
- Extensive experience working with Cognos 11.x/10.x/8.x Business Intelligence Reporting Suite (Framework Manager, Analysis Studio, Report Studio, Event Studio, Query Studio, Cognos Access Manager)
- Hands on Experience with Framework Manager (Physical Layer, Business Layer, Presentation Layer) and Importing Meta Data from Different Sources, Dimension Hierarchy and setting up Determinants
- Created and published packages with Object and Data level security using Framework Manager and created complex Reports (List, Cross tab, Charts, Maps, Drill - through, Master-Detail and Cascading) and Dashboards building with Report Studio
- Created Active Reports which made offline analytics easy to get truly portable business intelligence
- Knowledge of data warehouse techniques and practices, including BI Reporting, Relational Modeling, Star schema & Snowflake schema
- Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Scheduling and Bursting of Reports and various kind of prompts (Value prompt, Date prompt, Textbox prompt)
- Good knowledge on troubleshooting and resolving complex Production and Performance issues
- Worked on complete Life Cycle Development process, which includes analyzing business needs, documenting business requirements, technical design documents, development, integrating, Implementing and Production Support using Cognos as a BI tool
- Experienced in using Java script and HTML to create prompts
- Provided extensiveEnd User andSupport
- Experienced in Migration of other reports into Cognos (BO to Cognos) and version up-gradation in Cognos
- Proficiency in working with Relational Databases like Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2
- 1+ years of experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using SQL Server Integration Services
- Ability to write and maintaintechnical documentationto describe Reports development, logic, coding, testing, changes, and corrections
- Strong interpersonal and communicative skills. Strong analytical-problem solving and trouble shooting skills. Ability to balance flexibility and task priorities to meet internal customer demands and meet project deadlines
- Experience in creating the Universe in the Information Design Tool (IDT) and Universe Design tool (UDT)
- Good knowledge on SAPBusinessIntelligence 4.1(Universe Designer and Webi)
- Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports usingBusinessObjects
- Good knowledge onBusinessObjectsreporting functionalities such as Master Detailed, Slice and Dice, Filters, Ranking, Sections, Graphs and Breaks
- Worked on complexBusinessObjectsReports using Input Controls, Drill Filters and Hyperlinks
SKILLS/TOOLS SUMMARY:
BI Tools: Cognos 11.x, Cognos10.x, Cognos Business Intelligence (8.1 to 8.4), Report Studio, Query Studio, Analysis Studio, Metrics Studio, Cognos workspace, Configuration Manager, Cognos workspace advanced, Cognos administration, Cognos Access Manager, Business Objects XI 3.1, Cognos Framework Manger & Business Objects Universe Designer and WebI, Tableau and MS Power BI
Querying Tools: Toad, SQL Management Studio
ETL Tools: SQL Server Integration Services
Languages: MSSQL, PL/SQL
RDBMS: Oracle 11g/10g/9i/8.x, MS Access/Excel, DB2, and SQL Server
Operating Systems: Windows 2003/2008/2012 R2
PROFESSIONAL EXPERIENCE:
Confidential, New Jersey
Lead Cognos Developer
Responsibilities:
- Analysing the existing Cognos environment, Reports, Packages and backend Databases
- Prepared design and test case documents for migration activities
- Worked on migrating the Reports across all the environments
- Testing Reports, Packages and other components in Cognos 11 environment
- Analysing on JavaScript issues which were not compatible with Cognos 11 after migration
- Working closely with IBM on migration issues
- Finding the root cause for migration issues and fixing them
- Moving the Reports and Security settings from Old environments to New environments
- Attending regular calls with Business Users and updating them on migration status
- Co-ordinating and communicating with Admin team on migration activities
- Giving production support after the migration went live into Production
Environment: Cognos10.1 BI,Cognos10.1 Framework Manager, Cognos 11.x, Report Studio, Query Studio
Confidential
Lead Cognos Developer & Tableau Developer
Responsibilities:
- Worked closely with Users in creating Functional Requirement Specifications for report development, creating Prototypes before starting actual development
- Designed the model based on the requirements for different subject areas and by analyzing the underlying data. Developed customized packages to be used by the query studio users, as per the business specifications
- Enhanced the existing models and reports for better representation, better formatting, performance and new requirements to end users
- Experience in developing active reports
- Developed List, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts, conditional formatting, filters, multi - page, multi-query reports to meet the business user requirements while increasing the accuracy and amount of data presented
- Experience in distributing reports using bursting, email, scheduling
- Performance tuning by analyzing and comparing the turnaround times between SQL andCognos
- Creating User Classes and restricted the user access with the help of User Class Privileges.
- Responsible for the delivery of solution-oriented complex reports using Report Studio.
- Created the documentation for all the developments along with the technical specifications
- Interacting with the End users on a regular basis for resolving issues pertaining to the reports
- Involved in the end user sessions on Query studio, andCognosConnection
- Good experience in creating canned and ad-hoc reports inTableauDesktop
- Worked on configuring reports from various Data sources using Data blending in Tableau
- Capability of doing data visualization, Reporting, Analysis, Pie Charts, Bar Charts, Cross Map, Scatter Plots, Geographic Map inTableauDesktop
- Good knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, Transformations, filters, Sets, Groups, prompts, Parameters etc inTableau
Environment: Cognos10.1 BI,Cognos10.1 Framework Manager, Report Studio, Query Studio, Analysis Studio, SQL Management Studio, Tableau 10.2
Confidential
Cognos Developer and Business Objects Developer
Responsibilities:
- Gathering Business Process Requirements from business users, for the reports to be developed.
- Developing technical specifications documents by analysing the business from the gathered BPR.
- Developed various relational models using Framework Manager forCognosupgrade.
- Tested the Metadata model and relationships in Framework Manager.
- Developed various reports, and they include, simple lists, cross tabs, charts, complex reports with tables in them, conditional block, static choices in prompt, bursting etc.
- Expertise in handling Administration tasks like bursting and scheduling the reports.
- Fine Tuning PL/SQL queries, views and stored procedures.
- Expertise in writing JavaScript for advanced sorting, hide and show Reports.
- Developed hide and show reports by using Conditional blocks and HTML Items.
- Designing and developing prompt pages and cascaded input prompts.
- Extensive interaction with Business community and Team members.
- Follow quality standards and best practices for the development tasks.
- Provided administration support and Development support for development and production issues.
- Created / Modified Universes, Reports from the underlying Databases for differentbusiness modules
- Resolved loops by either creating aliases or contexts or by defining shortcut Joins
- Created Universes using @functions for specifying the query script forobjects
- Imported/ Exported the Universes from/to repository to make them accessible to end-users.
- Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes and free-hand SQL
- Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc
Environment: Congos 8.4 (Framework Manager,CognosConnection, Report Studio, Query Studio, Analysis Studio, Metric Studio), Oracle 9i, Toad, Business Objects XI 3.1
Confidential
Business Objects Developer
Responsibilities:
- Gathering Business Process Requirements from business users, for the reports to be developed.
- Developing technical specifications documents by analysing the business from the gathered BPR. users to use theCognosconnection to access their corresponding reports and cubes.
- Ability to work independently with minimal supervision and effectively meet project deliverables on time.
- Developed various reports, and they include, simple lists, cross tabs, charts, complex reports with bursting etc.
- Expertise in handling Administration tasks like bursting and scheduling the reports.
- Fine Tuning PL/SQL queries, views and stored procedures.
- Designing and developing prompt pages and cascaded input prompts.
- Extensive interaction with Business community and Team members.
- Follow quality standards and best practices for the development tasks.
- Provided administration support and Development support for development and production issues.
- Created / Modified Universes, Reports from the underlying Databases for differentbusiness modules
- Resolved loops by either creating aliases or contexts or by defining shortcut Joins
- Created Universes using @functions for specifying the query script forobjects
- Imported/ Exported the Universes from/to repository to make them accessible to end-users.
- Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes and free-hand SQL
- Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc
Environment: Oracle 9i, Toad, Business Objects XI 3.1