We provide IT Staff Augmentation Services!

System Analysis Resume

New Jersy, NJ


Experience Summary

  • 7+ years of IT experience in the System Analysis, Design, Development, Implementation, Testing and Production support of Database, Data warehousing, Client/Server/Legacy applications for various industries, using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis.
  • Around 5 years of experience in ETL using Ascential Datastage 8.5/8.1/8.0.1/7.5/7.1r1/7.0/6.0 XE (Datastage Manager, Datastage Designer, Datastage Director, Parallel Extender)
  • 2 years of experience in the upgraded version of ETL data warehousing tool IBM Websphere Datastage 8.0.1/8.1/8.5
  • Experience with FACT Tables, Dimension Tables for Star Schema Modeling
  • Participated in discussions with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues.
  • Experience in Data Mining with exposure to OLAP, OLTP, database administration, data warehouse development and Data modeling.
  • Extensive experience in Designing, Compiling, Testing, and Scheduling and Running Data Stage jobs.
  • Expertise in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon.
  • Experience working with Parallel Extender for Parallel Processing to improve job performance while working with bulk data sources. Worked with most of the parallel stages applying different partitioning techniques.
  • Experience working on Quality Stage in 8.0 for data cleansing and data standardization Process.
  • Extensive experience in Dimensional modeling techniques.
  • Experience in converting the Business Logic into Technical Specifications.
  • Very good experience to write complex SQL Queries.
  • Extensively worked with Parallel Extender for splitting bulk data into subsets to distribute the data to all available processors to achieve best job performance.
  • Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and designing server/parallel jobs of Datastage.
  • Experience in loading data from Flat files, XML files, Oracle, DB2, SQL server into Data Warehouse/Data Marts using Datastage.
  • Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications.
  • Excellent team player with strong written, communication, interpersonal, analytical skills. Capable of working under high stress environment with resource constraints
  • Technical Skills

    ETL Tools: IBM InfoSphere DataStage and QualityStage 8.5/8.1/8.0,
    Ascential Datastage 6.0/7.5.2, Quality Stage, Informatica Power Center 8.1
    Reporting Tools: Business objects Xi/R2, OBIEE
    Languages: C, C++, Shell Scripting, SQL, PL/SQL, BTEQ
    Operating Systems: Windows NT/98/2000/XP/7, AIX UNIX, LINUX, HP-UNIX
    Data Modeling: ERStudio Data Architect 8.5.3, Erwin 4.1/3.5
    RDBMS: Oracle 10g/9i/7.0, Teradata 9.1/8.0, DB2 9.1/7.1, SQL Server 2010/2005/2000,
    Sybase, MS Access
    Database Tools: Aqua Data Studio 10.0, SQL Server Management Studio, TOAD, PL/SQL Developer,
    SQL Loader
    Other Tools: UC4 (Job Scheduling tool), SAP-R/3 (Plug-in), PUTTY, WINSCP, MS Office Suite,
    Microsoft Visual Studio 2010 (TFS Version Control), MS Visio

    Certifications

    IBM Certified Solution Developer -- Websphere IIS Datastage Enterprise Edition V7.5

    Education

    Masters in Computer Applications

    Hire Now