• Successfully installed SSMS (SQL Server Management Studio), Visual studio and SSIS (SQL Server Integration Service) to create databases, tables, developed packages to load data including insert, update, delete functionality and automated download files.• Built SSIS Package to load data into Microsoft SQL Server database • Inspected More than 5,00,000 datasets to check inaccurate and inconsistent data• SQL Server 2016 (Create System versioned table), Created tables with constraints and proper datatypes • Established test plan document that shows what functionality and how the production packages works exactly including expected and actual result with all steps for the client• Created and managed 5 SQL server databases

• Formalized technical documents for Data architecture and blueprint for database.• Launched oracle database with proper number of tablespaces, datafiles, control files, redo log files and archived logs using suitable drives.• Extract transform and load (ETL) the data, examined and refined data from Excel.• Developed Entity Relationship Diagram with MS Visio, Project Schedule using Microsoft Project.• Formalized tables with indexes, sequences and constraints using oracle.• Loaded data using SQL* Loader, PL/SQL scripts and using import/export and data pump utility.• Enlarged ( Cold & hot) backup and recovery strategies (User Managed/RMAN) to do the regular backups of the data at different locations (Offsite, Onsite) so client can have minimum loss of data in case of natural disaster or hardware failure.• Gathered project requirements and generated prerequisite document, data warehouse and used data mining techniques for Travel Experts Agency including partitioning, materialized views, parallel execution, analyzed data using Tableau and prompted different types of reports. • Performed database tuning and performance monitoring including database auditing. • Explored store procedures and triggers, Produced SLA (Service Level Agreement) for backup and restore procedures.• Originated Proposal for client to defined what are the features, benefits, what problem has been solved and including detailed budget of the project.• Experienced in managing and deploying windows servers, virtual environments.• Client received easily commission tracking system, monthly reports, project was delivered before deadline and within budget.

• Greeted customers in a professional, welcoming manner to determine needs and to make valuable recommendations• Constructed and managed employee schedules with store manager using POS system, restocked, arranged and organized merchandise in front lanes to drive product sales• Mentored new team members on POS system operation, customer strategies and sales goals• Processed POS transactions, including cash, debit and credit transactions and refunds