SUMMARY

• 11 years of experience with proven ability in Application Development, Data modeling, Database Design, Implementation and Support using Oracle technology and tools on different platforms achieving high client satisfaction.
• Excellent application development skills and experience in Oracle 9i/10g/11g/12c using PL/SQL, Pro*C, UNIX shell scripting, Java and ETL implementations.
• More than 6 Years of Experience in UNIX Shell scripting utilizing utilities like awk, perl, sed, etc.
• Extensive experience in PL/SQL that includes Cursors, Ref - cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Exception Handlers, Partitioned Tables, Triggers, Materialized Views, Table Indexing, SQL*Loader and using latest features to optimize performance.
• Expertise in Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non-Oracle Database, Mainframe files etc.) to Oracle Database using PL/SQL procedures, SQL*LOADER, Export/Import, UTL-FILE, External Tables etc.
• Expertise in Performance Tuning&Optimization of SQL statements.
• Proficient in advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Designed and developed the Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Good knowledge in OOPS and RDBMS concepts.
• Successfully implemented large complex conversion/migration projectsusing multiple technologies.
• Used Bulk binding techniques like BULK COLLECT and FOR ALL to improve performance.
• Extensively worked in Client- Server application environment usingoracle11g on Windows/Linux platforms and profound knowledge on 9i/10g/11g,SQL*plus,data migration usingSQL*loader.
• Experience in Production Support/maintenance with quick turnaround time.
• Have expertise knowledge on development methodologies like Waterfall, Agileand Scrumpractices.
• Experienced on all types of Projects (Development, Migration&Support).
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Lead multiple projects with teamsofsizes25+. Provided Technical guidance, guiding team to complete assigned tasks, setting goals, providing performance feedback and mentoring.
• Participated in code and peer reviews as well as formal walk-throughs.
• Provided estimations, planning and project execution plan to client requirements and providing the status to all key stakeholders.
• Proactive in identifying theissues, escalating and communicating the issues to the business clients.
• Extensively worked on all the phases of Database life cycle from Design to Project Support in Business and Functional Requirements Gathering, support in developing Use Cases, conducting Gap Analysis, preparing manual.
• Having knowledge and experience on Investments systems and applications like Brokerage, Mutual Funds, Managed Accounts, Phase3, GIM2, PAM, CAMRA, CRIMS, Cost Basis.
• Strong leadership skills demonstrated in end-to-end project delivery.
• Outstanding analytical, problem solving and debugging/troubleshooting skills.
• Strong personal drive and ability to work individually and in team environments.
• Explain technical concepts and communicate with users/system administrators at all levels.
• Flexible and very enthusiastic to work/learn new technologies/tools in a quick turnaround of time.
• Solid work ethics and a good team player.

TECHNICAL SKILLS

Packages/Suites: Microsoft Office Suite, Microsoft Visio

RDBMS: Oracle 9i/10g/11g/12c, MS-SQL Server 2000/2005, DB2, MS-Access

Programming Languages: SQL, PL/SQL, Pro* C, Java, UNIX Shell ScriptingWeb & Reporting Tools HTML, XML, JavaScript, CSS, Crystal Reports

Development Tools/Utilities: TOAD, SQL Developer, Putty, SQL * Loader, VI Editor, FTP tools

Platforms: Windows XP/NT/2000/2003, UNIX, Linux

Version Control: Borland StarTeam, VSS, RTC

Scheduling Tools: Control-M

Execution Methodologies: Waterfall, Agile

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

PL/SQL Lead Developer

Responsibilities:

• Analyzing current system for insight on full technical details to accomplish Business requirement
• Created scripts for new tables utilizing enhanced Oracle 12c features like identity columns, default on null, row archival for temporary data archiving, extended size for character data types, DDL logging, etc.
• Utilized new features for better query performance such as temporal data selection using DBMS FLASHBACK ARCHIVE package, top-n features, WITH clause functions, PRAGMA UDF, etc.
• Created PL/SQL Packages, Views, Functions, Procedures,Indexes, Integrity constraints and Triggers according to the design to fulfill requirements.
• Created Dynamic SQL statements in procedures.
• Developing, Modifying, Debugging SQL Queries according to the requirement
• Designed and developed daily batch jobs representing manual ETL process for transmission and processing of data files between source and target systems.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching betweenSQLandPL/SQLengines.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Involved in preparing scripts for validating files from different sources, develop scripts and stored procedures for loading data into staging and target tables from control files using UNIX shell scripts
• Involved in preparing shell scripts for running jobs in parallel and calling procedures to load the data into tables and developed daily batch jobs for processing the data on daily basis.

