Tivoli Access Manager Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Ruby Wickham

309 Carifa Drive · Hilliard, OH · 43001 ·  (614) 596-9876

ruby@yahoo.com

Summary   

As a senior-level Cognos/BI/Data Warehousing resource Rory has 9 years experience (10+ overall IT experience) with planning, installing, configuring, administrating & tuning multiple Cognos Product Suite installations/upgrades across various operating systems and industries.  During that same time, he has acted as Team Lead, BI Champion, Mentor and/or Developer and has performed 9 years of full-cycle development with both the Series 7, ReportNet and Cognos 8/10 toolsets; everything from requirements gathering to actual Framework Manager, Report Studio, Query Studio and Transformer design/development.

Technology Summary                                                  

Programming Languages

§  SQL	§  VB Script	§  Java and JBuilder
§  ASP 3.0	§  JavaScript	§  Visual Basic 5.0

Operating Systems

§  Red Hat Enterprise Linux (RHEL)	§  Windows 95/98/NT/2000/XP
§  Sun Solaris UNIX (SunOS)

Databases

§  Oracle 11g	§  MS Access	§  SQL Server 7.0/2000	§  Sybase
§  Teradata v2r5.0	§  UDB/DB2/OS390 (v7.0 – 8.0)

Software

§  Cognos BI 8.0 – 10.1	§  MicroStrategy Business Intelligence Suite 7 (MSI)
§  Cognos ReportNet 1.1 (CRN)	§  Microsoft Internet Information Services
§  Cognos Series 7 Suite	§  Apache Web Server
§  IBM WebSphere 5.0/6.1/7.0	§  Querymon
§  Tivoli Access Manager 6.1	§  Microsoft Project
§  Teradata Administrator	§  DB2 Query Management Facility (QMF)
§  Teradata SQL Assistant	§  Cygwin
§  Embarcadero Rapid SQL	§  Omegamon II for DB2

 

Industry Certifications

                          April, 2011                                                               IBM                                                                  Columbus, OH

§  BM Certified WebSphere 7 Administrator

                          March, 2011                                                            IBM                                                                  Columbus, OH

§  IBM Certified Cognos 10 BI Administrator

                          March, 2004                                              Cognos Corporation                                                    Cleveland, OH

§  Cognos Certified ReportNet Product User

                          August, 2003                                            Cognos Corporation                                                    Cincinnati, OH

§  Cognos Certified Level 2 BI Administrator

                          February, 2003                                          Cognos Corporation                                                    Cincinnati, OH

§  Cognos Certified Level 1 BI Author

Education

                          February, 2002                                 DeVry Institute of Technology                                           Columbus, OH

§  Bachelor of Science in Computer Information Systems
Summa Cum Laude

Experience

                          August, 2008 – Current                      KForce/Lockheed Martin                                                    Dayton, OH
                          October, 2006 – June, 2007

                          Senior Data Warehousing Consultant/Business Intelligence Architect

                          Cognos Solutions Expert – Lockheed Martin (Wright Patterson Air Force Base)

§  Acted as sole Cognos 10.1 Administrator/Architect, responsible for:

·         Reviewing/approving all Cognos designs (models, repots, cubes, etc)

·         Performance-tuning reports/cubes, improving performance by an average of 50%

·         Recommending development/architecture paths with regards to Business Intelligence

·         Cross-training DISA/Lockheed personnel on Cognos architecture and administration

·         Co-authoring BI Strategy & Roadmap presentation for Air Force personnel/staff

§  Installed Cognos BI 10.1 in several multi-server, multi-tier RHEL environments

§  Coordinated with AKAMAI to implement portal caching in multiple Cognos environments

§  Customized Cognos Connection to remove various formatting/functionality as per requirements

§  Created multiple UNIX shell scripting to automate the following:

·         Archiving of Cognos server log files

·         Execution of multiple cube builds and deploying cubes across servers

§  Installed and configured the following across multiple SunOS environments:

·         Cognos BI 8.4.1 in multi-server, multi-tier configuration

·         Cognos BI 8.1 in multi-server, multi-tier configuration

·         Multiple Hot Fixes and/or Fix Packs

 

                          IBM WebSphere Administrator – Lockheed Martin (Wright Patterson Air Force Base)

§  Acted as WebSphere Administrator for WebSphere 6.1/7.0RHEL environments, responsible for:

·         Deploying multiple Rich Internet Applications to multiple environments

