SUMMARY:

• About 16 years of experience as a programmer/analyst with proven abilities in identifying and analyzing end - user requirements, translating functional requirements into technical specifications, designing and developing custom applications to meet the business needs on both database and application layers.
• Experience as a Software Developer working on full life cycle projects performing requirements analysis, designing, developing, testing and providing user support with analytical and problem-solving skills for custom applications, developed using SQL, MySQL, PL/SQL, HTML, Java Script, AJAX, React, BI Publisher, XML, Oracle Forms and Oracle Express.
• Experience as an ETL developer performing data analysis, extraction, transformation and populating data for Data Warehouse project using SQL and PL/SQL and Veteran Affairs Health Care system using SQL Server and MySQL.
• As a technical Operations Support team member, provided technical support for business activities using UNIX, PL/SQL, SQL, INFORMATICA and APPIAN.
• Experience working in Agile environment, using Agile development methodologies for database administration and application development to deliver incremental source code, as a strong team player coordinating across the team.

TECHNICAL SKILLS:

Languages: C, C++, SQL, PL/SQL, JavaScript, JAVA, KORN Shell Scripting

OS: UNIX, MS DOS, MS Windows, Windows NT, Windows 7, Windows XP, Mac OS X 10.12

GUI: Oracle Forms, Reports, Crystal Reports, BI Publisher, HTML, AJAX, XML, Eclipse, React

Databases: Oracle 12c, 11i, 10g, 9i, Oracle 8.x, Oracle 7.3, SQL Server

EBusiness suite: Oracle Financials 10.7, 11.5.10 & 11i

T ools: TOAD, SQL Plus, SQL Developer, PL/SQL Developer, Visual Studio Code, Azura Data Studio

Source Code Tools:: TFS, SVN, SourceTree, Bitbucket, SourceTree, PVCS Tracker, JIRA, GitHub, Rational

WORK EXPERIENCE:

Confidential, Chantilly, VA

SQL Developer / Web Developer

Responsibilities:

• As a technical developer, responsible for analysis of the business requirements, designing and developing technical solutions in collaboration with the product owner and technical architect. Main duties involved reviewing user stories, tasking in Rational, analyzing wireframes to validate business requirements, reviewing technical solution, designing and developing database objects and user interface, unit testing, system design documentation and coordinating with system testers on defect remediation.
• As a web developer, worked with the team to develop new functionality for web applications to allow VA users to view, create, activate and/or delete the Standard Episodes of Health Care, along with various other features to help maintain their health care system through a secure portal.
• As a SQL Developer, I was primarily responsible for database management and administration for SECO Database, which interacts with the SEOC application, that was developed for Veteran Affairs Health Care system.
• Aggressively worked with the team to review data for extracting, formatting, and loading into the destination tables from a flat file received from the government, using SQL Server, EXCEL and MySQL
• Involved in maintenance of SEOC Database, by updating scripts to refresh existing data consistently, in various environments, such as PROD, Pre-PROD, SQA and Development.

Environment: SQL Server, MySQL, Docker, Crucible, EXCEL, React, SourceTree, Bitbucket, JIRA, GitHub, Rational.

Confidential, RESTON, VA

PL/SQL Consultant

Responsibilities:

• As an ETL developer, involved in analysis, designing and creating DB objects such as staging tables, sequences, indexes, audit columns and triggers, that were identified as a requirement to support the ETL process of retrieving source table data comprising of over 100 tables, transforming the data in the staging process, and eventually loading into the Data Warehouse through staging tables.
• Working with business team to analyze mapping constraints, preparing technical design document to demonstrate Proof of Concept for the audit trail process and ETL framework.
• Working on ETL implementation using PL/SQL procedures and packages, that will be scheduled to run on a nightly basis to identify the delta of the updates to the system, that needs to be processed and loaded into the target Data Warehouse.

Environment: Oracle, SQL, PL/SQL, SQL Developer, GitHub.

Confidential, RESTON, VA

Senior Technical Support Engineer

Responsibilities:

• As a production support team member of SAT batch processing, was performing critical activities of executing project plans, monitoring ETL workflows to load data during marshaling process, validating staging data using SQL scripts.
• Worked with Quality Control team to identify and address further issues detected during the data replication process. Reconciliation report was created to be executed at the end of every data load process to provide counts and fallout statistics.
• Incident management system was heavily used for documenting defects and data requests encountered during the data load cycle. Extensively used SQL and PL/SQL for analyzing and resolving data discrepancies reported by the users. Writing Standard Operating Procedure (SOP) and creating templates to ensure consistent execution plan, trouble-shooting production issues and writing up root cause, analysis of complex issues, were other duties .

Environment: Oracle 12c, SQL, PL/SQL, UNIX, AWS, APPIAN, INFORMATICA.

Confidential, MANASSAS, VA

Software Engineer

Responsibilities:

• Developed ETL program, using SQL scripts, PL/SQL programs and shell scripts, for replication of data from UNISYS environment to UNIX environment. Process involved, analyzing source data to be extracted, designing and defining target tables, transforming the data to comply with the target environment standards and load the data with reasonable processing time. Used External tables for performance tuning, to meet the execution timeline. Used SQL scripts to validate the data load and PLSQL program to generate a flat file to compare against the source file for identifying data discrepancies.
• For deployment, tasks involved identifying data mapping, developing PL/SQL and C++ programs, coordinating with the team members to identify library dependencies and executing through shell scripts.
• Created multiple KORN Shell wrappers, to invoke SQL scripts and PL/SQL programs, to format and customize the execution of ETL, as the part of the provisioning implementation process.
• Worked on EARSDB project to provide SQL scripts to generate User Session History reports. Developed ASSIST FEED program using SQL and Shell scripts to generate XML files to feed internal SCP data into external database on remote host.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, Shell scripting, C++.

