We provide IT Staff Augmentation Services!

Principle Consultant Resume

Libertyville, IL

TECHNICAL SKILLS

  • Cognos BI 8 and 10
  • Cognos BI Installation and configuration
  • Cognos Administration
  • Cognos Metrics Designer
  • Framework Manager
  • Cognos Integration with Maximo 7.5
  • PowerPlay Transformer
  • Cognos Report Studio
  • Cognos Report Studio
  • Cognos Metrics Studio
  • Knowledge in:
  • Data warehouse design
  • Maximo 6.2 and 7.5
  • Data warehouse construction
  • Integration Services (SSIS)
  • OLAP modeling
  • Microsoft SQL Server
  • UNIX operating systems
  • SQL scripting
  • Windows operating systems
  • Oracle
  • ColdFusion
  • VB Script
  • Dreamweaver
  • Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential, Libertyville, IL

Principle Consultant

Responsibilities:

  • Manage and lead project deliverables pertaining to development of Cognos Business Intelligence
  • Integrated Maximo 7.5 with Cognos reporting
  • Lead development activities for quality reporting for Maximo 7.5 in Cognos
  • Mentor Framework Manager and Report developers
  • Develop database stored procedures to improve performance in Cognos
  • Administer overall Cognos environment to ensure system is running and stable
  • Design and develop Cognos Business Intelligence applications
  • Gather requirements for end user reporting and analysis
  • Develop best practices
  • Developed upgrade strategy to migrate existing Cognos Series 7 and ReportNet 1.1 applications to newest version of Cognos 8 environment
  • Create plans for report and environment testing
  • Author technical and design documentation following SDLC process
  • Architect and install software in new and existing environments
  • Mentor clients on best practices, administration, and report design
  • Advise client on licensing decisions
  • Advise on database table structure for reporting environment
  • Developed vb.net code to automate Transformer and Cognos Connection security
  • Assist in the analysis and troubleshooting of data and database issues

Confidential, Libertyville, IL

Principle Consultant

Responsibilities:

  • Worked with client to develop multiple ReportNet reports utilizing Report Studio and DB2 stored procedures
  • Developed and modified DB2 stored procedures to deliver data to the Cognos reporting environment to be utilized by the Report Studio reports
  • Assessed end user report requirements to better define results
  • Assisted in developing reporting best practices for the developers and end users

Confidential, Schaumburg, IL

Engagement Manager

Responsibilities:

  • Responsible for leading teams to deploy large scale enterprise applications of Cognos solutions across web and client platforms.
  • Developed, managed, and executed project plans, including requirements gathering and definition, development, end user training and documentation.
  • Assessed hardware and software requirements for enterprise deployments.
  • Analyzed and evaluated data mart and data warehouse implementations across multiple platforms.
  • Worked with clients to establish best practices and support guidelines for help desk personnel.
  • Continually developed the relationship between clients and Cognos.
  • Supported sales and pre - sales staff in sales cycle.
  • Ongoing knowledge transfer to clients.
  • Worked with multiple clients, including Fortune 500 companies, in the pharmaceutical, financial, sales, marketing, and manufacturing industries.
  • Mentored colleagues to sharpen and grow their consulting skills.

Confidential

Business Intelligence Consultant

Responsibilities:

  • Developed Impromptu catalogs with an emphasis on capturing appropriate database content and providing maximum end user reporting capability in complex data settings.
  • Creation of customized Impromptu reports tailored to customer’s stringent reporting requirements.
  • Performing analysis, design, and implementation of PowerPlay applications for Windows and Web based solutions.
  • Development of security architecture for PowerPlay and Upfront.
  • Coding of automation processes for periodic updates of PowerPlay OLAP data.
  • Provided training and knowledge transfer to customers on implemented solutions.
  • Performance tuned pre-existing SQL used in both Impromptu and PowerPlay.

Confidential, Highland Park, IL

Data Warehouse Developer

Responsibilities:

  • Performed design and analysis for the multiple data warehouses.
  • Developed front end user reports utilizing Business Objects.
  • Development of C code to extract data from source systems to populate the data warehouses.
  • Developed reports to validate nightly load of Risk Management data in Microfocos COBOL on UNIX platform.
  • Developed and maintained global relational database systems on AIX and mainframe platforms.

Hire Now