SUMMARY

• Over Fourteen years of IT experience with Sound knowledge and experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production. Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions Cognos 11 (Analytics), Cognos 10, Cognos 8, Cognos ReportNet, Cognos Impromptu, Transformer, Power Play and Cognos Query.
• Including 10 years hands - on experience with the Cognos ReportNet suite (Framework Manager, Cognos Connection, Report Studio, and Query Studio) as both a developer and as an administrator.
• Involved in migrating reports from Cognos 8 to Cognos 10. Involved in data migration process between different versions of Cognos.
• Involved in migrating Catalogs, Impromptu reports from Cognos Series 7 to Cognos 8.
• Experience in designing models with Framework Manager involving Relational Models and Dimensional models.
• Experience in installation and configuration of Cognos 10, Cognos 11, Cognos 8 and Cognos ReportNet Environment.
• Experience working with Large Database and DW BI Implementation
• Experience with ReportNet Software Development Kit (SDK) to customize reports.
• Experience in Security Implementation in Cognos8, Cognos 10, ReportNet, on various levels such as User level, Object Level, Row Level Security Implementation.
• Developed OLAP applications using Cognos suite of tools and extracted data from the enterprise data warehouse to support the analytical and reporting for all Corporate Business Units.
• Hands on experience administering, deploying and maintaining Models, Reports, and Cubes using ReportNet, Impromptu, Transformer, Power Play and PPES.
• Published IWR reports and Power Play Cubes on the portal using Cognos IWR report administrator and Power Play Enterprise Server.
• Created dimension maps and multidimensional cubes using Impromptu Query Definition in Power Play Transformer.
• Involved in migrating Cubes, Power Play Reports from Cognos Series 7 to Cognos 8.
• Developed MDX Queries, PL/SQL database stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.
• Proficient in using best practices to support the reporting activities.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS

BI Tools: Cognos Business Intelligence 7.0, Impromptu 7.1/7.0/6.0, Impromptu Web Reports 7.0/6.0, Upfront, Cognos Query, Power Play Transformer 7.1/7.0/6.0, Power Play Enterprise Server, Access Manager, Cognos Visualizer, Cognos Script Editor, AW, Cognos ReportNet 1.0.2/1.1 MR2, Cognos 8.3, 8.4 BI Series and Cognos 10.1, 10.2, 10.2.2, IBM SPSS, Cognos 11,Qlikview 9, Cognos 10 BI Author Certified.

Languages: SQL, PL/SQL, C, C++, Oracle, Visual Basic 6.0/5.0

Data Modeling: Erwin 4.0 / 3.5

Front End: Visual Basic (6.0/5.0), HTML

Operating System: Windows 2000/ NT/ 98/ 95,MS-DOS, UNIX

Databases: Teradata, Oracle 10g,9.x/8.x/7.x/6.x, MS SQL Server 2000/7.0/6.5

ETL Tools: Informatica 8.1, 7.1

PROFESSIONAL EXPERIENCE

Confidential

Senior Cognos Consultant

Responsibilities:

• Installed and configured Cognos Analytics (11.0.12).
• Worked closely with the business to understand the current reporting system and documented recommend solution with Cognos.
• Conducted JAD session with the business and documented the requirement in a system response documentation.
• Provided business with Cognos Architecture diagram and Data Mapping documents mapping source to target.
• Designed and developed complex dashboards for the Confidential Executive team based on Cognos Cube.
• Developed operational reports based on a transactional system with WBS structure.
• Developed and provided training for the end users on Cognos Analytics.
• Created views specifically to meet the reporting requirements.
• Unit tested reports and helped the Testing team with answering Cognos questions.
• Deploy Cognos application to different environments within Confidential .

Environment: IBM Cognos 11.0.12 BI Suite (Framework Manager, Report Studio, Dashboard), Oracle11 g, Powerplay Enterprise Server, PowerPlay Windows Client and Powerplay Transformer.

Confidential

Senior Cognos Consultant

Responsibilities:

