Summary:

• 6 years of experience as an ETL Developer in different IT domains like Pharmaceuticals, Educational, Airlines, Healthcare, Consulting, Financial, and Retails.
• Expertise in Data warehouse development and systems using Oracle 10g/11g, SQL Server Teradata, DB2, UDB, SQL, PL/SQL, Informatica and UNIX Shell Scripts at various stages of Data Warehouse, Data Conversion, History Data Migration and ETL projects.
• Experienced in understanding Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Strong knowledge in writing complex PL/SQL Packages, Stored Procedures, XML DOM Parsers, Triggers, Performance tuning, Application tuning and Query Optimization using Hints, Explain plan, TKPROF.
• Worked on Reporting tool Cognos 10.1 to develop complex reports using Report Studio, Business Insight Advanced and Query Studio.
• Actively participated in gathering business requirements for ETL needs.
• In Depth experience in using Informatica transformations like Router, Update strategy, Connected/Unconnected Lookup, Aggregator, Stored Procedure, User Defined Functions, Techniques for pivoting rows to columns and columns to rows.
• Proficient in Normalization/Denormalization techniques in relational/dimensional database environments.
• Involved in the design, development and testing of PL/SQL database applications to support project delivery, production systems and business development activities.
• Proficiency in designing physical database objects based on data volumes, CPU utilization, end user data accessibility, archival and load strategies for the optimized database performance.
• Excellent proficiency in managing the entire testing process using Global Test management tool HP Quality Center.
• Currently playing Senior ETL Developer role at University of California at San Diego UCSD .
• Designed complex ETL mappings, reusable transformations using Regular Expressions, Dynamic Lookups, and Update Strategies for slowly changing dimensions, critical performance tweaking stages with partitioning, persistent cache, and extensive use of mapplets for common sub routines.
• Improved ETL performance by implementing Archival strategy, partitioning, using Parameter files at the session level and fine tuned SQL with unwanted loops, indexes, and pagination and recursive indexes between parent and child tables.
• Excellent communication skills to effectively communicate technical information to end users and ability to work individually on multiple projects
• Experience with software Development life cycle SDLC process performing detailed analysis, collecting requirements, document requirements, coding and unit testing,
• Integration and system testing.

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Successfully implemented FannieMae's major SOX remediation initiative in eBusiness Datawarehouse by tightening Database Security, Segregating Duties, Auditing Actions and Setting up Access Controls.
• Implemented the conversion/upgrade of all Oracle 9i databases 20 of them to the latest version of Oracle 10gR2.
• Instrumental in a major conversion effort of converting 15TB Sybase Data Warehouse to Oracle.
• Consolidated small databases supporting mortgage applications in Microsoft SQL Server environment to Oracle infrastructure.
• Advocated and implemented the Block Change Tracking BCT feature of RMAN in backing up Terabytes sized Oracle Data Warehouse databases.
• Assisted Developers, Business users and External clients with performance tuning database queries and production processes to meet or exceed current SLA levels.
• Worked with ER Studio to analyze logical data models and generate physical DDL scripts for schema generation. Also used this tool to reverse engineer schemas from production to generate baseline data models.
• Worked with Autosys batch scheduling tool to automate running of several database tasks by writing JIL scripts and Korn shell scripts.
• Used Oracle Enterprise Manager Grid control to monitor UNIX hosts, Database targets in a RAC environment. Created backup schedules, defined custom metrics, generate reports and acted upon the alerts to remediate the issues.
• Take part in Database object design and support Release migrations for business processes.
• Participated in the implementation of Data Guard in production environment and performed fail - over/fail-back on a regular pre-defined schedule.
• Diagnosed Backup/Recovery issues and re-jig the backup schedule for optimum survivability of production database instances.
• Involved in the performance tuning of Datawarehouse and Datamart instances for increasing throughput of AbInitio ETL processes/graphs and reducing the turnaround times for SQL queries issued by Business users.

Environment: Oracle 10g 9i, Sun Sparc E6500, SunFire 4800 Blade Servers, Solaris 2.8, Solaris 10

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers and Application Owners.
• Involved in the development of the Conceptual, Logical and Physical data model of the Star Schema using ERWIN.
• Extracted data from various Source Systems such as Oracle, Sql Server, Flat Files, and DB2 as per the requirements.
• Designed and developed several complex mappings using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer.
• Used Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and rectified them.
• Worked on performance tuning of the ETL processes. Optimized/tuned mappings for better performance and efficiency.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Environment: Informatica 6.2, Oracle 9i, OLTP, PL/SQL, SQL Server, DB2, MS Excel, UNIX Shell Scripting, TOAD 7.1.

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

Requirement gathering and analysis

• Create design document
• Create work estimate based on technical specifications
• Review Defect Tracker, review defect tracker on weekly basis and identify the problem areas and communicate accordingly to project team to perform causal and impact analysis
• Analyze source and target systems to decide on data enrichment process
• Create different mapping using Informatica transformations based on different business requirements
• Design and schedule different Business objects reports based on requirements from the business users.
• Created and maintained Sybase/DB2 Database Objects like tables, views, indexes, constraints, sequence.
• Monitor and involve in Code Reviews and preparing unit test plan
• Defining and reviewing the coding standards, besides reviewing the code.
• Analyzing performance of database objects and suggesting DBA for Indexes, schema gathering, partitioning.
• Extensive Performance tuning for optimized results
• Implemented business rules by using database triggers.
• Participated and contributed in discussions about database issues, performed applications tuning by analyzing trace files and explain plans.
• Supported development and test databases for on-going development and testing.
• Process Management, Formulation of processes and roll out, Defining standards, guidelines policies and Documentation. Monitor execution of required processes.
• Worked extensively in tuning SQL and Stored procedures, identifying and resolving tuning issues. Implemented Indexing and Security Management.
• Expertise in setting up Autosys jobs in UNIX and Windows.

