Application Developer / Database Administrator Resume
Chico, CA
SUMMARY
Versatile, results - driven professional with 10+ years of experience designing software, web applications, and databases Proven ability to manage multiple complex projects while adhering to strict quality standards and customer requirements.
AREA OF EXPERTISE
- SDLC Management
- Statistical & Data Analysis
- Cross-Functional Collaboration
- Reporting & Dashboards
- Requirements Gathering
- Testing & Troubleshooting
- Performance Optimization
- Automation & Integration
- Quality Assurance
- Business Intelligence
- Continuous Improvement
- Cloud-Based Technologies
TECHNICAL SKILLS
Programming: C# • Visual Basic • JavaScript • T-SQL • HTML • CSS • Perl • Python • Java • AJAX • XML
Applications: Visual Studio 6 - 2013 • SQL Server 2000 - 2016 (ETL/SSIS & DTS, SSRS, SSMS) • MySQL • Cognos Crystal Reports MS Office • PCOMM • UNET • Knowlagent • Traverse • NetSuite Flash • Authorware
PROFESSIONAL EXPERIENCE
Confidential
Application Developer / Database Administrator
Responsibilities:
- Developed a custom ERP system (SQL, .Net, MS Access) for a transportation company to manage all aspects of the business including storage, deliveries, accounting (AR/AP). Created complex trending reports for accounting.
- Utilized SuiteTalk web service to integrate NetSuite accounting package and the custom ERP
- Created DTS packages to transfer data from trucking maintenance software and AS400 document imaging system into custom ERP.
- Integrated ERP system with TRAVERSE accounting package.
- Significantly improved both speed and functionality by redesigning a customized wholesale and retail e-Commerce site
Confidential
Application Developer
Responsibilities:
- Created web-based reporting dashboard by working with vendors to incorporate existing data into new systems.
- Designed and implemented a wide range of improvements and enhancements to the company's web applications (C# and Visual Basic) including optimizing code, improving stored procedures and functions in SQL and creating reports with SSRS
- Worked with internal customers to define application requirements for new web applications.
- Leveraged expertise with SQL Server and Reporting Services to design SQL databases and develop associated reports.
Confidential
Sr. Business Analyst
Responsibilities:
- Worked closely with the Eligibility team to develop and launch a customized paper eligibility tracking tool (PETT).
- Developed a custom ETL tool to automate employee assignments to the group hierarchy in Knowlagent from PeopleSoft.
- Created reports in SSRS, COGNOS, and Crystal Reports
- Designed an application for the Contracts department to facilitate the loading of all new USS and Key Accounts business.
- Developed and rolled out a web-based LMS that centralized tracking and integrated training information for 10,000+ employees.
Confidential, Chico, CA
Business Analyst
Responsibilities:
- Improved claim processing time, accuracy, and analyst accountability by developing a windows application to replace PCOMM macro pad.
- Supported HR systems by automating the tracking of local employee records, including time spent away from work.