SUMMARY:

• Proficient in keeping detailed documentation for system processes.
• Develop and execute on projects effectively within any team size.
• Capable of interfacing with client groups, technology partners, and co - workers.
• Possess effective skills relative to interaction with various support areas within the company.
• Proven experience in completing assignments independently with no supervision.
• Able to mobilize and leverage appropriate resources to get things done within deadlines.
• Develops schedules and project plans. Ensures target timelines and deliverables are met.
• Able to make appropriate decisions and understand their impact & audience.
• Able to provide effective guidance to individuals that may lack a certain level of knowledge

TECHNICAL SKILL SETS & EXPERIENCE:

Client/Server: Windows, HTML, Classic ASP, ASP.NET, C#.NET, Javascript, Vbscript, VBA, COM+, AJAXDynamic HTML, ADO, ADO.NET, VB.NET, Visual Studio 2005/2008/2010/2012 , Autosys

Relational Database: SQL Server 2014 / 2012 / 2008 / 2005 / 2000 / 2003 , SQL Server7, Oracle, DB2Sybase, MS Access, ETL, T-SQL, PL/SQL, Data Mart, Data Warehouse, Stored ProceduresDTS, SSIS, SSRS, SQL Server Management Studio, Oracle BI (Siebel Analytics/OBIEE) Crystal Reports, Macros, MS Access Forms & Reports, Operational data store (ODS)

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL Developer

Responsibilities:

• ETL (SSIS) Developer working with Liquidity Risk Management Group to design and develop ETL (SSIS) process to load liquidity risk data into Sql Server data warehouse database for the Federal Liquidity Monitoring daily reporting of PNV cashflows.
• Designed and developed Star schema/Kimball database including slowly changing dimension tables (SCD tables) and ETL (SSIS) process utilizing T-sql, stored procedures and views. Utilized development technologies such as SQL Server 2014 & 2016, Oracle and Visual Studio 2015, Toad.
• Work close with the lines of business leads.

Confidential, Charlotte, NC

SSIS Developer

Responsibilities:

• SSIS Developer working with Wholesale Technology Group to design and develop ETL (SSIS) process for the CRM database system (SQL Server database).
• Developed and tuned tables, stored procedures, SSIS packages.
• Developed SSIS packages utilizing KingswaySoft to integrate with Dynamics CRM database.
• Utilized development technologies such as T-SQL, SSIS, SQL Server 2014, Oracle and Visual Studio 2012. Work with job scheduling tool (Autosys).
• Experience with researching, analyzing, designing and developing new and/or existing monthly, daily, and one-time data processes by use of ETL.
• Work close with the lines of business leads.

Confidential, Charlotte, NC

SQL Server Developer

Responsibilities:

• SQL Server Developer working with Privacy Technology Group to design and develop PEMD database for a 2012 web application database system and support other database systems within the Privacy Technology Group.
• Develop database structure from concept to design to development to implementation and support.
• Developed and tuned stored procedures.
• Developed data tables and data relationship and reports.
• Utilized development technologies such as T-SQL, SSIS, SQL Server 2008 and SQL Server 2012, Oracle.
• Provide design/development support to application developers utilizing development knowledge and experience of ASP.Net and C#.Net (Visual Studio 2010/2012).
• Experience with researching, analyzing, designing and developing new and/or existing daily data processes by use of ETL.
• Work close with the lines of business leads.

Confidential, Charlotte, NC

SQL Server Developer

Responsibilities:

• SQL Server Developer working with Investor Performance Management (IPM) for a Client-Analytics group with primary focus and experience working with Equity trade data (syndicate and secondary trades) data mart within the IPM data warehouse.
• Provide additional support to other data marts (Fixed Income trades).
• Utilized development technologies such as SSIS, SQL Server 2008, Sybase, Oracle database, DTS, T-SQL, JavaScript, STAR schema, KIMBALL methodology, Visual Studio 2008/2010, and ASP.Net, C#.Net.
• Performed T-SQL query optimization and tuning tasks to enhance performance in daily data processes of large external and internal data files and data tables. Developed and tuned Stored Procedures for optimum performance that are used in the daily data processing.
• Experience with researching, analyzing, designing and developing new and/or existing daily data processes by use of ETL.
• Perform data warehousing, relational database and dimensional database modeling maintenance and support tasks. Work close with the lines of business leads.

Confidential, Wilson-Salem, NC

SQL Server Developer

Responsibilities:

