SUMMARY

• Over 10+ years of programming experience as an Oracle PL/SQL projects mainly focusing in Application Development, Maintenance, Enhancement and Production Support.
• Involved in all phases of the SDLC from Analysis, Design, Development, Testing, Implementation and Maintenance in Banking, Investment Banking and Data Migration with timely delivery against aggressive deadlines.
• Expertise in client - server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.
• Production DBA experience in Sybase IQ 15.4/16.0, Sybase ASE 12.5/15.5/15.7/1 6 , Sybase Replication Server and MS SQL Server database administration and management.
• Extensive experience in database migration from Sybase ASE 12.5 to Sybase ASE 15.
• Extensive experience as Oracle Developer in developing and utilizing PL/SQL complex database objects like Stored Procedures, Functions, Triggers incorporating advanced PL/SQL techniques like analytic functions, Dynamic SQL, BULK techniques, Collections, regular expressions and Ref Cursors etc.,
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Ref Cursor, Dynamic SQL, Joins and Exception Handling.
• Experience with Data flow diagrams, Data dictionary, Database normalization techniques, Entity relation modelling and design techniques.
• Experience with Data Warehouse Techniques (Star and Snow flake schemas. Slowly Changing Dimensions (type1 and type2, type3), Fact and Dimension Tables).
• Good knowledge of Hadoop architecture and its components like HDFS, Job Tracker, Task Tracker, Name Node and Data Node.
• Experience in BI Tools Tableau in latest design and presentation.
• Experience in query optimization, Performance tuning using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of Global Temporary Tables and Table Partitioning.
• Good knowledge of key oracle performance related features such as Query Optimizer, Execution plans and Indexes.
• Managed cross-functional teams with diverse technical backgrounds, by adopting innovative ways to deliver technically challenging projects with on high quality and reduced cost.

TECHNICAL SKILLS

Primary Skill: Oracle 8i/9i/10g/11g, Sybase ASE 12.5/15.5/15.7/1

Secondary Skill: UNIX Scripting, PL/SQL, Sybase IQ, MS SQL Server 2005/2012

Tools: PL/SQL Developer, Toad, SQL Navigator, SharePoint, SAP BO, Tableau

Source Control: VSS, SVN, TFS, Star Team

Software Development: Waterfall method, Agile (scrum) methodology, JIRA

Scheduling Tool: Cron Jobs, Control M

Ticket Tool: Gators PGS

PROFESSIONAL EXPERIENCE

Confidential - CA

Senior Technical Consultant

Responsibilities:

• Work closely with business users to know their business views while gathering the requirements and documenting the requirements in order to design, develop, Testing and production rollover of Reporting and Analysis projects.
• Developed Stored procedures, Triggers, Tables to implement business logic
• Participated in change and code review to understand the testing needs of the change components.
• Involved in continuous enhancements and fixing production problems.
• Responsible for modifying and performance tuning of the Existing Reports.
• Participated in project sessions and generated daily Reports, Weekly Reports, Monthly Reports as per the end user and senior management requirements.

Skills & Environment: Sybase ASE 15.5/16, BMC Remedy, UNIX Shell Scripting, Tableau

Confidential - NY

Project Lead

Responsibilities:

• Responsible to participate in the requirement discussions with BNY Mellon Analysts to go through the requirements, identify the dependencies, provide inputs for any improvements and baseline the requirements involved in code review for database related projects.
• Monitor day to day jobs of money and cash voucher transactions for respective bank branches.
• Involving in daily scrum calls and provides the status update in project meetings.
• Developed and customized Packages to extract the data from different sources and load it into database.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24-hour production support.
• Developed the Unix Shell Scripts using KSH shell for file transfer.
• Co-ordinate with team member to resolve the issue if they stuck with bottleneck problem.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Partitioned tables and indexes for better performance of application
• Analyze SQL statements, reorganize database objects to improve response of queries.
• Involved in handling the changes in compiling scripts according to the database changes.
• Do the daily stand up meeting to identify the critical issue and discuss about their suggestions as part of project development concern.
• Interact with business to get the feedback about the application and about the value creation.
• Created scripts to create new Tables, Views, and Queries for new enhancement in the application using TOAD.
• Replicate transactions and generate reports in test environments for clients.
• Load changes to Sybase ASE database objects through requests raised in tool.
• Responsible for preparation of database for business implementations.
• Responsible for working with multiple up streams and down streams applications, ETL and hardware teams.
• Involved in maintenance activities like bug fixing, optimizing and performance tuning.
• Manage Sybase ASE and Sybase IQ database server in both non production and production environment
• Upgraded Sybase IQ 15.4 to Sybase IQ 16.
• Designed and maintained data warehouse system using Sybase IQ 15.4
• Provide post-production development support for migration work on production machines.

Skills & Environment: ORACLE-PLSQL, Control-M, Sybase ASE 15.5/16, Sybase IQ 15.4, SharePoint, BMC Remedy, UNIX Shell Scripting, TOAD, SAP BO 4.0

Confidential - NY

Lead Analyst

Responsibilities:

• Developed the PLSQL stored procedures, triggers, packages, functions and materialized view to implement business logic using SQL navigator for the DBX margin Application.
• Tune the other batch process in order to execute fast and to provide more bandwidth for other batch process.
• Load the data into oracle table via SQL loader and TOAD.
• Developed the Unix Shell Scripts using KSH shell for data migration.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created Design documents and Requirement understanding document.
• Performed Benchmarks and performance tuning of Sybase ASE 15.5.
• Worked on running update statistics and query optimization, and automated procedure for backing up & restoring the user databases
• Involved in creating UNIX Shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in Table Re-designing with implementation of Partitions Table and Partition Indexes to make Database faster and easier to maintain
• Was involved in unit testing.
• Prepared unit test cases and executed the same.

