Raji Raman

RAJI RAMAN

SUMMARY

• •

• • • • •

Over 5 years of IT experience in implementation and development of data integration, client/server and Oracle development applications 4 years of Extraction, Transformation and Loading (ETL) experience using Ascential DataStage 7.5/7.0/6.x/5.x (Administrator, Director, Manager, Designer), Parallel Extender, Metastage, Profile Stage (MetaRecon) and Quality Stage (Integrity) and development of Data Warehouse/Data mart Applications Expertise in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data Modeling using Erwin and Oracle Warehouse Builder to implement Business Intelligent systems. Extensive Experience in Microsoft SQL Server 2000/7.0/6.5, NCR TeraData, Oracle 9i/8i, SQL, PL/SQL, SQL* Loader, Windows NT 4.0 Good understanding of Cognos, Microstrategy and Business Objects OLAP tools Extensive experience in client-server and internet application development using Oracle, MS SQL server, PL/SQL, stored procedures, Functions, Triggers, ODBC and Visual Basic Excellent analytical, interpersonal and communication skills and ability to work as an individual as well as a team player

TECHNICAL SKILLS

ETL Tools Data Warehousing Database Data Modeling Reporting Tools Programming Languages Operating System Web Development Servers Other Tools

Ascential Data Stage 7.5/7.0/6.x/5.x (Administrator, Manager, Designer, Director), MetaStage, Parallel Extender, Profile Stage (MetaRecon), Quality Stage (Integrity) Datamarts, OLTP, OLAP, Normalization, Dimensional Modeling, Facts, Dimensions, Star schema, Snow Flake schema, Slowly changing dimensions, Oracle Warehouse Builder 9i Oracle 9i/8i/8.x, MS SQL Server 2000/7.0/6.5, DB2 UDB, MS Access 7.0, NCR TeraData V2R3, ODBC, PeopleSoft CRM 8.4/8.9 Erwin 4.1/3.5, ER/Studio 3.5, Microsoft Visio 2000 Cognos, Microstrategy 7.2/7.1, Business Objects 5.0/5.1, Brio SQL, Transact SQL, PL/SQL, Unix Shell scripting, C, C++, Java, Visual Basic 5.0 Windows XP/2000/NT/98, Unix, Linux J2EE, Applets, Servlets, EJB, XML, HTML 4.0, ASP Apache, Weblogic, Microsoft IIS 6.0, Oracle 9iAS SQL* Plus, SQL Loader, SQL Navigator 4.1, PL/SQL Developer, TOAD, MS Visual Studio

PROFESSIONAL EXPERIENCE ProQuest, Richfield, OH Datastage/Microstrategy Developer

Jan ’06 – Till Date

Environment: Ascential DataStage 7.5 (Designer, Manager, Director, Administrator), Parallel Extender/Enterprise Edition (EE), MicroStrategy Desktop 7.2.4 (clustered), Narrowcast 7.2.1, Web 7.2.4 & 7.2.3, Oracle 9i, SQL, PL/SQL, Oracle 9i/8i, HP-Unix, TOAD, MS Excel, Windows XP, Erwin 4.2, StarTeam, SQL Loader ProQuest Business Solutions is the global leader in the development and deployment of parts and services information products and dealer performance applications for the automotive market. The focus of the current publishing process is to offer an easy to use electronic parts catalog to the dealers for approximately 32 automobile brands manufactured by General Motors, Ford Motor Company, Honda/Acura, Toyota/Lexus, Hyundai, Kia, Nissan, Saturn and Volvo, among others. Responsibilities: • •

• • •

• • •

•

•

• • • • • • • • •

