Experience

Unknown

• Insurance
• 1 - 100 Employee

• Database Developer | DBA

  • Apr 2014 - Present

  • Oversaw 30+ production, QA and development SQL instances (version 2000, 2005, 2008 R2, 2012 and 2014), monitoring and troubleshooting daily SQL agent jobs, to assure backup and data integration tasks were completed. Maintained and developed DTS, SSIS package, VB-Script and batch files for data exchange automation and ETL processes. Applied patches and deployed SQL scripts to fix bugs and product enhancements. • Maintained SQL 2003 clustered instances, Configured and set up SQL 2012/2014 high availability clustered instance, migrated SQL 2000 databases, DTS packages and SQL agent jobs to SQL 2012 environment. Implemented maintenance plans to perform DB backup, rebuild indexes, checking data integrity. • Created SQL tables, stored procedure, SQL views, SQL indexes, Reference Integrity and user permission to support new project needs. Developed financial report by utilizing ShowCase Excel Add-In and VBA codes, IBM I-series access for window and SQL link server. • Migrated and Configured SQL 2005 SSRS server to SQL 2008/2012 SSRS , defined ACL to enhance security, utilized SQL report builder to develop Call Center reports, Performance dashboard for agent hot line and underwriter department, transformed report created by ASP to SSRS, Daily job logs and nightly cycle reports to improve productively. • Working collaboratively with Stakeholders and Business Analyst, translated reporting needs and requirements into detailed technical design and programming specifications. • Migrated Business Object Crystal XI R2 servers to SAP Crystal Server 2013, Implemented KERBORE Single Sign On, created documentations and provide user training. • Provided application support for Oracle UCM, Kofax, SUNGUARD EAS, Infor outbound marketing manager, E. Piphany Data Warehouse server, in-house ACCESS application. • Researched and conducted data analysis to resolve data and production issues. Show less



KOZY SHACK ENTERPRISES, INC. /LAND O’ LAKES INC.,

• Integration Team

  • 2012 - 2013

  Member of selected IT integration team to support and maintain existing systems, worked with Land O’ Lakes project team in planning, migrating and knowledge transfer to assure integration processes were completed in timely manner and within budget. Member of selected IT integration team to support and maintain existing systems, worked with Land O’ Lakes project team in planning, migrating and knowledge transfer to assure integration processes were completed in timely manner and within budget.



Kozy Shack Enterprises

• DBA/Senior Developer

  • 2000 - 2012

  • Planned and deployed Microsoft SharePoint technology to replace existing corporate intranet and extra-net, customized and implemented workflow to roll out Help Desk call center, SCORE (Supplier Correction/Order Request).• Negotiated and consolidated printing devices to reduce 15% of corporate printing expenses.• Served as member of Help Desk support team to support remote office and 100+ remote users regarding hardware and software issues. • Oversaw and maintained enterprise CA Arcserve backup server to back up 50+ Unix and Window based application servers. Reviewed and planning corporate disaster recovery plan to minimum system down time. • Configured and installed ActiveBatch enterprise job scheduler to perform mission critical cross platform data exchange and process control, created VB script, UNIX Shell, FTP commands, MS-DOS batch files and ActiveBatch API to push and pull data between ERP and internal /external applications.• Oversaw and maintained 10+ SQL 2000/2005/2008 R2 instances, creating stored procedure. Provided technical support and advisement to BA regarding their query issues, backup and restore database, SQL database/tables design and performance tuning.• Migrated Window SharePoint V3.0 service server to SharePoint 2010 server configured and integrated SharePoint 2010 with SQL 2008 R2 reporting server. Explored SSRS report designer to evaluate the possibility of converting existing Ad-Hoc reports to SSRS.• Utilized Crystal Reports to automatically generate Canadian Custom Form for freight operations, enabling invoiced re-print feature to speed up order processing. • Developed MS-ACCESS database to import Verizon wireless bill, categorized various charges and analysis report. Reduced time required by 75% for data entry and eliminated human error. Enabled management to perform necessary adjust calling plan to control the total cost more effectively. Show less

• Special Project Leader

  • 1998 - 2000

  Promoted to support ERP system, EDI coordinator (Sterling Gentran Director) defining communication and trading partner profiles, troubleshooting communication and transaction errors. Coordinated with vendors to initialize EDI transactions and upgraded documents template to 4010 to comply Y2K issue.

• IT Specialist

  • 1997 - 1998

  Provided desktop support including remote users and office, file/application servers administration. Led successful roll out Exchange server V5.5 and outlook to replace Notework- Novell MHS based email system. Deployed MS Proxy server V2.0 and CISCO PIX to secure corporate Internet access.



EXP COMPUTER INC.

• Syosset, NY

• MIS Manager

  • 1993 - 1997

  Provided desktop support, managed file/application servers, Supported SBT accounting program, Lotus Notes Administrator and Developer. Developed RMA (Return Merchandise Authorization) Lotus Notes workflow application, utilized FOXPRO to developed Customer Warranty Registration database. Provided desktop support, managed file/application servers, Supported SBT accounting program, Lotus Notes Administrator and Developer. Developed RMA (Return Merchandise Authorization) Lotus Notes workflow application, utilized FOXPRO to developed Customer Warranty Registration database.