SUMMARY:

• Over 10+ years' experience in Systems Analysis, Design, Development, Testing and Implementation of application software using oracle, SQL Server, Java, JavaScript, jQuery, CSS and power builder..
• Developing client/server and multi - tiered applications using Oracle Database and PL/SQL on different platforms and production support.
• Worked with IBM Netcool manage both wireless and fixed IP network performance using an extensive library of network interfaces called technology packs.
• Expertise in all phases of the SDLC including analysis, Conceptual Design physical and logical design, Data Modeling and Data Architecture, documentation, code development, testing, implementing, resource planning and maintenance.
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, cursor, ref cursor, DB Triggers, table partition and Indexes.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Experience in writing and tuning of complex SQL statements, complex joins, sub-queries and in-line views.
• Extensive experience on UNIX SHELL scripting and corn jobs.
• Database migration experience with SAS.
• Data Masking of a large databases.
• Generated DDL, DML statements for creation of new database objects like tables, views, merge, materialized view, sequences, synonyms, indexes, DB Links, roles and granting privileges.
• Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Experience with oracle algorithms with oracle data miner.
• Experience in client-side Technologies such as HTML, CSS, JavaScript, jQuery and Ajax.
• Having solid work experience on XML, JSON, JAXP, HTML5, JavaScript, CSS3 and Ajax
• Experience in web application design using MVC Spring Framework and Struts Framework.
• Very strong shell scripting skills on platforms like HP-UNIX, SOLARIS.
• Proficiency in data warehousing techniques for data cleansing, slowly changing dimension phenomenon, surrogate key assignment and change data capture.
• Expertise in Data warehousing and Data migration
• Proficient in programming in Oracle 11g/10g/9i/8.x using SQL, PL/SQL.
• Developed several PL/SQL Batch programs implementing transaction management using oracle features like SAVEPOINT, Rollback and Autonomous transaction on UNIX.
• Strong database concepts and experience on SQL, PL/SQL.
• Good understanding of server-side programming (Stored Procedures, Stored Functions, and Database Triggers).
• Experience in creating Index, Views, complex Stored Procedures, appropriate functions and Triggers.
• Experience in performance tuning of ETL processes and DataStage jobs in SMP and MPP environments from both system as well as job design perspective.
• Proficiency in data warehousing techniques for data cleansing, slowly changing dimension phenomenon, surrogate key assignment and change data capture.
• Experienced in Agile Software Development Methodology using Scrum
• Involved in complete lifecycle of the ETL process including testing and production support
• Good exposure to Software Life cycle Phases.
• Good exposure on Data Modeling and Data analysis.
• Handled advanced SQLs for optimization with decode, cast, and having clauses.
• Good Experience in Optimizing Long Running SQL's.
• Ability to adapt new changing technologies faster and a good team player.
• Experience on tuning SQL queries.
• Proficient in programming using SQL LOADER.
• Used in REST webservices and JDBC, Hibernate.
• Employed tools like TOAD, Oracle, SQL*Plus, SQL Navigator.
• Using Java created non-visual user object functions with oops concepts.
• Excellent experience of working with object oriented Concepts such as Inheritance, Polymorphism and Encapsulation.
• Using PowerBuilder created different windows from scratch with user friendly buttons options.
• Using PowerBuilder modified/altered run time SQL for complex SQL queries.

TECHNICAL SKILLS:

Operating Systems: HP-UNIX, Sun Solaris, Windows 2008/2003/XP/2000/NT.

Languages: C, C++, SQL, PL/SQL, ASP, HTML 4.0, XML.

Databases: Oracle 8i, 9i, 10g/11g,12c, PL/SQL, SQL Server 2005,2008

Scripting: UNIX Shell Scripting, Perl, Scheduler, Cronjobs

Primary tools: SQL*Loader, PL/SQL Developer, PL/SQL, Toad, SQL Navigator.

Front End & Web: PowerBuilder 6.5,9,10.5,11.5, Java, JSP, Servlets, JavaScript, Struts, ASP.NET 4.x/3.5/3.0/2.0, MVC, Web Services, WCF

Other Technologies & Version Control Tools.: MS FrontPage 4.0, HTML, PVCS version manager, PVCS tracker, Dynam software, ClearQuest.

Other Skills: Requirements Analysis, High level Design, Code reviews, Testing, Production Support and Implementation, Informatica.

