PROFESIONAL SUMMARY:

• Over 7 years of total experience in IT and 5 years of professional experience in Extraction, Transformation and Loading (ETL) experience using DataStage 8.1/7.5 Parallel Extender.
• Over 2 years working in Database, Networking and Server Admnistrations.
• Expert Level experience in DataStage Client components - DataStage Designer, DataStage Manager, DataStage Director and DataStage Administrator
• Extensively worked on Server Edition, Enterprise Edition (Parallel Extender) and Development of Data Warehouse/Data Mart Applications.
• Extensively made use of all stages Aggregator, Sort, Merge, Join, Change Capture, Peek stages in Parallel Extender job.
• Used Data Stage Manager to import/export Data Stage projects and jobs to define table definition in repository.
• Used Data Stage Director to debug, validate, schedule, run and monitor Data Stage Jobs
• Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts.
• Expertise in writing UNIX shell scripts and hands on experience with scheduling of shell scripts using AUTOSYS. Knowledge in UNIX shell and have written shell scripts for automation of Job Flow, Scheduling Jobs.
• Optimized DataStage job utilization Parallelism, Partitioning and Pipelining features of Parallel Extender.
• Advance Knowledge, excellent concepts and experienced in decision support system (DSS), querying and analysis, Extraction Transformation Loading (ETL) Data Stage and Data Warehousing.
• Worked with DB-admin to create appropriate Indexes on tables for better performance of Data Stage queries.
• Strong Knowledge of Data Warehouse architecture in Designing Star Schema, Snow Flake Schema, FACT and Dimensional Tables. Physical and Logical modeling using Erwin.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data to various sources into data warehouse and Data Marts using Data Stage.
• Expertise in Data Migration and Upgrading.
• Expertise in using ERWIN for data modeling.
• Involved in Performance Fine Tuning of ETL programs. Tuned DataStage and Stored Procedures Code.
• Excellent experience in Relational Database (RDBMS), Oracle 11g,10g,9i, Microsoft SQL Server, Teradata Load and MultiLoad, SQL, PL/SQL, TOAD
• Involved in Logical and Physical Design, Backup, Restore, Data Integration and Data Transformation Service and Creating Database Objects (Tables, Index, Triggers, Views, Store Procedures).
• Experience as Database Administrator:
• Data modeling, database optimization, understanding and implementation of schemas, and programming Structured Query Language.
• Proactively monitor systems for optimum performance and capacity constraints.
• Establish standards and best practices for SQL.
• Interact with and coach developers in SQL scripting.
• Experience as Developer and Implementing Netwoks.
• Programming for Albtek clients, web and desktop applications.
• Designing and implementing Networks for Albtek clients.
• Designing and implementing, SQL databases for further applications.

TECHNICAL SKILLS:

ETL: IBM Ascential DataStage 8.x/7.5x2/7.x EE & SE Adminstrator, Designer, Director, Manager, Parallel Extender, IBM WebSphere Information Server 8.0.1, IBM InfoSphere Information Server 8.1

Data Modeling: Dimensional, Logical & Physical Data Modeling, Star Schema, Snow - Flake Schema, ERwin 3.x

RDBMS: Oracle 11g/10g/9i, DB2 9.x/7.x, SQL Server 2008/2005/2000

Programming: SQL, PL/SQL, Shell Scripting,VB Script,Java

Reporting: Crystal Reports,IReport

Operating System: Unix, Linux, Windows NT/XP/2000/2003 Server, Solaris

Scheduling Tools: Autosys, Crontab Utility

PROFESSIONAL EXPERIENCE:

Confidential, PA

DataStage Developer

Responsibilities:

• Participating on Business Analysis Development Phase and Gathering Requirements. Working with Developer Department team for translating business requirements into Data Mart Design.
• Working with Database team for creating logical and physical Data Modeling process using Erwin and guide business group and users session.
• Taking part in planning and management of all Data Warehouse migration process.
• Involved in creating strategy for Star Schemas with Fact and Dimension Tables.
• Translating Business requirements into Data Mart design coordinating with team members Creating Fact, Dimensional and Aggregate Tables and Loading Data Warehouse tables.
• Responsible for getting the Data Dictionary, Designing and modifying the Data Stage jobs using Data Stage Designer, Created mappings based on Data Dictionary.
• Worked on Data migration from SQL Server 2005 and was responsible developing Data Stage Jobs, creating mapping for data transformation, extracting data from Oracle and Loading it into the Dimensional tables.
• Creating backups by using Data Stage Manager Exporting data stage components and packaging of projects.
• Implemented the Surrogate Key by using Key Management functionality for newly inserted rows in Data Warehouse
• Developed Shell Scripts for taking backup and recovery of database. Performed physical and logical backup.
• Used Autosys to schedule the Datastage ETL batch jobs on daily, weekly and monthly basis.
• Used DataStage manager to import, create and edit the metadata.
• Used the DataStage Administrator to assign privileges to users or users groups, move, rename or delete projects and manager or publish jobs from development to production status.
• Validated all applications and ran the jobs using DataStage Director.
• Performed tuning of the repository and jobs for optimum performance.
• Prepared Test Plan and performed Unit Testing, System, Integration, Volume Testing.
• Extensively involved in writing Stored Procedures and calling the same through Data Stage Stored Procedure Transformation.
• Developed Server side functionality by using PL/SQL and UNIX shell programming.
• Constructed SQL Scripts to validate the data after loading process.
• Data Quality and validation using Quality Stage, Metadata capture and analysis using MetaStage.

Environment: DataStage EE 7.5/8.1ERwin 4.1.5,SQLServer 2005,Oracle10g/9iPL/SQL,AutoSys, TOAD, UNIX, Shell scripting

Confidential, Kansas

DataStage Developer

Responsibilities:

• Involved in status meetings, and interacted with the Business Analyst to get the business rules.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• AnalysisandDesignreview of the existing and new system.
• Mappingandmigratinglegacy system data tonew n-tier system.
• Design and development Confidential source system data and finally make the data available to satisfy the reporting and analytical requirements of the long distance entry effort.
• DesignedODSto quick operations on individual data.
• Loaded data intoLoad, StagingandLookup tables.
• Performancetuned DataStageto reduce batch run time.
• Extensively used Built-in (Sort, Merge, Oracle, Aggregator, DB2 Stages), Plug-in Stages for extraction, transformation and loading of the data.
• Designed the DataStage jobs toExtract the data from Text files, Transformthe data according to the business requirements and load them intoOracle tables.
• As per the data volume, presented the size requirements and partitioning requirements for ODS tables in Oracle.
• Designed Parallel jobs using various stages like Join, Merge, Remove Duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator and Funnel stages
• Wrote Oracle stored procedures and called theStored Proceduresin Data Stage.
• Create and enhance the existing process of thePL/SQL Proceduresand Packages.
• Extensively worked withDimensional Data Modeling, Star and Snowflake Schema.
• ImplementedSlowly Changing Dimensions and Surrogate keysfor designing theData MartsClosely worked with the System analyst and application development teams Implemented Best Practices of DataStage.

Environment: DataStage 7.5, Oracle and MS SQL Server 2005, UNIX and shell scripts, Erwin, SQL Loader.

Confidential, OH

DataStage Developer

Responsibilities:

• Environment IMB Infosphere DataStage software extracting data from DB2, Oracle and Flat File and Load to target tables.
• Participated in Business Analysis and technical design meeting with business and technical staff to develop Entity Relationship / Data Models, requirements document, and ETL specifications.
• Creating and maintaining DataStage Parallel Jobs for every policy holders from Confidential .
• Extracted data from text files, using FTP Stage and loaded into different databases.
• Developed Parallel Jobs using various Development / Debug Stages (Peek Stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample stage) and Processing Stages (Aggregator, Change Capture, Change Apply, Filter, Sort and Merge, Funnel Remove Duplicate Stage).
• Designed Parallel jobs using various stages like Join, Merge, Remove Dublicates, Filter, Lookup, Modify, Aggregator and Funnel stages.
• Using DataStage Software Development Kit, Functions like DSJobInfo, ICOV and OCONV, Transformers like Data Transform.
• Developed Test Cases and Performed Unit Testing, System, Integration Testing, UAT Testing.
• Used Email Notification, Nested Condition, Sequencer and Terminator activities in Job Sequences.
• Developed Customized Routines and Functions for better job performance.
• Updated the current Design Specifications based on the changes that occurred during development process and was involved in writing new design specifications.
• Used AUTOSYS to Schedule the DataStage ETL batch jobs on a daily, weekly and monthly basis.
• Designed the DataStage Integrity check jobs which check each Dimension ID and Fact table that has a corresponding ID in a Dimension table.
• Involved in developing and rewriting Investigation, Matching, Survivors rules and Standartization using Quality Stage.
• Used the DataStage Administrator to assign privileges to users or user group, move rename or delete projects and manage or publish jobs from development to production status.
• Used Management Studio to query the SQL Server database.
• Used DataStage Director for Executing, Monitoring, Analyzing logs and Scheduling the jobs.

