We provide IT Staff Augmentation Services!

Database / Sql Developer Resume

Brooklyn, NY

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NY

Database / SQL Developer

  • Architected database designs and administered user and application roles and privileges for numerous client - facing applications
  • Extensively developed T-SQL statements and stored procedures in Microsoft SQL Server (2000, 2008, 2012) and IBM DB2 (3 environments)
  • Optimized batch process query/procedure logic, performance tuned their respective database objects, and defined dependency relationships between related and dependent processes
  • Managed production turnover requests across 3 environments (Test, Development, Production)
  • Led project to automate business intelligence reporting and analytics aggregation using Zeacom reports, database components, and excel automation to create custom and dynamic client-facing reports
  • Created and deployed all types of SQL Server Reporting Services (SSRS) reports users with multiple parameters, optimized for mode of consumption, and administered access permissions
  • Managed data support requests by creating SQL Server and DB2 programs/stored procedures
  • Architected on-demand solutions for frequently submitted requests using SharePoint BCS, SSIS packages, and MS SQL and DB2 stored procedures.
  • Participated in analysis, dependency research, and data/object migration during MS SQL NPPI data encryption, DB2 test/production data tokenization, and MS SQL upgrade from
  • Designed and created DTS and SSIS packages to extract, transfer, and load (ETL) data into MS SQL Server and others for exporting data into Excel Spreadsheets
  • Converted packages from DTS into SSIS

Confidential, Brooklyn, NY

Founder, Website and Systems Developer

  • Innovated business idea and business model
  • Led efforts to develop company website and customer relationship management (CRM) system
  • Automated shipping label generation using MySQL stored procedures, and order status updates and email generation using MySQL triggers
  • Created a fully functional inventory tracking system to display current inventory and defect rate, calculate COGS, and to generate timely reorder alerts using PHP and MySQL triggers/sprocs
  • Oversaw and maintained customer and sales data through MySQL databases
  • Created stored procedures for quarterly sales reporting —sales by channel and volume
  • Developed business intelligence reports for web and social media analytics, advertising and referral campaign performance, and sales conversion metrics
  • Schedule server jobs and routines for backups and data transformation
  • Developed online website that communicates value proposition to customers

Confidential, Brooklyn, NY

Information and Technology Support

  • Created SSRS reports in Microsoft Business Intelligence Development Studio (BIDS)
  • Managed SSRS report access and permissions
  • Created business intelligence reports to better understand volume and business patterns
  • Developed SQL stored procedures for financial reporting, client management, and to fulfill auditor inquiries
  • Provided technical guidance for converting records into a paperless environment as well as replacing existing processes with digital workflow.

Hire Now