SUMMARY:

• Excellent results oriented, 12 years of experience in IT; development of conceptual, logical, and physical data models; data quality; Data Scientist; RStudio, Scala, Advance Preductive Modeling; IBM DB2, SQL and PL/SQL development; administration, extract, transform, and load (ETL using Informatica, DataStage, Talend); Master Data Management; Big Data; Hadoop; Business Intelligence (OBIEE); Tabule, DAC; Job Control Management; solving object - relational mapping challenges; 24/7 production support; onsite/offshore experience, analysis of business and technical requirements, and mapping them to implementation strategies
• Over 8 years of extensive ETL experience using using custom complex PL/SQL scripts, SSIS, Informatica, and DataStage
• Over 7 years of extensive experience in managing and coordinating in blended on-shore/off-shore model to meet client deliverables
• Extensive experience in Designing, Developing and maintaining applications in data warehouse for Healthcare, Banking and Insurance and retailer industries
• Profound knowledge of the principle of DW using Fact Tables, Dimension Tables, Star schema modeling and Snowflake Schema modeling
• Great ability to work with Data Modeling, Discoverer, SSIS and understand healthcare businessess like Medicare and Medicaid
• Experience in using SQL Server, Enterprise Manager, Microsoft Business Intelligence Studio and writing procedures and analysing from Query Analyzer
• Extensive experience with ETL concepts in extraction, transformation and loading of data directly from different databases toFlat Files, Excel to database using complex PL/SQL logic
• Good understanding and working knowledge with Pre-Paid Solutions using Teradata, designing the database, in dealing with clients to gather requirements, understanding the Business requirements, Advanced Queing, product demonstrations, database management tools such as TOAD, and providing product support sessions on 24/7 basis
• Strong back-end processing with DBA skills including enhancing database performance, experience in understanding database architecture, data analysis, development, testing, and documentation of projects, expertise in using configuration management tools such as WinCVS, HP Open View, Service Call, and StarTeam 2006, Clear Case, Oracle Designer and good experience in using SQL*Loader to fetch data from Legacy Systems to Oracle Databases
• Comprehensive and in-depth experience in the System Development Life Cycle and the role of Database in this process and a self-motivated, responsible, and reliable team player with a set of strong technical skills
• Proven experience in using cursors, cursor for loops to fetch the data from different tables, creating data definitions and templates to print the check, creating XML reports for financial applications to populate the required fields such as check number and check amount, and setting up the payables to run the custom check print program using concurrent programs

TECHNICAL PROFICIENCY:

Operating Systems: UNIX, Windows 2000/XP/Vista/7/8.1

Databases: Oracle, Netezza, SQL Server, DB2, NoSQL, MongoDB, HBase, PostgreSQL, Teradata, Cassandra

ETL Tools: Informatica PowerCenter, IDQ, MDM, DataStage, ODI, SSIS/SSRS, Talend

Big Data and Cloud: Hadoop, MapReduce, Flume, HDFS, HBase, Hive, Pig, RStudio, Sqoop, Spark, AWS, S3, Scala, Oozie

Oracle BI Applications: OBIA 7.9.6/7.9.5 (Financial Analytics, Order Management and Customized)

Business Intelligence: OBIEE 11g/10g, Discoverer Reports, Answers, Analysis, Dashboards, XML Publisher, BI Publisher, Tabule

ERP: Oracle Apps 11i - Financials(AP, AR, GL), Order Managerment, Inventory

Languages: SQL, Dynamic SQL, PL/SQL, Unix Shell Script, SQL*Plus, SQL*Loader, XML

Job Scheduling Tools: Control-M, AutoSys, DAC 10g

Applications and DataModeling Tools: WinCVS, ClearQuest, ClearCase, GitHub, Jenkins, Borland StarTeam 2006, Erwin, Oracle Designer, Microsoft Team Foundation Server

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. Informatica ETL/ BI Consltant

• Responsible for all activities related to the development, implementation, deployment, database modeling, design, administration and support of ETL processes for large scale data warehouses
• Worked closely with business team, analyst, development teams, gather requirements and create specification documents
• Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling by using Erwin, Visio
• Extensively used parameter files, variables, paramaters like passing user name and passwords to connect to database and very stong hands on error handling experience in optimizing and provide the solutions ontime
• Created complex mappings and maplets with XML and Web Service Consumer transfromations and check results
• Configured match rule set property by enabling search by rules and created Trust and Validation rules and setting up the match/merge rule sets to get the right master records in MDM according to Business Rules
• Used Session parameters, Mapping variable/parameters and created Parameter files for flexible runs of workflows based on changing values for parameters dynamically like database passwords using EPV keys
• Created multiple environments for staging, to stage data from multiple sources and aggregate data before loading into target DW tables, experienced in moving data from Hadoop to multiple sources
• Created mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, XML, Expression, Lookup, Aggregate, Update Strategy and Joiner
• Created new table structures and modifying existing tables and fit into the existing Data Model. Designed and managed data models for Data warehouse supporting data from multiple sources on real time
• Managed the environment setup, maintenance and part of business meetings with business analysts and support groups to discuss new changes, enhancements and maintenance tasks and server maintenance, support 24/7
• Extensively involved in debugging to identify the issues in mapping and expert in solving analytical issues and troubleshooting the existing ETL bugs
• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client/Server
• Responsible in preparing migration document to move the mappings from development to testing and then to production repositories
• Performed Sim Corp installations, upgrades and many of end-to-end gold copy deployments and user profiles configurations
• Managed and supported the EPV process to sync the passwords into password vault to avoid all applications from hard coding the passwords in source code and properties files
• Extensive experience in managing and organizing on-site and off-shore teams to meet the client requirements and deliverbales

Environment: Oracle 11g, PL/SQL, Hadoop, Hive, Pig, HDFS, DB2, SQL Server, Netezza, Informatica PowerCenter, IDQ, MDM, Sim Corp Dimension Tool, EPV, ClearCase, TOAD, UNIX, Python, BMC Remedy, AutoSys

Confidential, Rosemont, IL

ETL/BI Application Developer

• Supported multiple internal applications and helped users with security and data related issues and support daily ETL process
• Designed and developed mappings standards and guidelines to improve the ETL performance and reports performance
• Responsible for day to day ETL process of loading customers, products, sales and CAS data from multiple data sources and make sure the aggregates were build; briefing books were delivered and make sure daily reports are available to users before the business starts
• Extensively worked on rewriting the informatica ETL into PL/SQL coding and vice versa.
• Responsible for requirement gathering and convert them to business requirement specifications and delivered excellent technical and function documentation, process flow diagrams for ETL jobs using visio and explain clients help them understand the process
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse
• Created shell scripts to call and execute informatica mappings and mapplets and scheduled these scripts into Autosys for executions
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse and implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them
• Involved in business meetings with business analysts and business owner groups to discuss new changes, enhancements and new developments for BI reports
• Effectively involved in business meetings with business analysts and business owner groups to discuss new changes, enhancements and new developments
• Implementation of SCDs in existing ETL interfaces for capturing slowly changing dimensions and load aggregate tables
• Mapped the source and target databases and identified derivations for each target column
• Managed team of 8 consultants at off-shore, schedule daily status calls, track deliverables and provide updates to clients

Environment: IBM DB2, Oracle 11g, PL/SQL, Talend, DataStage, Informatica PowerCenter, Informatica MDM, Tabule, Control-M, UNIX, HPSM, OBIEE 11g, Windows7

Confidential, Naperville, IL

Sr. Oracle ETL Consultant

• Effectively involved in business meetings with business analysts and business owner groups to discuss new changes, enhancements and new developments
• Analyzed business process workflows and assisted in the development of ETL informatica procedures for moving data from source to target systems
• Used Informatica Repository Manager maintained all the repositories of various applications, created users, user groups, and security access control and created migration documents
• Created complex mappings, mapplets using Informatica PowerCenter transformations
• Used workflow manager for session management, database connection management and scheduling of jobs
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions
• Created technical documentation, process flow diagrams for ETL jobs, DAC executions steps and oracle database tables using visio and explain clients help them understand the process
• Wrote complex user defined SQL queries for extracting the data from source systems
• Mapped the source and target databases and identified derivations for each target column
• Developed automated and scheduled load processes UNIX shell scripting and AutoSys
• Created technical documentation, process flow diagrams for ETL jobs and oracle database tables using visio and explain clients help them understand the process
• Resposible for project deliverables as an Onsite Coordinator and SME, schedule daily status calls, scrum calls and coordinate project work

Environment: Oracle 11g, PL/SQL, Informatica PowerCenter, MDM, Talend, SQL*Plus, SQL*Loader, TOAD, UNIX, Microsoft Visio, Windows XP, DataStage, HP Quality Center

Confidential, South Barrington, IL

Sr. ETL Lead

• Effectively participated in fixing the defects, creating the NSR’s and deploy the changes in production after successful testing
• Monitor daily loads and verify the new business, endoursements and payment tech processing
• Designed and created staging tables and provide mapping between target tables to load data
• Developed several batch reports and data extract reports by using complex queries and UTL files and packages for various teams in Confidential and maintained on 24/7 days
• Generated multiple data files for finance teams, product teams and business groups to understand data and improve business
• Performed various card related activities like insurance card activation/printing through different sources and processing ACH transactions to charge credit cards for membership renewals and new business
• Involved in processing payment tech processor, generating invoices and send welcome/invoice and thank you letters to insurance members
• Created extensive reports and trained call center team to help subscribes and members to deliver dispatches and services like fuel filling, towing
• Involved in testing and move the code from development, integration and to production after the successful testing
• Involved in technical documentation, process flow diagrams, ER diagrams for oracle database tables using visio and explain clients and help them understand the process
• Has extensive ability to maintain and organize on-site and off-shore teams and good direct contacts with clients

Environment: Oracle 11g, PL/SQL, Informatica PowerCenter, MDM, Control-M, TOAD, UNIX, Microsoft Visio, Erwin, Windows XP, DataStage, Control-M

Confidential

Sr. ETL Analyst

• Developed complex ETL processing steps using SSIS packages and configurations to load data from different databases
• Worked closely with clients, business analysts, product specilists to gather requirement and understand the client needs
• Effectively analyzed and worked on TriZetto products, Facets and QNXT and its backend databases
• Designed staging and destination schemas and cretaed mapping for core to stage A schema and Stage A to Stage B schema and mapping from Stage B schema to a MEDai flat file
• Created databases on development and QA servers and maintain database models
• Implemented process to deliver packages from dev box to QA box and generated batch files and profiles to provide easy access and able to run packages
• PubSub is the TriZetto’s internal component. Implemented the PubSub integration for all packages using complex Pub/Sub facilities, created jobs and job schedules
• Extensively participated in creating Pub/Sub metadata and build parameters and added parameter association to each packages with proper parameter to be identified and passed
• Created configurations and profiles to load packages into PubSub run control and log summary/detailed log messages while package executes
• Extensively involved in understaing 3 different databases to load data from and provided excellent solutions to client to satisfy requirments
• Effectively coordinated and lead team of 12 off-shore team and provide training to understand product and develop applications for clients
• Extensively particiapted in creating process trackers, technical documentaion and architecture documents

Environment: Oracle 10g, PL/SQL, SQL*Plus, Informatica, SQL Server Management Studio, SSIS, TOAD, Pub Sub, UNIX, Microsoft Visio, Erwin, Windows XP, Microsoft Team Foundation Server(TFS), Microsoft Business Intelligence Studio (BIDS), DataStage

Confidential, Atlanta, GA

Sr. Informatica Developer

• Open Loop Prepaid Cards provides a platform for payments processing solutions for Gift cards, teen cards, Pay cards such as point-of-sale (POS) services, fraud protection and authentication solutions, check guarantee and verification services and checking
• CMS (Card Management System) is the internal application used for processing real time transactions of card related activities and access other integrated functionalities on the Open Loop Platform
• Created test Informaica mappings and workflows identify and remove bottlenecks to improve the performance of ETL jobs
• Responsible for designing and modeling (Star Schema and snow flake schemas) using the conceptual, logical and physical data models, setting up variables and parameter files
• Performed various card related activities like Card Activation through different sources (like web, batch and IVR), Funding Cards, Processing POS transactions through OLTP database.
• Involved in processing ACH transactions, balance transfers and maintain transactions for consumers in Open Loop Platform
• Created DMART load (ETL) jobs and specs to load data from OLTP by creating MDM tables, staging tables, adding meta data, ref cursors, complex procedures, functions and call the procedures to load all target tables
• Implemented and maintained DMART data model by creating the dimension tables, fact tables, summary tables and mapping tables between OLTP and DMART databases
• Running daily ETL jobs to load all the data from OLTP into DMART database for historical data and load the log tables with each statements with start time, end time of processing and analyze if the query is taking too long and try to improve the performance using tuning concepts
• Developed several batch reports and data extract reports by using complex queries, dynamic sql queries, temporary tables and staging tables for various clients of FirstData and maintained on 24/7 days
• Verifying the ETL audits every day and compare from OLTP to DMART by writing complex queries and fix the audit mismatches
• Extensively involved in monitoring all DMART load jobs and provide production support for DMART database
• Created complex reports in discoverer reports to be refreshed after completing daily ETL loads and deployed reports on clients meachines
• Effectively participated in testing the code as per the requirements and guide QA team for further testing before moving the code to production
• Effectively answered for all the functional and technical questions, queries and issues requested by business people
• Implemented the special ETL load process in different ways for DEV, QA and CERT environments for testing needs, monitor loads and fix immediately if any issues
• Involved in technical documentation, process flow diagrams, ER diagrams for oracle database tables using visio and explain clients and help them understand the process
• Extensively maintained and organized on-site and off-shore teams and maintained good contacts with clients

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, Informatica, UNIX, Microsoft Visio, Windows XP, Clear Case, CA Service Desk, OLTP, DMART, CMS Application, DataStage Parallel Extender

