EXPERIENCE SUMMARY:

• 15+ years of IT experience in the field of Data Architect, Database Development, ETL, DBA, Data Analysis, PLSQL, Oracle Forms and Report, ETL Development, Data Modeling, Data Warehousing and Data Marts
• Proficient in database design and data modeling (physical and logical) using ERWIN
• Proficient in database design and modeling for very complex application using ERWIN (Domain and Subject area more than 500 tables).
• Proficient in Reverse engineer existing physical database using ERWIN
• Involved in data modeling and database design using ERWIN & UML
• Experience with Oracle 11g environment and documented experience in performance tuning existing applications, including use and integration of best practices to increase processing time
• Experienced in Oracle Advanced PL/SQL APIs DBMS STATS, DBMS METADATA, DBMS GenXML TEXT IO and FTREE
• Extensively used CAST And MULTISET, Oracle Hints, Table Partitions, External Tables,
• Experienced in Oracle 8i, 9i, 10g & 11g, SQL *Plus, PL/SQL, Forms 6i (Developer 2000), Reports 6i, Oracle Developer Suite 10g.
• Created Advance PL/SQL packages, procedures, triggers and functions to implement business logic.
• Developed interfaces using Oracle, PL/SQL, Forms, Reports, SQL*PLUS, External Tables, Bulk collect, SQL*Loader, Directory Object, UTL FILE and Dynamic SQL
• Excellent working knowledge for snapshots, materialized views, packages, Multitable Conditional and Unconditional Insert, Rollup, Cube, Grouping and Merge
• Developed and tuned very Complex Forms, Reports and PL/SQL Packages
• Data Migration from COBOL, DB2 and MS SQL Server Oracle using SQL* Loader
• Experience in 24 x 7 Production support, developing production roll scripts & maintain Shell Scripts.
• Experience in Oracle Server Installation (Oracle 11g/10g/9i/8i and 8.x) on Linux
• Performed DBA tasks like managing users and security, schema objects, such as tables, indexes, views and monitoring and tuning performance
• Expertise in SQL tuning and creating a Modularized and Layered Subprogram (procedure, function, packages and triggers)
• Created Java stored procedures for enhanced performance
• Experience in installing and configuring various Databases Oracle11g/10g/9i/8x and MS SQL Server.
• Sound experience in projects analysis, designing and development in Health Care, Financial Manufacturing, Distribution, Insurance, and Service Industry
• Created advance PL/SQL, packages, procedures, functions and triggers to implement business logic
• Excellent knowledge and hands on experience in TOAD and Oracle PLSQL/SQL Developer
• Sound knowledge of Debugging PL/SQL Complex Code
• Designed & developed OLTP and OLAP applications using Oracle with Dynamic P/LSQL
• Hands on experience in all aspects of System Development Life Cycle (SDLC)

TECHNICAL SKILLS MATRIX:

Oracle SQL

Oracle PL/SQL

Oracle Forms

Oracle Reports

Data Modeling ETL Process

Database Administration

Unix administration

COMPUTER SKILLS:

Software: MS Excel, MS Word, MS FrontPage, MS Project, MS Outlook, Visual Studio .Net 2005, Smart Draw,Photoshop CS 5, Jgrasp, Net Beans, VM Ware, Notepad++, Crystal Reports

Languages: PL/SQL, SQL XML/XDK, Shell Scripting, Java, PHP, HTML, C, C++, Pro *C, PHPAction Script, HTML

Databases: Oracle 11g/10g/9i/ 8i/8/7.x/6.x, MS SQL Server 2005 & 2008, MYSQL, MS Access

Platforms: Linux, Sun Solaris, AIX, HP UNIX, Windows server 2008/NT/XP/98, Vista and Windows 7

Development: Developer Suite 11g, (Forms 11g/10g/9i/6i/4.5), SQL NavigatorPLSQL Developer, SQL Developer, Warehouse Builder, Java DeveloperToad 8.5, Graphvz and Informatica 8.6, Toad 11.6

Data Modeling: ERwin 7.1/4.x/3.x, UML,MS Visio, Toad Data Modeler

Power Shell: Windows Power Shell command line utility i.e. PS Scripting, SQL Server PSGeneral task, scheduled Sripts, Creating database tables, Invoke SQLCMD etc.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database / Informatica Developer

Responsibilities:

• Creating and design ETL Process through Informatica ( Power Center) 9.0.1
• Installing and configuration Power Center client, configured repository, registering the Power Center server, Setting up the powercenter Metadata, connecting the database etc.
• Managing the repository, folders, security, versioned objects, grouping, copying objects, exporting and importing objects, exchange metadata.
• Managed aggregator, custom function, external procedures, Rank, Router Joiner, Lookup, Sequence, Sorter, XML and stored procedures transformation.
• Enhanced existing Diabetes application for various diagnosis patient information system.
• Create new schema for Diabetes Database to enhance new approach for Type 1 and Type 2 patients.
• Create new packages, procedures, functions, and other oracle objects from existing system to new data model
• Create triggers to enforce rules for various purpose
• Managed new application, checking performance through partitioning and other SQL tune packages.
• Create Autonomous transaction, large objects, cursors, Pragma Exception handling.
• Perform tuning for packages and other PLSQL code by using hints, explain plan, and other database level tuning
• Create tables, views, synonyms, triggers and other large objects for the new system

Confidential

Senior Database/ETL Developer

Responsibilities:

• Loading Data from different data sources mostly UPS Invoices through SQl Loader utility.
• Perform source tables, flat files, xml files and transfer target database.
• Create mapping for source objects and transformed into the database.
• Monitor job to perform ETL Process, disable constraints and other objects during the etl process to perform performance tuning.
• Develop and design UPS Audit Payment Process System and Customer Information System.
• Create External Tables and load the data into staging table for UPS Invoices.
• Create index and partitioned on staging table for UPS System.
• Writing packages and procedures for ETL Process
• Check log file, discard file and bad file for identify invalid records.
• Perform tuning for packages and other PLSQL code by using hints, explain plan, and other database level tuning
• Writing shell script for etl process.
• Create external files from database table, writing code for UTL FILE package and compare source files and target files.

Confidential

Senior Database Developer

Responsibilities:

• Design logical, physical model for Supplier Management System (Totals) model by using Ervin.
• Enhance packages, procedures, functions, and other oracle objects from existing system to new data model
• Enhance oracle forms running on application server
• Design 40 forms and reports for totals application ( Supplier Management System )
• Perform tuning for packages and other PLSQL code by using hints, explain plan, and other database level tuning
• Unit testing by using UTPLSQL for stored procedures, packages, and functions
• Responsible for writing shell scripts for totals application
• Using Pro*C/C++ statement for BLOB, CLOB and BFile
• Creating link by using Pro*C., writing statement for LOB Locator, LOB Buffering and Temporary LOB.
• Import data from other system by using SQL loader utility, create control file, log file, discard file in red hat enterprise Linux server 5.9.
• Load customer information from different data sources through Informatica power center, create mapping and transformed through router, aggregate, lookup, joiner and stored procedure.
• Create tables, views, synonyms, and other large objects for the new system

Senior Data / Informatica Architect

Confidential

Responsibilities:

• Enterprise Metadata Application
• Designed logical, physical model for (IRS) Enterprise Metadata Physical model by using Oracle Data Modeler Version 3.1.2.
• Wrote different packages and stored procedures for the above Data Model
• Installed setup and configured (UTPLSQL) Unit testing
• Enhanced packages for BMF, IMF, AUR, IND schemas for tax purposes
• Test packages with different scenario through UTPLSQL
• Enhanced different application and packages for IRDM Naming standards and rules
• Wrote triggers for naming standard
• Installed, setup Informatica server 9.0.1, creating repository service, integration service, managing user accounts at server level
• Created and designed ETL Process through Informatica (Power Center) 9.0.1.
• Load data from various data sources into power center repository, create mapping and transformation for target tables.
• Installed and configured power center client, configured repository, registering the Power Center server, setting up the powercenter Metadata, connecting the database etc.

Technical Database/Informatica Specialist

Confidential

Responsibilities:

• Built custom application using Oracle Developer suite 11g including forms and Reports Modules on Oracle 11g database.
• The project was to develop a system for taking Patient data from different servers where all company patient history was updated
• Upgrade oracle forms and reports from 6i to 11g
• Created star schema for our Research Preliminary Database application enhancement, which is currently running on yearly basis as the system doesn’t have partitioning for the very large terabytes tables i.e. Diagnosis, Procedures, Pharmacy and Lab data
• Redesigned the Research application by using Oracle Designer
• Created packages, stored procedures, functions, materialized view, sequences
• Inserted bulk loads, 230 million rows for our data warehousing table for only 1 year
• Ran SQL Loader utility at Unix environment, create control file, log file and call stored procedure
• Worked on multiple databases, database administration, monitor Data files, performance tuning both server level and SQL level.
• Created and design ETL Process through Informatica (Power Center) 8.16.
• Installed and configuration Power Center client, configured repository, registering the Power Center server, Setting up the powercenter Metadata, connecting the database etc.
• Managed the repository, folders, security, versioned objects, grouping, copying objects, exporting and importing objects, exchange metadata.
• Managed aggregator, custom function, external procedures, Rank, Router Joiner, Lookup, Sequence, Sorter, XML and stored procedures transformation.
• Enhanced shell script for Email notification and job control
• Developed and designed historical database system
• Performed query using hints, bulk load and forall, and used DBMS SQL packages for performance wise
• Wrote documentation for the new application and enhancement for the existing system
• Compared objects at database level, schema level in Toad
• Enhanced existing application, made changes in logical design, load tables and object in Toad Data Modeler through reverse engineering

