We provide IT Staff Augmentation Services!

Sql Developer Resume

Anaheim, CA

SUMMARY

  • Extensive IT experience in hardware and software design, and systems development, integration and support.
  • Technical expertise in front - end, middleware and backend (database) development.
  • Experience with consuming Web services: Salesforce; Taleo; Jive; Concur.
  • Extensive experience in SQL (2000/5/8/12/14 ), SSIS, SSRS, Stored Procedures, CTE, PL/T-SQL scripts and procedures, Crystal Reporting, Business Objects, Tableau, Dell Boomi.
  • Experienced in building and deploying integrated reports using Microsoft Reporting Services (SSRS).
  • Experienced in using Transaction SQL (PL/T-SQL) to create complex Queries and Stored Procedures to import, transform and normalize data from Oracle, FoxPro, Access and other relational databases.
  • Well practiced at analyzing and optimizing SQL tables, queries and indexes.
  • Skilled at creating Database Schemas and designing Data Cubes in a SQL OLTP/OLAP environment.
  • Excellent team member with outstanding leadership skills.
  • Self-starter and takes pride in completing projects on time and under budget.

TECHNICAL SKILLS

  • Data driven web projects
  • N-Tier software Design
  • Development
  • Security and Integration
  • Database Design
  • Construction
  • Conversion and Tuning
  • Report Development and Integration
  • MS SSRS
  • SSIS
  • ASP/ASP.NET
  • ADO
  • ADO.NET
  • RDO
  • DAO
  • ODBC
  • SOAP
  • XML
  • Ajax
  • Oracle
  • MSQL
  • PL/SQL
  • T-SQL
  • VSTO
  • SharePoint
  • OLTP
  • OLAP
  • Web services
  • JSON

PROFESSIONAL EXPERIENCE

Confidential, Anaheim, CA

SQL Developer

Responsibilities:

  • Designed ETL processes using SSIS for data warehouse workflow.
  • Designed ETL processes using SSIS for use in data collection and distribution.
  • Designed ETL processes using SSIS to manage application data and processes.
  • Designed and developed SQL data structures to service frontend web application.
  • Supported Development of a .NET Website to service Solar Customers.
  • Designed an infrastructure and process stack to track metrics produced by data collection and distributions processes.
  • Created custom monitors to track errors and metric thresholds from data collection and distribution processes.
  • Managed backup, restore and security for SQL Server 2008 and 2012 databases.

Environment: Windows 7/8, MSSQL 2012; MSSQL 2014; Microsoft Visual Studio 2014; SSIS 2013/2012/2008/2005

Confidential

ETL Developer

Responsibilities:

  • Created scripts to determine what Jobs are running on what servers and whether the Job is running SSIS packages or Stored Procedures.
  • Create SSIS package to parse and Normalized data from a HL7 formatted flat file.
  • Import and export data from SFTP sites using SSIS.
  • Import files into SQL DB using SSIS.
  • Import data from remote Oracle DB to SQL Server DB.
  • Performed referential Integrity checks on SQL tables using SSIS.
  • Create and distribute Medical admissions and Discharge data using SSIS to an Interactive Voice Response system.
  • Created tracking system to track the execution and results of SQL jobs and SSIS packages across multiple SQL Servers.

Environment: Windows 7/8, MSSQL 2008 R2; MSSQL 2014; Oracle, Business Objects, Crystal Reports, Microsoft Visual Studio 2014; SSIS 2013/2012/2008/2005

Confidential, Anaheim, CA

SQL Developer

Responsibilities:

  • Created SSIS packages to Manage Financial data and Transmit data to Vendors.
  • Designed and developed SQL data structures to service frontend web application.
  • Supported Development of a .NET Website to service Solar Customers.

Environment: Windows 7/8, MSSQL 2008 R2; MSSQL 2014; Microsoft Visual Studio 2014; SSIS 2013/2012/2008/2005

Confidential, San Diego, CA

SQL Developer

Responsibilities:

  • Planned, designed, optimized and developed Integration processes using Dell Boomi.
  • Created processes to create Expense report entries in Concur using Concur Web service SQL data and Dell Boomi.
  • Imported data from SalesForce and Taleo Web services into Process Peak using Dell Boomi.
  • Created process to Insert, Update and Delete user properties in Jive using Jive Web service and Dell Boomi.
  • Created processes to manage workflow integration between in-house and online platforms: MSSQL, SalesForce, Jive, Taleo, Process Peak, Concur, Onyx and Matrix using Dell Boomi.

Environment: Windows 7, MSSQL 2008 R2; Microsoft Visual Studio 2008; XML; SOAP; JSON; REST; Concur; Taleo; Jive; SalesForce; Jira; Process Peak

Confidential, Irvine, CA

Business Intelligence Developer

Responsibilities:

  • Planned, design optimized and developed Visual Studio 2008/2012 SSIS packages to extract transform and load data to data warehouse tables, external clients and Tableau DataMart’s.
  • Created technical design requirements and specification documentation based on business requirement documents.
  • Imported client data from Excel, XML and CSV files.
  • Used SSIS to create client data feeds to deliver via FTP.
  • Maintained ETL for Star Schema data warehouse tables.

