SUMMARY

• Over 7+ years of IT experience in Analysis, Design, Development, Implementation and support Of RDBMS in Production, Development and Test environments using Oracle Tools in client server environments.
• Involved in entire life cycle of implementation (SDLC) from business analysis to final deployment and testing.
• Experience in using Oracle related tools like SQL * Loader, Toad, SQL Navigator, SQL Developer and Data Loader.
• Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, object types and collections.
• Experience with Views, Materialized views, Cursors (Implicit and Explicit), Ref Cursors, and External tables, table partitioning, Index partitioning and nested loops.
• Extensive working knowledge on SQL Loader control programs, Oracle CDC, and PL/SQL validation scripts to transfer flat file data into oracle database tables.
• Working knowledge on, Java, HTML, and JSP.
• Experience in architecting and developing ETL Processes.
• Experience in building and modifying Data models in data modeling tools, such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
• Experience in DB2 development and optimization.
• Advanced skills in Oracle 11g/10g/9i database programming using PL/SQL (Stored Procedures, Functions, Packages and Triggers), standard built-in Oracle packages.
• Working Knowledge and experience with BI publisher Reporting, SQL Reporting, Crystal Reports, Business Objects and other report writing tools utilizing oracle, SQL Server, Access, Excel, Flat files and other Data sources.
• Expertise in maintenance of database objects such as tables, indexes, views, synonyms and extensively exposure in performing ETL.
• Strong technical expertise in UTL FILE, DBMS SQL, DBMS OUPUT, DBMS UTILITY, DBMS JOBS packages.
• Strong Experience in CDC and tools like Oracle Utility CDC, Golden Gate and IBM CDC.
• Experience in SQL or server level tuning using Explain Plan, TKPROF, STATSPACK Extensively used Cursors, Composite data type and Collections in writing the backend PL/SQL code.
• Experience in working with different data models such as normalized model, de-normalized model, flat model, Enterprise data model and Dimensional data model.
• Worked with timesheet management tools like IQ Navigator, KRONOS, LDAP
• Experience in writing UNIX shell scripts and experience in Informatica, Datastage ETL tools and OBIEE.
• Knowledge and experience in Backup, Recovery and restoring related activities
• Experience in Oracle Installation, Setting up Database Server, and extensive Data Migration Experience.
• Excellent analytical skills, logical reasoning, interpersonal skills, problem solving skills and communication skills.
• Strong management, administrative and leadership skills to work in team.
• Experience in 24*7 Production Support and managing offshore team.

TECHNICAL SKILLS

ORACLE: Oracle developer 11g/10g/9i/8i, Forms 10g/9i/6i. Reports 10g/9i/6i, Oracle EBS 11i.

LANGUAGES: SQL,PL\SQL, Bash/Korn shell scripting, TSQL,JAVA,HTML,JSP

Programming Tools: Oracle 11g/10g/9i/8i, MS-SQLSERVER and MS Access

Database Tools: Informatica,Datstage,OBIEE,Erwin data modeling,Sybase power designer tool, Enterprise manager,SQL Navigator,Toad,SQLdeveloper,SQL Server Management Studio, SQL*Plus, SQL*Loader, GoldenGate,IBM CDC

Operating System: Windows NT /XP and UNIX and Red Hat Linux, Sun Solaris, HP UX

PROFESSIONAL EXPERIENCE

Confidential, Maryland

Sr. Database Developer

RESPONSIBILITIES:

• Push the database deployment scripts to Production by analyzing the push timings and push scripts to find the impact.
• Involved in PLSQL development activity for Batch jobs.
• Analyze push scripts in load Test environment to categorize pre-push, post push plausible scripts that can impact production push timings.
• We work in Agile paced development and scrum for planning.
• Worked on Data Security and Data Governance.
• Tuning the SQL’s that were time taking one based on the Ignite report.
• Analyzing the code based on the LT Pre-Pushes.
• Work on database syncing from prod to Load Test environment to keep LT sync with PROD
• Deploy Informatica pushes from the command line.
• Worked on Sandbox cloud environment with PostgreSQL, MySQL for New applications.
• Working on performance tuning for the existing ETL processes based on Load test performance tests.
• Working on Load Test Performance environment and QA environments for Database pushes and assist release management engineers if there are any Database push error
• Suggested different database script changes either to include better way or to improve push quality and the changes that are because either effecting the business process, applications and ETL.

