Manager Developer

REBECCA A. JOHNSON

Atlanta, Georgia (Metro)

PROFESSIONAL SUMMARY

Senior BI Developer with sound understanding of SDLC processes, such as Waterfall, Spiral, and Agile Methodologies.

Proficient in developing in Reporting tools, such as IBM Cognos (Framework Manager, Transformer, Report Studio, Query Studio, Analysis, Workspace, Workspace Advance, and TM1) and BusinessObjects (WebIntelligence, Universe Designer and Crystal Reports).

Demonstrated ability to communicate technically within all levels of the organization, including IT and the Business Units.

Effective working closely with Product Managers, Project Managers, Business Analysts, Data Architects, Database Administrators, System Administrators, and QA on various projects throughout the SDLC Process.

Sound understanding of Data Warehouse concepts, such as Relational and Dimensional Data Models, Table Relationships, Joins, Cardinalities Star and Snowflake Data Models, slowly changing dimensions, OLAP, and OLTP.

Understanding of Reporting security features, such as LDAP, Object level, Role based, and Row level or Data security.

Proficient in the installation and configuration of Cognos BI and BusinessObjects Enterprise XI 3.1.

Software Applications: Cognos BI Applications: Installation, Configuration, Administration, Security, Framework Manager, Architect, Report Studio, Query Studio, Event Studio, Analysis Studio, Workspace, Workspace Advance, PowerPlay Client, PowerPlay Transformer, and Cognos SDK; Microsoft Applications: Office (Word, Access, PowerPoint, Excel, 365, SSIS/SSRS/SSAS), Project, Visio, Visual SourceSafe, and SharePoint); BusinessObjects Enterprise XI 3.1 (Crystal Reports, Designer, InfoView, WebIntelligence, and CMC (Security & Administration).

RDBMS: Oracle, SQL Server, Informix, MS Access, DB2.

OS: Windows, Solaris 8/9, RedHat Linux 5.

Software Exposure/Evaluation MicroStrategy, Oracle BI Publisher, IBM Cognos 10 Metric Studio, IBM Cognos 10 Business Insight, IBM Cognos 10.2 TM1, Informatica PowerCenter, Tableau, QlikView, and IBM Cognos Analytics.

PROFESSIONAL EXPERIENCE

Senior BI Developer, RelayHealth, Atlanta, Georgia

February 2015 - March 2016

Documented Technical Design Solution for overall Program area, documented detailed Technical Design Specifications for Reports, documented Unit Test Cases for Reports, documented tracking details of development requests utilizing an open source and customizable issue-tracking web-application known as JTrac.

Performed peer-reviews of Code, technical design and artifacts for other Developers on the Team.

Provided ongoing and daily customer support by fulfilling ad-hoc requests; granting user access to reporting objects, updating Production systems with new Sponsor, Drug and Manufacturer information. .

Conducted peer-reviews for other Developers; consisting of Code Reviews, Report Reviews, Unit Test Cases Reviews, and Technical Documentation Reviews.

Developed Framework Manager Models and Packages within IBM Cognos Framework Manager and developed IBM Cognos Reports and Dashboards using Report Studio, IBM Cognos Workspace and IBM

Cognos Workspace Advance, and created database views utilized by Reporting objects.

Adhered to Company's policies and procedures and completed all required employee training within a timely manner.

Provided IBM Cognos Administration and Security responsibilities as requested by end users, other developers, and QA.

Performed detailed data analysis for determining best approach to designing new queries and determining issues related to existing queries by testing SQL performance and design.

Promoted IBM Cognos objects across the different environments in support of the different phases within the overall SDLC process and provided ongoing support and maintenance of existing reports within the Production environment.

Worked closely with Quality Assurance (AQ); providing support to the Testers and Test Leads during the QA Phase of new or modified code.

Worked closely with Product Managers, Project Managers, Business Analysts, and Data Architects to ensure best design approach for new development; include attending weekly and/or ad-hoc Requirements, Project, and Design meetings.

Completed HLD, LLD and Function Points estimates for Project development.

Documented Requirements Traceability Matrix with Technical Design Solutions doc.

Business Intelligence Developer/Analyst, SunTrust Bank, Atlanta, Georgia

October 2013 - August 2014

Utilized Reporting tools, such as IBM Cognos Framework Manager, IBM Cognos Transformer, IBM Cognos Report Studio and IBM Cognos Analysis Studio to provide development solutions and on-going support solutions to End Users within the Consumer Secured Credit Card Group.

Monitored daily jobs and ensured that jobs are processed completely and accurately and rerun processes as needed if any discrepancies or missing data are discovered.

Developed and/or modified new and existing Microsoft SQL Server 2000 DTS Packages and 2008 SSIS (ETL) Packages to support new business requirements from the Consumer Credit Card Business Users.

Modified existing stored procedures to support changed requirements and developed new stored procedures to support new requirements.

Verified data consistency across multiple systems running on IBM DB2, Oracle and SQL Server Platforms.

Analyzed and ensured the integrity of data used for reporting and analysis within reporting environments, such as Cognos Report Studio and Cognos Analysis Studio.

Wrote complex SQL against DB2, Oracle and SQL Server to compare data across the multiple platforms.

Ensured that monthly processes were completed on time and in agreement with the SLA's and ensured that monthly data was accurate and presented to the users as expected.

Performed database integration, migrating objects and data from DB2 to SQL Server 2000 & 2008.

Data manipulation language (DML), creating views, tables, updating data or inserting data into new tables.

Developer, AT&T, Atlanta, Georgia

November 2010 – October 2013

Provided 24x7 application support for all Cognos environments, including development, system test, field support, system integration testing, disaster recovery, and production.

Provided end-user support ensuring accounts are created for users and the correct security is applied to user accounts for both Cognos and BusinessObjects reporting environments.

Performed metadata migration of Cognos models to BusinessObjects universes.

Performed migration of Cognos reports to BusinessObjects reports environment.

Provide IBM Cognos user access and LDAP access as requested.

Attend weekly scheduled Team and Project meetings.

Work with QA Testers to ensure that Reports are tested for accuracy prior to delivery to Production.

Assisted end-users with creating complex queries and reports with Cognos and BusinessObjects.

Senior Lead Cognos Developer, RelayHealth, Atlanta, Georgia

August 2010 – March 2011

Developed reports using Cognos 8.2 Report Studio.

Documented the design of reports and document test cases used for unit testing of the reports.

Assisted Junior Developers with the design and development of Cognos Report Studio reports.

Worked with Java Script and HTML interfacing Cognos Reports for flexible prompting capabilities.

Performed peer reviews of development work completed by other developers on the Team.

Attended and participated in various meetings to discuss reporting requirements.

Transformed requirements document into technical design documents for reporting.

Provided assigned leadership responsibilities on various reporting projects for the Team.

Worked closely with System Administrators and Database Developers to ensure that all of the necessary requirements are met in order to install and configure Cognos 8.4.1 within a RHEL environment.

Maintained and supported user access to Cognos using OpenLDAP as the Authentication Source

Served as the Primary Contact between IBM Cognos and RelayHealth and collaborate with the Vendor on open issues related to installation, configuration and development within the Cognos BI environment.

Evaluated Cognos 10.1 Administration, Configuration, Security, and Development function for potential upgrade from Cognos 8.2.

BI Developer, AT&T, Atlanta, GA

April 2001 – July 2010

Installed, configured, maintained, and supported the IBM Cognos Business Intelligence Reporting Application within on a UNIX Platform running on a multi-server distributed environment with hardware load balancing and failover support.

Administered and implemented Authentication and Security for IBM Cognos Business Intelligence Reporting Application using Cognos 8.x, Cognos SDK, JavaScript, and HTML.

Provided 24x7 Application Support for all Cognos environments, including Development, System Test, Field Support, System Integration Testing, Disaster Recovery, and Production.

Provided End User Support for accessing, running reports within the Cognos Connection Portal.

Designed and developed Framework Metadata Models, Impromptu Catalogs, PowerPlay Transformation Models, Impromptu Reports, ReportNet Reports, Cognos BI 8.x Reports, PowerPlay Cubes & Reports, PowerPrompts Applications, BusinessObjects XI 3.1 Universes, SAP BusinessObjects XI 83.1 Web Intelligence Reports.

Implemented and maintained User and Group Security within BusinessObjects Central Management Console (CMC).

Performed Ad-hoc querying for internal Users and automated file output processing to Network for use the Network Management System Team and Engineers.

Configured and implemented Auditing Activity for the Cognos Series 7 and Cognos 8.x BI Environments.

Performed migration of Cognos IWR to Cognos ReportNet, including the migration of User Accounts, Catalogs Models, Reports, PowerPlay Cubes.

Configured, administered, and managed Series 7 Cognos Access Manager Centralized Security System for accessing and running Reports within the Cognos Environment.

Performing data analysis by writing complex SQL queries to obtain desired results of reports and cubes as specified in the requirements.

Created database objects, such as tables, views and procedures to support the design of Reports and Cubes.

Worked closely with Database Administrators, System Administrators, Database Developers, System Engineers, System Testers, and Project Managers daily in delivering Reports and Cubes to Business and End Users based on Requirements and Specification within a timely manner to provide a quality product to the Users.

Created Design Documentation for all Business Intelligence development.

Utilized Configuration Management Tools and Change Control Tools to keep track of Customer Requests, Defects, and Enhancements related to Project work and overall Business Intelligence Development.

Maintained and updated a Portal Page used and the Entry Point for Accessing the Reporting Infrastructure.

Performed extensive data analysis to determine performance issues and data accuracy for Reports and PowerPlay Cubes.

Worked closely with SiteMinder Administration on implementing a SSO Solution by installing SiteMinder Plug-ins and configuring Sun One Web Server and Cognos to communicate with SiteMinder and Sun One LDAP for SSO and Authentication.

Worked closely with System Administrators in configuring the Sun One Java System Web Server and Cognos 8 to perform hardware load balancing using Weighted Round Robin balancing mechanism.

Created internal Service Requests for all Business Intelligence needs, including Firewall Request, Exceptions, and Security Risks Assessments.

Performed frequent Java Updates to run with Cognos 8 Reporting Application as requested by Internal Security Operations Group.

Viewed various packages, stored procedures, and functions to understand the code blocks used to extract and transform data that were being stored for reporting and analysis.

SYSTEMS & DEVELOPMENT TOOLS PROFICIENCY

Languages:

JavaScript, HTML, XML, Visual Basics, PL/SQL, Microsoft DTS, Microsoft SSIS.

RDBMS:

Oracle 9i, Oracle 10g, Oracle 11g, Microsoft SQL Server (2000/2008), Informix,

Microsoft Access, and IBM DB2.

Operating Systems:

Microsoft Windows 2000, XP, Ultimate 7, 2003 Server; Sun Solaris 8 and 9

(UNIX), and RedHat Linux 5.

Development Resource

Tools:

IBM Rational DOORS, SQL Navigator, SQL Developer, FTP/SFTP, ReflectionX,

XMing SecureCRT, PUTTY, Toad DataPoints, Toad for Oracle, IBM Data

Studio, Microsoft Office Suites, Microsoft Project, Microsoft Visio, Microsoft

Visual SourceSafe, SQLPlus, SQL Developer, SQL Navigator, NetBeans 5.5

IDE, Eclipse, Open Source JTrac, Microsoft SharePoint.

Hands-on Training & Professional Development:

BusinessObjects Enterprise XI 3.1 Administration and Security, Business

Objects Enterprise XI 3.1 Crystal Reports, BusinessObjects Enterprise XI3.1

Web Intelligence, IBM Cognos v10.2 Transformer, IBM Cognos v10.2

Dynamic Cube Design, IBM Cognos v10.2 Active Reports, Cognos TM1 10.2.

EDUCATION

Master of Science, Computer Information Systems (CIS), University of Phoenix Arizona, 10/2006

Bachelor of Business Administration, CIS, Georgia State University, 07/1995

Associate of Science, CIS, Brunswick College, 06/1992

Contact this candidate