Environment: Windows 7, Windows 2008 Server, Active Directory; MSSQL 2005/2008/20012 ; Microsoft Visual Studio .NET 2012, Visual Source Safe, HTML, XML, Citrix, Hadoop, OLAP/OLTP, Tableau, GIT HUB, SSRS, SSIS

Confidential, Orange, CA

Business Intelligence Developer

Responsibilities:

  • Planned, design and developed Visual Studio 2008 SSIS packages to extract transform and load data to data warehouse tables.
  • Created technical design requirements and specification documentation based on business requirement documents.
  • Designed data model based on flat file design specifications to import fixed length data.
  • Performance tuned views and stored procedures and tables based on the data model of the data warehouse.
  • Used Citrix virtual machine to execute and manage SSIS packages and data.
  • Worked with large files greater than 25 GB in size.

Environment: Windows 7, Windows 2008 Server, Active Directory; MSSQL 2005/2008; Microsoft Visual Studio .NET 2008, HTML, XML, Citrix

Confidential, Irvine, CA

Business Intelligence Developer

Responsibilities:

  • Planned, design and developed Visual Studio 2005 SSIS packages to extract transform and load data to data warehouse tables.
  • Managed projects for full life cycle team development efforts (9-12 team members).
  • Created technical design requirements and specification documentation based on business requirement documents.
  • Designed data model based on Business Objects Data warehouse Universe.
  • Performance tuned views and stored procedures and tables based on the data model of the data warehouse.
  • Created TSQL scripts to manage project releases, changes and migrations.
  • Performed technical reviews for code design and QA.
  • Provided weekly and off-hours technical support for data warehouse and reporting.

Environment: Windows 7, Windows XP,Windows 2003/2008 Server, Active Directory; MSSQL 2005/2008; Microsoft Visual Studio .NET 2005, HTML, XML, Business Objects, MS Share Point, Crystal Reports 2008

Confidential, San Bernardino, CA

Software Developer

Responsibilities:

  • Planned, design and developed ASP.NET site to manage, archive and distribute data and reports.
  • Reviewed business intelligence tools to determine the technology that best fit their reporting needs.
  • Designed data model based on function and utilization of data warehouse.
  • Performance tuned views and stored procedures based on the data model of the data warehouse.
  • Implemented Infragistics third-party controls in Visual Studio 2005, 2008 and 2010 for ASP.NET.
  • Managed documentation for code changes and code version releases using MS Team Foundation.
  • Managed Report Subscriptions in SSRS and SharePoint.
  • Created User Defined Functions to handle common tasks within stored procedures.
  • Created dashboards to display monthly and weekly metrics using SharePoint widgets and key indicators.
  • Worked with business to develop data warehouse methodologies, processes and rules.
  • Used MS SSIS to import and transform data for data warehouse.

Environment: Windows 7, Windows XP,Windows 2003/2008 Server, Active Directory; MSSQL 2005/2008; Microsoft Visual Studio .NET 2008-2010, ASP 3.5/4, HTML, VBScript, JavaScript, Ajax, Infragistics, XML, Microsoft Team Foundation 2010, Microsoft Reporting Services (SSRS), MS SharePoint, VSTO 2010

Confidential

Software Developer

Responsibilities:

  • Worked with business to design web based lot history record app enhancements.
  • Worked with business to identify, test and correct web based lot history record app bugs.
  • Implemented code changes for bug and web based lot history record app enhancements in accordance with FDA regulations.
  • Managed documentation for code changes and code version releases in accordance with FDA regulations
  • Provided high-level support for manufacturing personnel using eLHR web application.
  • Provided 24/7 emergency support for production eLHR web application.

Environment: Windows XP, Windows 2003 Server, Active Directory; Oracle 10g; Microsoft Visual Studio .NET 2005, ASP 2.0/3.5, HTML, VBScript, JavaScript, Ajax, Camstar Insite, XML, Visual Source Safe, Remedy, OLAP/OLTP

Confidential, Foothill Ranch, CA.

Software Developer

Responsibilities:

  • Migrated Access Database to SQL 2005.
  • Created and maintained T-SQL scripts and procedures.
  • Used SSIS to transform, schedule and maintain reports and data migration.
  • Created ASP.NET application to replace Access forms.
  • Created Reporting Services Reports to replace Access reports.
  • Implemented, tuned and debugged enterprise apps on IIS
  • Installed and configured Microsoft Reporting Services (SSRS).
  • Created ASP.NET application to display training information based on Active Directory security groups.

Environment: Windows XP - Windows 2003 Server - Active Directory; MS SQL 2005; Microsoft Visual Studio .NET 2005/2008, ASP 2.0/3.5, HTML, VBScript, JavaScript, Ajax, Citrix, Access, OLAP/OLTP

Hire Now