Skills & Environment: ORACLE SQL, PL/SQL, Sybase ASE, JIRA, Unix Shell Scripting, TOAD, Sybase Central, SVN

Confidential

Senior Software Engineer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Creating Indexes on tables to improve the performance by eliminating the Full Table Scans and Views for hiding the actual tables and to eliminate the complexity of the large queries
• Providing 24X7 2nd and 3rd line supports to production and test instances of the application and monitor the application and bridge case handling along with the team.
• Upgraded Oracle 9i to 10g software in different Environments for latest features and also tested databases.
• Developed and modified Triggers, Packages, Functions and Stored Procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Handling disk management and table space management and monitoring the batch jobs and dbms jobs daily.
• Handling the priority based user incidents and solutions in a stipulated time period.
• Handling Problem Management and Change Management through Gators PGS.
• Handling weekly platform calls based on the incidents, problems and changes handled last week.
• Handling the Shift management and other management activities for the team.
• Skilled in identifying, troubleshooting and resolving the code fix issues.
• Client Interaction for updating status, building customer confidence and generating new requirements to expand the scope of work.
• Liaising with other support team and users over phone and email.
• Raise Change Request for Release, Outage and Testing.
• Developed the Unix Shell Scripts using KSH shell for automating daily tasks.
• Proficient in directing and coordinating with team members in quality related works
• Experienced in knowledge transfer journey and made the application stable from war gaming to steady state.
• Commendable contributions have been made for stabilizing the application by providing permanent fix for all outstanding issues.
• Fine-tuned procedures/SQL Queries for maximum efficiency in various database using Oracle Hints for Rule based optimization
• Responsible for overall production support issues for modules such as Appraisals, Closings, Property Reports, Info Products, Titles and Recordings of the Order Entry System.

Skills & Environment: Oracle 10g, Power Builder 12.5/11.0/10.5 , Sybase ASE 12.5, SQL, PL/SQL, SQL Server 2012/2005, Unix Shell Scripting, TOAD, TFS, Star Team Source Control.

Confidential

Software Engineer

Responsibilities:

• Requirement Analysis, Pre and Post Activities, Designing and developing automation modules, Integration Testing and Internal Release to make the module functional
• Created databases, users & roles, profiles and managed the rollback segments, table spaces & indexing
• Developed the shell script for purging the various logs and archive files & script for creating the database metrics of various in-house projects
• Created stored procedures, functions in PL/SQL wherever required for data analysis.
• Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
• Developed the Unix Shell Scripts using KSH shell for performing daily tasks.
• Involved in Batch process system and scheduling jobs using TOAD and CRON.
• Responsible for overall production support issues, overall deliverables and coordination from offshore
• Create functional and technical design specifications for enhancements and bug fixes
• Develop stored procedures, packages, triggers and other oracle database logic
• Performing code review for the code changes from offshore
• Performing Unit Testing, Integration Testing for the new bug fixes and Enhancements on Development & Test Environments
• Providing estimates for completion times
• Was actively involved in requirement analysis, Estimation and Project Plan.

Skills & Environment: Oracle 9i, PowerBuilder 11.0, Sybase ASE 12.5, SQL, PL/SQL, VB 6.0, Unix Shell Scripting, TOAD

Confidential

System Analyst

Responsibilities:

• Gathering high-level requirements from Client. Analysing and translating those requirements into written plans.
• Translate high-level business requirements into low-level tasks and then design Oracle PL/SQL code to accomplish these objectives
• Create Functional and Technical Design Specifications for Development efforts.
• Develop complex Stored Procedures, Functions, Packages, Triggers and oracle Database Logic
• Design, analyse and develop efficient table and index design, monitor and tune performance and execution plans to improve performance
• Designing components and performing complex coding, De-bugging and testing within a Data-Management system
• Used TOAD tool to perform oracle related procedure creation.
• Worked with development team to improve Oracle Application Performance and resolve Real-Time problems as they occur
• Prepare requirements specifications, design documents and Unit Test Plans.
• Performing Unit Testing, Integration Testing and additional care for new modules and enhancements in production
• Performing Code Reviews and Design Reviews
• Providing estimates for completion times and required resources for assigned projects and program initiatives.
• Providing mentoring to team members on Oracle PL/SQL
• Participating in user group meetings to understand new enhancements and existing problem areas.
• Resolving user issues/tickets and consistently maintained SLA
• Performed the tuning analysis of the databases & tuned the parameters to improve the performance
• Developed the script for finding out the table space
• Developed the shell scripts for taking the physical & the logical database backups
• Created Control-M jobs for daily batch jobs
• Developed the Unix Shell Scripts using KSH shell for daily monitoring tasks.

Skills & Environment: Oracle, Sybase 11.0, Power Builder 6.0, SQR, SQL Server 2000, UNIX Shell Scripting, TOAD and VB6.0

Confidential

System Programmer

Responsibilities:

• Enhanced System Monitoring Application to monitor all processes of the HBS system in the server. In case of any problem occurs in the system, a mobile alert is sent to the concern department.
• Implementation of “Business Demands” in the Prepaid Billing System which are marketed as “Products” in connection to “BPL-MOTS”, in Kerala.
• Developed the Unix Shell Scripts using KSH shell for file transfer.
• Used TOAD tool to perform oracle related procedure creation.
• Responsible for the analysis, designing and coding of the front end using visual basic.
• Handled the client problems and troubleshoot and fixed and implemented bug fixes and enhancement within tight deadlines.
• Developed the Unix Shell Scripts using KSH shell for file transfer.
• Used TOAD tool to perform oracle related procedure creation.

Skills & Environment: Visual Basic 6.0, SQL Server 2000, Crystal Report 9.0