• Identified and mapped tables and columns in the database to the fields in the Remedy application
• Created views that are required for reporting and imported them into FM and created DMR models
• Created the three layers in FM and set the correct usage properties and aggregate functions for each query items
• Created required calculations and applied business rules into the business layer
• Conduct JAD sessions in order to gather requirements for reporting.
• Created about 20 Cognos reports and dashboards to meet the business initial need which also compliant with the Accessibility for Ontarians with Disability Act
• Met with business users to gather requirements for ad Hoc reporting purpose.
• Build the FM model to satisfy the business user ad Hoc reporting purposes.
• Oversee and supported end-user training through preparation and delivery of training course and materials.
• Implemented security for Data access, Object level access and Package access.
• Resolved performance related report issues with many of the existing reports by working both on the model as well as the database views.
• Resolved any performance issues of the reports by enhancing the performance of the SQL queries.
• Created deployments and data source in Cognos administration. developing reports compliant with the Accessibility for Ontarians with Disabilities Act

Environment: IBM Cognos 11.0.9 BI Suite, Oracle11 g, MotioPI and Remedy Esubmit.

Confidential

Senior Cognos Consultant

Responsibilities:

• Imported and installed Cognos Rave Visualization into the Library.
• Analyze the existing 30 Dashboards based on matrix studio and identify areas where the dashboards can be consolidated.
• Building the backend tables and views in DB2 that would support the reporting needs both Detail drill through and summarized data.
• Created drill through using parameterized report URL and passed multiple values from dashboards to detail report
• Included metrics such as ALC % and ED LOS Indicators calculations in the dashboards and showed trends and traffic light indicators depending on the KPIs.
• Working very close with the Management teams to get inputs into the development of the dashboards as its being developed.
• Help other team members with Cognos report development and troubleshoot any issues that arise in the production environment.
• Help the business get the reports by providing different delivery methods including Bursting to public mail Box / Common Shared Drive.
• Perform add hock data extracts and reporting on the fly when requested by business users.
• Worked with users in solving any Cognos related issues the users encountered and provided training on Workspace Advanced and Café.

Environment: IBM Cognos 10, Cognos Rave Visualization customizer and DB2.

Confidential

Senior Cognos Consultant

Responsibilities:

• Created and enhanced PEAR standard reports using Cognos Version 11 which are being used by Inventory PHU and PPHD users.
• Created over 20 reports and Dashboards using Active reports in Cognos Version 11
• Ensured the developed reports follow the report standard and documented Unit Test results in JIRA.
• Once the development is completed did a walk through with business and QA teams.
• Worked with business users to clarify requirements and assist in UAT.
• Assisted business in providing Cognos training to the PHU users.
• Worked on any production related issues identified by the users in regard to Cognos application.
• Developed and documented Data Refresh monitoring tab on the Cognos portal.
• Prepared XML for deploying to Production and updating Deployment document once QA Signed off.
• In the process of converting current CQM based reports to DQM supported reports.
• Worked with QA Team to address any defects in JIRA and informed them of any application behavior.
• Developed application that comply with the GO-ITS standards.
• Attended release meeting and provided status on progress of report development and defects progress.
• Very familiar with the PHIPA and created data governance around PHIPA.
• Helped business users to create Ad hoc reports or to modify the existing standard reports to their need.
• Updated the Data Dictionary with new columns that are being added as a part of enhancement.

Environment: IBM Cognos 11 Analytics, Oracle SQL Developer and IBM Panorama.

Confidential

Senior Cognos Consultant

Responsibilities:

