SUMMARY

• 7+ years of experience in software development of databases that include Design, Analysis, Development and Deployment of software related to database application systems and database administration.
• Extensive experience in analyzing business requirements from end users and developing open interfaces, reports, and forms from conceptual stage to implementation and migration to Production environment.
• Experience in analysis, design, development, testing, implementation and production support of businesses using Oracle Applications (11i/R12)
• Good understanding of Data modeling concepts such as Design of the Dataflow, ER Diagrams (Erwin 3.1), UML, Use Cases (Oracle designer 6i/2000), Normalization and De-normalizationof Tables.
• Strong knowledge in Oracle 10g/9i/8i database programming using PL/SQL (Stored Procedures, Functions, Packages, Triggers), developing Replications and standard built-in Oracle packages in UNIX environment.
• Expertise in Creating and Maintaining Database objects like Tables, Indexes, Views, synonyms etc.
• Extensive ETL and data integration knowledge using Informatica PowerCenter 7.1/ 8.1.1/9.1.0
• Created Business components, source and target structures, transformations, mappings, using Informatica’s Source Analyzer, Warehouse Designer and Mapping designer components necessary for loading data into data warehouse environments.
• Sound knowledge in building OLAP databases and maintaining them.
• Adept knowledge in writing UNIX shell scripts and Perl scripts for parsing data files, formatting, cleansing, loading into database and scheduling cron jobs, batch processing, ad-hoc report generation.
• Experience in tuning of complex SQL statements using oracle Hints, Explain plans and trace sessions and in partitioning of tables and indexes.
• Used SQL*Loader, External table, PL/SQL procedures, Data pump utility to facilitate data import/export from staging tables to production tables.
• Experience in writing proficient Dynamic SQL queries using both Native Dynamic SQL and DBMS_SQL.
• Worked with BLOBS, CLOBS, XML Files, Flat files on file systems using seed packages like UTL_FILE, DBMS_LOB.
• Involved in User Acceptance Testing involving data validation, data integrity, functional testing, integration testing and system testing.
• Experience with bug tracking tools like JIRA, bugzilla and project planning tools like Rally.
• Worked on version control systems like SVN, CVS.
• Interacted with all levels of the project development team, from end users to Software Architect, Technical Lead, Database Administrators and System Administrators.
• Excellent analytical skills, logical reasoning, interpersonal skills.

SKILL SET

RDBMS Oracle 8i/9i/10g/11g, SQL Server 2000, MS Access.
Languages SQL, PL/SQL, PRO* C, C, C++, VB 6.0, Java, Unix Shell Scripting, Perl
ETL Tools: Informatica PowerCenter 9.1/8.1.1/7.1, Pentaho Data Integration 3.2/2.8/4.1
Tools Developer 2000, Forms 9i/6i, Reports 9i/6i, SQL*Plus, SQL* Loader,
MS Excel, TOAD, SQL Navigator, Data Loader, XML Publisher.
Design Tools: ERWin 3.1, Designer 9i, JDeveloper, Developer 2000

Operating System UNIX, Windows XP/2000/98/95, MS-DOS, SunSolaris, CentOS, Source Code Control - PVCS.

EDUCATION

Bachelor of Engineering,
Masters in Engineering Systems,

PROFESSIONAL EXPERIENCE

Confidential,Bethesda, MD. (July 11 – present)
Sr Oracle developer
WealthEngine provides the most comprehensive screening and research tools available and gives data access to the best US and UK databases available for hard asset and biographical data mining and provide the ability to pinpoint the top prospects. The company is leading in the wealth identification and prospect research field with powerful market intelligence technology and35+ wealthdatabases.
Project Description: Project involves extensive data parsing which is derived from different sources. The main objective of this project involves working with name and address data, which has to be parsed into the objects which eventually provides clean data to help the clients to look for in the respective fields.
Responsibilities:

• Created packages to parse the data with multiple functions and procedures.
• Used bulk collects and for all updates within the procedures to process the data of different size up to maximum of 120 million records.
• Processed the data by partitions to load them into the objects.
• Extensively used Regular expressions with the coding to search for patterns in string data by using standardized syntax conventions.
• Used Native Dynamic SQL code in PLSQL procedures for handling individual partitions
• Widely used collections like V-arrays with the procedures to improve processing time and efficiency
• Coded the functions for conversion of Word to Number, Street suffixes and Unit prefixes which are part of the addresses to be parsed and incorporated in the package, providing the customers to view clean address data.
• Created Object types which contain attributes and methods are stored with the data in the database, so they are available for any application to use. Customers enter a particular search ID in the application and they will be presented with the required data which makes it easier for them to view.
• As part of the development team, extensively worked also with the DBA team to load huge data files.
• Written shell scripts to invoke the sql loader jobs to load the daily files.
• Created tables by partitioning using range, list, hash and composite partitions.

Environments: Oracle 11g, PL/SQL Developer, SQL plus, TOAD.

