SUMMARY

• Oracle Certified Associate (OCA) with more than 12 years of design & development experience in client/server, multi - tier complex Business systems and applications
• Managed various phases of Software Development Life Cycle (SDLC) with complete ownership of BRDs, LLD, HLD along with design, Coding, Testing, Quality assurance and prod roll out of global projects
• Expert level experience in creating Procedures, Packages, Functions, Triggers and databases complicated technical objects using SQL, PL/SQL as well as enforcing data integrity via integrity constraints & database triggers
• Developed complex Performance Tuning and Procedures criteria’s to maximize schemas efficiency across large complex and Oracle/PLSQL databases
• Led multiple minor/major Release and engagement of Dev, QA, APS and Technology teams across global technology footprint
• Demonstrated Global team (Onshore/Offshore) and process management expertise with end to end experience in execution & management of projects in various capacities (ETL & Project lead, Engagement & Release Manager)

TECHNICAL SKILLS

Operating Systems: RHEL Linux, UNIX, SOLARIS, AIX and Windows 95/98/ME/NT/2000/XP

RDBMS: Oracle8i/ 9i/ 10g/11g, Sql Server 2000, Access

Languages: SQL, PL/SQL, C, UNIX Shell, VB, VB.net

Tools: SQL*Loader, TOAD, PL/SQL Developer, SQL Navigator, Forms and Reports, Tableau

Tuning Tools: EXPLAIN PLAN, SQL HINT, Index

Database Modeling: TOAD, ER-Diagram, Erwin and MS Visio

BI, ETL and DW: Informatica, Power Center, Business Object

Version Control: Clear Case, SVN, GIT

Network Protocols: ODBC, TCP/IP, HTTP, FTP, SMTP

Web Tools: HTML, XML, ASP, Vb script

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Team Lead Application Programmer/SME

Responsibilities:

• Responsible for creating End to End Policies with synthetic data in the authenticated application.
• Responsible create more use cases as per the provided requirement.
• Responsible for bug fix and do enhancement using existing solution.
• Analyze and gather new requirement from the ITAO (IT Application Owner)

Confidential

SME (SUBJECT MATTER EXPERT) OF DATAMASKING

Responsibilities:

• Responsible to coordinate with the team of 10 members and generate weekly progress report.
• Responsible to have END to END knowledge of the solution and coordinate the team accordingly to their responsible functions.
• Responsible to coordinate with ITAO to resolve their queries and satisfied them to use our solution.
• Responsible to initiate the Analysis process using DQ (Data Questionnaire) to discuss the sensitive data and time window for masking process, with ITAO of that corresponding application.
• Perform data discovery process to get the sign off from application ITAO regarding sensitive columns to be masked of a particular application.
• Perform End to End data masking for that database using pl/sql scripts and ensured Application Owner signoff the remediation process with certifying the data masking ha completed successfully.
• Provided ad hoc support for management updates, governance, documentation presentations.
• Responsible for End to End migration of in house masking solution to Test Data Management Informatica

Confidential

Team Lead Application Programmer

Responsibilities:

• Loading the user account information and authenticating their databases into database
• Apply the business rules to manage the information properly
• Generating the weekly report for non-complaint and compliant account so that remediation team can take action accordingly.

Confidential

Lead Database Programmer/Data Modeler

Responsibilities:

• Lead the Design of relevant data access governance controls to reduce risks, meet information security standards and MAS IT14/US FRB regulatory requirements.
• Lead Data Access Governance (DAG) reporting application’s development and Reporting Model: Oversee the development and rollout of the DAG application to generate reports to the senior leadership and business owners.
• Lead an effective global team of developers in assessment and correction of security controls (team locations are Jersey City and Chennai, India).
• Perform internal team reviews, work assignments, verification and quality control.
• Provide technical direction and guidance to less experienced team members to include oversight of tasks and deliverables on a periodic basis.
• Documentation of proper governance and compliance policies, procedures and mitigation controls.
• Present analysis results and recommendations to senior leadership and business owners globally.
• Promote and foster general awareness of best security practice; ensuring that application owners continue to maintain the business standards post remediation effort including their continuous participation in the account recertification
• Business and security analysis of data, system access, entitlements, and controls. Identify sensitive data and subsequent access to it, ensuring that entitlements are provisioned in compliance to the segregation of duties.
• Develops, enhances, debugs, supports, maintains and tests software applications that support business units or supporting functions
• Has expanded contact with responsibility to varied and multiple departments and functional operations, and actively participates in strategic business relationships.

Environment: Oracle 11g, TOAD, SQL*PLUS, SQL Developer, SQL LOADER, Win SCP, Putty, Control M (Job Scheduler), MS VISIO, Tableau.

Confidential, Warren NJ

Senior Application Developer/Application DBA

Responsibilities:

• Responsible for Application Production Support 24 X 7 on-calls
• Create necessary deployment instructions (Release process) for System Administrator to deploy from DEV to QA/Test and then Production.
• Troubleshoot code defects (JIRA) in the development, test and production environments and implement appropriate solutions.
• Responsible to handle production support issues through an established Virtual ticketing process.
• Developed functional and technical design and documentation of Oracle Applications dependent data conversions, interfaces, custom reporting, and custom applications.
• Work with BO team to develop reporting solutions on top of these frameworks to provide adequate analytics and data reconciliation between many complex data sources.
• Analyze and document root cause of defects or production support issues and implement appropriate solutions using own judgment.
• Worked with SCM Team in release process after tagging the updated units in clear case and verified the release before handed off the system to USER.
• Worked with project team to understand business process and workflow and translating them into system requirements.
• Develop, design and troubleshoot various new and existing functionality in modules (LS, LD, LT) of Flex cube to book the loans.
• Create and maintain queries using PL/SQL, and Linux scripting as required.
• Participated in all phases of software development/implementation life cycle including functional analysis, development of technical requirements, coding, testing, deployment and support.
• Experienced in using tools like TOAD, SQL*PLUS, Putty, Exam diff, PL/SQL Developer, Confidential Client, Auto sys, Clear Case, LMS (Login Management System) for design and development.
• Ability to use all available tools including Oracle Forms and Reports
• Estimate the level of effort required to deliver assigned tasks

