SUMMARY

Senior IT Professional with established achievement leading the development and implementation of IT solutions that increase organizational effectiveness. Experience with Database Design and Administration of Microsoft SQL Server, Visual Basic and C Development. Key strengths include project management experience, team leadership, problem resolution and diverse industry experience, excellent analytical, communication and interpersonal skills, good presentation skills and an experienced team player.

TECHNICAL SKILLS

RDBMS: Microsoft SQL Structured Query Language Server 2014, 2012, 2005, 2008, 2000. Oracle 10g, 9ei, AS/400, Erwin 7.3, Microsoft Access 2007, 2003, 2000, 97

PROGRAMMING

LANGUAGES: TSQL Transact SQL , C C Sharp , PL/SQL Program Language/SQL , DB2, VB Visual Basic 6.0, XML Extensible Markup Language , HTML Hyper-Text Markup Language , Fortran Formula Translating System .

SOFTWARE/TOOLS: Visual Studio 2012, 2010, 2008, 2005, SQL Data Tools SSDT , BIDS Business Intelligence Data Tools , TFS Team Foundation Server , ETL Extract Transfer and Load , SSIS SQL Server Integration Services , DTS Data Transformation Services , SSAS SS Analysis Services , SSRS SS Reporting Services , IIS Internet Information Services , ADO ActiveX Data Object , OLE Object Linking and Embedding , OOP Object Oriented Programming , MDI Multiple Document Interface , DAO Data Access Object , ODBC Open Database Connectivity , DSN Database Source Name , API Application Programming Interface , OOED Object Oriented Event Driven , Windows Installer, Visual Studio Installer, Microsoft Office Developer, Visual Studio Developer, Microsoft Frontpage, Oracle Discoverer, Access VBA Visual Basic for Applications , Excel VBA, Project VBA, Sharepoint, Redgate, Parallel Data Warehouse PDW

OPERATING SYSTEMS: Windows Enterprise Server 2000, 2003, Windows 7, Vista, XP, NT 5.0 / 4.0 / 3.5, 9.x / 3.x, MS DOS DiskOperating System .

PROFESSIONAL EXPERIENCE

Business Intelligence Developer

Confidential

• ETL developer, SSRS developer, TSQL, SSIS, TFS
• SSIS package design, VS 2012, 2010, 2008, Instrumental in implimenting Change Tracking and Change Data Capture, Data Flow Memory Management: DefaultMaxBufferSize, DefaultBufferMaxRows, Rows Per Batch, Maximum Insert Commit Size, Engine Threads
• SSMS: Merge operations, subqueries, common table expressions, row number over expressions
• Control flow tasks: For Loop and Foreach Loop Container, CDC Control Task
• Data flow components: Conditional Split, Merge, Merge Join, Multicast, OLE DB Command, Script Command and Union All, CDC Splitter, OLE DB and ADO Net Source and Destinations, Logging, Package configurations
• Customer, EFT, Employee, General Ledger, Billing, Great Plains, Ceridian, Sales, Billing, Active Directory
• Familiarity with PDW, RoamBI, MicroStrategy, Embarcadero, Redgate, PowerPivot
• 6 Terabyte DW server

Confidential

Project Management

• Data management and administration of Proposal data in Boeing proprietary platform, Project Integration Management System PIMS .
• Complex Access, Excel and VBA development for analysis of DCAA Defense Contract Audit Agency audits of proposals.
• For DCAA analysis used MS Access and Excel, ADO, DAO, VBA in Access and Excel, API, OOP, OOED, Collections and Methods, Excel Reporting, Access Reporting and Sharepoint.
• MS Project VBA to enhance proposal, project management and metrics reporting.
• Reason for leaving: Completion of Contract

Database Developer

Confidential

• VBA design in Access and Excel.
• Utilization of VB, VBA, DAO, event procedures, subprocedures, functions, collection and methods, macros and SQL queries, ADO, API, OOP, OOED, Collections and Methods, Excel Reporting and Access Reporting.
• SQL Server 2005 development, stored procedures in TSQL, SSIS, SSAS and SSRS.