Confidential, Cranford, NJ

Sr. Oracle Consultant

• Extensive understanding and analyzing Confidential ’s database, functional and technical requirements
• Understanding the Confidential ’s front end BPM application built for MyWork Project and also worked as DBA/Data Analyst to provide analysis to business users are get the new requirements from clients
• Effectively participated in fixing the defects, creating the NSR’s and deploy the changes in production after successful testing
• Oganizing live meetigs, conference calls with clients to discuss about the project status, analysis and requirements
• Worked as DBA to improve the performance tuning and credit trading data management
• Utilized UTL SMTP, UTL FILE, BULK COLLECT, COLLECTIONS, DB Links, Performance Tuning Concepts, Dynamic SQL, SQL*Loader to load the tables and tune the applications/databases
• Involved in calling Oracle Packages, Functions and Procedures from JAVA to populate the target tables with production data.
• Expertise in understanding Oracle Architecture and designing custome applications like My Work, HFT for Confidential and understand, analyze the SDLC Process
• Has a great ability to improve the performance tuning on datawarehouse application and effectively participated in imprving the perforance of the new and exisiting PL/SQL code
• Utilized the DBMS packages to connect to the FTP server, find files and move between servers and databases and send e-mail notifications as required
• Effectively involved in taking the initiatives of OWB application tasks, trouble shooting and support clients to help and identify integrity issues
• Involved in creating, executing the daily night jobs, weekly load jobs and monthly load jobs and monitor them and worked as Prodution Support and fixing the programs
• Involved in testing and move the code from SIT to UAT and to Production after successful testing had completed
• Involved in technical documentation, process flow diagrams, ER diagrams for oracle database tables using visio and explain clients and help them understand the process
• Has extensive ability to maintain and organize on-site and off-shore teams and good direct contacts with clients

Environment: Oracle9i/10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, UNIX, SQL Server 2000, JAVA, BPM Savvion Application, Microsoft Visio, Windows XP, Excel Macros, DataStage

Confidential, Franklin, TN

ETL Production Support

• Extensively involved in understanding and analyzing Anthem’s Healthcare ETL products
• Has extensive ability to maintain and organize on-site and off-shore teams and good direct contacts with clients
• Effectively involved in implementing, monitoring, maintaining and support the daily load jobs to populate the data into respective product tables
• Effectively involved in writing complex PL/SQL procedures and packages to load the data to Anthem’s Products Databases to build and support
• Utilized Oracle Database 10g, Oracle Discoverer 10g, OLAP, Oracle Apex 10g, SQL Navigator, TOAD, Dashboards
• Involved in writing complex procedures to be called in Oracle Application Express to build an apex report for Anthem’s Application for hospitals and CEO’s
• Has a great ability to improve the performance tuning of the new and exisiting PL/SQL packages, functions and procedures
• Utilized Oracle Discoverer 10g to build multiple worksheets, drill down reports to meet the clients requirements as their business needs
• Involved in meeting clients directly and understand the problem, explain them with a detailed solution and fix the issues
• Involved in creating, scheduling the daily load jobs, weekly load jobs and monthly load jobs and monitor them 24/7 days and moitor the database activities using Oracle Enterprise Manager
• Involved in DBA activities to provide priviliges and data analysis on production data and Teradata
• Effectively utilized Oracle Discoverer 10g to build, support and maintain the BI Reports, Portlets and Dashboard
• Effectively involved in creating and enhancements for forms and reprots with Oracle Application Express
• Involved in identifying the files received from client and make sure all the files are received, naming standards as the program automatically set the external table location and ftp the files from different servers and directiries
• Validate and correct the month end process amounts and data for all of Anthem’s Products
• Involved in creating and maintaining Tablespaces, test and production environments/servers
• Involved in technical documentation, process flow diagrams using visio and explain clients and help them understand the process

