SKILLS:

Database: MS SQL Server 2000, 2005, 2008, and 2008 R2

Completed MCP Exams: Developing in SQL 2000, Installation and Administration of SQL 2000, and Windows XP Professional

Programming Languages: Proficient in MS SQL, and beginner knowledge of Visual Studio .NET

Applications: SQL Server Business Intelligence Studio (Analysis Services, Integration Services, and Reporting Services), LiteSpeed for SQL Server, Backup Exec, Idera Diagnostics Manager, Mercurial SCM, Microsoft Visual Source Safe, Microsoft Office products, Webfolio

Operating Systems: Intermediate knowledge of Windows Server 2000 and 2003 administration

EXPERIENCE:

Confidential, New York, NY

SQL DBA/Database Developer

Responsibilities:

• Supported and administered approximately 100 GB of production and development databases across several SQL 2005 and 2008 R2 Servers
• Implemented a number of improvements to the existing data transformation tasks using SQL Integration Service (SSIS) and fine - tuned corresponding data loading SQL scripts to process more efficiently which significantly reduced overall execution time and maximized server resources
• Worked with the Cognos Developer to generate automated reports to confirm the validity of the data entered by users through the third party asset management platform (Webfolio) so that the Database Team can ensure all required data was transmitted and processed accurately to other database repositories and promptly react and correct any issues to prevent data discrepancies from appearing in internal and client reports
• Developed functionality within Webfolio which allows users to manually enter a formula for creating custom indices directly into the application and automatically generate calculations for the new index which eliminated a time consuming manual data entry process for the application users
• Worked extensively with Application and Cognos Developers to create and deploy SQL scripts, stored procedures, triggers, and other objects used for installing and upgrading reports and Webfolio functionality
• Part of the team responsible for planning, testing, and deploying SQL Server upgrades from 2005 to 2008 R2
• Worked with the Database Team to provide 24x7 support for the firm which included close monitoring of database servers using Idera Diagnostics Manager and troubleshoot and resolve any database related issues such as backups, hourly and daily data transformation failures, and other DBA tasks quickly and effectively

Confidential, New York, NY

Senior Developer - SQL DBA/Database Developer

Responsibilities:

• Supported and administered approximately 5TB databases across many SQL 2000 and 2008 Servers
• Redesigned production databases to optimize performance of client systems and other internal processes
• Developed and automated a solution which handles monthly data processing and normalization, of client Budgeting and Forecasting data, and made data available as an OLAP cube using VB.NET and SQL Server Analysis Services to improve and simplify analysis of comprehensive data for internal and client users
• Enhanced existing stored procedures and other production processes to execute more efficiently which significantly decreased execution time by several hours and reduced server resources
• Lead SQL Server upgrade efforts to migrate from SQL Server 2000 to 2008 by working closely with Developers, Infrastructure, and Project Managers to plan, test, and deploy the environment to the new version in a timely manner
• Worked closely with Infrastructure to configure and deploy new SQL Servers and upgrade existing SQL Server hardware to maximize performance
• Assisted Developers in creating an internal application designed to implement and log production changes
• Used Reporting Services and other applications to create internal reports and notification processes to easily monitor and audit the SQL Server environment
• Worked directly with Developers to create and fine-tune SQL scripts, stored procedures, and other objects used to implement new features and upgrades for all client applications
• Worked with Project Managers to develop and update automated client reports for new and existing customers

Confidential, White Plains, NY

Senior Analyst

Responsibilities:

• Supported and administered approximately 25TB databases across seven SQL 2000 Servers
• Designed and maintained project databases using SQL Server and automated numerous database maintenance and backup tasks
• Monitored and troubleshot stored procedures, user queries, and indexes and performed performance tuning when needed
• Managed data library to ensure proper processing and validation of client data
• Developed and administered the TeamTrack workflow application used to create department and project specific workflows which increased completeness and efficiency of project specific tasks
• Conducted new analyst training sessions in Data Loading procedures and best practices for SQL querying
• Developed SSIS and DTS solutions to automate Data Loading tasks
• Worked directly with clients and project managers to ensure all necessary data is created and delivered properly in accordance to corporate and standard security policies
• Monitored daily and weekly server backups and handled all database restores when needed
• Analyzed and developed reports used by Management and Analysts to validate client data
• Prepared client deliverables for quarterly analysis and presentations