oracle extract transform and loading resume

Creating this common source for quote data meansthat leveraging the same data resulting in much more consistency around respective analytic processes and reporting. This project is a great example of Operational Excellence, as it takes the basic quote data 'manufacturing' process out of the hands of Marketing and other functions, and creates an automated and centralized source for the quote data. Today in PL (Personal Lines) Applications, policy and quote data reside in multiple data marts, making itdifficult to analyze performance without significant manual intervention to pull all of the data, even prior to analysis. The primary objectives of the Data work stream are to create one common version of Quote and Policy data for Auto. Confidential, is one of the top 1000 sites in the world and is in the Retailers category. Good interpersonal, Analytical and communication skillsĬonsumer Pricing Initiate (CPI) has several work streams.Proficient in Unix shell and awk scripting.MS Word, MS EXCEL, MS Outlook Express, MS One Notebook SQL*Plus Editor, Microsoft Management Studio, Business Intelligent Studio (SSRS 2005/2008 R2), Oracle Developer, TOAD, iSQL*Plus, Informatica PowerCenter 7.x, 8.6, Visual Studio 2008, TURBO C++ IDE T-SQL, SQL, PL/SQL Developer, ETL Developer, Java DeveloperĬ/C++, T-SQL, SQL, PL/SQL, UNIX and SHELL Scripting, J2SE, J2EE (Servlets & JSP), HTML Health, Insurance and retail Domain, Credit Card Data Warehousing Extensive experience indeveloping PL/SQL Procedures, Functions, Packages and Database Triggers and debugging.Good working experience in Reports, PL/SQL,Oracle Databases8i/9i/10g and RDBMS Concepts.Good and Thorough understanding of system development process, from Initial planning through Deployment.Having Good expertise in all the stages of Full software development life cycle implementation (SDLC).Proficient in preparing Technical Design Documents and Unit Test Documents.Worked in both OLTP and Data warehouse Environments.Strong analytical and problem solving skills coupled with excellent written, verbal and inter-personnel communication skills. Self motivated team player with good communication skills. Expertise in Unit Testing, Integration, Functional, System, Performance, Load, Regression Testing and Validation Testing.

Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining Test scripts.

Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

Good ability to quickly grasp and master new concepts and technologies.Possess excellent oral / written communication and interpersonal skills.Significant experience working with clients, technical teams for executing concurrent multi-technology projects.Experience in advanced PL/SQL concepts like Bulk collect and FORALL.Experience working on Onsite/Offshore Model.Experience in other DBA activities like creating Tables, Complex Views, PublicSynonyms, and Database Links.2+ Years Experience in using Data warehousing tools like Informatica for ETL process 2+ Years Experience in working with Unix Shell scripts. Data Migration using SQL *Loader and TOAD Utility.Strong PL/SQL programming for data population and table alterations, Oracle Performance tuning/ SQL tuning and query optimization skills.Experience in Requirement capturing, System analysis, Logical and Physicaldata modeling, Development and Implementation of software applications.2+ Years Experience in creating and modifying forms using Oracle Forms 6i for data manipulation purpose and reports using OracleReports.5+ Years Extensive experience writing Database Triggers, Stored Procedures, Functions and Packages using PL/SQL.Extensive and proven experience using Oracle 8i/9i/10g/11g, SQL, PL/SQL, SQL* Plus, SQL*Loader, Informatica.Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema for faster and effective Querying for the Metadata Management solutions.Good understanding of database client/server configuration on Oracle 8i/9i/10g, SQL Server 2005/2008 and DB2.6 Years of experience in Oracle Development.4 Years of extensive experience in the Data Warehousing Environments.Database Development with Around 6+ Years of experience in ETL/Oracle environment as Programmer Analyst/ Developer using most of the Oracle related tools under UNIX and Windows environments.

Oracle extract transform and loading resume