PROFILE

• Innovative software professional with 20 years' experience in building and maintaining client relationships, pre-sales, consulting, business intelligence, data warehouse, analytics, data marts, enterprise architecture, information strategy, data architecture and data integration
• Extensive experience to manage, design, mentor, develop and test large scale multi-year implementations working with team of vendors and global delivery model onsite/offshore
• Good experience in project management, recruitment, vendor management requirements gathering, analysis, capacity planning, MDM, design, development, implementation and testing of large scale implementations
• Design data warehouse architecture, logical data model, physical data model, conceptual data model, relational data model, dimensional data model, star schema, snowflake schema and data flow doc. Implementation experience of normalization rules, de-normalization, IBM IIW, Kimball methodology and Inmon methodology
• Design framework for data processing and mentor a team to develop ETL jobs, cubes, database procedures, functions, triggers, job schedules, olap cubes, BI reports, BI templates, shell scripts, install database, configure database, tuning queries and performance tuning
• Expertise in financial domain - core banking, investment banking and insurance data marts for Fixed Income, Derivatives, Marketing, Retention, Campaign management, BASEL II Risk management, AML, Management Dashboard, Repo, Insurance claims, Equity risk, Credit VaR, Credit Scoring
• Data Quality Create and validate data cleansing, governance, standardization, validation and transformation rules
• Methodology - Extensive experience in prototyping, RAD, SSM, SDLC, JAD, Iterative development, structured techniques, meta data management and data mapping
• Management Hands-on as well as good team mentor skills. Prepare project plans, project costing, cost-benefit analysis, as-is-scenarios, present value analysis, resources plan, project schedules, project proposals, test plans and test schedules. Conduct interviews, project reviews, training, tools evaluation and selection
• Good written, presentation and verbal language skills. Ability to learn very quickly and apply new skills to existing problems. Self-starter.

Specific tools and techniques

ETL Ascential Datastage, Informatica Power Center, XML, SSIS, DTS, SQL Loader, External Tables, Oracle warehouse builder, BO Data Services

BI Tools Micro strategy, Business Objects, Hyperion, SSAS, SSRS, Crystal Reports, MS Excel

Data Modeling ERwin, Microsoft Visio, Oracle Designer, Embarcadero

Database Admin Toad, OEM, SQL Plus, SQL Advantage, SQL Server Management Studio, SQL Server Enterprise Manager

Databases Oracle, SQL server, Sybase, Microsoft Access, DB2, Greenplum

OS Sun Solaris, Windows, NT

Languages PL/SQL, T-SQL, Shell scripts, Basic, C, XML, HTML

Methodologies Agile, Waterfall Method, RAD, JAD, SSM, Prototyping, Iterative development

Configuration Management MS VSS

Project Manager

Work Experience

Confidential Worked with multiple clients in insurance and derivatives for information strategy roadmap pre sales discussions data warehouse, data marts, data integration solutions regulatory compliance framework and mentor off shore resources

• Proposal making, pre-sales discussions with client senior management, problems analysis and solutions presentations
• Information strategy roadmap for a group insurance company
• Data warehouse framework for a property and casualty insurance company
• Mentor a team of client staff, PwC and offshore SDC resources to build claims data warehouse for a property and casualty insurance company
• Effectively use agile process program, epics, stories . to deliver a set of 100 reports for a property and casualty insurance company
• Develop data warehouse framework to be used across multiple clients
• Help a client to meet their regulatory requirements by analyzing problems in regulatory reports terabytes of data , deficiency in reporting process and reporting data

Environment

Oracle 10g, Microsoft business intelligence suite, SQL server 2012, Greenplum, Erwin 7.0, TFS, Microsoft Visio

Confidential

Data Warehouse Architect

Lead a team of 20 people to design, develop and implement a data warehouse and data marts to move data in real time and nightly from host applications of Fixed Income/Repo. Data warehouse sourced data from 8 different applications.

• Architecture - Lead a team from conception to production of a data warehouse which support transaction, analytical and reporting needs of users. Prepare, discuss and get approval for Roadmap, SOA, logical architecture, physical architecture and data flow diagrams for data movement in batch and real time.
• Requirement Analysis - Requirements gathering, BPM, interviewing, reports study, Q A sessions. Document findings of requirement analysis phase.
• Data profiling - Data statistics, data analysis, identify integration rules to join data from different sources. SQL queries/scripting.
• Data Modeling - Conceptual model, Logical model, physical model. Indexing and partitioning strategy. Data Mapping, Data Dictionary, Meta data management. Naming standards. Manage and maintain data standards and definitions. Design and develop data taxonomies and relationships. Develop schemas for staging area, operational data stores, data warehouse and data marts. Kimball methodology.
• ETL jobs development - Design and develop ETL jobs for Initial load, nightly jobs and real time data movement. Jobs to reconcile real time data with batch loads.
• Testing using HP QC Center - Design test cases, document test results, track defects and prepare management reports.
• Project Management Agile, SCRUMS, Project plan, Project scheduling, project reviews
• Documentation/Hand over - Prepare standards document, framework document, assumptions document, share and gain acceptance of all stakeholders.

Environment

Oracle 10g, Business Objects 3.1, Informatica 8.1, Erwin 7.0, HP QC Center, Microsoft Visio., Sun solaris

Confidential

Data Warehouse Architect

Confidential start-to-end design, development and implementation of data warehouse batch and real time and data marts including requirement analysis, data analysis, data modeling, ETL job design and development, database development and administration, production support and performance tuning.

Responsibilities:

• Conduct user interviews, hard fact study, JAD sessions for data warehouse, policies, quotes, claims, underwriting data. Do data profiling, statistical analysis, As-is-scenario and capacity planning. Prepare data dict, gap analysis and data mapping sheets.
• Design conceptual, logical physical data model for relational dimensional database. Design star schema and snow flake schema for data marts. Conduct normalization and de-normalization of database, design walkthrough sessions. Prepare standards for data model, data acquisition, data integration, standardization, validation, transformation, interface files, and audit parameters. Kimball and Inmon methodology.
• Develop and mentor team to develop ETL jobs, cubes, PL/SQL stored procedures, functions, shell scripts, SQL queries, sql loader jobs to load ODS, data warehouse and data marts. Conduct performance tuning, sql tuning. Mentor team for meta data management, scheduling using Autosys, encryption, Sftp and security matrix.
• Create database, tables, users, indexes, partitions, roles, synonyms, tablespaces. Configure database and parameters for optimal performance
• Prepare project plan, project schedule, conduct project reviews.
• Mentor team for database installation, configuration, development, move ups from Dev to QA to Production and configuration management.
• Mentor team for production support, maintain problem logs, conduct reviews, enhancement of current jobs, automation, coordination with other departments. Backup and recovery strategies. Prepare resource plans, budget and monitor.

Environment:

Sun Solaris 5.8, Micro strategy, Ascential Data stage 7.5, Erwin 7.2, Toad, XML, MS Visio, Exceed, SQL server 2005, DB2, SQL Plus, OEM, Reflection X, VSS, MS BI Studio, MS Project Manager

Confidential

Data Warehouse Architect

Perform data warehouse enhancement and data marts development , production support, requirements analysis, data flow design, ETL jobs and database objects development, testing, implementation and enterprise standards. I was hands-on as well as led a team of 1 data analyst, 2 dbas and 8 ETL developers.

Responsibilities:

• Manage Requirement gathering sessions for enhancement to data warehouse and data marts by interviewing, hard facts study, JAD meetings with people across the management hierarchy. Estimate hardware size and efforts. Conduct project, requirements, design and code reviews. Kimball and Inmon methodology.
• Do source data analysis, data profiling, statistical analysis and gap analysis. Prepare data flow models, process models and data dictionary. Conduct data mapping sessions.
• Define increments for the projects, develop and implement increments. Enhance current data warehouse data model logical data model and physical data model using ERWin for relational and dimensional database . Design and implement standards for data acquisition, data integration, data quality, data standardization, validation and transformation.
• Write shell scripts, sql loader, PL/SQL stored procedures, functions, develop reports using Hyperion. Develop and mentor team to develop ETL jobs, cubes, management dashboard, database procedures, functions and reports. Prepare backup and recovery strategies.
• Prepare test plans for unit testing, integration testing, Module testing. Coordinate UAT.
• Resources planning, budget and monitoring. Performance tuning after installation. Mentor team for database installation, configuration, development and production support.

Environment:

Sun Solaris, Informatica Power Center, Cognos, ER/Studio, SyncSort, Oracle, Sybase, SQL server, , OEM, SQL Advantage, MS Visio, Exceed, VSS, MS Project Manager

Confidential

Data Warehouse Architect

Design data base architecture for data warehouse, prepare documents to get top management approval, design, develop, implement, monitor and enhance EDW and data marts. I lead a team of 3 dbas, 1 data modeler, 2 data analyst and 18 developers.

Responsibilities:

• Prepare project plan for data warehouse implementation, data warehouse enhancements and data marts. Project costing, cost-benefit analysis, project reviews. Hardware, software and manpower vendor's liaison. Proposal's presentation. Lead a team of 14 members.
• Prepare URS doc, data flow diagrams, data mapping, gap analysis, business rules, data dictionary, test plans, data profiling, source data analysis, capacity planning, data segmentation.
• Design logical and physical data model for relational data base, dimensional data base, ODS, data warehouse, data marts and OLAP cubes. Mentor team for meta data management. Kimball and Inmon methodology.
• Prepare and validate standardization, validation, transformation rules, data and process standards. Conduct data warehouse performance tuning and data replication. Prepare backup and recovery strategy.
• Conduct tools evaluation and resources recruitment. Prepare resources plan, project schedule, project reviews and project status reports for senior management.
• With the help of 14 member team develop data warehouse for core banking products and data marts for Credit Risk, Market Risk, Investment Risk, Management Dashboard, Campaign Management, Profitability, AML, Equity derivative, Credit VaR, Credit Scoring.
• Mentor team for requirement analysis, data modeling, ETL jobs, data base structure creation, database administration, performance tuning, documentation and production support.
• Perform migration of data warehouse from oracle 8i to 9i. Use big-bang approach and chicken-little approach for implementation.
• Prepare enterprise information architecture, As-is-scenarios, cost benefit analysis, present value analysis.

Environment:

Sun Solaris 5.8, Windows 2000, Oracle Warehouse Builder, DTS, SQL Loader, External Table, CoSort, BRIO, Hyperion, SSAS 2000, SSRS 2000, Crystal Reports, MS Excel, Microsoft Visio, Toad, OEM, SQL Advantage, SQL Plus, SSEM, Exceed, Oracle 8i, 9i, 10g, Sybase 11.5, SQL server 7, 2000, Microsoft Access, PL/SQL, T-SQL, Basic, C, HTML, XML, VSS, MS Project Manager

Confidential

Data Warehouse Architect

I was responsible to improve the physical design of database implementation, capacity planning, data migration and improve data warehouse load performance in oracle 8i.

• Install oracle 8i database on sun solaris server
• Analyze data loading patterns and data access patterns.
• Implemented data partitioning, indexing and parallel loads to fully utilize available hardware resources.
• Increased data warehouse load performance by disabling and enabling indexes, using parallel loads.
• Analyze requirements of various departments to estimate data growth and do capacity planning.
• Enhanced sql loader jobs for faster loading.
• Developed necessary triggers and procedures to monitor data loads.
• Data migration from windows server to sun solaris using db links.

Environment:

Sun Solaris 5.8, Ascential Data stage 4.2, SQL Loader, Toad, OEM, SQL Plus, Oracle 8i, PL/SQL, VSS, MS Project Manager

Confidential

Data Warehouse Developer

I worked in this project to develop data warehouse for Standard Chartered Bank Hong Kong as a team member in 7 people team. I was actively involved in data extraction, data integration, data quality and transformation rules.

Responsibilities:

• Design and develop ETL jobs using oracle warehouse builder. Data extraction was done using DELTA mechanism and month end extraction from various data sources.
• Verification of program standards to check compatibility with client's programming standards. Configuration management using Microsoft VSS
• As a part of maintenance and as per end users requirement, created new columns in the ODS
• Relational and dimensional data model using Oracle Designer
• User requirement study and develop end-user reports BRIO
• Unit testing, Module testing, Integration Testing, UAT
• Prepare Tech specs, data flow diagrams, test cases and results.

Environment:

Sun Solaris 5.2, SQL Loader, BRIO, MS Excel, Oracle Designer, Toad, OEM, SQL Plus, Oracle 8, 8i, PL/SQL, VSS

Confidential

Oracle Developer and Database Administration

I was actively involved in database objects creation, programming, database administration, database backup and recovery. The database size was 100 GB, number of users were 500.

Responsibilities:

• Prepared stored procedures, functions and triggers for database
• Installation of oracle database on windows and sun solaris server
• Oracle and Sybase database administration, database creation
• Backup and recovery with Veritas net backup, data loading, Import export
• Users creation, database security triggers, roles, privileges , shell scripting
• Performance tuning Memory tuning, I/O tuning, Sql tuning , Database auditing
• Application migration from Sybase to oracle using oracle migration workbench
• Created Oracle Forms and Oracle Reports
• Installation and configuration of database, Standby database and parallel server
• Designed and created the production database
• Database administration, Users requirement study
• Performance tuning and database re-organization activities using Toad, OEM