Environment: Oracle 12c, DB2, UNIX shell scripting, PL/SQL, Java, SQL Developer, Linux, Windows, MS Office, Visio, SQL Developer

Confidential, Durham, NC

PL SQLLead Developer

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• DevelopedPL/SQLtriggers and master tables for automatic creation of primary keys.
• CreatedPL/SQLstored procedures, functions and packages, created scripts to create new tables, views, queries for new enhancement in the application.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in CompleteSoftware Development LifecycleExperience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Worked on Production Fixes, Analysis and Development of enhancement requests.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching betweenSQLandPL/SQLengines.
• Extensively used the advanced features ofPL/SQLlike Records, Tables, Object types and DynamicSQL.
• Handled offshore and onshore team as a team lead.
• Changes to programs that contain the SQL statements to data source to point new hierarchy tables.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning, Coding, Code Reviews, Technical assistance to team.
• Test developed program modules against prepared test cases.
• Ensuring quality, timeliness of product delivery and provided support 24*7 in maintenance duration.

Environment: UNIX shell scripting, Oracle 12c, PL/SQL, SQL Developer, COBOL, JCL, Easytrieve, DB2, CICS, VSAM, and Endeavor.

Confidential, San Antonio, TX

PL SQLLead & Java Developer

Responsibilities:

• Provided guidance to technical teams in making widgets reusable for other client applications.
• Actively participated in High-level Design discussions understand business rules and convert to System Requirements.
• Developed application using Java, Wicket framework and Integrated the application with the services.
• Developed backend supporting application using shell scripting and PL/SQL
• Took care of Configuration Management activities for all teams including build and deploy activities.
• Involved in integration testing with various client applications and across different channels.
• Prepared Specification documents created and updated wiki pages on internal site with details of how to integrate widget and details of what need to be taken care for future migrations.

Environment: Oracle 11g - PL/SQL, SQL Developer, Java, Clients customized Wicket framework, UNIX shell scripting, Linux, Windows, MS Office, Visio, RTC

Confidential, San Antonio, TX

PL SQL Lead Developer

Responsibilities:

• Designed and developed daily batch jobs for processing the daily reconciliation reports received between multiple systems and vendors.
• Successfully automated the process of saving Journal and TA reports to EOS and business share location, avoiding the manual process downloading them by business team.
• Established infrastructure to send all the Mutual Fund transaction and Transfer Authorization details between downstream systems for automated transmission of data on different platforms between windows batch, mainframes and Data stage processing.
• Strong domain knowledge and prior conversion experience helped to deliver the Mutual Funds information in a usable format where Fund Account Agents can interpret and process the information without any change.
• As a Tech lead, acted as a liaison between large Development and Business operations teams to provide proper communication.

Environment: Windows, Datastage, Oracle 11g, SQL Server, mainframes, windows batch scripting for Accurate vendor tool, Linux, RTC

Confidential, San Antonio, TX

PLSQL Lead Developer

Responsibilities:

• Provided technical solutions to the issues faced by the development teams.
• Identified risks involved in time synchronization with vendors, initial steps for launch of new mutual funds and proposed mitigation plan at early stages.
• Defined a development methodology and standards to develop the services with high quality and less time.
• Prepared tailored design tool for this effort which returns scripts for the business requirements provided as input. This reduced development effort by 33% on overall effort and 12% cost for next launch of new funds.
• Closely worked with SMEs to gather requirements in rewriting requirements from previous year.
• Prepared Cookbook with all minute details, technical impacts and impacted systems, components which serve as detailed Analysis document for similar future efforts.
• Designed process maps for the launch of new funds that can be reused - which involved nearly 136 SMEs and saves time.

Environment: Windows, Java, Oracle 11g, UNIX Shell Scripting, SQL*Plus, PL/SQL, SQL Developer, RTC, mainframe, Linux, Smartbear Code Collaborator V7, Exceed

Confidential, San Antonio, TX

PL SQL Developer

Responsibilities:

• Played key role in implementing complex business requirements thus providing benefits in terms of Compliance, Risk Mitigation and Time savings for business team.
• Developed Unix shell script to validate the input feed files received for trade orders from vendors.
• Wrote complex SQL queries, Sub queries and nested loops for faster data retrieval.
• Created batch jobs to load data into our database using UNIX Shell Script and Control - M scheduling.
• Wrote Shell Scripts to do manipulation on vendor input files and loaded into database table
• Generating various reports on requirements using PL/SQL, ProC and SQL * plus SPOOL command.
• Designed and developed various validation reports which reduced 70% of post trade reports validation time.
• Strong knowledge on Charles River application and internal IMCO systems helped successful mapping of various data attributes across different platforms.
• Designed and developed daily batch jobs for processing the daily
• CreatedPL/SQLstored procedures, functions and packages, created scripts to create new tables, views, queries for new enhancement in the client application.
• Proposed block trade execution for similar stocks and larger volumes which helped in improve performance and less trade cycle time.
• Coordinating with offshore, attending regular hand-off and transition meetings for new projects.
• Providing Knowledge transition on delivered effort to Production Support team.

