SUMMARY:

Strong SQL Server Developer/DBA (26 years), ETL (9 years) and VB.NET skills (6 years). Created and supported risk management tools including IRR, amortization and price calculations.

TECHNICAL SKILLS:

Programming Languages: C#, Visual Basic, VBA, Transact SQL, Javascript, ColdFusion, HTML, XML and XSLT

Applications / Technologies: SQL Server 2012, SSIS, SSRS, MySQL, Erwin SQL, MS Access, TFS, SVN, QlikView

PROFESSIONAL EXPERIENCE:

Senior SQL Developer

Confidential, Asheville, NC

Responsibilities:

• Created SSIS packages to retrieve data in XML or JSON format using various vendor APIs (Amazon and Walmart among others) to store in MySQL database. Maintain and develop Qlikview reports to support internal business users in analysis and support of product pricing. Maintain ColdFusion grids and portlets.

Data Architect

Confidential, Asheville, NC

Responsibilities:

• Write Transact - SQL queries to support integration and population of hospital data from multiple sources to facilitate reporting. Maintain and develop Qlikview reports to support clinical needs.

Senior SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Created SQL Server tables, views, stored procedures, functions, triggers and SSIS packages to support tracking of ad campaign responses and revenues. Created SSRS reports for performance tracking.

Senior SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Created SQL Server tables, views, stored procedures, functions, triggers and SSIS packages to support corporate middleware inventory and compliance with corporate versions and software patching.

Senior SQL Developer

Confidential, Winston-Salem, NC

Responsibilities:

• Created SSIS packages to retrieve vehicle insurance information from acquired companies into central repository.

Senior SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Created various SSIS packages to populate performance incentive reporting database from production. Created/reworked stored procedures and functions to support ETL and reporting.

Senior SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Acted as developer on federal compliance project. Created SSIS ETLs to various test results into SQL Server, stored procedures to match test results to existing student table and SSRS reports to identify the type of matching and highlight possible matches for those that couldn’t be definitively associated. Used to monitor progress with respect to various federal guidelines on school performance.

Senior SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Acted as lead developer on federal regulations compliance project. Created standard Excel template for all of the different test areas to capture results. Created SSIS ETL to parse Excel template and import into SQL Server, facilitating reporting of area scorecards and identification of specific points of failure.

Senior SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Acted as lead database developer on conversion of SNAPSHOT application. Rewrite of legacy application to permit finer grained control over which accounts were reconciled. Project was completed under intense pressure because previous team had attempted and failed at rewrite; only a three month window to complete project before corporate conversion event. Leveraged existing code base and made modifications to facilitate new features and to add more robust error handling and automated failure recovery.
• Reduced processing time of General Ledger Extract process by 90%. GL Extract application is source of all data for reconciliation platform. Delays in extract were causing missed deadlines downstream. Quickly analyzed package and determined key areas where performance could be improved without prolonged development effort. Changes were quickly made and moved into production which resolved problem.
• Developed SSIS package for loading trial balance files to General Ledger database in order to remediate error-prone and difficult to maintain c# application. Package is responsible for loading around 80 files daily. While each file was supposed to follow common format, many did not, so package was setup to facilitate a number of data lookups and one-off conversions to standardized the data before being loaded.
• Created/enhanced numerous SSRS reports to support internal business users and support team to monitor various processes.
• Modified various SSIS packages used in GL extract to process more efficiently in terms of time and subdividing output files to facilitate downstream applications.
• Provided training in SSIS and Transact-SQL to support team to enable them to help themselves and provide better service. Greatly reduced problem tickets which were negatively impacting area performance.

Senior Developer / DBA

Confidential, Charlotte, NC

Responsibilities:

• Converted SQL Server 2000 DTS packages to SQL Server 2005 SSIS.
• Migrated SQL Server .
• Enhanced automated overnight data feed and nightly processing process, replacing Windows scheduler and some DLLs with SSIS package incorporating email notification identifying if and where problems arose and data driven model to support multiple databases.
• Created SSIS/SSRS system to collect data feed and nightly processing results from all the production, QA and development SQL Servers and produce report identifying results to facilitate maintenance.
• Created SSIS system based on customized data objects to emulate data driven subscriptions (feature of SQL Server Enterprise which we lacked) to suppress delivery of empty reports both internally and to external clients.
• Created numerous SSRS reports to support internal business users, external clients and IT staff, including use of system tables to monitor timing and destination of SSRS subscriptions.
• Created data dictionary application to allow us to enter business definitions of tables and fields in system tables along with stored procedure facilitating IT documentation and development by allowing searches from a multitude of perspectives.
• Eliminated many instances of hard to maintain dynamic Transact-SQL in stored procedures with table function converting comma delimited list of IDs into a table used in JOINs.
• Replace Crystal Reports with SSRS.
• Maintain front end application for NQDC accounts written in ASP classic, Javascript and VB script.

