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
• 1+ years 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 extensive End User Training and Support
• 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 maintain technical documentation to 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 SAP Business Intelligence 4.1(Universe Designer and Webi)
• Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects
• Good knowledge on Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Filters, Ranking, Sections, Graphs and Breaks
• Worked on complex Business Objects Reports using Input Controls, Drill Filters and Hyperlinks

TECHNICAL SKILLS:

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

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 and Cognos
• 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 training sessions on Query studio, and Cognos Connection
• Good experience in creating canned and ad-hoc reports in Tableau Desktop
• 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 in Tableau Desktop
• Good knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, Transformations, filters, Sets, Groups, prompts, Parameters etc in Tableau

Environment: Cognos 10.1 BI, Cognos 10.1 Framework Manager, Report Studio, Query Studio, Analysis Studio, SQL Management Studio, Tableau 10.2

Confidential

Lead 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.
• Training users to use the Cognos connection to access their corresponding reports and cubes.
• Ability to work independently with minimal supervision and effectively meet project deliverables on time.
• Developed various relational models using Framework Manager for Cognos upgrade.
• 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.
• Expertise in Developing Ad hoc Reports using Query Studio and complex reports using Report Studio.
• 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 different business modules
• Resolved loops by either creating aliases or contexts or by defining shortcut Joins
• Created Universes using @functions for specifying the query script for objects
• 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, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio), Oracle 9i, Toad, Business Objects XI 3.1