Database/software/solution Development Resume
2.00/5 (Submit Your Rating)
PROFESSIONAL EXPERIENCE
Database/Software/Solution Development
Confidential
Responsibilities:
- Developer on an MVC 3.0 site/application (converted from ASP.NET) to track and manage meter reads (water, gas, electric). Source code was written using C# with Structure Map and Fluent NHibernate. This was a large scale application needing to handle 200+ billion read records for reporting and billing purposes. This project was managed using Agile.
- Developed a C# application to load data extracts from a cloud system into local Sql Server 2008 databases for reporting and warehousing.
- Designed and modified Sql Server Analysis Services 2008 data warehouses for reporting using SSIS 2005.
- Developed an ASP.NET application using Visual Basic .NET 2010 for moving product image files to customer FTP sites.
- Developed reporting using SSRS against existing Sql Server 2008 databases and Sql Server Analysis Services 2005 data warehouses.
- Provided support (bug fixes and modifications) for existing Visual Basic .NET and C# (2003 to 2008) applications.
- Developed pages in SharePoint Services 2005
- Development/support of various data warehouses for reporting using crystal reports and web front - ends. Back-ends included various sources, Sql Server 2000/2005, Oracle, FACS (MUMPS collection system), MAS90 Financials.
- Crystal Enterprise (9,10,11) used extensively for report scheduling and distribution against various data sources. Some administration of the system.
- Development of systems/databases to reconcile data between internal and clients systems.
- ETL into existing systems and for conversions into other systems using various tools (Sql Server 2000, VS.NET C#, VB.NET, VB 6, Data Junction, MS Sql Server DTS)
- Development of reports/ETL using Sql Server DTS, crystal reports
- Design, development and support of web based collection systems using ASP with MS Sql Server and Oracle back-ends.
- Design, development, and support of quality control and order management/shipping systems (EDI functional) using C# and MS Sql Server back-ends.
Business Analysis
Confidential
Responsibilities:
- Worked closely with various levels of management on defining requirements for databases and reports, and applications.
- Analyzed existing systems and processes to help in architecting improved and new processes.
- Supported various systems and process for various levels of management and operations.
Project Management
Confidential
Responsibilities:
- Agile based project work.
- Project management of small projects and solutions.
- Tracking requirements and tasks in large multi phased projects.
- Conversions between business systems (Collection Systems)
- Process improvement projects (data reconciliation, Q.A, Order management)
- ERP Requirements Gathering (Manufacturing)
TECHNICAL SKILLS
- Microsoft Sql Server 2000/2005/2008/2010 (T-SQL/DTS/SSIS/SSRS)
- Visual Studio .NET 2003/2005/2008/2010 (VB.NET, C#)
- Visual Basic 6.0, VBA, VBScript
- Visual Studio ASP.NET 2010, MVC 3.0
- Web Development
- HTML, XML, ASP, VBScript, JavaScript
- Database programming using ADO/RDO/ASP.NET
- Crystal Reports version 4.0 to 11.0
- Microsoft Excel/Access
- Fluent Structure Map and NHibernate
- TFS Source Control, Subversion
- Unit testing with MSTest and TFS