Title:RATE NEEDED

abpx9l@r.postjobfree.com

Document

Source below

NAME: Surendra Kumar

ADDRESS:

CITY:

STATE/PROVINCE: CT

ZIP/POSTAL CODE:

COUNTRY: USA

EMAIL: abpx9l@r.postjobfree.com

PHONE: 203-***-****

CANDIDATE ID: 101312

CITIZENSHIP: Requires Sponsorship

EDUCATION: Master Degree

EXPERIENCE: 9

WILL RELOCATE: Open

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

HOTSKILLS: ETL

ESUME

SURENDRA KUMAR

abpx9l@r.postjobfree.com

203-***-****

(Cell)

203-***-****

(Home)

Over 9 Years experience in Computer and Database Systems with strong Data Warehouse

experience throughout system development life cycle (SDLC), ORACLE Database Applications

and Administration.Expert working knowledge of ETL Tools (CA DecisionBase, CA InfoPump,

Constellar and Informatica).In addition Strong skills in database creation performance

tuning of logical and physical design,

disk space management, database tuning and security management, backup and recovery

activities, installation and upgrade of database as well as managing the objects and

system privileges. Proven expertise designing and developing Data Marts with RDBMS (ORACLE

8i, 8.05 and 7.x), MS SQL Server 7.0, ODBC, legacy systems, DB2 and flatfiles as

source/target.

TECHNICAL SKILLS

OPERATING SYSTEMS

Ms Windows NT, Ms Windows 2000/98/95, SUN OS (SOLARIS 2.5.x), HP-UX 11.0, HP-UX 10.x, Ms

DOS & Novell NetWare 3.11/4.10

LANGUAGES / DEVELOPMENT TOOLS

C, C++, COBOL, PASCAL, Clipper 5.0, HTML Scripts, Java Script, Java Servlets/applets,

Perl Scripts, CGI Scripts and UNIX shell Scripting

3RD PARTY APPLICATION SOFTWARE

Data Warehousing, Decision Support Systems, MIS and OLAP, using star Schemas, Erwin, CA

Decision Base 1.9, CA InfoPump, CA AutoSys 3.4, Info Pump 3.3, Decision Base Meta Data

Repository (Repository/OEE 2.0), Informatica (Power Mart, Power Center), Constellar,

COGNOS (PowerPlay Enterprise Server 6.5, PowerPlay Client 6.0, PowerPlay Web 6.0,

PowerPlay Transformation

Server 6.0, Impromptu Query client 5.0 and Impromptu Web Query 2.12), Business Objects

and Information Advantage, Oracle Designer 2000, Oracle Developer 2000 (Forms 4.5, Reports

2.5), Visual Basic 6.0, SQL*DBA, PL/SQL, SQL*LOADER, PRO*C, SQR (Structured Query Report V

3.0.5),ToadSoft, SQL Station 2.0 and FoxPro 2.5, Oracle 8i, 8.05,7.x/6.0, Ms SQL Server

7.0, Ms Access 97, ERP-AVALON 9.2.

CERTIFICATIONS

* Certificate of Achievement in HUBTO/HUBD from Constellar, Inc.

* Certificate in Decision Base 1.9 Data Movement Introduction from Computer Associates.

* Learning Informatica (Power Mart & Center) ETL tool.

* Certificate in Java 2 from Brainbench, Inc.

EXPERIENCE SUMMARY

Company - XYZ

04/00

- Present

On assignment to: Praxair, Inc

As a Sr. System Development Analyst, worked on WISDOM Spend Data Mart Project. Praxair,

Inc., a global, Fortune 500 firm, is the largest Industrial Gases Company in North & South

America and one of the largest worldwide, with operations in 44 countries. This is an

Enterprise Data Warehouse project having a central production server based in Tonawanda,

NY, The Data Warehouse currently consists of the Operational Data Store(ODS) and two Data

Marts the Global Spending Data Mart and the Visa Data Mart. Operational Data Store (ODS)

are the sources for the Data Marts and contain atomic level data. Decision Base is a Data

transformation tool that moves and transform data from a variety of sources like SAP,

Oracle financial, JDE Edwards, oracle 8.05 and 7.x, MS SQL Server 7.0, ODBC, legacy

systems, DB2 and flatfiles. COGNOS is an end-user

analytical tool, to provide the user and developer with a variety of functions like

access to the cubes, access to the star schema and sophisticated reporting capabilities.

* Responsibilities include Analyzing user needs & data, designing data model and develop

data warehouse for Praxair, Inc.

* Extract data from different data sources/countries by DecisionBase ETL Tool, scrubbing,

transforming and loading clean data into Data warehouse.

* Worked with ERWIN Data Models.

* Expertise in multi-dimensional data modeling and star schema design concepts, source to

target mapping.

* Used Iterations methodology for design development and testing

* Developed resuable code with ETL tool.

* Designed and developed ETL data extraction programs from multiple source/countries

applying a wide variety of transformation rules.

* Developed a front end staging extract subsystem to isolate JD Edwards data and

integrate the data updates within a Operational Data Store subsystem.

* Setup and managed operations for ODS and Data Warehouse.

* Assisted Praxair DBA with backup/restore procedures as well as Database and SQL Tuning.

* Worked with business community to complete requirements and business analysis.

* Worked with OLAP staff to design data cubes for reports and data mining.

* Design and maintenance of logical and physical database model and OLAP system.

* Expertise in Pl/SQL coding and Proficiency in UNIX environment.

* Environment :

Oracle 8i, 8.05 and Oracle 7.3 (Parallel Server), MS SQL Server 7.0, Compaq 7000 with NT

4.0, COGNOS OLAP Tool, Visual Basic 6.0, MS-Access, SQL, PL/SQL, SQL*Loader, CA

DecisionBase, CA InfoPump, CA AutoSys 3.4, SQL Work Station 2.0 (GUI Interface), Erwin 3.5

and Flat files (ASCII, EBCDIC and binary).

JBAS Systems, Inc

03/99

- 03/00

On assignment to: MRJ Technology Solutions, VA (U.S.A)

As a Software Engineer, worked on the Enterprise Data warehouse building for U.S. Patent

and Trademark Office. Worked on the Enterprise Data Warehouse (EDW) project for US -

Patent and trademark Office (P.T.O) which gave information to P.T.O managers for analysis

and support in Decision-making. EDW was subject oriented and has areas like Patent General

ledger Payroll,

Human Resources, Activity Based Costing. Data warehouse was also mapped to Executive

Information System (EIS). EIS reports were web based on the USPTO Intranet. This system

had dynamic presentation, drill down capabilities, interactive, and was user friendly.

Metadata was managed on the Rochade. Raw data come from different source systems

