EXPERIENCE SUMMARY:

Talented IT Professional with strong SQL Server Stack development experience and DBA cross-over skills. Over fifteen years of commercial programming experience with SQL Server, SSIS, SSRS, Fact/Dimension data modeling, VB, MS Access, and Excel VBA programming with a focus on Sql Server related development using t-sql and stored procedures. Latest experience includes SSIS package development including architectural decisions, conversions of DTS and SSIS 2005 to Sql Server 2008 R2 as well as performance tuning via report data cache tables, indexing, efficient data and design techniques. Creating T-SQL/DTS/SSIS processes for data export/transformation/load and automated, flexible reporting using cascading parameters in SSRS in conjunction with data-driven subscriptions is part of my skillset. I have over twenty-four years of business experience with major insurance, mutual fund, manufacturing, healthcare, financial service and other companies.

TECHNICAL SKILLS:

• Languages: T-SQL, PL/Sql, Visual Basic 6.0, UML, Visual Basic for Applications, VBA, ADO, DAO, XML, VB.Net, C .Net Hardware: PC Compatible
• Operating Systems: Windows 7, Windows XP , 2008 Server, 2003 Server, NT, x32 and x64
• Ancillary Skills: Ms SQL Server 2000 , 2005 , 2008R2 , TFS , Query Analyzer, Enterprise Manager, Sql Server 2005/2008 Management Studio, Visual Studio for SSIS and SSRS , Microsoft Sql, Sql Server Business Intelligence Development Studio, BIDS, Sql Server Integration Services, SSIS, Data mapping, Data modeling, Crystal Reports 9, Seagate Info7, Ms Access, Custom Reporting, Ms Office automation, NT 4.0, Tomcat, MySQL, ODBC, ActiveX, Sybase, SQL, T-SQL, database design, table normalization, stored procedures, batch processing, Rational ClearQuest, AlphaCam CAD/CAM, WinAPI, Demosheild 5.0, Photoshop 4.0, Mediastudio 2.5 AVI Editor, .wav editing tools, Microsoft Sharepoint, VMWare , Windows Server 2008, BI xPress
• Methodologies Techniques: Prototyping, JAD, Software Development Life Cycle SDLC, CMM Levels 1 2, Agile Development Methodologies Scrum

EXPERIENCE:

Confidential

Title: Sr. SSIS/SSRS Sql Server Developer

• Projects: Created database components for waste tracking as well as price estimation systems.
• Trouble-shoot data and ETL issues, day-to-day. Train new-hires. Interact with Kiwi MAP, Kiwi ESP, AS400, Amtech, Oracle and other databases in relation to the RockTenn data warehouse. Function as a general resource converting SSIS 2005 packages to SSIS 2008 R2, re-architecting existing packages to meet current standards which I helped to create , building new SSIS packages, stored procedures, functions and SSRS reports for executive level and company-wide data warehouse reporting. Re-built production reporting processes to use cache tables to hold daily results for enhanced performance as well as SSIS package and logic to rebuild this cache data as needed due to source system data changes. Created release management installation scripts as well as rollback scripts for installations into production. Implemented SSIS standard best-practices including the use of database-driven package variables table used to increase the re-use and minimize re-coding of SSIS packages for extracting and loading data warehouse staging and final tables. Converted DTS sql server 2000 to SSIS 2005 and 2008 R2 which required the rebuilding of script tasks in vb.net, using database-driven variable/parameter population, a comprehensive error and table count logging as well as light-weight email notification on error used for SSIS error handling.

Confidential

Title: SSIS/Sql Server Business Intelligence Developer

Project: Create flexible SSIS structures for the movement for source system data Cisco, iSeries, eWFM, Kronos, Aspect, Avaya to operational data store on Sql Server 2008R2 platform through company standard staging area. Accomplishments: Using the existing company ETL architecture including use of BI xPress third-party auditing software, built re-useable SSIS package for logging/audit and movement of table data to vertical bar delimited flat files. Built re-usable SSIS package including very small, simple field mapping child packages to move data from flat files to Sql Server staging area tables with no transformations. These re-usable components are table-driven and only required the new tables/file names to be input in setup tables. The child field/data type packages are simple and take about an hour to create and unit test. These structures allow any sql server table, view or any flat file data to be loaded without the creation of new SSIS packages. Built time dimension not date dimension in order to create thirty minute block report using Cisco Termination Call Detail table for cradle-to-grave call center reporting.

