PROFESSIONAL SUMMARY

Application and database development professional with expertise in object-oriented programming, relational databases, designing, and implementing client-server software solutions. Highly organized, great communication skills, service-oriented team player, who enjoys working with multiple programming languages and technologies.

Programming: VB.NET, VBA Excel MSAccess , SSIS/DTS, SSRS

Exposure To: C , ASP.NET, HTML, and XML

Technologies: Visual Studio 2005, 2008, and 2010

Database Systems: SQL Server 2000/2005/2008/2008R2, Oracle, MSAccess, and DB2

Database Connectivity: OLEDB and ODBC

Database Object Models: DAO, ADO, ADOX, and ADO.NET

Financial/Analysis Systems: SAP, PeopleSoft, and Fermat

Blending/Scheduling Systems: AspenTech Orion-MBO

Real-Time Data Systems: OSIsoft PI

CRM Systems: Saratoga CRM iAvenue

Software: MS Excel, Access, Word, and PowerPoint

• SQL Server/Oracle: SQL scripts/batches , stored procedures, cursors, triggers, sqlcmd, and xp cmdshell
• ETL: SSIS and DTS
• Database/Application Development SQL Server / Microsoft Access
• Reporting Tools: SSRS Basic Level
• DBA Jr. Level - Management, Monitoring, Security, Administration
• Object orientated programming, relational database concepts, and .NET Framework
• VB.NET Intermediate proficiency
• VBA for Excel and MSAccess Advanced proficiency
• Visual Basic 6.0 Intermediate proficiency
• C , ASP.NET, HTML, and XML Basic proficiency
• Scripting: VBScript .vbs
• Command Line Utilities: DOS Commands and BCP
• HelpDesk/Desktop support using Maestro and Remedy Tracking Systems

PROFESSIONAL EXPERIENCE

.NET/SQL Server/SSIS Consultant

Confidential

• SSIS ETL package development and file system/package store deployments for processing banking data from DB2/Oracle/SQL Server source systems into SQL Server 2005 databases and data warehouses for reporting.
• SSIS package development to create custom extract files and reports Excel, CSV/TXT
• SQL Server 2005 development - db tables constraints, defaults, and indexes , stored procedures, functions, ad-hoc queries, including OPENQUERYs utilizing linked servers.
• SSRS Reports report modifications and basic report creation utilizing shared data sources
• Excel interface and functionality enhancements to multiple HomeEquity/CreditCard/Billing applications utilizing VBA.
• Modify ADO database connectivity within Excel interfaces to extract data from new and/or multiple datasources SQLServer and Oracle .

Confidential

• DTS to SSIS package conversions Package Migration Wizard custom modifications
• VB.NET, Excel VBA, and MSAccess development/enhancements, utilizing OLEDB/ODBC database connectivity SQL Server/Oracle/DB2 .
• VB6 to VB.NET code migrations
• Saratoga CRM Migration iAvenue Windows 2003 Server administration, software installation, unit testing, screen .dvf and schema .dbd enhancements
• Document BLOB migrations into SQL Server 2008 utilizing Saratoga DBAdmin utility
• Actuate-BIRT BI Upgrade Windows 2003 Server administration, software installation, application configurations, report migrations, and unit testing
• Special Project: ColdFusion - Interface and functionality enhancements to several web- applications Outage Notification, Business Online Enrollments, and Enrollment Stats

Confidential

• SSIS packages develop/test/migrate/deploy - financial, transactional, and operational data from various input sources txt, csv, Excel, Access, SQLServer/Oracle, and Web to create custom output files for integration into FERMAT system.
• SSRS Report enhancements to several existing reports, including basic report creation
• Back-up for executing custom Fermat scripts to create/register database objects.

Confidential

• WinWard Project Implementation - SSIS package development, conversion, and enhancements to perform daily batch load operations of critical Medicare/Medicaid data into new database system.
• Basic SSRS report enhancements changing datasources, adding fields to existing reports.

Confidential

Interface Specialist/ SQL Developer

• Created numerous custom VB.NET, C , Excel VBA and Access VBA interfaces, including custom class objects, sub procedures/fuctions, hashtable/dictionary/enum objects, and OLE Automation Excel Object Model to implement interface functionality.
• Converted existing Excel VBA interfaces to more robust VB.NET version.
• Functional and GUI enhancements to C and Excel/Access VBA applications.
• Incorporated OSISoft PI data into .NET and Excel VBA interfaces using PI SDK dll and PI Excel Data Link Add-In.
• Incorporated Orion-MBO SDK DLL into .NET WinForm interfaces
• Implemented menu/toolbars, simple/complex databinding datagridview and other controls to facilitate user interaction within interfaces.
• Windows Registry and .NET MySettings environment for storing and retrieving users interface settings.
• ADO.NET/OLEDB/ODBC objects to establish database connectivity to external source systems Oracle, SQL Server, Excel, Access, Web, CSV, Text, FlatFiles, STF .
• Technical resource for investigating and resolving production related interface issues.
• Documentation: Instructional, technical, and mapping table documentation for all interfaces.

Confidential