ETL Tools: Ascential Datastage EE 8.x/7.x/6.x, QualityStage 8.x

OLAP Tools: Oracle Discoverer, Siebel Analytics, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential (Crystal city - VA)

Senior Consultant (oracle PL/SQL /UNIX)

Responsibilities:

• Created PL/SQL packages consisting of procedures and functions for implementing complex business logic.
• Expertise with SQL*loader scripts to migrate the data from flat file to Oracle.
• Analyzing the schemas (tables, indexes) to gather statistics, Created indexes for better performance.
• Extensively worked on scripts to test database objects like tables, triggers, constraints and sequences.
• Extensively used collections, ref cursors to create the procedures.
• To speed up the application fine re-engineering has done.
• Extensive experience in SHELL scripting.
• Strong experience on UNIX cron jobs.
• To work with the offshore team’s the data masking has done for databases.
• I converted the Informix scripts to SQL server scripts.
• Created Data Mapping using Ascential Datastage as ETL tool for designing Server jobs.
• Identifying the potential conformed dimensions to be converted into Incremental
• Developed the SQL’s for clean up the database to release the locks.
• All the constraints are set in disable mode to do the masking and run the masking SQL’s.
• Export the data from excel to csv file format.
• Used partitioning to increase the speed.
• Database masking by running masking SQL for over billion data.
• Experience with oracle algorithms with oracle data miner.
• Backend procedure for merging the subscribers with the dependents.
• Running daily SQL to clean up the bad data.
• Created new Stored Procedures and Functions to be called by Datastage Jobs.
• Used Datastage Director to schedule the jobs, Monitoring, testing and debugging.
• Designed Job Sequencer to execute the jobs in batches and to enforce referential Integrity among target tables.
• Implemented W3C and other web design standards. sed GitHub for Code management and issue tracking.
• Customizing the existing UI screen and changing the styles and theme.
• Used front end dependency management and packaging tools like Npm, Bower, Grunt
• Provided extensive pre-delivery support using Bug Fixing and Code Reviews.
• Co-ordinating with the different teams like Business, Testing and Production Support.Actively involved in design & development of IDD Asia and Europe application using Java, Spring, Flex and Cairngorm Framework.
• Troubleshoot with Teradata connections.
• Migrated Teradata.
• Created new Stored Procedures and Functions to be called by Datastage Jobs using Stored Procedure stage.
• SQLLDR used to migrate data from high volume CSV files to Database
• Developed RESTful Web services to create new subscription/account and updating subscription/account for mobile value chain in JSON format and consumed Rest Web services from the browser using AngularJS
• Wrote Stored Procedures for insertion and updating of the data into the tables
• Created and maintained oracle Packages in TOAD 9.1
• Designed and developed various Tables and Views, indexes, sequences, triggers, roles
• Optimize SQL queries for better performance.
• Code layouts using HTML, XHTML and CSS adhering to web 2.0 standards.
• Created semantic web HTML mockups and Style sheets.
• Constructed and implemented multiple-table links requiring complex JOIN statements, including outer-joins and self-joins.
• Tuned SQL queries using Explain plan, TKPROF, SQL Trace and hints.
• Responsible for gathering the requirements for creating data models for data analysis and reporting.
• UNIX support.
• Optimization through explain plan.
• Backup the database and masking through import & export.

Environment: Oracle 12c, Dynam Software, SQL Developer, SQL Enterprise, Ascential Datastage 7.5.3, UNIX, TOAD, Java, Java 4gl, Informix 4gl, Teradata, Informix, JAVA, JDK, JAVASCRIPT PowerBuilder 11.5, SQL Server 2005

Confidential (NSC - Herndon)

Senior Consultant (oracle PL/SQL, UNIX)

Responsibilities:

• Coordinate with the application team (java developers) to provide them with the necessary stored procedures, functions and packages (Stored Procedures, Functions, Cursors, Ref cursor) and the necessary insight into the data.
• Resolved functional issues in business processes through enhancements.
• Improve visibility into network performance to help minimize service degradations and disruptions and speed trouble shooting IBM Netcool performance manager.
• Reduce operational costs and boost efficiencies with IBM Netcool performance manager.
• Converted business logics to logical and then physical design of database systems.
• Performed tuning and optimization on SQL Queries using analyze, explain plan, TKPROF utility and optimizer hints.
• Extensively used SQL*LOADER to load data from flat files obtained from various facilities every day.
• Extensively used UTL FILE to put data in text file in a fixed length format.
• Generated server-side PL/SQL scripts for data manipulation and validation and created various Materialized views, global temporary table.
• Actively involved in design & development using Angular JS 2.0, HTML 5.0, JavaScript, JQuery, Bootstrap 3, CSS3, Java, Spring.
• Developed Custom angular JS Directives and Filters.
• Integrated third party open source JavaScript/Angular JS UI component.
• Created and used Table Partitions to further improve the performance while using tables containing large data.
• Created semantic web HTML mockups and Style sheets.
• Customizing the existing UI screen and changing the styles and theme.
• Generated Scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, Granting and Revoking Schema Object Privileges and Roles, Responding to System Events through Triggers.
• Having experience on database migration.
• Used nested tables, Varrays/associative arrays, string indexed, nested collections; wrote PL/SQL programs using collections and compared associative arrays to collections.
• Involved in data loading using PL/SQL and SQL*Loader, External tables and cron jobs calling UNIX (AIX) scripts to download and manipulate files.
• Involved in Performance tuning which included creating indexes and modifying tables using tools such as explain plan utility, hints, SQL trace.
• Involved in developing UNIX Shell Scripts required for maintaining the data Models and processing job.
• Modified UNIX shell scripts for automating batch jobs and developed PERL API’s.
• Developed automated Korn Shell Scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Regularly analyze review the Crystal reports developed and make enhancements to them if recommended by the user.
• Worked with postgress databases.
• Used ETL for process cycle and production support.
• Used advanced SQL with decode, cast, having and where current of clauses.
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports version XI.
• Performed Integration testing for checking complete functionality of various modules.
• Participated in daily status meeting to report any bugs, issues and risks.
• Provided 24*7 Production Support for complex modules.

Environment: Oracle 9i/10g/11g, SQL*Loader, TOAD, PL/SQL, SQL*Plus, Erwin, Crystal Reports XI, SQL Server 2005, PowerBuilder 9,Postgress, UNIX, PERL, Clear case(Version Control), Clear Quest, Windows 2000/XP,ASP.NET, JAVA

Confidential (Alexandria - VA)

Senior Consultant (oracle PL/SQL )

Responsibilities:

• Written PL/SQL stored procedures and Triggers.
• Used Array concept to validate the data.
• Used dbms job for scheduling the procedures.
• Developed system test scripts, unit test scripts, detail design documents for the enhancements.
• Worked extensively on tuning SQL queries and database modules for optimum performance.
• Wrote UNIX scripts and scheduled the jobs using Crontab utility.
• Tested stored procedures in different environments.
• SQLLDR used to migrate data from high volume CSV files to Database
• Wrote Stored Procedures for insertion and updating of the data into the tables
• Created and maintained oracle Packages in TOAD 9.1
• Creating Design templates for Ascential Jobs for re-used logic and setting Bench Marks for development Standards
• The company screen modified to accommodate more than 1000 companies before it was 500.
• For product enquiries the account no column made not visible for certain conditions.
• The datawindow designs modified between the bands.
• Written the PB function for converting double quotes to single quotes in each string.
• Designed and developed various Tables and Views, indexes, sequences, triggers, roles
• Interaction with the stakeholders and business users and collected the requirements to develop the system

Environment: Oracle 11g, SQL*Loader, TOAD, PL/SQL, JavaScript, PowerBuilder 9,Postgress, UNIX, PERL, Clear case(Version Control), Clear Quest, Windows 2000/XP,ASP.NET, JAVA

Confidential, Washington, DC

Consultant Oracle PL/SQL, UNIX

Responsibilities:

• Column level validations done from the backend side.
• Oracle cron jobs process the documents.
• Written an oracle procedure to return the document id based on the user id.
• Executed oracle scripts to find the invalid objects and recompiled them.
• Modified the oracle table to alter the column.
• Changed the materialized view for CLOB datatype to varchar2 datatype.
• Using toad to import the data from excel file.
• Executed the reports for users on monthly or quarterly basis.
• Modified oracle packages.
• Created oracle SQL scripts to execute the reports.

Environment: Java, Oracle Enterprise 11g, UNIX TOAD, ClearCase, SQL Developer, Documentum, SAP, SQL Enterprise.

