Jhon Laguerre 347-***-**** acflow@r.postjobfree.com

Professional Summary:

> 5 years of strong experience in Information Technology industry covering

various stages of development such as desktop, coding in various

languages.

> Excellent experience in design, development, implementation and

administration of database systems using MS-SQL Server 2008/2005/2000 for

both OLTP & Data Warehousing Systems applications.

> Adept in RDBMS concepts and constructs along with Objects creation such

as Database, Table, Normalization, UDF, User Defined Data Type, Indexes,

Stored Procedures, Views, Cursors and Triggers.

> Exposure on ETL DTS Packages & SSIS Packages for integrating data using

OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat

file, Text Format Data) by using multiple transformations provided by

SSIS such as Conditional Split, merge, Merge Join and Union All.

> Involved in Database Normalization and De-Normalization, Optimization and

Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database

Objects authorization.

> Strong experience in creating various reports like Drill down,

Parameterized and Cascading Parameterized according to the user

requirement using SQL Server Reporting Services (SSRS).

> Experienced in creating Jobs, Alerts, and SQL, Mail Agent, Scheduling DTS

packages.

> Excellent analytical and communication skills to present points precisely

and solve problems efficiently.

> Detail-oriented multi tasking with strong technical concepts and

organizational abilities.

Educational Qualification:

Bachelor of Science in Computer Science

Worcester State College, MA (2006)

Skills:

MS SQL Server 2008/2005/2000, DB2, Report Builder 3.0, MYSQL, ETL, SSRS,

Windows, UNIX, Linux, HTML, CSS, JavaScript, XML, Transfer various files

from server

LinkedIn: http://www.linkedin.com/pub/jhon-laguerre/22/ba2/22

Project Summary

Teksystems (WOW)- Alpharetta, GA 08/2013-

Present

Oracle / PL/SQL Developer

Environment:

Oracle 11g, Management Studio 2008 R2, 2012, Microsoft SQL Server, Windows

7

Responsibilities:

> Meeting with internal client to gather requirements for various t-sql

script

> Work in a team of .Net c#, Oracle and SQL developer

> Create new database and all new objects such as tables, triggers,

function and stored procedure for specific project 'Career Path'.

> Create new SPs or Modifying existing SP by adding new logic in either

Oracle or SQL Server.

> Create SSIS package with different logic and transformation to transfer

data from oracle to SQL Server vice versa.

> Schedule SSIS package on SQL Server or through task scheduler in windows

to run daily

> Created new or modify existing objects needed such as tables, functions,

views and store procedures

> Normalized or denormalized database by creating necessary index or

removing index for performance wise.

> Work with business users, application developers and support teams to

identify business needs, discuss solution options and document

requirement analysis.

Teksystems (CDC)-Atlanta, GA

07/2012-04/2013

SQL Developer

Center Diseases Control and Prevention are partners throughout the nation

to create the expertise, information, and tools that people and communities

need to protect their health. My responsibility is to maintain the SQL

database in regard of the ARCHE study.

Environment:

MS SQL Server Management Studio 2008, Visual Studio 2010, SSRS 2008,

Windows 7 platform, C# Visual Studio 2010

Responsibilities:

> Created new SSRS report according to the requirement based on design

styles and data sources to extract from such as server, database and

tables.

> Create drop down list with multiple select based on tracking ID, sources

and location.

> Created T-sql scripts to extract data from different sources and created

SSIS package to move data from various sources and destinations such as

access, excel, flat files to SQL Server.

> Used SSIS transformation such as merge, merge join and conditional split

to transfer specific data to different destinations

> Work with business users, application developers and support teams to

identify business needs, discuss solution options, document requirements,

specifications and design.

> Create documentation for any modifying and new objects creating.

> Work on the Arche project by creating new and modifying existing objects

such as tables, stored procedure, views and functions through t-sql.

> Maintained the SQL database server 2008 by modifying existing Stored

Procedure and creating new procedure.

> Creating new tables, views or modifying existing tables by adding new

columns or remove columns.

> Created cascading deleted to enable to delete a tracking ID from all

tables in the database.

Comcast- Philadelphia, PA

10/2011-4/2012

BI/SSRS Developer

Comcast is one of the world's leading media, entertainment and

communications companies. My responsibility is to create various SSRS

report based on the date range, division and region for the business