Confidential,Houston, TX. (Jan 11 – July11)
Oracle developer
Cameron is a leading provider of flow equipment products, systems and services to worldwide oil, gas and process industries. Cameron works with drilling contractors, oil & gas producers, pipeline operators, refiners and other process owners to control, direct, adjust, process, measure and compress pressures and flows. It has several manufacturing plants across the globe.

Project Description: Project Cameron is an oracle to SAP conversion project. It involves working with the Oracle, Data services and SAP teams. The main goal is to load the data into respective objects which were implemented in the Oracle applications to the functional specifications of the SAP team. I have created packages and loaded the data from the source objects into the temporary objects, which were used by the Data Services team to load them to SAP target.
Responsibilities:

• Involved in requirements gathering, design, development and implementation of the project.
• Extensively used Dezign tool for data modeling new structures in the project.
• Created Oracle tables for the BILLING, AP and INVENTORY according to the business requirements of the SAP.
• Created Packages to move the Oracle data into temporary Oracle tables, which were used by the data services (SAP) to migrate to SAP.
• Created main package to validate the data when the data is staged in the temporary objects, which gives the summary and details of the objects.
• Created Procedures with UTL_FILE package to write the data to files, which are registered in the concurrent programs where they can be executed.
• Involved in writing manual ETL scripts in PL/SQL and SQL to extract data from multiple Loaded XML source systems.
• Used Native Dynamic SQL to write efficient Dynamic SQL queries with Execute Immediate and bind variables.
• Developed reports for the validated data in Reports builder.
• flat files into Oracle tables and generated XML files from databases, using UTL_FILE, XMLGEN packages.
• Created Concurrent program requests in Oracle Applications to run the reports through XML Publisher Administrator and generate the reports in EXCEL format for business validation.
• Created Packages for the reports which can be directly sent to email when it is executed through the Concurrent Programs request (Oracle applications).

Environments: Oracle 10g, PL/SQL Developer, SQL plus, Design tool, Oracle Apps,
EBS R12, XML Publisher, Oracle Forms & Reports 10g.

Confidential,Alexandria, VA. (Jun 08 – Jan 11)
Oracle/ Informatica ETL Developer
Agentrics serves as an agent in assisting retailers, manufacturers, trading partners with optimizing shared business processes to more effectively server the consumer. They have a suite of web based products for Spend Management, Private Label Management etc.

Project Description: Project Genshare is aimed at building single environment for Registration of suppliers and buyers, conducting auctions, awarding the auction to the winning supplier. This Project is organized into different set of works like exporting auction data into Genshare for awarding, standard scenario creation, category tree management, building data warehouse for reporting, document management. As an Oracle Developer I was responsible for designing and developing most of the processes in the project and the entire ETL module.
Responsibilities:

• Involved in requirements gathering, design, development and implementation of the project.
• Modeled the data, and created ERD diagrams using Erwin 3.1. Built the complete schema in Database using the design generated. Constructed tables, indexes, views, sequences, synonyms, object types as necessary.
• Created Packages to export auction event data, user data, lot, items, bids, auction rates, bid ranks from sourcing databases to awarding database.
• Created standard scenarios to enable retailers to identify the best suppliers for a given auction for awarding
• Developed PL/SQL code for search functionality, where in users can search for events for a particular company or business unit, suppliers, time stamp.
• Created Advanced Queues and Queue tables for auction management, award notification etc. Built complex object types for storing the related data and to en-queing and de-queing data into queues.
• Written complex views using multi table joins for seamless retrieval of data for display on GUI
• Coded triggers for triggers export of data, awarding data and for storing valid data into the database.
• Coded general purpose and flexible solutions using Native Dynamic SQL, by placing dynamic sql statements into PL/SQL blocks.
• Developed a process to manage category trees for events. This process gives the users the ability to associate the events, items to a particular category.
• Designed a data mart to hold data from various sourcing systems for reporting purposes
• Analyzed the functional specs and created technical specs documents for all the mappings.
• Converted the data mart from logical design to physical model , created all the objects , constraints , indexes and automated the scripts for db builds.
• Extensively worked on creating all the necessary Informatica mappings using Power Center to load survey data from multiple source systems into staging and datamart.
• Used transformations like look up, joiner, rank and source qualifier for applying several layers of parsing and transformations of the data.
• Used unconnected lookup, sorter, router, aggregator transformations when needed to load data as per business logic.
• Created necessary mapplets/worklet/workflows for pushing data into data mart environment.
• Created parameter files, variables and dynamic cache techniques to create generic and highly performing ETL.
• Written perl and shell scripts for invoking various batch load jobs and scheduling.
• Involved in performance tuning of queries and stored procedures.
• Written sql scripts and wrappers scripts for generating adhoc reports for a company, business unit or user, auctions etc.

Environments: Oracle 10g, PL/SQL, SQL Plus,TOAD, UNIX, PRO* C Informatica PowerCenter 8.1, Workflow Manager, Workflow Monitor, Erwin 3.1

