Database Developer Active Directory

C

Results-driven, IT Professional with extensive experience in administration, development,

support and implementation of SQL Servers database and database warehouse.

SUMMARY OF QUALIFICATIONS

20 + Years IT Experience working as an SQL Database Development and Administration.

Extensive hands-on experience in system and network management, installation, maintenance, administration, security, troubleshooting, training, and technical support.

In-depth knowledge of network technologies, architectures, and platforms, with the ability to apply them to the strategic benefit of organizations.

Proven ability to successfully streamline, optimize, and maintain system/network functionality performance, and recoverability in mission-critical environments.

Adept at working with management to prioritize activities and achieve defined project objectives; able to effectively translate operational/network requirements into technical solutions.

EDUCATION AND TRAINING

Bachelor Degree of Professional Studies in Computer Information Systems and Database Management

DeVry College, New York, NY,2017

Certification – (MCDBA)MSSQL Server and Database Administration, 2013

Certification – (MCITP) ASP.Net C# Application & SQL Database Development, 2010

Certification – (MCSD) ASP.Net C#,C++ Application, Software & Database, Development, 2002

TECHNICAL SKILLS

Desktop Operating Systems: Microsoft Windows XP (Pro/Home) (32/64bit), Windows 7/10 (32/64) (Home, Home Premium, Business), Windows shell script, Windows 2000, Windows NT, Windows 9x (95/98/ME)

Software: MS2015Word, MS Excel, MS Outlook, MS PowerPoint, MS Access/Project, Visio2013, Adobe (Acrobat / Photoshop / Illustrator), GoToMyPC, VNC, VPN Client, RDP(Aventail), RDBMS, Symantec (Antivirus, Ghost), MacAfee (Antivirus, Anti Spyware), MS Visual Studio 2000-2015, T-SQL 2002-2016 Server Management Studio (SMS), T- SQL, SQL Profiler, Configuration Management, Azure DB, MySQL, PLSQL, Oracle Database and DB2 and Linux System, Java Script and knowledge of JASON

Server Operating Systems: Microsoft Windows SQL 2005, 2008 & 2008R2, 2012, 2014, 2017& 2019 Server, Linux

Server Applications: Active Directory, SQL DB & DB2, File and Print Services, Terminal Services

Wired Networking (LAN/WAN): Switches, Routers, Firewalls, Modems, Network Printers and Scanners

Network Protocols: TCP/IP, DNS, FTP, TFTP, Telnet, IIS, Ping, HTTP, HTTPS, RDP, SOAP, REST

PROFESSIONAL EXPERIENCE

DATA ANALYSTS/ LEAD SQL DEVELOPER NEW YORK, NY

TEACHER’S RETIREMENT SYSTEM NYC NOV 2019 – DEC 2020

Analyze and test migrated data from legacy system to new SQL RDS system and Azure Database on AWS Protégée.

Assist lead developer with Data Migration and Bridge mapping for ALL SSRS reports from cloud SQL 2017.

Maintained and Support ALL SSRS reports, distribution and data updates using SQL 2017

Monitor Client Azure cloud database and Support end users with data access and any ad hoc reports request.

Create and execute migration test cases from business specs and data mapping for testing migrated data.

Assist developers with report layout changes, new data mapping and document updates.

Lead team in Scheduled Maintain and Support all daily, weekly, and monthly reports on AWS Protégée RDS cloud.

Scheduled and monitored reports database and client azure database for weekly and monthly backups in AWS.

Build, monitor database tables, triggers and indexes using SQL 2017.

Maintained and Support all Stored Procedures for the SSRS reports using Jupiter software.

Lead developer support with ALL .Net C# applications using Visual Studios for troubleshooting SSRS &SSIS reports.

SQL DEVELOPER/ADMINISTRATOR IRVINGTON NY

EILEEN FISHER NOVEMBER 2018 – JUNE 2019

Assist with SQL PLM System Migration from Windows 8r2 server to AWS Protégée, Windows 10 cloud servers.

Lead developer with Migration for Live data for SSRS reports and ALL SSIS Packages from SQL 2008R2 to cloud SQL 2012.

Maintained and Support ALL SSRS reports and SSIS Informatica packages using SQL 2012 & 2008R2.

Lead Support for ALL PLM users and Vendors accounts from NYC, Hong Kong, and the UK using Azure virtual DB

