Summary & Objective

Technical Architect with 7 years of substantial hands-on experience implementing and supporting OLAP and relational systems, data warehouses and marts (in excess of 6 business intelligence systems using a multitude of database technologies, analytical tools, and user interfaces).

Has deep knowledge of project planning, cost and schedule management, requirements analysis, risk analysis and management, project diagnosis and recovery. Excellent communication skills; adept at multi-tasking and thriving in a fast-paced environment while implementing time-sensitive projects.

A career spanning 5 years with Tata Consultancy Services; Asia’s largest consulting company, a CMM level 5 organization. A trained auditor based on ISO 9001 2000 model, have been involved in Six Sigma implementation.
Proactive team player recognized for reliability, professional demeanor and strong work force ethic.
MS in Computer Science.

Skill Set

Database : Sql Server 2000, Oracle 8i/9i database, DB2 UDB, NCR Teradata V2R4, Oracle 9i lite for
Palmtops.
OLAP : Cognos EP V7.0 (Powerplay, Impromptu, Upfront), Microsoft Analysis Services, Microsoft Data Transformation Services, Excel 2000, Business Objects 5.0 and Web Intelligence 2.7, Oracle Discoverer 4i, Oracle Express Server 6.3.2, Express Web Agent, RAM/RAA.
ETL : Microsoft DTS, Informatica Powermart 6.0, OADW (Oracle Application Data Warehouse, previous to OWB from Oracle), Oracle PL/SQL, SQL Loader.
Web Tools : ASP.Net, C#, Visual Basic.Net, Javascript, PHP, HTML, CSS, XML
M Commerce : Microsoft Visual Studio.NET 2003, Microsoft Compact Framework V1.1 , Pocket PC 2003 Simulator, Microsoft Pocket PC 2003 SDK, Microsoft Active Sync 3.8, Oracle 9i lite for Pocket PC 2002, Web-To-Go, Branch office.
Client Server : Visual Basic, Oracle Forms and Reports (6i).
Application Servers: Oracle 9i AS, IIS, Lotus Dominos Server 5.0.10
OS : HP UNIX 10.7, MPRAS UNIX, Windows NT, Windows 2000, Windows CE
Tools Focus : TOAD 7.0, SQL Erwin, Visual Source Safe


CAREER PROFILE

Description May 04- till date
Project Performance Corporation (PPC) has developed PT Tracker, an advanced enterprise web usage-tracking tool designed specifically for Plumtree. PT Tracker tracks and analyzes a variety of activities at a click-by-click level of detail, including taxonomy browsing, community visits, keyword searches, portlet execution and document reads. The tool empowers portal administrators, knowledge managers, and business analysts to get important feedback on the portal’s actual performance, instead of relying on human responses such as questionnaires. It takes only about a week to deploy. It has been developed for logfiles generated by IIS Server for Plumtree V4.5/V5.0 and both Oracle /Sql Server databases. PT Tracker has been implemented for clients General Electric, IHSSolutions, Solectron, American Standard, KSA, ALA Tracking and DFAS.



Role: Technical Architect
Data quality analysis, perform feasibility analysis and conceptual design, project planning and monitoring, capacity planning for the data warehouse, logical and physical design of staging area and star schema, performed dimensional and 3NF modeling according to enterprise standards, identification of hierarchies and fact tables, design of multi dimensional database, extraction transformation and loading of data using UNIX and PLSQL scripts for Plumtree portal Oracle database and Microsoft DTS for Plumtree portal Sql Server database, track these events at a very granular level - individual users and cards, summarize data and present it at higher levels, including user groups and taxonomy branches, regular interaction with client for requirements, validation, performance and data reconciliation issues, backup and recovery requirements, performance and process improvement of the system .
Technology
.Net Architecture: Server 2000 in enterprise or standard edition and its built-in BI capability called Analysis Services, DTS, Microsoft Excel 2000 or XP or Data Analyzer.
Oracle Architecture: Oracle V8.0 or higher, Unix and Oracle stored Procedures for ETL, Cognos EP V7.0 (Impromptu Administrator, Cognos Transformer for creating cubes, Cognos Server Administration for publishing the cubes)


Client: Tietronix Software Inc, Houston Jan 05- May 05
Tietronix Software has developed a Wireless multithreaded Mobile Technology Application that allows a user to monitor his/her weight during an exercise program displayed as a graph on Pocket PC platform. The weighing machine (transmitter) will send valid real time data, the user’s current weight. PDA/PC (receiver) will capture the data and display a graph with the patient’s progress.
Role: Technical Architect
Implement MVC (Model View Controller) architecture used for the design and development of application, synchronous data transfer between transmitter and receiver using TCP Connection,
Multithreading used to facilitate synchronous read and write of shared memory using Mutex Class, message queue implemented for communication between Graph Module and Receiver module, singleton design pattern used for shared memory object and configuration wrapper object, valid data packets were received and displayed in a graph, Invalid packets received are logged and discarded, log file is maintained for the application whose contents include the timestamp, weight and reason for discarding the packet, automatic refresh of Graph to display the new data point that is captured for the logged user, dynamic scaling of graph within the range of the maximum and minimum value of the captured weight.
Technology
.Net Architecture: Microsoft Visual Studio.NET 2003, Microsoft Compact Framework V1.1 , Pocket PC 2003 Simulator, Microsoft Pocket PC 2003 SDK, Microsoft Active Sync 3.8, Programming Language – C#


