Sql Server Customer Service

Quality Assurance Engineer

With * years’ experience designing, coding, testing and supporting next-generation solutions in Windows environments. Possessing strong technical and customer service skills. Proficient and knowledgeable on assortment of technologies, Access, PowerPoint, Crystal Report, Excel, MS SQL Server, MS Visual Studio, MySQL, PowerClaim, EMR / EHR software, SharePoint, InfoPath

Skills include:

Proven ability to manage multiple tasks and meet deadlines

Excellent problem solving, analytical and organizational skills

Knowledge of MS SQL Server

SQL SERVER SSIS/SSRS, SSAS reporting and analytical tools usage experience

Project Management

Test Complete Knowledge (An automation test tool) and Tosca Testsuite, Sigma Software

EHR (Epic)

HP Load Runner

ChartLogic (EHR)

ETL/integration tools knowledge(Informatica, QlikTech,MySQL, SSIS, Hibernate, PenTaho)

SQL SERVER Database Administration

Persistence and the ability to work through and solve problems

Excellent creative thinking skills, and manual dexterity

Ability to identify and solve complex technical problems

Detail-oriented with flawless communication skills

Strong analytical and time management skills

Pacific Systems, Atlanta, GA • Atlanta, GA 10/2012 - Present

Application Developer

Ensure technical and functional designs using SSIS (Sql Server Integration Service) to meet business requirements.

Manage multiple projects simultaneously Project Management tool

Learn and apply new technologies quickly.

Maintain understanding of current web technologies and programming practices through continuing education, reading and participation in professional conferences, workshops etc

Analyzed, extracted and manipulated flat and fixed data files utilizing UNIX scripting tool with usage of SSIS.

Applied technical considerations into web site design plans, such as budget equipment, performance requirements

Understanding of Object-Oriented design principles using MS Visual Studio

Working knowledge of software development methodologies

Created and Executed Automated Coded UI Tests.

Created Data Driven Test by VS2010 and MTM (Microsoft Test Manager)

Created Automation Framework for regression testing.

Created and Executed Automated Web Performance Tests.

Created and Executed Automated Load Tests. Document test plans, testing procedures, and test results.

Identify problems uncovered by testing or customer feedback, and correct problems or refer issues to the appropriate destination for correction.

Knowledge of Agile/SCRUM Methodology

Deployed database products into production SQL Server 2008 environments

Have an Understanding of SQL and writing and executing queries against databases

Developed technical documents using Crystal Report for various project deliverables

Integrity and reliability providing support for all IT-supported technologies with an organized and pro-active focus

Assist in developing custom Web parts for application support toolset. Routinely troubleshoot issues and support internal users.

Develop and validate test routines and schedules to ensure test cases mimic external interfaces and address all browser and devise types

Help Provide the functionality for developing multitiered, Web-based applications using J2EE

Creating ASP.NET Web Projects in Visual Studio 2013 _ The ASP.NET Site

Code Editing ASP.NET Web Forms in Visual Studio 2013 _ The ASP.NET Site

Steps to Create SSIS Package - CodeProject

Help Dev in SharePoint (Dashboard)

Asist Understanding and Enforcing Data Integrity

Pacific Systems, Atlanta, GA • Atlanta, 09/2009-10/2012

Business Intelligence Analyst

Design and develop dashboards, scorecards, reports and other analytics using Epic Clarity, Reporting Workbench, Crystal and other Epic and Business Objects tools

Design and develop data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching

Consolidated information from accounting applications, third-party market data and internal equities/fixed income applications Applying SSIS

Used the graphical design tools that SQL Server Integration Services (SSIS) provides to create packages for execution

Contributed to standardizing content from disparate databases, enabling sales and support staff to quickly respond to customer requests.

Design and implement reporting data sources and complex

Analyzed various SQL Server databases for performance related issues

SharePoint usage in creating Web-enabled, group-scheduling system for a large university, allowing students to view and print schedules for current and future semesters. Delivered solution on time, on spec and on budget.

Assisted in SQL Server 2005 migration process to SQL Server 2008

Developed and tested storage strategies and disaster-recovery plan for large manufacturing company’s operational database, delivering solution that guaranteed recovery performance and high availability.

Test and validate dashboards and reports

Assisted in delivering quality data integration projects using SSIS

Used Load Generator to generate load against application by following scripts

Knowledge of Analysis assembles logs from various load generators formats reports for visualization of run result data and monitoring data

Knowledge of data modeling and designing databases in Sql Server 2005, 2008 and Informatica

Geac Interealty • Atlanta, GA 6/2005-9/2009

Project Technician

Develop plans to safeguard computer files against accidental or unauthorized modification, destruction, or disclosure and to meet emergency data processing needs.

Assisted in SQL Server 2005 migration process to SQL Server 2008

Experienced with data modeling and database design methodologies

Running stored procedures also manipulate sets of rows in tables

Enable parameters in rows, columns on tables

Manage multiple projects simultaneously with the Project Management tool

Learn and apply new technologies quickly. Create views that calls data from tables which can run at any time

Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.

Design and develop dashboards, scorecards, reports and other analytics using Epic Clarity, Reporting Workbench, Crystal and other Epic and Business Objects tools.

Test and validate dashboards and reports.

Gather and document user requirements in conjunction with the Business Intelligence department.

Provide expertise regarding Clarity data content.

Train and provide support to users of Clarity data and analytic tools.

Support users in integrating Clarity data and analytic tools into their workflows..

Design and used PL/SQL and Project Management in packages, procedures, function and types to implement database scheme and process flow

Store, retrieve, and manipulate data for analysis of system capabilities and requirements

Utilization of data base and file structure concepts in program designs in conjunction with V Cobol

Database maintenance, performance tuning, query optimization, and database backups Database upgrades and patches, replication

Maintained report uniformity with the use of SSRS (Sql Server Report Service) template

Education & Training

MS. Information Tech, Florida Institute of Technology, Melbourne, FL 2016

BS, Business Information Systems, DeVry University, Atlanta, GA

AA, Microcomputer Specialist, North Metro Technical College, Acworth GA

DBA Workshops: SQL SERVER Database Administration, Informatica Analytics 2007

DBA Workshops: Intro to Oracle 2004 9i,Oracle Database 10g Administration 2006

Microsoft Dynamics CRM 2011Workshops 2011

Contact this candidate