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

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Sr. SQL Developer

Confidential, Los Angeles, CA

Responsibilities:

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 development
Create, develop, and improve necessary stored procedures
Tuning queries and indexes
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
Worked on Subscription project
Schema changes and development
Create and modify stored procedures to meet new requirements
Worked on Gauge app project
Scheme modeling and set up for nutrition club app
Create, develop, and improve stored procedures
Create and develop business logic in C# and classes to read and format data from database
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

Programmer Analyst

Confidential, La Cienega, CA

Responsibilities:

Modernizing and revising existing reports.
Migrating from Crystal Reports and Reporting services 2005 to Reporting services 2008 via Business Intelligence
Modifying and customizing existing reports for better performance and efficiency.
Creating new 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
Researching Share Points Workflow for our needs
Creating and testing implementation of PLU worksheet workflow with InfoPath in our testing environment.
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)

Programmer Analyst (Temp)

Confidential, La Cienega, CA

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, Monterey Park, CA

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

Confidential, La Crescenta, CA

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