Developer / Business Intelligence Analyst Resume Baltimore, MD - Hire IT People

SUMMARY

Solid knowledge of database principles and design
MS SQL Server 2000, 2005, 2008, 2012, SQL, T - SQL, stored procedure, MySQL
Normalization, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS)
Database bug resolution, optimization and security enforcement
OOP: Encapsulation, inheritance and polymorphism
C#, ASP.NET, MVC, C+ +, web service, windows communication foundation (WCF), HTML, XHTML, CSS, XML, JavaScript, jQuery
Visual Studio, Team Foundation Server (TFS), Subversion
Leadership qualities/experience to lead and direct IT department

PROFESSIONAL EXPERIENCE

Developer / Business Intelligence Analyst

Confidential, Baltimore, MD

Responsibilities:

Administration, maintenance and programming of company’s financial software applications such as Advent Portfolio Exchange (APX), Salesforce and Bardie, among others.
Authoring, managing and deploying reporting solutions on as needed basis using SQL Server Reporting Services (SSRS) and SQL Integrated Services (SSIS)
Requirement gathering, analysis, and support for a robust in-house financial management software application called Galileo
Rigorous testing of Galileo in QA and UAT environments.

Database programmer/administrator

Confidential

Responsibilities:

Develop database objects using T-SQL programming language
Database administration and support, including performance tuning/optimization
Used Microsoft SQL Server Integration Services (SSIS) to extract and transform data, and load the results into target destination.
Used Microsoft SQL server Reporting Service (SSRS) to generate insurance reports
Some Active Directory work
Developed a “User manager” insurance application, complete with a graphical user interface (GUI) using C#
Support and maintenance of company’s Insurance Management System (IMS) application using C#

SQL programmer/ DBA (Consultant)

Confidential

Responsibilities:

Reviewed and authored T-SQL scripts, stored procedures, views and database functions
Database creations, performance tuning/optimization, database mirroring, managing and troubleshooting security
Bug resolution, maintenance and enhancement of ASP.NET MVC 4 web application using C#, JavaScript, jQuery and Microsoft SQL server.
Design, develop, and implement robust user-friendly enterprise windows / Web-based applications using .NET, C#, web services, WCF, JavaScript, jQuery, AJAX, MS SQL server, LINQ and ADO.NET.
Wrote codes and refactored methods and classes using C#

SQL programmer/Developer (Consultant)

Confidential

Responsibilities:

Resolved database related bugs, including enhancement of tables and table structures.
Stored procedures review, enhancement and authorship
Perform bug resolution, maintenance and enhancement of two web application systems (web form and MVC) respectively, using C#, Microsoft SQL server and other necessary tools.
Authorship of controller, model and view classes for MVC application
Wrote tests for MVC controller, model and view classes

IT Consultant

Confidential

Responsibilities:

Database bug resolution, including table creation and enhancements of previous tables
Stored procedures and views authorship, review and enhancement.
Bug resolution, maintenance and enhancement of ASP.NET of company’s web application using C#, JavaScript, jQuery and Microsoft SQL server.
Wrote codes and refactored methods and classes using C#

SQL programmer / DBA / Technical lead

Confidential

Responsibilities:

Reviewed and authored T-SQL, stored procedures and database functions
Served as technical lead for the IT department
Participated in all aspects of software development life cycle, SDLC
Designed, developed, and implemented robust user-friendly enterprise windows / Web-based applications using .NET, C#, web services, WCF, JavaScript, jQuery, AJAX, MS SQL server, LINQ and ADO.NET.

Software engineer

Confidential, Winter Park, FL

Responsibilities:

Authorship and review of T-SQL scripts, including stored procedures, functions, and database/table creations.
Designed, developed, and implemented robust user-friendly enterprise windows / Web-based applications in C#, ASP.NET and MS SQL server.
Leverage relationships with end-users to review, analyze, evaluate and apply solutions to project development

Database administrator

Confidential

Responsibilities:

Designed and maintained databases using MS SQL Server
Wrote T-SQL queries, functions and stored procedures
Used Microsoft SQL Server Integration Services (SSIS) for data extraction, transformation, and load results into destination.
Used Microsoft SQL server Reporting Service to generate reports
Database performance tuning/optimization
Database backups
Verified and ensured data integrity in all databases
Defined/implemented access controls to ensure security on databases

Information Technology Services Analyst

Confidential

Responsibilities:

Wrote T-SQL queries
Database performance tuning/optimization on Microsoft SQL Server databases
Maintenance / enhancement of county’s web application using C#, ASP.NET, XHTML, CSS, and JavaScript.