SUMMARY

Dedicated and highly motivated IT Professional experienced in data analysis, data architecture, data modeling, systems administration, systems analysis, and reporting currently seeking opportunities in the Florida Panhandle.

PROFESSIONAL EXPERIENCE

Confidential

Senior Systems Administrator/Cognos Administrator

Responsibilities:

• Administrator of Cognos BI 10.1.1 Reporting System
• Administrator of Informatica ETL 9.1.0 System
• Maintain network for development and test environments to monthly maintenance and patching for Windows and Solaris servers
• Maintain Cognos and Informatica systems within development, test, staging, and production environments.
• Support government monthly maintenance outages.
• Troubleshoot issues with Informatica ETL workflow processes and repair/correct as needed
• Troubleshoot issues with Windows and Solaris servers within the development and test environment
• Perform daily data checks on Cognos and Informatica systems in production and report overall system readiness to the government
• Work with Cognos developers to analyze, troubleshoot, and correct data modeling issues within Cognos BI using Framework Manager and Oracle 11g database
• Work with Cognos developers and Data architects to analyze government requirements changes to data report and determine how those changes will affect current state of the data architecture
• Perform weekly deployments to Oracle 11g database, Informatica ETL, and Cognos BI per government requirements

Confidential

Senior Cognos Administrator/Programmer

Special Projects/Achievements:

• Completed system upgrade from Cognos BI 8.4 to Cognos BI 10.1.1
• Completed system upgrade from Cognos BI 10.1.1 to Cognos BI 10.2.0

Responsibilities:

• Maintained environments for production and development for Cognos BI and Cognos TM1
• Performed system administration on all Cognos BI and TM1 servers to include monthly patching
• Performed administrative duties on all Cognos BI and TM1 environments to include security of data, user access, and configuration
• Maintained objects in data warehouse used by Cognos BI and TM1
• Created new data objects within the data warehouse for use within Cognos BI and TM1
• Maintained Cognos Framework Manager Projects
• Performed data modeling of dimensions and cubes within Cognos TM1 using Performance Modeler and Architect
• Authored reports for customers using Cognos report studio from both Cognos BI and TM1 data sources

Special Projects/Achievements:

• Data extraction from legacy database systems Costpoint and human resource database and transformation into format for import to PeopleSoft system
• Member of upgrade and test team for new versions of Costpoint Time, Expense, and Self Service
• Conversion of benefits forms and reports from Cognos 7 to Cognos 8

Responsibilities:

• Maintained human resource database and monitored data flow between it and other databases such as Costpoint, Sharepoint, and Training Tracker
• Served as Subject Matter Expert for database connectivity for systems that needed data from the human resource database.
• Responsible of making changes to the human resource database graphical user interface as requirements changed
• Maintained user access to the human resource database
• Partnered with IT database administrator to perform data modeling for reporting against Costpoint and the human resource database using Microsoft SQL Server and Cognos Framework Manager
• Wrote ad hoc queries in Microsoft SQL Server for management's data requests
• Responsible for troubleshooting data issues within the human resource database and its connectivity to other databases
• Performed analysis of human resource data each month and created reports for program managers and executives
• Authored reports in Cognos 7 and Cognos 8 for benefits specialists and management
• Responsible for extracting employee benefits enrollment data, transforming it into specific data formats, and securely transmitting it to benefits vendors such as health care, dental, and vision providers.
• Administrator for Costpoint Employee Self-Service maintaining workflows for benefits enrollments, making changes to screens within the graphic user interface, and assisting benefits staff with tracking employee enrollment status, troubleshooting, and correcting issues

Special Projects/Achievements:

• Member of the implementation team for the Boeing enterprise staffing system.
• Member of the test team for human resource system software upgrades and changes

Responsibilities:

• Managed PeopleSoft data for the site human resource department
• Authored ad hoc reports using Brio software
• Maintained and administered Microsoft Access applicant tracking database to include monthly backups, additions of data, and interfacing with Microsoft Word to create documents
• Performed other human resource duties such as employee counseling, recruiting, salary analysis, employee in-processing, and authoring affirmative action plans

Responsibilities:

• Maintenance of timesheet data from online timekeeping system, and manual entry of timesheet data as needed
• Performed data extraction from off-site electronic timesheet system and imported into online timekeeping system
• Authored labor reports for management using Querywriter software and Cognos 7
• Other accounting and payroll responsibilities

Responsibilities:

• Maintained and administered Microsoft Access database for tracking MSDS data for manufacturing floor
• Maintained Microsoft Access database for tracking serial numbers for manufactured assemblies
• Maintained Microsoft Access database that housed labor hours for contract employees and built labor hour reports for the government
• Authored reports for civil service labor hours using Querywriter
• Performed data imports from flat files into Microsoft Access databases