(mainframes, PC's) in different

format like EBCIDIC, Flat files, Oracle, Access tables and/or Excel worksheets. Loading

raw data to the EDW via staging tables using SQL*LOADER, Unix shell scripts, SQL & PL/SQL

performing extracts, transforms and cleansing.

* Preformed ETL programming and assisting DBA with creating tables, partitions, indexes,

views, synonyms and sequences.

* Coded SQL, PL/SQL (writing triggers, procedures, functions and packages), Unix shell

scripts.

* Data loading from flat files to Oracle tables using SQL Loader.

* Exporting and importing the database, backup and recovery strategies.

* Scheduled scripts in CRON-TAB jobs.

* Developed automated monitoring scripts using system tables and views.

* Environment: Oracle 8.05, HP- Unix 11, Constellar (V 3.01), OLAP Tool, Business Object,

Information Advantage, Perl Scripts, CGI Scripts, Html Scripts, Visual Basic 5.0, MS-

Access, Windows NT/95, IBM/Unisys main frame, SQL, PL/SQL, SQL*Loader, Erwin, Unix shell

scripts.

ACS International Resources, Inc

06/98

- 02/99On assignment

to: MDL Information Systems Inc

.

As a

Programmer/System Analyst, worked on Sample Management and Reagent Tracking System

(SMART System). Worked on the Sample Management and reagent Tracking System (SMART) which

provided a repository for discrete chemical inventory information. It provided a user

interface for Interactive, Searching, Browsing and reporting of inventory data. In the

reporting capabilities, included Chemical, supplier, location, quantity and storage

properties. This

system has implemented in a 2 tired architecture; Business process will be executing on

the server side via ORACLE PL/SQL and JAVA SCRIPT. The user interface was implemented on

Client-side using HTML & JAVA SCRIPT. Data was fetched by different type of DATABASES.

* Created and sizing database.

* Created scripts to create database and objects in the database.

* Created user accounts, groups and setting up privileges and accesses.

* Performance and space usage monitoring.

* Defragment extents, tablespaces and other objects.

* Database performance tuning, monitoring and enhancement.

* Database backup, recovery and archival, using hot, cold and export backups.

* Hands on experience loading and transforming (ETL) using oracle SQL*LOADER.

* Created Unix shell scripts and SQL scripts to populate the data

* Created stored procedure and triggers.

* Environment : Silicon Graphics (IRIX 6.4), HP-UX 10.x, Windows NT/95, PENTIUM/486 based

Machine, ORACLE 7.3.2, SQL, PL/SQL, HTML, JAVA SCRIPT.

Escorts, LTD (System Management Services Division)

04/97

- 05/98

Assistant Manager

- Systems

Worked on Executive Information System and was involved to design, development and

implementation of this system which was designed to take care of on line information for

all executives.

* Designed data model using Designer 2000 and created tables, indexes, views, synonyms,

sequences triggers, procedures, functions and packages.

* Developed new forms and reports as per company's requirements.

* Created reports with drill down capabilities and all the reports were developed in R

Two tool.

* Loaded oracle data to EIS database via staging tables using SQL*LOADER, UNIX Shell

scripts, SQL & PL/SQL which performed extracts, transformations and cleansing.

* Environment : Enterprise 3000 (SUN SPARC), Solaris 2.5.1,Windows NT/95, PENTIUM/486

based Machines, ORACLE 7.3.2 (SQL, PL/SQL), Oracle Developer/2000 (Forms 4.5, Reports

2.5), SQR, Designer 2000.

Escorts, LTD

(System Management Services Division)

04/97

- 05/98

Worked on Implementation and Customization team for the AVALON Financial (AP, AR, GL)

Module. AVALON is an Enterprise Resource Planning (ERP) System with an integrated family

of manufacturing distribution, purchase and Material Applications. ERP AVALON took care of

organization resources and was designed to address the need of the modern manufacturing

enterprise.

* Customized AVALON forms and development of new forms and reports as per ESCORTS

requirement using Oracle Developer (Forms 4.5 and Reports 2.5).

* Analyzed business process and set direction rule for AVALON flows and enhancement

analysis.

* Migrated data from ORACLE 6.0 based current Finance System to AVALON System using

PL/SQL, SQL*LOADER facilities.

* Mastered data structuring and validation to meet AVALON design requirements.

* Environment : Enterprise 3000 (SUN SPARC), Solaris 2.5.1,Windows NT, Windows 3.11/95,

PENTIUM/486 based Machines, ORACLE 7.3.2 (SQL, PL/SQL), Oracle Developer/2000 (Forms 4.5,

Reports 2.5), SQR (Structured Query Report Writer)

SUPER SEALS INDIA LTD

08/96

- 03/97Programmer Analyst

Worked on the Financial Accounting system. The important feature of the package included

Books of accounts (Cash, Bank and Journal), on-line General Ledger and trial balance.

Detailed over head expenses and Incomes. Calculation of TDS from payments professionals,

Contractors, rent and periodical returns to be submitted to Govt. The system was designed

to take care of legal

as well as Company's internal requirement.

* Was responsible for completes development of project, Analysis and designing of

specification, final testing, integration and user training.

* Build front-end application module with extensive use of Developer/2000.

* Added functionality by incorporating: GUI, LOVs, format masks, validations, triggers,

checks and alert.

* Environment : HP 9000 (D 370), HP-UX 10.x, Windows NT & DOS, Windows 3.11/95 and,

PENTIUM/486 Oracle 7.2 (SQL, PL/SQL), Developer/2000 (Forms & Reports), Designer 2000.

04/96

- 07/96Programmer Analyst

Worked on the Bank Reconciliation and check writing systems, which captured all the debit

and Credit transaction done between Super Seals and different Banks Accounts. Subsequently

all the transactions were reconciled through manually or automatically. The checks issued

by Super Seals are printed through computes and maintain the information.

* Was responsible for the complete development of project and Testing of system,

Designing and development of MIS reports and final Implementation of the system.

* Environment : HP 9000 (D 370), HP-UX 10.x, Windows NT & DOS, Windows 3.11/95 and

PENTIUM, Oracle 7.2 (SQL, PL/SQL), Oracle Developer/2000(Forms 4.5, Reports 2.5).

08/95

- 03/96Programmer Analyst

Worked on the Order Processing and Inventory System, which included order processing on

the basis of FIFO, Dispatch Scheduling, Invoicing and Receivable. It also kept track of

the payment made by the clients based on the invoices. It generates various types of

invoices, dispatched advice and statuary documents like Application of payments, Material

verification certificates and Excise documents. Designed the system to suits the needs in

changing business scenario.

* Was responsible for completes development of project, Analysis and designing of

specification,guidance of team members during development, final testing, integration of

modules and user training.

* Created Stored procedure and Triggers

* Environment : HCL - Magnum II, Magnix (UNIX V.3), Oracle 7.1 (SQL, SQL*PLUS, PL/SQL),

SQL*Forms 3.0, PRO*C, DOS, Windows 3.11, Pentium/486 Based Machine

01/95

- 07/95Programmer Analyst

Worked on the Payroll Accounting system, which was designed to keep view with maximum

customization for the Company. The major module of this package was Employee details,

Computerized attendance System, Payroll calculation, Bonus and Gratuity calculation, Loan

Accounting, Income Tax Calculation and PF Management. The System was integrated with

Financial Accounting.

* Was responsible for the development, testing, and designing of statutory reports and

final Implementation of the system.

* Environment : HCL - Magnum II, Magnix (UNIX V.3), Oracle 7.1 (SQL, SQL*PLUS, PL/SQL),

SQL*Forms 3.0, PRO*C, DOS, Windows 3.11, Pentium/486 Based Machine

05/94

- 12/94Programmer Analyst

Worked on the Leave Accounting System, which was designed for attendance entry, leave

monitoring and calculation of payable days, Bonus payable days and payable days for other

perquisites and benefits accounting to the work and attendance on normal working days,

Sunday, national holidays festivals. This system generated various MIS reports to take an

optimal decision regarding

production norms, Finance controlling, organization policies rules etc.

* Studied muster- roll, ledger, forms etc. Analysis of existing information, mainly rule

pertaining to the valid leaves, created tables, database triggers Procedures and packages

sequence forms and reports, testing and Implementation.

* Environment : HCL - Magnum II, Magnix (UNIX V.3), Oracle 7.0 (SQL, SQL*PLUS, PL/SQL),

SQL*Forms 3.0, PRO*C, DOS, Windows 3.11, Pentium/486 Based Machine

06/93

- 04/94Programmer Analyst

Worked on the Material Management Systems, which designed few reports for Goods receipt,

Receipt against advance, Receipts excess to schedules, Issue, Return, Physical Stock,

Shortage reports Rejection reports.

* Studied tables, forms, triggers, coded reports, Testing and verified reports through

managers and end-users Implementation. Tuned the previously developed system.

* Environment : HCL - Magnum II, Magnix (UNIX V.3), Oracle 6.0 (SQL, SQL*PLUS, PL/SQL),

SQL*Forms 3.0, PRO*C, DOS, Windows 3.11, Pentium/486 Based Machine

RUCHIKA INDUSTRIES LTD

07/92

- 05/93Programmer

Worked on the on-line Store Management System, Which was designed to enable the

organization to have a control over the working of the row material store, purchase and

materials accounts departments from Indents to bill passing of the material. Some MIS

reports, required by costing and auditing department, were also generated. The sub-

modules included in the system were purchase, stores, material accounts & others. The

working of Indent, Quotations, purchase,

Receipts, Issues to dept.'s, Issues to other parties on returnable basis, Return from

user departments, Returning their own materials, chargeable, Ledger, Debit notes, Scrap

sales, Bill passing, Overhead passing, and advance to parties was controlled in this

project.

* Studied of all forms, challans and Memos.

* Prepared of study documents. Analyzed study documents.

* Created database file and index.

* Tested through parallel run, manual system and Implementation.

* Environment : FoxPro 2.5 under NOVELL NetWare (3.11), DOS 6 and 486 based machines

Education

* Allahabad University

Master of Computer Applications (MCA)

* Meerut University

Bachelor of Science

Additional Training

* Completed training in Oracle, Developer 2000 at STG, India

Contact this candidate