Environment: Oracle 11gPL/SQL, PostgreSQL, MySQL Sybase Power designer, JIRA, Confluence, Mac Terminal, UNIX, TOAD.

Confidential, Maryland

Oracle Lead Developer

RESPONSIBILITIES:

• Created, modified, maintained and deployed ETL processes build using Oracle CDC and PLSQL.
• On call Production support and supported on call for lower environments like UAT and SIT.
• Designed and developed error handling in existing ETL CDC process.
• Worked with Business Analyst for changing requirement on Mortgage Loans pooling and its subject areas, updated data model, extracted DDLs from the data model and did the development work .
• Agile environment for the development life cycle.
• Designed and developed new enhanced CDC ETL process that has drastically improved performance from hours to minutes to load big volume of data.
• Working on performance tuning for the existing ETL processes.
• Suggested and modeled different database model changes either to include new functionality or to improve data quality and the changes that are because either effecting the business process, applications and ETL
• Involved in supporting Front-end team for generating reports, Procedures and SQL queries.
• Involved in working with Production tickets and CDTS tickets.
• Setup new replicated database and added replication using IBM CDC.
• Involved in design and devotement of new ETL processes and written DTD document for the new design.
• Created database link to refer to tables and views on other database.
• Handled complicated fixes in UNIX shell scripts to keep up the data sync and not affecting the current functionality.
• Automated data loading, extraction, report generation using UNIX shell scripting.
• Used CRON JOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.
• Also provided 24/7 production support for the batch/production jobs.
• Created deployment document for different releases and maintained and updated versions in SVN.
• Involved in Production support and EACO call support.
• Involved in data model changes.
• Involved in Extracting data from various Data sources through different phases and placing the required data in the Target Database using PLSQL.
• Worked in designing and deployment of Parallel Environments in UAT and Production to do comparison on data between LEGACY and new channel.
• Worked in consolidating Mapping from new channel in to enterprise master mapping document.
• Identified, analyzed and Fixed the random and frequent production errors and made the current production CDC process to be 99% error free
• Written Data Fix scripts for tickets and new tables and supported user pooling activity in Production.
• Written different SQL loader scripts to move data from one environment to another environment and to scrub the important data while copying data from production to lower environment.
• Involved in several important meetings for design reviews, data model reviews and code reviews.
• Written Validation queries for data compare between two databases source and target.
• Worked in on shore offshore model and lead the team to get the things done.

Environment: Oracle 11g, Oracle CDC, PL/SQL, IBM CDC,Sybase Power designer 16.1, Command line editor, UNIX, TOAD.

Confidential - Maryland

Database Lead developer

RESPONSIBILITIES:

• Actively involved as a team member for gathering and analyzing the business requirements.
• Analyzed and reviewed the Business Requirements and System specification documents.
• Worked on maintaining the data model using Erwin Database Modeling tool
• Followed Waterfall for analysis and design phase and Agile for the development phase.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created multiple customized PL/SQL Packages for various business needs and modified existing packages to improve performance.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format.
• Extensively used mapping parameters, mapping variables and parameter files.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created database link to refer to tables and views on other database
• Added indexes to run queries faster on DB2 tables
• Created and modified DB2 procedures for Application Support.
• Created new tables, triggers in DB2.
• Analyzed application SQLs and procedures for commits to avoid Dirty reads.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic, using TOAD.
• Written stored procedures and triggers in Transact-SQL in Microsoft SQL server Database for data conversion and data scrubbing.
• Used standard packages like UTL FILE, DMBS SQL, PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Manipulated PL/SQL tables and VARRAYs with BULK BINDS and BULK COLLECTS.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Developed PL/SQL programs to dump the data from staging tables to target tables.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Explain plan and SQL Trace.
• Using UNIX shell scripting created batch jobs to create Index and Analyze tables once the Imports are done.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Provided support for the application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• Optimized the databases with reorganizing and creating indexes on several tables for Query Analysis.
• Identified the defects in PL/SQL Scripts (cursors and nested loops) and optimized.
• Optimized the SQL 's of OLAP Applications
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Worked with AUTOSYS for Scheduling the Oracle scripts.
• Scheduled jobs in Autosys taking into account the ETL dependencies.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Worked on User-defined and also the System defined exceptions to handle different types of errors like NO DATA FOUND, TOO MANY ROWS and PRAGMA EXCEPTION INIT.
• Supported the fact tables and dimension table with database objects for ware house system.
• Involved in Extracting data from various Data sources through different phases and placing the required data in the Test Database using SQL.
• Participate in development, testing and migration of oracle objects from development to testing and production environments.

