SUMMARY

• IT: 9 years of experience in the field of Information Technology with solid experience in Software Analysis, Design and Development of Data warehousing applications.
• Datastage: 7 years of extensive experience using IBM Ascential Datastage EE/XE// 8.0.1/7.5/7.1/6.0/5.2 (Administrator, Manager, Designer, Director, Metastage, Parallel Extender/Orchestrate, MetaRecon, XE/390), Quality stage, ETL, Informatica, Trillium, First Logic, Datamart, OLAP and OLTP.
• Data Modeling: 5 years of extensive experience in Data Modeling using Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling and ERwin 4.5/4.0/3.5/3.0 ,
• Business Intelligence: 3 years of extensive Business Intelligence Experience in Business Objects XI/ 6.5/6.0/5.1/4. x, BO Developer Suite (Supervisor, Designer, Web Intelligence (Infoview), Broadcast Agent), Cognos Series 7.0
• Data Cleansing: 4 years of Data Cleansing experience using Ascential Qualitystage/Integrity, Trillium 7.6/6.5 (Converter, Parser, Matcher & Geocoder), Firstlogic 4.2/3.6, UNIX Shell Scripting and SQL coding.
• Databases: 7 years of experience using Oracle 10g/9i/8i/8.x/7.x, UDB/DB2 8.0/7.0, Teradata V2R5/V2R4/V2R3V2R5, MS SQL Server 2000/7.0/6.5 , Ms Access 2000, SQL, FTP, VB 6.0/5.0, ASP, XML, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.

TECHNICAL SKILLS

ETL: AscentialDataStageXE// 8.0.1/7.5/7.0/6.0/5.2/5.1/4.2/3.6 (Administrator, Manager, Designer, Director, XE/390, Metastage, Parallel Extender/Orchestrate,Quality stage, MetaRecon), ETL, OLAP, OLTP, Quality Manager Cognos, Business Objects 5.1, Metadata, Data Mining, DataStage, Datamart, OLAP, OLTP, SQL*Plus, SQL*Loader, Informatica PowerMart 6.2/6.1/5.1.1/5. x/4.7/3.8, Informatica PowerCenter 5.1.1/1.6/1.5 , Informatica Power Analyzer.

Reporting Tools: Business Objects XI/ 6.5/6.0/5.1/4. x, BO Developer Suite (Supervisor, Designer, Web Intelligence (Infoview), Data Reports, Seagate Crystal Reports 6.x/5.x/4.x/3.x, Cognos, SQR 3.x, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), Business Objects MS Access Reports

Data Modeling Tools: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling and ERwin 4.5/4.0/3.5/3.0

Databases: Oracle10g/9i/8i/8.x/7.x,UDB/DB2 8.0/7.0, Teradata V2R5/V2R4/V2R3, MSSQLServer 2000/7.0/6.5 , MS Access 2000, SQL*Plus, SQL*Loader, TOAD 7.0, and Developer 2000

Programming/Others: UNIX Shell Scripting, SQL, PL/SQL, SQL*Plus 3.3/8.0, C, C++, Java, JavaScript, SQL*Loader, Service Oriented Architecture (SOA), VB, ASP, COBOL, HTML, XML, PL/SQL

Environment: MVS OS, Sun Solaris 2.7/2.6, HP-UX 10.2/9.0, IBM AIX 4.3/4.2, Linux, MS DOS 6.22, Win 3.x/95/98/XP, FTP,Win NT 4.0, Sun Sparc, Sun Ultra, HP9000, IBM RS6000

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr.Datastage Consultant

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Developed DataStage ETL jobs for extracting data from multiple sources.
• Analyzed the given source Dimensions and target Fact table structures to develop Surrogate Key table referencing required dimensions.
• Developed various jobs using ODBC, Hashed file, Aggregator, Sequential file, Transformer stages, Change Capture.
• Developed Parallel jobs using Stages, which includes Join, Transformer, Sort, Merge, Filter and Lookup.
• Used Shared Containers and created reusable components for local and shared use in the ETL process.
• Imported and exported Repositories across DataStage projects.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Used DataStage Director Runtime engine to schedule and execute developed jobs sequences, and use Log events to monitor job progress and performance.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment: Ascential DataStage Server 8.0.1 (Manager, Director), Parallel Extender, Oracle 8/9i, MSSQL Server 2000, UNIX, Windows NT, DB2.

Confidential, DELAWARE

