SUMMARY:

• Accomplished and driven BI Architect with 15 years of Confidential BI experience. Excellent communication, documentation and presentation skills. In - depth experience working with business users as well as senior executives. Innovative and analytical thinker with a track record of bringing proactive insights to challenging and high-pressure situations. High rate of success in delivering consistent and superior results.

TECHNICAL SKILLS:

Confidential 8.4: Framework Manager (4 years), Analysis Studio(2 years), Report Studio (4 yrears), Transformer (12 years), Event Studio(1 year), Metrics Studio(3 years), Connection (4 years).

Confidential 7: Powerplay, Transformer, Impromptu, UpFront, Metrics Manager, Impromptu Web Reports

ETL: Business Objects Data Integrator, Confidential Data Manager

Databases: SQL Server, Oracle, Access

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, NJ

Migration Specialist

Responsibilities:

• Currently working on project that involves upgrading Cognos 8.4 multi-server environment to Cognos 10.1.1. There are approximately 1200 Report Studio Reports, 10 dashboards, and 44 cubes that source 400 Powerplay views. The reports exist in Cognos 8.4 connection portal, and the cubes reside in 7.4 Upfront portal using Powerplay Enterprise Server.
• Tested Framework Manager models and packages which were migrated from 8.4 to 10
• Developed identification, scoping and remediation processes using best practice change management processes and procedures
• Remediated Javascript issues related to the migration
• Responsible for migrating 50 cubes and 1000 cube views from Cognos 7 Powerplay Enterprise server to Cognos 10 Transformer and Powerplay server
• Involved in developing and executing functionality testing for behavioral differences between Cognos 8.4 and Cognos 10

Confidential, Skillman, NJ

Cognos Developer

Responsibilities:

• Worked on Sales Data Warehouse data integrity task for Pricing Project

Confidential, Ridgefield Park, NJ

BI Architect

Responsibilities:

• Responsible for entire Cognos BI deployment and data warehouse (SQL Server), ETL data flows (Business Objects Data Integrator) from JD Edwards ERP system. Responsible for Reporting and Analytics, new development, support, and onboarding users, and leveraging existing reporting objects for repurpose across Corporate and subsidiaries.
• Used Framework Manager, Transformer, Analysis Studio, Report Studio, Event Studio, Transformer (for building cubes).
• Developed dynamic Report Studio reports in Sales and Marketing, Incident Reporting, Pricing, Inventory Reconciliation, and Invoice Processing.
• Reported weekly status at PMO (Program Management) meetings.
• Represented BI in CCB (Change Control Board) meetings. Provided insight and cost benefit analysis for reporting requirements submitted from the business, provided change control documentation, did all the BI development, testing and promotion to Production
• Worked with JDE Edwards consultants with data mapping for a number of functional area reporting initiatives, including Supply Chain, GL, Production Costing, Sales and Marketing, and Inventory Reconciliation
• Identified opportunities to utilize existing, enhanced, or new technologies or business methods to streamline work processes and to improve business margins within individual business units
• Maintained an awareness of systems, products, and expertise available to utilize in addressing business unit needs
• Created Request for Proposal (RFP) by identifying business/functional requirements by working with key business personnel or end-users; Attend and assist in Vendor demo and create the Vendor Scorecards and other comparison analysis
• Created test scripts and participated in the UAT testing and SBS testing during deployment.
• Managed and worked with TM1 consulting resources, providing data flows from TM1 for budgeting and forecasting into the data warehouse and to presentation layer of BI.
• Responsible for proposing, designing, developing, and deploying Analysis Studio cubes for Sales/Marketing and Supply Chain for users unfamiliar with the technology.

Confidential, Langhorne, PA

Senior Cognos Developer/Architect

Responsibilities:

