EXPERIENCE SUMMARY:

• Over seven years of experience as a Database Developer in Analysis, Design, Implementation and Testing of Business applications using Relational Database Management System (RDBMS).
• Extensively worked on Client - Server architecture, Data Warehouse applications using Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008.
• Proficient working experience with SQL, PL/SQL, T-SQL using database objects like Stored Procedures, Functions, Triggers, Packages, Type Objects, RefCursors, Dynamic SQL, Oracle Supplied packages, PL/SQL Collections, Temporary tables and Exception Handling.
• Extensive experience in DB utility tools like SQL Plus, Toad, PL/SQL Developer, SQL Developer, SQL* Loader.
• Extensive experience in identifying issues, debugging and performing tuning the application using Explain Plan, SQL Trace, TK Prof, and AWR Reports to optimize the cost and for achieving higher performance.
• Strong experience in Partitioning tables, creating Indexes, using database Hints for faster data retrieval.
• Experience with Designing Data Flow Diagrams (DFD’s), Database Normalization and Denormalization techniques, Entity relation modeling and design techniques.
• Working Experience in Creating Physical and Logical data models using various tools like Erwin, ER-Studio and MS Visio tools.
• Working knowledge of Data warehouse and ETL tools like Informatica, Cognos.
• Extracting data from source database, Cleaning, mapping and loading data into the target database, validating and analyzing the data loaded for reporting purpose using Informatic.
• Working experience of Amazon redshift, Snowflake Databases.
• Good Knowledge of Data Visualization using Tableau and Python 2 programming.
• Experience in monitoring and automating tasks using UNIX Shell scripting and hands on experience in Perl Scripting.
• Experience with Agile based development environment and participated in Scrum sessions.
• Performing system auditing analyzing logs to provide support for the users.
• Documenting system related changes in procedures/policies along with the new issues and the solutions along with technical specifications.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11i, MSSqlServer 2005/2008/2012, MySQL 4/5, MS-Access, Amazon Redshift, Snowflake Data warehouse, Teradata, Hive, NoSQL

DB Utilities: SQL*PLUS, Toad 9.x, SQL Developer, PL/SQL Developer

Languages: SQL, PL/SQL, T-SQL, Shell Scripting, Perl, Python 2

Operating Systems: Windows, UNIX, Linux, Sun Solaris

Others: Oracle Forms and Reports 6i, Oracle 10g Dev Suite, Informatica, Tableau, Crystal Reports, Cognos, SSRS, SSIS, AVAYA, ER-Studio, Erwin, Microsoft Visio, UML, Rational Rose, Subversion SVN, Tortoise, Git, Serena Dimensions, Rally, Jira, Oracle Apps, Salesforce, JDBC, D / X HTML, XML, XSL, CSS, AJAX, JQuery, JavaScript, WordPress 2.9, XAMPP, WAMP, Zend, Kohana, PHP 4/5, VBA, Visual Studio.NET (2005/2008/2012), C, Core Java, C#, ASP, Excel, MS Power point, Eclipse, pycharm

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

Sr. Data Analyst / Database Developer

Responsibilities:

• As a part of the ETL team, involved in Extracting data from different databases (Oracle, Teradata and Salesforce) and loading it in to SQL Server database.
• Validating the data loaded in to SQL Server database and comparing it with the source DB for reporting purposes.
• Partitioning tables, data compression and created Indexes for faster retrieval of data.
• Tuning the queries for the faster retrieval of the data from the source database.
• Involved in Creating, Scheduling and monitoring the data load jobs and troubleshooting any issues occurring during the loading data.
• Analyzing data and writing queries to extract data and creating appropriate reports.
• Data Visualization using Tableau.

ENVIRONMENT: Oracle 11g, SQL Server 2008/2012, SQL, T-SQL, Visual Studio 2008, Teradata, Salesforce, Rally, Hive, Excel, Tableau.

Confidential, Jersey City, NJ

Sr. Database Developer

Responsibilities:

• Responsible for requirements analysis, database design, development and unit testing of the application.
• Modifying the existing DB design using Erwin tool according to the new requirements.
• Involved in Creation of DB objects like Tables, partitioning tables, Indexes, sequences, views.
• Involved in writing SQL queries and PL/SQL programming and tuned existing procedure and queries using Explain plan and SQL Trace.
• Worked on SQL Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Developed database triggers, packages, functions, and stored procedures according to the requirement and modifying the existing DB objects.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Extensively used the advanced features of PL/SQL like collections, ref cursors, and dynamic SQL, nested table, varrays, ref cursors, materialized views, Hints and dynamic SQL.
• Used AWR reports to collect the DB statistics and tuning the long running queries.
• Worked on database development, maintenance and production support, wrote Functional and Technical Specifications documents.

ENVIRONMENT: Oracle 11g, SQL Server 2008, PL/SQL, SQL, T-SQL, Informatica, TOAD, SQL Developer, PL/SQL Developer, Visual Studio, SQL*PLUS, Solaris 5.10, UNIX, Windows 8, Erwin, Putty, Java, Eclipse.

