Sql Server Project

Marino Mercedes

*** **** *** ****** ***. *A Brooklyn NY ***********@***.***

Cell 646-***-****

Qualifications Highlights

SQL DEVELOPER 2008R2

• SQL Developer using SQL Server 2008 and 2008R2 and Visual Studio 2008

• Strong hand on SQL Server database administration & development included DBA duties

• Solid knowledge with software development life cycle (SDLC) and project management methodologies

• Extensive Hands on using Extract, transforms and load (ETL) Data using SQL Server 2008R2

• Solid knowledge using DTS package to build different packages for different purposes on multiple projects according to user’s specifications

• Working knowledge on establishing and maintaining security integrity controls in conjunction with the applications and security groups on a project

• Extensive hand on designing, implementing, maintaining, and documenting database applications for testing environment

• Extensive hand-on with data modeling, logical and physical database design using SQL Server 2008R2 designing different projects

• Solid Hands-on using T-SQL in designing store procedure, triggers, tables, user defined functions, views, indexes, user profiles for different applications on different projects

• Strong hand on building relational database models for a project, and assigned different types of data integrity

• Solid hand on using SQL scripts, to build stored procedures, triggers, functions, and solid knowledge on building Disaster Recovery Plan for rebuilding fragmented index and for tuning database

• Extensive hand on using report Service 2008 and 2008R2 for creation of multiple reports application on different projects according to user’s documented specifications

• Excellent communication, presentation and interpersonal skills

Technical Skills

RDMS : MS SQL Server 2012/2008R2/2008/2005/2000,

MS Access 2000/2003/2005/2007/2010

Database Tools/Utilities : SSRS, SSAS, SSIS, Enterprise Manager, Query Analyzer,

SQL Profiler, Data Transformation Services, Replication,

Job and Task Creating and Scheduling, Analysis Services

Programming Languages : C#.NET, ASP.NET, XML, T-SQL, PL/SQL, VB.NET, Visual Basic 6.0

Operating Systems : Windows 2000/2003 Server, Windows NT and Windows 9x

Designing Tool : Visio and Rational Rose

Source Control Tool : Microsoft Visual SourceSafe

Others : FrontPage, MS Office

Database Management Systems:

Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft SQL Server 2008R2/2012

Software:

MS SQL Server 2005 Integration Services (SSIS), MS SQL Server 2005 Reporting Services

MS SQL Server 2008 Integration Services (SSIS), MS SQL Server 2008 Reporting Services

MS SQL Server 2008R2 Integration Services (SSIS), MS SQL Server 2008R2 Reporting Services

MS SQL Server 2012 Integration Services (SSIS), MS SQL Server 2012 Reporting Services

(SSRS), Microsoft Office 2007/2010

Tools:

SQL Server Management Studio, Microsoft Visio, Business Intelligence Development Studio, Microsoft Office 2007/2010

SQL Master’s Program (SQL Developer) at Set Focus, LLC, Parsippany, NJ- www.setfocus.com 09/2010-03/2011

Set Focus SQL Server Master’s Program is an intensive, hands–on, project oriented program where participants gain solid knowledge and valuable experience putting the SQL Server skill set to use in a simulated work environment

• During the SQL Master’s Program, I have created numerous simple to complex queries involving, inner joins, self joins, cross joins, outer joins and correlated sub queries. I have created many Common Table Expressions (CTE’s) and CSV files techniques for diverse business requirements such as ETL operation. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.

• As part of a SQL team I, I have analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu-Ray) rental company. I have employed best practices in creating a complete schema including tables, relationships, stored procedures, views, functions and triggers. I have implemented the Extract Transform and Load data techniques to import and export data using CSV files in SSIS environment. I individually have redesigned, authored, rebuilt, debugged and managed the online-rental movie project solution. I have recreated the project solution to perform data validation, transform and load data from CSV files to a BlockFlix online movie rental database. The ETL package solution also performs email notifications to users after data have been validated and loaded.

