Database Analyst Resume Samples

Description :

1. Installation, configuration, and upgrade of MS SQL Server 2000/2005/2008/2012.
2. Created user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, the creation of groups, granting the privileges to users and groups.
3. Data modeled an entire database system and have implemented and maintained.
4. Incorporated security to the database using the encryption/decryption, certificates.
5. Created DTS/SSIS packages to pull data from Oracle, Sybase, ms access and flat files for a project called legacy archive decommissioning.
6. Used performance-monitoring tools like SQL profile, SQLDIAG blocker script and system monitor.
7. Coordinating with the development team regarding tuning the SQL queries and stored procedures.
8. Designed and documented logical and physical data models using various tools like Erwin and MS Visio and SQL architecture.
9. Created different database maintenance plans for database optimization, integrity checks, and database backups.
10. Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained referential integrity.
11. Involved in security administration- creating users and assigning them roles and privileges.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Responsible for supporting the e-discovery needs of attorneys and support staff and implementing the department’s best practices related to e-discovery and data workflow.
2. Working with the office of data technology staff in the resolution of problems and implementing suggestions.
3. Developing, evaluating and modifying methodologies and procedures for manipulating files for use with cots products and litigation support applications.
4. Providing technical assistance to attorneys in the production of electronically stored information, along with preparing electronic discovery requests.
5. Providing load file manipulation (using regular expressions, editing paths, fixing delimiter issues), loading, and conversion services (processing in law, and relativity). Loading audio files in Nexidia sessions.
6. Extensive quality control checks on loaded data and outgoing productions.
7. Used SQL management studio to run simple queries when trying to find and resolve relativity issues on the back end.
8. Creating new relativity matters, new workspaces, adding new and existing users with permissions to new and existing workspaces. Creating new fields, running scripts, running searches and running outgoing productions. Monitoring relativity error alerts, logging into remote servers to restart inactive workers or agents.
9. Performing relativity smoke testing of all services in a test environment on weekends after monthly security patches are deployed – ensuring all services are working as normal.
10. Accessing and supporting virtual terminals via remote desktop connections. Migrated large volumes of data to and from network directories and databases. Using and modifying RoboCopy and Perl scripts.
11. Converting legacy databases to relational databases (concordance to relativity) and updating casemap links.

Experience

2-5 Years

Level

Junior

Education

AAS

Description :

1. Managing the organization CRM database and ensured its reflection of accurate and current member information.
2. Adding data and updated agency and/or holding company personnel and organizational changes.
3. Consolidating and analyzing data thoroughly to come to clear conclusions for recommendations.
4. Analyzing and problem-solving issues with current and planned systems as they related to integration and management of member data.
5. Updating and enforce standard operating procedures, business rules, logic, and processes.
6. Acquiring and abstracting primary or secondary data from existing internal or external data sources.
7. Developing and implementing data collection systems and other strategies that optimized statistical efficiency and data quality; researched and evaluated new techniques and tools for consideration.
8. Interpreting complex results and gave effective input on improved ways to utilize existing system data.
9. Maintaining direct, timely and appropriate communication with staff and 4as high profile member contacts.
10. Became the net forum "guru" and taught procedures and operations to staff, as well as all new hires.
11. Remained current on holding company activity, acquisitions, network agency structures, etc.
12. Researched movement of people in the industry to keep database current (ad week, advertising age, campaign, NY times, wall street journal, agency spy, Delaney report, etc.).

Experience

7-10 Years

Level

Executive

Education

BA

Description :

1. Served as a staff level database and operations analyst at a major army service.
2. Management of personnel mobilizations, and technical advice and guidance with regard to a vast array of army human resource related databases, programs, and contingency.
3. Provided subject matter expertise, analytical thinking, program operations guidance, skill in the manipulation of personnel placement data, and the ability to create and organize.
4. Reports regarding personnel deployment lifecycle accountability with regard to over 2000.
5. Personnel deploying to over 25 different warfighting joint task forces dispersed throughout the middle east and the united states, keeping staffing levels above 90 percent.
6. Provided database management of the worldwide individual augmentation system.
7. Developed reports and scheduled reviews using data from a multitude of army databases to advise leadership on current and projected personnel deployments in order to provide a.
8. Framework for program priorities, funding, requirements, and objectives for the organization.
9. Initiated training and user account setup for incoming WIAS users and provided guidance and system training sessions on technical procedures and general usage of the database to ensure uniform and proficient database utilization and security of information between all.
10. Interpreted and incorporated a wide variety of military force protection regulations, plans, and laws initiated by the joint staff, us central command, and headquarters of the company.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Developing and maintaining the ETL process to transfer and transform data from 4 different databases into a 2 terabyte Oracle data warehouse using the Dac (data warehouse administration console) from OBIEE (oracle business intelligence foundation suite) to run Informatica workflows.
2. Creating and maintaining Informatica mappings, sessions, and workflows to flow data from sources to the appropriate data warehouse tables.
3. Create, maintain, and publish power BI reports and dashboards which combined data from Oracle SQL server, and service now sources.
4. Leading development efforts on the last run of an old budgeting process so that finance can create budgets for leadership approval. This legacy budgeting process affected all 3500 employees if not done correctly.
5. Working in an agile development environment on a year-long project to produces a series of interactive dashboards to help project managers analyze their projects health and performance. Won the 2015 operational excellence achievement award for this project.
6. Using Kimball's dimensional modeling techniques and theories to create and maintain facts and dimensions in the data warehouse.
7. Creating and maintaining the oracle bi admin tool of OBIEE to provide users with data in bi answers in 10g and bi analysis in 11g.
8. Creating and maintaining interactive dashboards and reports using bi answers/analysis.
9. Creating and maintaining SSIS packages for the daily transfer of data from the transactional system to an asset management system.
10. Actively participated in an OBIEE 10g to 11g upgrade project. Reworked old answers reports that were incompatible with 11g analysis. Reworked dimension and fact tables to allow them to be more compatible for federation Essbase cubes.
11. Actively participated in an Oracle migration project where the data warehouse was transferred from an SQL server system to Oracle.

