SUMMARY

• Global IT professional with more than 20 years of diverse progressive hands - on technical and management experience. A results-driven, customer-focused, articulate and analytical Senior Software Engineer who can think “out of the box”. Strong in design and integration problem-solving skills.
• Expert in VB.NET, Microsoft SQL server development (T-SQL) and administration, Oracle database development (PL/SQL) as well as database analysis and design. Skilled in developing business plans, requirements specifications, user documentation, and architectural systems design.
• Repeated successes in spearheading global IT project initiatives end-to-end including budgets and management of department staff, and remote contractors, serving as sponsor of global IT applications projects. Established policy and procedure guidelines in accordance with global initiatives. Developed programs and implemented solutions designed to improve efficiency, increase productivity, and reduce costs.

TECHNICAL SKILLS

Microsoft SQL Server: Created Tables, Views, Partitioned Views, Stored Procedures with XML, Triggers, Indices, RPC, Heterogeneous Server Links, Jobs, DB Administration, Replication, Partitioned Tables, Performance Tuning, User management, SSIS, XML data exchange, BLOBs, SQL Server Clustering, Server Upgrades.

Oracle: eBusiness Suite (EBS), Advanced Supply Chain Planning (ASCP), Agile PLM, Hyperion Planning, Databases, PL/SQL, Functions (returning table type data, user-defined aggregate functions), Stored Procedures, Views and Materialized Views, Tables and Table Types, Database links

Application Development: VB.NET, WinForms, SQL Server and Oracle and MS-Access database access, Console applications, Multi-Threading, Crystal Reports, Developer Experess DXperience, CVS and SVN Version Control, ADO.NET.

Other: Windows Server administration, Windows Clustering, MS-Office, Flow Charting, and Documentation.

PROFESSIONAL EXPERIENCE

Confidential, West Hills, CA

Global MIS & Applications Manager

Responsibilities:

• Developed 3-year strategy plan for MIS and Application
• Managed and consolidated various consultants and external companies on hosting and support of ERP and Supply Chain Planning systems (Oracle EBS/ASCP/Agile PLM/Hyperion Planning).
• Interviewed internal business users, scoped, and created process flows for global projects such as CRM (Salesforce), Forecasting, RMA, Intranet, and BI projects.
• Reviewed proposals, and proposed vendors to implement CRM, RMA, Forecasting, and Intranet projects.
• Took ownership and maintenance of orphaned applications and processes left from former employees.
• Participated in decision making, selection and implementation of production servers SAN Storage upgrade.
• Supervisor of Global Travel and Expense system (Concur) and implementation of travel policies
• Hired and managed employees in USA, China, and Taiwan.
• Supervised SQL Server DBA tasks.
• Performed database performance tuning practices and obtained above satisfactory results.
• Maintained and developed database applications in VB.NET and T-SQL (Microsoft SQL Server) and PL/SQL.
• Supervised and developed OLTP databases and applications.
• Developed ETL jobs in SSIS.
• Created and maintained SQL Server and Oracle scripts for Stored Procedures, Views, Triggers, Jobs, etc.
• Performed Root-Cause analysis, DIVE process, 5-Why, and Fishbone for failed processes.
• Deployed Changes to various stages of production environment.
• Coordinated DBA and Development teams on various projects.
• Took over existing internally developed Manufacturing Execution System (MES) (VB.NET, SQL Server):
• Designed and implemented a whole new logic for creating serial numbers to avoid duplicate SN generation in global sites (US, China, Taiwan)
• Added Oracle EBS connectivity.
• Created a whole new global process to overcome extremely slow RMA processing between global servers. This involved incorporating XML technology in SQL Server stored procedures and using RPC.
• Created 2 generations of Shipping applications by gathering information from business stakeholders, design, implementation in global shipping sites in 2 cities of China and in USA.
• Added numerous modules and fine-tunings by following management directions and working with operations, engineering and R&D teams.
• Created various Supply Chain Planning tools by interfacing to Oracle EBS and ASCP (Advanced Supply Chain Planning or VCP) backend databases (OLTP) and creating User Interfaces (UIs), graphs and pivot reports in VB.NET. This involved considerable amount of R&D and reverse engineering on those systems and close collaboration with COO and other stakeholders in China production sites.
• Created parametric ETL software in VB.NET to have a quick method of creating data export/import between hosted Oracle EBS systems and local SQL Servers. Daily jobs were scheduled to fetch updated data from ERP and MRP systems and prepare them for US and Asia teams.
• Created SSIS ETL packages to interface with customer systems to send them shipment information.
• In addition to creating VB.NET reports, created complex Excel pivot reports and charts connected either directly to Oracle ERP system or to data extracted into MS-SQL Server.
• Installed a two-node Clustered Multiple Instance Active/Active SQL Server 2012
• Migrated existing production SQL Server 2005 to the above-mentioned cluster. During this migration, existing objects and setups including Linked Server connections, scheduled jobs and maintained compatibility with .legacy NET 1.1 32 bit applications running on the server requiring certain 32 bit Oracle client were maintained on the server.
• Migrated existing tables into Partitioned table structure on a multi-array drive configuration with multiple file-groups
• Deployed Changes to various stages of production environment.

Confidential, Riverside, CA

MIS Manager

Responsibilities:

• Created infrastructure of corporate IT servers including MS-SQL Server, Mail Server, FTP Server, File Server, and remote access (VPN, pcAnywhere).
• Setup networks in remote offices and connected to corporate office.
• Hired application developers.
• Continued design and development of Unison Courier and Logistics application.
• Maintained previously purchased Courier software through backend database modifications (MS-SQL Server).
• Created a new comprehensive Courier and Logistics application named Unison by working directly with president of company to replace the old application. This application was designed from ground up as modular application to support various functions such as Routing System, On-Demand Ordering, Truck Management, Holidays Management, Weight-Based Billing System, Tracking System, COD Management System, HR, Billing System, and Barcode tracking (VB.NET, Infragistics, Crystal Reports and SQL Server).
• Created NT service applications to import and export data in various EDI formats to exchange shipment and billing information with customers.
• Created and maintained client-side applications at customer sites.

Confidential, Irvine, CA

SQL Developer/Programmer/Analyst

Responsibilities:

• Courier/Messenger management application.
• ERP application system.
• Check-Cashing, Money Transfer and POS system
• Staffing system with HR, Accounts Receivable, and CRM modules.

Confidential

Cofounder and Technical Director

Responsibilities:

• Created proposals for various projects to customers.
• Provided technical designs on network and server setups based on Novell Netware and Windows NT 4.0.
• Selected and installed intranet server components (hardware and software).
• Architected Software requirements for customers.

Confidential

Director of Systems and Technologies

Responsibilities:

• Provided design, architecture and solutions for customer LANs and inter-building WANs.
• Installed and troubleshot Novell NetWare (4.10 & 3.12) LANs and Wireless WANs including VSAT.
• Provided infrastructure support of Oracle 6 Database for both server and client side
• Provided technical consultancy to management and clients.
• Supervised Hardware and software support and troubleshooting.

Confidential

Programmer

Responsibilities:

• Co-developed application using C language and Oracle supplied libraries (OCI) in DOS Real and Protected Modes to handle daily transactions of more than 20 branches of Mines and Metals Ministry of Iran across the country and store their data in the central Oracle Server on Novell Netware.
• Developed an application in C for Novell Btrieve Record Manager for use in the Stock Market Exchange.