OBJECTIVE:

To use my extensive hardware/software academic knowledge to make significant contributions within the IT sector by defining, designing, coding, and testing solutions for complex business problems.

SUMMARY:

• Over 4 years of programming experience as an SQL/Oracle Database Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against deadlines.
• Experience with Data flow Diagrams, Data Dictionary, Database normalization, Entity Relation Modeling and Design Techniques.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, SQL *PLUS, TOAD and SQL*LOADER.
• Loaded Data into Oracle Tables using SQL*Loader.
• Experienced in DDL, DML, DCL Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Developed ASP.Net Web Application and Windows application using C#.Net in .Net framework with Entity Framework.
• Good experience in DOTNET(C#,VB.NET),Visual Studio with all higher versions.
• Worked with Dot Net Toolbox Controls and Ajax Controls.
• Worked with LINQ.
• Worked with different domains like Health Care, e-Commerce Web Sites,, Data Warehouse.
• Good experience in MS Excel.
• Good experience in HTML5 and CSS3.
• Good understanding of the oracle database, related utilities and Tools.
• Good experience in writing stored procedures, functions and views.
• Good experience in writing and tuning complex sub queries, correlated queries, SQL, stored procedures, functions, packages, cursors, collections and triggers.
• Created Oracle objects Tables, Views, Constrains, Synonyms, Sequences.
• Experience in Pivot and Unpivot data.
• Experience in Database design using Normalization and E/R Diagrams
• Experience in Oracle Forms and Reports.
• Experience developing and supporting Crystal Reports XI and Crystal Reports 8.
• Load the data from MS Excel to Oracle Table and Oracle table to MS Excel.
• Used partitioning and sub partitioning of tables to improve performance.
• Expertise preparing report specifications and database designs to support reporting requirements
• Worked with team on customizing the abilities of Crystal Enterprise such as exporting, previewing, printing and emailing reports.
• Created Crystal Reports sourced from the Oracle database and flat files.
• Good knowledge in Basic DBA activity- Creating and Managing Oracle Database server, Proactive Monitoring, Database security (User & Resources, User Privileges & Roles).
• Ability to learn new concepts, tools and environments.
• Took training in Bigdata and Hadoop.
• Good knowledge in Bigdata and Hadoop Architecture.
• Worked with cloudera.
• Worked with Large Datasets.
• Good knowledge in Bigdata and Hadoop tools like Pig, Hive, Hbase Scoop, Flume.
• Good experience in HDFS commands.
• Good knowledge in R-Programming.

TECHNICAL SKILLS:

Programming languages:: C,C++, Java, R Programming, Python, Linux shell script,XML, HTML5, CSS3, C#, .NET

Tools: Visual Studio, NetBeans, Toad, SQL*Loader,SQL*PLUS,Tableau

Reporting Tools: Crystal Reports, Oracle Reports 2.5

Database: SQL Server 2008/2005/2000, Oracle 11g/10g/9i/8i, MySQL, PL/SQL, MS Access

Hadoop/Big Data: Hadoop Architecture, Pig, Hive, Hbase, Sqoop, FlumeOperating Systems: Windows Server 2016, 2012, 2008, 2005,LINUX/UNIX,Ubuntu.

PROFESSIONAL EXPERIENCE:

Confidential

SQL/Oracle Database Developer

Responsibilities:

• Involved in Software Development Life Cycle (SDLC) including analysis, design, development, and testing of the project.
• Coordinate with Managers, Architects and Analysts to develop Oracle database systems.
• Coordinated with the front end design team to provide them with the necessary stored procedure and the necessary insight into the data.
• Worked on SQL*Loader, SQL*PLUS to load data from flat files obtained from various facilities every day.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Design and deploy data table structures, forms, reports, and queries.
• Created DDL, DML, DCL Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Improved the performance of the application by rewriting the SQL queries.
• Understand business requirements and accordingly develop database models.
• Created lots of Triggers for validation.
• Created lots of procedure, functions, views, cursors, collections.
• Extensively used cursors for fetching the rows.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Used partitioning and sub partitioning of tables to improve performance.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created Oracle Materialized Views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used Collection objects, ref cursor, aggregate functions while Writing SQL Queries.