SUMMARY:

• Around 3+ years of experience in IT industry in the field of Business Intelligence as SQL Developer and Data Warehousing Expert, demonstrating in - depth knowledge and understanding of Analysis, Design, Development, and Performance tuning of applications using Oracle SQL, PL/SQL.
• Strong conceptual knowledge in Data Warehousing, OLAP, OLTP.
• Good exposure and experience in Oracle RDBMS (SQL, PL/SQL).
• Basic knowledge of ETL Tools like Informatica Power Centre 9x/8x/7x versions.
• Knowledge in BI Reporting Tools like OBIEE and Excel Pivoting.
• Proficient in Dimensional Modeling (Star and Snow Flake Schemas) and RDBMS Concepts.
• Have been through multiple iterations of successful data warehouse projects.
• Expertise in Client-Server application development using Oracle, PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.
• Design and generation of different Database Objects like Tables, Views, Synonyms and Sequences, PL/SQL packages and Database Triggers.
• Proficient in writing Packages, Stored Procedures, Functions, Views, Materialized view and Database Triggers using SQL and PL/SQL in Oracle.
• Excellent experience in working on UNIX Shell Scripting.
• Good experience in analysis, design of database and created ER Diagrams on Rational Rose using Normalization Techniques.
• Good Understanding of Data Modeling Concepts.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Good knowledge of dynamic SQL, PL/SQL collections and exception handling.
• Positive attitude with good Presentation Skills, hard working in nature, Believe in team work and decision making by consensus, capacity to withstand pressure, no geographical barriers.
• Ability to adapt to new skills and technologies and dedicated to maintaining high quality standards.
• Highly capable of handling Teams and efficient with Project Plan and Estimations.
• Analytical and Technical aptitude with ability to work in a fast paced, highly flexible environment where in-depth knowledge of technology, hard work and ingenuity are highly appreciated.

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows NT/XP, Windows 7

ETL/BI Tools: Informatica Power Center 9.x, OBIEE

Languages: C, C++, T-SQL, PL/SQL, UNIX

Scripting: SQL, UNIX Shell Scripting

Databases: Oracle 8i/9i/10g/11g, SQL Server, MS Access, My SQL.

Web Technologies: HTML, XML

Scheduling Tools: Control-M Enterprise Manager, Autosys

Data Modeling: Erwin, ER Studio, Toad Data modeler, MS Visio, OpenOffice, MS Office

Tools: TOAD, SQL developer, SQL*Loader, SQL*Plus

PROFESSIONAL EXPERIENCE:

Confidential

SQL BI Developer

Responsibilities:

• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Developed several database objects such as tables, triggers and views and also stored procedures.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Studied the existing environments and accumulated the requirements by interaction with various aspects.
• Successfully loaded data from an EXCEL, Access, Flat files into a SQL Server database.
• Written several stored procedures to achieve various functionalities of the system.
• Assisted the Application team in data modeling and T- SQL coding.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables

Environment: Visual Basic 5.0, Windows NT, T- SQL, EXCEL, Access, SQL Server Enterprise Manager, SQL Profiler.

Confidential

PL/ SQL Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Worked on the project that involved development and implementation of a data warehouse.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using PL/SQL in Development and Production environment for Oracle.
• Maintained security by creating users and giving appropriate permissions to users.
• Developed ER models using Erwin data modeler.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and maintaining logs.
• Involved in performance tuning and monitoring of PL/SQL blocks.
• Wrote PL/SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Responsible for Cleansing up database for Maintenance of the database.
• Responsible for unit testing, writing design documents.

Environment: Windows 2003 Server, Oracle 10g, PL/SQL, Erwin Data modeler, MS Office

Confidential

SQL Developer

Responsibilities:

• Gather and translate business requirements into an application design.
• Create System and Functional Requirements.
• Designing Database according to the requirements.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Designed ER model using MS Visio for all the modules involved in the project.
• Created various database objects needed for the system.
• Imported data from various excel sheets and .csv files into the database.
• Created course offerings view with the fields required for the website.
• Created stored procedure that helps in student registration.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Wrote complex queries needed to fetch data from database to generate various reports.

Environment: ASP.Net using C#, AJAX, JavaScript, HTML SQL Server 2005, IIS Server, MS Visio