Quality Assurance Resume
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
