We provide IT Staff Augmentation Services!

Data Stage Administrator Resume

Malvern, PA

Summary:

Over 7 yearsof IT experience in full life cycle development,Data Warehouse Development, Data Modeling, Design, Mapping, Extraction, Migration,Data Cleansing and Design/Development of ETL.Experienceconverting business requirements into a feasible technical solutionapplying client-server based technologies in mixed OS environments. Development experience includes applications in Financial, Banking and Health.

  • Extensive experience with Extraction, Transformation, Loading (ETL) process using Ascential Data Stage EE/8.0/7.5/ 7.1/6.0/5.2
  • Strong understanding of business processes and interface with IT.
  • Experienced in writing system specification, translating user requirements & creating design specifications.
  • Experienced in Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting Systems.
  • Experienced in design and implementation ofER, Star SchemaandSnowflake Schema.
  • Experience in developing different ETL DataStage jobs using stages (Lookup, Join, Change Capture,Aggregator,Datasets,XML Input, XML Output,Sequential files, ODBC,OraOCI,Transformer, Oracle and DB2 Enterprise, Merge, Modify and Copy).
  • DesignedParallel jobs, Job Sequencers, Batch jobs andServer jobs.
  • Expertise in developing strategies for Extraction, Transformation and Loading (ETL) processes using DataStage, expertise in LLD (low level design) and requirement analysis gathering.
  • Skilled in integration of various data sources such as SQL Server, Oracle, DB2 and MS Access into staging area.
  • Involved inPerformance Tuningof the DataStage Parallel jobs using Performance Statistics, Dump Score.
  • Experience in handlingxml filesusing Datastage.
  • Experianced in scheduling and running jobs usingDS Director&Unix scripting.
  • Creating Dashboard Style operational/adhoc reports for various departments using cognos 8.x/CRN1.1 tools (Frame work Manager, Report Studio, Query Studio).
  • UsedQuality Stagewith in DataStage parallel extender Version 8 to investigate, standardize and cleans names, address, phone numbers etc..
  • Experience in integration of various data source,testingand user documentation.
  • Installation, Configuration, Upgradation, and Maintaience of IBM Websphere Datastage on UNIX and windows.
  • Worked withcomplex flat filesusing logic to transform data for mapping.
  • Worked extensively with Business Analyst during requirement gathering.
  • Multilingual, highly organized, detail-oriented professional with strong technical skills.

Certification:

  • IBM Certified Solution Developer -- WebSphere IIS DataStage Enterprise Edition V8.0

Technical skills:

ETL Tools

Data stage 8.0/7.5/7.1/6.0, Quality stage7.x/8.x

Databases & Tools

Oracle (8i/10g/11g), UDB/DB2, Sybase, MS SQL Server, Erwin, Microsoft VISIO.

Languages

SQL, C/C++

Operating Systems

SunSolaris,Unix, Linux, IBM AIX (4.0/5.x), Windows XP/NT/2000/9x.

Web/App Servers

WebSphereApplicationServer3.5/4.0/5.0/5.1/6.0,IBM HTTP Server, Apache Web Server.

Scripting

WSADMIN, Korn Shell Script, Perl, JavaScript, VBScript.

Reporting Tools

Cognos 8.3 Suite, Report studio ,Query studio Crystal Reports, SQR, D2K

Professional Experience:

Confidential , Malvern , PA Aug ‘07 – Nov ‘09
Data Stage Administrator /Developer

Responsibilities:

  • Performed Installation and migration of IBM Websphere Datastage Enterprise Edition/PX on UNIX platforms.
  • Extracted data transformed and loaded into Oracle database according to the required provision using Data Stage 8.0.1/7.5.
  • Experienced with full life Cycle and Methodology for implementing logical and physical models of Datawarehouse.
  • Created DataStage parallel jobs to load data from Sequential files, Flat files, Data sets to Oracle.
  • Involved in dimensional modeling of the Data warehouse to design the business process, data representation, dimensions and fact tables using Erwin.
  • Enhanced the Job Performance by using proper partitioning methods and analyzing the resources utilized using Job Monitor.
  • Generated Surrogate Key for the dimensions in the fact table for indexed and faster access of data
  • Used QualityStage to investigate, standardize, and cleanse names, address, phone numbers and emails.
  • Implemented Datastage Application using Change Data Capture (CDC).
  • Implemented the Slowly Changing Dimension (SCD) strategy in Datastage, for Dimension tables for storing history data.
  • Experianced in running jobs using Job sequencers & Unix scripts.
  • Experience in UNIX shell scripting, for various functions such as maintenance, backup, and configuration.
  • Worked extensively inData Analysis, Design, Development,Testing and Implementation of various Applications in Ascential Datastage using multiple sources and targets likeOracle, DB2 and Flat filesonUNIXenvironment.
  • Created job sequences and job schedules to automate the ETL process. Enhanced the job properties for performance tuning.
  • Implemented Crontab for automating job execution.
  • Strong administration skills on Data stage and websphere.
  • Documented the purpose of the jobs so as to facilitate the personal to understand the process and incorporate the changes as and when necessary.