·         Installing & Configuring Deployment Manger & Application Server installs

·         Applying multiple WebSphere Fix Packs across multiple environments

·         Enabling/configuring Global Security against Tivoli Access Manager

·         Utilized profile manager to create additional profiles in an installation

·         Enabled detailed logging to troubleshoot multiple issues

·         Troubleshot applications issues in the WebSphere 7 environment

§  Wrote multiple shell scripts to facilitate network connectivity testing across 20+ servers

§  Created and/or re-configured multiple Tivoli Access Manager WebSeal Junctions

§  Responsible for adding users to various TAM groups in Development environment

                          June, 2007 – August 2008                    Sterling Commerce, Inc                                                        Dublin, OH
                          Lead Business Applications Analyst/Cognos Tech. Lead

§  Acted as BI Champion to Sterling Commerce in order to:

·         Promote Data Warehousing and Business Intelligence best practices

·         Educate the business on the value/use of a  Data Warehouse/Data Mart system

·         Coordinate the BI Road Map with the Business

·         Assist with Executive Information System Dashboard initiative

·         Spearhead the Enterprise Reporting Solution Data Mart

·         Mentor other team members in the use of Cognos

§  Installed and configured the following across multiple SunOS environments:

·         Cognos Business Intelligence 8.3

·         Cognos Business Intelligence 8.1

·         Cognos ReportNet 1.1 MR 2

·         PowerPlay Enterprise Server 7.3 MR 2

§  Peer-reviewed and tuned multi-fact (5+) metadata models for various Data Mart initiatives

§  Created/Administered multiple Reports, Drill Through Mappings and report delivery schedules

§  Performance tuned Transformer models to provide more efficient cube builds

§  Gathered requirements for integration of SalesForce.com data to the EDW

 

Experience (continued)

                          March, 2005 – October 2006       American Business Solutions, Inc                                              Dublin, OH
                          Senior Data Warehousing Consultant/Business Intelligence Architect

                          Cognos Solutions Expert – Sterling Commerce, Inc

§  Communicated with Senior Level executives (CFO, CIO, etc) to plan Data Mart initiatives

§  Responsible for coordinating/providing multiple BI demonstrations to the business

§  Architected multi-fact metadata model to provide global analysis of financial information

§  Installed/Configured ReportNet 1.1 and Series 7.3 components on multiple  SunOS environments

§  Architected multiple CRN models/packages against a DB2/UDB warehousing environment

§  Integrated CRN environments with Production Active Directory authentication instance

§  Created multiple UNIX Shell Scripts to automate multiple PowerPlay Cube building routines

§  Gathered high-level requirements for the first Data Mart solution provided to Sterling Commerce

§  Assisted in gathering low-level technical requirements/specifications of multiple source systems

§  Coordinated with Data Modelers/ETL team to prioritize deliverables

§  Designed several multi-dimensional, multi-fact PowerPlay cubes

§  Implemented row-level security in Framework Manager Metadata Models as per requirements

§  Assisted with Cognos Licensing estimates and pricing negotiations

§  Coordinated migration of MicroStrategy 8 BI solutions to Cognos ReportNet/PowerPlay

§  Wrote/tuned/analyzed multiple SQL statements as part of development/testing process

                          April, 2004 – March 2005                        Ovation Group, LLC                                                          Chicago, IL
                          Senior Systems Consultant/Business Intelligence Architect

                    Team Lead – Blue Cross Blue Shield of Illinois (HCSC)

§  Served as ReportNet expert across three different states in order to move reporting away from Impromptu and on to ReportNet based applications; this took the form of migration planning for current Impromptu-based projects and formulating training recommendations for various FTEs

§  Assisted with installation/configuration of multi-server environment to provide a more scalable/stable reporting environment for both Series 7 and ReportNet customers; this included integration of  ReportNet 1.1 MR1 with IBM WebSphere 5.0 as part of corporate standards

§  Responsible for reviewing current strategy of corporate portal integration with Cognos Series7 and recommending more efficient/maintainable processes/designs to be utilized

§  Participated in multiple design reviews of logical data models to make sure appropriate design methodologies were utilized, so that efficient/reliable designs were provided for use in future BI reporting by customers

§  Acted as Primary Developer for DB2 Operational Data Store (ODS), utilizing Cognos ReportNet.  This Proof-of-Concept was aimed at replacing a Siebel/Actuate production CSR reporting system that is performing at less-than-optimal speeds