• Migrated existing Salesforce and TIBCO Spotfire reports into Cognos reports.
• Worked on Framework Manager modeling tool in order to support report development.
• Work on any production issues that arise on a daily basis and provide RCA.
• Written Specification for development of reports and other enhancement to BI Reports
• Monitor daily scheduled jobs and troubleshoot any issues related to job failure.
• Converted existing Sybase based Cognos reports to work with Oracle database.
• Redesigned the existing TIBCO Spotfire reports to work with the Oracle database.
• Fixed any Reports that did not meet the SLA by optimizing the SQL query.
• Created Executive Dashboard and News Letters to be used by the senior management.
• Created TM1 web sheet templates, workflow validations, and custom automations.
• Building TI process to create cubes and load data into the cubes.
• Writing data mapping documents, data transformation rules and maintaining data dictionary, data migration and interface requirements documents.
• Created Cognos reports using TM1 cube as a data source.

Environment: IBM Cognos TM1, Cognos BI 10.2, TIBCO Spotfire and Salesforce

Confidential, Chicago, IL

Sr. Cognos Developer

Responsibilities:

• Developed the upgrade plan and test plan documentation for upgrade
• Upgrade Cognos 8.4 reports to Cognos 10 and bug fixing of the migrated reports
• Used Lifecycle Manager to compare reports before and after upgrade.
• Worked on different Cognos related application solutions initiatives from the requirement gathering phase to deployment of the solutions.
• Developed, Tested and Deployed IIG, GFO and Asset Management dashboards for Wealth Management group.
• Created Income Balance Sheet and Asset Management cubes and deployed to different internal users.
• Evaluated the Cognos CAFÉ and Workspace Advance modules and demo the product to customer.
• Enhance the performance of the SQL queries by creating the Indexes
• Reviewed the existing application for Gap Fit Analysis and Impact Analysis.
• Studied the existing application for Business Process Design Reengineering for Application.
• Tested the product behavior and logged product defects with IBM.
• Worked with IBM Development Team on providing interim solution for NT.
• Deployed and trained users with the café product and mentor business users.
• Developed reports for IPad and provided users with access to mobile dashboard.
• Lead the certification effort of Café and Go office products.

Environment: Cognos 10.1 Workspace Advanced, Report Studio, Cognos Analysis For Excel 10.1.1, Cognos Life Cycle Manager, Go Office, Oracle 11 g

Confidential, Beaverton, OR

Sr. Cognos Developer

Responsibilities:

• Created complex Transformer cubes for each individual territories with the EM
• Created the Executive dashboard for the Sales EM Directors Using Workspace
• Working with fact table which contains Large number of transactions close to 10TB
• Uploaded forecast data from excel sheets into SQL server and used it as a data source to add forecast data to the existing cubes
• Performed multiple complex transformations using SSIS packages
• Performed Clean House on transformer models before performing cube build in order to minimize the cube size.
• Played a major role in production support of the existing cubes and reports
• Gathered, validated, and documented business requirements within a single function.
• Communicate and coordinated the translation of functional requirements into technical solutions with IT resources.
• Supported testing activities including construction of test plans/scripts including the expected results and validation of test results.
• Updated the Data Dictionary as required basis.

Environment: Cognos 10.2 BI Suite (Work Space, Workspace Advanced, Report Studio), Transformer, SQL server 2005, SSIS and Oracle 10g

Confidential, Arden Hills, MN

Sr. Cognos Developer

Responsibilities:

• Created dashboards for different BSC groups and delivered them to the user’s IPAD.
• Implemented a solution to provide Data level security to different users within the organization so that the access requests can be automated.
• Performed administrative tasks such as ensuring the Cognos environments are running smoothly, giving access to new users and providing access to report folders.
• Monitor schedule jobs in the morning and re run and trouble shoot jobs that have failed overnight.
• Provided the company’s Executive team with the Executive Summary report solution which contained sensitive Sales data.
• Worked with the business users in creating reports that are related to Clinical data, Rebate Calculations and Compliance reports.
• Deploying and publishing QlikView applications on server.
• Resolved any Cognos Server issues and helped in applying patches and regularly maintained on the clustered Cognos environments.
• Created Korn shell scripting to modify the cognos report names on the server side.

Environment: Cognos 10.2 BI Suite (Work Space, Workspace Advanced, Frame work manager, Event Studio, Report Studio, Query Studio),Transformer, QlikView 9,Oracle 11 g, Unix, PL\SQL Developer.

