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)

CORE COMPETENCIES:

• Oracle SQL
• Oracle PL/SQL
• Oracle Forms
• Oracle Reports
• PostgreSQL
• Data Modeling & ETL Process
• Database Administration
• Unix administration

TECHNICAL 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, PHP, Action Script, HTML

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

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 Navigator,PLSQL Developer, SQL Developer, Warehouse Builder, Java Developer, Toad 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 PS,General task, scheduled Sripts, Creating database tables, Invoke SQLCMD etc.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior Database / ETL Developer

Responsibilities:

• Worked on AMC Mantas Application for Money Laundry program from US and Europe.
• Gathering information, design HLD and LLD for AML Program.
• Worked on tableau, modifying and display various database report. Filtering data, drill down/up in the table, sorting data, highlighting data.
• Improve navigation, display workbook and views.
• Developed and published Conceptual, Logical and Physical data models using ERwin
• Architected data models for an ETL repository using Erwin.
• Create ETL process, design ETL Load daily 300 files from 56 different source system.
• Develop new Informatica mappings, workflows, sessions and mapplets for data control.
• Develop new BTEQ scripts for loading data into TERADATA control tables.
• Responsible for code review for Developers
• Coordination between development, QA and Business team.
• Worked on informatica 9.6.1. Create folders, export metadata for various objects in XML files and import them in the different Repository.
• Load data from cobol source, cleaning files by using normalizer and perform various tasks, move data to oracle database.
• Writing Shell script for file validation i.e. file layout, number of columns check, rows, empty file check etc.
• Creating expression, router and filter transformation.
• Creating parameters, timer and workflows.
• Create jobs in Autosys, monitor and check the logs for any failure.
• Creating store procedures. Function in oracle database.
• Create Metadata tables in the database for various files i.e. file name, workflow running, session information number of rows inserted in the database table.
• Also create data model for current application by reverse engineering.

Confidential, Phoenix, AZ

Senior Database / ETL Developer

Responsibilities:

• Develop and design Audit Payment Process System and Customer Information System.
• Creating packages, procedures and functions for the Aerospace parts and manufacturing systems.
• Create triggers to enforce business rules.
• Create index and partitioned on staging table for the 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.
• Developed and design new database application for aerospace ODS application which we have daily process thousands of rows from SAP / Other systems to Oracle Database through Informatica.
• Install and configured Informatica PowerCenter 9.6.1. configure domain, repository, PowerCenter server, metadata and connection details.
• Creating and design ETL Process through Informatica ( Power Center) 9.6.1.
• Managing the repository, folders, security, versioned objects, grouping, copying objects, exporting and importing objects, exchange metadata.
• Import data from various sources i.e. SAP Power connect, SQL Server, PostgreSQL 9.5 to Oracle Database.
• Creating mapping, workflow for different application.
• Creating packages, procedures and functions for ETL.
• Managing workflows schedules / un - schedules for monthly and quarterly patching.
• Monitor workflows logs and session for daily routine check.
• Debugging workflows, sessions if failed.
• Creating timer, expression, aggregator, rank, router, joiner, lookup, xml and stored procedures transformation.
• Managing Aero Dashboard / Datastream / PIPS / ODS / OMST / Visibility / SAM / Barcode / ETime / Jetform / MDM / Solumana application.
• Provide 24x7 Production support for the above application.
• Resolving daily tickets, monitoring workflow and support applications after monthly patching.
• Enhanced visibility application, modify COGNOS code, tested and moved to production.
• Working on Visual source safe for version control, check out the production file, modify and testing.
• Creating Data model for ODS application ( Reverse Engineering ).

Confidential, Los Angeles, CA

Senior Database / Informatica Developer

Responsibilities:

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

Confidential, Los Angeles, CA

Senior Database Developer

Responsibilities:

• SMS Total Design Application.
• 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

Confidential

Senior Data / Informatica Architect

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.

Confidential, Pasadena, CA

Technical Database/Informatica Specialist

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

Confidential, Calabasas, CA

SQL Server Analyst

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.

Confidential, Los Angeles, CA

Senior Data Architect / Developer

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.