Client: University of Houston Aug 03- May 04
University Of Houston-Clear Lake came up with an initiative to develop Course Registration System (CRS) which allows new students to sign-on, store personal information, search for courses, add new courses, drop registered courses, and check status of courses registered, The system must do form data validation based on predefined criteria.
Role: Technical Architect
Capture new and existing business requirement, design and development of relational data model, design of logical and physical Data model in Visio 2000 and ER win, design of web forms, responsible for preparing URS (User Requirement Specification), SRS (System Requirement Specification), SDD (Software Design document), writing and executing unit test plans and system test plans, testing of Web Forms, implementation of the system.
Technology
ASP.Net, C#, HTML, CSS, Oracle 8i, Erwin 3.5.2, Toad 7.0



Client: Tata Sons Jun 02- Aug 03
Tata Sons has decided to undertake a Work Level Assessment across its Group companies. A repository of information was collected during the assessment, which is secure and would enable the Group HR to identify and place managers at required positions across the Group.
Role: Technical Consultant
Perform Data Analysis work for new and existing business requirement, design and development of Dimension Data Model (Star Schema), design of logical and physical data model in Visio 2000 and ER win, design dataflow diagram, data cleansing, assigning and enforcing standard naming convention for data warehouse components, conducted JAD (Joint Application Development) Session, conducted Code walk through sessions, writing and executing unit test plans and system test plans, metadata management.
Technology
Business Objects 5.1.4, Web Intelligence 2.7, Lotus Dominos Server 5.0.10, Oracle 8i, Erwin 3.5.2,
Informatica Powermart 5.1, Toad 7.0


TCS Oracle 9iAS Applications R&D Group Jul 01– May 02
Tata Consultancy Services initiated Oracle 9iAS R & D Group with an objective to develop expertise in Oracle Portal, Oracle 9i Lite. Developed a Mobile Commerce Solution using Microsoft Windows CE and Oracle 9i Lite on Pocket PC 2002.
Role: 9i Lite Technology Expert
Capacity Planning for Central Server database, designed, developed and implemented Microsoft Windows CE application to capture and analyze instore data on Pocket PC 2002, logical and physical design of the relational database, Seamless data transfer from PDA to the Central Server using wireless technology and Oracle 9i Lite software, developed and published web enabled reports using Discoverer 4i and Oracle 9i AS
Technology
Oracle 9i AS, 9i lite Components like Web-To-Go, Branch office, Discoverer 4i, Pocket PC 2002, and Toad 7.0


Client: US Federal Government May01–Jun 01
The project, TRICARE ENCOUNTER DATA (TED), is for the U.S Military Health Care Services. It basically deals with the health Insurance for the families of the military personnel. The federal govt. wanted to revamp the system, which was currently in Mainframes and move into a new system with major changes in business requirements. We did a one month high end consulting for them and came out with a solution that would best suit their new requirements and new environment. The team comprised of 3 consultants.
Role: Strategic Consultant
Was responsible for High End Consulting Engineering Analysis study for U.S Military Health Care
Services involved the following:
• Understand existing Purchased Care System functionality.
• Consolidate the high-level requirements of the proposed Tricare Encounter Data program.
• Review and validate the TRICARE Management Activity (TMA) Aurora approach in terms of development roadmap.
• Provide recommendations on Technical architecture, Development roadmap, Software and Hardware recommendations, Implementation methodology, Cost Estimates and Timelines.



Client: Kellogg’s , Japan Jan 00–May 01
Kellogg, Japan has initiated the Kellogg Performance Activity Tracking System (K-PAT System) project with a view to collect the data in Stores, Headquarters and Wholesalers in a computerized environment using M-Commerce. It was to aid the salespersons and Merchandisers the capability to collect data in a convenient way and analyze the market trends instantly.
Role: Implementation Site Leader
Was involved in the entire project from conceptualization to implementation of K-PAT System. Designed synchronized data transfer through pay phones/mobile phones/modems to the Central Server using Active Sync. Multiple synchronizations using xtndconnect software. Facilitate data analysis with the help of static and ad-hoc reports. The reports were published to IIS. , Project planning, task allocation and progress review, Customer status reporting were the part of the standard job.
Technology
Visual Basic for Windows CE for Palmtops and Handhelds, Developer 2000 (6.0) for Web enabled Forms and Reports, Discoverer 3i for Adhoc Reporting, Toad 7.0.


Client: Kellogg’s, USA Jan 99–Dec 99
Kellogg had initiated Enterprise Global Application Decision Support Suite (EGADSS) project with a view to build an Enterprise Data Warehouse storing information on various subject areas to enable them to perform cross-functional, cross-geography decision making and analysis and provide multiple perspectives of the information in the data warehouse. Integrated Business Planning (IBP-1) application had the objectives to aid the Kellogg’s Operations team in tactical and strategic decisions based on the absolute and relative performance of their Production, Shipments and Inventory functions, to provide multiple perspectives of the information in the data warehouse.
Role: Implementation Site Leader
design multi dimensional database, prepare unit test plans and low level design documents,
generate ad-hoc and standard production reports via RAM mappings by fetching the data from the hybrid
architecture made up of the Oracle Express MDDB server and the Oracle 8 Relational data warehouse,
wrote SQL scripts and UNIX scripts, prepared the audit trail tracking functionality, delivery of Integrated
Business Planning (IBP) into acceptance/ production.
Technology: Oracle Express Server, Oracle Express Objects, RAM/RAA, OADW, Oracle 8, PL/SQL, UNIX.

Client: The Trane Company Jan 98 – Oct 99
Description
Computerized Parts List (CPL) is a requirement for After Market Business Unit of TRANE. The purpose of the system is to print parts list for a particular product in various different formats. It is also used to print the name plate, and to query on the CPL database.
Role: Team Member
Was responsible for unit test plans, low level design , testing and documentation of Computerized Parts
List System.
Technology
Oracle Forms 4.5 and Reports 2.5