SUMMARY OF QUALIFICATIONS:

• More than twelve years of experience in IT with seven plus years of experience in managing and leading DW/BI efforts from requirement gathering to its implementation.
• Significant business knowledge in finance, telecommunications, manufacturing and the service industry.
• Large amount of experience gathering user requirements and translating them into technical and system specifications. Managing clients, vendors, and partner relationships.
• Extensive experience as a solution architect for business information systems, focusing on database architecture, data modeling, data analysis, software design, programming and application integration.
• Very good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
• Experience with Relational and Dimensional data modeling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach
• Provide tier-1, tier-2 and tier-3 level support and track issues/requests for system enhancements.
• Application integration using service-oriented architecture (SOA) to implement new computing modules, web based client modules and on-demand computing.
• Strong “hands-on” knowledge with application development, DW platforms and databases (Oracle 10g, Teradata, MS-SQL, Sybase, dBase): data warehousing, application software SDLC and business reporting.
• In-depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
• Experience in developing Strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Center (8.5.1/7.1/6.1)
• Oracle administration skills and knowledge of RMAN, RAC, database backup and performance turning.
• Experience with Informatica Power Center -Designer, Workflow Manager, Workflow Monitor and Repository Manager including administering, designing, developing, deploying and supporting ETL processes.
• Experience in UNIX and Windows environments, as well as operating system specific shell scripting and development using C/C++ with UML and OOAD Methods
• System administration skills such as installation and configuration, IIS installation & management, performance tuning, troubleshooting, and configuring client software on Windows, UNIX, and Linux.
• Experience in configuration management: Identifying and controlling the release of a product and its changes. Ensuring completeness and consistency of product among components. Managing the process and tools used for builds and making sure every defect has traceability back to the source
• Development and use of Quality engineering tools such as software inspections, facilitated design sessions, etc.

CERTIFICATION:

• Oracle Certified Professional: Oracle 9i Database Administrator.