Database Developer

Confidential

• Automation of billing and invoice reports for Ricoh's customer, Los Angeles City departments including Fire, Police District Attorney etc. Data was extracted from Ricoh's Oracle server, transformed and loaded into a local Access db file. Users were given the ability to start an automated print job for all monthly invoices. Reduced the workload to rule out in advance the need to hire two to three new positions that would have been needed in the billing department.
• Developed utilizing of MS Access and Excel, ADO, DAO, VBA in Access and Excel, API, OOP, OOED, Collections and Methods, Excel Reporting and Access Reporting.
• Reason for leaving: Completion of Contract

Database Developer

Confidential

• Implemented and designed the replication of a Siebel Oracle database in Germany on a MS SQL Server local platform for DPD service data worldwide for datamining and automated report production. Modified and created database structure to attain this result. Daily, weekly and monthly reports were produced in a fraction of the time when using the Siebel server. Administrated and developed the MS SQL Server automated job structure to download data daily from the Germany server. This serves as the Data Warehouse for Toshiba America's analysis.
• Made use of controls such as Rich Textbox, Masked Edit, DataList, DataGrid and Windows Common Controls.
• Utilized ETL and Bulk Insert methods to load the data from the Oracle Germany server, TSQL, PL/SQL, SSRS to automate Excel, Access and PDF file reports.
• Utilized SSRS to design reports for most business units of TAIS, Six Sigma Metrics, statistical and demographic analysis.
• Administration duties included configuring SSIS for backup and maintenance, assigning users and passwords. Use of query and performance tuning using tools SQLProfiler, Database Tuning Advisor and Index Tuning Wizard.
• Completed performance tuning of long running TSQL, adhoc Queries, Stored Procedures and Views using IO Statistics, query table joining techniques, indexing and optimization of Where clause structure.
• Conversion of SQL Server 2000 DTS to SQL Server 2005 SSIS / ETL configuration.
• Development of complex SSIS Data migration packages for Excel and Access data.
• SSAS database design using Data Warehouse and Cube concepts fact and dimension tables, hierarchies, utilizing design concepts of On Line Analytical Processing, OLAP : Relational, Multidimensional or Hybrid ROLAP / MOLAP / HOLAP .
• Utilized knowledge of Relational and Dimensional Modeling in the design of either star or snowflake schemas. Including Mini Dimension Tables and Outrigger Tables.
• ETL / DTS process for loading of Data Warehouse aggregated and finely grained fact tables.
• Created complex objects: Views, Stored Procedures, Triggers and Functions.
• Setup database maintenance routines using DBCC utilities as well as complex automated maintenance and backup using SSIS.
• Interaction with users and customers during various phases of the implementations including ETL, reporting and enhancements and debugging.
• Installed and configured Oracle 10g driver on SQL Server platform to facilitate connection between servers.
• Administrated and developed the database and interface of Root Cause Analysis RCA at the Manufacturing Repair Center MRC of Toshiba. Database and interface stored repairs done by the MRC department's technicians and allowed Customer Service Agents to view status of these repairs on MS SQL Server. Managers could also publish reports based on the data.
• Packaged in an installable VB and Access application using a designed Windows Installer software.
• VB and VBA design using event procedures, subprocedures, functions, ADO, DAO, collection and methods, macros and SQL queries. Forms and subform design including popup, modal, message box and custom dialog box design using code-behind-forms in event procedures to produce reports and run-time applications for users.
• Front end and report development utilizing Visual Studio VS , VB, MS Access and Excel, ADO, DAO, VBA, API, OOED and Collections and Methods.
• Further design production SQL Server database for RCA data collection including complex relations between Tables, Views, Stored Procedures and Functions.
• Created DSNs and connection strings to facilitate connections to platforms.
• Utilized concepts of On Line Transaction Processing OLTP : Highly normalized table schemas, transaction processing well developed BEGIN, COMMIT and ROLLBACK statements to accomodate 30 to 100 daily transactions. Formulated system using Atomicity, Consistency, Isolation and Durability ACID .