SUMMARY

• Over 8+ years of professional experience on Cognos Business Intelligence as a CognosAdministrator, Developer, and Developer - Analyst with key activities in all the stages of the project SDLC such as support, analysis, designing, testing, debugging and documenting Cognos BI/TM1 solutions across multiple industries.
• Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), &OLAP Cubes) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension) using Data Modeling tools such as Cognos Transformer, Cube Designer and Framework Manager.
• Installed, configured and worked on Cognos BI suite, including Business Insight & Advanced, Report Studio, Analysis Studio, Workspace Advanced, Cube Designer and Framework Manager.
• Experience in understanding existing business processes, gathering business systems requirements analysis and design thereby converting into detailed reports for strategic decision making.
• Extensive experience working with Cognos 8.x/10.x Business Intelligence Reporting Suite (Framework Manager, Analysis Studio, Report Studio, Event Studio, Query Studio and Transformer, Dynamic Cubes, Workspace, Workspace Advanced, PowerPlay Studio, Cognos mobile) Applications.
• Designed and implemented enterprise wide Reporting strategies utilizing Business Intelligence (BI), Data warehouse, Data Analysis, Data Modeling, Data Mining techniques.
• Implemented the Enterprise level Cognos security and Server Administration using Cognos 10.x/8.x and administration of security using Access Manager, LDAP and Custom Authentication Provider.
• Developed simple and complex reports including list, crosstabs and charts with drill-thru capabilities,Master Detail relationship, Bookmarks, Prompts, Macros, and Dashboards etc.
• Experience in Database coding using ETL tools, data mining techniques, installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008, MY SQL and Oracle 10 series databases
• Extensive experience using various data sources such as Oracle, DB2, SQL Server and Access.
• Excellent knowledge on SDLC/Data Warehousing implementations using Star schema and Snow flake schema and developing reporting solutions from OLTP.
• Experienced in Migration of other reports into Cognos and version up-gradation in Cognos.
• Has worked on several requests from business towards building Report Studio reports, Query Optimization and Performance Tuning of reports.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules.
• Solid designing and development experience in developing various kind of reports like Cascading parameters, pick lists, Drill down, Drill through, Sub Reports and Charts.
• Responsible for Interacting with users and department directors to identify information needs and business requirements.
• Experience with the Enterprise level Cognos administration and Framework Development support, which includes the installation, configuration, administration and maintenance of a business-critical Cognos product set in a 24x7 production environment.
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas methodologies, dimensional data structures and complex hierarchies.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Proficient in maintaining Data Level, Object Level and Package Level Security.
• Extensive experience in writing SQL queries and Involved in Query Level Performance tuning.
• Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.
• Excellent team player with problem-solving and trouble-shooting capabilities and ability to adjust to people, circumstances, with a Drive for results through self-motivation.

TECHNICAL SKILLS

Tools: Cognos 10.2.X, Cognos10.1.1, Cognos Mobile 10.1.1, Cognos Express, 8 Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Framework Manager), ReportNet 1.1 MR3/1.1 (Framework Manager, Report Studio, Query Studio), Cognos Impromptu 7.x/6.x, Impromptu Web Reports (IWR), PowerPlay Transformer 7.x/6.0, PowerPlay Enterprise Server, Modeling Tools Transformer & Framework Manger 1.1/8.x, Cognos10.

ETL Tools: Informatica

Mobile Interface tools: Cognos Active Reports

Data Visualization: Tableau, Qlik View

Languages: SQL, PLSQL, HTML, XML, Java script.

O/S: Windows 2000/2003/2008/2012 server.

RDBMS: TOAD, Oracle 11g/10g/9i/8.x, MS Access/Excel, DB2, MY SQL and SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Sr. Cognos BI Admin/Developer

Responsibilities:

• Worked with Business Users to get the user requirement for creating multi-dimensional cubes and canned reports.
• Install and configure Development, Test, Stage, Training and Production environments with IBM Cognos 10.2 BI /CognosTM1 10.1
• Design and Implement Integration of Cognos BI and TM1 Portals
• Understood business logic underlying the requirements, based on the report mockups.
• Implemented report prototypes layouts before the actual report implementation.
• Conducted constant review meetings with Business End Users to ensure the reports are meeting the requirements et.
• Worked extensively with the ETL Team for creating the MV’s and creating Views for the report requirements.
• Did performance tuning on Dynamic cubes to reduce query time by capturing the Queries from the XQE-Logs
• By usingMDX Functions developedDash Board reportsinReport Studio.
• Involved in design phase, gathered requirements from users and documented/designed/developed report specifications including report documentation for creating reports using Report Studio.
• Developed Complex reports using Report Studio which includes various report types ranging from simple lists, crosstabs and chart through complex dashboards, drill-through, master-detail and conditional formatting.
• Involved in the Unit Testing of the reports and preparing the Test cases.
• Raised tickets and interact with different teams for migration of code (Teradata views, packages and reports) to different environments
• Created multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting.
• Designed Dynamic Cubes - in memory tool using Cube Designer tool and deployed in the Cognos 10 environment to increase the performance which is using large data sets.
• Created POC for Active Reports (using data tabs, data decks etc.) and Dynamic Cubes in Cognos 10.2.2
• Updated Active Reports using Scheduled jobs and used these for the Mobile reporting both for IOS and Android Tablets and Phones.
• Defined a separate portal tab for hosting the Active reports, Dashboards and WSA Reports that are useful for Mobile users both offline and online.
• Analyzed existing solution containing cubes reports, materialized views and worked with the functional team to create technical documents.
• Installed, configured and administered various Cognos components such as the Cognos BI server, Framework Manager and Cube Designer.
• Worked with the user for resolving the issues on QC, to log and close the defects that are raised.
• Supported the reports in Production environment and transferred knowledge on maintaining/modifying reports in the future to the support team.

Environment: Cognos 10.2 and Cognos 10.2.2 (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration), CAFÉ, Oracle 11g, Windows 2003/7, Microsoft Excel.

Confidential, Houston, TX

Sr. Cognos BI Admin/ Developer

Responsibilities:

• Install and configure Development, Test, Stage, Training and Production environments with IBM Cognos 10.2 BI /CognosTM1 10.1
• Design and Implement Integration of Cognos BI and TM1 Portals
• Design and implement Cognos content Backup and restore
• Cognos 10.2 BI/TM1 10.1 Distribution environment Setup
• Provide design and implementation architectural solutions for data warehouse and data marts database design, ETL/data loading strategy, and business intelligence reporting data, taking into account system requirements, security, system extensibility and interoperability, costs, operations and support considerations, and BI best practices.
• Develop and maintain BI architecture principles, best practices, patterns, guidelines, standards, methods, techniques, and models.
• Logical and physical data design modeling and implementation to meet business objectives and the needs of BI architecture other program deliverables.
• Provide an end to end solution and work with integration partner during design and implementation of the data warehouse, BI tool integration, and associated sub systems.
• Developed Complex ETL code through Data manager to design BI related Cubes for data analysis at corporate level.
• Formulated ETL processes to Extract Data from Operations DB to the Reporting DWH, Designed and developed Cognos EP models and Cubes.
• Worked on MDX functions over Report Studio on Multi-dimensional sources
• Work with MDM Data Governance Lead to implement processes to maintain integrity and quality of the data residing in the data warehouse and data marts.
• Design and implement production processing architecture, including performance monitoring, scheduling, and notification in the event of failures.
• Once deployed, responsible for day to day support of the data warehouse and marts, ETL integration, and BI application.
• ManageCognosBI licenses for projectlife cycle and reviewed the report design and documentation.

