SUMMARY

• Over 13 plus years of progressive experience with teh Cognos BI/ETL and a Certified Cognos Professional with extensive BI Reporting experience using teh COGNOS 11/10.x/8. x. Solid understanding and sound knowledge of Data warehouse/BI concepts.
• A practiced consultant and team lead of business intelligence initiatives, enterprise data warehouse development, trending and forecasting systems and information visualization solutions.
• Strong understanding of Data Mart Architecture.
• Proficient in all phases of Data Warehousing design, development and implementation - Extraction, Transformation, OLAP, Reporting and End-user support.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Strong experience as Business Analyst with Key roles in gathering, assessing, developing project designs, tests, research and data analysis.
• Experience in installing and configuring Cognos/Qlik suite of tools.
• Technically resourceful with an array of skills in design, engineering, data management and IT to an advanced level.
• Team Player with teh ability to communicate TEMPeffectively at all levels of teh Development Process.
• Excellent listening, leadership and client handling and customer facing interpersonal skills.
• Results focused with strategic foresight and clarity, exceptional documentation and conclusive work streams.
• Knowledge of SAP Systems and sources.
• Data Visualization & Analysis utilizing DAR principles
• Advanced Data Modelling
• Geo Data Analytics

TECHNICAL SKILLS

BI/Analysis Tools: Cognos10/11 Analytics, Transformer cubes, Framework Manager, Report Studio, Query Studio, Qlikview11/QlikSense3.1, N-Printing

ETL Tools: Informatica 9.1, Oracle Warehouse Builder.

Databases: Netezza 6.0, SAP HANA, Oracle 9i/10g/11g, MS SQL server, DB2, MS Access.

Automation Tools: Tidal 5.3, Redwood

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Database Tools: TOAD, SQL Developer, AQT, Query Analyzer

Languages: C, SQL, PL/SQL, HTML, and XML, Python

OS: Windows8/7/XP, Windows 2000, NT4.0, UNIX

PROFESSIONAL EXPERIENCE

Sr. Cognos Architect

Confidential, NY

Responsibilities:

• Assisted with teh migration of Business Objects reports to Cognos Analytics (C11), Development and Production servers, setup teh content store databases.
• Built consolidated Framework Model to replicate 6-8 Business Object Universes.
• Extensively worked on Cognos Framework Manager - Creating Models in Framework Manager - Importing Meta Data from Different Sources, Dimension Hierarchy, Determinants, Star Schema Grouping, and Packages.
• Creatingstar schema groupingfor better understanding of teh model & facilitate multi-fact (cross-fact) reporting.
• Setting upcardinality (minimum, maximum & optional), Determinantsto avoiddouble counting,support loop joins,optimize data source, and identifydimensionsandfacts
• Created Cognos Groups and Roles; assigned to teh Team content Folders, and Reports/Dashboards.
• Created model based standalone calculations and filters to support teh reporting requirements. Added Date calculations to support various time periods.
• Involved in gathering and analyzing requirementsand preparing teh Specification document as per teh Business requirement.
• Developed around 70 reports to support Contract, Licensee, Royalty(actual/forecast), Royalty on Hand, Cash, Invoice and Receivables data.
• Developed and consolidated BO reports in Cognos to increase teh TEMPeffectiveness of reporting and convenience for business users.
• Created multiple reports across different business areas like Auditing, Cash & Invoice, Sales, Deals, Royalty and Forecast.
• Created financial reports to capture AR Analysis, Unposted Statements, Earn Out, Royalty by SKU and Receivables.
• Performance tuningby analyzing and comparing teh turnaround times between BO and Cognos.
• Built tabbed reports, used Custom Control to create custom Search and Select prompt on various dimensions.
• Built Data Modules to support additional data from different data sources like Excel.

Sr. Cognos Architect/Admin

Confidential, Bridgewater, New Jersey

Responsibilities:

• Assisted with teh migration of Cognos10 to Cognos Analytics (C11).
• Cognos implementation in an enterprise environment including, installing, configuring, and tuning Cognos architecture that is distributed over multiple servers.
• Setting up theContent storeby creatingcontent databasesinSql Server
• Migrated Portal tabs from Cognos10 to Cognos11.
• Maintain Windows servers including patching, disaster recovery, and security.
• Work with system admin and network teams to troubleshoot any system level issues impacting application health.
• Deployed Content from one environment to another using Export/Import of Reports/Packages for large deployments and used report XML deployment for one or two reports.
• Promote, implement, document, and communicate BI best practices and Standard Operating Procedures.
• Set upAudit tables, Audit ReportinCognos11Environment to analyze teh Report Usage.
• Provide support for BI developers with connection to data sources like Sql Server, Oracle and SAP.
• Created Cognos Groups and Roles; assigned to teh Team content Folders, and Reports/Dashboards.
• Built robust Framework Model for FLEX and JDE reporting.
• Created model based standalone calculations and filters to support teh reporting requirements. Added Date calculations to support various time periods.
• Designed and developed transformer cubes to supporting FLEX/JDE reporting.
• Developed lot of reports to support Lag - Settled, Open Chargebacks, Rebate and Shipment information.
• Created reports to report on Confidential Direct/Indirect Sales, Returns.
• Created EDI 852 - Inventory and EDI 867 - Sales Reports.
• Created financial reports to capture Chargeback Accrual Analysis, Utilization Rate and Average Contract Price.
• Configured Active Directory and Mail exchange server.
• Built tabbed reports, used Custom Control to create custom Search and Select prompt on various dimensions.
• Built Data Modules to support additional Dashboarding options.
• Designed/created reporting tables in Sql Server for increased performance of reports and dashboards.

Sr. BI Architect (Cognos11 Analytics)

Confidential, Houston, TX

Responsibilities:

• Installed and configured Cognos11 Analytics dev and production servers and setup teh content store databases.
• Configured Active directory and mail exchange server.
• Configured teh Cognos 11.0 environment using Cognos Configuration withApplication, GatewayandContent ManagerConnections.
• Created groups and roles and assigned them to teh Team content folders and reports/dashboards.
• Set up Audit tables, Audit ReportinCognos11Environment to analyze teh Report Usage.
• Setting up of teh backups of all environments with backup andrestoringofContent Store Databases, backups ofCognos Configurations, DeploymentofPublic Folders.
• Built robust Framework Manager data model to be able to report on Accounts Receivable, Payroll/Billable Utilization, Labor Wage and General Ledger information.
• Created lot of Standalone calculations and filters to support teh reporting requirements. Added lot of date calculations to support various time periods.
• Developed Margin Enhancement Dashboard with KPI’s to capture Technology & Automation, Contract Compliance, Labor Management and Revenue by Service Line metrics.
• Created highly complex Margin Enhancement advanced Report to able to report on Current, Baseline and Target data and defined teh captured value based on Current and Baseline numbers.
• Developed Active Reports to be able to report on different Business Segments offline.
• Created Branch Payroll, Billable Utilization Reports to support teh Payroll system.
• Built Payroll Utilization Burst Report and implemented security at Branch Level. Implemented Master Detail relationships to get to teh desired output.
• Created Branch Head Count, Labor Wage to track teh employee head count and salaries.
• Created Summary/Detailed Specialty Services report page break on each service.
• Built Summary/Detailed Drill through reports.
• Built tabbed reports, used Custom Control to create custom Search and Select prompt on Customer Dimension.
• Explored teh Data Modules option to build reporting without teh need of Framework Manager packages.
• Built Powerplay cube to give teh ability for users to slice and dice on different levels of organizational hierarchy.
• Created a reporting table in sql server for better performance of reports and dashboards.
• Built a flexible Period table in teh backend to able to report on any time.

Sr. BI Architect (Cognos/Qlik)

Confidential, Hoboken, NJ

Responsibilities:

• Worked with Business Intelligence and Analytics team as teh lead BI consultant for various projects to produce Marketing/Sales Executive Summary dashboards and reports from conception to final deployment covering complete phases of production - requirement gathering, analysis, best data modelling practices and UI visualization concepts.
• Served as member or ERP(SAP) Reporting implementation team to provide TEMPeffective reporting solutions to AR, FP&A, Research & CRM departments.
• Provide programming support to visualize relationships in teh raw data. Develop and maintain automatic reporting tools, visualization dashboards and decision support tools to support business needs.
• Implemented 3 Layer Architecture in Framework Manager support teh reporting requirements.
• Designed/implemented an in-memory solution (Dynamic Cubes) for CDM group to capture Total Customer Value.
• Built ad-hoc packages to report directly against JD Edwards’s application across different source systems and created pre-built report templates for users to use in Query Studio.
• Developed Profit and Loss Analysis cubes with Currency Conversions and implemented security.
• Developed 25-30 OLAP cubes using Cognos Transformer to slice and dice on Sales, Earnings, SMDB, Journals and different Channels at Wiley.
• Provided flexible OLAP solution for third party vendors in UK to able to report and analyze Agency data.
• Implemented Row, Object and Package level security in Framework Manager and data level security in OLAP Cubes.
• Created parameter maps in Framework Manager to support dynamic reporting in Report studio.
• Implemented table driven reporting solution in Cognos to report daily Profit and Loss Statements for Financial Planning and Analysis team. Generated Board and Quarterly Management reports on weekly basis.
• Created burst reports to able to burst on Sales Territories and distribute them to Regional Managers and individual Sales Reps with Targets.
• Developed a reporting solution for Global Planning System team and implemented row level security based on Company Org. hierarchy dimension.
• Built prompt macros in reports studio to halp users to dynamically sort or display columns.
• CAFÉ Reporting - built OLAP cubes in tranformer8/10 to support reporting in CAFÉ and designed reports in list and formula modes.
• Salesforce.com Reporting, extracted data from Salesforce.com into Framework manager using Virtual View Manger and created reports in Report Studio.
• Metastorm Reporting - created dashboards in report studio against data extracted from Metastorm application to capture Slippage/Grippage of all Journals.
• Built ad-hoc reporting packages with standard report templates to be able to report on JD Edwards data.
• Built an ad-hoc reporting solution (Query studio packages) to capture Book production and Paper planning & purchasing costs.
• Automated Cognos reporting/OLAP applications using Tidal Scheduler, Redwood and batch scripts.
• Participated in all levels of testing from peer code reviews to individual unit testing, integration and user acceptance testing.
• Analyze, troubleshoot and resolve system functional and technical errors including issues of overall system performance. Troubleshoot on systems and data and generate solutions which may include systems modifications enhancements or new procedures.
• Participate in customer feedback sessions on product usability and acceptance to identify opportunities to improve product functionality, features, and overall customer acceptance.
• Create detailed functional and technical design documents.
• Demonstrated ability to provide solutions considering applications beyond installed footprint.
• Organize work, set priorities and meet critical deadlines.
• Worked in Agile Software development environment.
• Worked with bug, issue tracking and Project management tools like JIRA and Mantis.
• Instrumental in various upgrade/migration projects:

BI Consultant

Confidential, NY

Responsibilities:

• Involved in installing and configuring teh latest version of Cognos8.1MR2.
• Involved in upgrading existing Reportnet 1.1MR3 environment to Cognos8.
• Involved in upgrading teh existing 14 models in Reportnet to Cognos8.
• Involved in debugging teh upgraded Reports pointing to all 14 models.
• Created a new model called RTCC using framework manager in Cognos8 in an attempt to consolidate teh existing 14 models into a single, stable and a consistent model.
• Involved in gathering requirements and enhancements for teh new model from business users.
• Designed ER diagram for teh new model and documented teh design spec’s using Microsoft Visio and Word Document.
• Created filters, calculations, prompts in framework manager with consistent naming conventions and designed a business layer with customized query subjects with business terms which are used for Adhoc as well as for advanced reporting.
• Performed Unit testing to teh test teh performance of teh RTCC model.
• Implemented security in Cognos8 for teh new model using LDAP and also created user groups and roles.
• Added Package level security to teh packages.
• Deployed teh packages to testing and production environments.
• Created new reports using teh RTCC model and used Java scripts in teh prompt page for teh reports to make teh report more users friendly.
• Wrote SQL queries to explain teh report data quality.

Cognos Consultant

Confidential, Norwalk, CT

Responsibilities:

• Involved in installing and Configuring Framework Manager.
• Involved in gathering requirements from business users and created new reports and did enhancements to teh existing reports
• Involved in modeling metadata in framework manager and updating existing model.
• Created new query subjects, calculations, and filters in teh framework model.
• Created Parameter Maps pointing to different query subjects in framework manager and provided teh users with teh option of selecting multiple facts and dimensions dynamically.
• Created reports with Layout and Filter prompt pages where teh users are given teh option of selecting teh columns to appear in report output in teh layout prompt page and to filter teh data in filter prompt page.
• Created complex reports with dynamic calculations embedded to measure volume and dollar sales for each month and yearly by various geography, product or brand levels that combined data from multiple tables at different levels of hierarchy into single list based reports.
• Implemented Conditional formatting for highlighting rows and columns, and hiding individual rows.
• Implemented security in access manager by creating users and user groups and also applied security at package level.
• Scheduled various reports using Schedule Management in Cognos Connection.
• Deployed packages and reports to different servers.
• Wrote Sql and performed Unit testing for all developed reports.

Migration Consultant

Confidential, Ware, MA

Responsibilities:

• Involved in installing and configuring Cognos8 on client server machine.
• Configured Cognos8 with Cognos series7 Namespace to integrate security.
• Created Data source connections in framework manager.
• Installed Migs7 migration tool in teh same location where Cognos series7 tools are installed previously.
• Installed Migdeploy tool in teh same location where Cognos8 is installed.
• Migrated 12 catalogs to cognos8 framework manager.
• Migrated and deployed around 80 .imr reports to Cognos Connection.
• Debugged and formatted teh migrated .imr reports using report studio.
• Configured Reportnet with Cognos 7 series Namespace.
• Involved in integrating upfront reports and cubes to Cognos Connection.
• Published Cubes from Power Enterprise Server to Cognos Connection.

Environment: Cognos 8 BI, Report Studio, Framework Manager, Cognos Connection, Query Studio, Cognos Scripts, Cognos Scheduler, Configuration Manager, Content Manger, IIS Web Server, Cognos7 series, Impromptu and MS SQL Server on Windows 2003 server.

Cognos Consultant

Confidential, New Jersey

Responsibilities:

• Gathering business requirements from various users in Rebates department.
• Involved in Strategic Planning for Cognos Report Net Framework Model.
• Created models using Framework Manager in multiple namespaces by creating shortcuts, joins, star schema groupings, Calculations and filters.
• Created and published Packages using Frame Work Manager.
• Created database connections to different data sources in Framework Manager.
• Designed teh standard template for creating reports in Report Studio
• Responsible for teh delivery of solution-oriented complex reports using Cognos Report Studio.
• Creating and Managing Jobs and Schedules.
• Introduced Highlight exceptions, and drill-down reports to expedite analysis.
• Involved in training end users in Cognos Connection and Cognos Query Studio
• Created User Acceptance Test (UAT) plan documents for both managed and ad-hoc reports.
• Attended Functional Testing and User Acceptance sessions and worked on teh feedback from teh business users.
• Deploying teh packages (exporting and importing teh packages) using teh Deployment functionality under Cognos Connection Portal.
• Trained users in Cognos Connection to run/schedule reports and save to my folders.
• Provided support for managed reports and users
• Documented teh whole reporting process.
• Documented high level business user requirements.

Cognos Consultant

Confidential, San Diego

Responsibilities:

• Involved in Installing and Configuring ReportNet Server, FrameWork Manager.
• Involved in data modeling in Framework.
• Secured Models are created using FrameWork Manager.
• Created and published Packages using FrameWork Manager.
• Applied Security at teh package level.
• Applying Security and User Authentication to teh various User Groups.
• Deploying Sample, Testing teh Server and Managing Cognos Connection Portal.
• Scheduled reports and with different output formats..
• Developed standard Reports, Charts, Drill through Reports, Master Detail Reports.
• Created new jobs using Cognos Connection.
• Scheduled Management is used in Cognos Connection.
• Bursting Reports and using Report Studio and Query Studio.
• Configured Access Manager with MS Active Directory and involved in creating users and users groups.
• Configured reportnet with Cognos7 Series Namespace.
• Published newly created impromptu reports to Upfront.
• Created Macros using cognos script editor for automating teh existing impromptu reports.
• Documenting teh whole process.