Database / SQL Developer Resume Brooklyn, NY - Hire IT People

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.