Environment: Sybase, UNIX Shell Scripts, SYTS, RGS, Perl, Autosys Informatica 8, DB2 UDB, Business Objects X, XI

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Setup and administered all aspects of Integrated Marketing Data Warehouse on HP-64-bit Oracle platform by migrating from Sun E10K-32-bit Oracle platform.
• Implemented a scalable 4-node Oracle RAC system using Linux Servers, FC SAN switched fabric topology, OCFS, and ASM TAF.
• Solely developed the Business Continuity Management plan, disaster recovery solution, and implemented it using EMC SRDF solution of disk group level replication.
• Instrumental in revamping security of all Oracle databases by applying Critical patchsets released by Oracle, participating in developing extensive in-house Oracle Database/UNIX Security Standards, Implementing recommendations of internal Corporate Vulnerability Assessments Review, and implementing Auditing programs to keep databases Compliant.
• Lead Oracle production DBA for bank-wide core strategic initiatives Full exposure to Project Management concepts and SDLC Interact with Department Leaders and Business Area heads for scoping out deliverables and SLA's.
• Expert at Performance Tuning - Solely Designed the kernels for HP boxes Designed/Architect storage layout for all Oracle Production databases Configured Veritas Volume Manager stripe width/stripe depth and Setup right Oracle Block sizes for optimal performance.
• Managed a team of 6 people that was responsible for core Architecture Design, Implementation, Security/Risk assessment, Performance Tuning, Recovery and Capacity Planning.
• Served as the primary contact for all software vendors, worked out licensing arrangements, maintained software inventories, and managed Computer Software budgeting expenses.
• Setup and administered Oracle Portal 10g Application Server OAS Internet site that served NFL Customers using Oracle Identity Management's Single Sign-On SSO core feature, Oracle Internet Directory OID and Secure Sockets Layer SSL .
• Setup and maintained all third-party software applications/tools like AbInitio, Essbase, SAS, Cognos Power Play, Cognos Reportnet, Unica Affinium Campaign Manager that access Oracle. Integrated Oracle Marketing Datawarehouse to perform analytics.
• Supported 200 power analytic users to effectively use the tools in generating marketing leads and automated production processing using Tivoli Maestro job scheduler, UNIX crontabs.
• Setup resource allocation policies for effective utilization of computing resources by implementing HP Process Resource Manager PRM at the UNIX level and Oracle Database Resource Manager for managing resources at Oracle level.
• Mentored Junior DBA's and developed department wide standards for Development and Production scripting and processing.

Environment: Oracle 10g 9i, HP-UX 11.11 PA-RISC, HP RP8420, Sun Sparc E10K, Solaris 2.8

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Analyzed all business functionality related to back-end database interfaces and utilized PL/SQL developer tool in developing all back-end database interfaces.
• Designed the conceptual, logical and physical model according to the requirements using Erwin.
• Worked on Logical and Physical Data Modeling to gather the business requirements and convert them into models and design the databases.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL Plus.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code PL/SQL .
• Used UTL file in packages to read/write the data from/to a flat file and SQL Loader for migrating flat file data into target.
• Involved in OLTP Process.
• Created tables using Toad as well as created and managed roles for different users to access database objects.
• Written various Triggers, Stored Procedures to perform or automate many of the tasks.
• Optimized SQL queries used in Reports and Stored Programs Procedures, Functions and Packages to improve performance drastically.
• Created Database Triggers, bypassing the mutating table errors, use of row and statement level triggers for advanced auditing of changes made to a table and Oracle Functions and Procedures to centralize the business logic in the database.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries
• Develop the supply chain management application go-live support environment, construct the transition plan from the project team to the support team, and support and maintain the client applications and technology infrastructure
• Monitored the Performance during Beta - Testing phase of the application.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets.

Environment: Oracle 10g PL/SQL, 11g, SQL Loader, MySQL, UNIX, Toad 8, Crystal Reports XI/8.5 Designer 2000, Oracle Forms and reports, Windows 2000, Erwin 4.1, MS Excel 2007, Windows 2008 Server.

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions etc.
• Develop/Modify data migration tool scripts
• Design and develop post migration reports part of data consistency check.
• Data Migration and Post Implementation Support
• Involved in Preparing Detailed technical documents
• Involved in Code Review and preparing unit test cases
• Involved in Writing Backend Procedures, Function Packages in PL/SQL
• Trouble shooting and provide 24x7 supports for Production environment.
• Maintained the data integrity and security using integrity constraints and database triggers
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Involved in the analysis of the existing database.
• Defining and reviewing the coding standards, besides reviewing the code.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans.
• Customization of code as per the user requirements.
• Involved in the application tuning of database by identifying the suitable indexes.
• Designed and extensively worked on project documentation.
• Data modeling, database design and creation of database using data modeling tools Creation of Data Flow diagrams and Entity Relation Diagrams using MS Visio.
• Extensively involved in database design and creation.
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization.
• Co-ordination between development, testing and production teams and attending bridge calls and technical. Discussions regarding future developments and releases.

Environment: Oracle 9i, 10g, SQL Loader, UNIX, Windows XP, Pl SQL Developer. MS-VSS