Hire freelance Microsoft Sql Server

Find and hire skilled Microsoft Sql Server freelancers with Wono and get work done on a secure and flexible community-driven platform.
Browse top 28 freelancers by category - to view all resumes click:
Joanna Joseph
BASIC
Data Analyst Joanna Joseph, Websites, IT & Software
PROFILE SUMMARY  PGD (Post Graduate Diploma) in Data Analytics and Business Intelligence from Unitec Institute of Technology, New Zealand  3 years of experience as a Data and Reporting Analyst with CBRE Limited, Auckland, New Zealand  Holds sound knowledge of SQL and Database Management  6 years of experience as an IT professional in Banking, Automobile, Property and Commercial Real Estate Industries  Instrumental in preparing solutions by determining and designing client specifications and standards.  Well versed with Data analysis and Dashboard creation in Advanced Excel, Qlik Sense and Tableau.  Quick learner with attention to detail, Critical thinker and Effective communicator. WORK EXPERIENCE CBRE New Zealand Engineering Analyst (ANZ Bank) Oct 2017 – Nov 2020  Analysis and Reporting on compliance, Health & Safety, portfolio metrics to identify trends and to develop cost effective initiatives.  ANZ Asset Database & CMMS Management  Provided regular analysis, insight to the Facility Management team and our Client.  Developed dashboards to monitor waste, quality assurance, work order overdues, capex plan.  Supported and developed long range budget and handover  Worked with procurement lead to provide analysis and insight at different stages of tender. Technologies/Tools : Tableau, Advanced Microsoft Excel, Service Insight (CMMS), SQL, JDE ERP, Microsoft Teams, Qlik Sense Client : ANZ Bank Domain : Banking and Commercial Property Infosys Limited (India) Systems Engineer Oct 2013 – Jan 2016  Worked on Design, development, validation, implementation and other support activities in line with the architecture requirements  Played the role of a mainframe developer in two significant projects for a leading automobile client.  Awarded the best performer as a developer for the project titled “Adding a new plant in Mexico (Salamanca) for Toyota Motor Sales”.  Worked as one of the senior developers for the project titled, “Team Member Lease Benefit Program” for Toyota Motor Sales  Developed BRD (Business requirement gathering) and designing applications  involved in mentoring and training my team in coding and testing the proposed design. Technologies/Tools : IBM Mainframe technologies (COBOL, JCL, CICS, VSAM, REXX), IBM DB2 & IMS Databases Client: : Toyota Motor Sales Domain : Automobile Manufacturing TECHNICAL EXPERTISE  Tools & Libraries: Advanced Microsoft Excel, Microsoft Office Tools, Qlik sense, Tableau, Microsoft Visual Studio, SQL server management studio, Eclipse for Java, Jupyter Notebook, Scikit Learn library, Keras library, WEKA, Cougar budgeting tool.  CRM/CMMS: CBRE Service Insight, JDE, Infusion soft, ZOHO CRM  Programming Languages: C#, Java, Python, R, HTML, CSS, JavaScript (Knockout), SQL, VBA, IBM Mainframe technologies (COBOL, JCL, CICS, VSAM, REXX)  Database: IBM DB2 & IMS (2.3 years), SQL Server 2014  CMS: Drupal, Wordpress, Adobe Business Catalyst
Websites, IT & Software
Analytics
Business Intelligence
Data Visualization
Database Administration
Microsoft SQL Server
32 $
James Fuchs
BASIC
James Fuchs Resume James Fuchs, Websites, IT & Software
Summary: Experienced BA, DBA, Data Analyst and Software Developer and who just finished a one-year assignment working from home office using FoxPro as a front-end to a SQL Server back-end. I have skills and experience as follows. • An experienced Business Analyst capable of assessing processes and procedures, researching current technologies, performing gap analysis, and highly skilled in the deliverance of easy to understand reports, both written and verbal to stakeholders. • An experienced I.T. Project Manager using Waterfall and Agile methodologies to manage teams of programmers (internal and external) in support of project directives. • Experience in Change Control and related documentation in compliance with Sarbanes Oxley (SOX) auditing processes. • Over 25 years’ experience managing large databases – creation, analysis, importing of raw data, programming user access screens and reports as per needs of stakeholders. • Over 25 years’ experience programming in Microsoft Visual FoxPro and its precursors, from inception, data mapping, user access application coding, UAT (User acceptance Testing) and training. Specialties: • I.T. Project Management, utilizing both Waterfall and Agile methodologies • Business Analysis, Gap Analysis • Database design, programming, and maintenance • Development using Microsoft SQL Server as a back-end to a Microsoft FoxPro 9.0 Front-end Technical Skills: Software Applications All Microsoft programs including Microsoft Word, Excel, Publisher, Outlook, PowerPoint, Visual FoxPro, Microsoft OS from DOS 3.3 through Windows 10 Project Management Jira, Excel ERP Applications MFG/Pro, by QAD Database Applications Microsoft SQL Server and Visual FoxPro Engineering Applications Autodesk’s AutoCAD and related software Certifications Currently preparing for PMP certification Professional Experience: Software Developer Sept. 2019 – Oct. 2020 Data Age Business Systems, Inc, Clearwater, FL (remote assignment) • Microsoft Visual FoxPro 9 front-end developer to Microsoft SQL Server back-end. • Upgraded pawnshop POS software to utilize on-line sale of store’s stock, using API calls to website. • Updated and maintained software, including debugging of errors, both from internal sources as well as a 3,500-customer base. • Enhanced existing features to satisfy customer base desires. • Addressed work tickets from Jira project management software. Business Analyst / IT Project Manager Oct. 2013 – Nov. 2015 Quanex Building Products, Davenport, IA ● Analyzed and performed gap analysis on existing processes involving the separation, melting down then reformulating aluminum for recycling. Assisted teams in constructing plans for improvement, from purchasing, inventory, and machine operation through to the end product. Providing a main plan and possible alternatives. ● Acted as liaison between executive (C-Level) stakeholders/non-technical participants and front-line programmers. Gathered requirements, consulted with both inside and outside consultants, implemented plans. Assisted in the creation of project budgets, facilitated progress meetings to keep stakeholders abreast of progress, conducted risk analysis throughout the entire process. ● Inspired and lead a team of programmers, both internal and external to reach the goals set forth in the project plans of several initiatives, all while maintaining strict adherence to company strategies, policies and procedures, as well as compliance within the SOX (Sarbanes/Oxley) guidelines during the entire SDLC all in support of the company’s both short- and long-term strategies and goals. ● Maintained and upgraded production software, including ERP programs: MFG/Pro and MLS, both by QAD, inc., as well as EDI processes. ● Project Management from start to finish supporting approved plans, focusing on intersection of I.T. processes and manufacturing operations. ● Created and managed UAT (User Acceptance Testing) plans. ● Maintained Change Management processes through change control software for SOX compliance utilizing SharePoint. Satisfactorily succeeded in passing audit. Data Analyst - Telecommute Contract Mar. 2004 – Sept. 2019 (seasonal) Ogden & Fry, LLC, Chicago, IL (remote contractor for satisfying technology needs) ● Importing, cleaning, data-mapping, then parsing exceptionally large (over 1 terabyte) raw ASCII data files employing Microsoft SQL Server in support of political campaigns. ● Managing data warehouse, keeping current 8.3 million record relational database, data mining, querying, and reporting as per needs of political campaigns. ● Analysis of 20 plus years of voting history allowing the determination of the best people and districts that require concentration of efforts. ● Managed two political campaigns with successful results (candidates were elected) Business Analyst/I.T. Administrator 2008 - 2013 The Law Group, Chicago, IL ● Assisted in the upgrade of old computer systems and software to bring company up-to-date with current hardware and software including Microsoft Office and its ancillary programs, enabled client to expand his practice ● Compiled and reorganized over 12,000 client records and associated data into one comprehensive database and wrote a program using Microsoft Visual FoxPro 7.0 through 9.0 enabling users to search, edit, and report data including automated e-mail communications with clients and scanned document control. Greatly increased communication between law firm and it's clients. ● After several years, performed analysis of off-the-shelf programs aimed at law firms, chose one and assisted in the setup and importing of all legacy data, allowing for the seamless transition to new program. Designed then setup automated backup process. Trained all employees on the use of this new program Business Analyst/Database Programmer – Microsoft FoxPro – Various Contracts 2002 – 2013 Including: ● Digital Pix Composites, Crystal Lake, IL o Programmed database front-end using SQL back-end ● Several Law offices including: o Law office of Steven A. Leahy, Chicago, IL o The law firm of Touhy and Touhy, Ltd Other notable achievements 1990 – 2008 Team Leader, CAD and Documentation Control • Atlas Electric Devices Co., Chicago, IL o Assisted in the installation and configuration of a new ERP system. Customized for company use the manufacturing software MFG/Pro (QAD, Inc.). Exported company’s entire manufacturing system and inventory data from a DEC VAX system to PC-based networked PCs. Implemented engineering change order modules that changed and maintained over 4,000 bills of material. o Assisted in the implementation of company-wide MRP (Material Requirements Planning) software system to manage manufacturing of large scale machines. Extracted, modified and replaced data out of and back into system including bills of materials to support “just in time” inventory control. o Managed technical writers developing user manuals of equipment • Computer Output Process Engineering, Inc., Tucson, AZ o Helped Design and build paper-handling machinery • Vega Technologies ,Inc., Tucson, AZ o Helped design and build world’s first computer controlled DNA synthesizer
Websites, IT & Software
Database Administration
Database Development
Database Programming
Microsoft SQL Server
Programming
50 $
Willie Li
BASIC
SQL Developer - remote Willie Li, Websites, IT & Software
SUMMARY OF QUALIFICATIONS • Strong business analytical skills, outstanding business knowledge in Finance, Insurance, Healthcare, Ecommerce, Retail and Media. • Excellent database/data warehouse design and administration, data transformation and data analysis expertise. • Solid full life cycle business application development experience. • Great background in Computer Science, Mathematics and Statistics. • Seasoned object-oriented/Web/E-Commerce/Window application programming and problem-solving experience. COMPUTER SKILLS: • Languages: C#, ASP/ASP.NET, SQL, PL/SQL/T-SQL, Python, PowerShell, VBScript/JavaScript/jQuery/CSS/SCSS/XSL, Visual Basic, C/C++, Java, XML/JSON/HTML/DHTML, Ajax, PHP • Database: MS SQL Server (from SQL 6.5 to SQL 2017), Redshift, MySQL, Oracle, MS Access, DB2, Firebird, MongoDB • Software/Tool: Visual Studio, SQL Server SSIS/SSRS/SSAS, SSMS/Azure Data Studio, SQL Workbench, MS Power BI, Tableau, Crystal Reports, Elasticsearch/Kibana, ER/Studio Data Architect, MS Office/FrontPage/PowerPoint/Share Point, Visual Source Safe, Agile, Bitbucket/Git, Jira, ZappSys, Magneto, Fishbowl, Shipworks PROFESSIONAL EXPERIENCE Radiological Society of North America (Oak brook, IL) SQL /ETL Developer 04/2019-Present Work closely with business user and application developer to analyze/enhance the existing relational/non-relational database solution, create new database solution, redesign the data warehouse to better serve the business. • Highly proficient in T-SQL programming, create/update complex stored procedure, user defined function/type, view, trigger and index on SQL Server, improve the query performance, decrease the CPU usage and disk IO. • Create/enhance ETL packages to auto retrieve data from FTP server, dynamic web page and different API call, transform data from different format to relational data, store the transformed data to Redshift and SQL database. Store and manage data files in Amaze S3. • Use SSRS/Power BI to build customized interactive/parameterized/drill down reports and dashboard. • Create ETL project to update company level Elasticsearch data. • Design and develop ETL solution using SSIS/C# to read and reformat special survey data for business reporting. • Create ETL solution using SSIS/Python to read vendor data file, fix the input data issue and transfer the data for analysis needs. • Redesign the data warehouse schema, improving the loading data job’s efficient, decrease job’s running time. • Create and maintain varies daily/weekly/monthly SQL Server Agent jobs. These jobs are used to prepare and transform data from different source to SQL database and enterprise data warehouse. • Set up a new SQL ETL development server, create new SQL Server Agent jobs. Unique Fitness Concepts (Vermont Hills, IL) Senior Developer/Data Analyst 03/2017 – 04/2019 Interact with business user to define the requirements for business need. Work with different software vendors to customize their solution to fit Unique Fitness’s need. Use SSIS/C# to build ETL tools to integrate data from different sources. Enhance and support Unique Fitness’s web site, troubleshoot site related issues. • Created, maintained and updated email, invoice, label and packing slip templates in Shipworks. • Maintained and updated Unique Fitness website using Magento software. • Monitored, cleansed and mapped more than 100 vendors' product and price data source. • Designed and developed ETL solution using SSIS/C# to maintain product and pricing. • Used SSRS/Power BI to generate reports to satisfy business needs. Li & Association (Westmont, IL) Consultant 09/2004 - 03/2017 Built business solution for different clients. • Designed, created and maintained a stock trade analytical tool. Developed a ETL tool to auto retrieve market data from different web sites. Built and maintained a SQL server database to store trade and market data, generated different trend reports for business user. • Designed and developed different solutions to help client monitoring/cleansing/mapping/integrating healthcare data. • Designed, created and enhanced business reports for different clients. Bank One/JPMorgan Chase (Chicago, IL) Senior Developer /DBA 08/2002 - 08/2004 Worked with Bank One capital marketing business supervisor, designed and built applications/database to achieve SuperBase model (fix income prepayment modeling), created industrial recognized software and reports. • Designed, created, maintained and fine-turning SQL Server database and managed the database security. There are more than 100 GB data in 11 databases, more than 300 stored procedures and 50 DTS and jobs to implement the business rules. • Processed the loan level data received from six different issuers, pool level data from Intex to produce the data for SuperBase application. • Built and enhanced SuperBase application. This is an analysis tool used to analyze loan level (current and future) and pool level (current) data. It also generated monthly residential ABS reports, loan forecast data (ARM and Fixed), on-demanding reports/data required by business users and clients. • Built a data warehouse using SuperBase monthly report’s results and marketing data. • Built SuperBase client software to allow client analyzing their loan information and generating forecast data based on the marketing information. • Created Microsoft Word templates used for monthly reports. Tellabs (Lisle, IL) Consultant (Web Developer) 10/2001- 05/2002 • Enhanced and supported Detailed Specification System. The DSS software is an intranet application designed to increase the productivity of the deployment engineering group. Technium (Chicago, IL) Consultant 09/2000 – 08/2001 Designed and built applications for eSkye Solutions, Inc. (a service network and technology solutions provider for the global beverage industry) • As a web developer: built a web application allowing eSkye customer service setting up and maintaining user's profile and their priority on-line. • As a SQL server developer: mapped data between existing data structure and newly implement data structure, converted data from existing database and other sources to new database. Created and modified stored procedure, triggers, user defined functions and built DTS packages and jobs. Designed and built applications for RollingStone.com (an internet music distribution) • As a web developer: involved in the full life cycle development of client's system. Built a web-based administrator tool to allow user to change their data on-line. Created and modified COM components to add new functionalities. • As a SQL developer: created COM components to be used in SQL server jobs. Created and modified stored procedures, triggers, user defined functions and built DTS packages and jobs. Stargate Communications Inc. (Oak Brook, IL) Web Developer 03/2000 – 09/2000 Designed and built several applications for different client. • Sole responsible for building the B2B web site www.comm-2000.com. Worked with business owner to define the business need, created the database, designed and coded the web site. Used SQL DTS/Jobs to translate the product and client information between UL and www.comm-2000.com. • Enhanced www.mba2mba.com web site and its database. Coded most of the site functionality including member sign on/registration, colleague search and site administration functionality used to maintain member information on-line. • Used SQL Server, Crystal Report as the tools to sort and group the raw data from www.OurHouse.com and produced meaning reports for the client. Newspaper Services of American (Naperville, IL) Senior Developer 07/1998 – 03/2000 • Designed and built a client-server application to maintain the company’s vendor information. • Installed a new MS SQL Server. Designed and set up a new MS SQL Server database, converting the existing data into the newly created database. • Designed and built an interface application to map client’s data into NSA system. • Designed and coded company’s intranet application. NCH Promotional Service (Lincolnshire, IL) Developer 01/1997 – 07/1998 • Designed and modified current system (Batch and Front-end) to accomplish business changes. • Directly contacted manufacturers, obtained requests and completed tasks. • Supported current retailer system. Metamor Technologies (Chicago, IL) Consultant 06/1996 – 01/1997 Designed and built several applications for client United Healthcare of Chicago. • Created, reformed current system (batch process) to achieve client’s request • Communicated directly with clients, finished ad-hoc requests. • On call support. EDUCATION AND CERTIFICATE Master of Science Degree (Computer Science, Loyola University of Chicago, January 1994 - May 1996)
Websites, IT & Software
C# Programming
Database Development
ETL
Microsoft SQL Server
SSIS (SQL Server Integration Services)
60 $
Charles Johnson
BASIC
United States, Atlanta
SR. SYSTEM ANALYST/QUALITY ASSURANCE ANALYST Charles Johnson, Websites, IT & Software
Dear Hiring Manager, As a well-experienced software delivery professional, I read your posting with keen interest and I felt motivated to submit my resume for your review. My flare for advancing technical performances, improving systems’ competency via the implementation of modern technical strategies, offering supports to users, and driving team advancement through trainings, gives me great mettle and confidence in my ability to bring quantifiable improvement to the technical arm of your organization. Revamping systematic productivity and competitive performance by skillfully aligning resources with objectives is one of the many ways I served an instrumental role in the success of all past employers. Equipped with firsthand experience in advancing and maintaining systems competency and capacity. I am also well-versed in multiple functions Including Requirement Gathering, Risk Assessment/Management, System Maintenance, Workflow Reengineering, Cost Management, Strategic Planning & Execution, Software QA, Technical Support, Project Management/Development, Requirement Testing, Staff Training & Development, implementation and support practices while enforcing compliance with best practices. My expertise in facilitating overall workflow, with a reputation for providing exceptional consultative support, are key strengths. As a result-oriented individual with a rigorous work ethic, my core strengths in technical needs analysis, operational direction, and systems maintenance are sure to render me an immediate asset to your organization. Thank you for your time and consideration. I would be happy to discuss my qualifications in an interview setting further. Sincerely, Charles M. Johnson.
Websites, IT & Software
Agile Project Management
Microsoft Project
Microsoft SQL Server
QA & testing
Software Testing
40 $
V VS
BASIC
VVS - CV for "Production Support MSSQL DBA". V Vs, Websites, IT & Software
Technical Lead - Employee #- 51313308 HCL Technologies Dec 2009 – Jun 2019 (9 yrs 7 mos) Worked as Offshore Production Support MSSQL DBA for US based Healthcare Insurance company. Project Details :- =========== 1. HCSC DB INFRA SUPPORT. (Feb-17 to May-19). Duties And Responsibilities :- • Installation, Administration and Maintenance of SQL Server Instances. • Setup Test, Dev, Staging and Production Environments. • Create Users and assign permissions based on the level of database access the user would need. • Design database Backup and Restoration Strategy. • Once created the database Backups, monitor those backups are being performed regularly. • From time to time recover the databases to a specific point of time, as per the requests. • Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication) • Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured)) • Monitoring and Performance tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining Indexes, performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc) • Documenting major changes to the SQL Servers. • Apply Service Packs & patches. • Database security administration. 2. NXP/FREESCALE DB INFRA SUPPORT. (May-14 to Jan-17). 3. BOI - TEST COE SQL CONSOLIDATION SUPPORT. (Jan-12 to Mar-14). 4. CBA - MF COE APPLICATION SUPPORT. (Jun-10 to Nov-11). 5. DB - LASER APPLICATION SUPPORT. (Jan-10 to May-10).
Websites, IT & Software
Azure
BMC Remedy
Microsoft Access
Microsoft SQL Server
Office 365
100 $
use cookies. By continuing to use this website you consent to our cookies policy. Privacy Policy
    WONO