Sr. SQL Developer Resume Los Angeles, CA - Hire IT People

SUMMARY:

Challenging position where I can manage and improve business critical systems and the company operation
MS SQL SERVER 2008 R2/2012, SQL Azure, TFS, SSIS, SSRS Business Intelligence(VS 2008/2010/2012 ), Powershell
C#, Sharepoint 2010, Crystal Report

EXPERIENCE:

Sr. SQL Developer

Confidential - Los Angeles, CA

Responsibilities:

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
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

Programmer Analyst

Confidential

Responsibilities:

Modernizing and revising existing reports.
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
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)

Programmer Analyst (Temp)

Confidential

Responsibilities:

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

Distributed Computing Admin

Confidential

Responsibilities:

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

Computer Support Technician

Confidential

Responsibilities:

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