We provide IT Staff Augmentation Services!

Programmer Analyst Resume

0/5 (Submit Your Rating)

Los Angeles, CA

SKILL:

  • Hadoop, Tableau, Python
  • SQL (12 years)
  • SSIS (5 years)
  • SSRS (2 - 3 years)

WORK EXPERIENCE:

PROGRAMMER ANALYST

Confidential, Los Angeles, CA

Responsibilities:

  • Administered MySQL and Linux for web applications.
  • Administered and developed customized application using Salesforce platform (Visualforce, Lightning SLDS, Apex class and Salesforce1) for an internal survey system.
  • Completed the data integration between csv file and Salesforce using Process Builder, Flow and Python.
  • Created Python scripts to parse and trim data from text file into csv file. Technologies used: Linux, PHP, Python, MySQL, Salesforce, R, Jupyter & Tableau

PROGRAMMER

Confidential, Palmdale, CA

Responsibilities:

  • Coded in VB.Net (80%) and C# (20%) to fix bugs identified by line of business and built enhancements to a Windows application, a practice management software.
  • Integrated third party application (File Center) to the Windows application.
  • Programmed and modified the Crystal Reports within the Windows application.

SUBJECT MATTER EXPERT (Production Support)

Confidential, Agoura Hills, CA

Responsibilities:

  • Created new SSIS (SQL Server Integration Services) packages and modified existing SSIS packages.
  • Analyzed, programmed and supported the ETL process for several web applications.
  • Designed and maintained SQL tables, views and stored procedures and set permissions with DBA.
  • Modified and fixed ASP.NET (C#) applications with code changes.
  • Assisted in execution of daily and month end close out process for Line of Business with accuracy using SQL, .NET Windows app and MS Access backend app. Minimized steps on manual daily closeout to maximize efficiency of tasks for App Dev Team and Line of Business.
  • Supported any production issues related to .NET web applications, SQL and MS Access app (VBA).
  • Administered and performed minor coding for team's SharePoint sites using SharePoint Designer 2007.

DATABASE DEVELOPER

Confidential, Simi Valley, CA

Responsibilities:

  • Revised intranet sites by modifying codes (ASP & ASP.NET (VB and C#), JavaScript & SQL Stored Procedure).
  • Created reports using SSRS (SQL Server Reporting Services). Created and managed DTS and SSIS packages.
  • Performed general SQL database support (update data and analysis), created and modified stored procedures.
  • MS Access Support (VBA) - provided access and fix any production related issues and errors.

WEB DEVELOPER

Confidential, Compton, CA

Responsibilities:

  • Responsible for full web application development cycle for internal and outside clients. Planned, designed, programmed, debugged, deployed and maintained websites.
  • Designed, structured and enhanced user interface & updated and maintained design and content on a regular basis.
  • Built well-documented and optimized server side code primarily using ASP.
  • Administered, designed, applied query building, and testing database with SQL Server 2000.
  • Implemented E-commerce sites for internal and clients' sites, including modifying codes and user interface design. Troubleshoot existing code, improved overall site performance and enhanced the shopping experience for customers.

We'd love your feedback!