Top 20 companies that use SQL

2. Guidehouse

3. Deloitte

How Deloitte uses SQL:

• Incorporated LINQ to Entity Framework 4.1 and LINQ to SQL for business and data objects.
• Directed development efforts for Business Intelligence including SQL Reporting Services and other dashboard reporting technologies for executive and end user reporting.
• Designed sophisticated SQL queries that reduced processing time by 1000x.

Most common skills for Deloitte:

• Project Management
• Java
• Business Development
• Process Improvement
• Business Process
• Financial Statements

4. Intel

How Intel uses SQL:

• Created views, stored procedures and functions in SQL Server database.
• Identified trends and derived key insights from vast quantities of data through creation and execution of SQL queries.
• Involved in Tuning Stored Procedures in MS SQL Server 2005.

Most common skills for Intel:

• Linux
• Perl
• Debugging
• Windows
• RTL
• Python

5. U.S. Department of the Treasury

How U.S. Department of the Treasury uses SQL:

• Assisted with updating the Microsoft SQL server from the version 2008 to 2012.
• Configured mirroring on all SQL instances including SQL 2012.

Most common skills for U.S. Department of the Treasury:

• Treasury
• IRS
• SharePoint
• PowerPoint
• Subpoenas
• Tax Issues

6. Capital One

How Capital One uses SQL:

• Created SQL queries to test the backend functionality of the application.
• General knowledge of Oracle and SQL databases from backup perspective.
• Developed data analytics and custom SQL solutions to solve business problems and drive efficiency.

Most common skills for Capital One:

• Customer Service
• Process Improvement
• Credit Card
• Customer Inquiries
• Java
• Inbound Calls

7. Amazon

How Amazon uses SQL:

• Developed custom SQL queries to analyze databases for trends in fraudulent activity.
• Utilized advanced skills with Excel in SQL to collect data for global metric and goal reporting
• Create daily metrics / benchmarks using Excel and SQL to monitor network performance.

Most common skills for Amazon:

• Customer Orders
• Pallets
• Inventory Control
• Pallet Jack
• RF Scanner
• Problem Solve

8. Prime Therapeutics

Most common skills for Prime Therapeutics:

• SAS
• Hippa
• End-To-End Testing
• Medicare
• HIPAA
• Outbound Calls

9. Lumina Foundation

10. GEICO

How GEICO uses SQL:

• Performed data transformation using SAS and SQL to map selected major cities to loss experience data for fraud analysis.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment and SQL Server 2008 security Audit.
• Used SQL profiler to identify performance bottlenecks and improved performance by tuning sql queries.

Most common skills for GEICO:

• Customer Service
• Inbound Calls
• Arbitration
• Customer Inquiries
• Policy Coverage
• Insurance Coverage

11. Ford Motor

How Ford Motor uses SQL:

• Designed and created objects using UML Wrote embedded SQL to run queries.
• Extract, transform and process data from Factory Information System-FIS utilizing SQL queries.
• Use SQL to pull out machine running data and cycle time data from factory information system database.

Most common skills for Ford Motor:

• Assembly Line
• Sigma
• Lean Manufacturing
• Customer Service
• Process Improvement
• ISO

12. Highmark

How Highmark uses SQL:

• Created custom SQL's in db2 and oracle for the reports.

Most common skills for Highmark:

• Strong Analytical
• Customer Service
• Medicare
• PL/SQL
• Process Improvement
• Test Cases

13. Meta

Most common skills for Meta:

• Facebook
• Visualization
• POS
• API
• Twitter
• Java

14. CVS Health

How CVS Health uses SQL:

• Utilize SAS and SQL data programming skills to tackle complex marketing campaigns and mentored fellow team members on these techniques.
• Utilize the following applications to process data for analytics: SQL Server, Microsoft Access, Microsoft Excel.
• Translated proprietary SQL code to assist with data warehouse migration project.

Most common skills for CVS Health:

• Customer Service
• Patients
• CVS
• Inventory Management
• HIPAA
• Computer System

15. Robert Half

How Robert Half uses SQL:

• Designed and developed MS SQL reports and analyses for business operations.
• Resolve Application, OS and SQL DB errors causing system outages affecting the user community.
• Support Microsoft SQL 2000 server clusters and databases, planning for future increases in capacity.

Most common skills for Robert Half:

• Customer Service
• Expense Reports
• Payroll
• Journal Entries
• Data Entry
• QuickBooks

16. U.S. Bank

How U.S. Bank uses SQL:

• Served as key member for design and testing for conversion of SQL server database to web based design.
• Identify major trends and using provided tools or SQL to scope and track defects.

Most common skills for U.S. Bank:

• Customer Service
• ATM
• Credit Card
• Loan Applications
• Bank Products
• Customer Accounts

17. Humana

How Humana uses SQL:

• Used SQL queries to by pass windows based reporting system to increase query speed.
• Migrated Excel pivot table based reporting to SQL based reporting.
• Design and create queries through SQL, ISeries and Access to obtain the data.

Most common skills for Humana:

• CMS
• Medicare
• Customer Service
• Outbound Calls
• Medicaid
• HIPAA

18. Fidelity Investments

How Fidelity Investments uses SQL:

• Partnered with technical and business teams to successfully analyze and resolve data issues using SQL for completion of data certification project.
• Developed ETL processes using AbInitio and SQL to obtain required performance results for large data transformations.
• Improved web site functionality making it easier to manage by using ASP running on IIS, querying a SQL Server database.

Most common skills for Fidelity Investments:

• Customer Service
• QA
• Process Improvement
• Project Management
• Inbound Calls
• Problem Resolution

19. JPMorgan Chase & Co.

How JPMorgan Chase & Co. uses SQL:

• Used SQL to pull relevant data from Oracle databases.
• Execute testing in SIT, UAT and Prod database environments using SQL queries and perform regression testing.
• Utilized Oracle SQL, PL/SQL stored procedure, packages utilization.

Most common skills for JPMorgan Chase & Co.:

• Customer Service
• QA
• Process Improvement
• Customer Inquiries
• Customer Accounts
• SharePoint

20. Navient

How Navient uses SQL:

• Conducted data analysis using SQL, Excel, and other software applications.
• Assisted in the creation of the SQL databases currently being utilized to run multiple SSRS reports for the Back Office.

Most common skills for Navient:

• Student Loans
• Customer Service
• Outbound Calls
• Inbound Calls
• Credit Reports
• Customer Accounts