Confidential, New York, NY

Sr. Database Developer

Responsibilities:

• Involved in writing SQL queries (Sub queries, Correlated sub queries and Join conditions) and PL/SQL programming.
• Modified the existing database packages, triggers, functions and stored procedures using PL/SQL and maintained scripts for various data feeds.
• Extensively used the features of PL/SQL like collections, ref cursors, and dynamic SQL and varrays.
• Created Indexes for faster retrieval of the data and enhance the database performance.
• Used Analyze and Explain plan for tuning and Optimization of SQL Queries.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data fields.
• Providing reports on loading data into database and according to the client requirement.

ENVIRONMENT: Windows 7, Sun Solaris, Unix, Oracle 10g / 11g, Toad, SQL Developer, PL/SQL, SQL*Loader, UNIX, Putty, Excel.

Confidential, New York, NY

Responsibilities:

• Responsible for Requirements analysis, Design, Development and unit testing of the application.
• Performing hands-on analysis, manipulation and loading of customer-provided data and providing reporting on loading.
• Worked on designing the database from scratch and application development in all phases of waterfall model.
• Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and created Process flow diagrams using MS Visio tool.
• Involved in writing SQL queries (Sub queries, Correlated sub queries and Join conditions) and PL/SQL programming.
• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Developed database packages, triggers, functions and stored procedures using PL/SQL and maintained scripts for various data feeds.
• Used the advanced features of PL/SQL like collections, ref cursors, varrays, PL/SQL tables, type variables, dynamic SQL, Temporary tables and External tables.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROF utility to get the report for the trace file for tuning and Optimization of SQL Queries.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data fields.
• Used Data Pump utility (EXPDP/IMPDP) for taking schema level backup of the database.
• Worked on Informatica Source Analyzer, Mapping Designer & Mapplet, and Transformations.
• Created mappings using different look-ups like connected, unconnected and dynamic look-up with different caches such as persistent cache.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Developed ETL framework for processing and monitoring import of flat files in SSIS for key client.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Worked on creating UNIX scripts for automating jobs for loading data from data files received from downstream application to upstream application.

ENVIRONMENT: Windows 7, Oracle 10g / 11g, SQL Server 2005, Visual Studio, Toad, SQL Developer, T-SQL, SQL, PL/SQL, SQL*Loader, SSIS, SSRS, UNIX, Putty, Serena Dimensions, Appian, Informatica, Cognos, SQL Loader, Excel, MS Visio, ER-Studio, MS-Visio.

Confidential, Jersey City, NJ

Database Developer

Responsibilities:

• Participated in all phases of development like System Analysis, Design, Coding, Development and Implementation using Agile-Scrum as an iterative framework for development.
• Involved in writing SQL queries (Sub queries, Correlated sub queries and Join conditions) and worked on advanced features of PL/SQL like cursors, ref cursors, collections, varray and dynamic SQL.
• Worked on writing stored procedures according to the requirement and modifying the existing scripts.
• Utilized SQL*Loader to perform bulk data loads into database tables from flat files.
• Worked on User-defined and System defined exceptions to handle different types of Errors.
• Created different reports using Excel according to the requirement.
• Worked on Perl and Shell scripting according to the requirement.
• Designed and developed screen interface using Oracle Forms, Reports.
• Developed Front end with Forms 6i and wrote DDL statements, PL/SQL Library and triggers in oracle forms. Developed LOV’s and Triggers for different data blocks.
• Developed complex Oracle forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications.
• Managed and resolved design issues during development stage. Worked closely with other developers.
• Used the methods provided in the JDBC API to create, read, update and delete the data from the database.

ENVIRONMENT: Windows 7, Oracle 11i, Putty, SQL Developer, PL/SQL, Excel, Perl 5.x, UNIX, Forms 6i, Reports 6i, Windows XP, JDBC 4.0, Java1.6

Confidential, North Chelmsford, MA

Web / Database Developer

Responsibilities:

• Extensively involved in writing SQL queries (Sub queries, Correlated sub queries and Join conditions).
• Involved in Creation of tables, views, Indexes, sequences, synonyms, database triggers, packages, functions, and stored procedures using PL/SQL.
• Used Analyze and Explain plan for tuning and Optimization of SQL Queries.
• Utilized SQL*Loader to perform bulk data loads into database tables from flat files.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Worked on User-defined and System defined exceptions to handle different types of Errors.
• Developed web pages using HTML, PHP, JavaScript, CSS and AJAX.
• Used Cascading Style Sheets (CSS) to make the layout of the application uniform.
• Worked on Content Management System and Involved in manual testing and cross browser compatibility.

ENVIRONMENT: Sun Solaris 5.10, Windows Server 2003, UNIX, Putty, Oracle 10g, PL/SQL, Toad 9.6, PHP 5.3, HTML, CSS, JavaScript, AJAX, JQuery, Zend Framework, Zend Server, Apache 2.2, Git, Test Mate.