Garima Panta

**** * ****** ***** *****, Irving Texas, 75038

Mobile No: +1-409-***-****

E-mail: ac8hl8@r.postjobfree.com

SQL Developer

Professional developer with best work ethics and dedication to work

2+ years of professional experience as SQL Developer with MSSQL 2016/2012/2008.

1 year’s professional experience in Healthcare Industry

Experience in T-SQL Programming using DDL, DML, DCL commands for various business applications.

A professional database developer with expertise on every aspect of efficient development, deployment and maintenance.

Proven experience on working with SQL server created databases, tables, and retrieving the data from database, stored procedures.

Hands on expertise on developing complex Queries, Indexes, Cursor, Views, Functions and Joins.

Involved in all the stages of Software Development Life Cycle (SDLC) and Agile Methodology.

Experience in developing reports using Crystal Reports, SSRS and Power BI.

Quick learner excellent team player, hardworking developer with excellent interpersonal, communication, and presentation skills.

EDUCATION

Master of Science in Computer Science GPA~3.8/May 2017 Lamar University, Beaumont Texas

Bachelors of Engineering in Computer Engineering GPA~3.8/Jan 2014

Kathmandu Engineering College, Kathmandu, Nepal

(Electives: XML Technologies, Data Mining, Big Data)

SKILLS

Databases : MSSQL 2016/2012/2008

Database Tools : SQL Profiler, SQL Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, Activity Monitor

Operating Systems : Windows 8/7/NT/95/98/2000/XP, Linux

Reporting Tools : Crystal reports, SSRS, Power BI, Bullseye

EHR Systems : Meditech, Soarian, Medhost, NextGen, Mosaiq

EXPERIENCE

The Shams Group August 2017-Present

Software Engineer

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views utilizing T-SQL code and SQL joins to generate data reports.

Skilled at optimizing large complicated SQL statements and tuning stored procedures by creating/modifying indexes or query structure. Successfully able to reduce the query time over 75%

Creation and Maintenance of Datawarehouse and DataMart’s

Experience in creating formatted Adhoc reports, Dashboards, drill down, subscription, parameterized reports using PowerBI

Transition existing reports from existing reporting platforms to Bullseye reporting application as well as developing new reports as assigned.

Create effective Business Intelligence (BI) solutions and analytical dashboards / analytical tools for business users.

Followed SDLC methodologies in performance of all development activities, including design, development, test and quality assurance support

Hands-on experience with SSRS and Crystal Reports

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Expertise in handling data from multiple database servers

Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.

Develop GUI interfaces using Open Database Connectivity (ODBC) to connect to SQL.

Department of Speech and Hearing Science, Lamar University Oct 2015- May 2017

Graduate Assistant

Created, Updated and Managed the SPHS webpages for faculty, news and seminars.

Maintained existing SPHS web site and various applications.

Assisted the department with Graduate Admission works.

Worked as a single point of communication for writing the contents for the departmental webpages

Global Resource for Audiology Information Networking (GRAIN) Nov 2015- Present

http://globalaudiology.org/

Web Developer and Designer

Modified the default WordPress theme and developed it as per requirements and validating them.

Created Web pages using HTML, JavaScript and CSS.

Involved in Maintenance of the Web-Application.

Fixed number of defects during implementation and debugged the application within the deadlines

Update the webpages based on the information received from different authors across the globe.

Reference:

Dr. Vinaya Manchaiah

Director of AudiologyDepartment of Speech and Hearing Sciences, Lamar University, Beaumont, Texas Email: ac8hl8@r.postjobfree.com Website: www.vinayamanchaiah.com Tel: +1-409-***-****

TRAININGS

OOP (with c#, ADO .NET, ASP .NET, CSS), Basic Computer Hardware Course, SAP (ERP Overview)

Contact this candidate