Confidential

Title: SSRS/T-SQL/Business Intelligence Developer

Database administrator Resume Profile CA

Accomplishments: Gathered specifications for migration of Actuate reports to SSRS. Installation and setup of VMWare on local development computer with Windows Server 2008 and Oracle 11g. Document existing reports and PL/Sql from Actuate Report Designer using Oracle Sql Developer. Worked with client to establish development environment database and version control SVN Subversion full development permissions for Ensynch development team and gain access to any existing documentation. After assessing and clarifying the specifications of the MIR departments report migration components and recommending that embedded PL/SQL be converted to Oracle stored procedures and functions, I informed Ensynch that they would be better served with a SSRS developer with PL/SQL development experience. Converted four Actuate reports to SSRS and uploaded to development Report Server. Created PL/SQL function for handling SSRS comma separated parameter lists and built one Oracle stored procedure for report conversion before migrating off project. Rate: 115. per hour plus expenses.

EXPERIENCE:

Confidential

Title: T-SQL/ETL/Business Intelligence Developer

Validate, test, enhance and document complex 100 stored procedures for company's Customer Loyalty Rewards programs within Sql Server 2005/2008. Research problems/symptoms within the code and suggest resolutions. Architected, designed and built custom, re-useable test harness in SSIS and T-SQL code for pulling production data, manipulating data to confirm to use case conditions and loading it into base-line table in the DEV environment in order to run/test the existing Loyalty program. This included table and data design, understanding company's data and the existing Loyalty Program implementation within SSIS as well as the stored procedures which spanned five different databases and two servers.

Confidential

Title: T-SQL/ETL/Business Intelligence Developer

Build custom stored procedures, trouble-shoot and resolve issues with existing data warehouse and SSIS processes. Build reports in SSRS and enhance/trouble-shoot existing reports. Build new SSIS packages to import Excel files into data warehouse. PK lookup, data conversions, slowly changing dimensions and conditional splits involved. Understand complex, undocumented business rules from t-sql code in order to re-build existing processes. Sales force compensation-related data.

Confidential

Title: T-SQL/ETL/Business Intelligence Developer

Created multi-layered SSIS packages for gaming industry business intelligence systems sold by TechResults. The architecture involves three stages: an initial direct copy of the source system data to the BI source database no transformations a secondary copy of the data from BI source to BI staging tables where casino management system data was inserted in addition to datatype, lookup, default value and rowaction status insert, update transformations. Rowaction: After data was transformed to the staging area from the local source copy of data, each row would be marked with a 1 for insert, 2 for update or 0 for no action by a separate user stored procedure finding new records, existing records that had changed CheckSum and records that would not be used a final update or insert over to final data warehouse tables ready for SSAS processing into cubes. SSIS configuration was highly flexible as initial DB connect was made through a single XML file with the primary databases connection string. All other paths, connections and variables were passed from parent package to child package via a standard set of SSIS variables. Each package level error handling was implemented by two user defined stored procedures which used a combination of system and user SSIS variables to log execution information as well as any error generation. For/Each containers were used to loop through multiple properties for each casino client, thus creating a re-useable structure to use for any TechResults customer no matter how many casino properties they operated. In addition to documenting an existing group creation wizard built in VB 6.0 and Sql Server by reverse-engineering, I created entity relationship models for this new schema for the newest version of the back-end architecture for TechResults products. I also built a MsAccess configuration application with linked tables to the System schema used by TechResults installers to configure the schema's tables with all necessary information needed prior to operating TechResults B.I. products. This two month contract was a push to complete by deadline relative to a proof-of-concept in Macau, China for a potentially very large customer for the client. Code was managed with Team Foundation Server TFS . Used Sharepoint within company intranet to communicate knowledge base and general documentation for department. Oracle data source configuration in SSIS.

Confidential

Title: T-SQL/ETL/Business Intelligence Developer