• SSIS package development to replace/streamline existing interfaces using multiple control and data flow components ExecuteSQL, Foreach Loop, Execute Process, File System, Script Task, Derived Column, Conditional Splits, LookUp, Cache Transform, Data Conversion, Script Component, Sort/Merge/Union All, FTP, and Row count.
• SSRS report development SQL Server data source
• Administration: Create/Maintain site databases and mapping tables for model development. Perform db back-ups and restores.
• Security: Set-up and maintain server/database security i.e. Windows security groups, logins, mapping users, roles, permissions, and create service accounts
• Server Administration: Set-up and maintained replication utilizing asynchronous mirroring for production servers to ensure data recovery. Establish linked servers to SQL Server and Oracle databases
• Monitoring: Set-up jobs and alerts for monitoring disk space usage
• Maintenance: Set-up jobs to perform database back-ups, purging/trimming tasks utilizing SQL scripts and custom stored procedures.
• Support: Ad-hoc queries T-SQL, PL/SQL, Access SQL , and OPENQUERY statements, UDF's, stored procedures, SSIS packages, cursors, and triggers as needed for interface development.
• Other responsibilities: Development of SMO app to help site modelers and Orion support team to perform ad-hoc database back-ups and restores.

Confidential

• Converted RevCast security model to role-based access and automated security requisition process.
• Develop/Execute DTS packages, stored procedures, batch jobs to perform large data loads from data warehouses Onynx, FIN to import actuals into RevCast, NIT, and Import PPT Count Tools.
• Create ad-hoc SQL queries and scripts, import/export data using BCP and DT tasks for report generation, and utilize ODBC/OLEDB for database connectivity.
• Create custom Visual Basic and Access VBA code to automate business processes, and incorporate ActiveX Controls spreadsheet control to enhance Access GUI.
• Code migration to UAT and Production environments
• Technical support utilizing Maestro and Remedy Systems for issue tracking.
• Other projects: graphical and functional enhancements to web-based reporting tool Shared Services Cost Transaction Info. Center utilizing ASP.NET.

Confidential

Database Developer

• Developed Microsoft Access 2003 Database application to capture critical product specification data to populate database tables for tracking product development, simplify data entry, enhance querying capabilities, facilitate report generation, and automate form creation ECN, ECR, and PMA Work Order Forms via Access-Excel Automation VBA .
• Additional project work included database table creation, forms/reports development, queries, macros, and code modules objects to create customized functionality.
• Conducted several training session with Engineering Staff to demonstrate new functionality.

Confidential

Visual Basic Programmer

• Development to update an highly complex Excel / VBA application / VB 6.0 Gas Cost-Gas Charge Model used for analyzing, forecasting, and generating schedule filings for submission to ICC on monthly basis to determine Gas Pricing.
• Analyzed existing model to determine effort of work to convert model to new GL accounting structure SAP to PeopleSoft .
• Interacted with business to gather requirements, map requirements, develop technical and functional specifications, code, test, debug, and migrated app. into production.
• Enhanced application GUI and functionality to retrieve data from multiple external resources flat files .CSV and .TXT, Excel, SAP Extracts, and PeopleSoft using DTS Packages and stored procedures.

Confidential

Visual Basic Programmer/Analyst IT Core Shared Services

• Developed complex Excel solutions for Corporate Shared Services - Accounting. New application development 40 , enhancements and technical support of existing applications 60 . VBA/Database programming to retrieve data from linked/remote servers i.e. SQL Server - SQL, Oracle PL/SQL, and DB2 databases using gateways, database links, synonyms, and ADO to create interactive reports and facilitate data manipulation within Excel.
• Extensive SQL Server programming: queries, batches, scripts, stored procedures, cursors, functions.
• Special Projects Business Metric Automation, Migration Projects Excel 2000 to 2003 and Access 97 to 2003 .
• Light DBA tasks: Jobs, Alerts

Confidential

Application Developer

• Development of VB/VBA tools and highly complex Excel spreadsheets to serve as back-up system to proprietary web-based system PJM .
• Utilized advanced Excel functions, user-defined functions, and custom VBA code to automate the process of generating and reconciling supplier eSchedules.
• Converted/transformed numerical data into different eCapacity file upload formats .CSV, .TXT, and XML files related to Schedule Reconciliations, Peak Load, Internal Schedules, and Bus Aggregates.
• Developed small VB 6.0 application used to retrieve and view data from external database sources.

Confidential

Technical Analyst

• Created custom applications involving Visual Basic interfaces connected to ODBC/OLEDB data sources MSExcel, Access, SQL Server to assist in oversight of Energy For Tomorrow Program and implement 16 Renewable Energy Development Programs Budget - 6.1 Million .
• Provided technical expertise assisting in financial analysis of budgetary data, converting data to structured format, pivot table generation, database queries SQL Server, Access, CSS, and iAvenue , budget tracking, and report generation SAP .

Confidential

Database Developer

• Gathered and analyzed requirements to create tools for automating and streamlining business processes using Visual Basic, ADO, ActiveX Controls, and SQL statements.
• Developed automated database application utilizing VB 6.0 and Microsoft Access to track legal matters and generate monthly/annual highlight reports.
• Created complex Excel spreadsheets utilizing custom VBA code for automation, advanced formulas and functions Pivot Tables, VLookUp, Text, Database, Logical, Date/Time , charts, graphs, hyperlinks.
• Minor web page development Java , department contact for technical support/problem resolution of general software and computer equipment issues.