Sr. Database Application Developer Resume
3.00/5 (Submit Your Rating)
Atlanta, GA
SUMMARY:
- Extensive hands - on leadership experience with teh analysis, design, development, implementation, and support of numerous mission critical database applications.
- Designed, developed, and administered several mission critical SQL Server database systems.
- Consulted directly with business users to jointly determine their needs and develop successful solutions.
- Designed, developed, and implemented numerous web and client-server solutions.
- Led several mission critical projects from initial vision through implementation.
TECHNICAL SKILLS:
Database/Software/language/Tools: SQL Server 2000/2005/2008, T-SQL, SSIS, DTS, ETL, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ASP.Net, C#, .Net Framework, Crystal Reports, Tableau, Web Services, IIS, Visual Basic, VB.Net, ASP, Delphi, HTML, XML, JavaScript, VBScript, C++, Pascal, VISIO, Excel, Word, MS Confidential, Visual Source Safe, Oracle, PL/SQL, MS Access, COM+, SOAP, OOD, SOA
PROFESSIONAL EXPERIENCE:
Confidential - Atlanta, GA
Sr. Database Application Developer
Responsibilities:
- Designed, developed, and implemented a sales and budgeting data warehouse.
- Developed SSIS packages to process teh daily dimension and fact loads for teh data warehouse
- Converted teh internal accounting system databases from SQL 2000 to SQL 2005 and managed teh process of deploying teh upgraded application.
- Upgraded teh accounting system's supporting DTS packages to SSIS.
- Designed, and developed a data synchronization process between SalesForce and teh company's existing CRM system. Utilized SSIS packages to keep teh two systems consistent.
- Enhanced and maintained several enterprise-wide SQL Server applications
- Upgraded SSAS 2000 cubes to SSAS 2008
- Developed and enhanced reports using Tableau and Crystal Reports
- Extensive development of tables, views, stored procedures, and functions as needed.
- Collaborated with other developers in teh development and maintenance of internal and third-party systems.
Confidential - Atlanta, GA
SQL Consultant
Responsibilities:
- Responsible for teh maintenance and enhancement of SQL Server applications
- Developed and enhanced reports using Crystal Reports
IT Programming Manager
Confidential
Responsibilities:
- In response to a class action lawsuit, developed a data management and reporting process that successfully satisfied teh court's access to teh updated and merged information.
- Implemented SQL Server Reporting Services for teh division. Developed reports, administered security, and supported teh use of Report Builder by teh end-users.
- Designed, developed, and implemented a web service which reduced teh average insurance application turn-around time from 2.5 weeks to less than 1 day. This process was developed using C#, ASP.Net, and SQL Server.
- Developed and maintained an extract, transform, and load (ETL) process which kept over 3 million rows of SQL Server data in sync with its mainframe data source. This process was developed using SSIS.
- Developed and maintained dozens of extract, transform, and load (ETL) processes for data uploads and downloads. Used both DTS and SSIS.
- Administered over 25 SQL Server Databases maintaining security, query optimization, change control, and problem resolution.
- Upgraded all SQL Server databases from SQL 2000 to SQL 2005.
- Produced numerous reports from SQL Server as requested. (SQL, SSRS, Excel, Access)
- Developed scores of stored procedures, functions, and views.
- Completed several full life cycles of database development including analysis, data modeling, and implementation based on business needs.
- Developed and implemented teh division’s Systems Development Life Cycle.
