SUMMARY

• 6+ years of experience in Database Designing and developing for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T - SQL writing stored procedures, triggers and functions, Schemas, Synonyms, DMX Queries, etc.
• Designing and Developing SSIS process for numerous automated stuffs and created several permanentSQL Server2008 R2 database tables, created severalSQLviews and wrote several complex user-defined functions (UDF’s) to validate and manipulate data elements prior to participation in this match process.
• Designed and developed several other SSIS packages for the creation of delimited file extracts and reports.
• Created numerous, parameterized SSRS 2008 R2 SSRS reports and the complex report dataset views from which the report records were retrieved.
• Designed and developed several SSRS 2008 R2 reports that cached the current report records to a permanent table to allow for their exclusion from subsequent scheduled executions of the report.
• Optimized and performance tuned numerousSQLviews, stored procedures, user-defined functions and queries by rewriting them as more efficient Transact-SQLcode and by adding indexes, when appropriate, to theSQLServerdatabase tables from which they retrieved their data.
• Supported the QA and UAT testing of several releases of the UPI project software by providing complex, parameterizedSQLqueries to the testing BAs and by analyzing and resolving Quality Center defects as necessary.
• Frequently requested the promotion of the Development team’s database software objects to our QA, UAT and
• Monitoring Production environments by our DBA group for scheduled releases and ad-hoc issue resolution.
• Participated in the design of new UPI software processes and reports and in the enhancement of existing processes and reports.
• Mentored new project team developers and business analysts in development best practices and advancedSQLServerTransact-SQLquery techniques.
• Introduced, Developed and Deployed the Integration Packages (SSIS) Analysis Services (SSAS), Reporting Services (SSRS).
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.

TECHNICAL SKILLS

Databases: MS SQL Server 2012, 2008 R2, 2005, MySQL, Oracle 9i, MySQL

Programming: T-SQL, PL/SQL, Visual Basic 6, Visual Basic 5, C, C++, C#

DBA: Database administration of MS SQL Server 2012,2008, 2005

Disaster Recovery Soln.: Clustering, Replication, Log Shipping, Database Mirroring, Always On High Availability, Backup’s etc.

Business Intelligence: SQL Server Integration Services (SSIS), SSAS, SSRS, ETL, DTS, Jasper, Tableau, Qlikview, etc.

Source Control: Team Foundation Server (TFS), VSS, Red Gate SQL Source Control

Operating System: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Supporting Tools: Backup Utility, SQL Lite Speed, MS Visio, MS Project Plan

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

SQL Server Developer

Responsibilities:

• Designed and developed a suite of Claims Control Reports inSQLServer2008 R2 Reporting Services (SSRS).
• One report consists of a parent report and three embedded heavily parameterized sub-reports.
• The sub-reports retrieve their report content from multipleSQLServers and databases.
• Developed a separate, stand-alone, parameterized Claims Transactions Report in SSRS 2008 R2 that retrieves all claims transactions from the centralized transaction data warehouse by selected As-Of-Date.
• Developed a complex, source system-specific Premium and Claim Reconciliation Report in SSRS 2008 R2 consisting of a parameterized parent report with six embedded heavily parameterized sub-reports retrieving data from five separate databases.
• Wrote numerous complex, optimized Transact-SQLqueries, stored procedures and user-defined functions.
• Designed and developed a complex ETL package inSQLServer2008 R2 Integration Services (SSIS) that prepares and executes as aSQLAgent job a cross-database SSRS Reconciliation Report.
• This SSIS package will run as the final step of an ETL process that loads Premium, Commission and Claim data into several staging databases, the US Data-Hub data warehouse and the Corporate GL database.
• The SSIS package consists of an ExecuteSQLTask; a Data Flow Task to retrieve, sort, merge and enrich data from severalSQLServerdatabases and then load data to a report-specificSQLServer2008 R2 database table; a Script Task to execute a custom C#.Net script to run the Premium Reconciliation report on a specified Reporting Web Service and to automatically export it to MS Excel; and another ExecuteSQLTask to run a SQLAgent job to actually produce the SSRS report.
• Participated in the integration of Aspen’s Surety data into the US Data-Hub data warehouse and the Corporate GL database.
• Performed the initial data profiling of the vendor-hosted Surety data and the data mapping of this data to the US Data-Hub staging DB tables.

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, Microsoft Visio 2010, SFTP, Microsoft Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS)

Confidential, Minneapolis, MN

Senior SQL Developer

Responsibilities:

• Designed and developed a complex SSIS 2008 R2 process to match Unclaimed Property Research tranche records to records in the Confidential Treasury Department’s Tracker database by any of several possible explicit or approximate match criteria.
• As part of the SSIS process I designed and created several permanentSQL Server2008 R2database tables, created severalSQLviews and wrote several complex user-defined functions to validate and manipulate data elements prior to participation in this match process.
• Designed and developed several other SSIS packages for the creation of delimited file extracts and reports.
• Created numerous, parameterized SSRS 2008 R2 reports and the complex report dataset views from which the report records were retrieved.
• Designed and developed several SSRS 2008 R2 reports that cached the current report records to a permanent table to allow for their exclusion from subsequent scheduled executions of the report.
• Optimized and performance tuned numerous SQLviews, stored procedures, user-defined functions and queries by rewriting them as more efficient Transact-SQLcode and by adding indexes, when appropriate, to the SQL Serverdatabase tables from which they retrieved their data.
• Supported the QA and UAT testing of several releases of the UPI project software by providing complex, parameterized SQLqueries to the testing BAs and by analyzing and resolving Quality Center defects as necessary.
• Frequently requested the promotion of the Development team’s database software objects to our QA, UAT and Production environments by our DBA group for scheduled releases and ad-hoc issue resolution.
• Participated in the design of new UPI software processes and reports and in the enhancement of existing processes and reports.
• Mentored new UPI project team developers and business analysts in development best practices and advancedSQLServerTransact-SQLquery techniques.