Systems Analyst / Developer / DBA

Confidential, Boston, MA

Responsibilities:

• Consult with users to identify current operating procedures and to clarify program objectives
• Design, analyze and implement software applications based on program objectives obtained
• Support and maintain fixed income financial application systems:
• VB.Net and SQL Server application collects and aggregates holdings data from all different areas of the company. Various reports used to monitor monthly company compliance with SEC regulations on limits of equity position held in individual company. Automated retrieval of shares outstanding and prices from Bloomberg FTP server. VBA code in Word template pulls SQL Server data to produce filings to SEC, replacing HotDocs software, saving license costs and eliminating high maintenance efforts associated with it.
• VB.Net and SQL Server application tracks filings and NAIC ratings of held securities.
• MS Access system permits tracking of mezzanine portfolio. Captures partner, issuer, investment, transactions, capital calls, acquisitions and distributions. Produces holdings, cashflow, investment summary and investment summary. Provides IRR calculation for issuer and portfolio.
• Maintain/enhance MS Access data maintenance and reporting system for third party holdings. Tracks trades. Provides oversight of and reconciliation with custodian. Prices securities. Tracks benchmarks. Generates monthly client reports, including investment portfolio compliance, asset values, performance, inventory and transactions. Automated customized client reports in Word VBA, which pulls in assorted Access reports into a single document, allowing distribution of single PDF file.
• Extract accounting data of holdings of internal John Hancock customers from mainframe system on daily basis and third party customers from MS Access system on monthly basis into SQL Server. Created MS Access front end to monitor portfolio status in terms of amounts, ratings and allocation at portfolio level. Facilitates oversight of accounting area transaction processing. Measures exposure from slew of perspectives, such as quality, industry, national origin and user defined groupings. Produce amortization schedules from transactions and sinking funds. Report on sales and resulting gains and losses to various management committees. Feeds monthly pricing of securities and problem loan review application.
• key risk management tool. MS Access front end to SQL Server back end providing problem loan review monitoring by management to help shape strategic thinking to minimize losses. Feed by Holdings system, permits quarterly analyst writeup of various business categories. Maintains history of positions and commentary, facilitating trend analysis. Review of rating changes affects reserve levels. Standardizes output for each industrial team, streamlines data collection, reduces errors and facilitates grouping at the department level.

Systems Analyst / Developer / DBA

Confidential, Boston, MA

Responsibilities:

• Visual Basic and SQL Server application allowing browsing/editing of all aspects of portfolio management in a centralized fashion. System currently used internally, but will be made available to clients to permit them to monitor portfolio results/strategy and provide feedback electronically.
• Visual Basic and SQL Server application aggregating financial data in user defined fashion over varying timeframes and levels of aggregation. Performed different financial analysis such as ROR and IRR calculations (nominal and real). Created an extract that fed an industry indexing system.
• Conducted sessions with business users to map data requirements of business. Subsequently created structures within SQL Server.
• Visual Basic and SQL Server application allowing browsing/editing of company data, associated contacts and call reports. Provided contact selection, which fed Word macro application for used for mail merges.
• Extracted administrative assistants to be accounting data from mainframe system on quarterly basis in SQL Server. Visual Basic application facilitated a variety of accounting needs, including data verification and quarterly financial system by allowing user to query for individual transaction components over varying timeframes and levels of aggregation.
• Visual Basic and SQL Server application allowing group members throughout all regional offices to view all members schedules, make appointments, accept invitations and update their own calendar. Tied into ccMail as a redundant backup to system invitation.
• Visual Basic and SQL Server application allowing browsing/editing of property disposition process. Measured performance of each step of process against goals. Created reports for voting committees.

Systems Analyst / Developer / DBA

Confidential, Boston, MA

Responsibilities:

• Visual Basic and SQL Server application allowing browsing/editing of extracts from participating business areas within sector. Permitted sharing of information between business areas and centralized data retrieval for sector level officers.

Systems Analyst / Developer

Confidential, Boston, MA

Responsibilities:

• Maintain and develop mainframe and PC systems (Paradox, SQL/DS, IMS, Focus, Cobol, PL/1, Rexx and APL).

Computer Programmer

Confidential, Piscataway, NJ

Responsibilities:

• Created and maintained PL/1 programs front-ending IMS databases on MVS mainframe.

Accountant

Confidential, Cambridge, MA

Accountant

Confidential, Boston, MA

Public Accountant

Confidential, New York City, NY