SUMMARY:

• Cognos certified developer with IT experience in development and implementation of Business Intelligence concepts using Cognos 8.x. and 10x.
• In - depth experience working with Cognos tools: Cognos Series 8.3 - 10.2 BI, Cognos (Report Studio, Query Studio, Event Studio, Analysis Studio, Framework Manager, Cognos Connection)
• Knowledge of Data Modeling concepts; good understanding of Relational Database concepts and multi-dimensional data.
• Good understanding of cardinalities and their impacts on relationships between the query items; worked with multiple-fact queries, using Joins, Unions etc.
• Strong experience in creating and publishing packages in Framework Manager.
• Strong complex reporting skills - building Dashboards consisting of complex Drill-Through, multiple report types such as nested crosstabs and charts, as well as different kinds of prompts and filters.
• Strong Experience using SQL in running queries, development of reports, analyzing data etc.
• Productions support experience includes providing subject matter expertise during different phases of the SDLC, from requirement gathering to development, testing to migration into Production; and further post production end user support, along with facilitating enhancements discussions.
• Experience in gathering of end-user business requirements and responsible to provide specific direction, training and mentoring to customers.
• Self-motivated, team player, good interpersonal and communication skills.

TECHNICAL SKILLS:

IBM Cognos 8.3: 4, 10.1,2 Report Studio, Active Reports, Query Studio, Event Studio, Analysis Studio, Workspace/Advance, Cognos Connection ThoughtSpot, Alteryx

Languages: SQL, HTML

Databases / Tools: Oracle 10g+, SQL Server 2008+, Toad, SQL Server Enterprise Manager

Methodologies: Star Schema, Snowflake Schema

Software: Microsoft Standard Suite (i.e. Word, Excel, etc.), along with MS Project, InfoPath, SharePoint, Master Data Services, JIRA, GitHub, Collibra (data governance)

PROFESSIONAL EXPERIENCE:

Confidential, Yonkers, NY

Business Intelligence Analyst

Roles & Responsibilities

• Defining process and control for communication between Business Intelligence team and the end users, primarily with regards to report requests and their implementation
• Developed dashboard using Cognos Workspace to facilitate monthly overview of business function for management
• Created complex reports using both meta data from FM packages as well free-hand SQL
• Developed multi-query, multi-page reports using joins and unions
• Scheduled and distributed reports using Event Studio and bursting functionalities to internal and external stakeholders
• Used Toad for Oracle and SQL Server Studio Management for data analysis and writing SQL queries
• Utilized Collibra software for data governance, end-user report inventory documentation
• Utilized JIRA for report request, issue management, capturing effort estimate and other administrative tasks
• Utilized GitHub for Oracle view version control
• Trained end-users and created solution in ThoughtSpot, including answers, pinboards etc.
• Actively participated in Cognos upgrade between releases of the Cognos 10; this included creating test plan, identifying components and executing unit testing
• Maintained user access, roles and groups for Cognos and ThoughtSpot
• Utilized Alteryx for Data Wrangling and adhoc solutions.
• Utilized Master Data Services to collect and maintain business unit - specific data, that would essentially be ETL into database tables

Confidential, New York, NY

Senior Cognos Developer

Roles & Responsibilities

• Involved in all phases of SDLC from requirement gathering to development, testing and production support
• Used Oracle SQL Developer and SQL Server Enterprise Manager for data analysis and validation.
• Developed a comprehensive data model using Cognos Framework Manager, consisting of meta data from multiple database schemas, primarily using Oracle at the backend
• Implemented conditional formatting to accomplish the objective of the project, which was to provide rag rating (red, amber, green) for a given supplier
• Utilized extensive amounts of conditional block and render variables to conditionally hide/show rows and objects within tables and data containers
• Utilizes bookmarks to easily navigate through multi sectioned report for long running HTML page
• Lead a team of 4 resources of multi-platform skill sets in a collaborative effort to produce hybrid solutions to meet business requirements
• Utilized Microsoft InfoPath to build multi-view/page forms with complex logics, rules and actions
• Implemented multi conditioned validation rules to control the required fields
• Used formatting rules to conditionally render sections and fields, action rules to trigger subfields and queries and updated SharePoint lists;
• SharePoint Designer to modify workflows of the forms, trigger email to different user groups
• Worked closely with project management team in preparing Project Plan for the life cycle of the solution
• Utilized Microsoft Project to prepare detail project plan consisting of different aspects of the SDLC process (e.g. requirements gathering, development, migration, testing etc.)
• Provided production support and enhancements post Go-Live of the dashboard

Confidential, New York, NY

Cognos Consultant

Roles & Responsibilities:

• Working closely with the business partners and other stakeholders, in requirement gatherings and setting expectations
• Regularly updated the project manager along with rest of the team the status of the development; working through JAD sessions.
• Modeling data using Cognos Framework Manager to meet the need of the report to be developed
• Working closely with the data base team to ensure the model that is created works well with the reporting tool
• Developing advanced reports, consisting of multiple types of charts, prompts and complex logics
• Applying complex filters and logics to conditionally retrieve data per prompt selection
• Applying conditional formatting and conditionally rendered report objects to help users focus on certain data for better analysis;
• Integrating reports into multi-page dashboard using Portal Page mechanism
• Preparing High/Low level design documentation, outlining model and report development, for business users and technical personnel;
• Using software such as Subversion for proper sharing and categorization

Confidential, Independence, MO

Cognos Developer

Roles & Responsibilities:

• Worked closely with the entire BI team, from collaborating with ETL/DBAs at the back-end, to testers and end-users in the front, at systematic agile development environment
• Worked with business and system analysts in gathering/modifying report specifications as per business requirements
• Authored complex reports based on multi-dimensional data sources, more specifically cubes based on Cognos Transformer
• Developed multiple nested crosstab reports and nested combination charts; utilized both legacy charts as well as Cognos 10.1 charts; applied condition palette to format the graph for ease of analysis
• Created prompt pages with multiple prompts, including cascading prompt
• Developed master-detail relationships between multiple queries and different components to work in synch to generate the expected result
• Worked closely with QA team for UAT testing before moving the reports to production

Confidential, Norwood, MA

Cognos Developer

Roles & Responsibilities:

• Analyzed Cognos Impromptu reports to construct a blueprint structure of how the new Cognos 8.4 reports will look like
• Worked with the company’s on-site and off-shore team to undertake proper upgrade of the Impromptu Catalogues into Framework Manager.
• Investigated join related issues and re-structured some of the already-built model in Framework Manager for proper data retrieval
• Manipulated cardinalities of different Query Subjects for proper relationships between them
• Developed a multi layered Metadata Model for the Trustee Management System using Cognos 8.4 Framework Manager
• Published customized packages for various clients each with their unique requirements.
• Developed Standard Templates for all the reports to be easily integrated as new clients will be added to the TMS project.
• Applied complex groupings and formatting to match the older Impromptu Reports
• Generated HTML, PDF and Microsoft Excel output of the report for specific users.
• Involved in troubleshooting, validating and refining reports as they were tested and moved on to production
• Modified preference settings in Cognos Connection, especially with regards to security permissions of specific Cognos components
• Held JAD sessions with the team lead and project manager to discuss various options and methods to establish an efficient and successful discourse.
• Held regular knowledge transfer/mentoring sessions with both off-shore and on-site team to help them through the Cognos 8.4 reporting mechanisms, interface and functionalities.
• Created thorough Documentations of technical design and development for developers and other Cognos personnel of the company