Environment: IBM InfoSphere Information Server v8.1 Suite (DataStage and QualityStage, Information Analyzer and Metadata Server), DB2UDB9.1, Oracle 10g,SQL,PL/SQL,UNIX,IBM-AIX, Erwin 4.5, MS Visio and Autosys.

Confidential, Calabasas, CA

Datastage Developer

Responsibilities:

• Creating Different Jobs to extract data from CRM and ELM systems using ODBC,OCI and DRS connections.
• Created Data mapping using Ascential Datastage as ETL tool.
• Writing PL/SQL queries to join tables and create Data Mart Dimension and Fact tables
• Data Cleansing using DataStage Transforms and using Basic functions
• Using DataStage Designer for Extracting, Transforming, Integrating and Loading Data into the staging area.
• Designed Parallel jobs using various stages like Join, Merge, Remove Duplicates, Filter, Dataset, Lookup, Modify, Aggregator and Funnel stages.
• Flattening data from Sequential files using Pivot stage and loading into Oracle tables.
• Use of CRC logic to concatenate and compare strings of data input.
• Developing Sequencers with regards to interdependencies and embedding exception handlers for aborts and notification activities.
• Designed Parallel jobs using various stages like Join, Merge, Remove Duplicates, Filter, Dataset, Lookup, Modify, Aggregator and Funnel stages.
• Using the Parallel Change capture and Change apply stages for doing comparison.
• Using Hashed File Lookups wherever possible to increase performance job.
• Designing stage variables to calculate begin date and end date for Type2 Dimensions.
• Developed the customized Routines and Functions for better job performance.
• Developing Jobs to capture errors and load Audit tables.
• Using DataStage macros for providing runtime parameters and using system variables along with stage variables for surrogate key population

Environment: Ascential Datastage, Unix, Business Objects, Oracle 9i

Confidential, San Francisco

DataStage Developer

Responsibilities:

• Changed the earlier server jobs to PX by converting hashed file lookups to lookup file set etc.,
• Developed Parallel Shared Containers for the jobs for reusability.
• Created customPX stageby combining the functionality of several PX stages.
• Improved the job performance with respect to compile time and Real Time Integration (RTI) by more than 40% over the baseline PX job.
• Performance tuning by decreasing the number of stages and thereby decreasing the number of Processes.
• Node configurations. File was used in the project and stages were minimized to reduce number of processes.
• Evaluated, redesigned and modified existing program logic to improve overall system performance.
• Created shell script for FTP file from one location to another and Trigger the Data Stage Jobs.
• Manipulated the files, by removing Head stage and Tail stage from the input file.
• Used the sequencer to sequence various steps within the jobs.
• Tuned Sql Queries to improve the performance.
• Performed testing and debugging of PX jobs, strings and shared containers consisting of more than 800 stages.

Environment: DataStage EE 7.5.x, Parallel Extender, UNIX AIX 5.2, SQL,PL/SQL, DB2 UDBUNIX Shell Scripting.

Confidential

DB Administrator/Programmer

Responsibilities:

• Installation of new versions of DBMS software, application software, and other software related to DBMS administration and test this new software before it is moved into a production environment.
• Take care of databases system replication, backup scheme and disaster recovery
• Configuration of hardware and software so that it functions optimally with the DBMS.
• DBA Security administration— Monitoring and administering DBMS security. This involves adding and removing users, administering quotas, auditing, and checking for security problems.
• Data analysis— frequently analyzes the data stored in the database and to make recommendations relating to performance and efficiency of that data storage.
• Data modeling and optimization— optimize the system layouts to take the most advantage of the I/O subsystem.
• Responsible for the administration of existing databases (ORACLE & SQL) and the analysis, design, and creation of new databases.
• Data modeling, database optimization, understanding and implementation of schemas, and programming Structured Query Language.
• Establish standards and best practices for SQL.
• Interact with and coach developers in SQL scripting.
• Programming or editing current application with the programming team for the scope of implementing or upgrading application for the Confidential
• Taking care of internal webpage and services included within.
• Consulting and taking decisions for contracts regarding with providers for services, acquaintance of licenses and other technological equipments.

Confidential

Network maintenance/Web Design/Security

Responsibilities:

• Programming for Albtek clients, web and desktop applications.
• Designing and implementing Networks for Albtek clients.
• Designing and implementing, SQL databases for further applications.
• Building the company website and maintaining it for further.