Environment: Cognos 10.2 and 10.2.2 BI versions, Report Studio10.2.2, Query Studio 10.2.2, Framework manager 10.2.2, Dynamic Cubes,IBM Cognos Business Insight, IBM Cognos Configuration, IBM Cognos Lifecycle Manager,Cognos 10.2 tool suite, Cognos TM1 9.5.2 and SQL, PL/SQL, Windows 2008, 2012.

Confidential, Whitehouse Station, NJ

Cognos Technical Analyst

Responsibilities:

• Extensively worked on developing simple and complex reports on Cognos Report Studio 10.1.1.
• Developing the reports using various templates like list report, Cross-tab Report and Chart Report.
• Created cascading prompts and worked with various prompt controls such as Value prompt, Pick list prompt, and Date and Time prompt.
• Created reports using conditional formatting and sorting options.
• Created Boolean, String and Report language variables to render the reports to the particular query.
• Worked on Stored Procedures in SQL Server Management Studio 2008 R2(DEV,TEST and PROD).
• Interacting with different application team members and fixing the issues related to the framework models.
• Involved in refreshing the metadata models whenever the changes are made in the stored procedures.
• Worked a user application called E-sales(DEV, TEST and PROD) where the users can access the reports.
• Responsible for upgrading reports from Cognos 10.0 to Cognos10.1.1in Dev, UAT, QA and Production environments.
• Involved in testing and quality assurance of all the reports before delivering them to the end users.
• Assisted to build dashboards using Cognos Workspace, Cognos Workspace Advanced and Cube Designer.
• Developed active reports, dashboards, metrics, analysis and other information in a security-rich environment using Cognos Mobile 10.1.1 to make the user to view and interact.
• Prepared back up plan and Fact Finder documents Disaster recovery plan forCognosBI environments.
• Develop and maintain custom audit reports forCognos usage, servers & portals monitoring plan for n Cognos environments.
• Design and implementCognosportal setup,CognosPortal Performance settings, Cognos server performance settings andCognosproduction deployment plan.

Environment: Cognos 10.1 and 10.1.1 BI versions, Cognos Mobile 10.1.1, Report Studio10.1.1, Query Studio 10.1.1, Framework manager 10.1.1, SQL Server Management Studio 2008 R2 database, XML, Excel and Windows 2008, 2012.

Confidential, Charlotte, NC

Cognos BI Developer

Responsibilities:

• Gather, analyze and document business requirements, clarify business rules and data design requirements, functional requirements and prepare specification documents.
• Assist in reviewing and analyzing existing system structures to provide solutions to enhance and improve system.
• Assist in conducting in-depth review of requirement specifications collected and analyzing business process to determine the exact nature of user’s system requirements.
• Designing mapping of process flow and interacting with analysts and core team members to select the proper system infrastructure.
• Design and review the processing steps and create processes for new system.
• Review project specifications, flow charts, process diagrams and system documentation for application operations and methodology.
• Create processes for new system and attend to ad-hoc issues related to day to day activities throughout project implementation and testing phases.
• Installation and configuration of Business Objects suite in all (Dev, Test and Production) environments.
• Coordinating with other teams to improve the quality of work.
• Extracting OM(Order Management) application data from an Oracle transactional system and Loading it into a SQL Server data warehouse.
• Designed, developed, deployed and maintained Universes using Business Objects Designer tool.
• Developed complex reports including multipage-reports, graphical reports, formulae base and well-formatted reports according to user requirements.
• Created Aliases and Contexts for resolving Loops and Checked the Cardinality and Integrity of the Project / Framework Model.
• Created prompts in report to restrict data fetch and ease data load.
• Restricting the user access with help of Access Level privileges.
• Creation of repositories and security domain with user groups and security implementation.
• As per the Business requirement creating the reports to cater to Order, Orders History, Pending Orders at Tasks, Processes and Tasks subject areas of the application.
• Provided the security access management by creating users/groups and folders.
• Upgraded fromCognos8.4.1 to10.x.