Environment: Oracle 11g, UNIX shell scripting, PL/SQL, JAVA batch and CRIMS, Exceed, RTC, Smartbear Code Collaborator V7, Crystal Reports.

Confidential, San Antonio, TX

PL SQL Developer

Responsibilities:

• Successful migration of Open and Closed Tax Lots of Brokerage and Mutual Funds Accounts in the form of seed files.
• Established infrastructure to send all the real time Trades / Stock details to vendor through MQ/ Java web services.
• Involved in Created database objects like table, indexes, procedures, packages, triggers, sequences, synonyms, etc.
• Designed critical and complex database queries for data extraction from multiple databases and played major role in reconciliation after conversion
• Strong domain knowledge and prior conversion experience helped to deliver the tax lots information in a usable format where vendor can interpret and process the information with less effort.
• Designed and developed daily batch jobs for processing the daily reconciliation reports received from the vendor.
• Wrote Unix shell scripts to validate and manipulate the vendor files.
• Used File Transfer Protocol (FTP) tool to transfer files from one server to other.
• Worked on CTRL M for Scheduling Batch Jobs.
• Involved in Unit testing, Integration test and writing the Test plan.
• Preparing the technical documentation on changes done.
• Release notes and Rollout and Backout plan.
• Trained other team members on the functionality and operability of the application.

Environment: Java, UNIX Shell Scripting/Pro*C, Java, Datastage and Oracle 11i as a backend, Windows, Linux, SQL Developer, Slick Edit, Borland StarTeam, Smartbear Code Collaborator V7, Crystal reports

Confidential, San Antonio, TX

PL SQL Developer

Responsibilities:

• Preparation of Checklists, identification of Test Cases, preparing Test Plans.
• Developed Pro C scripts with embedded plsql and sql.
• Wrote Unix shell scripts to invoke the Pro C executables.
• Wrote complex SQL queries, Sub queries, Cursors and Collections for faster data retrieval.
• Involved in Performance Tuning for the SQL, PL/SQL scripts.
• Extraction of data from different flat files into Oracle Database using SQL* Loader.
• Extensively used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Coordination with the Release Management team to ensure the version control of the scripts execution in Production environment.
• Provided knowledge transfer to other team members about the new technology and allocation of tasks to the team.
• Involved in writing technical documentation, and writing test plan.
• Coordinated with development team, project management, QA and provided necessary support.
• Developed the interfaces between USAA and new system Checkfree APL using Pro*C and UNIX shell scripting.
• Designed and developed daily batch jobs for transmission and processing of accounts and transactions between USAA and APL.
• Developed and integrated interfaces between internal systems with rigorous integration testing and unit testing performed at each element level.

Environment: UNIX shell scripting, Oracle 11i, Pro* C, PL/SQL, Java/J2EE, Crystal Reports, Windows, Linux, SQL Developer, Slick Edit, Borland StarTeam.

Confidential

Developer

Responsibilities:

• Involved in migrating Database from SQL Server to Oracle.
• Wrote custom functions in Oracle for SQL Server functions to keep the migration changes minimal.
• Involved in writing database stored procedures, triggers and functions.
• Tuned SQL queries using execution plans for better performance.
• Involved in developing of front end web pages.
• Performed unit testing, integration testing and supported acceptance testing.
• Preparing the technical documentation on changes done.
• To find out bugs in the application and rectify them.
• To prepare document as per the changes in the code.
• Involved in maintenance and support post implementation.

Environment: Developed web based application with ASP, Java Script, HTML and oracle as backend, Windows, IIS, SVN, MS Visual Interdev

Confidential

Developer

Responsibilities:

• Interacting with client for collecting requirements.
• Designed and developed the User Interface application using ASP, Java Script, HTML
• Preparation of Specification Documents.
• Involving in design of Databases and Stored Procedures.
• Generating Custom Reports (Adhoc Reports on demand)

Environment: ASP, Java Script, HTML, CSS, SQL Server, MS Project 2002, Windows, IIS, SVN, MS Visual Interdev