SUMMARY:

• Highly motivated software professional with 15+ Yrs. of strong experiences in Design, Development, System Test, Production execution and Support of Software Projects in IT Industry.
• Have been involved in all phases of SDLC (requirement analysis, high and detail level design, coding, unit, integration, regression, user acceptance testing and deployment) for projects in Financial ( Confidential, Confidential, Confidential ) & Healthcare ( Confidential, Confidential ) domain.
• Have worked with Confidential Banking Products - Branch Banking Software Confidential & Confidential Core Banking Software Solution (BaNCS) for implementation at Confidential .
• Have extensive experience in production support projects.
• Extensive exposure in UNIX, PL/SQL, Oracle Pre-compilers and Java in complex environment.
• Exposure in development and maintenance of applications using Actuate 7/8/9 Business intelligence Suites, Oracle 9i/11g, Callidus TrueComp 3.x/5.x.
• Experience in using Oracle tools such as Toad and Oracle SQL Developer.
• Exposure in Application System Maintenance/Administration on UNIX server.
• Involved in cleaning and maintaining migrated data.
• Experienced in Tuning Queries for better performance with a large volume of data.
• Experience in using Explain Plan, SQL tuning, a collection of statistics and creation of indexes for database access and indexing the required columns.
• Experience with procedures and coding PL/SQL blocks.
• Quick learner with the ability to master new concepts and applications.
• Excellent analytical, problem-solving, communication and interpersonal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Lifecycle. Experience in utilizing Business Objects.
• Extensively worked with Oracle Utilities like Imports / Exports, SQL * Loader- Worked with very large databases - Extensively used UNIX shell Scripts for automating batch programs.
• Focused and hard-working, able to troubleshoot complex problems. Strong Business and Application Analytical skills.
• Effective team player and a motivating leader with innovative & adaptive communication skills.
• Possess a track record of success in meeting project milestones and developing a very good relationship with the client and other groups.

PROJECTS EXPERIENCE:

Confidential, Charlotte, NC

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Working directly with & reporting to Customers to understand the requirements.
• Extensively involved in using PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, Oracle Reports for data processing.
• Within the iHUB space, we are upgrading the Informatica servers, and upgrading the Oracle 11g to 12c database. Defining new Business Requirements for new projects
• Working on performance tuning strategies for the database objects across various databases.
• Database Analysis of the Oracle and SQL Server loan data for testing code.
• Changes/enhancements.

Environment: Oracle PL/SQL, SQL *Plus, Informatica, Teradata, Python, OFSAA FSDF, Exadata, OBIEE, Ab Initio

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Involved in data Maintenance and Support which uses Oracle 9i database, SQL, PL/SQL, SQL* Loader, Shell Scripts, Business Objects in Windows NT and Unix environment.
• Extensively involved in using PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, Oracle Reports10g and views for processing data and needed business rules.
• Code optimization/Performance Tuning - Involved in performance management of various PL-SQL reports & queries.
• Developing various reports using Oracle Pl/SQL. Also tuned the reports queries to help save redundant database queries and thus save report execution time.
• Working directly with & reporting to Customers to understand the requirements. Production support for Allocations Processing system.
• Developed a database compare tool to negate manual intervention for database object comparison during data copy to data warehouse/reporting environment. It provides a list and DDLs of Tables, Indexes, and Views which are different among the source and target systems, thus saving considerable time.
• Implemented table cleanup script to purge old table data to secure additional table space.
• Worked on Informatica & Abinitio to execute the workflows, monitoring errors, logs. Also, worked closely with the Development Team to fix the issues, and proposed resigned solutions.
• Implemented various process improvements within the team to enhance the customer-vendor relationship.
• Was involved in executing and monitoring daily process feeds in Informatica and analyze Informatica workflow logs for issues, also extensively involved in code debugging.
• Extensive experience with production support and ticket management.
• Good experience in using Golden Gate to sync up data among various Geographies while supporting the KYC project.
• Exposure to HIVE based data warehouse platform maintained for end-user experience.
• Used TOAD and Oracle PL/SQL developer as GUI interfaces.

Environment: PL/SQL, UNIX, Oracle, AutoSys, Informatica, AB Initio, Python, Big Data, Hive, Java, Golden Gate.

Confidential

Associate Consultant

Responsibilities:

• Responsibilities include analyzing, troubleshooting, resolving and documenting reports. Understand existing system business logic, perform enhancement and impact analysis of the applications.
• Documented all the requirements received from the business team, optimized for effective solutions. Design, Development, and Enhancements of various types of reports.
• Developed and maintained in-house Data Warehouse environment. The environment was developed using Oracle PL/SQL.
• Development/enhancement of Oracle PL/SQL programs for creating Tables, Views, Sequences, Database triggers, Cursors, Stored Procedures and Functions, Exception Handling and Indexing, Optimization and Tuning of Procedures, SQL Queries to improve performance.
• Creation and execution of the implementation plan, deployment of executables to servers.
• Development/enhancement of UNIX shell scripts. Troubleshoot the Production issues.
• Work directly and reporting to Customers to understand their requirements.
• Deployment of the reports with proper security & accessibility.
• Developed and maintained sales incentive reports in actuating.
• Automated sever-volumes process using Information Delivery APIs.
• The automated process would alert the system administrator as soon as a server volume went off-line. The process saved about 8Hrs of turnaround time in a month.
• Used MySQL workbench to make a connection with MariaDB to analyze/monitor the database.
• Code optimization - Involved in performance management of actuating reports/PL-SQL queries.
• Work closely with upper management and consultants onshore and offshore of various teams in development, maintenance, QA & Testing and production support of compensation system.
• Coordinate with business analyst, business client and various functional teams across the application to gather requirements and provide best solution approach.
• Time & Cost estimation of work/change requests, work allocation to team members (offshore and onshore), track/review progress.
• Developed application upgrades for three Annual Release and multiple Quarterly Release. This development involved a compensation application upgrade, report development, Oracle stored procedures/Functions development etc.
• Create complex data models and process flow diagrams. Create and maintain high-level design (HLD), detailed design (DD), Unit test (UTP) documentations & business-process documentation based on the requirements gathered from business analysts & business user, using industry-standard methodology.
• Actively organize team and business meetings, mentor resources, and participate in resource hiring process.
• Used TOAD to review explain plans, long-running operations and assist with performance tuning of queries.

Environment: PL/SQL, Java, AIX-UNIX, Oracle 9i database, MySQL/MariaDB, Actuate 9.0, Callidus-TrueComp

Confidential, Philadelphia, PA

Responsibilities:

• Involved in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications.
• Contributed towards creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.
• Did Gap Analysis & Impact analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
• Migrated legacy C++ based Requester APIs to Java-based IDAPI environment using SOAP on Solaris environment, resulting in system independence and resource savings.
• Automated all the manual Oracle SQL scripts-based reports using Java. Developed UNIX scripts to execute the Java programs and scheduled the UNIX scripts on Tivoli Workload Scheduler. This resulted in saving of 6-8 Hrs. of manual intervention every month.
• Developed and deployed driver reports for automating the execution of multiple reports for various customers. This driver report proved to be very useful in a customer reporting environment as it automated the entire report generation process of all the customers who get many reports on a scheduled basis, namely weekly, monthly or quarterly. Suitable privileges for the individual customer folders were also handled to ensure privacy.
• Performed performance tuning of the report queries to help save redundant database queries and thus save report execution time.
• Following the Coding Standards for e-Report Designer Professional, XSLT (eSpreadsheet) and Stored Procedure as per the organization standards. Development & Modification of Queries and Stored Procedures in Oracle.
• Deployment and scheduling the Objects to the iServer through Management Console. Unit & Integration testing. Involved in making new releases of the application.
• Worked as the team leader of the offshore team, where the responsibilities include distributing tasks among the team members, knowledge transitioning and assisting them in maintaining the development/delivery standards. Prepared documents to conduct User Acceptance Testing.
• Responsibilities include analyzing, reproducing and fixing the bugs.

Environment: SUN SOLARIS, Oracle 9i database, PL/SQL, Java, Actuate-IDAPIs

Confidential

Responsibilities:

• Implemented and provided enhancements such as multiple accounts editor, mainstreaming for Inward Clearing process to meet client requirement. This helped save considerable time on the clearing process which is a strictly time-bound activity.
• Created and implemented the IBGA (Inter-Branch Clearing Account) module and related reports. Developed reports and flat file generation programs specific to the client requirements. Created UNIX scripts to automate the flat file dispatch process to various processing centers.
• Involved in designing and implementation of transfer batch for salary, pension, and ECS posting to reduce the load on existing inward clearing process. The new system provided the customer with more control over the process.

Environment: FNS-BANCS, IBM-AIX, Oracle 9I database, PL/SQL, PRO*C, MF COBOL

Confidential

Responsibilities:

• Involved in requirement gathering & project Analysis. Development, Coding, Testing (integration, functional and performance) and Debugging.
• Provided Banking/Technical support to various branches of the banks. Developed & maintained custom reports.
• Testing (integration, functional and performance). Deployment at the client site. Employee training.

Environment: Pl/SQL, PRO*C, SCO-Unix, Oracle 7 database, Forms 3.0.