Database Design/support Specialist Resume
Kinston, NC
SUMMARY:
- An extensive knowledge of software and hardware including database administration, building websites, setting up networks, and securing information on a large scale.
- A highly motivated individual, who possesses strong leadership and successful team building capabilities.
- Excellent technical and communication skills; presentation and customer service skills.
- A Resourceful problem solver with proven ability to bring quick resolution to challenging situations.
- Proven experience leading teams, multitasking.
TECHNICAL SKILLS:
Computer HW & SW: Intensive background in computer building, maintenance and troubleshooting. A+ certificate
Graphic Design: Over 20 years in design experience. Adobe Illustrator, Adobe PageMaker, Adobe Photoshop, Corel Draw, Dreamweaver, Digital Camera/Photography
Programming: COBOL, C++, Python
Database Administration: Oracle 9i, Oracle Recovery Management, Oracle 10g, MS Access, Visual Basics, SQL, MySQL, R Studio, Tableau, Visual Studio, SSRS, SQL Server Business Intelligence Management Studio
Website Development: Linux, Apache Server, HTML, XML, CSS, PHP, ASP, JavaScript, e - Commerce, CRM, Social Media Marketing/Advertising/Administration, SalesForce CRM Platform
Word Processing: Guru Level. Lotus Smart Suite (Approach, 123, Notes), Microsoft (Excel, Office, Outlook, PowerPoint, Visio, Word, Works)
EMPLOYMENT HISTORY:
Confidential, Kinston, NC
Database Design/Support Specialist
Responsibilities:
- Meet with department managers and supervisors to review database issues, complaints, desired changes and user complaints.
- Meet with end users to determine the needs and issues of database “systems”.
- Conduct an analysis of current MS Access and Firebird “systems” to determine whether to repair, update or to convert.
- Debug and reconstruct VBA from multiple previous versions to current VBA, VB and VB.Net versions.
- Migrate and archive data to SQL Server.
- Develop up to date interfaces with Visual Studios (VB.Net), Microsoft SSRS and SQL Server Business Intelligence Management Studio in order to increase performance, scalability and reliability.
Confidential, Raleigh, NC
Instructor
Responsibilities:
- Teach HTML, Python and gaming code to students under 18.
- Help students to achieve their goals and learn to think critically and project ahead while coding projects.
Confidential, Durham, NC
Systems Management Analyst
Responsibilities:
- Database development using PHP and MySQL.
- Project Lead on ASP to PHP migration.
Confidential, Chapel Hill, NC
IT Consultant
Responsibilities:
- Develop databases for various clinical trial projects using MS Access (SQL, visual basics, macros, active data tools, dynamic queries, access pages).
- Worked with staff members to create solutions for data collection issues.
- Maintain a telecommuting schedule.
- Transferred to an Confidential after Temp Agency dissolved.
Confidential, Raleigh, NC
Web Designer/Database Developer
Responsibilities:
- Build websites for individuals and/or various companies.
- Build databases (MS Access) for customer and client services.
- Web-Master/Developer providing 24 hr. maintenance, customer service, and technical support.
- Provided graphic design services (i.e. logos, marketing materials, product labels) for various individuals and/or companies.
- Provided "business sense" help and marketing tools.
- Promoted businesses locally and online (through search engines, classifieds and mail campaigns).
- An independent web developer/graphic designer serviced clients by researching and gathering information on target markets and the most profitable and effective ways to advertise.
- Identified additional needs by helping create materials that have appeal and attract attention.
Confidential, Raleigh, NC
Database Administrator
Responsibilities:
- Developed and maintain departmental databases using MS Access (SQL, visual basics, macros, active data tools, dynamic queries, access pages).
- Supported and redesign existing databases as needed.
- Developed tools that reduce work load.
- Created database system that mimicked a software application for easy user interface.
Confidential, Research Triangle Park, NC
Telecommunications Analyst
Responsibilities:
- Billing Management: including vendor invoices processing and payments.
- Developed and maintain departmental database used form tracking billing and device management using MS Access (SQL, visual basics, macros, queries, dynamic forms).
- Created ad hoc reports from raw vendor data (excel and csv formats).
- Worked with teams to develop database searches and user friendly forms and reports.
- Developed and maintained dispute and reconciliation tracking process.
- Worked alongside upper management to process fiscal year billing data.
Confidential, Research Triangle Park, NC
Technical Quality Support
Responsibilities:
- Provided support for the internal auditing system, consists of report preparation, data entry, and analysis.
- Primary focus on regulatory inspection and internal corporate audit information.
- Created and maintain MS Access database used to track and compile data.
- Prepared monthly internal status reports and related reports.
- Completed monthly compliance audits of the auditing data and issue a report to management.
- Provided information from auditing system that is used to develop Site Risk Assessment Profiles and site
- Knowledge Management Summaries.
- Interfaced with QA department to verify inspection and audit data.
- Entered audit data for agency inspections into the audit system for sites that have limited or no access to system.
- Compiled additional ad-hoc reports as needed.
- Created and maintain protocols, working practices, and SOPs for system processes and activities.
- Prepared Monthly RCRM Status report and all related reports.
- Reports must be reconciled prior to review by the Director.
- Interacted with Global Quality Assurance and Confidential Manufacturing Sites to verify data in system and to identify scheduled, tentative, confined, completed, and cancelled agency inspections and internal audits.
- Completed compliance checks of the system data on a routing basis. Identify areas of non-compliance and work sites to correct the information in system.
- Maintained excellent records of all reports and backup data generated and provided for use.
Confidential, Research Triangle Park, NC
Senior Software Engineer
Responsibilities:
- Researched and maintained data used to build server systems using MS Excel and MS Access.
- Document control and project administration for hardware.
- Maintained Master Product Control List used by US and various countries as blue print to build and assemble servers.
- Ran reports to verify data accuracy across various systems.
- Liaison between two groups to share and consolidate data.
Confidential, Research Triangle Park, NC
Data Migration Specialist/Project Lead
Responsibilities:
- Data Migration for 102 global manufacturing sites for client utilizing a web-based proprietary product (oracle).
- Lead in a team environment.
- Provide risk assessment evaluation for data security for manufacturing sites.
- Seamlessly migrated data pools from one system to another without interrupting the user.
- Evaluate product, develop protocol assessments to test methodology and provide solutions to vendor for upgrades and enhancements.
- Interact with senior level management to provide input/changes for proprietary software.
- Audit accuracy of data and analyze data for errors.
- Run monthly and weekly reports to trend system usage. Provide software expertise and training.
- Manage team in efforts to stay on target and meet deadlines.
- Provide project status reports to Director and oversee team in his absence.