SQL Data Analyst Resume Sample
Clint Kulas
62560 Hoeger Light,
Los Angeles,
CA
+1 (555) 153 7451
Work Experience
Senior SQL Data Analyst
02/2017
-
PRESENT
San Francisco, CA
- Monitoring. Assist with the monitoring, and response to system messages and alerts. Carry out workflow processes across the systems to achieve resolution to issues generating the alerts and alarms
- Reporting. Execute and distribute basic data reports to report on daily metrics, and satisfy user requests
- Jobs. Monitor system jobs and batch processes, and report on issues that are identified
- Interfaces. Provide support for testing and monitoring interfaces to and from systems, including testing support for user, web service, and batch interfaces
- Environment. Assist with the operational support for internal applications and database environments (including Production, QA, and Test)
- Troubleshooting. Provide support for troubleshooting issues in the systems, including their applications, databases, and associated interfaces
- Security. Assist with the administration of user permissions within the systems by processing employee assignments to security groups
- Perform analytical analysis and assessments of data integration sources into the Master Data Warehouse
- Perform and communicate data consistency and accuracy assessments across key IT infrastructure SORs
SQL Data Analyst
05/2014
-
08/2016
San Francisco, CA
- Drive future data standardization and quality measurements based on analysis outcomes
- Experience in Data Analysis or Data Integration
- Strong SQL skills against industry standard DBMS (Netezza, IBM, DB2, Oracle, SQL Server)
- Problem Management and root cause for data quality issues and development of metrics to support
- Strong interpersonal and business skills to achieve cooperation/coordination of multiple tasks being performed
- The ability to communicate effectively to multiple levels in technology organization
- Conduct quality assurance of integrated data supporting initiatives for data integrity and normalization
- Work with Senior management both on the Technology as well as Business
SQL Data Analyst Healthcare Quality Measures
10/2010
-
02/2014
Chicago, IL
- Experience working and articulating analysis results
- Knowledge of IT Service Management, ITIL principles (Specifically, IT Asset and Configuration Management)
- ITIL V3 2011
- Assess and suggest changes to the Master Model over time
- Provide input to reporting and integration requirements
- Strong quantitative and analytical skills with advanced knowledge of Excel, Access, and SQL is required
- Proven ability to address and solve problems in a creative, innovative, timely, and decisive manner
Education
Washington State University Vancouver
2004 - 2009
Bachelor's Degree in Management Information Systems
Professional Skills
- Build and maintain tables to store data gathered from multiple sources. Data sources include lookup tables and data downloaded from Know Your Customer ‘KYC’ systems
- Optimize SQL performance, integrity and security of the project’s databases/schemas. Contribute to the optimization of data management and performance tuning
- Strong data modeling skills and data integration experience required
- Experience with Excel including strong skills in Pivot tables and other data features
- Demonstrated experience/skills in appropriate computer, statistical or database applications including SAS/SQL, Business Objects, Cognos or similar
- Strong attention to detail and time management/organization skills to manage multiple priorities
- Demonstrated experience/skills with Data Warehouse concepts and Cognos
How to write SQL Data Analyst Resume
SQL Data Analyst role is responsible for sql, analytical, modeling, analysis, database, integration, automation, cognos, excel, advanced.
To write great resume for sql data analyst job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For SQL Data Analyst Resume
The section contact information is important in your sql data analyst resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your SQL Data Analyst Resume
The section work experience is an essential part of your sql data analyst resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous sql data analyst responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular sql data analyst position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative SQL Data Analyst resume experience can include:
- Proactive and willing to continuously improve upon and learn new skills
- Experience with big data platform(Hadoop) and tool sets SQL,PL/SQL development experience to aid the data analysis
- Write Business requirements documentation to effectively communicate the requirements to the technical teams and project stakeholders
- Effectively partner with Production-Operations, ATOMX, and IT team to support data migration needs
- Proven work experience as a Data Engineer, Data Analytics or similar role
- Strong hands on experience with Oracle 11g or Higher, Exadata
Education on a SQL Data Analyst Resume
Make sure to make education a priority on your sql data analyst resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your sql data analyst experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in SQL Data Analyst Resume
When listing skills on your sql data analyst resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical sql data analyst skills:
- Advanced SQL (Structured Query Language) skills including strong SQL Query data writing
- Excellent interpersonal, presentation and collaborative skills to build and maintain professional relationships
- Strong analytical skills, especially with financial data
- Strong Data Analysis skills in either SAS or SQL
- Strong PowerPoint and Excel skills is required (Vlookups, Macros, and other automation techniques)
- Work effectively in ticketing software system (JIRA) to monitor, document, track and follow up and through on testing, releases and updates
List of Typical Experience For a SQL Data Analyst Resume
1
Experience For SQL Data Analyst & Support Resume
- General PeopleSoft development skills
- Experience with financial and accounting data
- Proven ability to proactively take initiative to drive closure on key tasks and open items
- Experience in Microsoft SQL Server 2008 (SQL, T-SQL, SSIS, SSMS, Stored Procedures and related technologies) is required
- Experience with API’s in a REST environment preferable
- Experience with data Analysis & various databases
- Experience in creating data quality metrics and trending reports
- Experience of business data analysis in a corporate environment utilizing SQL
- Demonstrated focus on quality that includes attention to detail, accuracy, and accountability for work product
2
Experience For SQL Data Analyst Healthcare Quality Measures Resume
- Experience with Microsoft SharePoint or other project management tools
- Prioritize user requests
- T-SQL Experience (stored procedures, views and/or functions)
- SQL Server Experience (development, administration, and/or architecture)
- Experience with databases as well data analysis, interpretation and manipulation of data required
- Direct experience as a database developer / Technical Analyst in a corporate environment
- Identifying and interpreting trends and patterns in datasets to locate influences
- Produce standard and adhoc analyses and reports using a variety of data which support the development, implementation and monitoring of programs/projects
- Perform data analysis for data quality issues potential data gaps and propose remediation plans
3
Experience For SAS / SQL Data Analyst Resume
- Connect the dots across various applications and business processes, document data flows and identify gaps
- Write and analyze complex queries, stored procedures
- Produce routine and ad hoc analysis
- Develop regular and ad hoc reports
- Fulfill the role of Subject Matter Expert (SME) and Data Expert for Lakeview Sub-servicer and Seller data
4
Experience For Senior SQL Data Analyst Resume
- Monitor Daily Feeds from sub-servicers for data issues
- Accountable for the integrity and accuracy of Lakeview data
- Assist with data analysis for new IT projects and additional sub-servicer or seller data requests
- Identify data gaps for sub-servicer, seller, or business user provided data
- Direct engagement with sub-servicers or transaction management team to resolve data gaps
- Performs ad-hoc data requests from other data consumers
- Provide after-hours support evenings / weekends / holidays as necessary
- Work reasonable overtime hours as required
5
Experience For SQL Data Analyst / Operations Engineer Resume
- Assist in the data analysis and documentation processes required to support the development, testing, and implementation of AML dashboard and reports used across the lines of business
- Analyze and design KRI, metrics and reports analyses for Operations as well as partner teams like Sales and Global Financial Crime Compliance team
- Assist in the transformation of manual report production to an automated process
- Understand information from various sources logically and holistically, as well as summarize and present complex data in an organized, concise manner
- Design queries to perform data analytics, and data extractions across AML and accounts system
6
Experience For SQL Data Analyst Risk Adjustment Resume
- Perform quantitative and qualitative analysis of data used to prepare and report various metrics of the bank to internal and external parties using PowerPoint, Excel, and Tableau(example)
- Conduct advanced data mining in a timely and accurate manner as required by the program/project
- Integrate/manipulate large datasets from data sources (e.g. claims and encounter data) to support analyses using MS Excel, Access, SAS, SQL, COGNOS, and Business Objects
- Design and develop specific databases for collection, tracking, and reporting of data
- Deploy standard qualitative and quantitative analysis techniques utilizing software packages such as SAS, SQL or Atlas.ti
- Utilize and create standard testing measures and/or algorithms to test and analyze large amounts of data
- Participate in the design and implementation of data management strategies/techniques and quality control procedures, including writing technical requirements and documentation of data sets
- Ensure accuracy of all data analyses, reports and other deliverables by conducting thorough quality control checks and resolving discrepancies
- Provides direction regarding sales patterns, trends, and projections to drive business decisions
7
Experience For SQL Data Analyst & Reporting Developer Resume
- Presents sales reporting and insights to leadership
- Schedule, coordinate, and review activities related to data collection and analysis in order to meet deadlines
- Develop quality code that meets project and departmental standards
- Present results of analysis, data models, and other projects to senior management, when requested, in a concise and professional manner
- Organize, as well as manage large data sets
- Code derived fields via Structured Query Language (SQL)
8
Experience For Aml-risk Tolerance SQL Data Analyst Resume
- Analyze, as well as collaborate, with various teams on implementation methods, updates and changes to data tables, data objects, logic and data structures so as to fully understand cause/effect/impacts to changes or updates. Effectively communicate impacts to management
- Experience with SQL
- Recognize and interpret meaningful trends and make recommendations for improvements
- Uses transactional data for identification and evaluation of sales performance with consideration towards sales quotas
- Work with business operations, channel strategy, and sales leadership to incorporate sales forecasts into daily/weekly/monthly reports
9
Experience For SQL Data Analyst / Developer Resume
- Generate ad hoc reporting and analysis for residential Marketing & Sales channels that include Call Center COEs, Online, Cox Owned & 3rd Party Retail, and Door to door sales
- Help in design of Data Models and Data Marts
- Work with the client Credit Business teams to Translate business requirements into technical specifications, test and implement solution
- Work with Business Analysts to ensure all business and user requirements are met through design, build and implementation phases
- Provide Business (Respond to user questions/issues) and Technical Support
- Identification of technical alternatives and recommendations
- Interface with the client Credit DA/DBA teams and other IT service teams
10
Experience For SQL-data Analyst Resume
- Interfacing between the business and divisional data teams to generate tools to be leveraged in building analysis and reports which are actionable within the business environment
- Continuously gaining a deeper understanding of the division’s data in order to meet business needs
- Analyze data for cross media fulfillment projects
- Provide Tier-2 support for/research internal data issues and questions
- Provide one-off data fixes and other special requests
List of Typical Skills For a SQL Data Analyst Resume
1
Skills For SQL Data Analyst & Support Resume
- Strong analytical and problem-solving skills with the ability to work independently with minimal supervision
- Strong hands on experience with Microsoft SQL Server Management Studio 2012
- Experience with cross system conversions with thorough demonstrated understanding of data conversion processes and typical issues
- Demonstrated experience with test cycles (UAT and Model Office)
- Strong knowledge of T-SQL language as evidenced by ability to write complex SQL queries
- Coding issues identification & resolution experience required
- High level SQL experience developing tables, organizing data, running queries in an enterprise level setting
- Experience working with PDF tools for merging data and generating reports
- Experience with Excel including advanced formatting, use of formulas, and querying databases directly from a spreadsheet
2
Skills For SQL Data Analyst Healthcare Quality Measures Resume
- Experienced in creating/using SQL code to create new and modify existing reports
- Experience with other data scripting tools including Python
- Strong working knowledge of SQL, including SSIS and Oracle
- Experience extracting data and moving data from SQL Server and Oracle Databases
- Experience with SQL Server as Power User for coding, troubleshooting and modifications
- Research/locate/validate data fields, including derived fields using various systems, data tables, stored procedures and data dictionaries
3
Skills For SAS / SQL Data Analyst Resume
- Experience with modifying schemas as required to support collection efforts
- Experience with FME Scripting tool (This might be hard to find)
- Experience required in related field of Sales Analysis, Sales Operations, Marketing and Database Systems
- Experience of data visualisation using QlikView or Tableau
- Experience with standard business modeling techniques, such as cross-functional process flows, use cases, wireframes, and UML
- Hands-on experience working within Oracle/Sybase database environment
- Related experience; including at least one year of healthcare data analysis
- Experience of business data analysis in a corporate environment utilizing SQL
4
Skills For Senior SQL Data Analyst Resume
- Experience working with Elastic Path, AEM, IBM Websphere or Infosphere
- Validate and sign off on fulfillment processing and integration projects
- Experience using SAS to schedule server jobs
- Experience with analytic and reporting
- Strong working knowledge base in quantitative and analytical techniques
- Assist with data validation testing for new projects
5
Skills For SQL Data Analyst / Operations Engineer Resume
- Strong knowledge of MS Excel, preferably VBA
- Experience of Netezza or Hadoop desired but not essential
- Develops, validates and executes algorithms and predictive models to solve business problems
- Health Insurance domain experience (Claims, Medicare, Medicaid, Commercial)
- Demonstrated understanding of SQL coding best practices and performance tuning, stored procedures, transaction handling, etc
- Good knowledge of data modeling concepts, OLTP and OLAP data models, data modeling tools, etc
- Experience implementing 100% availability database architecture
6
Skills For SQL Data Analyst Risk Adjustment Resume
- Experience developing SSIS packages/ETL
- Five years of experience in an applicable risk management environment
- Experience in information technology with an emphasis on technology business and data analysis
- Working knowledge of claims based health care data, including medical terminology and standard coding systems (ICD9/ICD10, CPT, MS-DRG, HCPCS)
- Producing datasets and reports for analysis using system reporting tools
- Working knowledge of computers and various tools including MS-Office and text-editors
- Working knowledge of Microsoft SQL Management Studio, SQL Reporting Services
- Working knowledge of SQL Analysis Services tools
- Creating specifications for reports and analysis based on business needs
7
Skills For SQL Data Analyst & Reporting Developer Resume
- Possibly performing research and assisting in analyzing data related to the division’s strategic initiatives and broader research needs
- Produce forecasting models to support senior management in decision making
- Proactively work with various teams within ATOMX, including Data, Report Writing and Analytics and Communications on current initiatives and company objectives
- Generate and configure reports using BI tools and Excel
- SQL reporting
- Enjoys working independently as well as within a team environment
- Comfortable in a fast-pased, ever-changing environment
- Performs analyses of varied healthcare data to evaluate programs and product solutions using healthcare medical, pharmacy, lab, survey and utilization data
- Designs and codes efficiently using SAS/SQL programs
8
Skills For Aml-risk Tolerance SQL Data Analyst Resume
- Investigates and evaluates alternative solutions to meeting business needs
- Documents methods, specifications and findings clearly; contributes to writing and presentation of results, findings and conclusions
- Knowledge of various file formats including .CSV
- Exposure to content management systems and understanding of catalogs
- Interface with Technical lead to learn and understand the existing application and architecture
- Configure software configuration data and developing SQL queries
- Responsible for operational processing if necessary when required for one-off situations
- Data mapping specification designs, Data feed specifications , Data analysis and data comparison
- Gather and manage large segments of data, translating the technical information to a structured visual representation
9
Skills For SQL Data Analyst / Developer Resume
- Develop and maintain tracking documentation for key initiatives
- Documentation for Process Management and Business Requirements Gathering
- Assist in resolving queries from end-users of data about the data
- Identify opportunities for data quality checks and exception reporting
- Design and implement reports for internal and external use, including adhoc and published reports. Meet with users to establish correct report criteria
10
Skills For SQL-data Analyst Resume
- Collaborate with business owners on data analysis and modeling projects; and
- In-depth understanding of data base structures and principals
- Able to decipher and interpret complex SAL logic, including how it was constructed and trace/source back to system of record/data source
- Critical and analytical thinking – data oriented mindset
- Develop reports for internal and external use, including ad hoc and published reports. Meet with users to establish correct report criteria
- Collect, analyze, evaluate, and report sales and marketing data to increase productivity
List of Typical Responsibilities For a SQL Data Analyst Resume
1
Responsibilities For SQL Data Analyst & Support Resume
- Relevant hands-on SQL Development experience in transactional systems - writing SQL Queries, debugging, performance tuning, database tuning/normalization, etc., or equivalent combination of education and work experience
- Experience in Data/Business Analysis, including interfacing with lines of business, gathering and analyzing requirements and writing functional specifications
- (required) 2+ years of T-SQL experience
- Knowledgeable of SAS and/or Advanced SQL and be able to do comparisons of data using SQL and be able to enforce data completeness and perfect data accuracy using SQL
- Strong knowledge of T-SQL language as evidenced by ability to write complex SQL queries, Microsoft SQL Management Studio, SQL Reporting Services, SQL Analysis Services and SQL Server Integration Services
2
Responsibilities For SQL Data Analyst Healthcare Quality Measures Resume
- Working knowledge and experience with Excel
- Demonstrated ability to research issues and resources
- PeopleCode, Application Designer, Application Engine, SQR
- Expertise in Health Insurance services utilization, reimbursement concepts, industry standard terminology and metrics relevant to Coordination of Benefits for Medicaid, Medicare and Commercial Payers
- Knowledge of HIPAA transactions, EDI transactions, and XML
3
Responsibilities For SAS / SQL Data Analyst Resume
- Highly proficient in Microsoft Office suite (Word/Excel/Access/PowerPoint)
- PeopleCode, Application Designer, Application Engine, SQR, SQL Analysis Services tools
- Experience with Data Visualization tools such as PowerBI, SQL Server Reporting Services, Tableau, Cognos. (Required – at least one, in order of decreasing preference)
- Experience with the direct support & cooperation with the applications end users and business teams
- Support use of standard processes and initiate standard processes when one is not available
- Committed to quality excellence and fanatical Support/Service levels
- Work with web producers as needed
4
Responsibilities For Senior SQL Data Analyst Resume
- Configure data within the catalogs
- Familiarity with HIPAA transaction sets required
- Healthcare background, along with knowledge of all types of managed care, required
- Extracts data from multiple sources and creates integrated analytic datasets and creates reports and studies to address business and research questions
- Executes univariate and multivariate statistical analyses and interprets results in the context of the business problem or question
5
Responsibilities For SQL Data Analyst / Operations Engineer Resume
- Conducts periodic updates of analytical routines and department production systems
- Participates in presentations and consultations to constituents on information services, capabilities and performance results
- Creates and evaluates the data needs of assigned projects and assures the integrity of the data
- Manages personal resources efficiently to complete assigned projects accurately and on time
- Data is pulled from SQL Server and Oracle Databases within a Data Warehouse
6
Responsibilities For SQL Data Analyst Risk Adjustment Resume
- Exposure to Data Warehouse and ETL. (They do not use ETL Tools like Informatica or Ab Initio in this role though – they need to be strong SQL Data Analyst – don’t send Informatica or DW Developers)
- Self starter, driven and exhibits thought leadership
- Knowledge of database tools such a PGAdmin
- Automate scripts and check for correct output
- Advanced knowledge of Office Suite (Microsoft Word, Excel, & PowerPoint) with expert knowledge of Excel
- SQL: 5 years
Related to SQL Data Analyst Resume Samples
SQL Analyst Resume Sample
Work Experience
• Creates and manages tools that support key business processes
• Performs data analysis to uncover process/reporting inefficiencies, make recommendations to address findings and spearheads resolution efforts
• Identifies, automates and implements business process efficiencies
...
Professional Skills
• Excellent communication, facilitation, int...
• Strong communications skills and professio...
• Strong interpersonal skills, ability to bu...
SQL DBA Resume Sample
Work Experience
• Participate in an on-call support rotation and provide non-standard work hour support
• Provides database support to business users. Restores functionality to database processes that have failed, documents resolutions, and creates and maintains troubleshooting documentation
• ...
Professional Skills
• Strong SQL writing skills - 3+ years of ex...
• Strong production support experience and c...
• Demonstrate excellent analytical skills an...
SQL Server DBA Resume Sample
Work Experience
• Self-starter and able to perform work with minimal supervisory direction
• Self-starter who’s highly motivated and energetic
• Evaluate solution’s alignment with the end user experience
• Enterprise SQL experience
• Demonstrates i...
Professional Skills
• Experience working with high profile custo...
• Excellent troubleshooting skills related t...
• Demonstrated skills in designing and build...
Senior Cyber Resume Sample
Work Experience
• Demonstration of deep technical understanding of Cyber/Network Security & Privacy, an Commercial and Technology Errors & Omissions, and Media. Utilizing risk expertise and knowledge of industry and insurance market place, reviews clients’ exposures and loss experience and develops solutions for complex clients’ n...
Professional Skills
• Passion for all things information technol...
• Project and case management skills
• Experience of using common security tools ...
Consultant CRM Resume Sample
Work Experience
• Identify the appropriate stakeholders for your area of work, considering the impact of your work and the broader cross-functional dependencies. Manage these relationships to meet stakeholders’ business needs and align expectations. Always strive to improve business partner satisfaction
• Implemente...
Professional Skills
• Strong Influencing skills and communicatio...
• Global team player, effective and reliable...
• Experience managing global CRM teams and w...
Lead SAP Resume Sample
Work Experience
• Application life cycle management for all Tate & Lyle’s application landscape including roadmaps and Software Asset Management where needed
• Comprehensive understanding of SAP’s customizing toolset
• Work independently as well as a part of a global team
•&nbs...
Professional Skills
• Experience in strong background in formal ...
• Business Analyst experience in functional ...
• Min of 6 to 8 years of experience required...