SUMMARY

• 16+ years of extensive experience in different phases of Software Development Life Cycle, including Analysis, Design, Development, Test, Support and Maintenance
• Extensively worked in the capacity of a Database Developer, Technical consultant / SME / Sr Developer / Sr Analyst / Technical Lead, team Lead with excellent business domain experience.
• Experienced in designing innovative business solutions, development and maintenance of Business applications using AWS, Oracle 19c/ 12c/ 11g / 10g /9i, PL/SQL, SQL Server 2008/2012/2016 , Unix, Python.
• Experience working with ETL tools like SSIS, home grown custom tools.
• Has experience working in reporting tools like Tableau, Crystal reports, SSRS.
• Skilled in cloud computing, information management, application development, and virtualization.
• Expertise in all phases of Software Development Life Cycle (SDLC) and software engineering methodologies such as Requirement Gathering, Development, Normalization, Data analysis, Performance tuning, Integration, Bug - fixing, Coding, Unit Testing, Production support and Maintenance and Database Upgrade of application, deploying the database changes from one environment to other.
• Very hands on in translating business requirements into creation of database objects: Tables, Indexes, Constraints, Packages, Stored procedures, Functions, Collections, Records, CLOB, Bulk Collect, Dynamic SQL and Triggers, Oracle Types, Oracle Cursor Management, Exception Handling, Oracle Packages, External Table, Oracle DBlinks, Change Data Capture and Materialized views using SQL and Oracle PL/SQL.
• Experienced in Oracle SQL/PLSQL Performance Tuning using Toad SQL Optimizer, Explain plan analysis, Oracle Enterprise Manager and various techniques.
• Experienced in UNIX Shell Scripting, Object Oriented Programming and Core Java, Service Oriented architecture etc.
• Experienced in Agile Development, Sprints, Paced environments, Continuous Integration and deployment.
• Training and mentoring diverse teams towards maximizing team synergies.
• Communicating effectively and timely with internal teams thru Senior management, Product sponsors and external users such as servicers (small thru Large)
• Having great experience in Product development for AMS software net FORUM Enterprise, Mobile Device Management Software EMMC and integration experience with Mobile Iron and Citrix XenMobile, government contracting experience etc.
• Heavy experience working with Data Processing in Databases. Very good experience working in Oracle PL/SQL and SQL Server T-SQL.
• Along with Very Good Experience, Education, have certifications. Very Good Team Player, has great working Attitude with Aptitude.

TECHNICAL SKILLS

Databases: Oracle 19c / 12c/11g/ 10g / 9i, SQL Server 2016/2014/2008 R2/2008, MS Access 2003/2007.AWS RDS.

Management tools: MS Project, Excel, Visio, Rational tools, Clarity, Serena, SharePoint, Tableau, Agile, RUP, Waterfall, Agile/Scrum, SAFe.

Tools: & languages: TOAD, SQL Developer, SSIS, Talend, SQL, T-SQL, PL/SQL. C/C++

Modeling Tools: MS Visio . ER Diagram, Rational Suite.

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Oracle PL/SQL / Database Developer

Responsibilities:

• Design, Architect and develop database for application using Oracle Database as backend
• Working Hybrid environments using with Cloud environment, Virtual environments.
• Responsible for Oracle SQL and PL SQL Performance Tuning.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in creating UNIX Shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SDLC.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation, and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Performed modifications on existing form as per change request and maintained it.
• Migrated oracle 12c to oracle 18c
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell Scripts to automate repetitive database processes.
• Migrate the database code from development to Test and Production environments.

Environment: Oracle Database 10g/9i, PL/SQL Developer, SQL Server, T-SQL, Sharepoint 2007/2010 Databases, TOAD, Crystal Reports, SSRS, SSIS, Informatica, GitHub, TFS, PVCS

Confidential, Bethesda, MD

Oracle / PL/SQL Developer

Responsibilities:

• Serve as technical lead for database team, design and development of new enterprise web based applications as well as new versions of existing ones written in Oracle PL/SQL.
• Provide technical and functional direction to our customers in matters of implementing technology within their business processes
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
• Create PL/SQL packages, standalone procedures, and functions.
• Write complex SQL queries with sub-queries, analytical functions, and inline views
• Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.
• Use Collections like variable arrays, nested tables
• Design and create Confidential relationship diagrams (ERD) for Oracle based applications and interfaces.
• Provide on call and daily production support and Oracle PL/SQL ETL processes.
• Manage User Acceptance Testing of new applications and new versions of existing applications.
• Manage the packaging and release of applications to the training, UAT and production environments.

Environment: Oracle Database 10g/9i, PL/SQL Developer, TOAD, SQL Server, T-SQL, Sharepoint 2007/2010 Databases, Crystal Reports, SSRS, SSIS, Informatica, GitHub, TFS, PVCS

Confidential, McLean, VA

Sr. Developer

Responsibilities:

• Gathering the requirement from internal clients and stack holders for development and analyze the requirement and existing Data and functionality.
• Actively involved in Design and Implementation of netFORUM modules like accounting, Fundraising, Improving functionality of netFORUM Enterprise.
• Working on Agile methodology development. Working with Façade Pattern architecture, Factory Pattern, Singleton Pattern, Confidential framework Model.
• Design and develop advanced features for the base line of the company's software products. This includes research and implementation of new technologies into the product and enhancing existing functionality.
• Involved with Professional services for netFORUM customizations.
• Create PL/SQL packages, standalone procedures, and functions.
• Write complex SQL queries with sub-queries, analytical functions, and inline views
• Database Design and development include writing stored procedures, Functions, Create Database Table Keys using Transact SQL (T-SQL).

Environment: Oracle Database 10g/9i, PL/SQL Developer, TOAD, SQL Server, T-SQL, Forms Builder 6i, Reports Builder 6i Workflow Builder 2.6.3.5, TFS, PVCS

Confidential, NJ

Responsibilities:

• Responsible for interacting with Business Users and other development teams for gathering requirements.
• Developed Functional and Technical Specifications.
• Involved in creating SQL loader scripts to load the data from the flat file received from 3rd party vendors into oracle tables.
• Worked as production support specialist and resolved production related issues.
• Developed Functions & Procedures to manipulate the data and to load to the tables.
• Used Oracle Advanced concepts like types, PL/SQL tables and V-Arrays and dynamic SQL in generating the complex extracts from database.
• Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
• Involved in the creation of database objects like tables, views, stored procedures, functions, Indexes for new requirements.
• Involved in creating users and requests, schedules in Oracle Apps for all interfaces.
• Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.
• Developed ETL mappings, transformations using Informatica Power Center
• Involved in Coding, Data conversion and Implementation.
• Designed front end screens in Pro*C
• Extensively involved in writing SQL queries (Sub queries and Join conditions).
• Developed customer and order packages to process all customers and orders.
• Created database objects like views, stored procedures, and functions.
• Prepared Unit test plans and developed Technical Specifications.

Environment: Pro*C, Oracle 9i/8i, UNIX Shell Scripting, Solaris, TOAD.

Confidential

Developer

Responsibilities:

• Verify all functionalities of the application related to user management, tamper representation, meter readings, stored load survey and energy displays, modem configurations and various report support.
• Gather the requirements from internal client and all stock holders and design the system.
• Requirement Analysis and technical documentation using OO Methodology (UML, MS Visio)
• Analyzing the different types of Tampers possible in the Electrical Utility. Designed and Developed User Interfaces (Win forms) using C#. Developed server-side logic using C# and ADO.NET.
• Developed various stored procedures, constraints, indexes and views using Oracle Server to maintain business logic and enforce data integrity using PL/SQL. Designed database connectivity modules using ODBC with Oracle server as the database. Designed and developed reports using Crystal Reports. Testing and maintenance of the application.
• Electrical Utility migration & its Enhancement

Environment: Pro*C, Oracle 9i/8i, UNIX Shell Scripting, Solaris, TOAD.