SQL Server Analyst

Confidential

Responsibilities:

• Worked with SSIS Integration services, Creating Packages with SQL Server Import and Export Wizard. Define Source and destination configuration, formatting and transformation, save and execute
• Defined server based connections to database other than SQL Server
• Imported and exported Flat files and other files
• Upgraded, managed, and migrated existing DTS 2000 packages to integration service
• Upgraded SQL Server 2005 Integration services to SQL Server 2008 Integration
• Imported data through BCP Bulk Copy command line utility. Define permissions and modes i.e. character mode, native and wide mode
• Exported data through BCP
• Created system views, catalog view, information schema views, and dynamic management view
• Created useful system stored procedures
• Worked on the server / client side installation, client configuration, and client data access technologies
• Created user administration, authentication mode, managed principles, logins, SQL server security, user/schema separation and roles
• Managed permissions, logins through SSMS and T - SQL. Managed full recovery and bulk logged recovery
• Managed Backup devices i.e. disk, tape, network shares media sets
• Configured SQL server agent
• Managed SQL server jobs, defining multiple jobs, view job history, scripting jobs and alerts
• Multiserver job management, created master server, powershell, and start power shell
• Created and modified tables, views, partition tables, function, and schemas

Senior Data Architect / Developer

Confidential

Responsibilities:

• Worked with the Inventory System-Designed comprehensive diamond single-stone, tracking software for 7 processing units
• Created PL/SQL stored procedures, functions, packages and triggers to transform and load staging table data into fact & dimension tables, by applying critical business needs of wireless industry
• Maintained log of unprocessed records by writing efficient exceptions in PL/SQL programs
• Responsible for interacting with business analysts to apply data transformation rules in PL/SQL programs
• Created and maintained Partitioned Tables and Indexes that helped in maintaining large tables efficiently
• Wrote functions and procedures for implementation of the business logic as per the client requirement
• Created materialized views to leverage speed of extracting data from large fact tables
• Experienced with ETL and data integration experience in developing ETL mappings and scripts using Informatica (Power Center), TOAD, and Warehouse Builder
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules
• Maintained data security by creating database triggers to populate audit trail columns in dimension, lookup and cross-reference tables.
• Performed SQL & PL/SQL tuning using Explain Plan and TKPROF
• Used TOAD Schema Browser to navigate through various objects and SQL Editor to test and tune complex SQL Queries
• Designed database schema using Erwin tool
• Created the database schema objects: tables, views, synonyms, indexes, procedures, and functions. Written UNIX shell scripts to transform & load data from flat file to staging tables
• Involved in the Database design and Technical Design Specifications for enhancement applications using Designer 6i
• Involved in the Data modeling of ER diagrams, functional flow diagrams, data flow diagrams using Oracle Designer
• Created table spaces, tables, views, indexes, synonyms, and integrity constraints
• Designed and Developed the Master and Transaction Forms using Oracle Forms 10g/6i through Designer 10g/6i.
• Designed and developed 25 Master forms, 100 Transaction Forms and 120 Reports using Oracle Forms 10g/6i Reports 10g/6i and PL/SQL
• Wrote stand alone stored procedures, triggers, functions and packages using PL/SQL
• Developed and executed Template form using Oracle Forms 6i and PL/SQL which is used throughout the application
• Involved in the SQL query tuning of the application using TOAD, EXPLAIN Plan

Senior Oracle Developer

Confidential

Responsibilities:

• Designed various front-end screens of application using Oracle Designer 6 and Forms 6i
• Developed various Reports in Oracle Designer 6i and Reports 6i.
• Customized and developed program Libraries (PLL) for the application screens in Oracle Forms 6i
• Developed and in corporate changes in various packages, libraries, procedures and functions to support and develop new application
• Designed and developed various modules of company new application from scratch which enable company to enter in international market using and Reports 6i.
• Designed physical and logical database using Oracle Designer 6i and ERWIN data-modeling tools
• Designed and developed schemas, creating tables, views, and constraints based on international and national market manufacturing Industry business rules
• Performance tuning of queries and cursors using HINTS, Explain Plan and TKProf and PL/SQL Developer
• Developed backend procedures, functions, libraries and triggers for Data validation, and parsing EDI files data into database
• Developed advance PL/SQL packages, procedures, triggers and functions to implement business logic.
• Generated tech Documentation, detail designs, SDDs, DFDs, and user manuals of interfaces that are developed in customer service and billing and cash to help users and tester understand application while they test or use it
• Assisted and supported users in user testing and helping to ensure accuracy designed and developed schemas, tables, views, constraints, and triggers to make system automatic
• Developed complex packages, functions and procedures to convert and parse data from XML files to multiple database tables
• Worked as a Senior Oracle Developer and Database Designer to support large databases by developing routines at backend packages for company’s intranet application