Ten years and seven months of IT industry experience encompassing a wide range of skill set, roles and industry verticals and being presented for the role of Information Architect

• Extensive experience of on all Software Development Life Cycle (SDLC) with data and requirement analysis, design, development, testing and implementation of software applications including in-house Enterprise Resource Planning applications. Have experience of tuning Oracle Forms, Reports 6i, SQL Performance Tuning, preparation and execution of stored procedures, functions and triggers.
• Experience in Data Architect, Build and Deployment Administrator,DB2 Database Administrator, Migration Team Lead cum Data Architect, Oracle Consultant, Oracle Form Developer and in-house ERP Systems Analyst
• Experience on Oracle 8i / 9i /10g DB and Forms 6i /10 and Reports 6i /10g with hands on PL/SQL , stored procedures, triggers, 3NF etc
• Experience as Data Quality Lead to actively drive and manage the data requirements for migration, coordinate with the Integrity project manager(s) and technical teams, create and review Requirements Documents
• Proficient in analyzing and translating business requirements to technical requirements and database modeling by having a strong Architecture concepts , database skills, Object Oriented Programming and development knowledge
• Well versed in preparation and execution of Test cases and good experience in different software testing like Sanity, Unit , Black-Box , White Box ,Alpha , Beta , Comparison, Integration and Interface
• Having knowledge of Data Management Tools i.e. Optim 6.5 which helps in Data Security, Data Anonymization, Data Masking, Archival and Test Data Management
• Executed software projects for Tele-communication, Industrial (Manufacturing) & Distribution, Finance, Government, Healthcare, Pharmaceuticals and Energy & Utility industry
• Involved in Oracle databases proposal development for different bidding projects
• Technical panel for IBM India DBMS interview drives
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player

EDUCATION:

• Master of Computer Science
• Bachelor of Pharmacy

CERTIFICATIONS:

• IBM Certified Database Administrator DB2 9 for Linux, UNIX and Windows
• IBM Information Management Optim Technical Sales Professional
• Brain Bench Certification of :-
• Oracle PL/SQL certificates
• RDBMS Concept certificate
• Oracle Form 6.0 certificate
• IBM Asset Management certificate
• SQL ANSI certificate

TECHNICAL SKILLS:

Oracle

8.8

DB2

2.0

Sybase

1.6

SQL Server

1.0

Languages

PL-SQL

8.8

Developer 2000 (Forms 9i/6.0, Reports 9i / 6.0)

4.5

Transact-SQL

1.5

Java

1.0

C++, C

1.0

Visual Basic 4.0– 6.0

1.0

PowerBuilder 3.0-6.0

0.5

HTML

0..5

Platforms

Windows NT

8.8

UNIX

4.0

LINUX

0.5

Project Domain

In-house ERP / Payroll Management System

4.5

Inventory / Sales Management System

4.0

Financial Accounting Management System

4.0

Procurement Management System

4.5

Operating Systems

Windows NT

5.0

UNIX

4.0

Windows 95

1.0

Linux

0.5

MS-DOS

0.5

Hardware

PCs

8.8

IBM

4.3

RDBMS

Oracle 10g

3.0

Oracle 9i

3.0

DB2

2.0

Sybase

1.0

Development Tools

TOAD,

8.8

SQL Loader,

5.0

Microsoft Office 2000

8.8

Microsoft Office XP

6.0

Applications Methodologies

Object Oriented Analysis and Design

8.8

Tools

TOAD 8.0 ,7.5,7.0

8.8

ODI

.5

RDA 7.5

2.5

IDA 7.5

.5

OPTIM 6.5

.1

Methodology

Waterfall

4.0

Agile

1.0

GS Method

2.0

RUP

.5

Processes

IBM’s QMS (Quality Management System)

4.5

Repository Tools

Rational Clear-Case

3.0

Rational Clear-Quest

3.0

Visio

.5

Subversion

1.0

CVS Version Control

1.0

PROFESSIONAL EXPERIENCE:

EMPLOYER : Confidential,

CLIENT :Confidential, 
DURATION :Dec 2012 – Till Date 
ROLE :Senior Data Architect cum Oracle Consultant

Description: Johnson&Johnson has more than 250 companies located in 57 countries around the world. Their Family of Companies is organized into several business segments comprised of franchises and therapeutic categories. Basically J&J has 3 categories which are 1) Consumer segment 2) Medical Devices and Diagnostics segment 3) Pharmaceuticals

I am working as Oracle consultant / Data Architect on the below modules :-

Confidential, - This is a worldwide decision support tool designed to assist Line Managers and Human Resource staff with compensation planning. In particular, this includes support for the year-end compensation planning cycle. The cycle formally begins in November and finishes in February with the issuance of bonuses and other forms of year-end compensation. However, a great deal of work is done in CompNAV before and after the planning cycle dates. CompNAV expedites the planning process by significantly reducing paperwork, providing Line Managers with sufficient information to make good compensation decisions and facilitating rapid review and approval. CompNAV accesses information from a real-time, common database. There is no importing and exporting of data and no data files to send to supervisors or HR/Compensation departments. For US operations, employee data remains “current” during the planning process and is updated for new hires and terminations.

Responsibilities:- My responsibilities for this module includes :-

• To grant role permission to users, batch jobs and elements on admin, planning and report modules
• To perform daily code and database migration on CompNAV and MyCompNav
• To support the daily tickets raised by client for the changes required and apprise them of status.
• Assist with the transition of currently running applications to the new technologies
• Review, recommend and assist with the implementation of systems monitoring and capacity planning
• Provides the means of system integration by understanding the source and target data and build the data mapping.
• High-level data architecture documentation, which illustrates the source and destination 
  of data to and/or from approved data sources