Created source-target mapping spreadsheet using MS Excel to facilitate better understanding of the mapping and transformations Worked on source data analysis to figure the mapping between various legacy source data Exported the source-target mapping to various Oracle tables using PL/SQL scripts Developed the physical and logical data modeling using Erwin4.2 Imported metadata using Datastage Manager Extensively worked with DataStage Designer for developing various server jobs using Sequential file, Hashed file, ODBC, Oracle OCI and Transformer stages Implemented local containers for the same job and shared containers for multiple jobs that have the same business logic Created various routines and transforms to handle complex data Extensively used processing stages like the Lookup stage to perform lookup operations based on the various target tables, Modify stage to alter the record schema of the input data set, Funnel stage to combine various datasets into a single large dataset and Switch stage to trigger the required output based on a specific condition Designed parallel jobs using parallel extender to enhance the performance of the Datastage jobs Used the expression editor to perform derivations and transformations using DSRoutines and DSTransforms Used Director to run, monitor and schedule the jobs Extensively created Narrowcast objects, Documents, Publications and Services Customized reports using Custom Groups and Consolidations Designed Compound metrics and Complex filters and Time filters Configured Data Marts in MicroStrategy Desktop to update tables in database Extensively used MicroStrategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports Involved in the extraction, transformation and loading of the source data to the target Oracle database Created and maintained ETL design document and integration test plans

Wells Fargo Bank, Concord, CA ETL Developer/Data Quality Analyst

Mar ’05 – Dec ‘05

Environment: Ascential DataStage 7.5 (Designer, Manager, Director, Administrator), Parallel Extender/Enterprise Edition, SQL, PL/SQL, Oracle 9i/8i, HP-Unix, SQL Navigator, MS Excel, Windows XP, Cognos (Impromptu, PowerPlay), Erwin 4.2 Wells Fargo Business Banking supports the small business market by providing various products to the small business community. The proposed vision to support Business Banking in performing analytical and management reporting is through the development of an “Integrated Business Data Depot”. This will allow business users and senior management access key information that is integrated, documented and a consistent source of relevant business banking data for reporting and analysis. Responsibilities:

• • • • • • • • • • • • • • • • • • • • •

Involved with the users and Source System Analysts to collect the requirements of the project Extensively worked with DataStage Designer for developing various server jobs using Sequential file, Hashed file, ODBC, Oracle OCI and Transformer stages Created source-target mapping spreadsheet using MS Excel Exported the source-target mapping to various Oracle tables using PL/SQL scripts Worked on the clean up, fixes and loading of metadata into the Warehouse Used Datastage Manager to import the metadata definitions into various jobs Created various Oracle date transformation functions to translate the dates in the raw files to readable dates Developed various PL/SQL stored procedures to enhance reusability during data validation and to perform unit testing Created job sequences to handle the load dependency Used Director to run, monitor and schedule the jobs Involved in laying out Oracle 9i database tables and database schema design Created UNIX shell scripts to extract specific columns needed for business from the raw files Created jobs in Autosys Job Management Scheduler to run the jobs in sequence without manual intervention Extensively worked with PL/SQL, Stored Procedures and Functions to validate the data loaded in the Warehouse tables Created lots of PL/SQL scripts to tune and optimize the database performance Extensively worked with SQL Loader to load the flat files into various Oracle tables Created and maintained ETL design document and integration test plans Created and documented various Data Quality Scripts to perform system integrated testing and user acceptance testing Extensively used Erwin to import and export the data model definition of business Currently involved in Production Support by debugging various production issues, validating the data and fixing the same as per the business requirements Reports are generated using Cognos Framework

Verizon, Dallas, TX ETL Developer

Dec ’04 – Feb ‘05

Environment: Ascential DataStage 7.5 (Designer, Manager, Director, Administrator), Parallel Extender/Enterprise Edition, SQL, PL/SQL, Oracle 9i/8i, Unix (Sun Solaris 5.8), TOAD, MS Excel, Windows XP, PeopleSoft CRM 8.4/8.9 and Microstrategy Verizon Information Services is one of the leading IT service providers. This project “VERIZON SUPERPAGES” involves in building a web based directory so that customers can use the yellow pages before newspapers and search engines for their local businesses. SUPERPAGES gives information including coverage area, adjacent directories, publication dates, circulation, demographics, products and shopping experience. Responsibilities:

• • • • • • • • • • • • • • • • •