services department.

Environment:

MS SQL Server Management Studio 2008, Visual Studio, SSRS 2008, SQL Server

Agent, Windows 7 platform

Responsibilities:

> Work closely with client to gather the report requirement for design

styles and data sources for extraction purposes such as server, database

and tables.

> Created new report or modify several existing report by adding division,

region and date range

> Created or modify several views and stored procedures by adding new logic

according to the report requirement.

> Created and modified a variety of parameterized, drill down, click

through, chart, matrix reports using SSRS 2008, by obtaining data from

different sources.

> Created permissions and adding new role assignment for business users to

gain access to the report folders and files through report manager

> Set up and distributed file sharing reports to a network target folder.

> Scheduled the reports to run on daily and weekly basis and email the

results to the business users in the required format.

> ETL from various sources include different server, linked-server such as

oracle, and different databases

> Transfer files such as Excel, Flat, FTP through SSIS and used data

conversion such as Multicast and Bulk Insert

> Created automation through SQL Server Agent by writing several steps

query and schedule jobs for daily refresh

ING- Atlanta, GA

7/2011-9/2011

DB2 SQL Developer

ING is one of leading provider of retirement and insurance products and

services. My responsibility is to create query, stored procedure, and

triggers and also work on performance tuning on existing views, stored

procedure to reduce the execution time.

Environment:

Aqua Data Studio 6.0.15, DB2, Explain, Windows 7

Responsibilities:

> Working on performance tuning several stored procedure that needed to run

faster by reducing their execution time.

> Create global temporary table to feed the main query for better

performance.

> Query optimizer through explain to actually analyze the performance of

the query such as if index is needed or not, or certain sql script is

helping or not.

> Created or modify several functions, views and stored procedures by

adding new logic for better performance.

> Normalized or denormalized database by creating necessary index or

removing index for performance wise.

> Work with business users, application developers and support teams to

identify business needs, discuss solution options and document

requirement analysis.

> Gather ETL requirement from client to map queries by breaking them down

into table, column name and field name. Maintained data integrity by

performing validation checks.

Ricoh-USA, Duluth, GA

3/2009-4/2010 SQL Developer

Ricoh USA is a global leader in the technology imaging industry. I was

Responsible for the design of OLEP to provide product info and sales

history for their intranet. Design SQL database for several .NET

applications, including Sales History, total of Copier, Printer, Fax and

different type of Manufacturing such as Xerox, Ricoh etc.

Environment:

SQL Server 2005/2008, Oracle 8i/9i, SSIS, SSRS, MS Excel

Responsibilities:

> Created and maintained existing objects like database, table, t-sql,

stored procedures, views

> Created linked server and distributional queries to access data from

Oracle system

> Transfer data from flat files, Excel, FTP, Oracle to SQL server

> Plan, design and implement database code objects such as stored

procedures, SQL Jobs, triggers, functions etc. to support business

applications and data maintenance.

> Debug, analyze and troubleshoot database coding to support and maintain

existing functionality.

> Created SQL server Reports using SSRS 2008 from initial stage.

> Involved in writing Query for generating Ad-hoc reports, drill down

reports, identified and worked with the parameters to generate

parameterized reports along with that extensively used global variables,

expressions and functions.

> Build and maintain ETL processes using SSIS and T-SQL by using various

transformation like multicast, merge, union all

Home Depot, Atlanta, Ga

1/2007 -8/2008

Database Management

Environment:

IBM, MS Access, MS Excel

Responsibilities:

> Provided efficient customer service quality service to internal and

external customers

> Proficiency in Access, Excel, IBM

> Insert data for all merchandising-related data (i.e., Purchase Orders,

SKU setups, Vendor setups and maintenance, Retail/Cost updates).

> Assisted Manager and Supervisor of Data Administration in their projects

and initiatives

> Trained new associates on how to use the data management software

Worcester State College, Worcester, MA 2/2003-

4/2006

Help Desk Support-Work Study

Responsibilities:

> Customer Service duty such as helping student in person or over the phone

with different PC issues.

> Create school email login and password for student

> Set up new PCs through out the college

> Data migration from the main server to PCs

> Troubleshoot computers for Anti virus and Spy ware.

> Installed software, video cards, sound cards, O/Ss and other peripherals.

> Setup routers and networking.

Contact this candidate