TECHNICAL SKILLS:
Operating Systems: Windows 2000/ NT, HP UNIX 3.2.2, Sun Solaris 7, OS/400, Novell 3.1.
RDBMS: TeradataR5V6.1 (FSLDM), Oracle 10g (PL/ SQL), Microsoft SQL 2000, Sybase 11, D2K Forms 4.5, Reports 2.5, UDB/DB2, MS Access.
Data Modeling tools: ERWIN 4.1 & R7, Agilian (Agile Modeler),MS Visio.
Business Intelligence: Informatica 6.2-8.5, Business Object 5.1.8, Actuate 4.0., Cognos 8.
Development Tools: Microsoft .NET/ Visual Studio 6.0, (VC++, VB, VBScript, JavaScript), Macromedia Dream weaver, Fireworks, Broad Vision 5.0.
Management Tools: Staff Ware 8.0 - Workflow Management tool, Saperion - Document Management tool.
CRM Tools: Clarify, Siebel.
Languages: C++, C, ASP, HTML, Java, JSP, EJB, Shell Scripting/Programming (UNIX), Pro*C, Basic, Cobol.
Tools/Utilities: TOAD 9.0, Objectory 3.8, MKS Source Integrity 7.3, Purify 5.0 for Windows NT, Visual Coverage 1.0, and Visual Source Safe 6.0.
Softwares/ Packages: MS Proxy Servers, DNS Server, MS Internet Information Server (IIS), MS-Exchange Server, and Crystal Report, Clarity.
Middleware Technology: COM/ DCOM/ ActiveX/ ISAPI.
Methodologies: Unified Modeling Language (UML), Object Modeling Technique (OMT), by Rumbaugh et al., Soft System Methodology, and Nimsad.
Network & Security: SSL, network protocols- FTP, telnet, HTTP(S), and SSH, Public Key Infrastructure (PKI), Encryption with US Data Encryption Standard (DES), PGP, RSA Digital Signing in accordance with RSA Data Security Inc, Public Key Cryptographic Standards (PKCS#1), Hash functions SHA-1/MD5.

PROFESSIONAL EXPERIENCE:

Dec’08 – till date Confidential, San Ramon-CA, USA
Sr. Technical ETL & DW/BI Architect

Project: CCPM – Contact Center Performance Management - Productivity Data Mart 
Confidential initiated the CCPM program to support the improvement of business operations and individual performance. The system is designed to provide common data source, with standardized definitions and data elements that support enterprise wide Consumer operations, performance management and centralized reporting information for managers to efficiently integrate and analyze data in a timely manner. Program allows AT&T to analyze data, from the employee to enterprise level, across functional perspectives such as operations, sales, quality and customer care. 

Responsibilities:

• Liaise with business subject matter experts in analyzing business requirements (Productivity related – KPIs), understand the various data sources.
• Architect the productivity data mart. Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g.
• Develop strategies for use in high volume, high performance heterogeneous environment.
• Map source data elements from various systems like – Avaya, CMS-Customer Management System, Outbound dialers, SBR, and IVR to CCPM and develop, test, and support extraction, transformation and load processes.
• Analyze source data related to Work force, Call Stats/Productivity, Contact, Contact quality, Training , Hierarchy Final, Coaching. Applybusiness rules to the data in the raw data mart and load it to the reporting data repository.
• Defines and captures metadata and rules associated with ETL processes in Informatica.
• Design and develop the technical/functional specification for ETL development and implement using Informatica. Analyze dependencies for workflow for various ETL processes, handle exception, and maintain logs.
• Manage artifacts - versions, including software code, documents, design models, and even the directory structure itself.

Environment: UNIX,Teradata, Oracle 10g – PL/SQL, Erwin DM r7, TOAD 9.5, Informatica Power Center 8.1.6, network protocols- FTP.

Project: RxDE - Data Warehouse (Healthcare- Automated Patient Notifications)
Confidential provides the on-demand software and services by enabling delivery of automated communications to patients over the phone, through text messages or email that helps pharmacies reach more patients while avoiding the excessive time and money a traditional communications approach would require. Data warehouse is designed to manage and support clients (pharmacies) patient information eg. Personalized reminders, including refills, tardy notifications, renewals, auto-fills and Rxs ready for pick-up 

Responsibilities:

• Liaise with business subject matter experts in analyzing business requirements and translating them into detailed conceptual data models, process models, logical models, physical models and schema development in the database.
• Model & Architect DW design, direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process in Informatica.
• Architect the database schema and implement dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g.
• Map source system data elements to target system and develop, test, and support extraction, transformation and load processes.
• Based on business rules, load health (medical prescription) related data, develop Informatica mappings, create sessions, workflows to load and process data received from pharmacies.
• Defines and captures metadata and rules associated with ETL processes.
• Manage artifacts - versions, including software code, documents, design models, and even the directory structure itself.

Environment: UNIX SunOS 5.10, Shell Scripting, Oracle 10g – PL/SQL, Erwin Data modeler r7, TOAD 9.0.1, Informatica Power Center 8.5, PGP Encryption, network protocols- FTP, telnet, HTTP(S), and SSH.

July ’07 – May’08 Confidential, California, USA
Senior Lead Consultant and Data Architect (GDW)

Project: Enterprise Data Warehouse
Confidential is the largest direct response marketing television company. It started as a television direct marketer with focus on every area of electronic retailing, making quality products available to American and international consumers through broadcast television, cable and satellite, as well as the internet, telemarketing, direct mail and retail channels.

Responsibilities:

• Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
• Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.
• Facilitate Joint Application Development (JAD) sessions for gathering requirements for building a data warehouse and data marts.
• Participate in development and execution of tactics and strategies to optimize data quality in data warehouse, and OLAP environment.
• Create and design logical and physical data models using ERWIN– identify entity & its relationships and define the project’s informational needs. Design Source to target mapping as per the requirement of the client and business rules to load the data from ODS to Data Warehouse.
• Architect the database schema and implement a relational (for ODS) and dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g.
• Lead the application development team in providing support & maintenance of data marts and data warehouses. Maintains the integrity of data movement into the data warehouse and other environments
• Worked on Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets and Reusable Transformations.
• Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes – define mapping, sessions and workflow
• Defines and captures metadata and rules associated with ETL processes
• Review and analyze database performance, cubes and reports generated using Cognos.

Environment: UNIX, Shell Scripting, Oracle 10g – PL/SQL, Erwin Data modeler r7, TOAD 9.0.1, Informatica Power Center 8.1.1., Cognos 8.

May ’05 – May’ 07 Confidential, 
Lead Consultant

Project: Basel-II, Risk Weighted Analysis (GDW)
Confidential are Singapore’s leading banks. They have initiated BASEL-II projects in implementing risk management standards under new global banking rules.

Responsibilities:

• Manage and support development of the banks’ Global Data Warehouse (GDW) and Data Mart (DM) which sources data from the banks’ global data warehouse.
• Work closely with the Business group in determining business requirements and facilitate the computation of Risk Weight and segmentation for stress testing and back testing as part of the Basel II accord.
• Perform requirements analysis: Interact with business analysts to get functional requirements, interact with end users to determine reporting needs, and conduct discussions with the project team to identify additional requirements.
• Create and Maintain FSLDM, a conceptual data model, a logical data model, and a physical data model in ERWIN. Design a dimensional data model and perform Star Schema/Snowflake Schema modeling for data mart. Create FACT and Dimensions tables.
• Identify data sources (UDB/DBW, Oracle, MSSQL) , design and develop the technical/functional specification for ETL development and “the Data Warehouse (DW)” of banks’ various applications (Customer information, Loans, Trade Finance, Credit Cards, Treasury etc). Generate the necessary DDLs for creating the Database Objects (Tables, Views, Stored Procedures, and Triggers).
• Utilized Informatica Server Manager to create, schedule and monitor sessions and send pre and post session emails to communicate success or failure of session execution. Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance
• In informatica created mappings and utilized aggregate, expression, lookup, update strategy and router transformation. Utilized joiner transformation to extract data from multiple sources. Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Writing complex queries for loading and extraction data using Teradata development utilities. (Fastload, Mload, FastExport, etc.)
• Provide subject matter expertise to systems programs in the form of knowledge of data systems, interpretation of source data including data cleansing, data testing and validation in multiple systems
• Configuring, Monitoring and managing batch processing jobs using Control-M graphical tool.
• Liaise with the vendor on interface development and its implementation and provide support for Tera data, Oracle, Informatica ETL code migration, troubleshooting for DEV, SIT, UAT and the production environment.

Environment: UNIX, Shell Scripting, Oracle 9i, C++, PL/SQL, Informatica Power Center 7.3, Toad, Tera dataR5V6.1 (FSLDM) Utilities- Fastload, Mload, FastExport, ERWIN v4.0, Control-M.

Jan ‘04 - Apr ‘05 Confidential 
Technical Consultant/Project Leader

Project: Partner’s Data Warehouse (PDW) (Decision Support System) 
Hewlett-Packard (HP) is Asia-Pacific’s leading provider of products, technologies, solutions, and services to consumers and businesses. HP maintains a comprehensive Partner’s Data Warehouse that sources data from multiple systems, including data on Partners, Products, Sales (shipment, Sell-to, Sell-thu), Inventory, Orders and Revenue. The data caters to business groups within HP for the Asia Pacific Region.

Responsibilities:

• Implement and carry out application specific development and enhancement.
• Ensure that ETL jobs are running without any problems and data is available to users in real-time.
• Model and design the database using agile development method. Create and document logical, physical and dimensional data models (data warehouse, data model).
• Work closely with IT: the infrastructure team, network team, and business and management group to develop architectural procedures, processes and standards. Provide production support and enhancement to the Partner’s Data Warehouse (PDW).
• Provide Tier-2 level support 24*7 to PDW’s large Asia Pacific user base (business partners of HP), and maintain the data infrastructure (data dictionary, mete data, model repository).
• Design, develop and provide support with Business Objects (BO; User, Designer & Supervisor).Maintain the BO web site. The site dynamically provides data loading status and business intelligence report objects supporting end user business requirements
• Execute, analyze and write PL/SQL queries in Oracle 9i to verify data and reconcile Business Intelligence (BI) reports.
• Architect and adapts ETL processes to accommodate changes in source systems and new business user requirements.
• Manage a team that provides system support to business partners, the customer service group and the data warehouse group.
• Managing different versions of releases made, controlling the changes imposed, and auditing and reporting on the changes made.
• Report regularly on the level of support for Call Handling, Turn-Around-Time (TAT), and Service Requests handled.

Environment: HP UNIX, Oracle 9i, PL/ SQL, C++, VB, ASP, HTML, Toad 7.2, Shell Scripting. Agilian Software (modeling), ERWIN 4.0, Informatica Power Centre 6.2.2, Business Object 5.1.8, Data Stage 3.1

Jun ‘03 - Dec ‘03 Confidential
Solution Architect/Senior Consultant

Project: Provisioning System (Digital TV) 
Confidential is a media and Infocomms Company with a nationwide broadband network. They offer many services including cable TV through wireless delivery via UHF (ultra-high frequency) and MMDS (multi-point, multi-channel distribution system). The company is extending its cable TV services by offering digital TV service to subscribers in Singapore.

Responsibilities:

• Responsible for designing the solution and leading a team, user training, maintaining the digital TV provisioning system interface and providing system support to the customer service and warehouse groups.
• Work closely with IT and business analysts in determining system requirements.
• Model and design the database for production. Create logical and physical data models and implement the database.
• Architect, designand develop UNIX shell scripts and daemon processes to communicate between the Order Management (Inventory) and provisioning systems for Digital TV
• Plan, coordinate and liaise between users and the development team.
• Develop and implement new service oriented modules (daemon processes) for the Provision Manager/ Provision Updater to process orders and inventories.

Environment: SUN Solaris, Oracle 8i, PL/SQL, Arbor OM/BP, Falcon Informatica 5.0, Crystal Report 9.0, Microsoft VC++, C++ Orale Template Library, Pro*c.