Confidential, HERNDON, VA

Project Coordinator

Responsibilities:

• Worked on the RTB project comprising several applications to maintain the application data and support the DES Compliance system by analyzing the interface completeness check within the applications to verify and validate the data and updating the data in the system.
• Documenting and coordinating with the team members to identify data discrepancies and resolving the issues to reconcile the data in the reports.

Environment: Oracle 11g, SQL, EXCEL, SharePoint.

Confidential, CHANTILLY, VA

Software Engineer

Responsibilities:

• Worked on Force Management System database @ Confidential, in an agile, fast paced environment, analyzing the data using hierarchical queries to detect ghost records in a complex data structure and suggest steps to resolve the issues with data discrepancies. Implemented code changes for the data fix to resolve production support problems and developed new stored procedures to enhance the applications to eliminate the root cause of the existing problems.
• Worked intensely to handle change requests, managing the tickets created by end-users in TFS (Team Foundation Server), to provide a smooth functionality of the daily tasks with ad-hoc reports and data fixes to ensure the data integrity.
• Worked in full cycle software development projects, analyzing requirements, designing and developing packages to perform ETL process, which required Data Extraction from unclassified database, manipulating the data to meet the new business rules on the target site and loading into the classified database, testing, implementing and supporting the applications.
• Implementation process involved developing PL/SQL programs, integrating and testing the execution through C# program. Tasks involved were to identify and correct the data types, to match that of the calling program, and testing the deployment in a .NET framework.

Environment: Oracle 11g, SQL, PL/SQL, EXCEL, PL/SQL Developer, ASP .NET, C#, Team Foundation Server (TFS).

Confidential, LEESBURG, VA

Software Developer

Responsibilities:

• Gathered business requirements from clients to enhance existing Help files on the NAIMES - AISR application for the Confidential Flight Plan Equipment suffixes. Analyzed the requirements, designed and developed DDL and DML scripts to code the changes and updated the HTML page to reflect the enhancements in the application as per the requirement specifications.
• Implemented multiple projects to meet the ongoing requirements of “Incident Management System” at Cyber Security Management Center ( Confidential ) and to automate key processes by analyzing user requests and proposing enhancements, designing and developing custom applications, writing and executing test scripts for testing the programs, and deploying the changes through multiple environments of development, test and production.
• Developed Dashboard Reports for Internal and External users, providing graphical representation of the Statistical reports and reporting capabilities within the applications to export the report data into an Excel Report or a RTF Report. The functionality was built in PL/SQL extensively using advanced features of PL/SQL like Object types and Dynamic SQL.
• Enhanced the functionality of the Scheduling programs in MADE/ SAM’s applications to troubleshoot the error messages encountered by the users by programming Exception Handling enhancements to the code.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, JavaScript, UNIX. AJAX, XML, HTML, TOAD, SQL Developer, Java.

Confidential, RESTON, VA

Database Developer

Responsibilities:

• Major tasks performed were designing and developing custom applications for the Landing gear system for Department of Defense, to enter daily updates through a custom interface and to execute the validation process for the data mapped from DLA into the internal system. The data was mapped in the form of XML and EDI files.
• Responsible for loading raw data received from HAAS customer into the internal shipment tables using SQL scripts, validating and updating the data using advanced PL/SQL techniques such as bulk binding and Collections.
• Performed various other tasks such as data mining, data validation and data cleanup for all the processes to ensure that data was validated and mapped into the system securely. And, verified that the output of the crystal reports that was sent to the customers is consistent and accurate.

Environment: Oracle 9i, PL.SQL, SQL, SQL Navigator, MS EXCEL, Crystal Reports.

Confidential, VIENNA, VA

Oracle Applications Developer

Responsibilities:

• As a development team member, involved in gathering requirements, designing technical/functional flow and developing custom interfaces/reports to provide user friendly applications tailored to improve the performance of the end-user’s daily business activities such as placing orders, tracking sales, creating and updating estimated costs, generating invoices across various modules such as project accounting, payables, purchasing and receivables within E-business suite.
• As a production support team member, analyzed the underlying table structures and recommended enhancements to fix the invoicing and receiving process issues encountered by the system users. Also, administered Oracle applications by creating and maintaining user accounts in Oracle, re-initializing services for applications as needed, assigning responsibilities in Oracle, setting up sub inventories and PO Approval groups for PO users and defining profile options at the user level and site level. Also, creating form definitions, functions, menus and defining concurrent request and request groups for custom interfaces registered in E-business suite applications. Created and modified database objects such as tables, views, indexes, sequences and synonyms required for developing custom interfaces and for performance tuning. Created PL/SQL packages to define custom Alerts for processes within Oracle Receivables and custom applications to provide email notification for the users.
• Extensively involved in creating and maintaining database objects using TOAD, customizing forms and reports, defining and registering concurrent programs to enable the users to run the PA job cost and billing reports in various formats such as PDF, EXCEL and XML.

Environment: Oracle, PL.SQL, SQL, SQL Navigator, TOAD, Forms, Reports, E-Business Suite versions 10.7, 11.5, 11i

Confidential, HERNDON, VA

Oracle Financials Consultant

Responsibilities:

• Analyzed existing bugs to determine the requirement specifications, translated the functional requirements into technical specifications. Modified the database objects such as tables, indexes, constraints, sequences and synonyms as per the new requirements. Customized interfaces to provide added functionality and to tune the existing code for performance.
• Wrote documents such as Technical Design document, Functional Design document, Unit Test plans and Promotion package document to provide details of the process workflow of the custom programs implemented.

Environment: Oracle E-Business Suite, PL.SQL, SQL, SQL Navigator, TOAD, Developer 2000