.NET Analyst Developer

Summary:

• Overall * years of IT Industry experience with Oracle Application Development as Oracle (SQL, PL/SQL) developer.

• Experience in software development of databases that include definition, design, analysis, development and deployment of software related to database application systems.

• Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 10g, 9i, Forms & Reports.

• Expert in database design including data normalization and design of physical and logical structures.

• Expertise in Oracle database 9i, PL/SQL programming, building complex queries in SQL.

• Strong knowledge in Oracle 10g/9i database programming using PL/SQL queries, stored procedures, functions, triggers, and cursors.

• Experienced in Data analysis, Data Access, Data structures, Data Manipulations.

• Strong knowledge of Dataware Housing and Data Mart concepts

• Knowledge of ETL (Extract, Transform and Load).

• Thorough knowledge of Database Design and Data Modeling.

• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.

• Good analytical and problem solving skills, excellent communication and presentation skills. Enjoy working in a team as well as independently.

Technical Skills:

Languages: SQL, PL/SQL, Oracle 9i/10g

GUI: VB 6.0

RDBMS: ORACLE 8.0

Database: ORACLE®, Microsoft SQL Server and Microsoft Access

Platforms: Microsoft Windows® 2000, Microsoft Windows® XP.

Microsoft Tools: MS-Access, MS-Excel, MS-PowerPoint.

Web: HTML, XML

System Analysis: UML (Unified Modeling Language).

Professional Certification:

• Microsoft Certified Professional

Education:

• Masters in Information System

Virginia International University, Fairfax VA 22030, USA

• Masters in Computer Application

S. K. Patel Institute of Management and Computer Studies, Gandhinagar, Gujarat, INDIA

• Bachelors In Commerce

Concentration Accounting and Statistics

H.L.C.C. Navrangpura, Ahmedabad, Gujarat, INDIA

Professional Experience:

ERIE Insurance Jan 2008 – Till Date

Falls Church, VA

Role: Oracle PLSQL Developer/Analyst

Responsibilities:

• Gathered requirements required by the client.

• Developed user requirements and Functional/Technical specifications.

• Designed and developed Oracle database Tables, Views, Indexes, Sequences, functions, packages and Synonyms with proper privileges and these were incorporated in Oracle 9i and later on in Oracle 10g.

• Involved in design of master tables to store the business data.

• Transformed application logs into schemas.

• Actively involved in migrating applications to the new release versions especially Oracle 9i to 10g.

• Functioned as an analyst for the planning, analysis, design and development phases of the application.

• Developed queries, stored procedures in PL/SQL to populate tables at runtime to generate complex reports in Oracle 10gDB.

• Wrote queries to access, manipulate the data from database.

• Used XML applications, so that users can view XML documents with the ease and convenience that’s usually associated with HTML documents on the web.

• Worked with XML publisher and involved in formatting XML templates.

• Involved in creating E-R diagrams, Function Hierarchy diagrams, Data Flow diagrams using Oracle Designer 2000.

• Worked with Data Dictionaries.

• Involved in testing the Data Integrity of the new tables.

• Developed technical system documentation.

• Designed Oracle Logical objects including Triggers, Stored Procedures that help in automating various operations in the database.

• Worked with various functional experts to implement their functional knowledge into working Procedures.

Environment: Oracle 9i, 10g, SQL*Loader, PL/SQL, SQL Server, Forms 6i, Reports 6i, Visual Basic 6.0

Contact this candidate