• Worked as a member of the Business Intelligence Group, developing retail marketing solutions with Cognos 8.4 BI
• Worked on projects for the following retail customers: Toys R’ Us, Burlington Coat Factory, L’ Confidential, Loehmann’s, Stage Stores
• Worked with Framework Manager and Report Studio to create parameterized reports that interacted with an Oracle Dynamic SQL engine against a multi terabyte data warehouse
• Participated in design sessions to customize reports for clients
• Work with project team to document, design and create innovative solutions
• Lead/Support System Testing and User Acceptance Testing
• Provided subject matter expertise and guidance to less experienced staff members
• Conducted the analysis using appropriate tools/techniques, and deliver high quality analysis work to the business users, along with actionable insights and recommendations
• Provided direction to resources, monitor development efforts, assemble key project deliverables, report project status, and raise awareness on issues requiring escalation
• Worked as usability analyst for creation of web-based portals; Analyzed and recommended redesign based on company standards and visual identity guidelines.
• Created user manuals and provide user
• Effectively handle changing requirements and priorities including change management processes and ensuring changes are properly tested and migrated to production

Confidential, Nanuet, NY

Cognos Architect

Responsibilities:

• Installed and configured Cognos 7 on development and Production servers, along with LDAP.
• Migrated entire Cognos deployment, which included LDAP, Powerplay cube / IWR / Impromptu / UpFront / Macro Automation scripting
• Worked cohesively with Project Managers, BAs, Architects, Developers, DBAs & QAs
• Gathered data requirements of subject areas from stakeholders and developed strategies for data profiling and data validation.
• Involved in database Schema design and development.
• Developed data maps to track transformation of data elements from source to target.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML.
• Played a key role working closely with and supporting the Project Manager and associates.
• Documented the requirements and the functional specifications for the varied business areas.
• Managed the change requests and requirements throughout the project life cycle (PLC) - Initiation, Planning, Execution, Control and Closure.
• Organized and executed UAT testing.
• Successfully completed the User sessions, deployment, production testing and closures.

Confidential, Rockaway, NJ

Cognos Analytics Architect

Responsibilities:

• Developed entire Powerplay Analytics program for Confidential North America (32 cubes), including analytic cubes for Inventory, Sales, G/L, Supply Chain,Budgeting and Forecasting, Marketing, Customer Analysis, Product Analysis
• Developed entire scorecard deployment (6 scorecards), which covered tracking KPI’s for IT, Sales, Personnel, Distribution, and CRM
• Created detailed technical specification documents, WDIS specific installation document for application deployment.
• Provided support for over 250 users on Powerplay and Impromptu Web Reports
• Worked closely with the core technical team. Participated in system-critical review meeting. Brought out several technical issues that needed to be plugged.
• Responsibilities included backend support, maintenance and U/A testing for applications.
• Trained over 50 client analysts to use upgraded systems, doubling their productivity within a quarter.
• Initiated communication with the client company to provide intricate details and information during the initial trouble-shooting period.

Confidential, New York, NY

Cognos Architect

Responsibilities:

• Responsible for entire Cognos deployment; Powerplay cubes, Transformer models, Impromptu, DecisionStream ETL, SQL Server Data Warehouse
• Received Reporting requirements from Business Users (Truck leasing), and financial stakeholders and developed sophisticated Impromptu reports and Powerplay cubes to track leasing exposure, revenue streams, and risk.
• Provided support for over 25 users on Powerplay and Impromptu Web Reports

Confidential, Blue Bell, PA

Senior Cognos Consultant

Responsibilities:

• Consulted in a number of client sites for ISA:
• Confidential - Managed 3 consultants on 6 Transformer/Powerplay development projects.
• Confidential - Provided “Migration Matrix” cube; cable subscribers cube; DecisionStream ETL to Oracle Data warehouse.
• Confidential - Developed Sales and Marketing cube for all of Confidential ’s products (apparel) and retail stores worldwide
• Confidential - helped tune Powerplay cubes for worldwide distribution of cubes over UpFront portal.
• Confidential - migrated and upgraded multi server Cognos deployment from one server to 3 servers, upgraded 7.0 to 7.1, created mirrored cube environment “Daily Sales Cube” for performance
• L’ Confidential - Did multi-server upgrade of IWR from 6 to 7, which included PPES, UpFront, Access Manager, and Netscape LDAP. This included migrations of all data stores and object files (cubes, Impromptu Reports, UpFront data store, Transformer models, etc.).

Confidential, New york, NY

Senior Cognos Consultant

Responsibilities:

• Consulted in over 50 clients in the NY area for Cognos’ Confidential in New York office.
• Acquired on all Cognos products.
• Taught over 25 customized classes for Powerplay, Impromptu Administration, Impromptu Report development
• Conducted Pre Sales engagements when required