OBJECTIVE

• To become a part of a result oriented and highly successful team involved in implementing innovative ideas with quality standards and latest technological trends. I am seeking a challenging position with a company that is rapidly expanding and offers good advancement the best in me.

SUMMARY

• Close to 9 years of IT exp of programming experience in Analysis, Design and Implementation of Business Applications mostly in banking domain & real - time transactional environment and UAT & end to end testing, w orking on PL/SQL & Informatica development, crystal reports and webi report and unix shell scripting for integrating with customer requirements.
• Worked on crystal reports and WEBi reports.
• Have experience in working on ETL tools - Informatica ETL designing transformations, mappings and workflows .
• Went to onsite Germany for gathering business requirements and UAT testing for Telefonica Germany.
• Extensively used Unix shell scripting in most of the projects.
• Involved in all phases of the SDLC (Software Development Life Cycle) from requirements gathering, analysis, design, development, testing, implementation, testing, UAT, production and post-production support and maintenance with timely delivery against aggressive deadlines.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Involved in Purge and Archival activity and created scripts for the large database for efficient database maintenance.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Technically adept and confident software programmer with exceptional skills in coding and documentation
• Strong working knowledge in Oracle 9i/10g/11g SQL and PL/SQL Programming.
• Worked with client CITIBANK at onsite UK for 6 months for FLEXCUBE Production Support.
• Performance tuning and query optimization experience.
• Understanding the requirements from the functional specification document and developing the code to implement the functional changes after proper testing and then do the impact analysis.
• Participating in requirement gathering, preparing estimation, test strategies, test cases and executing them
• Worked with the front end .dot net/java team to implement the required changes after developing the pl/sql code with proper functional & technical documentation
• Experienced in Tuning Queries for better performance with large volume of data and which are taking more time to complete.
• Good communication skills and experience in customer interaction in requirements gathering.
• Worked with SQL scripts.
• Experience in manual testing, UAT & functional software testing, backend testing and regression testing in banking domain for product FLEXCUBE
• Experience in PL/SQL enhancements & testing & support for banking product
• IBBS and 1st level Flexcube Production Support for banking product
• Creation and execution of QA and testing processes, test cases, test strategies and plans, and bug documentation and regression
• Awareness of bank functionality and industry standards.
• Defect management, Reporting, documentation and client handling
• Involved in giving trainings on testing and core banking
• SQL query writing, PL/SQL programming (Procedure, Package, function), query ptimization, Informatica Basics.
• Extensive use of packages, procedures, functions for implementing business rules
• Generating reports using SQL, PL/SQL, and UNIX shell scripting.
• Understanding business data relationships & gathering statistics.
• PL/SQL Developer Oracle certified Associate OCA 11g certified with 98%
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communication skills

TECHNICAL SKILLS

Languages: Oracle PL/SQL 9i / 10g/11g, Unix,VBA, Linux C,C++

Web Technologies: Core Java

Operating Systems: HP Unix, Linux, MSDOS, Windows 98/2000, XP, Windows NT

Databases: Oracle 9i,Oracle 10 g,Oracle 11g

Middleware: Flexcube, Business objects, Informatica, Crystal Reports, WEBi reports

Tools: Toad, Flexcube, Putty, Telnet, NDM file transfer, Siebel, sql loader, Informatica

PROFESSIONAL EXPERIENCE

Confidential

Senior DI consultant

Responsibilities:

• Participated in Requirements Gathering with the customers.
• Developed end to end solutions for the customers for data integration requirements using Oracle PL/SQL Informatica and unix shell scripting.
• Developed ETL programs using Informatica to implement the business requirements.
• Created custom reports in SAP crystal and web intelligence tools.
• Provided technical development and implementation of design as it relates to the existing applications that correspond with the architecture
• Communicated with business customers to discuss the issues and requirements, Attending various calls with customers and onsite team.
• Worked on ETL techniques using Informatica Power Center 7.x, 8.x, Oracle PL/SQL Stored Procedures to Extract and Transform data from various data sources and Load to the Transactional/Dimensional Databases.
• Was involved in SIT testing and end to end testing of the Callidus Truecomp(commissions) application.
• Prepared and Executed the Test Cases during Unit Testing.
• Supported Testing team, UAT Team & Productions support team.
• Integrated data from Flat files into Oracle tables using Informatica.
• Identified Mapping Bottlenecks and Tuned performance at the source, target and mapping levels. Developed Stored Procedures, Functions and Packages to implement certain business rules.Developed UNIX Shell scripts for validating the files, running stored procedures & Informatica workflows.
• Extensively worked in UNIX Shell Scripting, AWK and file manipulation techniques.
• Have extensively worked in developing ETL programs for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Responsible for writing the technical specification documents and maintaining the documentation.
• Attending various training sessions internally to gather Callidus product knowledge.

