SUMMARY:

• Proficient in utilizing mixed data sources to create comprehensive data analysis and graphic representations.
• Expert level with MS Access including VB scripting.
• Expert level with MS Excel including vlookup, pivot tables & graphs
• Highly proficient with all versions of Microsoft Office Suite including Word, Excel, Access, PowerPoint, Project, Visio, Outlook and some Sharepoint integration.
• Project management, detailed analysis and design of environment, costing, workflow, system programming specifications, documentation design and end user training.
• Large database manipulation, migration and integration utilizing MS - SQL, Lotus Notes. and others customized with Visual Basic or Crystal reports, Business Objects

EXPERIENCE:

Confidential, Westlake, TX

Regulatory Compliance Data Analyst

Responsibilities:

• Create and maintain regulatory compliance reports utilizing MS Access and Excel.
• Retrieve and analyze data from multiple database sources to determine compliance with Confidential, Confidential and other regulatory agencies.
• Produce graphical analysis and PowerPoint presentations for director level management to be utilized as legal documentation of compliance.
• Review cell site documentation and verify key compliance indicators.
• Utilized advanced Excel Functionality including vlookup, pivot tables & graphic analysis.

Confidential

Litigation Support Specialist

Responsibilities:

• Develop Excel spreadsheets for data distribution and to verify all project progress.
• Utilized Excel formulas to derive project timing projections.
• Utilized pivot tables to provide project summaries.
• Provided Litigation and discovery support services.
• Utilized CSG Ultimate Mailbox and Paraben to perform mass conversion of legacy Novell Groupwise to Microsoft PST and EML format.
• Prepared large file conversion for discovery in Symantec Clearwell software.
• Port all EML data into SQL database for litigation services support.
• Develop internal database queries to test data integrity.

Confidential, Farmers Branch, TX

Regulatory Compliance Auditor

Responsibilities:

• Review and analyze cellphone tower construction and operating specifications to assure Confidential regulatory compliance.
• Utilized Excel to provide management summaries.
• Configured and installed desktop software and encryption assuring HIPPA compliance for 1,000 seat pharmacist call center.
• Transferred user profiles and assured software functionality.
• Utilized Remedy asset and incident management system to maintain support documentation and assure SLA.
• Provided Active directory support for users.
• Troubleshooting for 15,000 users.
• Utilized Altiris to deploy Windows XP and Windows 7 computers.
• Utilized HEAT ticketing system to maintain troubleshooting database and assure SLA.
• Provided all levels of service to healthcare professionals who utilized Citrix application servers, Lotus Notes databases/libraries and extensive MS Exchange services across multiple platforms. Supported multiple versions of MS Office Suite.
• Assured HIPAA compliance through encryption deployment. Provided Windows 7 user orientation and training.

Confidential, Dallas, TX

Consultant

Responsibilities:

• Plan and implement mobile platform hardware and software to assure regulatory compliance.
• Create technical and user documentation, training documentation and performed class room training.
• Create and implement EH&S self-audit process.
• Capture data from various sources and create status report system.
• Instrumental in redesign of Compliance Data Management System (CDMS).
• Performed data backups and data distribution.
• One on one training and support as necessary.

Confidential, Carrolton, TX

Project manager

Responsibilities:

• Design, document, test environmental management database which included document imaging interface.
• Design and implement data migration from existing access database structure to SQL server database. Perform and provide report structure for data integrity testing.
• Design detailed reports in Business Objects. Design user and training documentation.
• Contracted as a break-fix and desktop rollout technician for IBM servicing Confidential.
• Performed interactive end-user desk-side troubleshooting and repair of software and hardware for desktop and mobile workstations computers for 20,000 end users in north Texas.
• Responsible for replacing lease computers with new equipment in a Microsoft Active Director Services environment.
• Configuration of all desktop software.
• Migration of user data and e-mail archives. Setup of Cisco VPN connectivity software.