Environment: IBM DataStage 8.0/7.5 (Parallel extender), oracle 11g/ 8i, IBM AIX, DB2,SQL Query Analyzer, Flat files.

Confidential , Jersey City, NJ July ‘05 – Jun ‘07
DataStage Developer

Responsibilities:

  • Was responsible for Requirement Analysis, Design and Development of the project.
  • Performed extensive source Data analysis for effective design.
  • Extracted data transformed and loaded into Oracle databases according to the required provision using DataStage 7.5.
  • Designed Star schema model for Target system.
  • Responsible for mapping and workflow techniques.
  • Enhanced the Job Performance by using proper partitioning methods and analyzing resources utilized using Job the Monitor.
  • Extensively used most of the stages available in DataStage (Transformer, Aggregator, Join, Lookup, Merge, Sort, Link Collector, Link Partitioner, Hash file, Sequential file).
  • Used Datastage Manager for Importing, exporting projects, Individual components, Metadata definitions, from and to Repository
  • Involved in all the stages of Software Development Life Cycle (SDLC).
  • Extensive experience working with complex mainframe EBCDIC files using complex file stage
  • Experience in UNIX shell scripting, for various functions such as maintenance, backup, and configuration.
  • Automated Job Control using Batch logic to execute and Schedule various Datastage jobs.
  • Designed Datastage jobs for loading history data intoWareHousetable.
  • Ensured Data Quality by validating the data and maintaining proper data structure
  • Used Environment Variables and Stage Variables for developing Parameter Driven Jobs and debugging them.
  • Enhanced the Job Performance by using proper Partitioning methods and analyzing the resources utilized using Job Monitor.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager) Enterprise Edition, Quality Stage 7.x/8.X, SQL Server, Query Analyzer, Enterprise Manager, PL/SQL, Oracle 9i/10g, AIX, Unix.

Confidential, NY Jan ‘03 - June ‘05
DataStage Developer

Responsibilities:

  • Gathered user requirements from Business Analysts.
  • Mapped the source and target databases by studying the specifications and analyzing the required transforms.
  • Created DataStage server jobs to load data from sequential files, flat files and MS Access.
  • Used DataStage to transform the data to multiple stages, and documented the details.
  • Analyzed the performance of the jobs and project and enhance the performance using the standard techniques.
  • Created job sequences and scheduled for automation.
  • Designed and Developed jobsusing Parallel Extenderfor splitting Bulk Data into subsets and to dynamically distribute to all available Nodes to achieve best job performance.
  • Used the Data stage Designer to develop jobs for extracting, cleaning the Data.
  • Transforming, integrating, and loading data into data warehouse database.
  • Used the Data Stage Director for scheduling, validating, running and monitoring the jobs.
  • Used Administrator for creating projects and managing the users.
  • Used almost all stages like Sequential file, hash file, odbc stage etc and also
  • Extensively involved in creating custom routines and transforms.
  • Created reusable transformations and jobs using Designer Tool set of DataStage.
  • Developed various stages such as merge stage, look up stage, funnel stage, filter stage, copy stage.
  • Extensively involved in Unit & system to verify expected results..
  • Used DataStage Director to schedule and monitor the jobs.
  • Used DataStage Administrator for setting the variables and parameters.
  • Prepared Data volume estimates and troubleshot using the debugging tool.

Environment:
Ascential DataStage 7.1/6.0 ( Designer, Director, Manager ) Windows NT 4.0, UNIX,Oracle 8i, PL/SQL, Sequential Files, MS Access,DB2,ERwin 4.0.

Confidential Sep ‘01 - Dec ‘02
Websphere Administrator

Responsibilities:

  • Installed, configured and maintained IBM WebSphere Application Server 5.x(Network Deployment) on diverse UNIX platformsand Windows 2003
  • Involved in migration of the applications from WAS 4.x to 5.x
  • Supported WebSphere Application Server clustering, load balance, failover/recovery and performance tuning
  • Involved with the customer care and deployment teams in trouble shooting and fixing day-to-day problems of the applications in production
  • Involved in configuring the WebSphere load balancing utilizing WebSphere Workload Management (WLM) includinghorizontal scalingandvertical scaling.
  • Configured horizontal scalability of WebSphere through a mechanism called as “Cloning of multiple JVMs” with independent Java Virtual Machines-JVMs, for each clone.
  • Involved in trouble shooting and Performance tuning using Tivoli Performance Viewer and log analyzer.
  • InstallingSSLcertificates, configuringSingle Sign On(thruTAImodule of Siteminder), configuring Siteminder WebAgent to implement Security, and enablingGlobal Securityfor the Application Server
  • Configured volume groups and logical volumes, extended logical volumes for file system growth need using Logical Volume Manager (LVM) commands
  • Proficient in working withWebSphere Log Analyzertool for trouble shooting and handling ofApplication/Web servererrors and logs

Environment:
Aix 5.2, Sun OS 5.6/2.7/8, Apache, WebSphere 4.0.x/5.0/5.1, IBM HTTP Server, Websphere Portal Server 5.0.2.6, BIG IP, Windows NT/2000, Tivoli, Oracle 8i, Java, EJB, Java Servlets, JSP 1.0

Education:

  • Bachelor of Engineering in Computer Science

Hire Now