Confidential, Conway, AR

Sr. Cognos Developer

Responsibilities:

• Worked with users, business analysts to define reporting requirements for various services and processes using Cognos 8 BI Suite (Cognos connection, Query Studio, Report studio, Analysis Studio, Event Studio and Framework Manager).
• Used a variety of reporting packages to produce, automate, schedule, and distribute defined reports.
• Worked on migrating Cognos 8.4 reports to Cognos 10.1.
• Created Active reports in Report Studio and Build Dashboard using Business Insight.
• Mentor / help users with using Business Insight Advance to create Ad hoc reports.
• Built Models and published Packages utilizing Framework Manager for various Departments using Cognos 10.
• Created several packages in Framework Manager.
• Creating several parameter maps, calculations and relationships in Framework Manager.
• Creating and publishing several packages in Framework Manager.
• Worked on CCS, SLA Data and Created different Reports using Cognos 8.4 BI Suite.
• Worked on Stored procedure packages and created different reports.
• Developed Lists, Crosstabs, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Created calculations, filters and prompts in Report Studio reports.
• Created user groups for distribution and assigned security based on different roles.
• Generated various kinds of reports (Daily, weekly, monthly etc) in Cognos 8 BI Suite.
• Responsible for creating Ad hoc reports for business users.
• Created different joins according as per the user requirements.
• Created OLAP Cubes in Cognos Transformer and analyzed the data using Cognos PowerPlay.
• Developed Models and Power Cubes in PowerPlay Transformer using multiple IQDs and data sources, implemented drill through to Impromptu reports.
• Updated the multiple IQDs depends on the requirement.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Maintained Cube security by user classes from Access Manager.

Environment: Cognos 10.1, Cognos 8.4BI Suite (Frame work manager, Business Insight, Business Insight Advance,Report Studio, Query Studio), Impromptu, PowerPlay, Transformer, Upfront, Access Manager, SQL Server, Oracle 11 g, PL\SQL Developer.

Confidential, Irvine, CA

Sr. Cognos Developer

Responsibilities:

• Responsible for daily monitoring of the cube build over night and trouble shoot any failures in the process.
• Developed using the Agile SDLC methodology.
• Worked on any tickets that were created by end users in regards to data issues.
• Work closely with the Sales and Finance department.
• Created reports and Cubes on Inventory on Hands, Shipped and Sold calculations.
• Created reports indicating Return items reports for management team.
• Worked with end users to gather requirements, develop requirement documents and build new cubes and reports.
• Worked extensively with the Framework Manager, Powerplay Transformer in order to build Framework Manger models, Transformer model and cubes.
• Built Power Play Reports based on these cubes and published to Cognos 8 Server.
• Developed new automation processes to generate and deliver large amount of data to users outside the Hines’s Firewall.
• Managed the Cognos Administration including trouble shooting server issues and grading access to the new users to the Cubes and reports.
• Provided technical support and administration for the existing Cognos Power Play Cubes.
• Developed numerous drill-through Power Play and Cognos 8 reports.

Environment: Cognos 8.4, Reportnet, Framework manager, Oracle 10g, Toad 7.4PowerPlay Transformer, Cognos Server Administration, Cognos Configuration

Confidential, Santa Ana, CA

Sr.Cognos Developer

Responsibilities:

• Upgrade Cognos 8.2 reports to Cognos 8.4 and test all the reports in the new environment
• Loaded Big data (30- 40 TB) into the BIS system from multiple data sources including Oracle and SQL Servers.
• Build and scheduled the DTS jobs in order to bring in the data on a daily basis into BIS
• Created tables, index and views in order to do reporting off the BIS data sources.
• Produced and enhanced stored procedures and ad hoc queries in SQL
• Optimized and modified the triggers, complex store functions, procedures, user base datatype
• Extensively used loops, conditions, functions and store procedures in producing monthly process data.
• Created Korn shell scripting to automate cube creation.
• Extensively used MDX functions and queries to retrieve data from the Analysis cube.
• Created a data models in Frame work Manager with data level security.
• Worked with the finance and Treasury departments in order to provide them with the Journal Entry and Other Financial reports
• Created reports that contain monthly and cumulative amortization for loan discounts and originations fees.
• Created reports for analysis and auditing purpose, including reports at the student detail level.
• Worked with the INSIGHT data warehouse in building and bring in Data from different Student Systems.