• Development of a data strategy and design specifications

Confidential, is a Global Expense Reporting System (gXRS). In this system the files are generated as per layout specifications and loaded into the gXRS database using a gXRS process that pulls a particular folder in the server for presence of the files during daily processing. As soon as the gXRS process finds these files they are processed and loaded or rejected depending on the validity of the files.

Responsibilities:- My responsibilities for this module includes :-

• To check daily load of the data loaded on daily basis
• To update daily users of the progress and status of daily data load
• To support the daily tickets raised by client for the changes required and apprise them of status.

CLIENT : Confidential,Atlanta (US)
Duration : March 2011 till date
Role : Senior Data Architect

Description:
Confidential, is a Covered Entity, Clearing House and Business Associate for a network of BCBS plans. Confidential, provides the health care claim processing System for the BCBS plans of Michigan, Connecticut, New Jersey, California and New York. IBMI in coordination with IBM US is responsible for the enhancement and maintenance activities of the Confidential, Claim processing system :-

Responsibilities:
I had worked on Confidential, Mid-Tier Transformation Project as Information / Data Architect. This Mid-Tier Transformation / Modernization Project are being undertaken to:

• Improve and modernize the infrastructure and its support model
• Update and modernize Confidential, mid-tier hosting technologies
• Assist with the transition of currently running applications to the new technologies
• Review, recommend and assist with the implementation of systems monitoring and capacity planning
• Improve system recovery with a 3-footprint server model & Review and recommend virtualization strategies and opportunities and Improve new application support model
• Implement new Production Support Team model & Implement new Application Delivery Team model
• Provide new service level delivery capabilities
• Understanding the customer’s business requirements, business processes and system functionality to develop the data design and maintain the source of data.
• Responsible for developing and maintaining a formal description of the data and data structures which includes data definitions, data models for Conceptual, Logical and Physical Data Model, data dictionaries, data flow diagrams, etc. in short metadata.
• Data architecture includes topics such as metadata management, business semantics, data modeling and metadata workflow management.
• The architecture covers databases, data integration and the means to get to the data
  resolve the end to end data issues, design issues and end to end test issues with the help of data dictionaries.
• Provides the means of system integration by understanding the source and target data and build the data mapping.
• High-level data architecture documentation, which illustrates the source and destination 
  of data to and/or from approved data sources
• Development of a data strategy and design specifications
• Design strategy and design for managing history data
• Selection of capabilities and systems to meet business information needs & Evaluating new techniques for enhanced functionality
• Daily call and meeting with the customers to prepare document and review the migration strategy.
• Finalization of the tool strategy to be implemented and the different ways to optimize the application performance improvement.
• Check the consistency between sub-architectures and to identify the re-usable components with in the Architecture.
• Enforcement of Architecture Compliance and improving the maturity level of architecture discipline within the Confidential, organization.
• To provide the basis for all decision-making with regard to changes to the architectures.
• To ensure that infrastructure projects are aligned with agreed-to IBM and Confidential, standards and are scalable to meet both current Confidential, requirements and future growth requirements.
• To ensure that the Confidential, infrastructure considers the architecture of Confidential, applications. As a result, I also need to review the infrastructure requirements for all CSRs and application projects greater than 500 hours, or of any size if deemed by an appropriate manager which contain changes that are significant enough to warrant review.
• To provide input based on knowledge and experience with the steady-state support of the Confidential, Infrastructure environment.
• Responsible to stay abreast of new technologies and practices that might be suitable for consideration within the Confidential, environment and to raise those as topics for future IAB Monthly Review Meetings.

CLIENT :Confidential,Detroit (US) 
DURATION :Sep. 2010 - Feb 2011
ROLE :Senior Oracle Consultant cum Data Architect

Description:
The Contact Management System (CMS) is a custom Oracle/Unix relational database application developed for the State of Michigan Department of Civil Rights. Its primary purpose is to record and store information documenting contacts from individuals and organizations regarding civil rights concerns and related requests for service. Service options covered include Complaint Issue processing, Community Outreach, Education, Contract Compliance and requests for Information. In addition to data keyed into the application, the system also provides the means to store and retrieve output documents generated by Oracle forms and reports modules in the application, to send emails with document attachments, and to upload and store externally created and/or scanned documents. The application also includes functionality to track business process workflow, to enter notes reflecting actions taken concerning specific requests for service, to readily export data to Excel and other applications, and to document chain-of-custody of contacts as they are moved from one user to another. CMS also provides the means for reporting and measuring department activities for management decision support and to satisfy requests for information from the state legislature and other government entities and from news media and members of the public.
Responsibilities:

• Working on Data Modeling and Architecture with 3NF implementation
• Installing Oracle 10g both on server and client and also installing Oracle Middleware like Oracle Application Server: Oracle Forms, Oracle Reports.
• Selectively purge records from the database in accordance with MDCR Records Retentions Schedules.
• Modify existing forms and reports to reflect changes in business processes and to enhance or restore functionality
• Create new forms and reports to support current business processes
• Correct appearance issues in existing reports, including those resulting from the shift to the Oracle 10g database platform
• Determine the source of and correct programming errors that delay or prevent the completion of data commits in specific modules
• Correct programming errors that prevent the proper functioning of specific aspects of the CMS application
• Assess the impact to CMS of a shift from Novell GroupWise to MS Outlook and make or plan for any modifications required to implement the transition
• Modify database structure by adding columns and tables as needed to support new functionality
• Create or modify forms and reports in accordance with written Work Orders provided by the MDCR Project Manager
• Assist and support User Acceptance Testing
• Deploy completed work upon authorization by the MDCR Project Manager
• Document the changes done for the existing reports and form and also if new forms and reports are created