Objective

As a Senior Technical resource would like to play a vital role in planning, design, implementation and strategic oversight of enterprise data architecture, which aligns with business strategy, goals and objectives for fast paced high growth company.

Experience and Skills Summary

• 17 years of Experience in Data Analysis/Data Modeling /Architect/ Development/ ETL in HP-Unix, Windows-NT/2000,SUN SOLARIS,AIX, LINUX, SOA Service Oriented Architecture environment for projects like ETL,OLTP, OLAP Data warehousing , MDM Master Data Management , DSS Decision Support System , Web, Analytics, Client-Server, Legacy System, Transfer Databases, Data Migration and Product Management.
• Involved in providing technical guidance and direction in defining the data architecture to strategy projects and the business as a whole. Worked with senior management, stakeholder groups and client teams in order to determine data requirements and best practices for advance data manipulation, storage and analysis strategies in a data environment. Drove a consistent data architecture approach across the organization: contribute to and communicate data architecture standards guidelines to wide group.
• Experience in translating business requirements into Logical/Physical Database, Star Schema, Snowflake Schema, Fact and Dimension Modeling, Data Marts, Data Mapping, Data Loading/Migration, Data Warehousing and ETL Extract, Transform and Load / ELT Extract Load Transform .
• Experience in DBA Activities - Capacity Planning, Backup and Recovery Strategy, Performance Tuning, , Replication Basic and Advance , RAC Real Application Cluster , ASM, Partitioning, Migration, Oracle Advance Security, Data Quality, Data Pump, Online Definition and other aspect of database administration.
• Hands on Programming Language - SQL, PL/SQL, Shell Scripting, Perl Scripting, ETL Tools SSAS and SSIS - Sql Server and knowledge of Informatica.
• Have accomplished diverse roles ranging from software development, Project Lead, Data architect, programming, consulting/ project planning with clients, offshore team management, mentoring juniors and team members.

Technical Skills

Professional Experience:

Confidential

Sr. Oracle Consultant

• Responsible for all aspects of data management infrastructure including: Data Model, Data Security, Data Migration, Implementing new technologies and upgrades in Database Servers, release management, integration, application support and development.
• Manage analysis, design logical/physical data model for new applications or redesign using the mainframe copy books, development, administration, capacity planning, Data Security and tuning of databases for corporate databases.
• Work and manage offshore team for DB administration, user roles and privileges, data security for specific users, SSL connectivity for application user, space management, RMAN Database backup and archive logs strategy, 24x7 db support alert system and constant DB Tuning efforts.
• Work with DBAs in Database server refresh, implementing Oracle Advance Security, Virtual Private Database, OEM- Grid, RAC 11g Real Application Cluster , MDM IBM- Master Data Management 8.0 , IBM-Data Quality, Basic and Advance replication, Data Partitioning techniques, Load Balancing and DB Scalability testing.
• Responsible for development - stored procedure, function, packages, shell script, ETL, ref cursors, batch processing code for ongoing projects, Indexing, Partitioning and shell scripts to monitor DBA activities- Fragmentation, backup failure, db space monitoring, Monitor DB CPU and Memory parameters.
• Architecture Projects - Implement Oracle Advance Security, RAC 11g Real Application Cluster , Data Server Refresh, Database Migration, VPD Virtual Private Database , Data conversion from Mainframe to DB2 into Oracle, MDM Master Data Management , Data Quality.
• Corporate Projects Signature Capture, Kiosks, Pricing, Fleet Management, Location Migration, Reservation and Rental and Customer Data Management.
• Oracle DB Size 2.5 TB and growth rate is 1.5 every month.

Environment Oracle 11g, RAC 11g, Solaris 10, Sun Servers m500- 4Quad-32GB , MQ Series, Java, J2EE, Oracle SOA Suite, Toad , Power Designer, IBM-MDM 8.0, Web sphere, Web logic, SOA Environment.

Confidential

Job Title Project Lead

• Responsible for Data Analysis, Data Profiling and Data Administration for the Analytics Pharma products viz. iOptima Forecasting and Promotional Data , iFolio Sales force Strategy , iForce ROI based call Plans , iProfiler Sales Data and rank physicians , iTrak. At the same time implemented data strategy to integrate the Products.
• Interaction with the clients, professional service team and business users to convert the requirements into Logical/Physical Model. This involved normalization/de-normalization OLTP, OLAP, DSS , planning, redundancy, client based schema and data standardizing.
• Involved in writing PL/SQL Code and Shell Script Procedure, Function, Packages, Ref Cursor, Partitioning, Shell Script, Perl Scripting, Database Auditing and Analytics functions.
• Implemented the Standardized functionality for Data Cleansing, Meta Data, ETL Techniques for Data warehouse, Data Mart and generic code for all the Products.
• Involved in Project / Program Planning, Execution and Management, in tune with the core business objectives. Implemented project plans within pre-set budgets and deadlines.
• Familiar with IMS Data, DDD- data Wolters Kluwer health WKH Data.
• Managed resource allocations and setting up of communication channels across the various horizons of the organization structure.
• Managed onsite and offsite team.
• Products - iOptima Forecasting and Promotional Data , iFolio Sales force Strategy , iForce ROI based call Plans , iProfiler Sales Data and rank physicians , iTrak.
• Oracle DBSize 1 TB .

Environment Oracle 10g/ 9.04 ,Linux, ER-win 4.0,PL/SQL, VB 6.0 ,ASP ,MS-ACCESS 97,SAS,Toad 8.0, PL/SQL Developer, IIS Web Server 5.0,Sql Server 2005- SSAS and SSIS .

Confidential

Job Title Sr. Data Modeler/Developer IT Dept.

• Participated in requirement gatherings, analysis and design for application.
• Coordinated with the business user and created logical Model and Physical Model for the web application using Erwin. Provided visual representation of design in Visio and flowchart in PowerPoint.
• Established methods and procedures for tracking data quality, data standards, redundancy and auditing for the data changed.
• Designed the Archival and Auditing Strategies for large and fast growing tables as per the 21 CFR Part 11.
• Wrote Oracle Stored Procedures, Functions, Packages, Partition, Temporary Tables, Indexes, Dynamic Sqls, imp/exp tool and in built error handling code.
• Project SINA Safety Information Notification Application web based application that can facilitate EClinical Safety Data and Epidemiology CS E and Country Sector Organization CSO for tracking incoming Adverse Events Information reports, obtaining follow-up information.

Environment Oracle 8.1.7/9i, HP-UX, ER-win 4.0,PL/SQL ,Java, JSP,EJB,PL/SQL, Web logic, JDBC, Toad, RMI.

Confidential

Sr. Oracle Consultant

• Responsible for DESIGNING CREATING an ETL Framework that works based on a table driven approach.
• Developed the entire ETL process using PL/SQL, which refresh's the Staging area, Data Warehouse and Data Marts.
• Developed the scripts, which use the fuzzy logic for Data Quality on Patients name, address, zip, state and adverse events.
• Responsible for writing scripts for Daily, Weekly, biweekly and monthly refresh of data warehouse based on the data inputs.
• Involved in creating and maintaining Partitioned Tables and Indexes, public synonyms, read only user accounts and database links for remote database access.
• Project - WWSDW World Wide Safety Data warehousing Project for Regulatory Dept .Conversion of data from AEM and ARISG.- ECLINICAL DATA and builts Data Warehouse and Data Marts for a product.

Environment Oracle 8.1.7/9i, Linux, ER-win 4.0,PL/SQL, Perl, PL/SQL, SAS,MS Access.