Environment: Oracle 11g, Siebel 8.2.2 public sector Microsoft SQL server, SQL, Oracle forms, Mainframes,DB2, DB2 Data Studio,DB2 Command line editor, SQL Enterprise Manager, Erwin Data Modeling tool, TOAD

Confidential, Harrisburg,PA

Sr. Database Developer

RESPONSIBILITIES:

• Involved in writing Technical Specification Document.
• Converted User Requirements into formal Functional specification and Interfacing with clients.
• Involved in creating logical and physical data modeling using Sybase power designer.
• Provided alternate views of a given model or portion of a model. Representation of high level vs detail views i.e. one display without attributes or identifiers and another with both. One view for the end user, one view for DBA, one view for management. One view in Physical modeling notation, one view in Entity Relationship notation (Physical Model only) using Sybase Power designer.
• Worked onTeradata Store proceduresand functions to conform the data and load it on the table. involved inAnalyzing / buildingTeradata EDWusingTeradata ETL utilitiesandInformatica.
• UsedSQL Assistantto queryingTeradata tables.
• UsedTeradata Data Moverto copy data and objects such as tables and statistics from one system to another.
• Involved in Architecting data model for building Data Warehouse which includes staging area, ODS and OLAP structure flow.
• Worked with IBM CDC to add new tables and columns for Replication in Replicated database.
• Involved in Data Migration from Oracle 10g to 11g.
• Added indexes in the Source DB2 tables to pull data quickly from Informatica.
• Supported DB2 application on wring SQL queries and created views and procedures for Reports.
• Used MDM model for Oracle Data Store which pulls data from staging area from different sources and data mapping was done using META definition dictionaries.
• Involved in data analysis on source data and source meta information to design and develop ETL.
• Followed mostly Agile Environment and sometimes Prototype model in SDLC.
• Involved in writing stored procedures, functions, triggers, and ad hoc queries for the applications using Microsoft SQL Server Database involved in creating Test scripts for the generated final Reports.
• Planned version control of production source code using Rational Clear Case.
• Created CQ's and assigned to developers and myself using Rational Clear Quest.
• Created E-R diagrams, Function Hierarchy diagrams, Process diagrams, and Data Flow diagrams using Power Designer.
• Responsibilities include design, development, testing & Implementation of EDW daily receive pre-processing (Informatica and PLSQL Workflows), de-normalization for reporting purpose using Crystal Reports Developer, data security issues, development of ETL Process, development of ETL.
• Involved in Creating Data validation, Data cleansing, Data mapping Scripts and Monitoring Workflow errors and finding solutions for them.
• Developed interfaces using PL/SQL procedures and created packages to load data into targeted Oracle database.
• Developed several scripts to validate data in staging tables and developed Informatica Workflows to load the data from flat files into the staging tables, other database targets, flat files and XML.
• Involved in Migration of Workflows, Sessions, Mappings, and Mapplets from Informatica 8.1 to Informatica 9.5.
• Used Informatica GUI tool for building Oracle data warehouses and data marts.
• Used Informatica Primarily to build, deploy, and run ETL (Extract, Transform, Load), relational and dimensional modeling, OLTP modeling, data quality, data auditing, and full lifecycle management of data and metadata.
• Used Informatica Mappings and Transformations to load data into the data mart.
• Involved in design using Star Schema (Facts, Dimensions and Aggregate tables), Mapping and loading data from source (flat) to target (Oracle) tables using Informatica.
• Used Informatica for Metadata reporting and Runtime reporting.
• Created Database objects including Tables, Triggers, Views, Stored Procedures, Data Modeling, Indexes in SQL Server Database.
• Involved in design using Star Schema (Facts, Dimensions and Aggregate tables), Mapping and loading data from source (flat) to target (Oracle) tables using Informatica and PLSQL and SQL.
• Working knowledge with HTML, XHTML and JavaScript.
• Involved in writing Complex Queries, Store Procedures/Functions, Views, Triggers, Joins and Synonyms to maintain the Business Rules.
• Involved in validation including Source, category, and Code combination and also checked for duplicates and nulls.
• Created staging tables necessary to store validated data prior to loading data into interface tables.

