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.

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:

Oracle: 7.x/8.x/9i/10g/11g,(OEM-GRID),RMAN,SQL*DBA,SQL*Plus, EXP/IMP, SQL*Loader), MS-SQL Server 7.0, MS-Access, My-Sql, Sybase

ER: WIN4.0,Rational Rose, Visio, Designer-2000, Power Designer 15, Embarcadero

Windows NT: 4/2000, Linux3.1, Sun 5.8,9,10,HP-UX B.11,IBM-AIX 4.3.2

GUI: Developer 2000 (Forms 5, Reports 3),Brio

Languages: SQL, PL/SQL,Cgi/Perl5.06,C, Java1.2, Shell Script(Korne)

Web Servers: IIS,Apache1.3,Iplanet,Jrun,Websphere3.1,Weblogic,J2EE1.2Netscape

ETL Tools: Sql Server 2005 ( Integration Services, Analysis Design), Informatica (Power Center)

MDM 8.0: IBM

DBDevelopment Tool: Toad, PL/SQL Developer, Sql*plus, Sql Developer, Eclipse.

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Data Architect

Responsibilities:

• 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.
• 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.
• Signature Capture, Kiosks, Pricing, Fleet Management, Location Migration, Reservation and Rental and Customer Data Management.

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, Bridgewater, NJ

Project Lead

Responsibilities:

• 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.

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, East Hanover, NJ

Sr. Data Modeler/Developer

Responsibilities:

• 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.

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, New York, NY

Job Title - Sr. Oracle Consultant

Responsibilities:

• 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.

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

Confidential, San Francisco, CA

Sr. Oracle Consultant

Responsibilities:

• Responsible for Oracle Development, Tuning, Support Releases and user support request.

Confidential, Woodland Hills, CA

Project Lead

Responsibilities:

• Database design, website UI and leading team for development and content management.

Confidential

Sr. Oracle Developer

Responsibilities:

• Analysis, design, development, testing, tuning, Integration and implementing the ERP Model.
• Worked on Module Bill of Material, Site Management and Purchase Order.