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
EXPERIENCE
ByteSizedSolutions - Chicago, Illinois
Jr. Database Analyst Consultant
Dec 2019 - Oct 2020 (11 months)
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;
Part of a small team that did some research on the necessary steps to add Power BI to the company portfolio;
Created some demo reports in Power BI Desktop and published 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 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 supplies 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 tool in term 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 which 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 - Jun 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 Microsoft SQL Server 2012 database.
Handled and imported data from a database management system FOXPRO system to Microsoft SQL Server.
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;
Configured and validated database backup routines on a regular basis;
Performed tasks related to technical support and maintenance of SQL Server including installation of new releases/patches of SQL Server;
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;
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.
Created SQL tables, stored procedures, queries, and SSRS reports;
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
CERTIFICATE:
JavaScript Basics for Beginners
JavaScript Understaing the Weird Parts
Websites, IT & Software
MongoDB
node.js
Oracle Database
SQL
T-SQL (Transact Structures Query Language)