§  Assisted with redesign of various SQL queries/programs from older version of Enterprise Data Warehouse (EDW) data model to the latest version; this includes analyzing queries via Teradata Explain plans and working with Teradata DBAs to find more optimal query designs

§  Administrated multiple Cognos environments, maintaining 12+ reporting projects being utilized by several hundred users running 1300+ reports per week

§  Communicated with Director-Level management in order to begin process of designing/building/implementing Data Marts so that more efficient/user friendly reporting can be made available to customers                               

§  Provided direction/leadership for Cognos BI reporting team by setting deliverable dates, conducting design/peer reviews and prioritizing tasks/goals at both the team and individual levels

§  Responsible for knowledge transfer/mentoring of fellow team members in regards to BI Reporting methodology, Cognos reporting toolsets and techniques for training customers in the use of Cognos reporting tools on an ad-hoc basis

§  Coordinated project management tasks/status with various team members of the Texas, Illinois and New Mexico plans of BCBS

§  Interviewed/recommended applicants for the Data Delivery team in order to supplement skill sets

§  Interacted on a daily basis with Business community to plan/organize various EDW/BI reporting projects, including the gathering of business requirements; this often resulted in BI project plans containing Statements of Work, Scope Documents, Reporting Requirements, etc

Experience (continued)

                          March, 2002 – March, 2004       Ohio Department of Job & Family Services                          Columbus, OH

Programmer/Analyst II

MicroStrategy BI Developer/Administrator

§  Assisted with successful implementation of the Business Intelligence Channel (aka “BIC”), which assisted the State of Ohio in improving the “WELFARE-TO-WORK” accomplishments for Fiscal Year 2002.  This resulted in the State of Ohio receiving $21 million dollars in Temporary Assistance for Needy Families (TANF) awards on September 30^th 2003; more than any other state in the country

§  Participated in design, rollout and administration of ODJFS Eligibility Data Mart Release 1.0 & Release 2.0 using MSI 7.1, which includes three separate reporting projects.   Responsibilities included data-analysis, creating/altering interactive web-based reports and assisting with various optimization strategies for those reports

§  Beta-Tested MSI 7.2, including integration of Narrowcast with Web and Integration of Informatica’s metadata repository to show source data mappings for attributes within Desktop.

§  Administrated multiple MSI environments, maintaining over 12 different MSI reporting projects consisting of 500+ Users

§  Utilized VLDB settings in MicroStrategy to performance tune SQL generation

§  Architected multiple drill paths for reporting objects, providing flexibility of analysis to the customers

§  Utilized 2-Tier and 3-Tier connections to analyze MSI performance and SQL generation

§  Created multiple measures with embedded filters to implement required business logic

§  Developed multiple MSI projects for various internal customers

§  Designed multiple views/tables via SQL to enhance various MSI reporting requirements

§  Installed/Configured MSI NarrowCast to provide scheduling/delivery capabilities for reporting

§  Monitored queries in DB2 environment as part of MicroStrategy query optimization

§  Manipulated ASP and VBScript code to customize the default MSI Web interface into an online reporting portal based on ODJFS web site standards for the entire State of Ohio

§  Trained end-users at both the County and Statewide level in use of MicroStrategy Web including the creation of in-class curriculum and on-line training manual

§  Performed data validation of tables in Data Mart via ad-hoc SQL queries against DB2

Cognos BI Developer/Administrator

§  Delivered a Decision Support System allowing the business to view summary data in a cube and then drill down to detail about Ohio participants in a “Work Activity” program.  As tech lead on this project, responsibilities included data analysis of Work Activity database and creation of web-based/interactive reports to replace current static mainframe data

§  Designed/Tested/Created multiple Impromptu Reports and Power Cubes for various Cognos reporting projects

§  Documented Business Requirements for end-users to better design reports/cubes for their needs.

§  Designed Indexes using DB2 EXPLAIN for multiple DB2 tables to optimize query run time for Impromptu drill-through reports.

§  Assisted in design/creation of multiple DB2 lookup, fact and aggregate tables

§  Utilized a variety of Mainframe and Client Server tools against DB2 to perform data analysis/exploration and query monitoring

§  Created Scope and Training documents for various Cognos projects

§  Responsible for Planning/Developing MicroStrategy conversion to Cognos Series 7 solutions

Download Resume Format