Lead Support for all ETL/EDI Informatica data transactions to Hong Kong on Azure virtual machine.

Lead team in Scheduled Maintain and Support all daily, weekly, and monthly reports on AWS RDS.

Scheduled and supported all PLM style and material daily and weekly bridges.

Build, unit testing and deploying new and updated reports using SQL 2012, 2014 and Visual Studio 2012, 2014 and 2017.

Maintained and Support all Stored Procedures for the SSRS reports using bit bucket.

Lead Support for ALL .Net C# applications for troubleshooting SSRS &SSIS reports on AWS Protégée RDS cloud.

Knowledge of SDLC working with BA and Account managers for reports specs to create New SSRS reports.

Performed daily, weekly, and monthly PLM/SQL database and C# application backups using SQL 2012.

Configured IIS for new AWS RDS server, adding role permissions and monitor web site/service for EL and SSRS server.

Lead developer to Trouble shoot ALL report errors, All data cleaning and documentation process for PLM System.

Maintain and Support Zendesk and Bugzilla trouble ticket systems.

SQL DATABASE DEVELOPER BRONX, NY

AFFINITY HEALTH PLAN MARCH 2017 – AUGUST 2017

Monitor and maintained Data warehouse with 4+ Tera bytes of data for daily processing and reporting.

Monitor and support secured online vendor staging database for updates with Meta data and various data formats.

Perform daily, weekly, and monthly data base backups and coordinate files for offsite storage.

Unit testing migrate and data cleaning of over 750 ETL Informatica packages for server upgrade from SQL 2003 to SQL 2016 for daily processing.

Unit and performance testing for all ETL Informatica packages including connections to MSSQL, MySQL, PL/SQL Databases.

PL/SQL, SQL and MSSQL Query performance tuning, optimization, and table normalization

Database reporting via SSIS, SSRS, SSAS, Crystal, T-SQL and TABILAU for financial, statistical and membership enrollments.

Use ASP.Net C# and BI Studios to create shell scripts for Data warehouse updates and modify SSIS packages.

Coordinate weekly server upgrade status meetings with three different teams and team members, supervisors, and managers.

DATABASE ADMINISTRATOR/SQL DEVELOPER NEW YORK, NY

MAXIMUS INC. AUGUST 2015 – MARCH 2017

Lead team Analyzing & prepare incoming EDI client data files of various format for conversion and load into SQL RDBMS.

Monitoring and maintain secured online data warehouse for updates with various data formats on Azure cloud DB.

Perform daily, weekly, and monthly data base backups and coordinate EDI files for offsite storage.

Assist state workers, external and internal clients with remote access issues, file storage and file recovery.

Maintaine and monitored several database performances including Oracle, MSSQL, MySQL, PL/SQL, and Access.

PL/SQL, Oracle, MSSQL and T-SQL Query tuning, optimization, and table normalization

Assist Network dept with IIS monitoring for SSRS web server reporting/Monitoring BizTalk server and applications.

Database support via SSIS/ETL Informatica, SSRS, SSAS, Crystal and TABILAU for financial, statistical data.

Use ASP.Net C# and Alteryx to create and modify database reporting interfaces and SSIS packages.

Support All ETL/EDC data transports to NYS department of health and department of Finance.

Coordinate weekly database status meetings with three different teams and team members, supervisors, and managers.

SQL DATABASE ANALYSTS NEW YORK, NY

EMBLEM HEALTH SEPTEMBER 2014 – MARCH 2015

Lead Developer for email notification web service using BIDS 2008 and Alteryx for some SSIS packages.

Automated Inventory Forms Order Process with T-SQL stored procedure and SSIS 2008 package.

Processed daily, weekly, and monthly Mass Merge Mailing SSIS 2008 Production Packages.

Created SQL SSIS Informatica and SSRS reporting database and automated the reporting process using ETL 2008.

Converted DTS/SSIS 2000 packages to ETL Informatica 2008 packages and updated all outdated stored procedures.

Created Shell scripts and API interfaces Using ASP.Net C# and Alteryx

Assist Account manages with daily excel spreadsheet extractions for download and uploads.

Preformed daily, weekly, and monthly database backups.

SQL DATABASE ADMINISTRATOR LONG ISLAND CITY, NY

EAST COAST LIMOUSINE OCTOBER 2013 – NOVEMBER 2013