Confidential,Vienna, VA.
(June 2006 – May 2008)
Oracle Developer
About EPA: Environment Protection Agency influences and regulates human activities to protect and restore environment. They are responsible for the protection of air and water quality, and the control of pollution, waste, noise and radiation.
Project Description: The Facility Registry System (FRS) is a centrally managed database that identifies facilities, sites or places subject to environmental regulations or of environmental interest. FRS creates high-quality, accurate, and authoritative facility identification records through rigorous verification and management procedures that incorporate information from program national systems, state master facility records, data collected from EPA\'s Central Data Exchange registrations and data management personnel. The FRS provides Internet access to a single integrated source of comprehensive (air, water, and waste) environmental information about facilities, sites or places. As an Oracle Developer I was responsible for designing and developing ETL models to handle data related to the facilities and interests and associates them with FRS.
Responsibilities:

• Involved in requirements gathering, design, development and implementation of the project.
• Modeled the data, and created ERD diagrams using Erwin 3.1. Built the complete schema in Database using the design generated. Constructed tables, indexes, views, sequences, synonyms, object types as necessary.
• Coded general purpose and flexible solutions using Native Dynamic SQL, by placing dynamic sql statements into PL/SQL blocks.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, mapping and mapplet designer, Transformation designer for identifying different EPA based source systems, creating necessary structures and mappings as per specs.
• Tuning the mappings and sessions for optimum performance.
• Used Repository manager to maintain the metadata, security and reporting. Also used repository manager to maintain development, test and production mapping.
• Created ETL Procedures like parser procedure and a standardization procedure to break up the data values into distinct parts and identify missing data, match the data and ensure there is consistency and load them into respective tables.
• Written complex views using multi table joins for seamless retrieval of data for display on GUI
• Provided statistical reports that summarize the analysis made by FRS by integrating data collected from multiple sources/divisions to support in developing EPA rules.
• Facilitated automated job scheduling using UNIX scripts.
• Wrote UNIX shell scripts for automation activities involving data loading and extraction.
• Worked closely with quality assurance and development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to nail down the bugs.

Environments: Oracle 10g SQL, PL/SQL, SQL* Plus, SQL Loader, SQL Developer, TOAD, UNIX, Informatica PowerCenter 7.1

Confidential,Texas (May05 – May 06)
Oracle Developer
Retalix solutions simplify processes, optimizes assets, and drive growth throughout the supply chain right from warehouse to checkout.
Description: Project SCS ( Supply Chain Synchronization) is a CPFR tool aimed at improving visibility, quality, traceability and streamlining the supply chain process between retailers, manufacturers and their trading partners. As an Oracle Developer I was responsible for creating a batch data loading process, calculating KPI’s and loading them into the system, generate complex reports using Micro strategy 7.
Responsibilities

• Developed a batch processing system to load huge data files that we receive nightly from retailers into the collaborate tool. Written extensive Shell scripts to pick up data files sent by the retailers/suppliers, identify the format, cleanse the data, log the reject rows, and load the data into the database.
• Written SQL, PL/SQL scripts to aggregate user data based on the requirements and calculate Key Process Indicators data, which enables the end users to have clear visibility on key CPFR features like inventory on hand, availability for sales etc.
• Identifying the Data Warehouse Fact & Dimension Tables and Data Modeling
• Building the Star Schema & Snow Flake relationships between Query Subjects
• Designed complex reports using Micro strategy BI tool, by setting up the warehouse catalog, creating attributes, metrics, filters, prompts and scheduling the reports using narrow cast server to send reports to the customers in a timely manner.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Environment: Oracle 9i, PL/SQL, SQL* Loader, SQL Plus, TOAD, UNIX, Micro strategy 7.

Confidential,NJ (Sep 04 – May 05)
Oracle Developer
Innovative Benefit Planning is a company that combines innovation with integrity for Insurance companies across United States.
Project Description: Accessible Intelligent Medical Strategies (AIMS) is a reporting application used by clinical advisors who work for insurance companies for statistical analysis on drug types issued the doctors for the patients and there by target on doctors prescribing branded drugs to help benefit the insurance companies.
Responsibilities

• Automated the process of loading patient’s data records into the database. The data ran over a million rows and it contains patient, doctor, geographic, medical information.
• Analyzed and mapped the processes and data and producing a functional design.
• Created the necessary SQL objects as per the design and granted privileges.
• Written complex SQL statements using joins, sub queries and correlated sub queries to retrieve data as per the business requirements.
• Written complex procedures and functions for generating requested adhoc reports for different combination of criteria of doctors, patients, generic, branded, location, year etc.
• Written shell scripts to schedule the report generation process.

Environment: Oracle 9i, SQL*LOADER, Forms/Reports 6i, SQL, PL/SQL, Oracle9IAS, Oracle designer, TOAD