SUMMARY

• 10+ years of experience with proven ability in Application Development, Database Design, Implementation and Support using Oracle technology and tools on different platforms, Client - Server applications achieving high client satisfaction.
• Excellent application development skills and experience in Oracle 9i/10g/11g/12c using PL/SQL, Pro*C, UNIX shell scripting and ETL implementations in Financial Services domain.
• 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 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.
• Successfully implemented large complex conversion/migration projects using multiple technologies.
• Used Bulk binding techniques like BULK COLLECT and FOR ALL to improve performance.
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Knowledge on Dimensional Modeling and Data warehouse concepts (Star Schema, Snow Flake Schema, Dimension and Fact table).
• Knowledge of Logical & Physical Data Model in Relational Database Management System (RDBMS).
• Have a good knowledge of Big Data Technologies (Hadoop, Pig, Hive, Sqoop)
• Experience in Production Support/maintenance with quick turnaround time.
• Have expertise knowledge on development methodologies like Waterfall, Agile and Scrum practices.
• 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 teams of sizes 25+. 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 the issues, 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 Training 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, 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: SQL Developer, TOAD, Putty, SQL * Loader, VI Editor, FTP tools

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

Big Data: Hadoop (Knowledge on HDFS, HBASE, PIG, HIVE, SQOOP)

Version Control: Borland StarTeam, VSS, RTC

Scheduling Tools: Control-M

Execution Methodologies: Waterfall, Agile

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

PL SQL Lead 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, Montvale, NJ

PL SQL Lead Developer

Responsibilities:

• Analyzing current system for insight on full technical details to accomplish Business requirement
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
• Create and maintained Metadata, including table, column definitions.
• 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.
• 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.
• 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, 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 that are processed using ETL, shell scripting and Pro*C
• 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, Pro*C, SQL Server, DB2, mainframes, windows batch scripting for Accurate vendor tool, Linux, RTC

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 (Ad hoc Reports on demand)

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