SUMMARY:

IT Professional with over 7 years broad of experience including almost 5 years of Cognos, optimizing and supporting new and existing complex reports to support business reporting functions.

TECHNICAL SKILLS:

Languages: C++, VB.Net, Visual C++, SQL, HTML, PHP

Systems: Windows XP/Vista/Windows 7, Linux, UNIX, and DOS

Database: SAP BASIS, SQL Server 2008, 2000, MS Access

Software: Cognos Impromtu 7.3, Cognos 8.0, SAP ECC 6.0, SAP Solution Manager 4.0, Deltek/Costpoint ERP, MS Office (Word, Excel, Access, Power Point, FrontPage)

PROFESSIONAL EXPERIENCE:

Confidential, Huntsville, AL

Cognos Report Developer/SQL DBA

Responsibilities:

• Creating List, sub, cross - tab, and drill-thru reports using Impromptu 8.4.1 and setting up portals to users for Ad-Hoc reporting, analyzing and validating the integrity of the data based on end user needs.
• Setup Cognos 8 security for access, portals and data. Limited users on role level access.
• Creating, maintaining, optimizing and supporting new and existing complex reports to support business reporting functions
• Responsible for ensuring availability and performance of all Confidential databases.
• Worked to ensure that the associated hardware resources allocated to the databases are highly resilience and performed performance tuning as required.
• To proactively monitored the database systems to ensured secured services with minimum downtime.
• Responsible for providing trend analysis to the Confidential management team to enable them to make informed decisions regarding resource management.
• Developed various T-SQL stored procedures/functions for the Application.
• Responsible for improvement and maintenance of the databases to include rollout and upgrades.

Confidential

Information Technology Support

Responsibilities:

• Provided Level I/II support for Confidential TF-11 with both network and voice communication.
• Ensure technical safeguards are maintained to provide controlled user access, integrity of electronic applications and user data.
• Supervised software updating and patch installation, to counter, control, contain and eliminate virus infestations and software vulnerabilities.
• Provide assistance in the administrative of the TAMP SharePoint site, and TAMP servers to ensure both availability and usability.
• Accurately documented all issues and resolutions in SharePoint for tracking and recordkeeping.
• Inputs remedy ticket in Remedy Tracker for 54th signal to troubleshoot.

Confidential

Confidential Contractor

Responsibilities:

• Creating List, sub, cross-tab, and drill-thru reports using Impromptu 7.x and distributing Catalog to users for Ad-Hoc reporting, analyzing and validating the integrity of the data based on end user needs.
• Creating, maintaining, optimizing and supporting new and existing complex reports to support business reporting functions
• Interacting with technical teams and end users as needed for better defining, understanding and establishing reporting requirements.
• Generating and responding to data requests for surveys/statistics to department heads, auditors and directorates to satisfy EEO reporting requirements
• Collecting, analyzing and reporting data in order to make recommendations to managers and other functional units regarding business reporting capabilities
• Performing daily Cognos queries and report writing for business reporting purposes
• Monitoring and performing system audits, reports findings; Modifying HR systems internal tables; Managing and Maintaining Position Control assignments, Catalog of HRIS Reports; Coordinating Mass-Update features Acquisitions, Position Management, and Divestitures.
• Coordinating Mass-Update features Acquisitions by collaborating with supervisors and technical staff to understanding developing functional requirements, documentation, test case scenarios, and implementation for system enhancements and educate new user on new system module(s).
• Managing and maintaining the monitoring of data entry and maintenance by HR Representatives to ensure system data integrity.
• Performing system audits and reporting findings on an ongoing basis to ensure data integrity & accuracy
• Ensuring HRIS needs is effectively addressed by researching issues or problems reported by functional users. Providing training to staff to support and assist in the definition or resolution for application-specific issues.
• Monitoring HRIS system and all interfaces with IT technical and end-user staff to identify, analyze and trouble-shoot HR system errors and functionality issues.
• Systematically identify and define problems, evaluate alternatives and implement effective solutions.
• Training technical and non-technical users on the use of Impromptu tools.
• Using Cognos for creating and modifying reports to help with auditing.
• Primary POC for Export Control and ITAR/EAR

Confidential, Nashville, TN

Research Analyst

Responsibilities:

• Researched problems with electronic medical, dental, and government claims submitted through Confidential that rejected and contacted clients with resolutions to the issue.
• Tracked missing claims, resolved issues concerning formatting problem with NSF, MCDS, HCDS, and ANSI.
• Mapped claim records and explained to clients how to fix claim rejections.
• Explained HCFA and UB-92 forms to clients and what information needed to go where.

Confidential, Clarksville, TN

Manager / Information and Technology

Responsibilities:

• Developed several Excel spreadsheet macros currently in use for reducing entry time and automatically cross-referencing customer information.
• Implemented and trained staff with hotel software.
• Responsible for processing of monthly statements and balance inquiries.
• Balanced front desk transactions, recorded all hotel transactions.
• Created formal system for employee file documentation.
• Paid bills, deposited receipts, and produced payroll
• Implemented continuous Internet update system for room reservations.
• Provided customer service and overall satisfaction.

Confidential, Clarksville, TN

Computer Science Lab Assistant

Responsibilities:

• Maintained Lab Network and retained database using Access and SQL.
• Assisted new computer science students for understanding their assignments.
• Upgraded and maintained software and hardware in computer lab and performed trouble shooting on student’s accounts when problems arose.