• As part of a SQL team I, I have created various reports according to the business specifications for the movie rental company. I have individually redesigned, authored, installed, deployed and managed reports using SSRS for a BlockFlix online movie rental database. The BlockFlix loaded data was used to create various reports, such as Customer Membership, Most Rented Movie of the month, Most Active Customer of the month, Online Video Streaming and others. Those reports had been set up to automatic perform email and file share delivery based on standard report subscriptions.

• Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities.

• As part of a SQL team I have created an ETL solution that reads Product, Vendor, and Order data from CSV files on a network share into a SQL Server database. The solution also validated incoming data, move processed data to another destination in the network and performed notifications when jobs complete. The order data thus loaded into SQL Server was used to generate reports using the new SSRS 2008R2 reporting functionality (including the Tablix control). The reports had been set up for automatic email and file share delivery based on standard report subscriptions.

Master of Science (M.S.), Computer Software Engineering at Strayer University (DC) 09/2010-12/2011

Master of Science (M.S.), Computer Software Engineering: I was taking a master program (M.S.) of Software Engineering, by finishing the following credit courses:

• Advanced System Analysis & Design

• Software Engineering

• Quantitative Methods

• Enterprise Architecture

Professional Experience

SQL Server DBA 02/2008–06/2008

Microsoft, Redmond, Washington

• Company: Microsoft incorporated headquartered in Redmond, Washington. It is a leader of the build-in world-wide technology company, responsible for building personal computer and software. The company provides a wide range of solutions to business companies all over the world. Microsoft is the pioneer in the industry of World-wide technology services.

• Project: The project was to support a team of senior DBAs in the checking, upgrading, modifying and monitoring an old SQL Server database platform that support million applications from all over the World. It included database development (modeling logical and physical design) and testing through production providing the system with high availability, including application functionalities, security management, availability and performance monitoring and optimization.

• Responsibilities: Database planning in relation to physical and logical data architecture.

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.

• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).

• Designed and facilitated the implementation of data warehouses required by application systems.

• Developed and maintained data methodologies, procedures, and standards. Performed data impact analysis. Properly maintained core or control application tables.

• Validated change requests and made appropriate recommendations about standardized the implementation of data in a testing department.

• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

Junior SQL Server DBA 09/2007–12/2007

HD Dimension Princeton, New Jersey

• Company: HD dimension Corporation, headquartered in Princeton, New Jersey, is one of the nation's largest IT recruiter company. The company operates through an extensive network across United States, Canada and China. HD Dimension Corporation is a Wall Street Solution provider.

• Project: Supported and actively participated with a team of senior DBAS developer in the creation of 24/7 online banking system. The project was to create new databases according to business needs, install SQL Server 2005 on new 60 servers and upgraded existing SQL Server 2000 instances to SQL Server 2005.

• Responsibilities: Assisted senior database administrator (DBA) in testing and configuring the new application about its performance against the databases including data file allocation, index and the analysis of the impact on system performance. Analyzed server potential problems (response delay, locking, and server down time, etc.) to optimize system performance.

• Supported senior DBA in the search for business requirement for creating the new mission-critical databases from customers and internal employees.

• Created logical and physical database design, data structures using Erwin 7.

• Provided suggestions to network team regarding disk configuration, RAID level according to database sizing and capacity planning

• Supported in the development and creation of the new database objects including tables, views, index, stored procedures and functions, advanced query batches using SQL Management Studio 2005.

Education and Certification

AOS Degree in Information System- ASA College of Technologies Brooklyn, NY

BS Degree in Computer Science (Information System) - St. Joseph College Brooklyn, NY

MCP Microsoft Certified Professional - SQL Server Database Administrator 2000 Edison, NJ

SQL Master’s Program (SQL Developer 2008R2) at Set Focus, LLC Parsippany, NJ, www.setfocus.com

Contact this candidate