Build/Enhance custom Sql Server Jobs passing parameters to custom DTS Sql Server 2000 and SSIS Sql Server 2005 packages using ActiveX scripting vbscript pulling data from Oracle, Portia and other Sql Servers. Create/Enhanced stored procedures to meet current business needs. Enhance current architecture for re-use. Create Sql Server Reporting Services reports in Sql Server 2005 Business Intelligence Development Studio with cascading parameters, and drill-down capability. Production support tasks to investigate, understand and resolve failing production sql server jobs, DTS , stored procedures and reports. Performance tuning of stored procedures. Scipting and testing of all database objects developed for QA and PROD installations. Consult with BA's and PM's on solution specifications and System Architects on database/processing design. Built database and sql server processing for Anti-money laundering department web application which included business rule implementation, archiving, database design, software design documentation, complex queries and other SDLC requirements. Worked with team of developers to coordinate development standards and interfaces as well as QA, UAT and system testing. Used Sharepoint within company intranet to communicate knowledge base and general documentation for department

Confidential

Title: SQL Server / Sql Server Reporting Services Developer

Build/Enhance custom Sql Server Jobs passing parameters to custom DTS packages using ActiveX scripting vbscript . DTS packages created tables, pulled table data into flat files, activeX script to copy exported files into other server locations, ActiveX script to set parameters for secondary DTS package that uses vbscript to FTP files to customer servers. Create/Enhanced stored procedures to meet current business needs. Enhance current architecture for re-use. Create Sql Server Reporting Services Sql Server 2005 reports in Visual Studio .NET. DTS packages with special logic to create multiple MsExcel tabs based on record count. Production support tasks to investigate, understand and resolve failing production sql server jobs, DTS , stored procedures and reports. Performance tuning of stored procedures. Scipting and testing of all database objects developed for QA and PROD installations. Consult with BA's and PM's on solution architecture. Used Sharepoint within company intranet to communicate knowledge base and general documentation for department

Confidential

Title: SQL Developer / VBA

• Built SQL Server Reporting Services reports Sql Server 2005 and data-driven subscriptions which automatically email reports via a table of user email address based on NT Logon names.
• Researched and implemented proof-of-concept SSRS reporting using 3rd party rendering tool which allow data-driven export to Excel providing ALL Excel formatting capabilities. This extended the SSRS Excel export capability.
• Built custom reporting/analysis application using SQL-Server 2000 backend and Ms Excel as front-end. This involved custom VBA coding, construction of stored procedures called from VBA, WinAPI to check network connectivity, table design, indexing, loading of data using in DTS triggered by a SQL job.
• Table-based security, with NT security groups, user/admin roles as well as Excel sheet and code security used throughout application.
• Adjusted XML files within context of automated RosettaNet ETL process
• Additional duties included scripting column additions across multiple databases, scripting stored procedure changes, index changes on tables for use in production environment as well as other script-based database changes and enhancements.

Confidential

Title: SQL Developer

• Build DTS Job Monitoring archive/reporting process in SQL Server 2000
• Enhanced/modified/adapted custom ETL Extract, transform, load process using VB.NET to monitor user designated folder s , load newly drop files in SQL-Server database table, then pre-process data for compliance with business rules.
• Reduced processing time of critical daily download from 24 hours or more to less than two hours.

Confidential

Title: SQL Developer / VB

• Created several pages of t-SQL script to clean, transform client SQL server 2000 database
• Developed small, VB application which allowed user to define setup lists within multiple dataforensics applications before downloading info to PDA for field work
• Updated Ms Access databases used in the UK to conform to new laws using embedded SQL run from VB code on front-end application
• Enhanced processing, user interface and reporting in Plog application and Pwell applications.

Confidential

Title: SQL Developer / Testing

• Analyze and sometimes enhance very complex SQL-Server stored procedures,
• Create formal test cases including, data builds, test documents, and test data for CCE's Uniform Forecasting Planning web-based software.
• Main task was to replicate the SP logic in Ms Excel as part of testing process.

Confidential

Title: SQL Server Developer

