TECHNICAL SKILLS:

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

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.0Software: 2008 Microsoft Office (Word, MS Excel, MS PowerPoint, & MS Access), IBM Lotus iNotes 8.5.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, SQL Developer 3.0.04, Documentum, BMC Remedy IT Service Management

BI Tools: Microsoft 2012 SQL Server SSRS, SSAS, and T-SQL; Qlikview v11.0 (Publisher, Designer/Developer, Server Admin, QMC); Cognos v10.2.1 (Framework Manager, Report Studio, Workspace, Workspace Advanced, Query Studio, Powerplay Transformer, Analysis Studio, Event Studio, Drill-Through Definitions, 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 ReportsV7.0; Cognos Access Manager; Cognos Upfront; Cognos Script; Cognos Scheduler; Cognos Portfolio; Decision Stream, Brio, Motio v10.0

Financial Planning Tools: IBM Cognos TM1 v10.2.0 (TM1 Server, TM1 Admin Server, TM1 Perspectives, TM1 Architect, TM1 Web, TM1 Application Server, TM1 Application Web, Cognos Insight, TM1 Performance Modeler

Databases: ORACLE 8.0 thru 11g, IBM DB2 v10.0, Sybase, Informix, SAS Data Sets, 2013 MS Access; SQL Server 2000 thru 2012, IBM IMS Database

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Sr. Business Intelligence Consultant

Responsibilities:

• Developed numerous complex simple list and crosstab Cognos Report Studio reports and Workspace dashboards against a 2008 SQL Server relational OLTP database source
• Delivered customized report and prompt page solutions using Render and Style Variables, Drill-Through Definitions, Master-Detail Relationships, and Report Studio Query Subject Joins
• Leveraged SQL Server database functions to ensure optimized query performance and report rendering
• Performed unit and functional testing of all deliverables
• Facilitated internal and external client meetings and participated in SCRUM Stand-Up sessions
• Analyzed and translated customer requirements into technical design specifications
• Collaborated with teammates throughout the Agile development life-cycle

Confidential, Orlando, FL

Sr. Business Intelligence

Responsibilities:

• Developed and modified numerous complex Cognos Report Studio reports using a combination of hard-coded SQL, report-joined Query Subjects, and published Framework Manager models
• Facilitated meetings with the customer during the requirements gathering phase
• Gathered and translated requirements into technical design specifications
• Collaborated with teammates throughout the development life-cycle
• Lead user-acceptance testing of all deliverables
• Maintained and supported the execution and troubleshooting of all on-demand and scheduled reports

Confidential, Suitland, MD

Associate - Cognos TM1 and BI Consultant

Responsibilities:

• Developed DMR and Relational FM Models to support the customer’s ad-hoc query, reporting, and analysis requirements
• Updated and maintained Cognos Connection user access permissions
• Participated and supported the monthly budget data loads and reporting cycle
• Collaborated with teammates on the development of Cognos TM1 budget models
• Supported the execution and troubleshooting of on-demand and scheduled Cognos reports

Confidential, Orlando, FL

Sr. Business Intelligence Consultant, Planning and Integration

Responsibilities:

• Developed numerous SSRS reports, SSAS cubes, and Excel PowerPivot spreadsheets to support the Sales, Finance, and Marketing Divisions’ access to actionable information
• Facilitated meetings with the customer during the requirements gathering phase
• Gathered and translated requirements into technical design specifications
• Collaborated with teammates throughout the development life-cycle
• Lead user-acceptance testing of all deliverables
• Successfully reverse-engineered complex SSRS reports to SSAS cubes

Confidential, Orlando, FL

Cognos and Qlikview Technical Lead, Enterprise Business Intelligence Delivery Services

Responsibilities:

• 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, Charlotte, NC

Lead Business Intelligence Developer

Responsibilities:

• 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, Covington, GA

Managing/Lead Business Intelligence Consultant

Responsibilities:

• Delivery of robust relational and multi-dimensional Cognos reporting, analytic, and dashboard solutions against normalized and de-normalized data sources
• Architecture and administration of enterprise-wide Cognos BI environments on Windows and UNIX platforms in single and multi-tiered distributed environments
• Analysis and troubleshooting of query or application performance issues
• Resolving design defects in queries, reports, and cubes
• Tracking, management, and reporting of outstanding production support tickets

Confidential, Norcross, GA

Sr. Data Warehouse/Business Intelligence Consultant

Responsibilities:

• Performed as a senior consulting member responsible for installation, configuration, development, project management, and deployment of COGNOS data warehouse/business intelligence client-server and web-based solutions for assigned clients.