Environment: Oracle 11g, Informatica Power Center 8.1,9.5, IBM CDC, Teradata12.0/8.5,PL/SQL, SQL Enterprise Manager, DB2 Data Studio,DB2 Command line editor, Sybase Power Designer Data Modeling tool, TOAD,, JSP,CSS, .NET, DBMS JOB,UTL FILE, IBM Rational clear case, IBM Rational clear quest,DB2,SQL server .,Shell Scripting, SQL*Loader SQL developer, Business Objects

Confidential, Freeport, NY

Database Developer

Responsibilities:

• Studied user requirements and functional specifications. Converted User Requirements into formal Functional specification and Interfacing with client.
• Manage software projects and develop enterprise solution
• Direct and integrate projects
• Work with team members to solve project related queries
• Worked mostly in Agile Environment and sometimes V- model in a SDLC.
• Involved in working with SOA tools, techniques, concepts, design patterns for data integration.
• Worked on Data Stage Tool for ETL.
• Designed, Partitioned, Developed and Maintained the database.
• Involved in data Migration from Oracle 10g to 11g.
• Worked to define the project implementation strategies.
• Developed and modeled OLTP data modeling, Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN.
• Comprehensive knowledge and experience, Cost Accounting, Manufacturing (INV, BOM, WIP, ASCP, PJM) (with EDI implementation), Oracle EBS Supply Chain, Functional OBM user.
• Supported Oracle EBS internal project team in mapping business process to Oracle modules like Purchasing, Inventory & Order Management.
• Involved in architecting MDM model.
• Built Data mappings for ETL layer for MDM from EBS, external and internal sources using INFORMATICA, PL/SQL code, SQL*Loader and UNIX shell scripts.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format and pull data from Web services and from XML format and parse it and load it into tables.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Working with Java Front-End Developers on building and modifying applications.
• Worked on styles using CSS, HTML and HTML and javascript.
• Used Bulk processing for performance enhancement.
• Created UNIX shell scripts using SQL*Loader, SQL*Plus and PL/SQL programs that run as nightly interfaces.
• Worked on generating EDI for STA, ASN segments and few custom based invoices belonged to Invoice, Status and Entry and Generic EDI for most of the customers for the EMS application.
• Was responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing PERL shell scripts & SQL *Loader.
• Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures.
• Involved in the required updates on the GUI front (JSP pages).
• Designed and completely implemented the front end components using JSP, XML and HTML.
• Written backend processes to extract XML records using DBMS XMLGEN package and xml-parser to load into tables.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Involved in Database Performance Tuning using Oracle Hints, Bulk binds, Explain plan, SQLTRACE, TKPROF, Partitioning and Indexes.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Supplied packages were used to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL FILE to read and write from database, DBMS SQL to write Dynamic SQL .
• Converted legacy data with over 2 million records, Performed application level SQL tuning.

Environment: Oracle 10g/11g, Oracle 11g,PL/SQL, DB2,Datastage,SQL Plus, Erwin 7.3,SQL Navigator, XML,DBMS XMLGEN, Shell Scripting, SQL*Loader, Shell Scripting,, SQL Navigator, SQL developer, Reports 10g/6i, JSP,CSS, Java/Struts/Ajax Framework, DBMS JOB,UTL FILE,UNIX shell scripting