Environment: Oracle9i/10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, UNIX, SQL Server 2000, HP Open View, HP Service Calls, Oracle Discoverer 10g, Oracle Designer, Excel Macros, JAVA, Oracle Application Express (APEX), Oracle Portal, Dashboards, Microsoft Visio, Windows XP

Confidential, Milwaukee, WI

Sr. ETL Migration Developer

• Effectively involved in analyzing, creating and maintainig programs by writing complex PL/SQL procedures and packages to migrate the data from different environments
• Effectively involved in running and monitoring the performances of monthly, weekly and daily jobs and working with DBA teams to improve and recommend performance issues for various environments
• Involved in understanding, software development life cycle, analyzing the database design from a different legacy applications and identifying the solution to migrate the data
• Effectively participated in writing SQL*Loader scripts for data loads using direct and conventional loads
• Effectively involved scheduling, running and maintaining daily batch processess
• Extensively ivolved in involving with clients for business requirements and for technical support
• Extensively involved in utilizing the PL/SQL tables, partitions, bulk bind variables and colletions for understanding data extracts from legacy applications to load them into Oracle tables
• Extensively participated in migrating and upgrading Oracle 9i to Oracle 11g and also maintaining datawarehousing data in warehouse environments
• Effectively involved in troubleshooting/identifying abd fixing the PRAGMA EXCEPTION INIT errors, Materialized Views, snapshot errors and dead lock issues on tables to improve the performance and make sure all the objects are working correctly
• Effectively created SQL*Loader Scripts to perform the data loads from UNIX and VI Editior
• Effectively involved in testing, creating technical and functional documentation to understand the process
• Effectively participated in Coordinating and prioritize escalated activities/issues/bug fix’s including testing and implementation of system upgrades, enhancements and bug fixes.
• Extensively involved in resolving the production issues/data fixes, analyze and identlfy the changes and implement the code changes if required and maintain the functionality of the business

Environment: PL/SQL, SQL*Plus, SQL*Loader, TOAD, UNIX, SQL Server 2000, Oracle Portal, HP Open View, HP Service Calls, Oracle Discoverer 10g, BI OLAP, Oracle 10g, Oracle Designer, MS Office, Lotus Notes, Windows XP

Confidential, Nashville, TN

Sr.Oracle PL/SQL Programmer/Analyst

• CUPS is an internal custome application for Confidential built using VB Programming
• Working on CUPS, an internal application of Confidential that interacts with various other applications to build a complete healthcare package
• Managing a team of three members at off-shore in assigning the jobs and coordination with on-site team
• Developed interfaces using PL/SQL procedures and created packages to load data into targeted Oracle database
• Participated in designing and developing Web Design Layouts, implementing user interfaces and also creating BI OLTP/OLAP application processs to load, moniter and maintan the data and keeps refreshing for immediate data retrival usage
• Effectively involved in understanding and creating batch processing for Applications and moniter them and provide 24/7 technical support to clients
• Involved in building and maintaining CUPS Application using JAVA for Healtways to process and load healthcare data like pharmacy claims, medical claims by passing some parameters from Oracle Packages and Procedures.
• Participated in data modeling for production and testing databases using Erwin and involved in working on IBM DataStage to build ETL processsess
• Utilizing PL/SQL Tables, user defined record types, Materialized Views, ref cursors, Advanced Queing, CLOB, BLOB, Performance Tuning and Optimizer Hints, Pipelined Functions, Oracle Data Query, Query Analyzer to improve the performance and fetch the data faster from source tables to destination tables effectively
• Involved in building the applications using third or fourth generation languages like PL/SQL by writing complex packages, multi-terabyte databases, datawarehousing environments, procedures, functions with ref cursors to validate and reconcile the members data, claims data, utilization data, pharmacy data, and disease management data using informatica jobs and workflows
• Effectively involved in writing SQL*Loader scripts to load data into Oracle tables from different file formats
• Upgraded 6i client server Oracle Forms and Reports application to web based 10g and ran the application through Oracle Portal and Single Sign-on
• Testing the module and creating test plans and technical design specification documents also participated in production support and 24/7 on call support
• Checking in/ out the project documents and source code to servers using version control management tool StarTeam 2006 and assigning task numbers, bugs to each developer who owns the module
• Participated in creating and updating technical, functional documentations to explain the data flow and process flow of the business

