We provide IT Staff Augmentation Services!

Programmer Analyst Resume

Los Angeles, CaliforniA

CAREER SUMMARY:

  • An experienced IT professional who possess extensive skills and abilities to ensure software applications and other products of the I.T. Department are of high quality and meet the business needs of their users.
  • Possess the ability to perform advanced programming utilizing the following languages:
  • Develop SSIS, SSRS, SSAS using Microsoft Visual Studio 2017 on SQL Server.
  • I also know C#, MS - SQL, MySQL, Linux on CentOS, WordPress, Drupal, Oracle as well as the knowledge of the Database Administrator, SharePoint on cloud and Office 365.
  • My background encompassed extensive experience in software analysis and development in demanding hi-tech environment and the ability to develop web-based applications.
  • Bilingual (mandarin and cantonese).
  • Able to multi task and work independently.

CAREER EXPERIENCE:

Programmer Analyst

Confidential, Los Angeles, California

Responsibilities:

  • Install SQL Server 2008, 2012 and 2017 for our Enterprise, Department of Public Safety and university department servers.
  • Create maintenance plan for full, differential, transaction log backup and refresh database from development to production.
  • Maintenance SQL server database login, permission, shrink log files.
  • Install and config SSRS 2017 as our reporting tools.
  • Implement SQL Server AlwaysOn high availability.
  • Use SSIS to develop ETL package on Visual Studio, Create Store Procedures, Views and Reports on SQL server 2012 databases for our application.
  • Create Commvault Backup to ExaGrid and involve AWS backup with our backup team.
  • Data conversion, develop interface for our Environment Health and Safety System provided by our vendor (On Site Systems).
  • Config LDAP connection to our active directory domain services.
  • Act as an administrator to config and support IBM Planning Analytic 2.0.9.1 /TM1 on Cube, Dimension, TI Process, Security using Architect, run workspace on docker and setup client connection on Excel using Add-Ins.
  • Request and install SSL certificate and Shibboleth on our application servers.
  • SharePoint site administrator (add new user, create/maintenance SharePoint site and migrate old SharePoint content to Office 365.
  • Create Microsoft Power Apps and Flow to build out applications base on business logic.
  • Support iManage and Laserfiche (Document Management System) for Senior Vice President, General Council, Athletics Compliance, Office of Compliance, Human Resources and Department of Public Safety.
  • Install and config WordPress on our Linux VMware, create content using plug-in and support WordPress sites update.
  • Support and maintenance our department’s website using WordPress, Drupal with HTML.
  • Use Spacewalk for patching and Zabbix agent to monitor our application servers.
  • Perform server maintenance jobs on the weekend.
  • Work closely with our System Admin (Setup new virtual machine using vSphere, request storage, test Fortinet firewall rule on our applications).
  • Use Microsoft Teams and Agile for daily communication on our project status and collaborate at work using confluence.
  • Experience with DevOps Methodology and use ServiceNow as knowledge bases and service portals

Programmer Analyst

Confidential, California

Responsibilities:

  • Conversion and Implement from Oracle Retail Management System to replace GERS Retail System.
  • Use SSIS and SSRS to develop ETL package, Store Procedures and Reports on SQL server 2008 or Oracle 11g database.
  • Responsible for develop, maintenance, testing and implementation on our Application in Business intelligence group.
  • Load Structure and fact data from Our Data Warehouse into Enterprise Planning (EP) by JDA on creating and modify the Unix scripts in AIX as well as monitor the tablespaces using Oracle Enterprise Manager.
  • Support Essbase Opal application on maintenance the outlines, load rules and create report script.
  • Use Crystal report 11, ASP.net, C# to develop reports for Warehouse Management System.
  • Write Functional and Technical Specification on various application as a System Business Analyst.
  • Use Scrum on team collaboration.

Senior Programmer Analyst

Confidential, Foothill Ranch, California

Responsibilities:

  • Responsible for the development, implementation, testing and maintenance of employee benefit webforms applications development in a team work environment using Active Service Page with Microsoft SQL 2000 as the back-end database.
  • Use Java script and client-server development on Microsoft Visual Basic 6.0 for Cigna health care, UPS and FedEx application.
  • E-Commerce solutions for POS systems (Enterprise portal frameworks).
  • Use Developer 2000 of Oracle 9i to create forms and reports for Warehouse Data Management and Ticketing system.
  • And Maintenance PVCS (Program Version Control System).

Senior Programmer Analyst

Confidential, Irvine, California

Responsibilities:

  • Use Developer 2000 of Oracle 8 to create forms and reports for Retek Merchandise and distribution system.
  • Create Unix scripts, SQL*Plus and Cobol programs for EDI project to update the Oracle tables.
  • Modify Proc C of Retek package for enhancement.
  • Create Oracle Database, tables, trigger, constraint and load data for education purpose.
  • Hands on experience with Oracle DBMS - Enterprise Manager.

Programmer Analyst

Confidential, Foothill Ranch, California

Responsibilities:

  • Develop Visual Basic application and use Liberty ODBC driver to retrieve data on Pick system for our store’s Allocation System.
  • Use PL/SQL to build Platinum software interface and to modify Platinum application using Platinum Basic.
  • Maintain “Style Analysis” report using Oracle.
  • Implement and Maintain Payroll system written in Pick on Unix system .

Programmer Analyst

Confidential, Irvine, California

Responsibilities:

  • Create various report on SQL database.
  • Maintain existing application using PowerBuilder on Loan Servicing and Broker System.
  • Consolidate the monthly funded data from Sybase system.
  • Develop and maintain Visual Basic application for Loan Processing system.

Programmer Analyst

Confidential, Santa Ana, California

Responsibilities:

  • System Analysis, design, program coding and Installation for the in-house software system to automate business processes .
  • Write application software using Visual Basic, generate various reports using Crystal Report Writer and develop application in MS Access.
  • Develop applications in an Account System in Major Investors, Shipping, Loan Audit Using Clipper.

Hire Now