Adrian Draghin

Mount Prospect, IL

TECHNICAL SKILLS

SSMS, SSRS, SQL Profiler, Power BI, SSDT-BI, T-SQL, PL/SQL, MySQL, Oracle, MS Access, FoxPro, Report Builder, Query Writing, JavaScript, NodeJS, HTML, MS Office, git, GitHub, VirtualBox, Visual Studio, TOAD

EDUCATION

DePaul University Certificate, Big Data and NoSQL

Ioan Slavici University, Timisoara Bachelor's degree, Computers and Information Technology

PROFESSIONAL EXPERIENCE

Catholic Order of Foresters, Naperville, IL April 2022 - Present

Application Developer

Developing, supporting, and integrating business applications and databases using the following tools: T-SQL, Reporting Services, Azure Data Studio, Azure DevOps, and Redgate Compare.

Participated on the team to analyze reporting platforms Power BI and Qlik.

Developed Sales Reporting reports and processes using the Power BI platform.

Worked to convert old SSRS Sales reports to Power BI.

Created dataflow to support the newly created Power BI reports.

Created the logic used for the RSL on Power BI and implemented security on Reporting Service.

Assists team members in eliciting and refining project business requirements to develop and modify computer applications.

Assists in translating business requirements to technical designs and specifications.

Develop and debug computer-based solutions of moderate complexity.

Develop, execute, and document test plans.

Work with quality assurance job functions (product owners, analysts, and end users) to ensure that advanced solutions meet required specifications.

Actively participate in project meetings and discussions.

Support production of computer-based solutions.

Developing SQL Server stored procedures, functions, views, or analyzing processes for query optimization.

Developing reporting solutions using SSRS.

Surya, White, GA November 2021 - April 2022

Database Analyst

Modify stored procedures and functions by adding or removing logic.

Create new stored procedures for new reports or to support new table created for uploading data.

Create new SQL Server Jobs for the newly created stored procedures or to alter existing SQL Jobs

Create new SSRS reports and modify existing ones.

Modify existing Crystal Reports based on requests from the Sales and Marketing Department by adding new data sources for creating new calculated fields or just new fields.

Investigate and monitor slow running queries across multiple databases using SQL Profiler and propose solutions to fix problems.

Analyze resulted traces, SQL queries, or stored procedures and apply the changes to enhance the performance of the database.

Provide support for the process of moving a database in the PIM (Product Information Management) system.

To fix data do not conform with the PIM standards to be prepared for migration.

Daily adding and modifying the products inventory feed that is sent to eCommerce store clients.

Create new workflow tables and processes to support the needs of the Sales and Marketing Department for new reports.

Automating SSRS reports to run on specific dates and times, and to send the report to specific persons and departments.

Byte Sized Solutions LLC, Chicago, IL December 2019 - October 2020

Junior Database Analyst Consultant

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 new ones, to create new tables or to alter existing tables.

Used the SSMS to identify the cause of the falling SQL Jobs.

Used the SQL Business Intelligence Studio to create new SSRS reports from the existing stored procedure or from newly 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 newly deployed Power BI report.

Configured and deployed an On-premises data gateway to supply fresh data the new Power BI report created.

Timisoara Public Transport Company, Timisoara, Romania June 2017 - April 2018

IT Project Manager

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:

oVeloTM - a self-service stations network for bicycle renting in Timisoara.

o24Pay - an electronic wallet that provides payment services for public transportation travelers in Timisoara.

oWizOne 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.

oWizSalary - 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 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 lifecycle and conferring with project staff to outline work plans.

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.

Timisoara Public Transport Company, Timisoara, Romania August 2015 - June 2017

Senior DBA Developer

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 regarding data extraction and conversion.

Administered an Oracle 10g database: management of back-up, creating triggers, and reports using PL/SQL.

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 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.

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.

Ensures appropriate operational planning is executed to meet business needs.

Timisoara Public Transport Company, Timisoara, Romania October 2014 - August 2015

SQL Programmer Analyst

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 sub reports 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 store. 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 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 the 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 PCs 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.

Contact this candidate