SUMMARY:

• Over 15 years of experience in Information Technologies.
• Experienced in complete Software Development Life Cycle with seasoned specialty in A&A, gather client requirements, design and implementation and Project Management.
• Hands on Experience in Database design, Development and database transformations.
• Working experience in a fast - paced Agile/Kanban/Scrum environment.
• Functional knowledge in Financial, Security and Investigations, Insurance, B2B and B2C applications.
• Experience in developing web user interfaces and proficient in application development with web technologies and client-server architecture environments.
• Individual with excellent communication skills self-motivated and fast learner and has ability to handle projects independently.
• Experienced in Installing and configuring Database Servers, Web Servers and Application servers.
• Familiar with incident response and security compliance of federal systems.
• Worked on conducting security control assessments with NIST 800-53 security controls, also coordinated with development team in implementation of these controls.
• Worked on determining Information types within the information system and the impact of those information types on the Organization (FIPS 199/FIPS 200).
• Played a key role in implementing and conducting internal and external audits.
• Enthusiastic in learning new processes, technologies, and methods to improve productivity.
• Excellent team player with problem-solving with trouble-shooting capabilities.
• Motivated achiever, who exceeds goals, has been promoted regularly, earned best customer satisfaction rating.
• Articulate communicator who can fluently speak the languages of both people and technology.
• Blending technical expertise with exceptional interpersonal skills while interacting effectively with customers.
• In addition to IT, worked as Customer Support Engineer in the Analytical field for 3 years in India.
• Technologies: MySQL, Informatica, Oracle 12c/11g, Oracle PL/SQL, Mod PLSQL, Oracle WEBDB, Developer 2000, Oracle Reports, Oracle Applications, MS SQL SERVER 2008/2005, TSQL, Report Builder 3.0, VB, ASP, ASP.NET 4.x, C#, JavaScript, Perl, Python, Crystal Reports, HTML, DHTML, XML, MML, Oracle Portals, IBM Lotus Domino Designer, Informatica, Telerik controls and Site Minder.
• Server/Platform: IIS 7.0, WINDOWS 2012 R2, Linux. UNIX, Linux, SQL Server, Index Server, MS certificates Server 2000, VeriSign Card Management Server, VAX and VMS.
• Tools - MS Project, MS Office Applications, Oracle Enterprise Manager, SQL DEVELOPER, Precise, MS Visual Studio, MS Visual SourceSafe, Crystal Reports, Telerik, Tableau, XML Spy, EpiBuilder, Adobe Acrobat, FLEX GRID 10, Putty, Kitty, Winscp, Adlib, SA File Upload, Adobe Filter, SSIS/SSRS, VersionOne, TOAD for Oracle, GITHUB and SQL Loader.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr Database & Application Developer

Responsibilities:

• Lead role in database design, development and Administration works.
• Designed, developed and integrated ASP.NET webpages.
• Extensively used Telerik controls for user interface and layout.
• Wrote design documents for workflow in various modules.
• Worked on testing web application and data testing.
• Worked on integrating external interfaces to the web Application.
• Identity management: Implemented single sign on for web application using Site Minder.
• Wrote complex SQL queries to generate reports and meet requirements to develop webpages.
• Developed Packages, Stored Procedures and Functions to Create, Retrieve, Update and Delete Data.
• Worked on Performance tuning on existing database jobs.
• Worked on extracting external data and worked on data transformations.
• Cybersecurity:
• Worked on all the required documentation for eEMRT security authorization including SCD, SSP, ISCP, ISCP tests and results.
• Lead role in A&A(C&A) activities to achieve Authorization for hosting web application on Federal systems.
• Worked on all the required documentation for eEMRT security authorization including System Characterization Document(SCD), System Security Plans(SSP), ISCP, ISCP tests and results.
• Worked on review of conducting security control assessments with NIST 800-53 security controls and documenting results and addressing the POAMS listed after the assessment.
• Single POC for responding to information requests from FAA Security Offices.
• Worked on server security settings and configurations.
• Worked on code fixes to remediate vulnerabilities reported in various scans like WebInspect, Microfocus Fortify on Demand.
• Run Microfocus Fortify on demand Scans for Application scan.
• Participated in Assessment meetings/interviews to discuss and demo all security controls.

Confidential, Washington, DC

Sr Database Developer/Web Developer,

Responsibilities:

• Designed and created various reports.
• Involved in designing new Mobile application.
• Worked on code fixes to remediate vulnerabilities reported in Fortify on Demand.
• Worked on Performance tuning on existing database jobs.
• Developed Utility package containing generic functions which is used across the project.
• Developed logging of various activities in different applications and used for data analysis.
• Actively involved in Production support.
• Worked on developing API to reset password on Active directory.

Confidential, MD

Sr Programmer Analyst

Responsibilities:

• Reengineer part of the billing and reservation system based on changing requirements.
• Write PL/SQL stored procedures and PL/SQL packages.
• Replace existing cursors with in line SQL for better performance.
• Use Bulk collections and Bulk inserts to improve performance.
• Create and configure Materialized views.
• Modify existing procedures and packages to enhance the performance and efficiency.
• Perform stress test and regression tests. Work on Performance tuning on existing database jobs.
• Partition and index tables. Develop Utility package containing generic functions which is used across the project.
• Improve logging capabilities for a better tracking of the process. POC for Production support.

Confidential. Arlington VA

Sr Programmer Analyst

Responsibilities:

• Gather client requirements and writing design documents.
• Analyze and Design the given Requirement.
• Responsible for designing and developing secure code based on FAA standards.
• Design database and create development environment.
• Write PL/SQL stored procedures, Triggers and PL/SQL packages.
• Process data using business rules and store in reporting tables using Bulk inserts.
• Tweak existing queries for a better performance to produce quick output.

Confidential, Washington, DC

Sr Programmer Analyst/Lead Developer

Responsibilities:

• Gather client requirements and writing design documents.
• Write PL/SQL stored procedures, Triggers and PL/SQL packages.
• Involve in designing methodology for allocating costs to the different centers based on the activities.
• Process data using business rules and store in reporting tables using Bulk inserts.
• Used PL/SQL pipelined functions to improve performance.
• Extensively used Oracle Financial reports to get budget information. Customized Oracle Discoverer reports to meet customer’s needs.
• Create and Schedule daily Jobs to download data from Remote servers.
• Tweak existing queries for a better performance to produce quick output.