Complaint / Review
Daryl Devdutt
Fake Resume

Phony application... Pity on him

Daryl Devdutt

Sr. IBM DataStage Guide

Summary:

 Eight Plus (7) Decades of expertise within the area of It with strong expertise in Application Evaluation, Style and Improvement, Internet Technologies, Customer/Host company methods, datawarehousing and software development

 Five-Plus (5) Decades of substantial expertise with Datawarehousing and Business Intelligence programs utilizing IBM Information Server 8.0.1, Ascential DataStage 7.5/7.1/6.0/5.2/XE (Supervisor, Supervisor, Custom, Representative, MetaStage, Similar Extender/Orchestrate, Quality Phase (Ethics), MetaRecon, XE/390), ETL, Trillium, First Reasoning, Information mart, OLAP and OLTP

 Five-Plus (5) Years of substantial Expertise in Data Modeling using Dimensional Data Modeling, Celebrity Join Schema Modeling, Snow-Flake Modeling, Reality and Measurements Platforms, Bodily and Reasonable Data Modeling and ERwin 4.5/4.0/3.5/3.0, Business Database Integration and Administration among Sybase, Oracle, Msaccess, Teradata, MS Sqlserver and DB2, Database Design (Bodily and Reasonable), Information Management and Preservation, Software Assistance, Performance Tuning, Marketing

 Five-Plus (5) Decades of substantial Business Intelligence Encounter in Operation Objects XI/6.5/6.0/5.1/4. X, BO Developer Collection (Boss, Custom, Internet Intelligence (Infoview), Broadcast Representative), Cognos Impromptu 7.0/6. X (Impromptu, power-play, Transformer, Impromptu Web Reviews (IWR), Upfront, PowerPlay Enterprise Server)

 Eight Plus (7) Decades of encounter utilizing Oracle 10g/9i/8i/8. X/7. X, DB2 9.1/8.0/7.0, Teradata V2R6/V2R5/V2R4/V2R3, MS Sqlserver 7.0/6.5, Sybase 12. X/11. X, Msaccess 7.0, SQL, VB 6.0/5.0, ASP, XML, PL/SQL, SQL*Plus, SQL*Loader and Creator Get 3. X/95/98/XP, Get NT 4.0 and Sun Solaris 2. X

Certifications:

• IBM Certified Solution Developer – WebSphere IIS DataStage Enterprise Version V7.5

Technical skills:

ETL Resources IBM Information Server 8.0.1, Ascential DataStage 7.5/7.0/6.0/5.2,

MetaRecon, Ethics, Data-Mining, OLAP, OLTP

Info Modeling

Resources Dimensional Info Modeling, Data Modeling, Celebrity Join Schema Modeling,

Snow-Flake Modeling, REALITY and Measurements Platforms, Conceptual,

Reasonable and Physical Data Modeling, ERwin 4.5/4.0/3.5.2/3. X

Information Cleaning First Reasoning, Trillium

Reporting Resources Information Reviews, Seagate Crystal Reports 6. X/5. X/4. X/3. X, Cognos, SQR 3. X,

Creator 2000 (Types 4.5/5.0, Reviews 2.5/3.0), Business Items

Msaccess Reviews

Sources Oracle 10g/9i/8i/8.0/7.3, UDB DB2, Sybase, Sqlserver 12.0/11.0,

MS SQL Server 6.5/7.0, Teradata V2R6/V2R5/V2R4, ISQL, TSQL,

Msaccess 7.0/97

Machines Oracle 9iAS, MTS, IIS, Apache, Tomcat, MS Site Host

Languages D/D, D#, VB Software, Java-Script, HTML, UML, SQL, T-SQL

And PL/SQL, SQL*Plus, SQL*Loader

Os's MVS OS, IBM 390/370, Windows NT 4.0/XP, Sun Solaris, Solar OS,

HP UX, SCO Unix, Get 95/98/3.1, MSDOS 6.22, Sun Sparc,

Horsepower-9000, IBM AIX 5.3

Professional experience:

American Express, Phoenix, Arizona Mar - Present

Sr. DataStage Developer

American Express is just a top worldwide funds community and travel organization. The aim of this task would be to create a Data Warehouse after which Information Marts that will assist the managements’ requirement for economic info and help with decision-making.

Responsibilities:

• Positively involved with all stages of the task that incorporated Necessity Evaluation, Customer Conversation, Style, Code, Screening and Assistance

• Positively enjoyed in group conferences and mapping periods to comprehend the company needs

• Employed CFF phase to see and create mainframe documents

• Thoroughly employed CFF phase to remove numerous report sort documents and divided the file-based on report form for further control.

• Used DB2 Business phase to weight information in to the DB2 platforms.

• Caused additional associates to create careers that may be utilized over the task and lead to minimal preservation

• Employed their state document within the Transformer phase to keep an eye on the surrogate keys.

• Created Parameter models that will decrease the period had a need to include task stage guidelines to numerous careers and work sequences

• Employed the Change Data-Capture phase to do delta running.

• Reduced the usage of transformer phases and used Alter phase where feasible while building careers to enhance efficiency

• Employed phase factors to keep an eye on information within the supply that arrived in a variety of models of amounts.

• Produced Restoration and Copy procedure to shop the Surrogate key-Organic key mix datasets in level documents and recover them if required.

• Applied before work subroutines to remove the header documents within the mainframe documents

• Created DataStage jobs utilizing different phases to Extract, Change and Weight data in to the DB2 platforms

• Created Multiple Occasion jobs in order to recycle exactly the same work numerous occasions within the work series

• Decreased the procedure run-time by performance focusing DataStage jobs, perfecting program assets and integrating parallelism

• Created DataStage jobs that may manage large quantities of information.

• Used DataStage Representative to check performance data of careers and uncover careers when needed. Additionally utilized Data Server Web System to uncover careers.

• Used DataStage Custom customer for posting supply and target table meanings, posting and transferring jobs and making new work groups

• Imported Mainframe Cobol copybooks using DataStage Designer Customer

• Employed DataStage Manager to create environment stage guidelines

• Moved careers from Improvement Host towards the QA Host

• Created Work Sequences to assist in robot and work handle

• Created device test instances and done device assessment of DataStage jobs and work sequences

Atmosphere: IBM Information Server 8.0.1 (WebSphere DataStage and QualityStage), IBM AIX 5.3, IBM DB2 9.1, TOAD for DB2, DB2 Control Centre, MQC check representative, Tumbleweed, Control M, Micro Technique 8, Windows XP, MS Visio

Ashland Inc., Dublin, OH March – January

Sr. DataStage Developer

Ashland Inc. Is just a BUNDLE 500, varied chemical organization providing you with innovative items, providers and methods to clients all over the world. It works within the Usa as well as in over 100 nations around the globe. The goal of this task was to organize information to weight like a area of the continuing procedure for obtaining almost all their purchases into drain.

Responsibilities:

• Positively involved with all stages of the task that incorporated Necessity Evaluation, Customer Conversation, Style, Code, Screening and Assistance

• Positively enjoyed in group and business conferences to comprehend the company needs

• Worked carefully using the associates and company associates to make sure that the task is operating according to routine

• Caused DataStage NLS options to be able to have the ability to study and create Oriental information in DataStage

• done Signal site configurations and NLS options to make sure that the Oriental information removed and packed into Oracle database is correct

• Altered DataStage jobs to extract and weight Oriental information into drain

• Parameterized NLS Configurations for that current careers to make sure that the configurations could be transformed at run-time, if required

• Created DataStage jobs utilizing different phases to Extract, Change and Weight information in to the Oracle database

• Employed the drain R/3 plug in for DataStage to extract information from drain

• Employed DataStage Representative to check performance data of careers and uncover careers when necessary

• Employed DataStage Director for posting supply and target database schemas, posting and exporting jobs and Making new work groups

• Employed DataStage Manager to create atmosphere stage guidelines

• Created Work Sequences to assist in robot and work handle

• Created device test instances and done device assessment of DataStage jobs and work sequences

• Supplied manufacturing assistance to make sure smooth-running of the course that was joined by folks from all around the globe

• done current DataStage jobs to enhance efficiency

• Decreased the run-time for many procedures by performance focusing DataStage jobs, perfecting program assets and integrating parallelism

• Accomplished more than 60% Decrease in run-time of particular DataStage jobs

Atmosphere: IBM WebSphere DataStage 7.5.1, Similar Stretcher, Quality Phase, IBM AIX 5.3, Oracle DTA, drain R/3, Oracle 9i, TOAD for Oracle, Visual SourceSafe, Windows XP, MS Visio.

The People Companies, Inc., Hartford, CT February – September

Sr. DataStage Developer

The Tourists Businesses may be the second-largest expert of Industrial Property, Injury and Individual Insurance within the Usa. The primary goal of the task was to build up a DM to aid the Local Presidents’ requirement for management data.

Responsibilities:

• Positively involved with all stages of the task that incorporated Necessity Evaluation, Customer Conversation, Style, Code, Screening, Assistance and Paperwork

• Positively enjoyed in group conferences and business conferences to comprehend the company needs

• Worked carefully using the Company Expert and also the information modeler throughout the improvement stage to obtain a distinct knowledge of the company guidelines and information mapping

• Created and Created DataStage jobs to Extract, Change and Weight information in to the Teradata database

• Created similar careers utilizing different phases like Transformer, Kind, Eliminate Copy, Channel, data-set, Look, Successive file, Teradata Business Phases

• Organized the Specialized Design Files and Style techniques for each one of the supply methods

• Employed phase factors for supply approval, to fully capture rejects and also to show the reason behind the report being declined

• Style and Improvement of UNIX Korn Shell Programs for incorporation with ETL Handles and also to automate information weight procedures towards the goal Information warehouse

• Employed DataStage Representative to check careers and watch records to debug careers

• Employed DataStage Director for posting supply and target database schemas, posting and transferring jobs and making new work Groups

• Employed DataStage Manager to create atmosphere stage guidelines

• Caused Teradata resources like Quick Weight, Multi-Load and created BTEQ programs

• Created device test instances and done device assessment of DataStage jobs, UNIX programs and BTEQ programs

• Thoroughly employed the MQC check representative to record all of the device test instances

• Helped in planning the Capability arrange for the task to make sure that the task doesn't encounter source problems

• Helped in doing trigger and impact evaluation for several crucial problems to assist solve them at The first to make sure that the task matches its deliverables

• Employed Genius to routine careers

• Helped in planning Genius agendas and paperwork

• Involved With Teradata V2R6 repository management (DBA) actions about the Improvement host.

• Thoroughly applied the MKS Type Handle device

• Active in The planning of the Implementation Manual that helps in making certain all of the necessary research is performed when shifting from the lower atmosphere to raised surroundings

• Enjoyed within the overview of Specialized Design Doc and Style Methods

• Organized the work doc to help the Manufacturing Assistance group, it has just about all probable instances of procedure disappointment and also the proper actions that require to become done to obtain the procedure back again to operating condition

• Done Knowledge Move towards the Manufacturing Support team

Setting: IBM WebSphere DataStage 7.5.1, Similar Stretcher, IBM AIX 5.3, Cognos 8.1/8.2, Teradata V2R6, MKS Integrity Customer, MQC check representative, Tivoli Maestro, Windows XP, MS Visio

Allstate, Illinois January – January

DataStage Developer

Allstate is among the biggest insurance providers in america. The main goal of the task would be to create Knowledge Warehouse program producing substantial utilization of Information marts. The aim would be to remove information saved in various sources and weight into Oracle program.

Responsibilities:

• Enjoyed in most stages including Necessity Evaluation, Customer Conversation, Style, Code, Screening, Assistance and Paperwork

• Gathering and recording needs, requirements analysis, transforming requirements into Higher Level Design Files

• Doing ETL group conferences and detailing the requirements to associates.

• Strolling through Work styles, Signal by associates, fixing if required

• Creating work themes to identify high level construction strategy

• Created the Information Mart design with ERwin utilizing Celebrity Schema strategy

• Create Reasonable and Actual information versions that catch present state/potential state information components and information moves utilizing Erwin

• Created and Personalized information versions for Information warehouse encouraging information from numerous resources on real-time

• Created and created DataStage jobs for Packing hosting information from various resources like PeopleSoft DB, and Sqlserver DB into Data Warehouse implementing company Guidelines which comprises information masses, data cleaning, and information rubbing

• Applied Gradually Changing Measurement Product Type II, for several platforms in DW

• Produced Large Amount Of Sequencer careers to contact through AutoSys for these SCD to operate so as

• Created and created plenty of DataStage jobs to weight into Measurement and Reality Platforms of various Information Marts from removing information from Data Warehouse platforms

• Thoroughly utilized Rocker phase to rocker and us rotate the origin information to attain necessary stand buildings like transforming information from posts into lines and lines into posts

• Thoroughly used all of the phases in DataStage like Rocker, Hashed Document, Directory, Pot, Aggregator and Transformer

• Created, created and used DataStage Careers and fine tuned them by applying guidelines like transforming applying Hash Tables for lookups and subsequent Calling Requirements, Parameterizing the factors from International Atmosphere to phase degree

• Employed Similar Stretcher to operate jobs on SMP programs

• Thoroughly used-to Aggregator phase to kind and team the supplier information and determined the quartile position for that qualified companies

• Used Quality phases built-in wizards for parsing and eliminating duplicate documents

• Designed MetaStage Listing using MetaStage Manager. Thoroughly employed the majority of the phases & changes of the DataStage for numerous kinds of Day Conversions

• Creating Layer programs to automate document adjustment and information packing methods

Atmosphere: IBM WebSphere (Previously Ascential) DataStage 7.5.1. A, DataStage plug in, Parallel Stretcher, Quality Phase, MetaStage, Erwin 4.5, Type Control, PL/SQL, Oracle 10g/9i, Sqlserver DB2, PeopleSoft 7.5, Business Objects 6.5, Windows XP, HP UNIX

HSBC-HOME, Dallas, Illinois Rate 2003 - Dec

DataStage Developer

Responsibilities:

• Necessity Evaluation, Customer Conversation and Person Interviews

• Thoroughly employed Erwin for Reasonable / Actual information modeling and Dimensional Data Modeling and created Star Schemas

• Produced the (IM) Business Relationship images & sustaining related paperwork for corporate information book with all characteristics, table names and restrictions.

• Created and created DataStage jobs for information masses and data cleaning

• Thoroughly utilized just about all the phases of DataStage (Hashed Document, World, Unidata, Transformer etc.)

• Created, created and used DataStage work and fine–tuned them

• Thoroughly employed Ascential DataStage Custom to do complicated mappings centered on person requirements

• Development of re usable archive utilizing the Ascential DataStage Manager.

• Thoroughly applied Ascential DataStage Manager and Cover scripting for arranging the task to operate, contacting manufacturing assistance for troubleshooting from record records

• Employed DataStage Director to transfer Metadata Table Description.

• Created jobs in Similar Extender using various phases like Transformer, Join, Aggregator, Research, Supply dataset, Exterior Filter, Strip Turbine, Line Turbine, FTP, Working, Increase, Channel, Remove Copies, and Combine

• Conducted one-to-one, one to a lot of, many to one and external join mappings

• Produced DataStage jobs, amounts and work sequences and updated subsequently for greater performance-optimized

• Created Interfaces using UNIX Shell Programs to automate the mass weight, update and Order procedures

• Style and improvement of UNIX Shell Programs

• done information conversions and information masses using PL/SQL and SQL*Loader

• Thoroughly done Ascential Quality Phase to wash up the information

• Employed Similar Traction for similar running of information removal and change

• Used MetaStage Listing to supply, share, saved and reconciled an extensive spectral range of meta-data

• Employed Transformer phase for changes and Aggregator for aggregations

• Employed Hashed document DataStage like a research table-based about the same key

• Employed ODBC phase to remove information from information resources

• Described source to focus on area careers with DataStage total source program profiling.

• Removed large quantities (terabytes) of information from legacy programs and submitted into oracle applying SQL*Loader and PL/SQL

• Thoroughly utilized Business Intelligence device Company Items for record creation.

• Created and created Oracle PL/SQL and Cover Programs, Knowledge Transfer/Move, Information Conversions and Information Cleaning

• Efficiency tuning of PL/SQL Programs

• Removed from and packed information into sources for example DB2, Sqlserver, Oracle, Mainframe level documents

Atmosphere: Ascential DataStage 6.0/5.2, Similar Stretcher, Quality Phase, MetaStage, Erwin 3.5.2, Business Objects 6.0, PL/SQL, COBOL, Oracle 9i/8i, DB2 UDB 7.0, Sqlserver Teradata V2R4, drain R/3, drain BUNCH, Windows XP, HP UX, AIX 4.3.3.

AT&T, San Ramon, California February - March

Info Specialist and ETL Expert

AT&T hasbeen for over 125 years, been recognized for unparalleled quality and stability in communications. Supported from the study & created abilities of AT&T laboratories, the organization is just a worldwide head in nearby, long-distance, Web and deal-centered speech and information providers.

Responsibilities:

• Examined the project repository needs in the person

• Reached the querying requirements and using the inquiries using the aggregations

• Described aggregations needed and granularity accessible and needed in DW

• Described the partitioning of the information

• Gathered the info about various organizations and features

• Analyzed the present ODS by reverse-engineering into Erwin

• Normalized the organizations and demoralized for DW reasons

• Described the PKs and FKs for that organizations

• Described the associations and cardinalities between various organizations

• Produced very form and sub type organizations and Class organizations

• Described the areas for that characteristics and Approval guidelines

• Produced reasonable schema using Erwin 4. X as well as produced the Measurement Modeling for creating the Cubes

• Created DataStage ETL jobs for removing information from heterogeneous supply systems, change and lastly weight in to the Information Marts

• Determine supply systems, their connection, associated platforms and areas and guarantee information superbly for mapping

• Produced Surrogate IDs for that measurements within the reality stand for listed and quicker entry of information

• Produced surrogate key platforms to chart The necessary measurements

• Produced hash tables employed for referential integrity and/or else while changing the information addressing legitimate info

• Allowed Correct choice of the hash table style guidelines for quicker desk look up

• Produced re usable elements utilizing shared pots for regional use or shared use

• Imported and exported databases across tasks

• Employed Aggregator phases to sum the crucial performance indicators utilized in decision-support methods

• Updated DataStage changes and careers to improve their efficiency

• Published PL/SQL record and stored processes in Oracle for removing and creating information

• Used DataStage Representative to routine operating the clear answer, screening and debugging its elements, and checking the resulting executable variations on a or planned base

• Produced work agendas to automate the ETL procedure

• Organized the paperwork of Data-Acquisition and Software System Design

Atmosphere: Ascential DataStage 5.2/3.7 (Custom, Representative, Supervisor), MetaStage, ERwin 4.0, Windows NT 4.0, UNIX, Oracle 7, PL/SQL, DOS and UNIX Consecutive Documents, Msaccess, XML Documents

Datacon’s Pvt. Ltd, Bangalore, Asia May - December

Developer

The machine problems digital enrollment of client balances and watch the balances online and distributing emails for clarifications. It offers online info of the clients account details. Strategic Decision Support-System supplying total Transactional Info of kinds of balances of the Limbs Nationwide. Retains a the consideration associated info

Responsibilities:

• Involved With creating the repository design

• Created and created types for that interface utilizing Oracle Types

• Published PL/SQL Programs to produce change and fall database items enjoys platforms, sights, sequences, methods and capabilities. Published stored procedures and capabilities to get the information in the repository utilizing PL/SQL

• Various database causes Oracle 7.0 with SQL*Plus, PL/SQL in each UNIX and WINDOWS environment

• Sparks were produced and saved within the repository and dismissed down when items of repository were transformed

• Involved With performance tuning of the applying

• Created and created matrix reviews utilizing Oracle Reviews for that evaluation of the information

Atmosphere: Oracle 7.0, UNIX and Windows