- Featured in:
-
High Quality
The best examples from thousands of real-world resumes
Expert Approved
Handpicked by resume experts based on rigorous standards
Diverse Examples
Tailored for various backgrounds and experience levels
Database Analyst Resume Samples
No results found
Candidate Info
years in workforce
years at this job
Mathematics
Electronics
Database Analyst III
Designed, developed and maintained databases for the following applications: Labor, Payroll, Cashflow, Mechanical Drawings, Computer Based Training, Ideas (employee suggestions), Manufacturing History Log, AsBuilt, LabelMaster, Test Status, Final Inspection, Shipping, Warranty, Billing. Also was the Web Master for the company intranet website.
- Streamlined production and inspection process by designing new two-dimensional bar code that scanned and provided accurate documentation of all shipments to customers.
- Wrote program to create a "Virtual Vault" of mechanical drawings that expedited environmental testing (ESS) and batch pass on military sensor equipment and reduced inspection time by 80%.
- Automated contract billing that provided direct interface with government websites including FTP file transfer and supporting DD250 new manufacturing contracts and DD1149 materials management.
- Developed and integrated employee and supervisor labor system that accurately captured employee time sheets, record of activates and approval.
- Designed new computer learning database that provided eLearning opportunities, standards, testing and tracking of employee competency levels and certifications.
- Prepared for government audits and ensured compliance by automating GFE government furnished equipment audit forms and procedures.
Candidate Info
years in workforce
years at this job
Mechanical Engineering
Strategy & Finance
Database Analyst
- Implemented inventory control systems, established optimum inventory levels, saving $460K
- Tracked obsolete inventory and identified new sales channel for its disposal, saving $230K
- Led database consolidation initiative to implement efficient data distribution and analysis
- Managed integration efforts of new business line by optimizing reporting systems and operational parameters
Candidate Info
years in workforce
years at this job
Mathematical Sciences
Operations Research
Senior Marketing Database Analyst
Designed regression models to improve overall dollars spend in catalog selection.
- Using SAS Enterprise Guide, built multiple regression models for selection of customers for 5 separate brands, based on the response of previously mailed books
- Created and implemented a monthly process to apply the models to 5+ million customers to assist in the selection
- Created and maintained reports using SQL and Excel to monitor customer performance for any of the 5 brands and the company overall based on the new customer cell structure
- Designed and implemented the process within a 3 month time frame
- Presented results to senior management
Candidate Info
years in workforce
years at this job
Business Systems Consultant / Database Analyst
Create databases and analyze Business Banking data to increase cross-sell opportunities for business bankers. Develop ad-hoc report requests. Manage projects related to conversions. Create requirements for projects completing FSDs, BRDs, data dictionaries, schema diagrams and mapping documents for new and existing systems.
- Led department-wide initiative to redefine processes related to customer communication for internal customers aligning responsibilities for subject matter experts for each system or process.
- Substantially decreased month end processing times by applying Business Process Management methodologies; creating process flows and documenting issues and resolutions.
- Streamlined processes and procedures to increase system development efficiencies.
- Devised SharePoint surveys for department to complete to discern low scoring Q12 results.
- Promoted to Process Innovation Chair of the Process Innovation Committee.
Candidate Info
years in workforce
years at this job
Document Database Analyst
Produced and maintained a filing system for users of the Chemical Material Agency's Lean Six Sigma (LSS) tracking application.
- Created new user accounts for the LSS and sent out approval emails acknowledging the user's access was granted.
- Uploaded document files to the LSS database.
- Worked with project lead to ensure that the appropriate programmatic documents were maintained on the site.
- Edited files already existing in the database when changes became necessary.
- Used Microsoft Excel to create detailed outlines of the application's page functions and actions. Used these outlines to test the applications pages and documented the test results.
- Generated reports that were used by the developers to manage code changes from the basic application requirements.
Candidate Info
years in workforce
years at this job
Collge Prep Track
Information Technology
Database Analyst
Organized inventory and pricing on database Excel and Access. Maintained network and updated software. Ordered and organized inventory. Directed store employees. Dismantled owner's laptops and repaired Diagnosed hardware issues, made appropriate repairs.
- Established compatibility with third party software products by developing program for modification and integration.
- Provided maintenance and development of bug fixes and patch sets for existing web applications.
- Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
- Developed data architecture design to enable analysts to perform targeted customer analysis.
- Managed firewall, network monitoring and server monitoring both on- and off-site.
Candidate Info
years in workforce
years at this job
Finance
Accounting
Database Analyst/developer
- Managed database infrastructure spanning over multiple server and databases totaling nearly 1 Terabyte in size.
- Developed complex maintenance plans and performance monitoring solutions that increased performance and reduced downtime by over 30 %.
- Developed business intelligence solutions for all business areas including: operations, accounting, marketing, fuel, and executive management.
- Developed a General Ledger report that tracks store and district manager performance based on key performance indicators.
- Administered user accounts and security for the company ERP system and for all company databases.
Candidate Info
years in workforce
years at this job
Software Engineering
Database Analyst
Developed several databases for a direct marketing company. Identified business requirements, developed information models, performed data analysis.
- Designed advanced SQL queries, stored procedures, triggers, scripts, cursors.
- Created, maintained, modified, and optimized SQL Server databases.
- Collaborated with other programmers on data modeling.
- Optimized query and table design with knowledge of database performance and capacity.
Candidate Info
years in workforce
months at this job
Health Care Management
It Management / Business Analytics
Database Analyst
- Improved the accuracy of the Medhub database by implementing efficient verification processes using Excel
- Completed various reports to identify areas for improvement and proactively minimized violation risks
- Reconciled three-way match between faculty scheduling database, resident database and Medhub which resulted in the accurate and timely delivery of resident evaluations to provide feedback to physicians in-training
- Assisted faculty, resident physicians and staff with data queries to gain statistical insight which instilled physician confidence and provided support for the Medhub database system and led to accurate and timely payments
Candidate Info
years in workforce
year at this job
Computer Programming
Actuarial Science
Database Analyst and Report Administrator
Management of Siterra SaaS Database and MicroStrategy Business Intelligence Reporting Application
- Performance of Monthly OREO and MIP General Ledger Reconciliation to Ensure Collateral and Current Balance Agreement
- Collaborated with OREO and Loans Special Asset Groups, Facilities Management and Procurement Department to provide Siterra Support and Request
- Reviewed and Tested Data Validation and Reported to Management on Quality Improvement
- Implemented Process Improvement Guidelines, Procedures, and Workflows
- Assessed, Evaluated and Reviewed Operations and Provided Guidance and Training to Ensure Compliance with all Applicable Regulations
Candidate Info
years in workforce
years at this job
Network Administration
Database Analyst
Write SQL queries and scripts to update and create tables, extract data for uploading, reporting, analysis and data consistency checks. Exported data to Excel and Access for reporting, summarizing, created bar graphs and charts in Excel.
- Perform cross-functional activities including maintenance and/or research, analysis and provide feedback for particular software modifications for [company name], including user and program documentation, testing and implementation.
- Analyzing complex data systems and documenting data elements, data flow. Developing automated and reusable routines for extracting requested information from database systems.
- Maintained the customer database, ensured it was backed up, and upgraded as scheduled or as needed.
- Ability to meet deadlines and handle pressure coordinating multiple tasks.
- Demonstrated strong interpersonal skills with the ability to work effectively with upper management and excellent leadership skills in motivating others.
- Created several data reporting processes from start to finish, which included the data mining, analysis and reporting pieces
Candidate Info
years in workforce
years at this job
Business
Database Analyst
Created and developed customized applications, relational databases, reporting and graphing as requested from staff.
- Created a web-based Epilepsy Course 12-week program for the post-graduate fellowships which included maintaining forms, uploading staff lectures, photo archive and up-to-date schedules.
- Created a web-based program to track the staff interviews conducted for incoming fellows chosen for the fellowships, assuring data integrity and maintaining the interview scores through analysis for final selection.
- Created 3-D Brain reconstructions using MRI and CT Scans, SGI, VuTu, Litebox, MagicView and Curry software.
- Developed and maintained web pages and applications, as well as cron jobs to automate manual tasks.
- Developed an integrated scheduling web-based application that collected data from many sources (databases and servers) that maintained an accurate and up-to-date staff schedule. Monitored the schedule for data integrity and made changes as needed to upgrade for process efficiency.
Candidate Info
year in workforce
year at this job
Management Information Systems
Database Analyst/systems Integration Management Specialist
Maintained Oracle 8 and IMS Database Management System.
- Customized Oracle database systems according to client specifications.
- Implemented and modified physical database design.
- Modified PL/SQL packages and functions to enhance and update data retrieval processes for reporting.
- Provided level 3 support of database residing on the system.
- Created queries using PL/SQL for ad/hoc reporting
Candidate Info
years in workforce
years at this job
Database Analyst
Created database objects like tables, indexes, views, cursors, triggers, and stored procedures tables based on the client requirements, loaded data and pursued data cleansing and auditing to secure data quality.
- Designed data flow and extracted data from a SQL Server database, transformed the data and then loaded into different database or flat file.
- Created data mining structure to predict business need in the future.
- Generated variety of business reports using different tools.
- Extracted and analyzed data from various sources with strong Excel skill, making report with Powerful Pivot Table, Pivot Chart, macro and other advance formulas and functions.
Candidate Info
years in workforce
years at this job
Computer Science
Database Analyst
Technologies: SQL Server 2012, SQL Server Reporting, C# .NET, WPF.
- Performed server nightly and hourly back up setup.
- Created SQL reports to monitor Server Jobs, Disk space, job steps and job step statuses.
- Performed data integration setup using SSIS
- Designed and developed .NET windows applications using WPF and C#.
Candidate Info
years in workforce
months at this job
Computer Science
Database Analyst
Worked for an IT consulting company on various customer projects and daily support.
- Performed ongoing remote database monitoring and administration for several databases for a large automotive manufacturing corporation.
- Worked on a database monitoring report system using Oracle Web Server 3.0.
- Assessed database performance for a large database, including system utilization and user response time.
- Assisted in Oracle software installations on HP-UX for a large tobacco company.
- Involved in various tool selection processes for prospective clients.
Candidate Info
years in workforce
years at this job
Mechanical Engineering
Management Information Systems
Database Analyst
Design, develop and maintain enterprise data warehouse systems which collectively hold an estimated 20% of retail data in the US.
- Collaborate with client IT teams to understand their transaction data and identify facts and dimensions to load into the APT data model which enables APT's Test & Learn products to run predictive analytics and hence leverage the data.
- Designed, developed and automated ETL processes to load historical sales, inventory or KPIs and incremental updates received at various cadences.
- Analyzed retail datasets and worked with client analysts and APT business consultants and product managers to setup complex metrics and attributes which helped gain a deep insight into market dynamics and sales performance, and hence facilitated better data driven decision making.
- Identified bottlenecks and fixed performance issues by tweaking workflow or using SQL tuning methods
- Built SSRS reports to provide snapshots and abridged scorecards with concise summaries of key metrics.
- Developed and built a demographics dataset with a rich set of demographic attributes using the raw data provided by US Census Bureau.
- Developed a weather metrics dataset for Japan using data provided by Japan Meteorological Department.
- Developed training content and trained team members across various functions within the organization in data management processes and best practices.
Candidate Info
years in workforce
years at this job
Marketing And Operations And Supply Chain Management
Marketing Database Analyst
- Determined the marketing contribution and ROMI for campaigns that produce over $2million in revenue where 25% of the earners were attributed from recommended campaign tactics and strategies.
- Tracked and analyzed over 100,000 call responses per campaign using Five9, a cloud contact center software.
- Tracked and reported all visitor website interaction for over 1.3million page views during a campaign launch using Google Analytics, a virtual online statistical website traffic source used to measure conversion and sales.
- Increased market segmentation for clients by dividing a broad target market into subsets of B2B consumers through direct mail, e-mail, and telemarketing touch-points.
- Analyzed data configuration to determine relationships between databases using SAS, a business analytics and business intelligence software.
- Executed and reported on data collected from online training modules using Microsoft SQL Server, a relational database management system.
- Determined key performance indicators (KPI’s) including visitor profiles, web analytics, mobile and social analytics, and campaigns through Adobe Site Catalyst.
Candidate Info
years in workforce
year at this job
Marine Affairs
Database Analyst
Performed internal data consistency checks using SQL queries and SPSS
- Uploaded finalized data to an Oracle database for record keeping, historical summaries, and data mining
- Wrote technical documentation for database team procedures and operations
- Developed training plan for new database team hires and acted as lead trainer
- Retrieved data by SQL query for statistical analysis and summarization
- Monitored incoming data for errors and potential system wide issues
- Created automated bimonthly report contributing North American data to Dannon global team
Candidate Info
years in workforce
years at this job
Electrical And Mechanical Engineering Technology
Finance
Political Science
Database Analyst
- Responsible for database entry and analysis of payment and submissions to the Internal Revenue Service
- Promoted to training facilitator for new trainees, work with 10 new employees per month
- Recognized for ability to work well during peak seasons and high demand events
Candidate Info
years in workforce
years at this job
Computer Network Administrator
Sr. Database Analyst (department Head)
Took ownership of all Austin database projects and oversaw all aspects for these databases
- Managed and trained various DBAs within in the company on all new platforms and projects
- Tasked with creating new policies and procedures for my department for optimization and efficiency
- Assisted IT personnel on various server issues related to multiple hosted platforms
- Developed new database designs for optimization and workflow standards
- Created and executed various Scripts within SSMS for a variety of tasks which include reporting and quality control checks
- Performed all standard DBA job functions for Clearwell, Relativity, iCONECT, Pure Discovery and other proprietary database systems
- Provide client and internal support for all hosted platforms
Candidate Info
years in workforce
years at this job
Computer Science (honors, Class 2:1)
Artificial Intelligence
Marketing Database Analyst
- Supported Customer Insight & Analytics team by generating ad-hoc reports and analysis using SQL, Business Objects XI and Excel with data sources on Oracle 11G and SQL Server 2013.
- Designed and implemented Self Service reports using Microsoft SQL Server, SSIS and SSRS and Visual Studio Business Intelligence Development Studio.
- Prepared and provided reports and analytics on customer demographic and shopping behaviors.
- Extracted email of customers for targeted marketing projects, using IBM UNICA Campaign, based on purchase and web browsing patterns, product segmentations and recent purchase activities.
- Performed extensive quantitative and qualitative checks on database to ensure integrity of database for reporting purposes.
- Built visualization dashboards in Tableau 8.1 with heterogeneous data sources.
Candidate Info
years in workforce
year at this job
Computer Science And Engineering
Management Information Systems
Database Analyst
Designed queries and stored procedures/functions for pulling and aggregating de-normalized data based on requirements
- Analyzed data and Implemented models for Health Investment Account (HIA) portfolios for employees of Aetna clients
- Contributed in requirements gathering and design for future enhancements of Health Investment Accounts migration
- Developed SAS codes for importing raw files of customer data into Database and modeling it for recommendations
Candidate Info
years in workforce
years at this job
Information Systems / Business Administration
Project Management
Database Analyst
Per customer specifications, designed benefit data processing models for new and existing clients using AllApp and Selerix.
- Designed and implemented test cases to validate the accuracy of the new benefits models.
- Configured and deployed new benefits models on customer provided equipment.
- Provided on and off-site training to in-house personnel on how to implement new enrollment requirements.
Candidate Info
years in workforce
years at this job
Psychology
Marketing Database Analyst
Analyzing telemarketing campaign channels to develop recommendations for future campaigns.
- Designed and implemented marketing databases that broadened analytic capabilities of a major client and provided real time analysis
- Monthly and weekly code development that would Configure and export data to Excel using SAS and SQL software.
- Develops strategy for targeted marketing campaigns and is responsible for data extraction, or evaluating effectiveness of marketing campaigns and delivering to external clients and client groups.
- Working with large financial institutions to report on monthly scorecards metrics from customer satisfaction survey responses
- Assisted in data movement/FTP exercises.
- Helped create voice-of-customer database
Candidate Info
years in workforce
months at this job
Liberal Arts
Database Analyst
- Provided problem identification and correction in support of Allscripts Enterprise Electronic Health Records (EEHR) clients
- Analyzed problems with Extract Test and Load (ETL) processes in dedicated, Allscripts hosted, and 3rd party hosted environments, and applied corrective action
- Diagnosed and corrected problems in Meaningful Use attestation reports required by Centers for Medicare & Medicaid Services (CMS)
- Diagnosed and corrected performance issues in SQL Server Database systems and IIS Web Servers
Candidate Info
years in workforce
years at this job
Computer Science
Management Information Systems
Database Analyst
- Conducted JAD sessions for requirement gathering and scope definition for a relational database for the various department stakeholders.
- Analyzed and re-engineered database schema by defining entity-sets, relationship-sets, cardinality and documenting ERD’s.
- Performed database normalization, conceptualized SQL queries, stored procedures and triggers for the back end system in SQL Server 2008.
- Developed PHP scripts to connect front end system in Drupal with the external database and generate business reports.
Candidate Info
years in workforce
years at this job
Nursing Program
Environmental Studies / Ecology
Master of Arts
Database Analyst
- Interpreted Health Plan eligibility files and prepared files to be downloaded from health plan and then in-loaded into HCPIPA system
- Reviewed, researched and then corrected all eligibility Conflicting and Rejected records
- Interacted with HCPIPA internal departments and health plans to resolve eligibility related issues. These issues included eligibility date conflicts, benefit structure conflicts and conflicting PCP assignments
- Responsible for tracking approximately 54,000 HIP members including sensitive HCPIPA employee records
- Created policy and procedure manuals for HIP and QLIMG download processes
- Created desk procedures for use of EZ-Cap basic functions
- Trained new employees on department policies and procedures
Candidate Info
years in workforce
years at this job
Computer Science
Database Analyst
Part of the development team for several new products and processes including Customer Experience Profile (CEP)
- Solely tested new processes and products for bugs and coding errors as part of a development team
- Created a complex stored procedure designed to check loaded data and ensure accuracy
- Created and regularly implemented a process to check and drop tables in a heavily used database
- Monitored and tuned the performance of Stored Procedures and complex T-SQL Queries
- Created properly designed SSIS Packages
Candidate Info
years in workforce
months at this job
Network Communications
Jr. Oracle Database Analyst (consultant)
Worked on the upgrade project with the team of DBAs
- Monitored database activity and file usage, and ensured necessary resources are present so that databases function properly by archiving/removing old or obsolete files
- Developed data retrieval queries and optimized data queries within programs for performance and maintainability
- Installed new systems or new releases of database systems; determined table attributes, primary, and alternate keys for multiple databases
- Installed and upgraded hardware and software as necessary to enhance database performance
- Researched various hardware and software products; recommended solutions and implemented approved products
Candidate Info
years in workforce
years at this job
Systems And Computer Science
Manager Database Analyst
Managed DB functions and operations for one of the largest insurance and software development companies in the United States and the world.
- Focal point for making sound decisions related to data collection, data analysis, data security, methodologies and designs.
- Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
- Managed creation and implementation of triggers and stored procedures for implementation of custom required processes.
- Maintained the data integrity during extraction, manipulation, processing, analysis and storage.
- Prepare analysis reports and be responsible to answer any queries, complaints or suggestion in this regard
- Monitored and Tuned Applications, SQL statements and databases by using snapshot monitoring, event monitoring, and other monitoring utilities.
Candidate Info
years in workforce
years at this job
Computer Information Systems
Database Analyst
Worked with a team to determine problems and needs of a small business
- Developed a database using Microsoft SQL Server 2008
- Developed GUI to facilitate business user database management
- Applied database performance tuning and optimization to SQL Server database.
- Migrated Microsoft SQL Server database to Oracle database.
- Migrated Optimized SQL Server database to Microsoft Azure cloud
- Created Web access to the SQL Azure database
Candidate Info
years in workforce
years at this job
Computer Science
Senior Infrastructure Analyst/senior Database Analyst/dba
Managing and maintaining the Symantec NetBackup system along with the database backups and vaulting process. Capacity planning, installing, upgrading and monitoring of 60 SqlServer, 20 Oracle and 6 MySql databases. Sharing 24x7 on-call rotation with Database team members.
- Developed and implemented Symantec NetBackup hot and cold Oracle backups.
- Designed, developed, and deployed the automation of Oracle index rebuild scripts.
- Built, deployed, and administer Oracle database for online order entry system.
- Designed and built Sql Server backup compression process.
Candidate Info
years in workforce
years at this job
Computer Science
Solaris System Administration
Manager DATABASE ANALYST
Analyze, design, develop, implement and support multi-terabytes marketing data warehouse.
- Optimized database refreshes performance with ETL tuning and core process re-engineering. Improved performance over 90% on recurring core processes.
- Ensured high quality of data by developing QA monitoring/auditing procedures and reports.
- Worked closely with analysts to implement statistical g models and business rules into Oracle, and completed with segmentation and performance metrics.
- Collaborated with architects and business analysts to determine optimal solutions for a multi-terabytes data warehouse.
- Interacted with clients to clarify requirements and business needs.
- Automated recurring data processing and refreshes with Shell scripts, SQL and PL/SQL scripts.
- Provided support to internal business analysts and external clients with custom/special/statistics summary reports, and answering their ad-hoc queries/questions.
- Created reports in Business Objects for clients to view over internet. Conducted and interpreted data analysis to support the operation and analytic team.
- Provided guidance to junior developers on ETL jobs for marketing campaign operations.
- Light DBA works on exporting & importing data between database instances.
Candidate Info
years in workforce
years at this job
Evercare Minnesota -database Analyst
Designed, developed and implemented database for end users to enter enrollment, authorizations and member utilization data
- Designed, developed and automated standard reports for senior management team analysis/action purposes
- Worked closely with Evercare Minnesota CEO and Evercare Corporate Finance on data trends
- Key player in budget preparation
- Managed Medica and Ucare claims data and reported financial spend monthly
- Developed monthly financial reporting tool to include multi-layer product/program lines
Candidate Info
years in workforce
years at this job
Computer Science - Information Systems And Decision Sciences
Database Analyst III
Created databases in Concordance from various sources including CSV files, MS-Excel, MS-Access, Adobe, Outlook and TIFF.
- Mapped new SEC data from third party vendors to litigation servers.
- Edited, searched, and tagged documents.
- Ensured images were properly synchronized with database records.
- Reviewed and did quality assurance upon completion of all assignments and projects using a standard checklist.
- Created database locations and structures for attorneys to be able to locate and pinpoint data upon their usage on a large network.
Candidate Info
years in workforce
years at this job
Mathematics And Computer Science
Database Analyst II
- Designed and implemented a data loading workflow for the Recommind Axcelerate tool
- Assisted in the creation of a workflow for the migration of data from Concordance to Recommind
- Addressed issues in data files encountered by staff members during the loading process
- Investigated and initiated solutions for Recommind template and network connection issues
- Wrote Perl scripts to help streamline the data loading process and ensure timely availability of data
Candidate Info
years in workforce
year at this job
Finance
Database Analyst
- Created and maintained stored procedures/views for reporting. Optimized data model including researching indexing, keys, etc. Created new code writing procedures to address locking issues within the database.
- Developed and administered a large SQL Server 2000 platform.
- Analyzed database issues that included query performance, data mapping and lost network connection issues between FoxPro, SQL and the data warehouse. Analyzed the data warehouse for data content issues, anomalies, etc.
- Wrote complex queries to solve reporting issues over cross platforms.
- Worked with external FoxPro design team to ensure data accuracy of their front ends with the data warehouse.
- Tested issues, which included setting up the test procedures, of the FoxPro front end and worked these issues to conclusion.
- Reports created from developing stored procedures to deployment. This included using Crystal Reports and/or Excel as a final reporting solution for ad-hoc reports. It also involved using DTS packages to create a data mart to increase speed of final report.
- Managed several projects from start to completion, including proper allocation of available resources to meet deadlines.
Candidate Info
years in workforce
years at this job
Computer Science
Database Analyst/administrator
Involved in analysis of business software requirements documents and understand software functionality.
- Accountable for creating new logins, passwords, data access as per user roles, running ad-hoc queries and reports on an ongoing basis.
- Designed/developed/tested/implemented SQL stored procedures, functions, triggers and packages.
- Developed and modified ETL process to load data from flat files to SQL database.
- Organized, /planned/interacted with users to get requirements for various reports, do data analysis, participate in code review with developers, assist in integration and acceptance testing and migrate to production.
- Created, /modified/ tested/validated the data for adhoc queries/reports using SQL and SSRS. Reports are made available for Intranet, emailed business users to assist in accurate decision making business processes. Used HTML, XML elements, syntax, style, parser and viewing, CSS, Java script and VB script to develop/maintain internal website.
- Excellent verbal, interpersonal, writing and communication skills. Strong analytical, problem-solving skills.
Candidate Info
years in workforce
months at this job
Business Management
Information Systems Technology
Accounting
Financial Database Analyst
Analyze and evaluate financial data from the Department of Interior (DOI) Financial and Business Management System (FBMS).
- Developed Microsoft Access to import FBMS monitoring reports into tables and create weekly queries to report un-liquidated obligation (UDO) statuses.
- Converted existing queries from FBMS to Business Objects (BOBJ) during and after the overhaul of the Data Warehouse system.
- Specialized as the lead knowledge operator, viewed, sorted and analyzed business intelligence data within Business Objects (BOBJ).
- Created ad hoc queries for specific analysis of data by Web Intelligence.
Candidate Info
years in workforce
years at this job
Business / Psychology
IT Database Analyst / IT Disposal / Sale / Special Projects
IT database analyst for Fortune 500 client. Backup for Database Administrator. Responsible for day to day validation and recording of movement of equipment from primary IT asset warehouse and weekly auditing of inventory. Responsible for initiation and preparation of equipment sales and donations including pricing and work order creation. Special projects including three company-wide new work station refreshes.
- Maintain asset levels according to business needs, sell or donate equipment to maintain asset levels while upholding contract levels of accuracy and timing
- Audit and maintain accurate IT database
- Coordinate equipment transfers and sales with client management and warehouse staff
- Prepare a variety of detailed analytical reports, both static and ad-hoc, based on the needs of internal and external clients
- 100% client service level achievement
Candidate Info
years in workforce
months at this job
Business Administration
Information Systems
Database Analyst
Created logical and physical data models in both normalized and denormalized versions.
- Presented models to the DBA and data modeling team for peer review
- Created Excel spreadsheet using formulas to check data models for meeting standards
- Created source to target mapping documents
- Gained experience in modeling banking customers website activities
Candidate Info
years in workforce
year at this job
Database Analyst
Focal point for making sound decisions related to data collection, data analysis, data security, methodologies and designs.
- Maintained data integrity during extraction, manipulation, processing, analysis and storage.
- Coordinated project development and implementation activities.
- Analysis if information using various statistical methods, trying to see patterns in data
- Conceptualization of data and sharing this knowledge through effective presentation of the data output with the rest of your team
Candidate Info
years in workforce
year at this job
Database Analyst
Responsible for managing the database environment, ensuring a high availability and performance in a minimum supervision environment.
- SSRS -SSIS Custom Reports Development to improve departments work flow.
- Implemented SQL Server 2012 Side-by-Side migration (SQL Server 2005 to SQL Server 2012).
- AS/400 Database Performance improvements, (Indexing, Defrag, Monitoring)
- Proactive database monitoring to ensure minimum services downtimes and better performance.
- Database Backup/ Recovery.
- Departments Process automation by interviewing Users/Managers using SSIS/ SSRS.
Candidate Info
years in workforce
years at this job
GED
Certification
3 Semesters
Database Analyst
- Updated provider information in current database
- Tracked and executed provider file updates and modifications
- Researched and resolved high priority issues
- Managed work inventory and personal queues
- Responsible for processing large dataset inquires
- Accurate processing of work items
Candidate Info
years in workforce
months at this job
Science
Civil Engineering
Database Analyst
Work as a consultant contractor through Jacobs on the [company name]'s Asset Management Program.
- Perform database analysis of the [company name]'s entire pipeline system.
- Assist asset management team with budget analyses and perform labor management for fiscal year 2016 and 2017.
- Organize engineering drawings and database of water pipelines for contractor to perform Magnetic Flux Leakage pipeline inspection.
- Update database of the entire water pipeline system of the [company name].
- Use Pivot Tables and advanced Excel commands to analyze all needed information of water pipelines.
- Perform engineering calculation for Carbon Fiber Reinforced Polymer Renewal and Strengthening of PCCP.
Candidate Info
years in workforce
years at this job
Business / Data Processing
Database Analyst
- Responsible for ensuring that the work performed by installers, technicians and contractors corresponds and is consistent with the paperwork generated at the time that the work was requested.
- Create spreadsheets using Microsoft Excel and update log upon completion of daily work.
- Audit the work orders completed to work recorded in the billing system for consistency.
- Make corrections or reschedule work as necessary and schedule appointments for drop buries and installations.
- Generate and maintain pending reports on a daily basis and file completed work orders.
Candidate Info
years in workforce
years at this job
Database Analyst
Accurately deposit and process all donations to CHCC in the form or checks, cash and credit cards, while coding each gift to the appropriate Department or Fund within the hospital.
- Work directly with the Finance Department to reconcile donations that are processed each month.
- Train and supervise volunteers, interns, temporary employees as well as fellow co-workers within the fundraising database, The Raiser's Edge.
- Participated in the recruiting and interviewing process for several different positions within the Foundation.
- Help assist many donors and individuals over the phone and in person to help direct them to the appropriate department or person within the hospital.
- Send all thank you letters and receipts within a 72 hour turn-around for each donation that comes in.
- Accurately cleaned-up and continue to maintain The Raiser's Edge fundraising database with 70,000+ constituent donor records.
Database Analyst Resume Success Stories
Database Analyst Duties and Responsibilities
A Database Analyst's duties and responsibilities will vary from project to project and company to company. There are, however, several common primary duties for nearly all Database Analysts. A review of current job listings identified the following core tasks and responsibilities.
Organize Data Database Analysts must be able to gather pertinent information and organize it in a logical and functional manner. They will consult with management or administrators to determine what data needs to be included in the database system and will then find the best ways to organize and store this information. They will often create flowcharts and diagrams during this stage of data construction to illustrate how the data will be sorted and stored.
Design and Implement Databases Most Database Analysts will be expected to design and implement a database system once they have worked on the data organization. They must be up-to-date on the latest practices and trends in database creation in order to perform these tasks. They must also be fluent in one or more programming languages as well, such as SQL, an industry standard.
Document Actions Documentation is a very important part of the Database Analyst's job. Every aspect of a database must be thoroughly recorded. These documents will serve as references for new employees and for future maintenance on the system. Database Analysts must be able then, to communicate well through writing and be able to create flowcharts and diagrams.
Test and Secure Databases All databases must be tested for functionality and accuracy. Database Analysts may perform tests before a new system is launched as well as periodic testing on existing systems to ensure they are performing satisfactorily. They may also put in place security systems to prevent the information contained in the database from being accessed by unauthorized users.
Database Analyst Skills
A successful Database Analyst must be technically-inclined, a great problem-solver and possess excellent interpersonal skills. They are extremely reliable and enjoy working in teams and independently. They should also work well under pressure and tight deadlines. In addition to these traits, employers look for applicants with the following skillsets. Core skills: Based on job listings we looked at, employers want Database Analyst with these core skills. If you want to work in this field, focus on the following.- Knowledge of programming languages such as SQL, Javascript, CSS, HTML, and PHP
- Advanced computing skills
- Experience in creating database queries
- Data modeling experience
- A degree in Computer Science or related field
- Software development experience
Database Analyst Resources
There are more helpful and informational resources available on the Web for those interested in working as a Database Analyst. We scoured the internet and found these links full of learning opportunities and the latest industry news. On the Web
Database Journal - This site is full of articles and resources aimed at database professionals. Read about current trends and new technologies or visit their forum to connect with other Database Analysts.
Database Trends and Applications - This quarterly publication is a one-stop shop for everything database related. All the newest technologies, latest trends and developments, and best practices are covered in this magazine.
Database Magazine - This UK-based publication provides a wealth of information for database professionals. Database Analyst Books
Database Administration: The Complete Guide to DBA Practices and Procedures - Written by a Database Administrator with over 30 years' experience, this guide is an excellent resource for anyone working with databases. It covers the best practices, useful solutions, and the latest technologies in the field.
Database Systems: Design, Implementation & Management - This text is easy to read and full of useful diagrams, tables and illustrations to clarify the material. It covers the whole scope of database systems from the design phase to testing and updating practices. Industry Groups
Institute of Electrical and Electronics Engineers - IEEE established in 1884 for the burgeoning electrical industry, has grown into an organization with over 430,000 members worldwide composed of scientists, engineers, software developers and computer science employees. Their large network of members enjoy career development, technical information, research and industry news from this organization.
Computing Research Association - Founded in 1972, CRA brings together the worlds of government, academia, and industry to strengthen and improve the research and education in computing.
Association for Computing Machinery - Founded in 1947, ACM is the largest educational and scientific computing society in the world. It boasts over 100,000 members worldwide and is a wonderful resource for anyone in the computing industry.
