Technical Summary

Operating Systems: Windows 3.1, Windows 2003, Windows NT, Windows 95 98, Windows XP, Windows 2008, MVS, OS2, AS400, UNIX Solaris 8.0, UNIX AIX

Languages: COBOL I II, JCL, SQL, SAS 9.1 Mainframe and PC , MS Access Basic, Visual Basic 6.0, EASYTRIEVE Plus, SAS Screen Control Language, Oracle SQL Plus 8.0, Oracle PL/SQL 9.0

Software: MS Word, MS Excel, MS PowerPoint, MS Access 97, 2000, and 2003 , Lotus 1-2-3, AMIPRO, WordPerfect, FILE-AID, JHS, Panvalet, VSAM, ENDEVOR, TSO/ISPF, SAS Frames, SAS ACCESS, MS Internet Explorer, TCP/IP, File Transfer Protocol FTP , Microsoft Visual Source Safe 6.0, INFORMIX Client, Microsoft Internet Information Server IIS , Oracle SQL Net Client, Netscape Navigator, DataMirror Enterprise Administrator, Microsoft Active Directory LDAP , Netscape Directory Server LDAP , Siteminder V6.0, SunOne IPlanet Web Server, TOAD v9.0, Documentum

BI Tools: Qlikview v11.0 Publisher, Designer/Developer, Server Admin, QMC , Cognos 10.1.1 Framework Manager, Business Insight, Business Insight Advanced, Query Studio, Powerplay Studio, Analysis Studio, Analysis Studio, Report Studio, Event Studio, Drill-Through Definitions, IBM Cognos Administration, Cognos Connection Cognos v8.4 Go Dashboard, Powerplay, Powerplay Transformer, Cognos Viewer, Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Administration, Cognos Connection, Framework Manager COGNOS Impromptu Administrator/User V7.3 COGNOS Powerplay Transformer V7.3 COGNOS Powerplay Client Version V7.3 COGNOS Powerplay Web COGNOS Powerplay Enterprise Server V7.3 COGNOS Impromptu Web Reports V7.0 Cognos Access Manager COGNOS Upfront COGNOS Script COGNOS Scheduler COGNOS Portfolio Decision Stream, Brio, Motio v10.0

Databases: ORACLE 8.0 thru 11g, DB2 most versions , Sybase, INFORMIX, SAS Data Sets, MS Access SQL Server 2000 thru 2008, IBM IMS

Professional Experience

Confidential

Delivery Services

• Serving as a technical leader and subject-matter expert of the Business Intelligence Delivery Services Group responsible for strategic and tactical initiatives related to the implementation of Cognos and Qlikview enterprise reporting, analysis, and dashboard/data visualizations solutions.
• Directly responsible for providing development support and/or guidance on all BI development activities throughout the organization, performing environment administration, applying and changing user security, enforcing SDLC standards, and performing release management tasks between system environments.
• From a strategic perspective, assist in the research and evaluation of new BI technology, participate in enterprise BI architecture meetings, and provide technical project leadership.
• Responsible for supporting all technical activities and deliverables, including technical design, development and unit testing, Application Support Playbook updates, monitoring, operational readiness, implementation task list, resolves warranty defects
• Supports project estimates, forecasts, issues/risks/action item research and mitigation
• Responsible for advising leadership on new emerging trends and innovations throughout the BI industry and developing/fostering a collaborative environment with other organizations utilizing similar technology.

Accomplishments

Successfully lead the enterprise implementation of Qlikview in the development, test, and production environments. Successfully performing in the role of administrator and developer of numerous complex models, reports, and dashboards using the full suite of Cognos 10.1.1 products i.e. Framework Manager, Cognos Connection, Report Studio, Query Studio, Business Insight, Business Insight Advanced, Event Studio, Powerplay Transformer, Powerplay Studio against DB2, Oracle, and SQL Server relational database sources in Windows XP and Unix environments. Successfully lead in the troubleshooting of problems related to functionality, usability, and performance of Cognos solutions. Consistently received favorable performance reviews for providing excellent leadership and customer service.

Confidential

Lead Business Intelligence Developer Contract

Responsible for Cognos v8.4 development and technical leadership in support of Time Warner Cable's campaign management reporting projects.

Accomplishments

Successfully designed, developed, and deployed Cognos metadata and reports using Cognos v8.4 Framework Manager and Report Studio against an Oracle 10g/Netezza reporting database in a Windows XP environment. Coordinated and managed the requirements gathering and development life-cycle which resulted in the successful delivery of all reports in about 4 weeks in advance of the project deadline.

Confidential

Lead Business Intelligence Architect/Developer Contract

• Responsible for providing process and technical leadership on Cognos v8.4/8.3 architecture, administration, support, and development initiatives for various State Medicaid Fraud and Abuse Detection reporting systems using an Oracle 10g backend database in Windows XP and 2003 OS environments.
• Served as the subject-matter expert on matters relating to Cognos development, technical support, and query database performance issues.
• Responsible for supporting quality assurance through the tracking and closing of design defects, enforcing and maintaining the integrity of the development and test processes, and ensuring a high-level of quality in all deliverables.

Accomplishments

While serving in a development technical lead role, successfully developed and enhanced numerous relational/DMR Framework Manager Models, Report Studio reports, and Query Studio queries/reports. While serving in a production support role, provided technical leadership in the troubleshooting of database query and application performance issues.

Confidential

Sr., Business Intelligence Developer

• Performed as a Sr., Business Intelligence Developer responsible for architecting metadata against SQL Server, Oracle, and DB2 AS400 operational databases using Cognos v8.4 Framework Manager developing reporting solutions using Cognos v8.4 Report Studio, Query Studio, and Analysis Studio applying security in the Cognos Connection Portal and setting up deployment packages on Windows OS platforms.
• Responsible for the creation and publishing of development standards and technical specification documentation to be shared and used within the SunGard Business Intelligence Development Team.

Accomplishments

Successfully re-architected Series 7 Impromptu Catalogs to Cognos v8.4 Framework Manager Models and developed advanced Query Studio and Report Studio reports to support demos of SunGard Public Sectors' products and solutions using the Cognos v8.4 Tool Suite. Successfully developed metadata and reporting solutions against a new state-of-the-art client-server application developed by SunGard Public Sector. Successfully completed coursework and participated in projects related to the management and tracking of projects using the SCRUM software development process.

Confidential

Lead Cognos Architect/Developer Contract

• Performed as the Lead Cognos Architect/Developer responsible for the overall architecture and development of Cognos v8.3 reporting, MOLAP, and ROLAP solutions on an Oracle 10g database platform in a Windows XP operating system environment.
• Responsible for providing recommendations on Cognos architecture, development best-practices, and database/query performance improvements.

Accomplishments

Successfully lead the development and implementation of Cognos v8.3Report Studio and Powerplay 7.4 MOLAP reporting solutions. Successfully built Powerplay 7.4 cubes and published to a Cognos v8.3 environment to support analysis and reporting capability of consumer household deposit information. Successfully facilitated requirements definition and technical design sessions with stakeholders to support user drill-up and drill-down analysis and reporting requirements of consumer household deposit data. Provided recommendations and lead technical discussions on the design and upgrade of the existing Series 7.4 and Cognos v8.3 environments to Cognos v8.4.