Developer Sql Server
Resume:
Minh Ishihara
**********@*****.***
Experience Summary
A Microsoft SQL Server developer with several years of database development experience
including strong hands development knowledge utilizing Microsoft SQL Server 2008, 2014, MS
SSIS, SSRS, DTS, ETL Microsoft Dynamics and other Enterprise ERP Systems.
Programming Languages
C#, WCF, VB.NET, C++, Adobe Flash Builder, JavaScript
Development Methodologies
Agile, SDLC, AND Waterfall
Databases
Microsoft SQL Server 2008 R2, 2012 and 2014
Web Technologies
HTML, XML, XSLT, Ext.Net, SignalR and Google Polymer
Frameworks
Entity Framework, ADO.NET
Reporting / ETL Tools
Microsoft SSRS, SSIS
ERP
Microsoft Dynamics 2010
Work Experience:
Pratt Miller Engineering March 2014-February 2015
SQL Server T-SQL Developer
• Performance tuning and analysis of stored procedures.
• Refactor stored procedures to accommodate new business requirements.
• Refactor SSIS packages to accommodate new user requirements.
• Created Web Desktop interface for tracking and managing error patterns.
• Created dashboard for viewing status and metrics of race team operations.
• Created CLR to expose RegEx so that it could be used by development team via SQL.
OldCastle Materials, Inc. November 2013-January 2014
Application Developer
• Performance tuning and analysis of stored procedures.
• Created multi-thread C# desktop application which can be used to stress test stored procedures.
• Created C# interface to Proactis to move data between multiple servers without the use of linked
servers using XML as the transport mechanism.
Swisher Hygiene International February 2013-September 2013
Application Developer
• Developed several TSQL integrations to push and pull data from MS Dynamics.
• Provide data integration for a large ERP System (Great Plains) and Microsoft SQL Server.
• Created custom TSQL solution to port AP data for accounting consolidation effort.
• Created several TSQL based alerts (SQL Job Engine) to notify staff of data issues.
• Developed process to generate service calls in MS Dynamics in a timely manner.
• Extended a SSIS package to provide custom statements to Quick Trip.
• Created several integration solutions for MS Dynamics 2010. Debugged and enhanced various
scripts and procedures for performance issues.
• Supported the data functions for the Accounting line of business which included understanding
and gathering functional and business requirements.
Independent Consultant November 2012-January 2013
Freelance Developer
• Developed online asset tracking software for medical industry using Flash Builder 4.5, Javascript
and HTML.
Masterplan, Inc. June 2006-November 2012
Senior Developer / Microsoft Dynamics Administrator
• Instituted disaster recovery model to ensure continuity of business processes. Automated SQL
backups / restore process using SQL job engine and several TSQL procedures.
• Implemented log shipping as part of DR model as well as replication for reporting.
• Developed several monitor alerts to inform team of critical SQL performance issues.
• Developed CLR for zipping/unzipping of large data files. Developed C# extension to integrate
data with MS Dynamics 9.0.
• Created inventory upload desktop utility in C# to quickly upload customer medical inventory.
• Developed automated billing process using JP Morgan’s Xign interface for MS Dynamics using
C# / TSQL.
• Created online asset tracking interface using Flash Builder 4.0. and developed numerous SSRS
reports to ease extracting data out of MS Dynamics 9.0.
• Managed production SQL Server instances for entire enterprise. Identified and enhanced /
rewrote poorly performing stored procedures.
CollectTech April 2002-April 2006
Senior SQL DBA / Developer
• Developed extract and transform process as part of ETL initiative for enterprise data warehouse
using TSQL, C#, XML and XSLT.
• Assisted in design of star-schema data warehouse.
• Assisted in the re-design of disaster recovery model for enterprise’s 1.5 terabyte SQL database.
• Wrote numerous stored procedures for enterprise’s collection platform that spanned several
database and servers.
• Created numerous SSRS reports for consumption by CollectTech’s collection platform.
• Created several DTS/SSIS packages to move, scrub and export data to and from various
CollectTech clients.
Sempra Energy March 1998-March 2002
Senior SQL DBA / Developer / MS Dynamics Admin
• Wrote various procedures to extract and normalize data for Financial Accounting / Reporting to
expedite their month-end closing procedures.
• Developed backup and restore procedures for MS SQL 6.5/7.0 for disaster recovery.
• Developed web-based integration between MSSQL and Oracle 8i that assisted gas/electric traders
in identifying several metrics regarding Sempra Energy’s liability and cash position of any given
purchase made on the spot-market.
• Used ASP, VB 6, TSQL and Crystal Reports.
• Created interface for Sempra Energy’s ERCOT billing system that allowed for the secure
download of billing data from ERCOT using WinHTTP SDK to generate custom billing
statements for their clients.
• Developed Y2K bug tracking utility using Visual Studio C++ to identify systems within Sempra’s
enterprise that were at risk for the Y2K issue.
• Re-designed their DR solution working with Windows Server administration team to use weekly
full backups, daily differential backups and 15m log backups that were pushed to SAN using
Backup Exec.
• Created SQL alerts to identify SQL performance pressure points. Debugged and enhanced
procedures as-needed.
Transamerica 1994-1998
Senior Programmer / Analyst
• Developed interface to pull data from AS400 into SQL 6.0 using VB3 and Intersolv ODBC driver
and RUMBA SDK.
• Developed in-house online ordering system for supplies and documents using VB3 and Crystal
Reports. Later migrated to VB4 and SQL 6.5.
• Developed delinquent notification utility using VB4/5 and RAS to allow mortgage companies and
banks to notify mortgage holder that they were delinquent on mortgage.
• Developed contacts database / front-end that allowed Transamerica representatives access from
the field. Used VB4/5 and SQL 6.5.
Education North Hollywood High 1986
Contact this candidate