SUMMARY:

• Oracle Certified Professional (OCP) on four different Oracle Database verions, since 1998.
• Hands - on DBA, Data Architect and BI/DW professional, expertise in both production and development environment.
• Worked with Oracle 10G, 11g, on database clusters (RAC), expert in database/SQL tuning, PL/SQL coding.
• Confidential has over fourteen years of experience in different phases of design, development, implementation and performance tuning of Oracle databases. Confidential has architected several data warehouses for BI and Analytics projects. He has four years of data mining and modeling experience, and has worked with tools like Oracle Data Mining (ODM). Last seven years, he has worked with emphasis on extraction, transform and loading (ETL) using tools like Informatica, Oracle Warehouse Builder and SQL, PL/SQL scripts, reporting and cleansing of data for data warehouses and data marts and created a scripted tool called data extraction tool.
• Confidential has worked for clients/companies in finance/banking industries ( ), telecommunications ( ), healthcare ( ), retail industry / market research, law enforcement/federal and industry. His areas of expertise include data modeling, architecting data warehouses, data marts for data mining, improving data quality/noise reduction, building customer churn models and intrusion detection (IDS) to improve security of systems using clustering and classification techniques. He has researched on semi-supervised learning techniques and has published/presented his work in Oracle Openworld/IOUG and IEEE conferences. Confidential is skilled at collecting business requirements for data warehousing and data mining projects and developing high-level business solutions. He has worked on data modeling, enterprise data integration, database migration projects and has managed small teams. Additionally, he is a great team player for large and complex projects and has managed multiple resources on several projects.
• ODM, Oracle 9i, 10G and 11G: Worked on Analytics project for Telecomm industry to create data warehouse/data marts and used these for data mining to identify the most profitable customers, service bundles and fine-tune the product catalog.
• Customer Churn Prediction: Worked on developing the prediction model for customer retention to increase profitability and reduce customer turnover, especially for wireless customers.
• Intrusion Detection Systems (IDS): Modeled and improved data quality for IDS to help improve security in wired and wired networks.
• Real time recommendation engine (RTRE): Supported the Oracle data mining based real time analytics project for Finance/Banking industry
• Protect- Crime Detection System: Worked on data mining based crime detection system for a Sheriff’s office and on the counter terrorism module. Also worked for Federal/Govt predictive analytics project.
• Data Model review and design of data warehouse/ODS in different industry domains
• Oracle RDBMS Administration and Clustering
• Oracle 11G, 10G (R2 and R1), 9.2, 8i, 8.0 and 7.3: Worked on design, development and the database architecture on different RDBMS releases across different platforms. Managed very large databases (VLDB’s), partitioning, sizing and optimization on storage area network (SAN) and tuning.
• Experience in tuning large DB’s, parallelizing SQL operations and use of statspack for optimization of DB. Troubleshooter deadlock issues.
• Supported troubleshooting of Web server load balancing issues.
• Data modeling tools like ERWin, Oracle Designer etc.
• Telecomm Billing solutions/ Healthcare/Law Enforcement
• Custom Apps: Supported DB operations for Oracle RDBMS based telecomm-billing applications. Some of these installs involved integration with Oracle apps and Seibel CRM. Handled enterprise data integration and data conversion projects. Also managed DB migration and OS migration projects.
• Medical Billing: Worked on development of home health care Confidential t management and billing system with central data repository for management reporting.
• Law Enforcement: Worked on data mining projects for finding crime patterns using Oracle data mining.
• Database Security
• Security and Encryption: Worked on projects to encrypt and secure sensitive data such as the SSN, credit card, health care data, both at the DB level and the application level. Also work on encryption for backups. Worked on SOX compliance and HIPAA compliance at enterprise and DB level. Explored using of data mining for DB intrusion detection. Worked with VPD’s for enhancing security of the data warehouse.

TECHNICAL SKILLS:

Oracle Platform and Architecture: Oracle 10g, 9i, 8i and 7.3 Clustering RAC) on 9i and 10G Database design and sizing (Erwin, Oracle Designer, Toad, SQL Developer) High Availability (Data Guard and Oracle Streams) Performance Tuning

Oracle Data Mining: (ODM) and other Business Intelligence tools: Data Mining for Java (DM4J) Oracle Data Miner (ODMr client) Secure Enterprize search Oracle Business Intelligence EE (formerly Siebel Analytics) Oracle WareHouse Builder (OWB) Informatica ETL scripting Classification techniques (Na ve Bayes, Adaptive Na ve Bayes etc. Clustering Model (K - means), anomaly detection etc., semi-supervised learning Neural Networks, SVM Text Mining and Text Search Analytical reporting

Non Oracle Databases: Progress, Informix, SQL Server SQL Server 2000 on Windows Informix on AIX Progress on BSD Unix elecomm and Healthcare: Billing applications Operational system Data warehouse and data marts

Hardware & Operating Systems: Windows XP, 2000, NT Solaris 9, 8, 7 HP UX 11, 10, 9 AIX 4.12 Red Har Linux Wintel platforms Sun platforms HP 9000 RISC 6000 Wintel platforms using VMware

Programming Languages: PL/SQL Proc*C Procedures, triggers, ODM API s etc Embedded SQL

GUI Tools: General DB Admin/Reporting Oracle Enterprise Manager, Toad, Raptor, Informatica and Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Senior Data Architect / Oracle Developer, projects include Data Modeling, Data Warehousing and Enterprise Reporting for Internet Banking, mamaging onsite and offshore resources.

Confidential

Responsibilities:

• Principal Consultant, BI and Analytics Consulting Group (Data Warehousing/ETL, Data Modeling, Data Mining, Enterprize Reporting etc), managed several resources for BI/DW projects.

Confidential

Responsibilities:

• Senior DBA (Managed team of Oracle DBA’s) and Data Warehouse Developer (DB Admin, Database Design, DW Architecture etc). Telecom Billing software Telecom Data Marts.

Confidential

Responsibilities:

• Senior Systems Analyst, Oracle - PowerBuilder Development, Medical Billing system and healthcare data warehouse.