Environment: Oracle 11g, TOAD, SQL*PLUS, PL/SQL Developer, Exam diff, Confidential -client, Putty, Auto sys Job scheduler, Resolve IT, Clear Case, SVN,LMS

Confidential, Englewood NJ

Senior Database Developer

Responsibilities:

• Involved in data migration from SQL Server to MySql.
• Created different assets such as image, video, chart, special report, and involved in end to end story migration.
• Associate all assets to the story and publish those stories.
• Fixes all bugs to give the quality of data (Update weekly Rally).
• Responsible for all weekly sync-up to migrate the data.
• Worked on Image cropping and Video Ingestion process these came from third party (syndicator).
• Tune the SQL and Procedures, to improve the performance.
• Extract the XML through Java into Database (SQL Parsing).
• Involved in Tokenization to put manipulated data in form of xml.
• Worked on CMS (Tool belt).
• Worked closely with Product team, and take the requirement from them and fulfill those requirements.
• Wrote Procedures and Functions for the validation of input data and to implement business rules.
• Developed and designed the test plans/Scripts, documentation and implement them.
• Created Tables, Indexes, Sequences, Synonyms and Constraints.
• Responsible for writing the Technical Documents and maintain the documentation.
• Enforcing data integrity using integrity constraints and database triggersEnvironment: MYSQL, TOAD, Sql Server, java script (Eclipse)

Confidential, Trenton NJ

Senior Oracle Developer

Responsibilities:

• Wrote Procedures and Functions for the validation of input data and to implement business rules.
• Creating triggers, PL/SQL packages, stored procedures, functions and cursors, Collections.
• Developed and designed the test plans/Scripts, documentation and implement them.
• Created Tables, Indexes, Sequences, Synonyms and Constraints.
• Worked on the different DBMS PACKAGES Such as DBMS OUTPUT, UTL FILE, DBMS SQL, DBMS SCHEDULER and many more.
• Worked on Oracle Forms and Oracle Reports.
• Load the data from text files into the database by using SQL Loader and External table.
• Designed the Reports and edited the preexisted Reports and forms according to the requirement.
• Worked on SVN and keep documented all procedures, functions, packages in SVN.
• Tuned SQL Queries using EXPLAIN PLAN, SQL HINT and INDEXES.
• Used Native Dynamic SQL for interface programs and exception handling routines.
• Worked on the Autonomous Transactions, Analytical functions.
• Design the numerous SQL queries to retrieve the data in the effective way by using the TOAD.
• Written the Stored procedure to load the data files into the database which are comes from Captiva (software) in the form of .csv, after checking all the business rules.
• Troubleshoot the programming problem.
• Worked with in both the functional and technical environment with SQL.
• Design the ER Diagram and understand the documented E-R diagram.

Environment: Oracle 10g/11g, PL/SQL, TOAD, SQL*Loader, Access, Oracle Reports 6i.

Confidential

Oracle Developer

Responsibilities:

• Designed the web pages of interglobetechnologies.com and Zenithtours.com by using HTML, ASP, Java script, VB script, JSP.
• Developed the database for those websites by using the oracle.
• Web Applications to facilitate Advisors for accessing and modifying the data of the investors, accounts, assets and transactions from GUI.
• Performed systems analysis of accounting and auditing applications
• Involved in defining system requirements, designing & prototyping, developing, testing, training and Implementation of the applications
• Involved in the design and implementation of the process for loading the monthly loads coming from S & P (in the form of flat files, csv) into staging tables in the Oracle Database using Shell scripts and PL/SQL scripts
• Involved in the design of the GUI and Database objects
• Designed user interfaces in Forms 6i and generate the Oracle Reports.
• Involved in developing the software for Employee Payroll System by using the VB6.0 and Oracle.
• Developed complex queries.
• Wrote Packages, Stored procedures and functions for accessing, inserting, modifying and deleting data in the database.
• Troubleshoot the problems related to programming and applications.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Optimized existing queries for better performance and less impact on database
• Normalized the schema for Optimum disk space utilization

Environment: Oracle 9i/10g, PL/SQL, TOAD, SQL*Loader, SQL Server 2000, VisualStudio.NET, JavaScript, XML, HTML, ASP, Java Script, VB Script, Access.

Confidential

Software Engineer

Responsibilities:

• Developed and worked on a project “STORAGE & TOKEN MANAGEMENT” using VB.NET (front end) and Oracle (back end)
• Connected the database by using ODBC and ADODC connectivity.
• Involved in the design, development, testing and maintenance of the application.
• Responsible for analyzing, designing and coding of Customer Requirement, Material Management, Customer Invoices and Customer transaction listing.
• Designing forms, integrating the sales support system with the existing system which had all the modules like Employee information, Inventory, Customer, Vendors, Brokers Information.
• Created Forms through Oracle Form Builder templates as for Form design using visual attributes, Property Classes, Alerts, Messages, Object groups and toolbars.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.
• Load the Text files into database by using Sql Loader.
• Created reports such as: Customer Bill Invoice, Customer Transaction listing, Customer-wise Report, Material Stock-wise Report.
• Involved in the GUI design as an active member of the team

Environment: Visual Basic 6.0, VB.NET, MS Access, Oracle Forms and Reports, TOAD, Sql Loader