Installation and Implementation of MSSQL Server 2008R2 & 2012 and Server updates.

Use ASP.Net C# and BIDS to create dashboard for Automated Reports Generation.

Designed, Analyze & test new versions of the Client Relational DB2 RDBMS with clustered Indexes.

Program script and API for Oracle Database Tables and Table Nominalization for Client Databases.

Created and Design T-SQL SSRS, ETL Informatica and SSAS & Crystal Financial Reporting System.

Assign access permissions, roles, and privileges to client T-SQL Database & Oracle Database.

Import/Convert Access database and excel spread sheet to T-SQL & Oracle Database.

Ensured that storage, archiving, back-up, and recovery procedures are functioning correctly

Monitored performance and managed parameters to provide fast query responses

WEB/SQL DATABASE DEVELOPER SCARSDALE, NY

ZACHY’S WINE & LIQUOR JUNE 2012 – February 2013

Lead Developer with Single Sign-On development for Zachys website.

Lead Developer C# .Net Active Directory Application to create New User Profile.

Developed several SAP Crystal, Cube & SSRS Reports for Inventory, and Invoicing.

Administrator for Biz Talk server and Monitor all applications for client and warehouse support.

SQL 2008R2 & Oracle Database backup, recovery and data analyst using OLAP & MySQL profiler.

Trouble shoot bottle neck issues on Zachys web site for retail, auction, and storage.

Maintain internal IT helpdesk for several companies.

Responsible for importing of access and excel flat file to T-SQL DB for weekly cost report distribution.

Program and Process DB2 Production jobs for billing department.

Programmed stored procedures & triggers to create customers statements.

All Development done within the Microsoft Visual Studio ASP.Net 2010 & SQL 2008

.NET/SQL DATABASE DEVELOPER VALHALLA, NY

BRS SYSTEMS L.L.C. MARCH 2010- August 2011

Developed Client Statement SSRS & RTE web reporting service using C#, MVC & SQL 2008R2.

Developed SharePoint Reporting Service with 50 trea byte of data source.

Development of SharePoint 2010, C# .Net and MVC Imaging Dental Application,

Developed QB T-SQL applications for ADP system interrogations, using Visual Studio C#

Process and Monitor DB2 Production Jobs for report distribution on Oracle Database.

Lead developer for EDC data cataloging and transmissions to multiple dental offices.

Lead Oracle DBA on a team of three, Trouble shooting Oracle & MySQL database for bottle neck processing via OLAP.

Developed .Net Web form Invoicing Application using C# Created RDBMS clustered Index

Automated Billing system with .Net windows shell script & web form Application, Config IIS control.

Developed and Design T-SQL database & C# Stored Procedures and triggers.

Designed, Created and Backup Oracle Database for Production processing.

All Development done within Microsoft Visual Studio ASP.NET 2010 C# & T- SQL environment.

DATABASE ADMINISTRATOR/DEVELOPER WHITEPLAINS, NY

KRASDALES FOOD INC MARCH 2008-NOVEMBER 2009

Database error handling and performance tuning processing AS400 DB2 production Jobs.

Create & Update Dept. database via MySQL Query Analyzer & Enterprise Manager.

Designed logical & physical databases for RDMS & SSRS & Crystal reporting.

Developed ETL Informatica & SSRS and MySQL SSAS Cube reports for product inventory.

Created clustered Index and database Replication preformed all DB backups.

Programmed stored procedures, scripts and triggers for reporting services using C# .Net

Documentation for installation of all new SQL Server 2005/2008 DB apps.

All work done within a SQL 2005/2008 Database environment.

ASP.NET C# PROGRAMMER SECAUCUS NJ

THE CHILDREN’S PLACE September 2002 – November 2007

Perform testing of New Apps created with T-SQL server2000

OOP coding and Implementation of new programs in C# & MVC, setting IIS for web calls.

Maintain dept. data warehouse via T-SQL 2005 Server Manager.

Developed New Web form & Win form applications for P.O.S. posting using C+, C# & MVC.

HTML & XML code modifications, Windows shell scripting for DB reports.

Created Crystal and cube Reports for Dep. Head using ASP.Net and BI in C#

Created weekly and Monthly SSRS report based on Child Support System.

Responsible for scheduling SSIS production repots using CA-Scheduler.

All programming work done in Visual Studio ASP.Net 3.0/3.5 environment in C+.

Contact this candidate