OBJECTIVE

Seeking a SQL Server Development or administration position where I can utilize my technical skills, business knowledge and industry experience to effectively architect and implement solutions that enable the growth and success of the organization.

TECHNICAL SKILLS

Databases:

SQL Server Oracle 11g.

Microsoft Certified Technology Specialist SQL Server 2005.

Programming Languages/

Technologies:

T - SQL SSIS PL/SQL C VB.NET ASP.NET XML XSLT HTML DHTML JavaScript Crystal Reports Documentum Erwin UML Visio Rational Robot Nunit TestComplete Aperture IIS VMware Goldmine Enterprise Edition SCRUM Version One SVN.

Strengths:

Six years' experience using SCRUM Extensive experience designing and creating ETL packages using SSIS Excellent relational database design skills Solid T-SQL and PL/SQL skills SSAS and SSRS knowledge OOP knowledge and experience strong leadership skills Agile development methodologies Project Management Systems Design, Business Analysis, Data Modeling and Lead Development experience.

EXPERIENCE

Confidential

Responsible for managing two data warehouses within the corporate environment. Tasks include monitoring and tuning for performance, responding to business requests, and developing ETL packages to import data into the data warehouse. Developed numerous ETL packages using SSIS and SQL Server 2012 to import data from multiple systems and platforms including Oracle, SQL Server, FTP, the Internet, Excel and SharePoint. Worked with business partners to identify requirements and appropriate test plans.

Confidential

Lead project to implement SLQ Server Resources Governor to provide resource allocation. Architected and developed many SSIS packages to transform customer data across multiple platforms, ensuring data integrity, logging, error handling, and control totals were implemented. Designed and developed an automated NPS process using SQL Server 2008, SSIS, VB Scripting and Vovici web services, eliminating the need for manual operations. Designed and developed an application to copy blob data from the database to specific folders on the file system. Used SQL Server job scheduler to run packages and also developed a .NET application for data managers to move data in and out of jurisdictional databases as the data is provided by the states. Provide design and development of database objects, stored procedures, functions, views, triggers and jobs for three software teams. Work with team leads to architect solutions across systems and function as lead architect for CRM systems. Develop reports using SSRS and Crystal Reports. Provide leadership for development and maintenance of Compliance Watch on-line system using SCRUM. Work closely with product owners and development team to identify new features and provide effective technical solutions. Assist with database backups, maintenance plans, tuning, and disaster recovery. Certified Scrum Master with five years' experience developing and leading agile projects.

Confidential

Architected solutions across multiple platforms and provided technical leadership for SQL Server development. Led the development SSIS packages to transform data from Oracle to our SQL Server for marketing initiatives. Architected a process to fully automate our net promoter survey process in a way that provides immediate feedback to our customers and highlights areas for customer service improvement. Developed and managed multiple SQL Server jobs, SSIS packages, and stored procedures to transform data across technical platforms. Developed functions for repeatable use. Automated manual processes using a combination of TSQL, SSIS, SQL Server 2008 scheduled jobs, and .NET applications. Determined root-cause of rapidly growing database and resolved the issue, resulting in 90 increase in disk space and elimination of redundant data.. Developed CLR .NET assemblies to provide increased performance in search and replace of XML data. Developed interfaces to third party web services using SSIS scripting. Developed integration packages to transform data between various data sources and destinations. Lead application upgrade projects and SQL Server upgrade from 2005 to 2008. SQL Server 2005 and 2008, SSIS, Goldmine Enterprise Edition, Visual Basic .NET 2005 and 2008 Oracle 11g, SQL Developer Visio .

Confidential

Responsibilities include maintaining and providing upgrades to 300 databases, developing SQL stored procedures, functions, DTS and SSIS packages to support the business, and providing technical leadership to team members. Developed .NET tools, SSIS packages, and stored procedures to load and validate data obtained from various sources in varying formats. Designed and developed a stored procedure that integrates the .NET CLR and makes use of regular expressions to enable database searching, provided more inclusive data, and improve performance. Team member on redesign project to provide consistency across databases and improve maintainability. Significantly improved DNB data load performance by automating processes, adding error handling, logging, and data validation, and incorporating the new process into a one-click tool. Designed the Jurisdictional Services Data Warehouse Automated Load Process and contributed to its implementation. Created common processes to eliminate redundancy and improve maintainability. SQL Server 2000 and 2005 DTS SSIS Visio .NET 1.1 and 2.0 .

Confidential

Responsible for all aspects of Aperture data center management software implementation including database development and maintenance, administration, network architecture, application installations, configurations, component development, and support. Liaise with clients to ensure an accurate and high-quality implementation. Developed DTS packages, replication jobs and stored procedures for coordinating data between multiple servers. Implemented a virtual network to simulate the client's infrastructure within deadline, with no previous knowledge of Aperture or virtual networking tools. Lead the development team in design and development of a data collection system to streamline processes, eliminate errors and maximize quality. Developed quality assurance procedures to ensure data validity. Developed complex Crystal Reports, stored procedures and views for executive reporting. SQL Server Visio Aperture VMware Virtual Server Windows 2003 Server Access .NET .

Confidential

• Developed on-line student loan and credit-processing components from minimal business requirements within a very dynamic environment. Developed and documented application components, web front-ends, stored procedures, views, etc. as business needs changed. MSMQ ASP.NET VB.NET SQL Server 2000 XML XSL .
• Developed an end-to-end project implementation methodology that supports buy, build, or customize implementations.
• Researched and analyzed third-party OFAC products for integration into existing systems and recommended a cost-effective and efficient technical solution. Designed the recommended OFAC solution for integration into existing systems. SQL Server Visio UML ASP.NET VB.NET .
• Researched and analyzed various instrumentation frameworks for use with .Net projects and prepared prototypes demonstrating core benefits.
• Researched and evaluated numerous unit and integration testing tools, recommended a tool for .Net unit testing, and produced a reliable unit testing methodology for implementation into the development environment to reduce costs and time-to-deliver and improve software quality.
• Maintained an automated code-generator for use with SQL Server and .NET using web services, XML, and XSLT.