Database Developer / Analyst Resume

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2000, 2005, 2008 R2 and 2012, Oracle, Microsoft Access

Languages: T - SQL, PL/SQL, Visual Basic, Visual Basic for Applications (VBA), VB.NET, Java, XML, HTML, JavaScript, VBScript, ASP

Software: SQL Server Management Studio, Toad for SQL Server, Visual Studio, Microsoft Word, Microsoft Excel, Microsoft Visio

Reporting and Analysis Tools: Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), SAP Crystal Reports, QlikView, Sybase InfoMaker

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Database Developer / Analyst

Develops basic to complex T-SQL queries to research, analyze and troubleshoot data as well as to create both ad-hoc and recurring data reports.
Creates and delivers data reports to internal clients such as the College’s Graduate School, Registrar, Financial Aid and Student Accounting offices using SSRS, InfoMaker, MS Excel and the Student Information System (SIS) Online Portal’s reporting feature.
Performs data management tasks by creating and tuning stored procedures, triggers and views as well as inserting, updating records.
Manages projects that varies from third-party software assessment, institutional reporting implementation and data integration between external sources and the Student Information System (SIS).
Identifies data issues and provides recommendations for resolution and to ensure data integrity.
Provides technical support for the SIS which includes creating and maintaining workflow process documentation, data dictionaries and technical user guides for reference by internal clients.
Participates in software user acceptance tests in accordance to the internal client’s business process requirements.

Confidential, New York, NY

Database Developer / Analyst

Developed T-SQL queries for research, analysis and reporting purposes.
Created and tuned stored procedures and triggers for reporting and data management purposes.
Provided data management and operations support by inserting, updating and deleting records.
Created reports and performed data analysis using advanced Excel formulas and pivot tables, VBA macros and the firm’s Enterprise Resource Planning (ERP) system’s reporting tool.
Performed software quality assurance tests in accordance to business requirements and specifications.

Confidential, Newark, NJ

Senior Engineering Technician Engineering Technician

Provided data analysis using the client’s ERP and provided reports using advanced Excel formulas and pivot tables.
Developed data analysis tools for the client’s ERP using SSRS.
Performed quality control on reports prior to entering the data into the client’s database.
Created Access tables, data-entry forms and reports according to the client’s specifications.
Wrote data extraction QlikView scripts from an external data source.

Confidential

Developer (Intern)

Developed VB.NET applications and web services with SQL Server connectivity and Crystal Reports generation for company and client use.
Assisted in updating and maintaining the company intranet site using ASP.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship