Resume

Sign in

Sr SQL Developer

Location:
Los Angeles, California, United States
Salary:
130000
Posted:
February 14, 2019

Contact this candidate

Resume:

Aaron Sung

**** * ****** ****** **** Jr Blvd

Los Angeles, CA 90008

ac8hwz@r.postjobfree.com

(323) 559 - 7591

Summary:

Passionate about data, open-minded, and motivated SQL developer with advanced experience using SQL 2008R2, 2012, and Azure. Over 7 years of backend experience as a SQL developer in analysis, development, implementation and maintenance. Have created working databases for hybrid and web apps and launched successfully in different countries. Hard worker who likes challenging position with a desire to use updated skill sets to manage and improve business critical systems and the company objectives.

Major Skills:

MS SQL SERVER 2008 R2/2012/2014, SQL Azure, TFS, SSIS, SSRS, Business, Intelligence(VS 2008/2012/2015), Powershell

Minor Skills:

C#, Sharepoint 2010, Crystal Report, PowerBI

EXPERIENCE

July 2018 - Current

Sr. SQL Analyst

Molina Healthcare - Long Beach, CA

●Database reorganization

-Planned to reorganize database with dev and prod environment

-Create, develop, and improve table structure and stored procedures

-Automated manual processes via SSIS and SQL agent

-Clean up database by creating a service account and recreating tables

●Sox report submission

-Reduced report generating time by fixing current SSIS packages and procedures and automated some of processes

-Analyzed historical reports to get more accurate numbers on the report

June 2014 – March 2017

Sr. SQL Developer

Herbalife – Los Angeles, CA

●Lead on Gauge app project

-Starting with Scheme modeling and set up for nutrition club app

-Create, develop, and improve tables, stored procedures and indexes

-Create and develop business logic on data flow

-Generate daily, weekly and custom reports

-Create a sync job with ETL and .Net team to move data to on-prem SQL database and Azure SQL database

-Successfully launched the app in China and APAC

-Create a dashboard type report and analyzed data to give suggestion with data manipulation

●Worked on Single Sign On project to create one central login site for all different applications

-Data migration via SSIS and SQL stored procedure

-Database modeling and schema changes and back-end development

-Create, develop, and improve necessary stored procedures

-Tuning queries and indexes

-After piloting with two verticals, SSO was launched for multiple countries without any issues.

●Worked on Multi-Email implementation

-Improving existing stored procedure to enhance its performance and overall updates

-Implement multiple email feature for marketing and user account page

-Meeting with all verticals to resolve the issue and successfully removed all duplicates

●Worked on Subscription project

-Schema changes and development

-Create and modify stored procedures to meet new requirements

Jan 2011 – May 2014

Programmer Analyst

International Coffee and Tea LLC. – La Cienega, CA

●Modernizing and revising existing reports.

a)Migrating from Crystal Reports and Reporting services 2005 to Reporting services 2008 via Business Intelligence

b)Modifying and customizing existing reports like P/L and daily for better performance, efficiency and readability

c)Creating new reports for marketing and business team

●Creating, designing and developing interfaces with SSIS package

●Convert and moving data from flat files, MS Access and Oracle databases to MS SQL database via SSIS Package

●Modifying and upgrading PLU worksheets.

●Testing and developing Share Points Workflow

a)Researching Share Points Workflow for our needs

b)Creating and testing implementation of PLU worksheet workflow with InfoPath in our testing environment.

c)Creating and testing simple request forms using SharePoint and InfoPath.

●Writing and customizing PowerShell scripts

●Create/Modify classes in C# to implement new features and version upgrade for database related objects

●Improving existing stored procedures to enhance its performance and create new procedures when necessary (Oracle/MS_SQL)

Sep 2010 – Dec 2010

Programmer Analyst (Temp)

Robert Half Technology, International Coffee and Tea LLC. – La Cienega, CA

-Supported company projects by migrating existing data to a new server using modified powershell scripts

-Net-Chef posting through Crunch Time!

-Documented POS update procedures and rules

-Provided a new PLU schema for POS update project

-Modernized and improved previous reports and created reports for the business analysts

-Created powershell scripts to automate work procedures

-Developing and testing Sharepoint 2010 workflow project

Jun 2009 – May 2010

Distributed Computing Admin

Union Bank - Monterey Park, CA

-3rd tier support resource for escalated technical issues from Help Desk

-NAS server administration (Build/Install/Configure)

-SMS 2003 administration

-Created custom scripts to gather error data and provide reporting for troubleshooting

-Created custom scripts to analyze errors and decrease push-out failure rate from 21% to 4%.

-Tested/Created software packages

-Maintained a company-wide inventory of computer, server, and network hardware, including quality control

-Worked as QA and resolved issues found during formal quality testing and determined if they were defects in the application, potential design changes, or suggested enhancements for future phases

Mar 2006 – Sep 2006

Computer Support Technician

ABC computer - La Crescenta, CA

-Hardware and Software maintenance and support, remote assistance and remote desktop support

-Assisted in customer system deployments as a field deployment resource

-Managed customer accounts as a Liaison role for the company

-Strong Knowledge of Norton Ghost imaging software

EDUCATION

California State Polytechnic University, Pomona, 2010

B.S., Computer Science

ACHIEVEMENT

College of Science Scholarships and Boeing Scholarships



Contact this candidate