Environment: MS SQL Server2008/2005,Oracle 9i,T-SQL, Visual Studio.Net 2010, Crystal Reports 8.5, Business Objects 6.1b, SQL Loader,Lite Speed, MS Access, DTS, BCP, SSIS, SSAS, SSRS, SQL Profiler, Windows 2008

Confidential, Omaha, NE

Business Intelligence Developer

Responsibilities:

• Designed, developed and deployed to Production numerous complex, heavily parameterizedSQLServer2008 Reporting Services reports and the many Transact-SQLparameterized stored procedures used to retrieve the datasets for these reports and their parameter dropdown lists.
• Developed a customized SSRS 2008 Report Builder 2.0 Report Model with numerous named queries as derived tables, named calculations as derived columns, sourced from the existent DDSDW dimensional data warehouse to eventually be used for ad hoc reporting by the department’s business power users.
• Optimized, with the inclusion of several key missing indexes, theSQLServer2008 R2 DDSDW dimensional data warehouse for significantly enhanced query performance.
• Recoded and optimized several existent report stored procedures for greatly enhanced performance, closer adherence to ANSISQLstandards and better readability.
• Designed and developed severalSQLServer2008 Integrated Services packages to load new dimensionally modeled data warehouse tables from a relationally modeledSQLServerdatabase and a MS Excel worksheet source.
• Made extensive enhancements to the Report Definition Language files of several existing SSRS reports; often directly in the XML code view of the report.
• Developed aSQLServer2008 Analysis Services cube, sourced from the existent DDSDW dimensional data warehouse, to eventually be used as a data source for enhanced reporting.
• Created the reports using Business Objects functionality’s like Queries, Sub queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula’s etc.
• Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment: SQL Server 2008 R2/2005, Erwin 4.0, T-SQL, SSRS, SSIS, SSAS, Windows 2008 server, VB6.0, XML

Confidential, Warren, NJ

SQL Server Developer

Responsibilities:

• Designed and developed the Confidential ’s Stage Data Archive facility as a complex, multi-step stored procedure and user-defined function that programmatically creates multiple dynamicSQLstatements to perform the numerous Insert and Update steps required.
• Wrote numerous complex stored procedures to provide data retrieval and data update functionality to support the CARE Enrichment, CARE Opening Balances, PeopleSoft Chart field Validation, ARTS Tactical and Currency Conversion development endeavors.
• Designed and developed more than twenty complex stored procedures to extract and format data for the Reserve Pro Reporting endeavor.
• Wrote numerous complex, optimized Transact-SQLqueries to verify the accuracy of the ETL of source data into the Insurance Data Warehouse against Confidential ’s Stage 1 data.
• Designed and developed a complex, aggregating data extract query to provide the FR&C data necessary for the US P&C Reporting endeavor.
• Worked closely with business analysts and end-user clients to ensure the timely delivery of accurate, well formatted data extracts and optimized executable Transact-SQLqueries or stored procedures in support of all development efforts in which I participated

Environment: MS SQL Server, Windows 2003 Server, MS Office, SSRS, SSIS, SSAS, Windows Event Viewer, etc.

Confidential, Richmond, VA

SQL Server/BI Developer

Responsibilities:

• Designed and developed a SQL Server Integration Services process to load the Microsoft Access resident XL Insurance Balance Sheet data into the Revenue Projection Engine’s SQL Server 2008 R2 stage database for eventual loading into the RPE database.
• Created several SSIS configuration files and command line execution files for the execution of this package and another which loads the XLI Balance Sheet data from the stage database into the RPE.
• Coordinated the frequent submission of execution requests for these two SSIS processes, and others, to XL Data Management Services during RPE development and testing.
• Designed and developed a complex, integrated SSIS process consisting of 30 Control Flow task elements and numerous Data Flow Tasks to programmatically create the XL Insurance Income Statement source data for the Revenue Projection Engine from multiple, disparate MS Access, MS Excel and MSSQLServerdata sources.
• Created numerous complexSQLServer2008 Transact-SQLstored procedures and queries to support the development and testing of these SSIS processes.
• For the Insurance Data Warehouse, created several complex Transact-SQLuser-defined functions to conditionally change the signage of certain ceded premium and claim amounts to be implemented as an ETL or reporting-side solution.

Environment: Windows 2003 Server, SQL Server 2005, SQL Server 2005,T-SQL, PL/SQL, JavaScript, MS IIS Server 6.0, SOAP, HTML/DHTML, XML, Oracle8i.