Sql Server Windows

SUMMARY

Qualified software professional with a core concentration on Business and report designing.

Knowledge in BI reports design and development for end users to get deeper insights on their business points.

Experience in gathering, organizing, validating and analyzing data.

Knowledge of documentation and creation of use cases, functional specification requirements, workflows and data flows.

Knowledge of the Agile methodologies and demonstrated commitment to the quality of the products and service.

Strong ability in ETL and ELT development, implementation, optimization and maintenance.

Hands on experience in tuning databases, quality assurance (QA), query optimization, manual and automated testing.

TECHNICAL SKILLS

Databases

SQL Server 2010, MySQL 5.5, Oracle

Reporting

SQL Server Reporting Services (SSRS), Tableau Desktop, MS Excel

Scripting Languages

Python, PL/SQL, Batch Scripting

Web Programming Languages

HTML, CSS, JavaScript, PHP.

Web/ Application services

Apache, Tomcat, NIS Internet Information Server (IIS)

Operating Systems

Windows Server 2008, Linux(CentOS, Ubuntu), Unix

Tools

Microsoft Suite, Front Page/Dreamweaver, JIRA, MySQL Workbench, Selenium, Visio, Microsoft Project

EDUCATION AND TRAINING

Certified Scrum Master

Washington, D.C 2017

Virginia International University

MS in Information Systems Management (MISM), GPA: 3.80

Fairfax, VA May 2016

University of Llanos

Bachelor Degree in Systems Engineering

Villavicencio, Colombia

April 2011

PROFESSIONAL EXPERIENCE

Eagle Tech Corp

Business Analyst

Responsibilities

Springfield, VA

March 2017- September 2017

Gathered, organized and validated project data with customer and other stakeholders.

Created documentation for the project such as use cases, functional specification requirements, workflows and data flows.

Development of the website project throughout a Content Management System.

Preparing User acceptance testing for the final solution.

Work as the primary point of reference for all communication needs during the requirement gathering phase with the customer.

Villavicencio Elementary School

Intern

Responsibilities

Villavicencio,

Colombia

May 2009- April 2011

Developed and deployed an institutional academic information system management.

Designed a web application for pre-enrollment to elementary education institutes from Villavicencio city.

Migrated databases from MySQL 5.1 database to SQL Server 2010 using SQL Server Migration Assistant (SSMA) and SSIS packages.

Increasing the performance of queries through SQL Profiler and tuning them based on Query Execution Plan.

Improving institutional database by choosing a normalization form that speeds up the performance of the entire database along with a more efficient data storage.

Developed detail oriented reports with past and current student data in SSRS to predict quantity of new enrollments per year.

Environment:

Windows server 2008, SQL Server 2010, MySQL 5.1, MySQL Workbench, SSRS, SSIS, Python, HTML, JavaScript, PHP, JQuery, JIRA,Microsoft Fireworks.

Don Bosco High School

Villavicencio, Colombia

Institution website and network manager

January 2010 - December 2010

Responsibilities

Performed DBAs daily administrative tasks such as backup, installing updates, patches.

Updated and maintained website using JavaScript, HTML, CSS.

Monitored systems in order to improve performance and to start recovery action after system failure.

Analyzed network hardware and software requirements to suggest future upgrades.

Contact this candidate