Environment: PL/SQL, SQL*Plus, SQL*Loader, TOAD, SQL Server 2000, Borland StarTeam 2006, Oracle 9i/10g, OLTP, UNIX, DataStage, CUPS Application, Oracle Portal, Oracle Discoverer 10g, Microsoft Office, Windows XP

Confidential, San Frascisco, CA

Oracle Apps Developer

• Customized the standard check format print report, imported the same report into account payables, and printed the invoice check amount as per the client requirement
• Created custom functions, stored procedures and packages using Oracle ref cursors to retrieve, validate and process the data
• Upgraded the Web based application to Oracle Portal
• Involved in creating and modifying the architecture for BOM
• Utilized OLAP, OLTP, Oracle Tuning, Hints, Materialized Views, CLOB, BLOB, Advanced Queing, cursors and cursor for loops to fetch the data faster and effectively from different tables extensively
• Effectively involved in installing Oracle Application Server and supporting
• Effectively involved in creating and maintaining fixed incomes and bonds
• Provide guidance and documentation for upgrade from 9ias Version 1 to 9ias Version 2 Oracle Portal and Oracle Discoverer. Provided trouble shooting and deployment assistance.
• Experienced in participating in walkthroughs, Iteration design and problem resolution
• Effectively involved in understanding and creating data flow, technical flow diagrams
• Wrote Unix Shell Scripts and SQL*Loader Scripts to load the Oracle Tables
• Deployed customized reports in the applications, calling the reports from the back end by using stored procedures, and functions
• Extensively managed on-site and off-shore teams by providng the technical user training manuals/materials for Discoverer and Oracle Portal
• Uploaded the files to configuration management tool WinCVS

Environment: Oracle 9i/10g, PL/SQL, UNIX Shell Scripts, SQL*Plus, SQL*Loader, Forms 6i/9i, Reports 6i/9i, XML Publisher, OLAP/OLTP, Discoverer, TOAD, Oracle Portal, UNIX, MS-Visio, Informatica, Windows XP

Confidential, Santa Clara, CA

Oracle Apps Developer

• Worked on the program that is to update the resolution code and notes of Service Requests, if any Service Request does not get closed for whatever reason, the list of those SR #’s that did not get closed should be emailed to the person who requested the batch update as well as displayed in a report/ concurrent request output
• Effectively involved in understanding and creating data flow, technical flow diagrams using ERWin
• Participated in declaring global variables, record types, collections, cursor variables, bind variables, co-related queries and oracle joins extensively
• Worked extensively on PRAGMA autonomous transactions to solve and fix mutating table errors
• Created database triggers to update the transactions on database objects before or after the event occurs
• Managing on-site and off-shore teams during code review sessions and production work
• Participated in fetching the data using cursors, ref-cursors, and record types
• Utilized Materialized Views and built-in packages to debug the errors and solving the database errors
• Created packages extensively to update the status of service requests on the customers form
• Effectively involved in creating efficient technical documentation for non-technical users and providing guidance to better expalin the process plan
• Wrote Unix Shell Scripts to download the files and upload the files from server
• Participated in writing SQL*Loader scripts to load the data from flat file to preferred tables

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, SQL*Plus, ERWin, Discoverer 10g, UNIX Shell Script, Forms 6i, Reports 6i, TOAD, Workflow, Microsoft Visio, Windows XP

Confidential, San Jose, CA

Oracle Apps Developer

• Worked on the application that is to move the data from staging tables to Oracle Standard Interface tables using PL/SQL, a custom stored package that will be used to perform applications required translation/ validations, and provide required output error/ log reports
• Participated in creating stored procedures, Materialized Views, functions, Oracle Packages and Oracle Ref Cursors extensively
• Effectively involved in migrating Oracle Forms and Reports applications to J2EE using Oracle JDeveloper
• Effectively involved in understanding and creating data flow, technical flow diagrams
• Participated in creating custom staging tables, interface tables, and temporary tables to map with oracle tables
• Effectively involved in creating and maintaining fixed incomes and bonds
• Participated in creating database links to connect to remote database and System Development
• Involved in writing JAVA classes to build the application and connect to Application server and complete the business process
• Participated in creating database triggers to update the transactions on database objects
• Effectively involved in creating efficient technical documentation for non-technical users

Environment: Oracle 9i/10g, PL/SQL, SQL*Plus, UNIX Shell Script, TOAD, Workflow, JAVA, Discoverer, Forms 6i, Reports 6i, Windows XP, HTML