We provide IT Staff Augmentation Services!

Test Analyst Resume

SUMMARY:

A PL/SQL Oracle database developer, with 3+ years of relevant experience - Entity-Relationship diagram (ER diagram) - logical, physical data modeling, stored procedures, functions, triggers, cursors, packages, performance tuning.

CORE SKILLS:

Requirement analysis to design database solution - data modeling, root cause analysis and problem solving, Oracle database development with PL/SQL, SDLC, ITIL, Oracle 11g database architecture

TECHNICAL SKILLS:

Database & Tools: Oracle 11g, SQL Server, MySQL, ErWin Data Modeler, Visio, SQL*Loader, SQL*Plus, TOAD, Confidential, SAS Base, Tableau, Excel, MS Project, Putty, WinSCP, Informatica

Languages: PL/SQL, SQL, Unix shell scripting, Java, Hive Query Language (HiveQL) for Hadoop

Methodologies: SDLC, Agile, ITIL, ITSM, data warehouse design - Kimball, Inmon, crow-foot notation, chen notation

PROFESSIONAL EXPERIENCE:

Confidential

Test Analyst

Responsibilities:

  • Designed solution for inventory control - reorder point using demand forecast, lead-time, safety stock
  • Performed business analysis - researched, developed business requirements for the hospital supply chain subsystem
  • Designed database system on Oracle 11g - logical and physical model, forward engineering using ErWin data modeler
  • Developed 26 tables, 4 procedures, 4 functions, 2 triggers- PL/SQL on TOAD, imported data into tables using SQL loader

Confidential

Test Analyst

Responsibilities:

  • Dimensional data modeling for data warehouse - star-schema, developed grain, fact, dimension tables using Kimball
  • Loaded large datasets into Oracle 11g using SQL Loader, performed ETL in SQL, dashboard and reports in Tableau 10.0

Confidential

Test Analyst

Responsibilities:

  • Implemented transformations in SQL, tested ETL output against specified business requirements for transformations
  • Loaded csv flat files from different systems, into the SQL Server database, initial cleanup to ready data for processing

Confidential

Software Engineer

Responsibilities:

  • Lead enterprise-level database changes, onsite coordinator, single point of contact ( Confidential ) for critical application, dealing with 8 other application systems to implement a Common Exchange Model ( Confidential ) data across the enterprise
  • Documented high-level and low-level design solutions for database change requests, and problem requests
  • Designed normalized database tables using logical, physical data models for changes - Oracle 10g, Oracle 11g database
  • Built data model for existing database - reverse engineering via ErWin data modeler, data management practices
  • Created stored procedures - procedures, functions, packages, triggers and used dynamic SQL, cursors, DML, DDL to implement business logics and process bulk data - Confidential database
  • Developed test plan, strategy for database changes; performed unit test, system test, and system integration testing
  • Optimized reports by 30% - Performance tuning of SQL queries using Confidential, indexes, hints, table partitions, rewriting query to avoid Cartesian joins created deployment plan, optimized data validation scripts, backup scripts, trained team members, validated data quality, built strategy to forward bulk data to other systems involving EDI and B2B, communicated with client, senior managers, other teams
  • Worked closely with data architect, solution architect, test manager, and business analyst to lead database solutions
  • Monitoring governance - 24x7 L2 support for critical incidents, post Go Live support for development release, patches
  • Acted as key database specialist for critical application, guided SLA team of 7 members - incident root cause analysis
  • Wrote job files in unix shell script, with SQL query and identifiers, to exchange data between two relational databases
  • Trained the team members from capgemini during project transition - application database, tools, business processes

Hire Now