Experience

• 10 years as Project Lead, Team Lead, Data Architect, Data Model Architect,
• Data warehouse Architect, Data Warehouse Designer and Database Developer and
• Business Analyst with strong UNIX, C and RDBMS background.
• Hardware Windows, Linux, SGI and Sun Servers.
• Operating
• Systems Linux, IRIX, Solaris, UNIX, Windows
• Languages ABAP, C , C, Java, Perl, Python, COBOL, T-SQL,
• SQL, C/DB-Library, PL/SQL, SQL PLUS
• RDBMS Oracle, DB2UDB, Sybase, SQLServer.
• Others Scrum methodology, Oracle Designer 2000, ERWIN, MS Project, Siebel Tools,
• Oracle GoldenGate
• Familiar with WebLogic, JSP, EJB, Servlets J2EE , ODI,
• JDeveloper and Informatica PowerCenter

Confidential

• Architect for building the integrated database for customer facing Commerce Application Service. Data from multiple source systems like Siebel are replicated, transformed into simpler data structure and integrated into a single database using GoldenGate for 2-stage replication and PL/SQL. Developed an efficient and restartable data migration process to move more than 35 million records.
• Designed a system to validate order, subscription and entitlement data stored in multiple business applications to ensure that they are in sync at all times.
• Responsible for designing data warehouse solutions for integrating data from multiple source systems such as Siebel, Oracle BRM, home-grown applications and creating reporting data warehouse/data marts.
• Propose architecture solutions and decisions affecting data sources, data locations, methods of replications and reporting strategy.
• Investigate application systems including Intuit offerings to understand data and data models and proposing data integration sources and solutions.

Confidential

• Responsible for the Siebel Data Model.
• Responsible for the design of the data model, upgrades, EIM and Remote Docking Rules for all new application development for various releases. All schema changes are reviewed and approved by me.
• Siebel data model architect for the Siebel to Fusion data migration. Developed a number of architectural artifacts to support migration and acted as a Siebel data model consultant to various Fusion development teams and product managers. Advised Fusion migration developers on Siebel datamodel and application functionality.
• Lead a team of developers and QA for the development of the zero-downtime upgrade of Siebel using GoldenGate for replication and upgrade of Siebel SIA from version 7.8.2 to 8.1.1. on Oracle 11gR2. Provided technical guidelines and solutions, defined the architecture, resolved technical issues and completed the project. Conducted weekly meetings with onshore and offshore team.
• Advise customers through expert services, technical support and global support teams regarding schema, upgrade, docking rules and any custom extensions.
• Have worked on all releases from Siebel 2000, Siebel 7.x through Siebel 8.x.
• Advise application developers on configurations, upgrade requirements and performance issues.
• Responsible for performance tuning of the application and advising developers on search and sort specs when there are performance issues.
• Play an active role in recruiting candidates by reviewing resumes and interviewing candidates.
• Mentor and train junior members of the team in data modeling, EIM, Remote and Siebel Application functionality.
• Worked on a number of schema requirements in the CRM OnDemand Siebel Hosted model to support:
• Enable customers to customize screen names, view names, field names to suit their needs customizable views, fieldso Enable customers to extend the schema and the views on top of them customizable schema
• Enable customers to define/add their own values for List of Values for fields or change the values customizable list of values
• Internationalization and Localization of the application
• Multi-language support for both List of Values and text fields
• Charge customers based on their usage time and space of the system

Confidential

• Responsible for developing architecture/solutions for BI requirements from Finance users.
• Worked closely with Financial Analysts, Finance users, Sales users and Service users to understand their requirements and provided architectural solutions and design alternatives.
• Implemented a flexible solution for calculating Burdened Cost for Orders. Lead a team of ETL developers, Business Analyst and QA testers
• Responsible for developing a Cognos Cube solution to meet Finance BBB reporting requirements. Leading a team of on-shore and off-shore ETL developers, Cognos Cube developer, Report Developers, Business Analysts and QA testers.
• Part of BI Architecture Review Board. Responsible reviewing proposed changes to data warehouse, data mart and ETL process changes for all new and enhancement projects.
• Enterprise Data Architect for the NextGen BI Solution under development.

Confidential

