SQL Developer Adrian Draghin, Websites, IT & Software
Summary
SSMS, SSRS, Power BI, SSDT-BI, T-SQL, PL/SQL, MySQL, Oracle, MS Access, FoxPro, Report Builder, Query Writing, ETL, JavaScript, NodeJS, HTML, MS Office, git, GitHub, VirtualBox, Visual Studio, TOAD
Certificate:
DePaul University - Chicago, Illinois 04/21-06/21 Course on Big Data and NoSQL
EXPERIENCE
Byte Sized Solutions - Chicago, Illinois
Jr. Database Analyst Consultant
Dec 2019 - Oct 2020 (11 months)
As Jr. Database Analyst Consultant I provided database support to the employees of the financial department from Advocate Health Care Company. Some of the tasks that I performed were:
Created ad-hoc reports per client request;
Modifying stored procedures by adding or removing logic;
Creating new SSRS reports from existing stored procedures or from newly created ones;
Altering existing SSRS reports according to client request;
Used the SSMS to extract data from the client in-house database for one time reports or to create new SSRS reports;
Used the SSMS to validate or identify bugs on existing stored procedures used by the SSRS reports;
Used the SSMS to alter the existing stored procedures or to create the new ones, to create new tables or to alter existing tables;
Used the SSMS to identify to cause of the falling SQL Jobs;
Used the SQL Business Intelligence Studio to create new SSRS reports from the existing stored procedure or from new created stored procedure;
Used the SQL Business Intelligence Studio to alter the existing SSRS reports;
Created some demo reports in Power BI Desktop and published them into the Power BI Report Server to be presented as a demo to the entire team to display the benefits and capabilities of the new reporting services;
Created a new report on Power BI and deployed it on the Power BI Server to display the team overall goal;
Created a dashboard from the new deployed Power BI report;
Configured and deployed an On-premises data gateway to supply with fresh data the new Power BI report created;
Timisoara Public Transport Company - Timisoara, Romania 10/14 - 4/18
IT Project Manager
Jun 2017 - Apr 2018 (11 months)
As IT Project Manager together with the Chief Executive Officer and the other members of the Board of Directors, I participated in the elaboration of the investment plan as well as the implementation deadlines;
Coordinated 4 departments with more than 50 people and 4 major projects:
VeloTM - a self-service stations network for bicycle renting in Timisoara;
24Pay - an electronic wallet that provides payment services for public transportation travelers in Timisoara;
WizOne a human resource administration program designed to covers requests and approvals flow for annual leaves and other types of absences, certificates issuing, training, and to build strategies and budgets for managing workforce-related costs, at various levels
WizSalary - a payroll and personnel administration program designed to provide accurate and adaptable computerized work tools in terms of labor law amendments.
Provide IT leadership to ensure delivery of practice projects on time, on budget, and meeting scope and quality expectations;
Contribute to the IT strategy by providing proposals that include: cost, solution selection, and technology insight;
Coordinating projects and initiatives related to the program including but not limited to business requirements gathering, testing, and implementation of various modules of the selected platform;
Acting as the business relationship manager for the various internal organizational groups;
Establishing work plans and staffing for project activities, iterations, or phases, and arranging for recruitment or assignment of project personnel as needed;
Providing leadership and motivation to project team members throughout the program life-cycle and conferring with project staff to outline work plans;
Track and log project issues and risks.
Acting as the primary liaison between external partners and internal departments during implementation phases;
Provided prevention and event work, bound on schedule, along with my team;
Provide weekly, monthly and annual status reports;
Senior DBA Developer
Aug 2015 - Apr 2017 (1 year 11 months)
As Senior DBA Developer, I worked with other management staff to determine and implement specific organizational technical needs;
Provided support to migrate an old accounting system that used FOXPRO databases to new applications that use Microsoft SQL Server 2012;
Extracted data from the FOXPRO database and prepared to be inserted in a new Microsoft SQL Server 2012 database;
Communicated cross-departmentally regarding project scope, progress, and findings regarded data extraction and conversion;
Administered an Oracle 10g database: - management of back-up, creating triggers, and reports using PL/SQL;
Created SQL tables, stored procedures, queries, and SSRS reports;
Created sub-reports and linked reports from queries in SSRS;
Suggested new queries and SSRS reports;
Used the SQL Business Intelligence Studio to create new SSRS reports from the existing stored procedure or from a newly created stored procedure, or to alter the existing SSRS reports;
Used the SQL Business Intelligence Studio Performed tasks related to technical support and maintenance of SQL Server including installation of new releases/patches of SQL Server;
Used the SSMS to create new SSRS reports from the existing stored procedure or from the newly created stored procedure;
Used the SSMS to extract data from the in house database for one time reports or to create new SSRS reports;
Used the SSMS to validate or identify bugs on existing stored procedures used by the SSRS reports;
Used the SSMS to alter the existing stored procedures or to create the new ones, to create new tables or to alter existing tables;
Used the SSMS to validate or identify bugs on existing stored procedures used by the SSRS reports;
Used the SSMS to identify to cause of the falling SQL Jobs, to maintain and alter the indexes, and to fix the corrupted databases;
Responsible for the support of all SQL Server databases within the group's scope. This includes all traditional production DBA support roles such as upgrades to new releases of SQL Server;
Configured and validated database backup routines on a regular basis;
Administrated and provided technical support for a Bike Sharing project Velotm;
Coach / mentor new team members as appropriate on technical and process front;
I have experience with usage, installation, repair, and configuration including but not limited to Microsoft Windows XP/7/8/10, Windows Server 2003/2008/2012, and Imaging;
Installation, repair, and configuration of Computer Hardware (internal components and peripherals), Multifunctional Printers, Intermediate Networking;
Ensures appropriate operational planning is executed to meet business needs;
Provided appropriate documentation;
Provided support on the use of Microsoft Office Suite Tools(Access, Word, Excel, PowerPoint…);
Organized and managed multiple tasks/assignments at the same time;
SQL Programmer Analyst
Oct 2014 - Aug 2015 (11 months)
Provided guidance for problems and questions, regarding the company's database administration (FOXPRO, MS SQL, and MySQL);
Created triggers and reports for the Sales Department and Monitoring Department on the Oracle 10g database;
Created subreports and linked reports from queries in SSRS;
Used the SQL Business Intelligence Studio to alter the existing SSRS reports;
Used the SSMS to create new SSRS reports from the existing stored procedure or from the newly created stored procedure;
Used the SSMS to extract data from the in house database for one time reports or to create new SSRS reports;
Used the SSMS to validate or identify bugs on existing stored procedures used by the SSRS reports;
Used the SSMS to alter the existing stored procedures or to create the new ones, to create new tables or to alter existing tables;
Used the SSMS to validate or identify bugs on existing stored procedures used by the SSRS reports;
Used the SSMS to identify to cause of the falling SQL Jobs, to maintain and alter the indexes, and to fix the corrupted databases;
Provided off-hours support to Sales Department and Traffic Surveillance Department;
Data back-up and restore, for all PC's in the company (around 500);
Handled specific applications and operating systems installation/configuration;
Debugged various hardware and software related problems that occurred in different company locations;
Scheduled corrective and preventive IT product maintenance;
EDUCATION
Ioan Slavici University - Timisoara, Romania 2010- 2014
Bachelor's degree, Computers and Information Technology
Udemy courses:
JavaScript Basics for Beginners
JavaScript Understaing the Weird Parts
Websites, IT & Software
Oracle Database
node.js
T-SQL (Transact Structures Query Language)
MongoDB
SQL