• SQL Server Developer working with NPS Policy Insurance Datawarehouse team with primary focus and experience working with Coverages and Premiums financial data in 1 legacy operational data store (ODS) Oracle database and several other SQL Server (Star Schema / KIMBALL methodology) databases.
• Develop ETL for insurance data migration using SSIS from Oracle and SQL Server databases, design and analyze fact and dimension tables, develop PL-SQL functions and stored procedures, develop T-SQL stored procedures, and analyze insurance premium financial data.

Confidential, Charlotte, NC

SQL Server Developer / Data Analyst

Responsibilities:

• SQL Server Developer and data analyst working with the Quality Control Monitoring and Analysis team for Mortgage Data Analytics group with primary focus and experience working with primarily foreclosure mortgage data in 2 operational data store (ODS) databases.
• Utilized development technologies such as SSIS, SQL Server 2008, VB.Net, XML, Fusion Charts, Stored Procedures, MS Access, Excel, Visual Studio 2008 and JMP.
• Develop ETLs for mortgage data migration using SSIS from different systems; develop T-SQL ad-hoc reports; perform Stored Procedure performance tuning; develop T-SQL Stored Procedure processes, database design; perform mortgage data analysis and develop pivot charts for analytical review of data; develop process for Fusion Chart mortgage data trending reporting for SharePoint end users using SSIS, VB.Net, XML, SQL Server 2008 database and Fusion Chart technology; data sourcing research and documentation.

Confidential, Charlotte, NC

SQL Server Developer

Responsibilities:

• SQL Server Developer working with Investor Performance Management (IPM) for a Client-Analytics group with primary focus and experience working with Equity trade data (syndicate and secondary trades) data mart within the IPM data warehouse. Provide additional support to other data marts (Fixed Income trades).
• Utilized development technologies such as SSIS, SSRS, SQL Server 2005, Sybase, Oracle database, DB2, Oracle Business Intelligence (Siebel Analytics/OBIEE) tools, DTS, JavaScript, T-SQL, STAR schema, KIMBALL methodology, Visual Studio 2005, and ASP.Net with C#.
• Performed T-SQL query optimization and tuning tasks to enhance performance in daily data processes of large external and internal data files and data tables. Developed and tuned Stored Procedures for optimum performance that are used in the daily data processing.
• Experience with researching, analyzing, designing and developing new and/or existing daily data processes by use of ETL.
• Perform data warehousing, relational database and dimensional database modeling maintenance and support tasks.
• Work with OBIEE Administration involving metadata creation/modification on the repository (RPD) for creating and managing reports, and development of new and/or existing subject areas. Develop other reporting using SSRS. Work close with the lines of business leads.

Confidential, Charlotte, NC

SQL Server Developer

Responsibilities:

• Performed reporting and analysis on mortgage portfolio data warehouse within the HRD REPORTING AND ANALYTICS group working with teradata table sizes.
• Created analytical reports from system data and external data sources in presentational forms using Excel, Access Reports, SSRS reports and web-based reports.
• Performed T-SQL query (Stored Procedures) optimization and tuning tasks to enhance performance in daily data processes of large external and internal data files and data tables using ETL processing.
• Utilized Microsoft Technologies such as T-SQL, Stored Procedures, SSIS, SSRS, KIMBALL methodology and SQL Server 2000/2005.
• Developed T-SQL Stored Procedures; create, drop, alter database objects; manipulate data by use of Joins & SQL

Confidential, Charlotte, NC

Software Engineer

Responsibilities:

• Designed and developed SQL Server database structures for optimal database performance. Ensure data integrity.
• Developed T-SQL Stored Procedures; create, drop, alter database objects; manipulate data by use of Joins, SQL, and ETL.
• Developed a new data mart (project resources) within the existing data warehouse.
• Utilized Microsoft Technologies such as T-SQL, Stored Procedures, SSIS, SSRS and SQL Server 2000/2005 engine, ASP, ASP.NET, AJAX, VBscript, Javascript, MS Access (VBA), MS FrontPage.
• Developed new functionality into an existing enterprise web database application - named CPU.
• Development and review of design two web database application merger.
• Gathered and created requirements documentation. Mentor technical skilled junior level team members.
• Validate test cases of data. Developed test script using Test Director (Quality Center).
• Created analytical reports from system data and external data sources in presentational forms using Excel, Access Reports and web-based reports.

Confidential, Charlotte, NC

Software Engineer

Responsibilities:

• Designed and developed SQL Server databases structures for optimal database performance. Ensure data integrity within the new NCG data warehouse that contains 3 data marts (hardware/software data, FTE data and Contractor data).
• Developed T-SQL Stored Procedures; create, drop, alter database objects; manipulate data by use of Joins & SQL
• Developed and schedule DTS processes to import, export, and transform data (ETL) from remote MS Access sources
• Setup users with the appropriate SQL Server authentications and/or Windows authentications
• Maintain, administrator and support 3 SQL Server databases in 2 database server environments.
• Project manager - manage several on going projects, analyze and design database applications. Enforce BOA app & database standards.
• Designed and developed MS Access Reporting database structure and process for all reporting needs.
• Maintain and support 3 web server environments (IIS and Windows servers)
• Developed web survey application with full web administration sections using Microsoft Technologies such as Classic ASP, VBscript, Javascript, Visual Basic 6, ASP.NET, MS Access (VBA) and SQL Server database that reduced the amount of resources (from 4 people to 1) and time (from 80 hours/per execution to 1 hour) need to report the Desktop & Electronic Communications Total Cost Ownership for the bank. Mentor technical skilled junior level team members
• Create and monitor timelines and deliverables using MS Project.
• Gathered and created the application requirements documentation.
• Performed system analysis and documentation for existing and new systems.
• Administrator web application in three environments (development, UAT, production) utilizing BOA application development standards.
• Developed QA test scripts and managed testing process.
• Analyze quarterly based output data against identified benchmarks.
• Assist team with efforts to automate and streamline daily processes and procedures.
• Project manager for the support transitioning of the web application.
• MS Access and Crystal Reports as reporting tools for online reporting. medium team: 5+ members
• Performed system analysis and documentation.
• Developed multiple VBA (MS Access) database applications for the Network Computing Group department.
• These applications consist of advanced Visual Basic 6 & VBA objects to process large amounts of data feeds in addition to complex SQL statements for reporting (MS Access) and processing data using ETL with MS Excel data files as import files. Implemented processes to ensure data validity due to the type of data being processed (all internal employee, contractors, all computers, all software, and all hardware for Confidential with the cost of ownership associated with the counts).
• Assist team with efforts to automate and streamline daily processes and procedures. medium team: 5+ members
• Manage project and measure deliverables
• Enhancements to a desktop compensation database application using VBA (Visual Basic for Applications) MS Access within the Sales and Compensation department.
• Enhancements included adding additional functionality to the app forms.
• Create class object with application written in Visual Basic
• Automate the reporting formatting/printing/exporting (Excel reports) within the application using Visual Basic.
• Automate the reporting formatting/printing (MS Access reporting tools)
• Worked closely with the client. medium team: 9+ members .

Confidential, Charlotte, NC

Software Engineer

Responsibilities:

• Design and developed data T- SQL security, in addition to e-commerce SSL security. DTS data manipulation using ETL (SQL Server database engine).
• Designed and developed SQL Server database structure and complex T-SQL transaction Stored Procedures.
• Designed and developed a secure login system utilizing GUIDs vs. the use of a unpredictable session variables using SQL Server T-SQL transaction Stored Procedures.
• Maintain and support SQL Server database server and hosting - monitor SQL Server connectivity and performance, user session timeouts, load time. Data integrity. Validate test cases of data. Developed test script using Test Director (Quality Center). Manage database backup & restore process.
• Designed and developed the implementation staging of the web database application (development environment, testing environment, production environment)
• Maintain and support MS Access database for reporting tools online. - automated process including DHTML.
• Project Manager - Managed full development lifecycle, timelines, milestones and deliverables.
• Worked closely with the user interface specialists and gathered requirements.
• Designed, developed, and implemented an e-commerce search site using Classic ASP, Javascript, VBscript, SQL Server, Stored Procedures with transactions. Maintenance support using ASP.NET.
• Created an implemented extensive test plans to identify all data security issues.
• Designed, developed, and hosted the company informational and SQL Server database-driven website.
• Design and developed SQL Server database structure and ETL using T-SQL with Stored Procedures - reporting MS Access. Administrator SQL Server database.
• Worked close with the Executive Director.

Confidential, Charlotte, NC

Software Engineer

Responsibilities:

• Developed and design MS Access VBA (Visual Basic for Applications) application all stages of the development life cycle for a banking corporation (Consumer Real Estate).
• Design and developed MS Access database structure, MS Access reporting within database, exports and ETL.
• Create and monitor timelines and deliverables using MS Project.
• Gathered and created the application requirements documentation.
• Analyze and document design scope for a large-scale database application (front-end Visual Basic 6 / back-end SQL Server database engine).
• Assist team with efforts to automate and streamline daily processes and procedures.
• Worked closely with the client (Vice Presidents, Assist Vice Presidents, Managers). Project manager