Software Engineer / Development Team Lead / Integration Specialist Resume
SUMMARY:
Multi - certified technology professional with experience in administration and development of Microsoft SQL Server 7.0/2000/2005/2008/2012 , Progress, MySQL, Sybase and Oracle databases.Strong background in data modeling, T-SQL, ETL, EDI integration/development, programming and database design. Experience with data warehouse design, implementation, maintenance and user support. 21 years client/server development with various tools.Seeking opportunities that promote growth, learning advancement, and a good working environment.
EXPERTISE HIGHLIGHTS:
Data warehousing
ETL with SSIS/DTS/SSRS
Data/Business/Systems Analysis
Data Flow & Process Mapping
C#/VB.NET Programming
Database Design & Management
Major Software/Systems Implementations
Agile Development
Testing/Scripting/Documentation
Technical Writing (Manuals/System Specs)
TECHNOLOGY SUMMARY:
Applications: Microsoft SQL Enterprise Manager, Microsoft SQL Query Analyzer, Microsoft Project,, Microsoft Visio, pcAnywhere, Macromedia Dreamweaver, Microsoft FrontPage, Microsoft Office, Microsoft .NET 2003/2005/2008/2015 , Microsoft Expression Studio, Lotus Notes, Macola, Microsoft Dynamics
Systems: Windows, Linux
Languages: C#.NET, VB.NET, SQL, PL/SQL, HTML, PHP, JavaScript, Progress, CSS, VB6
PROFESSIONAL EXPERIENCE:
Confidential
Software Engineer / Development Team Lead / Integration Specialist
Responsibilities:
- Built external components in .NET to perform file transfers, integrations, and functionality not available in the system.
- Design, Develop, and Debug Core code of our enterprise product.
- Successfully converted legacy code to HTML5
- Added many new features to the software
- Many integrations involving SSIS, .NET, and SQL.
Confidential
Senior Programmer / Analyst/ IT Director
Responsibilities:
- Design and oversee all development efforts pertaining to ERP implementation.
- Includes process analysis, integrations with existing systems, custom UI design and implementation, reporting, and new data warehouse design and implementation.
- Mentor junior developers.
- Developed a new system for production demand reporting
- Designed and implemented a new data warehouse with SSAS from the ground up using SSRS for reporting.
- Developed 98% of all integrations with a new ERP system.
- Designed and coded custom UI screens for the new ERP system.
Confidential
Senior Software Integration Engineer
Responsibilities:
- Installed, configured, and built integrations for their newborn screening applications.
- Supported the prenatal screening program for Canada and Mexico.
- Developed custom applications to support new products coming from research and development.
- Lead engineer for the prenatal newborn screening program in Canada and Mexico
- Determined specifications and developed a custom file conversion applications that provided a way to increase sales of $2,000,000 in European markets
- Mentored various junior engineers and helped enhance their SQL Server and C# skills
- Designed and developed various code libraries to help standardize installations across all customers
Confidential
Owner/President
Responsibilities:
- Software development/consulting.
- Work with a company called Maintenance Connection as their Integration Specialist.
- Custom web site/ client server application development, Database administration and ERP integration
- Commercial Soybean Breeding web site
- Behavioral Health Professionals web site with web service integration and credit card processing
- Maintenance Connection -Integration Specialist
- DuPont client server applications
Confidential, NAVARRE, OH
Application Development Team Lead
Responsibilities:
- Manage application development projects, collect and analyze business requirements from users, Code solutions in VB/C#.NET, MSSQL 2005, and Oracle. Provide full support for a data warehouse consisting of 7 cubes.Schedule the developer resources for completing requests, quality check developer code.
- Meet with the business on a regular basis to assess needs and priorities.
- Led new data mart development efforts and migration to SQL2005
- Developed and supported integrations efforts between Oracle and SQL2005 via SSIS packages and stored procedures
- Implemented new quality improvement standards for SQL development as well as applications in C#
- Designed and built new web applications in .Net 2005/SQL 2005 to support production.
- Managed the Application Development Team by assigning work, tracking process, and code quality assurance testing.
- Database Administration for 4 SQL servers.Designed and deployed maintenance/backup plans for critical and non-critical databases.
- Automated previously manual, time-consuming processes to drive gains in data tracking/accuracy, workgroup efficiency and profitability.
- Data analysis with cubes, excel, and presentation with SSRS.
- Configure and Maintain transaction replication between multiple production databases
- Manage EDI communications and develop solutions to handle integration with the ERP
Confidential, CANTON, OH
Database Administrator
Responsibilities:
- Maintain/optimize 5 SQL Servers.
- Develop stored procedures, functions, triggers, and CLR user- defined functions.
- Develop all SSIS jobs for transferring data from a Progress 91D database.
- Develop and maintain a data warehouse.
- Build SSAS projects.
- Prepare data requests for Crystal Reports.
- Design and compose project charters and technical specifications.
- Code client server applications, web services, and ASP.Net web sites in VB/C#.NET.
- Troubleshoot and debug software.
- Maintain and update software written to run machines via PLC.
- Key player in large data migration effort from a progress database to SQL Server 2005 and a $600,000 ERP implementation
- Converted MS Access programs written in German to SQL Server for a more stable environment.
- Developed better data entry and integration systems using SQL Server 2005 and C#.NET
Confidential, Wooster, OH
Web Developer
Responsibilities:
- Analyze project requirements.
- Design and develop web applications and client server software with .NET 2003/2005, PHP, JavaScript, Microsoft SQL 2000/2005, Integrated Services, MySQL, and Sybase.
- Train users, and maintain existing code and databases.
- Build and maintain IIS and Linux/Apache web servers.
- Coordinate the implementation of new applications, and major development
- Redesigned and migrated DTS packages to SSIS
- Built a complete corporate intranet.
- Built an event registration application to replace a third party application and eliminated maintenance fees providing a cost savings of approximately $4,000 per event.