Environment: Cognos 8.2 and 8.4, Framework manager, Windows NT, PL/SQL, Erwin 4.0,Informatica Powercentre, Oracle 10g (SQL Plus).

Confidential, El segundo, CA

BI Team Lead

Responsibilities:

• Worked on different projects that involved requirement gathering, creating project plans, managing project, creating Power Play Cubes, Multidimensional Power Play Reports, Cognos 8 Framework Manager Packages, and List, crosstab and charts report net reports by using Cognos 8, Report Studio, Framework Manager, Power Play Transformer, Power Play, PL/SQL and Informatica
• Implemented Cognos 8, Developed Dimensional Models for Cognos 8 Analysis Studios, and Migrated Power Play cubes to Cognos 8 Framework Manager.
• Designed multidimensional reports in Cognos 8 Report studio
• Created Dashboards for end users in Cognos 8 using “new page” option.
• Built Cognos 8 packages for many daily and monthly usage reports using Framework MR2 and MR3 for different projects.
• Used Series 8 Report Studio to create list reports, cross-tab reports and chart reports with date, value and text box prompts.
• Implemented Security in Cognos 8 Packages before publishing.
• Wrote SQL queries to populate different calculated columns in reports.
• Scheduled Report.Net Reports to deliver through e-mail in PDF and Excel formats.
• Created Drill Through between Parent (Summary) and Child (Detail) Report.Net Reports.
• Designed and developed Cubes for Sales, Sales and Inventory, Inventory, Stock Ledger using Power Play Transformer V 7.3.
• Used time state rollups, average rollups and external rollups in some Transformer Models.
• Created dimension maps and multidimensional cubes using Impromptu Query Definition in Power Play Transformer.
• Created drill throughs from Power Play Cube to Detailed Report.Net reports.
• Created Korn shell scripting to automate cube creation.
• Migrated Cubes, Power Play Reports from Cognos Series 7 to Cognos 8.
• Used features of Informatica Versions 6.x and 7.x like Designer and Workflow manger and Repository Manager.
• Created training guides for different projects to efficiently use Power Play Cubes, reports and Report.Net Reports.

Environment: Cognos 8, Report NET Version 1.1 MR3, Power Play 7.3, Power Play Transformation Server Version 7.3, Power Play Enterprise Server 7.3, Framework manager, Informatica Power Center 6.1/7.1, UNIX, Windows NT, Oracle 9i.

Confidential, Hartford CT

Senior Cognos Developer

Responsibilities:

• Studied the existing CRN environment and draft the Design Document for the Sales Analytics project.
• Revised the Requirement Specifications with the users for better customer service and feasibility in CRN.
• Logged Support cases with Cognos and follow-ups.
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Developed procedures, functions and database triggers using with PL/SQL.
• Created User Groups, Roles to implement the Cognos Security, using LDAP. Implemented and administered different levels of security and report bursting, using Cognos 8, Access Manager.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and designed with a star schema .
• Assisted in Cognos migration projects: From Impromptu 7.3 (Catalogs) to Cognos 8
• Involved in administration, development and support of existing & new (20+) Catalogs, Created Dashboard and query definition files using various joins and filtering conditions using Impromptu administrator.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, Multi-page, Multi-query reports against multiple databases.

Environment: Cognos 8 (Framework Manager, Report Studio and Query Studio), Power Play 7.3, Transformer 7.3, Power Play Enterprise Server 7.3, Impromptu 7.3, IWR, Oracle 9i (SQL, PL/SQL), Win 2K Server, Teradata