Experience

10+ Years

Level

Senior

Education

BS

Description :

1. Successfully load the data to SQL server2008 /2012 and analyze and explain the result using SQL server 2008/2012 and access as an important tool.
2. Creating database tables with various constraints including primary key, foreign key, etc.
3. Loading data from flat data files into SQL server 2008/2012 database tables, using BCP, bulk insert, and table export/import; loaded data from flat data files and excel sheet into database/data warehouse.
4. Extracting data from SQL Server 2008/2012 database tables and Oracle database tables into flat data files and excel sheet.
5. SQL queries with multi-table joins, group functions, subqueries, set operations, and T-SQL or PL/SQL functions.
6. Generating a variety of business reports using SQL Server 2008/2012 SQL query, SSRS, crystal report 2008 and excel 2007 pivot table.
7. Using different databases cross-reference other databases with a primary key, foreign key and linking their related knowledge together.

Experience

10+ Years

Level

Senior

Education

MS

Description :

1. Developed and conducted business owner needs analysis from which project specifications are created relating directly to the claims administration industry sector.
2. Managed highly confidential client data filed that originate from various database platforms.
3. Modified, tested, and deployed database structural changes as required based on project specifications.
4. Wrote, tested and deployed stored procedures, triggers, functions, and reports based on project specifications using SQL server 2008.
5. Wrote codes for database access, modifications, and constructions using SQL server 2008.
6. Managed products in accordance with the approved standards, procedures, and methodologies.
7. Ongoing support of Rust/CCS/KNC business owners to include process development, troubleshooting, problem resolution, phone support and user training.
8. Experienced in manual testing, test automation, writing and executing test plans/test cases, writing SQL queries.
9. Documented and track test results, defects, and other quality metrics.
10. Developed and executed formal plans, procedures, and scenarios for manual and automated testing to ensure the quality of software applications.
11. Reviewed and assesses test coverage to ensure thorough quality review.

Experience

0-2 Years

Level

Entry Level

Education

MS

Description :

1. Primary role is as a data analyst responsible for the reference data database design, data acquisition and downstream delivery for the firm's finance systems. In this capacity am responsible for the logical and physical database designs and physical implementation for existing and strategic reference data stores across db2 and Teradata platforms.
2. Manager of the finance reference data (FRD) team managing the day to day operations of the system as it delivers reference data to 40 downstream consumers. A team consists of four members with ba and ETL skills. Responsible for the full software development lifecycle.
3. Constructed current state logical models of finance owned reference data including general ledger company, general ledger accounts, structures and company codes in Erwin.
4. Set-up model mart repository to house finance owned reference data models.
5. Conversion of finance owned reference data into strategic commerce model designs.
6. Designing reference data delivery solution from db2 into the detailed sub-ledger (DSL) Teradata repository. Reference data postings will leverage MQ, PERL, and XSLT to propagate changes from db2.
7. Participating in logical model naming standards and Erwin case tool replacement meetings.
8. Created and presented the strategic roadmap for finance owned reference data to stakeholders.
9. Design and delivery of 50 hierarchies (company, balance sheet, GL account, etc ) used by finance systems in the PDR structures model.
10. Performance management of db2 databases. Set-up and run performance lab tests to recommend performance improvements, determine system capacity and recommend future state.
11. Member of the corporate banking technology and phoenix funding management teams.

Experience

10+ Years

Level

Senior

Education

MM

Description :

1. Database administrator for the surface water ambient monitoring project (swamp) program for region 5. My responsibilities were, as water samples are taken, to ensure they met the SOP, Protocols in sampling, timeliness of laboratory analysis and quality assurance standards.
2. Supervised the data entry, verification, and QA/QC then personally loaded the data into the state swamp database.
3. Coordinated the data entry for sampling done for the state swamp contract, which included training the scientific aides, and establishing tracking procedures.
4. Developed a data loader using VBA and access macros for streamlining the data.
5. Entry with excel spreadsheets and merging the data into an access database for later processing into the state SQL databases.
6. Used SQL to query and maintain the database and assist environmental scientists in retrieving data for their projects.
7. Formed excellent one-on-one working relationships with the senior staff.
8. Created a sophisticated spreadsheet analysis to meet their reporting requirements.
9. Assisted other staff making macros in excel and designing databases for other.

Experience

10+ Years

Level

Senior

Education

BS

Description :

1. Implement daily, weekly, and monthly reports online by reviewing and approving new product tables therapeutic class while assisting in making therapeutic class decisions when necessary.
2. Assigns products names via MediSpan through system generated ids which the specialist creates and are then called brand names for in-house client database tables.
3. Consist of system generated ids for strengths, forms, manufacturers, and corporations which analyst creates as well as USC codes for new NDCS which are not yet placed into database tables.
4. Analyze data with the ability to identify all data discrepancies with the authority to make the necessary changes.
5. Create multiple operational reporting tools such as PL/SQL query statements to extract data to create an excel spreadsheet.
6. Research the internet (google, daily med, price Rx, and facts and comparisons answers etc.) to maintain data integrity.
7. Match new forms and routes, also package combination to form numbers.
8. Provide analytical support of actual results against product data and feasibility of proposed business strategies.
9. Ensure accuracy of data through the partnership with team members, day-to-day validation, and spot checks via (QC).
10. Consistent exercise of independent judgments and discretion in matters of significance.

Experience

10+ Years

Level

Senior

Education

Associate