Hire freelance Tsql Transact Structures Query Language

Find and hire skilled Tsql Transact Structures Query Language freelancers with Wono and get work done on a secure and flexible community-driven platform.
Browse top 3 freelancers by category - to view all resumes click:
Adrian Draghin
BASIC
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)
40 $
use cookies. By continuing to use this website you consent to our cookies policy. Privacy Policy
    WONO