• Created commission processing for SnapPay OTC stored value card system.
• Included table-driven base24 transaction code to ITCFS sub-service conversion processing.
• Built system import from DB2 of daily transaction data. Flat file export of ITCFS data for bank reporting. Automated import from flat files of merchant terminal data as well as logging of import results. Completed ACH process transferring money from merchants to ITCFS on a daily basis. DTS automation of tasks with automated email notification.
• Views, Stored procedures, adaptation to changing specifications, working with business analyze and Crystal Report writers.

Confidential

Title: SQL Server Developer / Analyst

• Using SQL-Server 2000 and custom Ms Access reporting tools, BIG needed to retrieve and clean up the existing database of hardware inventory for a complete reconciliation and write-off of poorly maintained data inventory.
• Worked with little guidance initially, I stripped the existing data of duplicates, bad serial numbers and null values creating various buckets of data for management to review.
• Automated this cleanup and reporting process through T-SQL, DTS and a custom Access reporting database.
• As management came to understand the data issues involved, we worked together to reconcile the existing system data with and in-progress physical site inventory.
• BIG management is actively considering the replacement of the existing inventory system in order to address data integrity issues and enterprise needs.

Confidential

Title: SQL Server Developer

• Converted and all Microsoft Access queries and VBA code to T-SQL using Enterprise Manager and Query Analyzer as lead in the conversion of a legal compliance verification system used in bond trading.
• Developed a custom Ms Access application to validate new system data against production data. Built a VB.NET test harness to test the allocation processes.
• Created sixty-eight Crystal 9.0 reports using existing Access reports as specification many of which involved nested sub-reports and complex T-SQL stored procedures.
• Coded complex data import processes in T-SQL and used DTS packages - Data Transformation Services and Maestro to orchestrate the daily execution.
• Documented system processes in Visual Mind graphical organization software for easy reference to design, process and construction.
• Introduced and nurtured Agile software development concepts to management and the team which are now being pursued across ING Americas on a trial basis.
• Primary reporting and data processing delivered ahead of schedule.

Confidential

Title: Ms Excel Developer

• Created new CPMF tool used by Quality Dept.
• This tool allows a project mgr. to select a project type and view all steps, instructions and related forms/templates for that project/size type and document progress through these steps.
• The tool makes use of VBA coding, UI Data separation for reuse and requirements gathered directly from the project manager.

Title: Software Engineer

• Unit Investment Trust Accounting System JH Funds
• Provided enhancements/fixes to the current custom Ms Access application using VB6
• Designed solutions using re-usable techniques including: In-process DLL components, table-driven reporting and out-of-process off the shelf components using VB6. Example: Created an automated transaction repost process which reduced one day's labor to an hour.
• Designed and implemented User Interfaces and created custom reports using Ms Access, VBA and Crystal Reports

Confidential

Title: Lead Development Engineer

• ORDER ENTRY W/ CAM TIE-IN PROJECT
• Responsible for database design 80K custom order entry/processing system with computer aided machining tie-in using VBA and VB6
• Prepared data and designed databases and DB tables using Ms SQL
• Designed and construction of User Interface using ActiveX controls, VBA and VB6
• Designed/built custom Ms Access and Crystal Reports using VBA and Active Reports
• Assisted in the writing of business requirements documents
• Directly engaged in client relations and technical support.

Confidential

Title: Programmer/Analyst

• Created custom reports using Ms Access, VBA and VB6
• Constructed add-on applications for users to access report data, SQL, stored procedures and ActiveX controls
• Developed ad-hoc reports and designed ad-hoc queries for decision support using stored procedures
• Maintained database and user access security and administration using NT and Ms Access security
• Resolved user issues in helpdesk function

Confidential

Title: Consultant/Developer

• Trained in PowerBuilder 5.0/6.0 for five weeks in preparation for a project later cancelled by client and created prototype U.I.'s in VB5
• Designed and developed over 90 of company's marketing CD 4.5 months using Demoshield, Photoshop, .AVI editors and .WAV editors.
• Optimized web page relative to key word searches by primary search engines 2 weeks using HTML
• Assessment of PORTIA investment management system for functionality

Confidential

Title: Programmer/Analyst

• Learned Crystal Reports 5.0 for the reformatting reports on company's INSIGHT Internet product.
• Created Ms-Access database to track department owned hardware.

Confidential

Title: Business Analyst and MsAccess Developer

Confidential

Title: Account Executive