Cognos Developer Resume
US
EXPERIENCE SUMMARY
Successful IT Operations manager experienced with leading multi-discipline, high performance teams responsible for the implementation, enhancement, and maintenance of a variety of strategic technology assets in addition to providing data operations support to teams across the data warehouse and applications areas.
TECHNOLOGY
Platforms: AIX UNIX, IIS, Win 2000/2005/2008, and IBM MVS
Development Tools: Information Server 7 and 8 (Data Stage, QualityStage, ProfileStage/Information Analyzer, FastTrack, Information Services Director (ISD), Metadata Workbench), MDM Server, COBOL, UNIX scripting, SQL, Cognos 10, Cognos 8, Impromptu, and Powerprompts, Business Objects 6.5 and XI, SAS Enterprise 9.2, Dreamweaver 4/MX, Macromedia Studio MX, HTML, Javascript, VBScript, Powerbuilder, C++, MS Access, ALC, Focus, RPG, Natural, and CICS.
Relational Database Technology: DB2 Z/OS, DB2 UDB, Teradata, Oracle, SQL Server, MS Access
Supporting tools: WAS 6 and 7, HP Openview Monitoring, Wily, nMon, Motio CI, ASG Zena, ASG Zeke, SecureCRT, Putty, WS-FTP, xMing, CA HelpDesk, HAL, File-Aid, FCile Master, Abend-aid, MS Project, Powerpoint, Visio, Lotus Notes, Word, Excel, Adobe Acrobat, PC Anywhere, Citrix, Reflections, On-Time, Attachmate, PCOMM, PVCS, and TimeLink.
Confidential,Richardson, Texas – April 2000 to current
Insurance, Data Warehousing, Business Intelligence, IBM Information Server, Center of Excellence Data Integration, Data Operations,Production Reliability,Technical Training, Peoplesoft, Marketing and Customer Reporting, strategic planning and budgeting, technical and business process expertise.
Cognos, Business Objects & SAS
- Collaborated with IBM and customers to deliver extensive changes to the Cognos environments to increase production reliability and stability
- Stabilized the Cognos environments by streamlining and implementing significant system enhancements
- Reduced the number of in-house supported versions of Cognos from 3 to 1
- Eliminated all Single Points of Failures (SPoF) - unsupported software, out of warranty hardware
- Upgraded and aligned Websphere and Java to the Enterprise for support and efficiencies
- Implemented virtualization of hardware for cost efficiencies
- Implemented eDirectory for Corporate LDAP alignment and enhanced security standardization
- Implemented Capacity Planning strategy
- Enhanced team support structure for training and mentoring staff across all tools
- Implemented operational practices such as Disaster Recovery, enhanced change management, and supported Cognos becoming a critical application to get appropriate level of support from all levels of the organization
- Built out a secondary Cognos 3-tier environment in a month to support a major customer
- Provided metrics and audit reporting on all facets of the Cognos environment
- Partnered with the Cognos Support team to implement best practices and provide a better customer experience
- Implemented MME (Metadata Management Environment) in the Cognos 8.3 DEV and TEST environments.
- Implemented Cognos 10 on virtualized AIX and Windows servers using Websphere 7
- Implemented Motio CI in Cognos 10 for enhanced testing, versioning, recovery, and administration capabilities
- Coordinated and participated in licensing negotiations, contracts, pricing, and working with legal and vendors. Negotiated 46% licensing discount.
- Provided Business Objects 6.5 and XI support for the EHCM business team and related areas.
- Collaborated with MedDecision on IT issues for both Business Objects 6.5 and XI (Alineo) for reporting
- Aligned Business Objects practices with Cognos practices
- Led the consultants who installed and configured SAS Enterprise 9.2
- Partnered with IT areas in a 2 week buildout of SAS server and client components
- Coordinated SAS Training for IT and business areas
- Partnered with the business on best practices and standards for SAS administration and development
CEDI & Information Server Implementation
- Managed and led 14 developers (consultants and FTEs) across multiple-sites for multiple projects concurrently to implement Information Server and develop the ECR dimensional data mart using DataStage and Teradata
- Participated in architecture and design sessions which facilitated the foundational best practices and standards for using the Information Server suite of tools and quality testing strategies
- Partnered with customers and SME’s across the enterprise to ensure a quality deliverable
- Partnered with IBM to install and configure software, complete proofs of technology for each tool, performance tune environment, and build customized best practices for development and administration
- Built, managed, and led the Center of Excellence Data Integration (CEDI) team and program to support the enterprise data integration best practices and administration
- Supported Information Server 7.5 and 8.x versions - DataStage, QualityStage, Metadata Workbench, FastTrack, ProfileStage/Information Analyzer, Information Services Director (ISD), and MDM Server
- Developed the CEDI Charter, Maturity and Staffing Models, Capacity Plan, and Best Practices and Standards and implemented the program resulting in highly available and reliable ETL environments and software for the Enterprise reducing development maintenance issues and increasing time to market for information solutions
- Developed and coordinated training programs for Information Server suite of tools and UNIX throughout the Enterprise. Maximized training dollars by ensuring full classes and building an in-house UNIX training program
- Led the operational practices of the division including change management, production reliability, POG, Problem Management updates, hardware/software licensing, Production on-call, SLA’s, ETL capacity planning, and enterprise initiatives such as STfP (Separating Test from Production) and Disaster Recovery
- Implemented a licensing library to track software licensing
- Matrixed highly-skilled CEDI staff to provide project development for quick wins
- Performed an IT audit on the ODS Project and provided results to management
- Provided performance tuning, mentoring, and 24x7x365 production support for ETL projects
- Provided free training alternatives on CEDI Portal for division-wide needs when training budgets were reduced
- Continuously matured the CEDI organization through automation and self-servicing
- Implemented metadata tracking capabilities for performance tuning, debugging issues, and project metrics
- Partnered with the architecture team to provide input into the Enterprise Technology Roadmap
- Member of the Internal Sourcing Team (IST) to internally consult across mission critical projects (3 years)
- Senior developer providing ETL design, mapping, and development for an enterprise Business Intelligence Data Mart solution for Enterprise Client Reporting using dimensional modeling techniques
- Impact analysis and risk assessments completed on source systems for data mart solution
- Provided backup leadership to Data Mart lead
- Senior developer for the remediation of 3 mainframe systems (COBOL/CICS/SAS) to a data mart solution with Cognos reporting on the Internet/Intranet for Marketing customers for Client Reporting
- Report development utilizing Cognos Impromptu and PowerPrompts
- Data Modeling Team Member
- Analyzed, developed, and supported 13 Marketing and Customer Reporting systems
- Team Lead/Developer for the remediation of mainframe systems and mentored backup SME
- Coordinated all SDLC phases for key business projects
- Implemented cycle efficiency enhancements, parallel processing, and standardization to reduce production support, ensure data integrity, and provided high-quality, timely reporting. Data availability reduced from 1 day to 10 minutes
- Partnered with customers across business and IT divisions to deliver quality, on-time projects
- Provided project management by maintaining the project plan, coordinating PMO meetings, maintaining the monthly Production Time Line and developing and tracking the Quarterly Reports status
- Assisted with the Demand Management and production support coordination
- Conducted research on SPI, PHI, and HIPAA initiatives and was co-facilitator for interactive training to support and mentor others on HCSC’s standard processes and procedures and government regulations
- Project Lead/Developer for the PUM (Provider Utilization Mgmt) Conversion Project
- Project Lead/Developer for the OS/390 Conversion Project (COBOL/CICS systems)
- Technical support and upgrades for Peoplesoft Financials and Budgets Explorer
Confidential,San Angelo, Texas – March 1993 to October 1999
Finance, Payroll, HR, and Manufacturing technical and business process expertise.
- Project Leader/Lead Developer for the Wage Payroll Improvement Project
- Project Leader/Analyst for a multi-Site, multi-language distributed application utilizing kiosks. Managed consultants and project results. Multi-million dollar ROI achieved within 1 year
- Developed strong technical design and programming skills in COBOL, CICS, RPG, FOCUS, and Natural
- Managed concurrent projects, production support, training, consultants, and business partnerships
- Developed manuals and training materials for Manufacturing, Payroll, Finance, and HR departments
- Partnered and built strong business relationships throughout the Enterprise to provide IT solutions proactively
- Supervised internal/external consultants throughout project life cycle for manufacturing and business projects
- Developed Request For Proposal (RFP) for IT projects including cost/benefit/risk analysis and business impact
- Proposed, reviewed, and coordinated vendor service and maintenance agreements with legal department
- Participated in budget reviews for projects and department
- Remediated local applications to Enterprise distributed applications utilizing Powerbuilder, C++, and Oracle
- Aligned production systems for Y2K and participated in change control board
- IT Project Lead for the development of a sterilization system required based on FDA audit findings
- HR and Management IT liaison for Union Contract negotiations to proactively support Payroll requirements
- Organized and completed conversion efforts in streamlining technical systems support
- Coordinated job scheduling of local and Enterprise applications
- Developed front-end application using dBase IV and gained Oracle experience
- IT Lead for the Wage (Union) Payroll system
- Supported manufacturing systems on IBM MVS mainframe - COBOL, CICS, RPG, and Natural.
EDUCATION
Confidential,University (San Angelo, Texas)
B.B.A. in Computer Science (major) – May 1994
Psychology (minor)
Certified IBM Cognos BI 8Administrator & Technical Specialist
Certified IBM InfoSphere DataStage & QualityStage 7.5 and 8.0
Member of Toastmasters International—Communication and Leadership organization
- ATM-Bronze and Competent Leader Certification
- Member and Leader in two TI organizations simultaneously
- Area Governor (1 yr), President (1 yr), VP of Education (4 yrs), VP of PR (2 yrs), Secretary (1 yr)
FDA, OSHA, ISO9001 federal regulations for the medical manufacturing environment.
GMP (Good Manufacturing Practices) Training
DataStage Essentials, Advanced and Administration training
SOA, eBusiness, and Object Oriented Programming and Methodologies (OOP/OOM)
Corporate Compliance (manufacturing and health insurance), HIPAA, SPI, and PHI training
