Software Engineer Sql Server
Resume:
AYODEJI ADEDIRAN
Long Island City, NY 11101
Email:
********@*****.***
Phone:
SUMMARY OF QUALIFICATIONS:
. Good experience in IIS management in IIS 7.5 on Windows 2008 R2.
. Experienced in website and database migration and upgrade.
. Extensive experience with XML, both in production and consumption of
XML-based web services feeds especially using SOAP.
. Good understanding of web technologies including, C#, ASP.NET, Web
services / XML, HTML, CSS, JavaScript, LINQ and JQuery.
. Experience Maintaining Classic ASP Website.
. Well versed in Microsoft .NET Framework. With experience identifying
needed front end applications and developing them to manage data
manipulation.
. Strong understanding of database management, database optimization,
query optimization, database design, stored procedures, triggers and
construction of complex queries using SQL.
. Good experience with data manipulation with Microsoft SQL Server 2008,
2012, including work with Integration Services packages, functions and
SSIS packages.
. Experience with Test Driven Development and automated testing
frameworks such as NUnit.
. Experience with agile development methodologies, with continuous
integration build practices and planning using Scrum for project
management.
. Knowledgeable in software development life cycle.
PROFESSIONAL EXPERIENCE:
Lead Software Developer
Daily Racing Form
New York, NY
2012 - Present.
. Website Migration: Migrated entire host of commercial websites,
database, XML feeds and forums to new servers.
. Lead development for new features, changes and bugs on key websites.
. Maintain Dot Net Nuke ASP.NET Websites.
. Experience in IIS management while migrating sites to IIS 7.5 on
Windows 2008 R2.
. Maintain SQL Server databases, created replications between servers
and maintain SQL Jobs. Also created new tables and stored procedures
as needed.
. Use SSIS to import and process different file formats.
. Process reports using SSRS.
. Maintain general reports using Microsoft Access for use by business
associates.
Senior Software Engineer / Web Services Support Manager (2010 - 2012)
. Manage team that supports our host of websites and handling customer
requests by responding to and resolving production problems and user
inquiries.
. Develop XML/Web services implementation, versioning to production.
. In other to reduce customer support, develop and maintain C# front end
applications - Web Control Panel - for website owners to update their
websites.
Software Engineer (2005 - 2010)
Ticket Network Inc.
Vernon, CT
2005 - 2012.
. Develop C# applications for data transfer to clients in ASP .NET and
web services / XML.
. Write SQL stored procedures for use in both XML and C# front end
applications and optimize them for best performance.
. Write and maintain complex queries for reports on web services usage
to sales ratio.
. Responsible for creating and supporting XML/Web Services API for
clients to access our ticket inventory data.
. Develop internal tools to ease management of customer data and
websites like automated website builder and broker administration
panel.
. Developed web services authentication application using IP addresses.
. Responsible for the creation of the web sites by using web
technologies like HTML, C#, JavaScript and jQuery
Database Administrator / Software Engineer.
National Institute for the Clinical Application of Behavioral Medicine.
(NICABM)
Mansfield, CT
2001 - 2005.
. Responsible for management of company data resources which consists
of SQL databases
. Migrated the Data base from Sybase to Microsoft SQL server 2005.
. Wrote complex queries, created and maintained stored procedures from
the queries for data analysis, data reporting, weekly reports and
conference charts.
. Created weekly automated reports for data analysis using VBA and Excel
Macros.
. Manipulated external mailing lists to match our database using Data
Transformation Services.
. Created and supported automated websites for online classes by using
FrontPage Server Extensions to administer, and the browse-time
functionality to manage content showing up at different times.
EDUCATION: UNIVERSITY OF CONNECTICUT - Storrs, CT
Computer Science & Engineering
2000 - 2004.
Skills:
. Languages: C#, ASP.NET, Classic ASP, 4.0, MVC, WCF, Visual Basic 6,
Visual Basic.NET, SOAP, HTML, XML, Web Services, .
. Software: Visual Studio .NET 2010, MS SQL Server 2008.
. Database: MS SQL, MS Access.
Contact this candidate