System Analysis Resume New Jersy NJ - Hire IT People

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

We provide IT Staff Augmentation Services!

System Analysis Resume

New Jersy, NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship