Data Administrator/sql Developer Resume
2.00/5 (Submit Your Rating)
East Lansing, MI
SUMMARY:
- Advanced experience with Structured Query Language using MS SQL Server Management Studio and MS Access
- MS SQL Server 2005 and 2008 R2
- MS SSIS
- Proficiency in MS SSRS (Report Builder and Visual Studio) and Crystal Reports
- Administrative level knowledge and user interface based construction of DNN, SharePoint and MS CRM web pages and forms
- Advanced experience with Microsoft Office Suite to include MS Visio
- Working knowledge of Survey Monkey and My Emma (email marketing tool)
- Working knowledge of project management tools SmartSheet and Trello iMIS Add - Ons: iMerge, Duplicate Manager, Accumail, FastForms, Informz email marketing suite and eTouches
EMPLOYMENT HISTORY:
Confidential, East Lansing, MI
Data Administrator/SQL Developer
Responsibilities:
- Create organization wide reports using SQL and SSRS
- Provide assistance on technical project teams with data preparation, data modeling, user acceptance testing, process documentation and reporting.
- Provide quarterly training to department staff on organization wide software (Access, Excel, KuTools, SSRS and SQL)
- Data Integrity - data maintenance and scheduling
Confidential, Lansing, MI
Database Specialist /Report Writer/Project Manager /Process Analyst
Responsibilities:
- Organization wide systems management and maintenance
- User security management
- System data integrations
- Technical Projects and Software Implementations
- Perform user needs analysis and define user requirements
- Request for Proposal process
- Project Management to include post project summaries and measurements
- Lead cross functional teams during system and software implementations
- User acceptance testing
- User process and system documentation
- User training
- Act as a liaison between consultants/programmers and system users
- Reporting for all data systems
- Data Integrity processes, automation and management
- Assigned troubleshooting and technical tasks from staff helpdesk
- Oversee the data integrity and project programming tasks of two employees
- Responsible for technology budget of $40,000+
- Responsible for project budgets between $5,000 - $100,000+
Confidential, Okemos, MI
Executive and Department Secretary / PPO Analyst /Auditor and Trainer
Responsibilities:
- Worked alongside Compuware (Lochbridge) for two years as department lead to analyze, redefine and document department business processes
- Developed and maintained file tracking system in MS Access
- Assisted in the database construction, user interfaces and user acceptance testing for company website
- Responsible for data preparation for regular system uploads
- Obtained user requirements for system upgrades to the company Oracle database
- Acquired, analyzed and prepared provider disruption, error and omission and fee schedule cost analysis reports for scheduled distribution
- Implemented time management measurements and tracking for productivity