• Received 'Outstanding Contributor Award' in Siebel Engineering Organization and CEO's Circle Award.
• Data architect/Data Modeler for CRM-OnDemand application and Siebel Repository based applications.
• Architected and developed a flexible Java based application architecture to validate the schema definitions contained in XML files.
• Developed utilities in Java to produce XML schema definitions from Siebel Repository in RDBMS system and from schema definitions contained in Excel spreadsheets. This was used in the Siebel's Nexus project next generation system .
• Created the schema for Oracle-Fusion CRM application based on the Siebel schema objects using Python.
• Worked on defining the architecture for Fusion CRM schema development.
• Developed training courses for teaching schema development to data modelers and conducted training courses.
• Responsible for the data model design for supporting multiple languages internationalizations , translation support for seed data and Universal Time Coordinated GMT Time support .
• Data Architect Data Modeling for a number of application areas. Responsible for converting Marketing/User/Developer requirements into logical and physical schema. This includes design of logical and physical data model and implementation of schema definitions in the Siebel Repository.
• Architected, designed and maintained a schema validation tool to validate the schema definitions in the Siebel Repository. This tool is based on more than 300 rules to ensure validity, consistency and adherence to specified schema standards. This tool is being used extensively in the engineering group. A patent application is being processed for this tool. This tool was featured in the front page of the corporate internal site for all employees. Subsequently ported the rules from Oracle to DB2UDB.
• Defined the processes for implementing a branch-based development process for data model related areas, coordinated the development and testing of the programs and co-authored the Development Guide for users. Implemented and supported the branch based development process.
• Mentored and trained a number of data modelers.
• Subject Matter Expert for schema and responsible for resolving data model related questions and issues from customers, data modelers and application developers.
• Part of UAN-Common Objects team. Participated in the development and definition of some of the common data models. Acted as a consultant from the Data Model Group for the UAN group.
• Responsible for entity and data mapping of SAP and Oracle applications to Siebel applications. This involved understanding the ERP systems' entities, tables and columns, their relationships and mapping those entities to Siebel data model. At the end of this exercise, identified new tables, columns, and indexes that have to be created in Siebel as well as usage of existing tables in Siebel. Identified special requirements that have to be implemented or handled in the Siebel applications to support the external application.
• Managed a number of projects involving multiple engineers and groups. Responsible for planning, development and implementation of those projects. Used MS Project for managing projects, their progress and for reporting. Lead a number of projects with direct and indirect reports.

Confidential

• Coordinated SAP IS-SW module implementation in the Sales Distribution module.
• Maintained Deferred Revenue Solution application and reports in SAP.
• Maintained Product line Expense Allocation Interface to SAP.
• Wrote, maintained and enhanced ABAP programs and reports.
• Business Analyst for Finance and Revenue group and supported reporting requirements of Finance and Revenue Users.
• Consultant to Data Warehouse Group on SAP based Product Licensing Design and its interface to DW project.

Confidential

• Data Warehouse Architect for the data warehouse team.
• Designed the database, architected and developed the processes for extracting data from SAP and creating the data warehouse and data marts running on Oracle in a Sun environment. This included processes for loading the staging tables and DW tables and building summary aggregation tables. Responsible for the production system support and ensured 7x24 system availability.
• Hand-coded ETL processes using Unix shell scripts and Perl programs and later interfaced with D2K ETL tools.
• Lead a team of 5 programmers. Managed the development project using MS Project, conducted review meetings and reported progress and critical issues to the management.
• Involved in the evaluation of data extraction tools like D2K, Informatica and Sagent.
• Responsibilities included studying SAP entities using SAP utilities and analyzing ABAP programs to understand the entities and their relationships in SAP application.
• Mentored and guided other programmers and developers.
• Developed reconciliation systems/processes between the DW and the ERP System.

Confidential

• Architect for the Data Warehouse processes and systems with Oracle Applications and MFG-PRO 25 installations as the back-office systems.
• Supported a large Sybase Database running the corporate data warehouse containing corporation-wide sales information. Responsible for the production system support and ensured 7x24 system availability. Developed reconciliation systems/processes between the data warehouse and back-office systems.
• Maintained and enhanced the Oracle PL/SQL and SQL Plus code and ETL tables to extract data from Oracle Manufacturing and Oracle Financial Application tables for the Sybase based data warehouse application.
• Designed, developed and implemented many systems to distribute the data from the Sybase data warehouse to multiple data marts located globally, using shell scripts and C/DB-Library. Developed a C/DB-Library based utility to selectively replicate data from the corporate data warehouse to regional data marts located in different countries.
• Supported a group of programmers in designing and developing downstream applications. Provided support to both technical and non-technical end-users across multiple divisions located in different countries.
• Responsibilities included Sybase database administration, performance tuning, Unix server operation, user support and application maintenance. Grew the application from using 2 RDBMS servers 1 Unix server to 2 Unix servers, 8 production RDBMS servers, 6 report workstations.
• Involved in the Sybase conversion from version 4.0 through system 11.
• Developed Sybase applications using DB-Library/C, Sybase Transact-SQL and Bourne Shell.
• Mentored new programmers.
• Lead a number of internal projects with contractors and employees.

Confidential

• Consultant at Sun Microsystems World Wide Financial Organization in Palo Alto, CA for their corporate reporting system.
• Worked with Sybase databases on multiple Sun Sybase servers containing world-wide financial and marketing data for SUN with source data coming from MFG-PRO applications and IBM Mainframe based applications.

Responsibilities: Unix and Sybase software upgrades, Sybase server installation and database administration, Software maintenance, bug fixing, performance tuning, data repair, data analysis and application development.

Used C and Bourne Shells, Sybase tools and C/DB-Library.

Confidential

• One of the Project Leaders for the Total Branch Automation Project in a large bank in India. This project used Sybase and C with DB-Library and APT-Library.
• Systems Analyst/Designer, Programmer, Database Administrator and System Administrator for the in-house software development team.
• Regularly conducted classes for EDP group members of the bank and for EDP Auditors from the Indian Banks Association in Unix, Shell Programming, Sybase and Unify RDBMS, C, Unix system administration and system security.
• FOREX Dealing Backup, Merchant Transactions Accounting System Designed and developed an online system at the International Division of the bank's HO for accounting, control and follow up MIS using Unix/C/RDBMS.