Reviewed and analyzed processes and reports developed from the BI team and provided estimates and recommendations for short- and long-term benefit solutions and for Disney Studio’s finance department. SME on Cognos TM1 Disney financial system matters.Full life cycle development including on requirements gathering, technical design, development, testing, and integration of TM1, Cognos BI report studioDeveloped and sustained DB2 SQLs and Views for Cognos TM1 and Informatica sources.Implemented and supported Cognos TM1 processes and Cognos BI Financial services and ensured consistency of data across SAP, DB2 and TM1 transitions.Performed technical code review of offshore teams to identify logic issues from test case scenarios.Served as the primary point of contact for communicating analysis results and recommendations to senior management and for the development and deployment of key reports.

Hired in a consulting capacity to install and configure Cognos, document the development process, and work with the developer to begin new Cognos application development. Developed automation script for daily cubes refresh and a corporation report studio that captured sales data at 15-minute intervals.Built Framework Manager data source connection, imported tables and star schemas, and built power cubes for sales, menu items, payment, and discounts.

Built power cubes for Europe and North America sales and finance organizations.Applied security to cubes, category, and portal levels. Develop query subjects in Framework Manager. Developed Event Studio for daily cubes refresh monitoring.Developed bursting report to 600 sales representatives for complex crosstab daily reporting.Supported report users in report distribution automation.Gathered business requirements and documented knowledge transfer processes.

Technical and team lead and GM consultant for the Cognos 8.3 sales reporting system. Worked directly with the GM business on requirements gathering and agile development.Built Oracle Materialized View for improved report performance.Built relational models and packages using Cognos Framework Manager.Created complex reports by integrating multiple queries to create a single output and tabular SQL (with custom joins) using Report Studio.Analyzed query performance and tuned SQL queries for improved performance.Developed standard, list, cross-tab, dashboard, and drill-through reports. Scheduled and distributed reports through Schedule Management in Cognos Connection.Used business requirements to create cubes and related drill-through reports to satisfy reporting requirements.Create query prompts, cascading prompts, develop prompt pages, and conditional variables.Responsible for Cognos administration, securities, configuration, and installation and the troubleshooting of production errors, issues, and outages.Performed code review, unit testing, regression testing, and test case QA of Cognos reports, PLSQL, and UNIX Scripts.Configured LDAP for authentication and to define users, groups and roles.Maintained audit and content database and CN tables for jobs and reports scheduling.