We provide IT Staff Augmentation Services!

Sql Server Database Developer Resume

5.00/5 (Submit Your Rating)

Long Beach, CA

Hire Now

PROFESSIONAL SUMMARY:

Business/IT professional with tenured experience consulting in business, technology, banking, utility and project management. Self-motivated with a broad skill set that includes project design and implementation, training and developing, business analysis and identifying process improvements. Exhibits exceptional communications skills to ensure the coordination and completion of projects on time within budget and within scope. Compassionate and energetic with a thirst for continuous self-improvement and a willingness to embrace challenges and driven for excellence. Team player with a high degree of professionalism seeking a challenging opportunity that will provide personal and professional growth, but not limited to consulting.

TECHNICAL SKILLS:

  • CAD Systems
  • Business operations expertise
  • Excellent problem-solving abilities Working with large data sets
  • Project Management Control
  • Statistical Quality
  • Microsoft Office
  • CAD Systems
  • SSIS/SSRS
  • Business/IT professional W orking with large data sets

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, CA

SQL Server Database Developer

Responsibilities:

  • Created ER diagrams and performed normalization on them to ensure faster querying.
  • Ensured data consistency by creating primary key, foreign keys and appropriate constraints.
  • Optimized SQL queries using SQL profiler, indexed views and indexes.
  • Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.
  • Created DDL and DML triggers to maintain database integrity
  • Used BCP utility and bulk insert for transferring data between SQL server and flat files.
  • Created ETL process using SSIS for populating data store in SQL Server 2005.
  • Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005.
  • Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
  • Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.
  • Successfully implemented indexes on tables and views for optimum performance tuning.
  • Supported some business specific relationships, and advance constraints by embedding triggers on tables.
  • Set up scheduled Jobs and alerts for updates and backups.
  • Involved in designing of shift based reports, chart reports (line and column), parameterized reports for performance analysis.
  • Set up report delivery schedules and report back up schedules by configuring subscriptions and snap shot respectively.
  • Designed strategies for securing the reports created depending upon the level of sensitivity of information that the report contained.

Confidential, Irvine, CA

SERVICE ENGINEER

Responsibilities:

  • Read and interpreted blueprints, technical drawings, schematics and computer-generated reports.
  • Developed CAD drawings based on specifications from engineers to ensure fitness products were best in class.
  • Analyzed complex customer data and drew insights that informed our marketing and PR efforts. Which generated over $62,000 a year on service call
  • Use tools (Excel, Word, SQL) to analyze, query, sort and manipulate data according to defined .

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship