Professional Profile

• Currently working as an Information/Data/Intgration Architect in IBM (GBS Order Management & Fulfillment practice).

• He has over 15 years of experience in the design, construction, and implementation of information system.

• He has worked as Information Architect, Data Architect, Data base architect, Data Service Specialist, Data migration Specialist, Data Modeler, DBA.

• He has extensive knowledge in SOA, SOI, BI, Web Services, BPEL, XML, XSD, WS-*.

• He is a goal oriented, hard working, and a good communicator.

Employment History

• Dec 2000 – Till Date -- IBM

• Aug 1999 – Dec 2000 -- Home Shopping Network

• Feb 1998 – Aug 1999 -- Arthur Andersen

• Jan 1994 – Feb 1998 -- Thermax Software and System.

Experience and Accomplishments

June 2010 – current BJs (Retail Industry): Integration/Data Architect.

Technology Used: IBM ACE, Erwin 4.5, IBM WebSphere Message Broker 7.0.1, IBM WebSphere 7.0, JDK 1.6, IBM IS DataStage, Oracle 10.x,J2EE, JSF,ARTS,

• Contribute to the architecture and development of the POS solution using IBM ACE and IBM Middleware technologies.

• Contribute to the development of the Enterprise Integration Layer (IL) development to convert the proprietary data format (TLOG) to the retail industry standard (PosLog) XML format.

• Involve in the modeling of the Operation Data Store (ODS) using ARTS modeling standards to build a central sales transaction repository.

• Architect and design the ETL layer to interface with the legacy back-end accounting and cash settlement systems.

• Solution Architect and design the intranet based User interface using JSF framework to store and manage store personalization data.

July 2009 – May 2010 WellPoint (Insurance Industry): Information Architect, Sr. Data Modeler, Team lead.

Technology Used: Optim, Erwin 4.5, IBM WebSphere 6.0, JDK 1.6, JIBX, CXF, Hibernate 3.2, Tibco EMS. Qarbon’s ViewletBuilder, ClearQuest, DB2 UDB

• Design and Develop Test Data Management strategy domain areas including processes, approaches, procedures, tools, and environment.

• Build Test Data Catalogue Solution Architecture.

• Design the data model for the Test Data Catalogue.

• Architect, Design, and Lead the Test Data Request application using IBM ClearQuest and DB2.

• Develop Test Data Cataloge viewlets for the training and knowledge transfer to the test data managers and leads.

Aug 2008 – June 2009 CitiGroup (Banking Industry): Sr. Data Modeler, Information Architect, Team Lead, Data Analyst.

Technology Used: Oracle RAC 9i, Erwin 4.5, AbInitio 1.15.6, IBM WebSphere 6.0, JDK 1.6, JIBX, CXF, Hibernate 3.2, Tibco EMS.

• Lead teams of DM and Data Analyst responsible for Payment System Data persistence Layer.

• Build Conceptual/logical/physical Data model for Central Activation System and Central Audit System and design the audit application using TIBCO EMS, JMS, BPEL, XSD, and XML.

• Wrote specs and design document to convert/migrate data from legacy to the new database system.

• Architect and design the data provisioning hub from CAS to the end system using SOAP Request-Response MEP using Tibco/Hibernate.

• Architect, design, and implement the complex data archiving and purging solution.

• Design the Payment Object Model and Data Persistence layer using J2EE/Hibernate/CXF/JIBX.

• Architecture, design, administration and performance tuning of Oracle 9.x RAC (three node)

• Review and provide recommendations as to system and data architectures, tools, and new technologies

• Status tracking, reporting and problem resolution, Root cause analysis of issues, issue escalation and resolution

Aug 2006 – Aug 2008 Circuit City (Retail Industry): Information Architect, Team Lead, Data Analyst, Data Modeler

Technology Used: Db2 LUW, Oracle 10g, WebSphere 5.0, WebSphere Message Broker, EJB 2.0, iBATIS, Oracle 360 Commerce, Sterling Commerce Yantra, WebSphere Portal, WPC, POSLog.

• Worked as an information architect for POS applications which includes application packages like 360 Commerce (now Oracle retail), Sterling Commerce Yantra, and StreamServe, including J2EE, ESB, Web-Services, DB2, SOI, SOA, BPEL, XSD, XML, and XPATH. Also, responsible for leading a project team in delivering solution to the customer. Also, responsible for managing scope, planning, tracking, change control, aspects of the project.

• Lead teams of DBAs and Data Analyst; responsible for Oracle Retail, Database and technical architecture, administration and performance tuning of a 7x24 mission critical applications, DB2 Replication.

• Implement WPC‘s MDM integration with the POS.

• Design and implement data Archive and purge Technical architecture for the store and central databases.

• Design store and central Database physical and logical design using ARTS data framework, Capacity and Scalability Planning, Backup and Recovery.

• Implemented Operation data reporting from different customer and sale data sources using an ODS layer.

• Review and provide recommendations to the Enterprise technical architecture strategy.

• Plan the data and software migrations including phase roll out and cut over.

• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Aug 2005 – Aug 2006 SunTrust (Banking Industry): Data Analyst, Data Modeler, and Data Architect, Data Steward, Data Warehouse Expert.

Technology Used: Db2 LUW, AbInitio, Cognos, Erwin, IBM BDW (Banking Data Warehouse), Erwin.

• Analyzed and data modeled the EDW (Enterprise Data warehouse) and Data Mart for Basel II Accord.

• Analyzed 30+ Source System data received from clients to ensure accuracy and completeness. Profiled Source system data using AbInitio Data Profiler and SAS DataFlux. Resolved data discrepancies and data cleansing as necessary. Defined Data Quality rules, participated in Data Steward and Data Governance.

• Build TPR central database from 30 plus desperate source system across LOB, these involved more than 15,000 tables; 65,000 data elements and; terabyte of data.

• Designed Enterprise Schema for Leasing application and build Logical and Physical Data Model containing 1500+ tables.

• Designed and developed Data Mapping Application for 30+ disparate source systems (COBOL, MS Sql Server, Oracle, and Mainframe DB2), using MS Access, and UNIX Korn script.

• Produced source to target mapping documents for 65,000 data elements based on data discovery results. Design the data masking application for 30+ source systems.

• Tuned Data Mart Reports using optimized query and Materialized Query Tables.

• Designed ETL Logic for EDW and Credit Risk Data Mart.

June 2005 – Aug 2005 Novartis (Pharmaceutical Industry): Data Architect.

Technology Used: Oracle 10g RAC, Linux.

• Performed TPC-C Oracle 10G RAC performance benchmark for NAS and SAN storage on Red Hat Enterprise Linux OS. Proposed database architecture design based on benchmark.

Feb 2004 – June 2005 MISO (Utilities Industry): Data Service Architect, Database Designer, Database, and Application Servers tuning specialist.

Technology Used: Oracle 9i RAC, Erwin, J2EE, and Spring Hibernate.

• As Database Tuning specialist Administrator/ Database Architecture, he is involved on the development/Testing/Integration and production databases for Client Project.

• As Performance Specialist he performed the application baseline and reviewed the client Oracle 9.x database architecture in respect with ORACLE-SUN-EMC Best practice methodology.

• As Performance Specialist he helped in designing, installation, and instrumentation Veritas i3 (7.2) and TeamQuest (9.2).

• Optimized database using different SQL queries and materialized views.

Mar 2003 – Feb 2004 GM (Automobile Industry): Database Architect, Database administrator, Data Modeler.

Technology Used: Db2 for Z (OS390), Oracle 9i, Erwin, InfoSphere DataStage, MicroStrategy.

• Designed and maintained the ODS, CDW, and Data Mart’s logical and physical data model to support NHTSA critical reporting needs.

• Implemented detail and efficient ODS and Data Mart.

• Administrated Databases Oracle 9.x (Sun Solaris) and DB2 7.x (OS390)) on the development/Testing/Integration and production databases for TREAD Project.

• Extrapolated, designed, and monitored database storage capacity planning.

Dec 2000 – March 2003 PricewarterhouseCoopers (Securities Industry): Database designer, Database administrator, Programmer, Data Analyst.

• Designed database architecture for development/Testing/Integration and production databases for nine client projects

• Designing Logical and physical data model.

• Lead a team for planning and Installing Oracle Database and client software across geography.

• Lead an effort to implemented application and database Security using database program, database roles, profiles, privileges, and views.

• Designed, developed, and implemented Data security using Oracle Advance Security package.

• Designed and setup Oracle SMTP process, Oracle LDAP.

Aug 99 – Dec 2000 Home Shopping Network (Media and Entertainment): Sr. Oracle Database Administrator, Data Modeler.

• Worked with five men team to administered, monitored and supported about 85 Oracle database instances in a large data center to support Internet development, PeopleSoft HR, Optum Warehouse management, Data warehouse, Rational Pro and custom web database systems. Configured and setup RMAN backups and EBU backups of Oracle databases using Netbackup on Solaris using Oracle 8i, 7.3.4 on Sun Solaris and HP-UX. Wrote UNIX scripts to monitor Oracle instances, Oracle database performance and free space. Upgrade Oracle 7.3.4 to Oracle 8.1.6 for 250GB database. Restored Oracle databases using RMAN and Netbackup from data file failures and disk failures. Restored corrupted table data using import files and custom application scripts. Designed storage capacity planning. Defined physical disk layouts using EMC disks and Veritas Quick IO.

• Used ERwin, CA dbVision, Toad, Sql navigator, CA iMonitor to manage the day-to-day database activities.

Feb 98 – Aug 99 Arthur Andersen (Consulting): Oracle Database Administrator, Programmer.

• Administered Oracle database running on Sun machines to support Oracle database for Arthur Andersen Worldwide Risk Management and Treasury Applications. The tools used are Oracle Enterprise Manager, Oracle Server Manager, Erwin 3.5.2, SAP Development Workbench (ABAP/4), Powerbuilder, Oracle Browser, SQL Plus 3.3, SQL Loader and Bourne shell scripts.

• Done Oracle Server installation, Database planning, Database creation, Configuration of middleware in Server & Client machine, Configuration of Client Machine, Server cache optimization, Space management, Monitoring of space usage, Security administration, Database Backup, Database Recovery, Monitored, Tuned database performance.

• Developed stored procedures and packages to convert large Legacy Data into Oracle Database. Developed data validation rules and code.

• Wrote shell scripts for automated backup of data files, batch jobs. Lead other team members with standard coding features for better performance. Wrote a cron script to delete more than 3 months old user traces and dump files. Wrote Bourne script to collect tablespace growth and insert the space growth in a table. Examined UNIX performance using UNIX utilities sar, vmstat, iostat, mpstat. Configured dbshut and dbstart for rc3.d

• Created Logical Model, Physical Model, Domain Dictionary, Trigger, Indexes, View, Procedure/Function, Pre/Post scripts using Erwin Data Modeling Tool.

Sept 1997 - Feb 1998 Thermax Software & System (Manufacturing) ORACLE DBA, Data Modeler, Programmer

• Worked as Oracle DBA for the applications aims at streamlining the different operations in Thermax Ltd. The Oracle database runs on Sun Solaris 2.3 and has following major modules 1) Foreign Exchange Invoicing (FEI), 2) Tax Deduction at Source (TDS).

• Created Data models and ER Diagrams through Erwin Data Modeling Tool.

• Administered Oracle installation, databases physical design, and database creation, and manage users; Laid down appropriate backup and recovery strategies.

• Involved in backup strategies, writing scripts for automated backup of data files, and Incomplete Database Recovery. Wrote shell scripts for automated Hot and Cold backups.

Dec 96 - Sept 97 Thermax Software & System (Manufacturing): ORACLE-SAP DBA, SAP Basis, ABAP-4 Programmer.

• Worked as an SAP DBA and BASIS Programmer SAP R/3 Material Management (MM), Production Planning (PP). As an NT-Administrator, created users and passwords, defined appropriate file systems, and wrote Batch scripts.

• Wrote Data Extract Program to extract Material Movements and Current Quantities in ASCII text file from SAP R/3 system and transfer the data file to Host legacy System (UNIX).

• Wrote Data Extract Program to extract data for Purchase Order created in SAP R/3 Material Management Module to the host system.

• Wrote BDC program to change address information for a vendor using the transaction code MK02.

• Created Domains, Data Element, Transparent Tables, Structure, Views, MatchCode.

Jan. 1994 - Dec. 1996 (Government): Oracle Database Programmer.

• Worked as Oracle Database Programmer /Designer. Involved in GUI Designing, coding, Unit testing, user training for INDENT, SUB-CONTRACT System. Wrote Database Stored Procedure, Trigger and Packages for Server side validation and for maintaining referential integrity of data. Involved in System Design, Programming, and design of GUI standards, testing. Migrated bulk data using SQL* Loader and Korn Shell Program

Education and Background

• Certified Oracle DBA, Certified SAP Consultant.

• MS in Computer Science.

• SOA Boot camp

Summary

• Industries: • Retail, Banking, Utilities, Securities, Media and Entertainment, Manufacturing Process, Government, Consulting.

• Project Domain: • Integration Architecture, Data Architecture, Data modeling, Database Architect, ETL design, Data Analysis, Application Development, Systems Integration, Performance Tuning.

• Hardware: • HP 9000, SUN 15k, IBM AIX servers, RS/6000, IBM Mainframes , PCs, Compatibles

• Operating Systems: • AIX,HP-UX, SUN Solaris 2.x, SCO Unix, Windows NT, Windows 95, Novell NetWare, IBM RS 6000, HP9000, Red Hat Linux 5.2, OS 390.

• Computer Languages: • SAP Development Workbench (ABAP/4), Powerbuilder, C, SQL, PL/SQL, Pro*C, Unix Bourne/Bash & Korn Shell using sed and awk programming language.

• RDBMS: • ORACLE 10g, 9.x, DB2 7.0 (OS 390), DB2 UDB 8.1 Oracle Personal Server, SYBASE 4.5-11.9.2, MS SQL Server 4.5-7.0.

• Development Tools: • SQL Workbench, SQL Navigator, Erwin, Quest suite, AbInitio Data Profiler, SAS DataFlux, DataStage, WebSphere Message Broker.

• Applications: • Microsoft Office 97, Microsoft Office 2000

• Training: • SAP Version 3.1H, a week training in Business Objects 4.0 (DSS), WebSphere Customer Center (WCC), SOA Boot camp

• Performance • TPC-C, Adlex, Veritas i3, TeamQuest

• Middleware • DataStage, AbInitio, WebSphere Message Broker, MQ, Tibco

Contact this candidate