SUMMARY:

• Over 20+ years of experience wif Cognos Analytic Enterprise reporting solutions (using Cognos 11.1.5 (thru Cognos 5.0). Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Power Play and Transformer cube development. Data Server, Data Sets, and Dashboard development
• Strong working knowledge of Cognos Administration, Cognos Connection, Security Implementation
• Managed multiple client engagement for Costpoint Enterprise (ERP Application) reporting solutions.
• Excellent ability to gather and understand business requirements and translate into IT solutions.
• Experienced wif Full Life Cycle development including requirements gathering, analysis and design, implementing, testing and deployment.
• Comprehensive experience developing end to end reporting solution using Cognos application Suite.
• Excellent problem resolution and communication skills wif ability to work under pressure in a highly visible role.
• Ability to manage multiple project assignment and deliverables.
• Conducted and development workshops for Costpoint Enterprise reporting on and off premise.
• Capable of developing communication plans wif all level of the corporate organization structure.
• Seasoned Technical Project Manager.

TECHNICAL SKILLS:

Applications/Tools Database/Software: Cognos (11.1.5 to 5.0), Query Studio, Report Studio, Framework manager, Data Server and Dashboard reporting. Business Intelligence Reports, OLAP solutions, Design and analyze Framework models to meet business and technical requirements. Developing complex reports and Content administration. Microsoft Office 365, MS Suite, SQL Server, Teradata, Skybot, MotioPI, JIRA, Aqua Studio

PROFESSIONAL EXPERIENCE:

Confidential, Uncasville, CT

Reporting Engineer - Team Lead

Responsibilities:

• Performed daily Project Management activities to meet internal and external reporting requirements.
• Developed dashboards and reporting solution for hospitality and entertainment organizations.
• Create and manage BI Users group to educate and facilitate technology capabilities throughout the organization.
• Designed and Implemented Cognos materials for Internal team Members.
• Manage/Implemented Cognos Analytic upgrades and installation (release 10 thru 11.1.5)
• Manage daily halp desk responsibilities to facilitate resolution of trouble tickets.
• Create self-manage work teams to implement reporting solution throughout the organization.
• Managed communication board using JIRA application to provide project status on report deliverables.
• Used Motio PI to facilities report status for application upgrades.
• Implemented and Upgrade Framework models wif tables changes as required to support legacy application.
• Created and implemented Data server and Data Modules to replace Framework models
• Created and support supported Kronos reporting application for New Time and attendance application.
• Manage Daily cube development thru Skybot application.
• Responsible for the daily administration and operation of Business Intelligence application.
• Created and managed Hotel and Hospitality dashboard for daily hospitality operations.
• Mentor and develop junior team members.
• Implement reporting solution to meet IRS Compliance Reporting requirements.
• Implemented Kronos Reporting application for new Time and Attendance application.
• Established Monthly Cognos user group meeting to facilitate technology adoption and knowledge center.
• Implemented Dashboard and Data server for Hospitality reporting.
• Developed and delivered classes in Cognos Reporting tools (Report Studio)
• Implemented Data server, data sets and data modules to replace framework models.
• Managed and Developed team members to operate as self-managed teams.
• Worked wif various Mohegan Sun team member to implement technology solution to improve the day to day operation. (Arena Alert Report, Housekeeping dashboards, VIP Dashboards)

Confidential, VA

Senior Consultant

Responsibilities:

• Provided technical and consulting services to Major account throughout the US for 6 years.
• Managed multiple client engagement at the same time.
• Provided Technical support for application upgrades to the Costpoint Enterprise Reporting (Cognos).
• Created medium to Complex reporting solution for Costpoint Enterprise reporting.
• Manage Full Life Cycle development for reports relating to HR, Payroll, Finance and Accounting.
• Implemented row level security protocols for major accounts.
• Delivered classes in Cognos Reporting tools (Query studio, Report Studio, and Framework Manager).
• Developed data extraction file for Benefits and Payroll feed to major insurance providers.

Confidential, San Diego, CA

Project Manager

Responsibilities:

• Worked wif project teams to support monthly application releases.
• Managed project plans to support BOBJ implementations to standup 4 environments (Dev, QA, Stage and Production).
• Managed project plans to support Master Data Management Implementation, and monthly BI enhancement. .
• Participated in weekly meetings to provide project and budget status .
• Manage project budgets in excess of 2M dollars.
• Conducted weekly meeting to facilitate project activities.
• Managed complete project lifecycle for BOBJ and MDM implementation using waterfall methodology. .
• Manage weekly PaTT budget to ensure accurate costs and internal labor are applied to the correct projects.

Environnent: SAP Change management, Microsoft Suite, and MS Project 2010

Confidential

Project Manager - Business Process Re-engineering

Responsibilities:

• Worked wif Vice President and Directors to streamline and consolidate business processes into Shared Services Center.
• Developed and managed multiple project plans for Insides Sales, National Casino Marketing, and Independent Agent work streams
• Created workflow matrix to document National Casino Marketing activities for process improvement/consolidation.
• Worked wif internal department to coordinate hardware requirement for new hires.
• Developed logistic plans for computer hardware re-allocation related to consolidation activities.
• Worked wif HR to communicate/coordinate hiring requirement for 45 new Inside Sales Reps.
• Establish internal and on-boarding requirements for Inside Sales new hires.
• Worked wif regulatory department to establish licensing requirement for new hires.
• Documented job description to support new organization structures/procedures.
• Drafted/created organization charts for PRCO and Regulatory compliance approval.
• Prepared Bi-weekly project status documents for PRCO meeting to senior management.
• Facilitated weekly project status reviews meeting wif Vice Presidents and Directors to communicate risk/concerns.
• Developed and communicated implementation plans wif other departments.
• Prepared Capital Investment proposal for Centralized Operator Call center.

Environnent: Microsoft Suite, MS Project.

Confidential, San Francisco, CA

Cognos Administrator

Responsibilities:

• Supported Cognos 8 Client’s base of approximately 200 users globally.
• Provided “front line” support for Client’s Cognos 8 environment by fielding end user support tickets·
• Triaged tickets based on urgency and level of difficulty.
• Obtained working knowledge of Client’s SDLC and change control methodology·
• Performed System Administration and maintenance duties of Cognos 8 application to satisfy business requirements and service level.
• Support users in the creation of Cognos queries and reports.
• Maintain and update existing queries, reports, folder structure and portals.
• Monitor and ensure stability of all 4 environments: DEV, TEST, PROD and DR.
• Respond to system alerts (e.g. Cognos report failures, application server space issues, etc.).
• Provided Production support to troubleshoot and resolve issues by engaging various infrastructure teams and application development teams (me.e.: Server, Oracle, Salesforce.com, SQL DBA, and Integration teams).
• Respond to and resolve performance issues for users.
• Troubleshoot user security permissions or display/browser issues.
• Manage issue resolution wif IBM Cognos support.
• Identify and deploy required Cognos Framework Manager Model updates from Dev to Prod as required.

Environment: Cognos 8.4, SQL Server Database.

Confidential, CA

Project Manager/Sr Cognos Developer

Responsibilities:

• Developed Cognos dashboards application to support corporate departments (Treasury, SOX compliance, GAAP Financial Services, Accounts Payable, Payroll Procurement and Supply, and HR).
• Developed and maintained Framework model to support dashboard project.
• Developed ETL process to extract data from Excel Spreadsheet documents.
• Loaded data into Oracle tables using TOAD.
• Created and modified database structures to support application.
• Worked wif Senior management to established and clarify metric and qualifications.
• Delivered Financial Service and Stewardship Dashboards on time and according to specification.
• Provided end to end user and application documentation to the client.
• Develop Cognos OLAP cube to support Dynamic Dashboard.

Environnent: Cognos 8.4, Oracle 10.2 Server Data base, Toad for Oracle 9.0

Confidential

Project: Financial Planning and Analysis

Responsibilities:

• Cognos Planning administrator and technical support for Strategic Plan, Forecast and Budget, BI Data mart.
• Worked wif IT organization to develop SLA to improve system performance.
• Developed E2E system performance application to monitor data migration from Cognos Planning to the BI DW.
• Migrated Budget and forecast models from Development to Production servers.
• Manage day to day administration of Planning Models.
• Established triggers and alerts procedures/process for systems failures.
• Open service request for system upgrades and enhancement using REMEDY.

Environnent: Cognos 8.4, Cognos Planning 7.3, Oracle 10.2 Server Data base

Confidential, San Diego, CA

Project Manager

Responsibilities:

• Project managed On-shore/Off-shore Cognos development team consisting of 25 developers to deliver 500 Cognos reports to support Confidential business units rolling onto Costpoint ERP Application Data Warehouse, BI Reporting/ERP Application.
• Managed financial budget (capital and Expense MM$) for Costpoint Implementation.
• Managed project plan for Wave 2 and Wave 3 report development and migration and all project activities for SDLC.
• Converted project plan from Waterfall to JAD methodology to facilitated Rapid Application Development.
• Conducted weekly Joint Application Development Session (JAD) sessions.
• Established performance enhancements activities wif development team and Database Administration team.
• Established performance testing process and metrics for report migration to production.
• Worked wif Business Analysts to streamline and document current processes to improve report migration to production.
• Conducted daily standup meeting (SCRUM/Agile) during report development and migration periods.
• Participated in migration planning meeting and “Dry run” to ensure deployment activities were successful.
• Coordinated meeting wif Business users to get Customer Acceptance during Wave 3 development cycle.
• Established communication plans using InStride SharePoint websites to communicate project status to upper management and Business Units.
• Developed contingency plans to remediate delayed report development activities.
• Worked wif Cognos O&M team to established transition plans for Go Live implementation (Wave 1, 2 and 3 Go Lives).
• Worked wif BI user groups to standardize best practice for Cognos reporting. Worked wif Change Management team to baseline documentation and specification for SOX compliance.
• Implemented internal testing teams for Wave 3 Framework and Oracle 11G upgrades using Cognos Upgrade Manager.

Environnent: Cognos 8.3, Oracle 11G Server Data base

Confidential

S enior Cognos Developer

Responsibilities:

• Project managed daily SCRUM (Agile) project management meetings. Worked on daily Scrum activities to support SCRUM objectives for BI projects.
• Participated in migration planning meeting and “Dry run” to ensure deployment activities were successful.
• Developed Meta Model to document framework model (tables and views) the model was use to established QA validation and user acceptance criteria for reporting.
• Re-evaluated VDS reports for performance and content layout. Re-worked reports to improve performance and message delivery.
• Evaluated bursting requirement for Studio performance reporting. Created short-term solution until new Cognos architecture was established.
• Implemented exception highlighting in Report studio reports to support Video Store reporting.

Environment: Cognos 8.2, Oracle Server Database

Confidential

Project Manager / Senior Cognos Developer

Responsibilities:

• Worked wif CIO to implement contingency plan for Marketing Planning and Analysis data mart initiatives,
• Worked wif external vendors (CPU and EDS) to establish current state process flows and business requirements.
• Established EDW design reviews wif all departments ensuring data warehouse compliance for requirements.
• Worked wif BI on-shore/off-shore development teams to resolved production issues.
• Coordinated wif internal project managers to ensure EDW development initiatives met future application requirements.
• Conducted weekly project status meeting for EDW development activities and project deliverables.
• Worked wif Marketing, Finance and Vendor management organization to implement BI requirements (reports and cubes).
• Resolved BI issues and concerns wif application performance.

Environment: Cognos 8.3, Oracle Server Database

Confidential

Project Lead / BI Architect

Responsibilities:

• Managed full project lifecycle development for Order to Cash (OTC), MDM and Sales Order Management (SOM) BI Reporting for Data Warehouse Migration.
• Managed customer relationship and established IT credibility wif End users (internal customers).
• Used reporting matrix to capture, record and monitor reporting requirements for BI deliverables.
• Facilitated users requirement gather meetings for Order-to-Cash project implementation.
• Developed Implementation plans for BI deliverables.
• Reviewed and validated Data Warehouse project plan for BI reporting requirements wif offshore development team.
• Recommended BI solution for reporting requirements.
• Developed implementation plans for BI deliverables.
• Developed, documented, and conducted End to End (E2E) test plans for Service Alliance implementation.
• Developed SRS documentation and test plan for BI deliverables.
• Conducted conference room pilot for BI Dashboards, Cognos Cubes and reports for MDM Go-Live.
• Developed BI Dashboard requirements and conducted JAD session for all internal departments.
• Conducted Voice of the Customer (VOC) meeting for Meta Repository requirements.

Environment: Cognos 8.1, Report Studio, Cognos Powerplay, Oracle Server Database

Confidential

Senior BI Developer/Architect

Responsibilities:

• Performed full project lifecycle development from concept to production.
• Developed dashboard reports to support Sales and Marketing program.
• Presented dashboard (story boards) to Sales and Marketing management for final approval.
• Worked wif DBA group to establish table’s structures for reporting application.
• Created reporting packages in Framework Manager wif data modeler group.
• Established “Bursting” requirements for Regional and District Sales Managers’ reports.
• Created OLAP cube for second phase of project deliverables. The prototype was used to explore the possibilities of second phase project requirements. The cube was implemented upon completion of sales and marketing data mart.

Environment: C8, Cognos Powerplay, SQL Server Database

Confidential

Project Manager

Responsibilities:

• Managed project to replace two current labeling applications wif an OTSS (off the Shelf) labeling application to support the Global manufacturing operation.
• Created project plans and monitored progress to the plans. Monitored project expenses to approved budget.
• Developed “Requested for Capital Expenditures” (RCE) for Hardware and Software acquisition.
• Prepared project documents required for Guidant System Development Methodology (GSDM).
• Conducted business process architecture session to develop “As-Is” and “To-Be” process flows.
• Communicated project status and updates to IT management and business sponsors.

Confidential

Senior BI Developer

Responsibilities:

• Developed Lot History Data Warehouse reports.
• Developed complex multi-frame reports.
• Created reports bursting methodology to support report distribution to user base.

Environment: CRN 7.3 MR2, Oracle Database

Confidential

Sr BI Developer /Technical Lead

Responsibilities:

• Managed and Administered the Sightline Vehicle Distribution day to day operation for Cognos Reporting environment, which includes daily production of cubes, reports, and server administration.
• Managed and performed new development requirements for cubes, IWRs, IMRs and CRN reports.
• Manage CRN migration team.
• Performed full project life cycle development activities for the following projects:
• Manage Sightline catalogs migration using Framework manager.
• Cognos exported the catalog and reports available in Series 7.3 to CRN using the migration tools provided.
• Converted 50 (Series 7.3) reports into Cognos Report Net reports. The catalog exported to CRN was further refined using Frame Work Manager (FM).
• Security was implemented using the corporate LDAP server, Cognos Connection and Frame Work Manager. Roles, Groups, Filters were incorporated using Cognos connection and Frame work Manager such that users could only see information relevant to them.
• Managed application Development team for the development of 30 new reports in CRN.
• Responsible for setting up best practices for Report Development, Frame Work Model Development, CRN Installation and Administration, CRN Security Implementation.
• Facilitated and trained users to fully utilize CRN capabilities
• Developed application to support the Pre-Owned Retail marketing business.
• Created catalogs, reports and cubes to monitor the business objectives against predefine metrics.
• Converted C3 Dealer Scorecard catalog to Framework Manager Package.
• Created 25 CRN reports to support daily business activities.
• Security was implemented using the corporate LDAP server, Cognos Connection and Frame Work Manager. Roles, Groups, Filters were incorporated using Cognos connection and Framework Manager.
• Created Framework manager package to support legacy application.
• Created preliminary reports to replace old Focus reports as required by the end users.
• Created report templates to standardize reporting format.
• Security was implemented using the corporate LDAP server, Cognos Connection and Framework manager. Roles, Groups, Filters were incorporated using Cognos connection and Framework manager.
• Redesign several cubes (Order Bank, Retail Sales and Inventory Pipeline) to improve performance and functional usage.
• Implemented Cube prioritization profiles to improve the daily production process, and improve overall deliverables for the monthly closing process.
• Established Server backup and restore procedures.
• Installation and configuration of Cognos Software’s in a mixed UNIX and NT OS environment and successfully implemented production releases by tuning system efficiency and performances.
• Provided technical support to end-users. Analyzed & troubleshoot complex Cognos system/day-to-day issues, provided problem resolutions on time. Extensively given Users, demo and provided time critical on-line production supports.
• Create, publish and maintain IMR, IWR, and CRN reports and power cubes. Automate and administer reports, dynamic cubes and security batch processes using macros.
• Involved in the creation of around 100+ IMR and IWR reports on the web, complex transformer model for cube build also provided drill through cube to IWR/CRN reports functionality. Created functional/program specs, templates and development standards.
• Worked on Framework Manager, Report/Query Studio, Cognos Connection, Cognos Configuration tools in migration and implementation of Sightline IWR/Web reporting environment.
• Developed test plans and involved in Unit/integrated/system testing process across Development, QA & Production for the user acceptance & sing off.
• Centrally controlled critical user access/maintenance for Authorization/Autantication process in Access Mgr LDAP.

Environment: IBM DB2 and UNIX. Cognos Series 7.0, 7.3, and CRN. MR1.2. Cognos Server Administration, Cognos Upfront, WS FTP Pro, Putty, FTP utilities.