SUMMARY:

• Over 10+ years' experience in Systems Analysis, Design, Development, Testing and Implementation of application software using oracle, SQL Server, ASP .NET, JAVA, 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 cron jobs.
• Database migration experience with SAS.
• 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 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.
• 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, 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.

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.
• 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.
• 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.
• 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 11g, Dynam Software, SQL Developer, SQL Enterprise, UNIX, TOAD, Java, Java 4gl, Informix 4gl, Informix, JAVA, JDK, JAVASCRIPT PowerBuilder 11.5, SQL Server 2005

Confidential, 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.
• 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.
• 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, 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.