TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008/2012/2016 , MySQL

Tools: Visual Studio + BIDS, T - SQL, Toad, TFS, SVN, VB/C#/ASP.Net, VBA, Java/VBscript, C, C++, Fortran

PROFESSIONAL EXPERIENCE:

Confidential

Software Engineer

Responsibilities:

• As a member of the Business Intelligence Data Services Team, responsible for maintenance and development of the Business Intelligence Data Warehouse.
• Sourcing data from multiple sub-systems and enterprise CRMs, tasked with troubleshooting existing SQL and ETL processes as well as developing efficient solutions with SSIS, SQL Server 2016 using an AGILE development model.

Confidential

SQL Developer

Responsibilities:

• Contracted to provide subject matter expertise in the area of Data Warehousing, ETL, SSIS and database development best practices utilizing Microsoft SQL Server 2012 and 2016.
• In progress development includes SSIS packages and related code to automate file retrieval from FTP, decryption, and data load.
• Designing, developing and implementing new data warehouse for the existing SSRS reporting environment.
• Development of scheduled, metadata-driven Merge logic to maintain relative freshness of data in the new data warehouse.

Confidential

SQL DBA/SSIS ETL Developer

Responsibilities:

• Responsible for providing SQL Server and SSIS expertise related to development, code refactoring and new initiatives for the Legal Technologies team, which supports the Confidential Department.
• Serving as the team’s subject matter expert for SSIS and ETL methodologies for the Legal Reporting data warehouse.
• A notable project was the planning, development and testing for an intranet-based application that analyzed and reported on the bank’s legal exposure for home loans.

Confidential

Database Analyst

Responsibilities:

• Member of the Confidential Development Team.
• As a member of the Confidential Development team, responsible for new development, modifications and improvements to existing processes, and troubleshooting/issue resolution for the Confidential data warehouse.
• Development utilizes SQL Server 2008, SSRS, SSIS, and Informatica. Individually responsible for multiple projects and initiatives as part of a standard SDLC process with bi-weekly deployments.

Confidential

Database Analyst

Responsibilities:

• Evaluation, recommendations and the rewrite of DML in databases and ETL processes to increase the availability, reliability and speed of the ICIS System with the aim of handling a ten-fold increase of inbound records
• Conversion and documentation of 50+ SSIS packages from 2005 to 2008 including rewrites, database-driven package configurations, logging and concurrent deployment and setup across all environments
• Assisting in the implementation of a new System Integration Testing (SIT) environment - responsible for AutoSys job scripting, scheduling, SSIS package deployment and validation of all SIT source and destination data

Confidential

Working Manager

Responsibilities:

• Identifying and improving operational and developmental deficiencies, streamlining current processes. Examples include participating in and directing the conversion of DTS packages to SSIS, consolidating the functionality of multiple stored procedures within individual SSIS packages, and creating streamlined and framework-based ETL methods to replace older, disjointed jobs and scheduled tasks.
• Implementing organizational change to increase revenue through the utilization of VB/C#.Net, SQL Server 2000/2005/2008 and multiple web technologies. Examples of organizational changes implemented include the utilization of the MVC model for new development of web sites aiding in faster, more agile web development, replacement of long-running cursor-based T-SQL code with CTE’s, and participation in the upgrade of numerous applications and databases from VB6, Classic ASP and SQL Server 2000 to .NET and SQL Server 2005.
• Investigation/break-fix of problem code and processes. Typical investigation/break-fix issues include researching, troubleshooting and rewriting malfunctioning DTS and/or SSIS packages, SQL sanitization and data manipulation using T-SQL, and replacement of outdated web code with browser-independent code.
• Guiding team members towards successful outcomes via oversight of performance, management of team workflow/task priority and day-to-day employee work and personal issues.
• Assisting Management on decisions regarding resource allocation.
• Participation and contribution in hiring, firing and annual review processes.

Confidential

Senior Database Application Developer

Responsibilities:

• Creation of database objects, application code, web services and web code for strategic applications
• Development of internal web/database tools to replace manual processes
• Collaboration with team members on creation of functional and technical specifications, and subsequent team-driven development

Confidential

Consultant

Responsibilities:

• Development and support for web-based data entry system for SQL Server database.
• Design of network-based database applications with MS Access and VBA, allowing management to view statistical reports, and modify and/or delete problem data.
• Creation of automation procedures with PERL, VB, and DOS batch-file scripting to retrieve, process and store server logs.
• Research and recommend new and emerging technologies for possible integration into existing infrastructure.

Confidential

Database Consultant

Responsibilities:

• Migrated property research, lease management, and Real Estate Manager Incentive programs into centralized SQL Server warehouse for the Real Estate department.
• Advised Real Estate department business analysts in identifying and implementing step-by-step procedures and processes related to the migration.
• Utilized Microsoft technologies - SQL Server, VBA, Excel, and Access - to create management and reporting system for Construction department oversight and evaluation of external building contractors.
• Implemented SQL Server database fixes for the Warehouse Receiving department.
• On a project-to-project basis, responsible for defining, evaluating, implementing, and reporting on project requirements, functional requirements, code management, project progress and benchmarks.