Experience in creating database objects like stored procedures, functions, packages and triggers etc.
*Extensive working knowledge in creating other database objects like tables, views, indexes, sequences, primary key, foreign keys and constraints.
*Experience in writing SQL queries and generating reports.
*Strong understanding of the Data Warehouse, Data model and RDBMS concepts.
Designing, developing and deploying SQL Server Reports using SSRS.
Experience in defining Query for generating drill down reports in SSRS.
Expert in database backup, recovery and restoration of Transactional Database and SSIS files system and SSRS server.
Obtained several training such as Java, SQL, HTML5, CSS3, Bootstrap, Angularjs, NodeJS, and AEM.
Experience creating components in AEM.
Knowledge of Linux Operating System.
Basic knowledge of Amazon Web Services.
Basic Knowledge of PHP language.
Ability to manage workload.
Excellent on Microsoft-word, Excel, and PowerPoint.
07/2017 to 03/2018
Project EngineerWipro Limited
Worked on Linux operating system for internal project.
Worked on creating a concept of Wipro portal.
Worked on internal project which involves front-end, and back-end also involved in creating the look, layout, and features of website.
Identified technical requirement needed to create a website and solved the problem related to code.
Establish and maintain relationships with business teams.
Utilize specific business knowledge and general business acumen to support effective IT engagement.
Learn new technical skills regularly through in house and via external courses.
Training includes: Java, SQL, HTML5, CSS3, Bootstrap, Angularjs, Nodejs, AEM, AWS and PHP.
01/2016 to 12/2016
Manages cash intake, making deposit slips, covering shift, and organizing store.
Reports losses, employee behavioral issues, serious customer complaints, and other significant issues to upper level management.
Distributes payroll checks.
Organize paper work in excel sheet, emailing paper work and schedules to upper level management and employees.
Promotes specials, sales, and new products or services when relevant.
Addresses and resolves customer inquiries and complaints.
Get feedback for better customer service.
07/2015 to 12/2015
SQL DeveloperVastika Inc Catholic Health Initiative － Denver, CO
Involved to work with troubleshooting the stored procedures, functions, views, triggers and part to be increasing the performance tuning.
Created numerous T-SQL queries simple to medium involving joins, functions.
Involved in Update/Delete T-SQL queries.
Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key.
Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
Developed SSIS ETL packages to meet data flow needs.
Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
Managed source code, keeping track of project deliverability such as defects, requirements, tasks and versioning control with the using of Team Foundation Server.
Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2012 R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes.
Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
08/2013 to 06/2015
Sales Associates Provided high level of customer satisfaction through excellent sales services.
Helped customers need and provided assistance and information on product features.
Welcome customers to the store with smile and answer all their quires.
Suggest ways to improve sales such as planning marketing activities, changing to store's design.
Education and Training
Bachelors: Information SystemUniversity of Texas － ArlingtonInformation System
concept, Data Analysis, data modeling, debugging, HTML5, PHP, indexing, Java, Linux, mediation, Sales, spreadsheet, SQL, SQL Server, T-SQL