Confidential

PL/SQL Consultant

Responsibilities:

• Resolved functional issues in business processes through enhancements.
• Converted business logics to logical and then physical design of database systems.
• Performed tuning and optimization on SQL Queries using analyze, explain plan, TKPROF utility and optimizer hints.
• Extensively used SQL*LOADER to load data from flat files obtained from various facilities every day.
• Generated server-side PL/SQL scripts for data manipulation and validation and created various Materialized views, global temporary table.
• Generated Scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Involved in PowerBuilder enhancements and developed user objects, response, main windows for new user interface modifications.
• Extensively involved in PowerBuilder EXE creation and deployment.
• Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, Granting and Revoking Schema Object Privileges and Roles, Responding to System Events through Triggers
• Oracle Function created to increase the speed of the application from front end to back end (Re-Engineering)
• Involved in Gathering and Analyzing Business requirements with product management team.
• Communicated with the End-Users to study the system requirement and develop Functional and Technical specifications to meet the requirements.
• Integrated spring framework with hibernate for data access and other operations.
• Developed user interface using JSP, JSTL, Spring Tag libraries and Java Script
• Created various database objects as per the business/product requirements.
• Created PL/SQL packages consisting of procedures and functions for implementing complex business logic.
• Expertise with SQL*loader scripts to migrate the data from flat file to Oracle.
• Analyzing the schemas (tables, indexes) to gather statistics, Created indexes for better performance.
• Extensively worked on scripts to test database objects like tables, triggers, constraints and sequences.
• OOPS concepts used for creating window level, global and NVO functions.
• Not null column validation checks using global function call in close query event.
• Mouse move up and tooltip points provided with yellow box.
• Share data function used in all master screen entries.
• In reports computed columns used for uniform display in all reports detail and header sections.
• Actively involved in design & development using Java, Spring, Flex, Html and JavaScript framework
• Customized existing UI screen design and implemented different dynamic themes.
• Developed Custom Flex/Action Script UI component.
• Implemented Swiz UI framework on Flex UI application.
• Created Html template and Integrated Flex and Java application.
• Re-engineering of PowerBuilder front end SQL moved to oracle back end side to increase the speed of the applications.
• Created Data Mapping using Ascential Datastage as ETL tool for designing Server jobs.
• Worked Closely With reporting team requirements to achieve efficiency by incorporating the major transformations on ETL side thereby increasing performance for BO Reports
• Optimized long running SQL's.
• Created combined indexes.
• Created temporary table's to export the data for a particular session.
• Logistics process of import and export mechanism written as procedures using oracle 11g.
• Round the clock production support.
• Application currently using in 70 countries worldwide
• Incorporated business concepts in PowerBuilder front end tool.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, JAVA, CSS, PowerBuilder 11.5, Dynam software (Version control), Unix, Ascential Datastage 8.0.1.

Confidential

SQL Developer

Responsibilities:

• Worked in a team of Ten, Involved in development, enhancement, testing and performance tuning of the application
• Developed the Application using Microsoft.Net (ASP.NET).
• Developed Custom Controls and User Controls using C#.
• Extensively using ADO.Net to interact with the SQL Server database.
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application & data migration, created new stored procedures & SQL scripts as part of the enhancements.
• Created new SQL scripts/TSQL for the data validation/datatype checks/referential integrity checks/rollback scripts etc.
• Developed DTS/SSIS Packages to transform data from Text/CSV/Excel file to SQL Server database.
• Worked in SQL Server Reporting Services 2005 for reports generation.

Environment: ASP.Net, C#.Net, ADO.Net, AJAX, JavaScript, XML, MS SQL Server 2005/2000, TSQL, Data Transformation Service (DTS), SSIS, Windows XP, Visual Source Safe and Microsoft SQL Server Reporting Service 2005, Powerbuilder.

Confidential, NY

PL/SQL Consultant

Responsibilities:

• Written PL/SQL stored procedures and Triggers.
• Used Array concept to validate the data.
• Used dbms job for scheduling the procedures.
• Developed system test scripts, unit test scripts, detail design documents for the enhancements.
• Worked extensively on tuning SQL queries and database modules for optimum performance.
• Wrote UNIX scripts and scheduled the jobs using Crontab utility.
• Tested stored procedures in different environments.
• SQLLDR used to migrate data from high volume CSV files to Database
• Wrote Stored Procedures for insertion and updating of the data into the tables
• Created and maintained oracle Packages in TOAD 9.1
• Creating Design templates for Ascential Jobs for re-used logic and setting Bench Marks for development Standards
• The company screen modified to accommodate more than 1000 companies before it was 500.
• For product enquiries the account no column made not visible for certain conditions.
• The datawindow designs modified between the bands.
• Written the PB function for converting double quotes to single quotes in each string.
• Designed and developed various Tables and Views, indexes, sequences, triggers, roles
• Interaction with the stakeholders and business users and collected the requirements to develop the system
• Developing Macro's using VBA coding to automate the Microsoft Project templates
• Involved and Interacted with the off-shore team for the development of the enhancements
• Capture the trades which are not loaded through the automation process, add those data's into the oracle system using PowerBuilder

Environment: Oracle 9i/8i, SQL, PL/SQL, TOAD, SQL Loader, UNIX Shell Script, PL/SQL Developer, PowerBuilder 9.0, ClearQuest.

Confidential

PowerBuilder/PL/SQL Consultant

Responsibilities:

• Involved in the Team meetings that was setup by the Analysts/Users to understand the requirements and existing system.
• Designed and Developed Maintenance screens, Reports in PowerBuilder
• Designed and Developed Oracle Procedures, Functions and Packages
• Designed and Developed Windows, Datawindows & User Objects in PowerBuilder.
• From PowerBuilder Called Procedures, Functions & Packages that was written in Oracle.
• Enhanced existing Menus, User Objects, Windows & etc. in PowerBuilder.
• Reused Windows, Datawindows, User Objects, Menus, Structures & etc. in PowerBuilder.
• Written Oracle Stored Procedures with cursors etc. that was used to send emails based on the requirement.
• Reused Oracle Functions, Procedures and Packages.
• Involved in Detailed Testing of the above requirements based on the test scripts.
• Coordinated with Review, analyzes, and evaluates business system and System needs.
• Created Use Cases to describe the System needs program functions to develop or modify the system and programs.
• Assisted Product Development in designing and developing the standard.
• Conducted design review, Data Model Presentation with User Group.
• Created Table, View, Indexes, Procedures, Functions, Triggers, Stored Procedures, Libraries, Forms, and Involved in all phases of testing.
• Scheduled and conducted UAT and User Training.
• Provided Customer support.

Environment: PowerBuilder 6.5, Oracle 8.0, Windows NT

Confidential

PL/SQL Developer

Responsibilities:

• Involved in coding & designing of SQL, PL/SQL procedures and functions.
• Written PL/SQL stored procedures, functions and Packages for report generation.
• Created various types of views to project the data based on front end Requirement.
• PL/SQL coding for Exception Handling and Duplicate Data maintaining.
• Worked with DBA's to correct problems with sequence, grants.
• Wrote PL/SQL scripts for data uploading from one schema to another.
• Created UNIX shell scripts, which call the PL/SQL scripts.
• Identification of the referenced items / program units in forms and removing their database references.
• Written CRON Jobs in UNIX to run Nightly, weekly cycle processes automatically.
• Worked extensively on tuning SQL queries and database modules for optimum performance.

Environment: Oracle 9i/8i, SQL, PL/SQL, TOAD, PL/SQL Developer, UNIX Shell Scripting, PVCS Version Manager and PowerBuilder.

Confidential

Sr. Project Associate

Responsibilities:

• Created/Compiled Stored Procedures, Tables, Indexes and etc.
• Optimized the SQL Statements in order to avoid the database crash.
• Involved in Analysis of the Stored procedures, Tables, Indexes & Triggers.
• Involved in System study and Analysis of the C Language process which includes stored procedures and SQL Statements.
• Prepared documents and reviewed the code.
• Uploaded the data from the flat file to the database.
• Processed the data for the current usage.
• Fixed the existing bugs in the data.
• Written test scripts and test plan.
• Tested the changes.
• Development.
• Coordinated development team for technical issues.
• Provided technical assistance and mentoring to developers.
• Performance Tuning, coding.
• Setting up Coding standards for the development team.
• Written triggers, stored procedures for the application.

Environment: PowerBuilder 7.0, Oracle 8i, Windows XP