Sr.Datastage Consultant

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, Support and Documentation.
• Extensively used SQL and PL/SQL coding in Datastage jobs for processing data
• Developed batches and sequencers in designer to run and control set of jobs
• Used the Datastage Director and its run-time engine to schedule running the job, testing and debugging its components, and monitoring the resulting executable versions
• Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements
• UsedParallelExtenderfordistributingloadamongdifferentprocessorsbyImplementingpipelineandPartitioningofdatainparallelextender.
• Used QualityStage to access the Metadata Server to obtain live access to current metadata for enterprise data. used QualityStage to access Data generated by WebSphere Information Analyzer
• Used Partition methods and collecting methods for implementing parallel processing.
• Used Datastage Manager for importing metadata from repository, new job categoriesand creating new data elements.
• Used Datastage Director to schedule running the solution, testing and debuggingitscomponents and monitoring the resultingexecutable versions both on adhocandscheduledbasis.
• Workedonprograms for scheduling Data loading and transformations usingDataStage from UDB/DB2 to Oracle 10g using PL/SQL.
• Used DS Administrator to Configure, Create and Maintain Datastage jobs.
• Wrote Unix Shell Scripts to automate the process.

Environment: IBMWebsphere(FormerlyAscential)XE/8.0/7.5.1,DatastagePlugin,ParallelExtender,MetaStage,QualityStage,Erwin4.5,VersionControl,PL/SQL,Oracle10g,SQL,FTP,SQLServer6.5,UDB/DB2,Win NT/XP, UNIX

Confidential, PA

SeniorDatastageDeveloper

Responsibilities:

• Involved in understanding the scope of application, present schema, data model and defining relationship within and between groups of data
• Participated in analyzing user requirements, identifying data needed to deliver requirements, and developing data models using data warehousing concepts.
• Involved in logical and physical data modeling using ERwin 4.5
• Involved in upgrading from DataStage 6.0 to DataStage 7.0
• Implementing a Services Oriented Architecture and have worked with several customers on solutions for their integration needs
• Develop integration solutions based on Service Oriented Architecture
• Designing and implementing service-oriented architectures (SOA) suitable for secure, reliable, and high-performance deployment
• Designed service-oriented architecture (SOA) optimizing inter-component messaging and interaction
• Developed data marts based on business requirements and developed ETL logic to process the data using DataStage 7.0
• Used DataStage Manager for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Participated in design and development of Star and Snow-flake schema database and mappings between sources and operational staging targets by identifying suitable Fact and Dimensional tables for the schema
• Used Datastage Parallel Extender for splitting the data into subsets and to load data, utilized the available processors to achieve job performance.
• Responsible for analysis of architectural designing of mappings .
• Extracted data from various sources like ORACLE,DB2 Transformed according to the requirement and Loaded into data warehouse schema using various stages like sequential file, Aggregator, Transformer stage
• Participated in all phases including Requirement Analysis, Design, Coding, Testing, Support and Documentation.
• Designed and developed Data Stage server jobs for extracting the Data from different sources like Operational Date Store and Flat Files to handle data and loading data into the Data Warehouse applying business rules and standard validations.
• Designed DataStage jobs for the different projects such as GCSS (Global Customer Service System), RKDS (Rederiet Container Documentation System), PDIS (Per Diem Invoicing System), and CVT (Container Visibility Tool).
• Implemented the Standard Procedure for all the projects known as “Change Data Capture” which extracts the updated data from the source systems.
• Designed Job Sequencers for every project to run in a loop based on the success or failure of individual jobs in the Sequencer.
• Extensively used SQL and PL/SQL coding in Datastage jobs for processing data
• Developed batches and sequencers in designer to run and control set of jobs
• Used the Datastage Director and its run-time engine to schedule running the job, testing and debugging its components, and monitoring the resulting executable versions
• Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements
• Performed the Unit testing for jobs developed to ensure that it meets the requirements
• Generated Surrogate Keys for composite attributes while loading the data into Data Warehouse
• Used INTEGRITY tool for cleansing and integrating the data before it is loaded into the staging area
• Analysis and Profiling of the source data is done using MetaRecon
• Developed UNIX shell scripts to automate file manipulation and data loading procedures
• Installed and configured Datastage client components
• Created and maintain several custom reports for various business analysis purposes using Business Objects

Environment: IBM Ascential Datastage XE/7.5.1 (Designer, Manager, Administrator, Director, MetaStage, MetaRecon, Quality Stage, Profile Stage), Microstrategy7i, SQL, PL/SQL, Service Oriented Architecture (SOA), Business Objects 6.5 (Supervisor, Designer, BO reporter, BCA), ERwin 4.1, Oracle 10g, DB2, UDB, Sybase, Teradata V2R5, TOAD 7.3, Win 2000, IBM AIX 4.3

Confidential, Louisiana

