Ponnambalam Arumugham

**** ***** *****, ****** ** 08817

Email: n601pv@r.postjobfree.com phone: 973-***-****

---------------------------------------------------------------------------------------------------------------------------------------

EXECUTIVE SUMMARY:

15+ years of experience in all phases of software development life cycle (SDLC), including design, development, testing, integration and Implementation of various projects using Data Warehousing tools and client server applications.

• 12+ years of experience in Oracle 11g/10g/9i/8i/7.x and its associated products/utilities like PL/SQL, Export/Import, SQL Loader, Pro*C/C++,SQL, SQLPLUS and developing applications using Procedures, Packages, functions, Views, Materialized Views, Types, Collections, Analytical functions &Triggers for both OLAP & OLTP Applications.

• 7+ Years of experience in Data Warehouse Architecture, Database Management, logical and physical design of relational and multidimensional databases using Erwin/Visio, Data analysis and Requirement Gathering, design documentation and design reviews.

• 10+ years of experience in Data Warehouse ETL applications using Informatica Power Center 8.4/7.1/6.1/5.1,Informatica Power Mart 4.7, SQL Loader and PL/SQL UTIL Files etc.

• Strong working knowledge in data warehousing concepts such as Multi-Dimensions, slowly changing dimensions, Facts, Attributes, Metrics, Measures, STAR Schema, Snow Flake schema, and Kimbell/Inmon data warehouse methodologies. Also, working experience in Agile development methodologies.

• Strong working experience in ODS (Operational Data Store) and Incremental loads/Change Data Capture (CDC).

• Certified DBA - performed administration activities like application tuning, performance tuning, database tuning, schema/object design, security design (roles, privileges) and database links etc.

• 12+ years of experience in UNIX shell scripting(HP-UX/SUN Solaris/IBM AIX) and automation of ETL processes using schedulers like Tivoli Maestro, Autosys & Crontab

• 6+ years of exposure to Business Intelligence OLAP/CUBE tools like Cognos, Microstrategy, Brio, Crystal reports for generating warehouse reports.

• 10+ years of experience in Production 24/7 ONCALL support and interacting with business partners.

• Experience in data quality, data governance, source systems analysis and data extraction from various data sources like Flat files, , SAP, Oracle 8i/9i ,SQL Server and DB2.

• Expertise in using supporting tools like Toad, SQL Navigator and version control tools like VSS, PVCS,CVS,SVN and eroom.

• Experience in Sales, Marketing, Market Operations, Finance, and Sale force Automation for pharmaceutical applications, and Loans, deposits, fixed income for Financial applications, and price Desk, Range and Assortment desk for retail applications, and inventory, purchase order, logistics, distribution for manufacturing applications, and Product, Inventory for Hospitality application.

• Possesses Technical, Team management skills and capable of involving in the project from conceptual phase to development. Possesses excellent Inter personal skills and Technical skills. Lead the team of 4 for a development project for 1 1/2 years.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.4/ 7.1/6.2/5.1, Power Mart 7.1/6.2/5.1, Power Connect 5.1., SQL* Loader, PL/SQL UTIL File.

OLAP Tools: Microstrategy 8.x/7.x, Cognos 8, Hyperion BRIO, Crystal reports

Scheduling Tools: Maestro, Autosys

Database: Oracle 11g/10g/9i/8i/7.x, SQL-Server 2008, MS-ACCESS, DB2, Datacom CA

Languages: SQL, SQLPLUS, PL-SQL, C, PRO*C/C++, JAVA, AWK/SED, UNIX shell Scripting, PERL, COBOL, Windows SDK, Developer/2000(Forms 4.5, Reports 2.5)

Web Tech: ASP.NET, VB6, Portal tools (PLUMTREE), SOA, JAVA,

Tools: Erwin, TOAD, SQL Navigator, Maestro (scheduler), VSS (Tracker, Version Manager), PVCS, Reflection-X, MS-Word, MS-Excel, MS-VISIO.

O/S: SunOS 5.9, AIX, ULTRIX, HP-UX, Sun Solaris, UNIX, Windows XP/2000/NT, DOS.

Hardware: sun4u sparc, SUN SPARC/10, HP 11000/9000, RS/6000, DEC ALPHA/2100, DEC ALPHA/4100, WIPRO Super-mini system (UNIX) and Windows XP/2000/NT

EXPERIENCE:

Jan 2010 to Present Senior Developer Wyndham World wide Inc,

Parsippany, NJ

Project: Weeks and Points Platinum

Wyndham Exchange & Rental provides hospitality support and manages around 12000 Resorts world wide. This project involves maintaining products, customers, & affiliates information and providing inventory, pricing, reservation and promotion info to multi-demographic customers through Online web systems. Also, involves generating warehouse reports on trend and sales for demand management.

• Performed the requirement gathering, design documentation and data analysis on multiple enterprise data.

• Architect the Conceptional, Logical & Physical modeling for relational ODS systems and dimensional EDW systems.

• Performed physical implementation, and optimized systems for better performance.

• Construct the ETL/DB processes using PL/SQL and Informatica.

• Schedule the batch jobs through shell scripting and schedulers.

• Supported the Java/J2EE architecture, SOA, XML and other web technologies.

Challenges:

1. Faced data integrity issue while designing the parent-child tables for multi-value attributes – resolved with NESTED TABLE approach.

2. One of the developers data load process took 4 min, tuned process and the SQL to bring it down to 20 sec.

3. Resolved data cloning for multilingual attributes some attributes are available only in standard language English.

Environment:

Solaris 10, Oracle 10g/9i,ERWIN,Informatica Power Center 8.4, SQL* Loader, Autosys( Scheduler ), Export/Import, PL/SQL, SQL, , SQL*PLUS, Unix SHELL programming (ksh), COGNOS 8, Crystal Reports 10, Windows XP, Java, XML, ACCESS, EXCEL

Dec 2006 to Jan 2010 Senior Developer/Data Architect Johnson & Johnson Inc,

Morris Plains, NJ

Project: Enterprise Data warehouse Dec 2006 – Jan 2010.

Project involves warehousing Operational Data Stores (ODS) like Sales, Pending, Inventory, A/R, etc. for J&J Consumer Healthcare division.

• Performed Process design, data modeling(ERWIN) and coding ETL process for Multi-dimensional master data (Customer, territory, product, sales bill of material, trade class) and Facts (Sales, pending, inventory, Account Receivable (AR) etc ) data from legacy system (SAP/DB2) to ODS/Data resource center (Oracle).

• Performed design and development of data feed for datamarts like Goals, demand Management, supply chain and Finance systems.

• Supported Business Intelligence (BI) reporting systems using Microstrategy, Cogos and crystal reports.

• Performed maintenance of database environments (Development, Test and Production) of size 2 terabyte and application tuning, performance tuning, automation (shell scripting & scheduling) and supporting (ON CALL) of applications.

Challenges:

1. The nightly batch process (around 200 jobs) for one of our Sales system used take 4 hours to process. Worked on to tune individual process (sql tuning, parallism) and brought proper dependencies on jobs and the whole batch was brought down under 1 hour.

2. Users has reported some OLAP reports were talking some considerable time to execute resolved the issue by partitioning the aggregate tables.

Environment:

HP 9000, HP-UX, Oracle 10g/9i,ERWIN,Informatica Power Center 8.0/7.1/6.1/5.1, Informatica Power Mart 4.7, SQL* Loader, Maestro( Scheduler ), Export/Import, PL/SQL, SQL, T-SQL, SQL*PLUS, SHELL programming (ksh), Microstradegy 7/8, Hyperion BRIO,COGNOS 8, Crystal Reports 10, ASP.NET,PLUMTREE, Windows XP/2000, C#.net HTML, ACCESS, EXCEL

Aug 2000 to Nov 2006 Senior system Specialist Pfizer Inc,

Morris Plains, NJ

Project 1: Syndicated consumption data warehouse Jun 04 – Nov 06.

Project involves processing of point of sales (POS) data, consumption data, competitor’s data, stores info from third party vendors like AC Nelson and IRI of size around 2 terabyte.

• Performed system design and development of ETL processes.

• Performed requirements gathering and user interactions.

• Coded complex queries, aggregates, optimization & parallel processing.

• Maintenance & ON CALL support.

Project 2: Professional Sales (Sale Force Automation) data warehouse Aug 02 – Jun 04.

Project involves sales force automation of tracking calls, details, samples of consumer products to doctors, and integrating their surveys, average weekly recommendations (AWR) & territory alignment.

• Interacted with third parties (DENDRITE, NDC, IMS,WG, JAY GROUP) for integrating data feed with professional data warehouse.

• Architected the backend ETL processes.

• Performed data analysis and modeled data integration processes.

• Performed Data Migration and Data Modeling.

• Designed the process flow of batch jobs and automated through perl, Unix shell scripting and Tivoli Maestro (scheduler).

• Lead the team for developing the backend processes.

• Supported the integration of reporting systems (Hyperion Brio & portal).

• Performed maintenance, production support, database maintenance and performance tuning of complex Queries/Processes.

Project 2: DRC STUDIO Jan 02 – Aug 02.

Project involves development of hierarchy sub-system which maintains Product (Category, Brand, Pack, and Flavor) tree structure and interfaced with data warehouse applications.

• Performed in design, development and maintenance

• Implemented the interfacing of warehouse applications and Web applications.

Project 3: COCKPIT Jun 01 – Jan 02.

The scorecard portal application maintains Sales, pending, Goals, LE (latest Estimates) information at high levels for Sales, Marketing, Finance and Market Operations of consumer business.

• Performed in the design, development, maintenance and production support.

• Implemented the interfacing with Portal systems (PLUMTREE & ASP.NET).

Project 4: TPF (Trade Promotion Fund) & TPE (Promotion Estimate) Aug 00 – Jun 01.

Project involves integrating promotions (coupons, fliers, Adds etc. ) and consumptions (POS Sales) with Sales system (Sales, Pending & inventory) to the gauge the LIFT, COST & LE.

• Performed in integrating with reporting systems and data warehouse subsystems.

Environment:

SUN4U SPARC, SUN SPARC/10, SunOS, HP 9000, HP-UX, Oracle 10g/9i/8i/7.x,SQL Server, Informatica Power Center 8.0/7.1/6.1/5.1, Informatica Power Mart 4.7, SQL* Loader, Maestro( Scheduler ), Export/Import, PL/SQL, SQL, T-SQL, SQL*PLUS, SHELL programming (ksh), Shell scripting, perl,Microstradegy 7/8, Hyperion BRIO, Crystal Reports 10, ASP.NET,PLUMTREE, Windows XP/2000, C#.net HTML, ACCESS, EXCEL

Oct 1999 to Jul 2000 PepBoys Stores Center, Philadelphia, PA

Project: RPD (Retail Price Desk) & RAD (Range and Assortment Desk)

The project RPD (Retail Price Desk) is the total pricing system deals with store markets, jobber price, base price, dealer price, list costs and net costs of auto parts of the PepBoys stores. The project (RAD) deals with Reference Library, Merchandize office and Chronicle data’s.

• Design and development of interfaces using ‘C’, ‘PRO*C’.

• Developed driver programs using shell (KORN) scripts and automation through crontab process.

• Wrote data load processes using stored procedures, functions, packages and database triggers, PL/SQL scripts

• Performed the exporting and importing of databases from development, test and production environments using Oracle EXPORT/IMPORT utilities.

• Performed in the database administration activities like user maintenance, security, Memory Management, object Management, database link creation and application tuning etc.

Environment:

RS/6000, UNIX AIX (4.3.0.2), Windows NT/98, Application A-Series (rel 2.4), Oracle 8.0.5, Oracle 7.3.4, ‘C’, ‘PRO*C’, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, and SHELL programming (ksh).

April 1997 to Sep 1999 CSC (Computer Science Corp)/COMMERZ BANK, MOORESTOWN, NJ

Project: Online Banking System

Commertz Bank is market player in commercial / Investment Banking that deals with Loans, Deposits, and Securities, swift, money market, Derivatives, FX and personal wealth management. Commertz bank maintains different systems for each area.

Various modules of the project:

• Fund Transfer

• Loans/Deposits

• FX.

• Securities

• Swift/Money Market.

.

• Design and development of stored procedures, functions, packages and database triggers using SQL and PL/SQL.

• Preprocessed the legacy data using AWK/SED programming and automated through SHELL programming and loaded into Oracle tables using SQL*Loader.

• Performed database administration activities like Memory Management, object Management and application tuning, Export/import, dblink etc.

• Performed maintenance of DATACOM, CA and ‘C’, Pro*C and Pro*COBOL program’s.

Environment:

DEC ALPHA/2100, DEC ALPHA/4100, SUN SPARC/10, HP 9000, UNIX, Windows NT/95, Oracle 7.3.4, DATACOM, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, Perl, AWK/SED programming and SHELL programming (csh & ksh)

January 1994 - March 1997 ASIEO, Computer Systems Division, Bangalore, India

Project: Inventory Control System / Goods Inwards System / Purchase Order System

Inventory Control system is a total on-line system, which automates stores receiving and stores issuing to

the defense industry.

The Goods Inwards System automates the goods receiving and inspection/rejection of material areas of the business in the defense industry.

The purchase Order System is a total online system which automates purchase business in the defense industry such as processing requisitions for purchase items from different departments in the company, inviting tenders from different suppliers, analyzing quotations received from different suppliers and processing purchase orders and follow-ups.

• Wrote stored procedures, packages, functions and database triggers using PL/SQL on Oracle 7.x databases

• Developed on-line screens using Oracle Forms 4.5/ReportWriter 2.5.

• Developed programs to generate complicated reports using PRO*C.

• Involved in designing and developing various reports using SQL*ReportWriter 2.5.

• Performed developing forms using Visual Basic 4.0

Environment: Oracle 7.x on UNIX(DEC) platform, Developer/2000 on Windows 3.1, PL/SQL, SQL*Plus, PRO*C, Visual Basic 4.0/5.0

EDUCATION and TRAINING:

B.S. in Electronics and Communication Engineering.

Post Graduate Diploma in Advanced Computer Technologies.

Passed Mastery level Database Administration Examination ( OCP Certified by Oracle Corporation).

Contact this candidate