Confidential

Senior Database Analyst

Responsibilities:

• Involved in Code Reviews and preparing Unit test cases as was the only DB resource in the team. Also prepared DB scripts for deployment in production & implementation instruction documents for DBAs.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds,Cast collect multiset,used cursor and global temporary tables,in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production using utilities like Explain plan, Trace and tkprof and Hints to improve the execution plan.
• Have created purge scripts based on purge criteria for purging big tables in production and implemented the same with the help of DBA. Also added a job afterwards which will automatically purge the tables based on monthly scheduler
• Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
• Played a pivotal role in the migration of legacy application databases from Oracle 11g to 12c in a planned manner.
• Implement and support code migration into production. Actively involved with DBA for deployment of objects to the production environment and have supported all the deployments.
• Wrote Oracle scheduler jobs and implemented Oracle Advanced Queues.
• Extensively used REF CURSORS to support data transfer between Oracle PL/SQL and Java environments.
• Responsible for writing the technical documents and maintaining the documentation.
• Responsible for creating and developing highly complex applications using Oracle as back-end with expertise in design and development of PL/SQL Packages, Procedures, Functions and Database Triggers using the oracle advanced
• Techniques Bulk Processing, En-queue and De-queue, Collections. Responsible for helping set development standards for database development within PL/SQL.
• Act as a database technical resource, with a high level of technical and analytical expertise in programming languages, data communications and a strong understanding of the business operation/customer.

Confidential

Senior software engineer

Responsibilities:

• Requirement gathering from the BAs & analyzing the data then preparing the technical specification document, development on the basis of that then testing & then implementing the required changes in front end working with the .net developers. Finally after the testers test & UAT sign off, I will include these changes in the monthly release implementation in production using impulse.
• Development including partitioned table, triggers, packages, stored procedures, Data modeling, compression etc
• Performance tuning of partitioned table query, complex report queries and procedures which were taking longer time.
• Migration & testing of SDS application as the existing application will be decommissioned in granite so after developing all scripts and then testing data and doing impact analysis on downstream applications.
• Used optimizer hints and created required indexes to enhance performance.
• Maintaining all the golden rules followed by the business for naming convention used for tables, partitions, procedure name, triggers, variables ets in development
• Have done integration and unit testing on developed code
• Basic knowledge of ETL tools with informatica power center which is used in the project.
• Participating in requirement gathering, preparing estimation, test strategies, test cases and executing them.

Confidential

Senior Team Member

Responsibilities:

• Performance tuning of complex report queries.
• Analyzing the query explain plan and tracing through tkprof output.
• Used optimizer hints and created required indexes to enhance performance.
• Developed Procedures/functions/Packages for complex download reports where the already existing code was in PB so analyzed the PB code also for it and handled it in oracle.
• Query optimization and fine tuning.
• Jasper domain creation
• Created synonyms and provided grants to developers to access tables not available to them
• Created procedure specific to developer requests where they want to insert data in a global temporary table and access that using JRXML.
• Converting the complex query or multi stage query into one simple query using some analytic/sql functions or joins
• Coding complex SQL queries using analytic, aggregate and window functions for checking the data.
• Mentoring team members with analysis of complex requests, fine tuning SQL queries and PL/SQL programs.
• Sql Loader was used to convert the data from the Excel/CSV to oracle tables.
• Analyzing the Data Mismatch issues between the old and the new system
• Load testing and giving access rights for the reports specific to the countries.

Confidential - Boston, MA

Database Analyst

Responsibilities:

• Analyze the business requirement and TAD preparation.
• Standardize tablespaces of tables across the database.
• Development of Archive and purge procedures for archiving historical data by identifying huge tables using PL/SQL and moving data using exchange partition.
• Identify and tune badly performing queries.
• Compressions of huge tables & indexes (using CTAS & normal method) and perform impact analysis based on the performance before and after compression. After completing the compression process, I developed the plan to drop the old table with the new compressed table & move the latest data to the compressed table.
• Analyze dependencies of the objects before any changes to the database.
• Gathered statistics for analyzing the space and performance.
• Tested all the scripts thoroughly in the development environment before moving it to production.
• Checking in the latest & updated scripts in clear case.