We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

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

Hire Now