We provide IT Staff Augmentation Services!

Quality Assurance Resume

0/5 (Submit Your Rating)

SUMMARY

  • Over 10 years of dynamic IT career reflecting 6+ years of experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Datastage 8.1/7.x/6.x(InfoSphere Information Server, WebSphere, Asecential DataStage).
  • Excellent knowledge of different RDBMS like Oracle 8i/9i/10g, MS SQL Server and DB2.
  • Expert in working with Data Stage Administrator, Manager, Designer, and Director.
  • Experienced in integration of various data sources (DB2 - UDB, SQL Server, Sybase, Oracle, Teradata, XML and MS-Access into data staging area.
  • Expert in using Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
  • Involved in all the stages of Software Development Life Cycle (SDLC).Familiar with Online Analytical Processing (OLAP) tool and creating Multidimensional Databases (MDDB’s).
  • Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator.
  • Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
  • Experienced in working with Quality Stage for data profiling, standardization, matching and survivorship.
  • Expertise in Database programming, Data analysis, Data design and Data migration techniques.
  • Expert in performance analysis of the jobs and queries and performance enhancement and tuning of jobs.
  • UNIX scripting for datastage
  • Expert in working on various operating systems like UNIX AIX 5.2/5.1, Sun Solaris V8.0 and Windows.
  • Experienced in Requirement analysis and Quality Assurance technologies.
  • Expertise in Unit testing, Integration testing, back-end testing and maintenance.
  • Good aptitude for problem solving and logical analysis.
  • Excellent interpersonal communication skills and possesses the ability to work effectively in a team environment.

TECHNICAL SKILLS

ETL Tools: IBM Infosphere Information server 8.1, Ascential DataStage Enterprise and DataStage 7.5/7/6.x(Designer, Manager, Director and Administrator), Information Analyzer, Quality Stage, MetaStage Informatica Powercenter 8.6(Designer, Workflow Manager, Workflow Monitor, Repository Manager)

Databases: Oracle 10g, 9i/8i, MS SQL Server 2005, DB2 UDB, Teradata, MS Access 2000/97, Sybase,Lotus Notes(.nsf and .ntf)

Tools: SQL*Plus, SQL*Loader, Business Glossary, Oracle Designer, Erwin, ER/Studio, TOAD 8.6, Crystal Reports, Business Objects, Autosys, Mercury Test Director

Operating Systems: IBM AIX 5.2/5.1, HP-UX, Solaris 5.10, Windows NT/95/98/2000/XP/Vista

Programming Languages: SQL, PL/SQL, Unix Shell Scripting, C, C++, Java Script, Lotus Notes Script, ASP

We'd love your feedback!