Environment: Cognos 10.1.1, 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight and Business Insight Advanced), Cognos Connection, Oracle 10g, SQL Server 2008, DB2 9.1 on Windows Server 2003/2008.

Confidential, Pittsburgh, PA

Cognos Developer

Responsibilities:

• Analyzed business and user needs to design Business Intelligence solutions that supported business and operations.
• Interacted with ETL team and the DBA to make available certain tables and data modifications required to successfully execute report requirements.
• Involved in Metadata modeling of both Relational and Dimensional data using Framework manager.
• Experience in implementing security based on user roles in Framework Manager and publishing reports.
• Used static choice value prompts, cascading prompts, conditional variables (Boolean and string) to create reports.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Maintenance of TM1 users, roles, and security, Imported the data from ODBC and Text files using TM1 Turbo integrator.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Created Conditional Block reports to dynamically hide or show report objects and provide the end user the option to view the data in different formats.
• Extensively used insertable objects like query calculation, layout calculation and tables to generate efficient and user-friendly reports.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Implemented Conditional formatting and Java Scripts for customizing the reports. Used Java Scripts for validating Date/Time controls and adding customized buttons to facilitate the Show/Hide requests.
• Created Drillable reports to provide users with more detailed information for the next levels.
• Developed various Dashboard Reports such as the Loan Originations dashboard to see at-a glance the volume and characteristics of new loan originations, such as credit scores and loan-to-value calculations throughout the portfolio.
• Scheduled Burst Reports for regions, zones and districts which delivered the appropriate output for the concerned mangers in Cognos Connections by email.
• Created Backups of the content store and Public folders.
• Involved in performance tuning of several Reports.
• Mentored the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Involved in unit testing of all the reports and documented all the test cases worked on.
• Responsible for upgrading reports from Cognos8.4 to Cognos10.1.
• Knowledge in creating Reports and Dashboards using Active Reports and Business Insight.

Environment: Cognos 10 BI, Cognos 8.3 BI Suite, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos TM1 9.5.2, Java Script, PLSQL Developer, SQL Server, SQL DBX.

Confidential - Princeton, NJ

Cognos Developer

Responsibilities:

• This included debugging and optimizing Cognos reports and used a variety of reporting packages to produce, automate, schedule, and distribute defined reports.
• Managing and Administering the entire Cognos 8 for BI Team.
• Involved in designing the Framework Manager Models.
• Improving existing models by Creating Alias tables and applying other techniques for effective reporting.
• Developed several Cognos reports.
• Responsible do to Query Optimization and Performance Tuning of all reports.
• Highlight: Lead functional role involving complete estimation, scheduling and delivery of a project for one of the business clients.

Environment: Cognos 8.4 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Oracle9i, MySQL, MSQL Server, windows 2003, Unix.

Confidential, Rochester, NY

Cognos BI Developer

Responsibilities:

• Developed and implemented Business Intelligence solutions as a part of Business Intelligence Organization.
• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Involved in the design and implementation of the balanced scorecard and online analytical processing (OLAP) solutions
• Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance.
• Collaborated with business to develop high-level designs including logical models and functional specification documents.
• Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.
• Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.
• Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
• Designed and developed PowerPlay cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users
• Recommended and designed summary tables to be used in reports to optimize performance.
• Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data.
• Administered Cognos BI Server Environment
• Managed Package Migrations and Deployments from one Environment to another.
• Managed Data Sources, run activities, user accounts and permissions
• Used Cognos SDK to develop various java applications.

Environment: COGNOS REPORT NET Framework Manager, Report Studio, COGNOS Connection, COGNOS Configuration 7.1, Cognos 8.4 Suite, Oracle 10g, SAPBW, SQL, PLSQL, AQT, PowerPlay Transformer 7.1/7.3, Quest Central, PowerPlay Enterprise Server Administration, Windows 2000, 2003, Unix.