Sr. Datastage Developer

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, Support and Documentation.
• Gathering and documenting requirements, requirements analysis, converting requirements into High Level Design Documents.
• Conducting ETL team meetings and explaining the requirements to team members.
• Walking through Job designs, Code by team members, correcting if necessary.
• Designing job templates to specify high level frame work approach.
• Design the Data Mart model with ERwin using Star Schema methodology.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Designed and Customized data models for Data warehouse supporting data from multiple sources on real time.
• Designed and developed Data Stage jobs for Loading Staging Data from different sources like SQL Server DB into Data Warehouse applying business rules which consists data loads, data cleansing, and data massaging.
• Implemented Slowly Changing Dimension Model Type II, for all tables in DW.
• Generated Lot of Sequencer jobs to call through Autosys for these SCD to run in order.
• Designed and developed lots of Data Stage jobs to load into Dimension and Fact Tables of different Data Marts from extracting data from Data Warehouse tables.
• Extensively used Pivot stage to pivot and un pivot the source data to achieve required table structures like converting data from columns into rows and rows into columns.
• Extensively used all the stages of Data Stage like Pivot, Hashed File, Folder, Container, Aggregator, Transformer etc.
• Designed, developed and deployed Data Stage Jobs and fine-tuned them by implementing best practices like converting using Hash Tables for look-ups and following Naming Standards, Parameterizing the variables from Global Environment to stage level.
• Used Parallel Extender for parallel processing of data extraction and transformation.
• Used Parallel Extender to run jobs on SMP systems.
• Extensively worked in Ascential Quality Stage to clean up the address information within the client data.
• Used Sequential file stage to extract the data from text files.
• Used Transformer stage for transformations and Aggregator for Aggregations.
• Extensively used to Aggregator stage to sort and group the provider data and calculated the quartile ranking for the eligible providers.
• Used Quality stages built in wizards for parsing and removing duplicate records.
• Unduped the address records using Ascential Quality Stage
• Configured Metastage Directory using Metastage Administrator. Extensively used almost all of the stages & transforms of the DataStage for various types of Date Conversions.
• Developing Shell scripts to automate file manipulation and data loading procedures.
• Used Business Objects to generate Business reports.

Environment: IBM Websphere (Formerly Ascential) DataStage 7.0, DataStage Plug-in, Parallel Extender, Quality Stage, Metastage, MetaRecon, Erwin 4.5, Version Control, PL/SQL, Oracle 9i, SQL Server 2005/2000, DB2 8.0, PeopleSoft 7.5, Business Objects 6.5, Windows XP/2000, HP UNIX.

Confidential, NJ

Data Stage Developer

Responsibilities:

• Requirements Analysis and Gathering and identifying different source systems.
• Involved in Design phase meetings and conference meetings with Ascential Datastage Support team.
• Used MetaBroker tool to Exchange data between data stage and other data warehousing tools.
• Designed the high-Level design documents for legacy interfaces.
• Server Sizing estimations & Development work estimations.
• Extensively worked with Datastage - Manager, Designer, Director and Administrator to load data from flat files, legacy data, SQL Server to target Oracle database
• Used Datastage for subjecting the data to multiple stages, thereby transforming it and prepared documentation.
• Responsible for the Dimensional Data Modeling and populating the business rules
• Developed PL/SQL Scripts and Stored Procedures.
• Converted Datastage jobs from version 5.1 to 6.0. Re-compiled, made minor changes and ported the jobs from development environment to production environment.
• Created Datastage jobs, batches, job sequences and tuned them for better performance
• Performed data loading with multiple and parallel ETL processes.
• Involved in Logical and Physical data modeling using ERwin tool and Sapphire tool.
• Extraction, Transformation & Loading of the contract accounts data from legacy flat files.
• Used Built-in, Plug-in and Custom Stages for extraction, transformation and loading of the data, provided derivations (Macros, Routines & Functions) over DS Links
• Used Integrity, Parallel Extender for cleansing the data and performance improvement.
• Involved in Gap analysis between the legacy and SAP, analyzed the business entities for the warehouse.
• Organized user meetings for the presentation/approval of the data model
• Designed/developed the ODS architecture for Shipment, Sales orders, delivery, billing, AP, AR and Consolidated ODS.
• Designed ODS for Product cost controlling, profitability analysis and overhead cost controlling.
• Developed and scheduled ABAP reports for extracting BW hierarchies for different info Objects based on the legacy data model.
• Designed/developed Info-cubes for Finance such as cost center expenses, cost center variances, profit center revenue & expense, functional area general ledger and profitability detail cube etc

Environment: Ascential Datastage 6.5/6.0 (Datastage Manager, Datastage Administrator, Datastage Designer, Datastage Director, Parallel Extender, Integrity and MetaRecon), Transforms, Jobs, Metadata, Datamart, Data Mining, ETI, ETL, SAP R/3 4.6c, BW 3.0B/2.1C, ABAP/4, Oracle 8i/8.0,DB2, UDB, ERwin, SAP R/3 (SAP CRM, SAP BW), Unix Shell Scripting, MS SQL Server 2000, Sun Solaris, AIX 5.2

Confidential

Programmer

Responsibilities:

• Involved in designing the database model
• Designed and developed forms for the user interface using Oracle Forms
• Wrote PL/SQL Scripts to create alter and drop database objects likes tables, views, sequences, procedures and functions. Wrote stored procedures and functions to retrieve the data from the database using PL/SQL
• Different database triggers Oracle 7.0 with SQL*Plus, PL/SQL in both UNIX and WINDOWS environment
• Triggers were created and stored in the database and fired off when contents of database were changed
• Involved in performance tuning of the application
• Designed and developed matrix reports using Oracle Reports for the analysis of the data