Extensively worked with DataStage Designer for developing various server jobs using Sequential file, Hashed file, ODBC, Oracle OCI and Transformer stages Imported metadata using DataStage Manager Used shared containers to reuse the specific business logic in various jobs Worked with various stages like the Aggregator stage, Pivot stage and Sort stage Created server routines to implement specific functionalities within the DataStage jobs Created UNIX shell scripts to remove quotes, strip carriage returns from various source flat files Incorporated various functions and transforms in the DataStage jobs Used parallel extender to design parallel jobs in order to enhance the performance thereby reducing the processing time Extensively involved in the extraction, transformation and loading of data from various flat files to Oracle 9i databases. Responsible for various SQL code tuning and debugging Oracle 9i functional issues Created various stored procedures, functions, triggers in PL/SQL to trigger the Oracle 9i Database objects Prepared Technical Design documents, Unit Test reports and Integration test reports as per the Oracle AIM standards Migrated data from PeopleSoft CRM 8.4 to PeopleSoft CRM 8.9 system Microstrategy Desktop was used to generate advanced reports consisting of data analysis in grid and graph formats Created different desktop schema objects with hierarchies having complex relationships and sort orders Created public objects: filters, prompts, metrics, consolidations, custom groups, templates Deployed web reports using Microstrategy Web for remote access by users

J. P. Morgan Chase, Dallas, TX Datastage Consultant

July ’04 – Nov ‘04

Environment: Ascential DataStage 7.5/7.0 (Designer, Manager, Director, Administrator), Parallel Extender, Metastage, SQL, PL/SQL, SQL Loader, Oracle 9i, Windows NT 4.0, UNIX, Erwin 4.1, Websphere IBM MQ Series, Editplus, Python, TOAD and MS Excel. J. P. Morgan Chase is one of the leading service providers in accounting and information. This project involves in building an infrastructure to manage and integrate customer information to track customer

activity for providing personalized and enhanced customer service and products. The main focus of this project is to organize customer records and individual account information for providing faster transaction and refined services to tailor customized offerings for individual preferences. Ten years of accounting information history is being maintained. Responsibilities:

• • • • • • • •

• • • • •

• •

Extensively worked with Parallel Extender and various DataStage clients (Designer, Manager, Director and Administrator) for developing DataStage parallel jobs and to enhance the performance of source to target transformation and loading Created server jobs using Hashed file, Sequential file, ODBC and Transformer stages Implemented local containers for the same job and shared containers for multiple jobs that have the same business logic Extensively worked with various source systems like the flat file source systems, Oracle source systems and Mainframe systems Created parallel jobs that read messages from the MQ Series using Websphere MQ stage and the MQ Read stage Used Column Import stage to restructure the data coming in a single column from the Websphere MQ into multiple columns for further processing through various other stages Used Remove Duplicates stage to remove the duplicate data from the source system to enhance high quality processing of the incoming data Extensively used processing stages like the Lookup stage to perform lookup operations based on the various target tables, Modify stage to alter the record schema of the input data set, Funnel stage to combine various datasets into a single large dataset and Switch stage to trigger the required output based on a specific condition Worked with Parallel Transformer stage and implemented various DSTransforms to transform the input data and map it to the target columns Used Peek stage for debugging the parallel jobs Worked with Director to run, monitor, schedule the job and to view the job log Involved in the extraction, transformation and loading of the source data to the target Oracle database Performed Import/Export of various Oracle 9i Database objects from one schema to the other Designed Database Triggers for audit and validation purpose and to store data History Tables in Oracle 9i Database Reports were generated using Cognos Framework

BellSouth, Birmingham, AL Data Warehouse Developer

May ’03 – June ‘04

Environment: Ascential DataStage 7.0/6.1(Designer, Administrator, Manager, Director), Parallel Extender, Quality Stage (Integrity), Profile Stage (MetaRecon), MetaStage, SQL, PL/SQL, SQL*Loader, Oracle 9i, Microstrategy 7.2, MS SQL Server, Windows NT 4.0, NCR Teradata V2R3, Unix and ERwin4.0 BellSouth is one of the leading telecommunications service providers. This project involved in building an efficient business intelligence infrastructure to analyze and optimize advertising sales by integrating data from disparate sources to help in reporting and analyzing past and present sales. Responsibilities:

• • • •

• • • • • • • • • • • • • •

Extensively worked with DataStage Administrator, Designer, Manager and Director for developing DataStage jobs Identified the facts and dimensions for the business and modeled the data using Star schema Involved in logical and physical data modeling using ERwin Implemented surrogate keys for all facts and dimensions

Developed server jobs and parallel jobs using built-in and plug-in stages like Aggregator, Hashed file, Sequential file, ODBC, BCPLoad Extensively worked on the source data from Flat file source systems, Oracle source systems, and DB2 source systems and loaded to Teradata target system Imported Metadata, table definitions and stored procedure definitions using the Manager Designed local and shared containers to simplify complex job designs and promote reusability of job designs Used the expression editor to perform derivations and transformations using DSRoutines and DSTransforms Created DataStage jobs, batches and job sequences and tuned them for better performance Used the DataStage Director to run and monitor the Data Stage jobs Worked with link partitioner and link collector to improve the performance Used parallel extender to run the jobs in parallel Used MetaStage for managing and collecting metadata from various other tools through the use of MetaBrokers Used MetaRecon to perform column/table analysis Deployed web reports using MicroStrategy Web for remote access by users Developed ad-hoc reports with drilling up, down, across dimensions and also drill to a template Created MicroStrategy schema objects: attributes, facts, hierarchies and public objects: templates, filters, prompts and metrics for the generation of ad-hoc reports

PMC Pharmaceuticals, Connaught, PA ETL Developer

Jan ’02 – Apr ‘03

Environment: Ascential DataStage 5.2, Datamarts, PL/SQL, SQL*Loader, Oracle 8i, SQL Server 2000, DB2/UDB, ERwin 3.5, Windows NT, Sun Solaris 2.6, Microstrategy, MetaStage, MetaRecon PMC Pharmaceuticals is the leading provider of drug delivery solutions. The primary objective of this project is to develop a healthcare system making extensive use of data marts. Data extracted from different operational databases is aggregated, transformed and loaded into the target database. Ad-hoc reports are generated for business analysis. Responsibilities: •

• • • • • •

Involved in requirements collection, data warehouse design, implementation and administration Identified the facts and dimensions for the business and modeled the data using star schema Developed the physical and logical data modeling using ERwin Created server jobs using DataStage Designer to extract the data from the source systems, aggregate the data and load into the data warehouse Used parallel processing to enhance the performance of the jobs Imported metadata of source, target and look up tables using DataStage Manager Used DataStage Manager for creating new job categories and table definitions

• • • •

• •

• •

Created stored procedures and functions on SQL Server Worked on Hash file stages, sequential stages, ODBC stages and DB2/UDB to extract the data from the source systems and to load into the target database Extensively worked on DataStage Director to run, monitor and schedule the DataStage jobs Used MetaStage for synchronizing and integrating metadata from warehouse related tools, automatically gathering process data from operational systems Created, analyzed, tested and implemented reports using MicroStrategy 7i Created MicroStrategy schema objects: attributes, facts, hierarchies and public objects: templates, filters, prompts and metrics for the generation of ad-hoc reports

Various prompts were created to give the users more flexibility to run ad-hoc reports, which included object prompts, value prompts and nested prompts Developed ad-hoc reports with drilling up, down, across dimensions and also drill to a template

Purple Technologies, Chennai, India Oracle Developer

Apr ’00 – Nov ‘01

Environment: PL/SQL, MS SQL Server 6.5, T-SQL, Visual Basic 5.0, Stored procedures, Views, Triggers, SQL* PLUS, MS Excel Responsibilities: •

Designed and modified the existing database to incorporate new requirements

• •

Evaluated T-SQL for performance monitoring, optimization and tuning Performed database administration duties like creation of tables, indexes, views, user roles, regular backups and monitored performance Used exports and imports wizard for performing data transfer Implemented front end programming in Visual Basic to invoke stored procedures Implemented a utility that can filter, validate and import the data into the existing database, which would otherwise require manual data entry

• • •

EDUCATION Bachelors in Electronics and Communication Engineering (Madras University)