SUMMARY:

• 10 Years of IT experience in Design, Development, Data Analysis and Implementation of Business Solutions ranging from Small/Medium-size to Enterprise-size organizations. Experience in software applications for Banking and Retail Industry, Movie Industry, Equipment finance, Enterprise Resource Planning and Healthcare industry along with Pretreatment Water information management system and Inventory Management System.
• Expertise in implementing Power Builder Foundation classes and developing complex applications using PowerBuilder, Oracle, Sybase, DB2, MSSqlServer 2000/2005, Powerbuilder Delta, PowerDesigner.
• Excellent SQL, PL/SQL programming skills writing complex SQL queries, Creation in Database Objects like Tables, Views, Packages, Triggers, Stored Procedures, Functions, Cursors Exception handling.
• Excellent conceptual and working knowledge of SAP Business Objects Data Services, SQL Server Integration Services, Informatica, SQL Server Reporting Services, SQL Servers, CICS, Crystal Reports, Embarcadero 7.5.
• I am exposed to all phases of a typical software development life cycle.
• Expertise in developing application using Object Oriented techniques.
• Strongly motivated, self-directed, highly teamwork oriented.
• Ability to develop conversion and system implementation plans.
• Ability to understand functional needs and how systems can support those needs.
• Thorough experience with identification and use of code libraries and open-source forums.
• Excellent interpersonal skills to interact with customers and team members.
• Analyzing bugs and Interacting with Developers and team members in fixing the Errors.

PROFESSIONAL EXPERIENCE:

Sr. Oracle/PL-SQL Consultant

Confidential

Responsibilities:

• Extensively used packages, functions, procedures, triggers.
• Performed all required PowerBuilder programming tasks screen development, transactional updates to the database and develop related Oracle PL/SQL stored procedures, triggers, batch programs scripts.
• Created ad-hoc basis executables to meet the deadlines and deliver the projects on time with development and testing simultaneously,
• Created on the fly production scripts to fix data issue and put claims on hold.
• Designing interfaces with PowerBuilder such as different types of Windows, Menus, Visual Non-Visual User objects Controls applied the same with object oriented functionalities Inheritance, Encapsulations and Polymorphism .
• Involved in application development utilizing the PowerBuilder. Created applied Dynamic data window objects functionalities, user events functions, Data store, Edit Styles, reports, Error handling, Database connection and transaction management, debugging Testing, execute Software Migrations etc.
• Experience integrating third party tools, OCX's or OLE objects into PowerBuilder applications
• Creates application design specification documents from which code will be written. Interfaces with external vendors and customers through crosswalk mapping with different and often complex architecture.
• Ensured code complies with BCBSF architectural and SDLC standards. Writes scripts to run programs.
• Extensively worked with Dynamic SQL, PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.
• Provided scope, sizing and estimates time required to complete code and provide this information to the project manager for input to the project plan.
• Determined impacts and integration points. Also participated in capacity planning with project manager or functional manager.
• Worked closely with system and business analyst to provide the best solution for business requirements.
• Improved performance for certain modules by tuning existing and creating new improved queries.
• Performed Unit Testing and Prepared application for Release to Testing Team. Analyzed defects found in testing and fix any missing component in timely manner.
• Created batch and real time procedures to process pharmacy claims.
• Solved both QA and Production tickets simultaneously for different programs across different schemas at any given point of time.

Environment: Oracle 10g/11g, PowerBuilder 11.5/9.0, ClearCase, Toad, SVN, Ctrl M, Unix, Service Manager, HP Quality Center, Share Point

Sr. PowerBuilder/Oracle/ Sybase Consultant

Confidential

Responsibilities:

• Communicating with the CRM to refine the requirements and prioritizing the requests.
• Delegating the change requirements to the offshore team and coordinating the implementation.
• Develop and implement new or enhanced utility components for the data warehouse
• Design and develop new or enhanced ETL Extract, Transform and Load process between different applications between Warner Brothers and CBS.
• Actively involved with team members to design and developed extract, transformation and data load designs based on well managed and integrated company's data warehouse infrastructure.
• Handling the emergency bug resolution with the onsite team members.
• Strong SQL query, SQL DML and relational database design skills.
• Perform and coordinate data warehouse administration for development and maintenance activities, including performance testing, tuning, and troubleshooting of data warehouse processes.
• Implementing change management procedures practices in the project and support related activities.
• Coordinating with different teams to setup and testing the interfaces with all integrated applications.

Environment: Oracle 10g, Sybase 15, PowerBuilder 11.5, SAP Business Objects Data Services, SQL Server Integration Services, SQL Server Reporting Services, DB Artisan, Windows XP.

Sr. PowerBuilder/Sybase, Oracle Consultant

Confidential

Responsibilities:

• Providing support for production and test environments to ensure that its fully functional.
• Involving with the users for new enhancements and provide Functional specifications, Technical specifications.
• Coordinates with offshore team to provide business requirements and review all changes.
• Interacting with the members of the system infrastructure, quality team, middle tier team and database team.
• Working on different projects simultaneously and provides solutions within time limit.
• Maintains documents in the form of the Production Support resolutions for future references,
• Maintain a strong understanding of the business cycles, transaction timing, and service level requirements of the enterprise.
• Strong problem solving and communication skills.
• Decisive in difficult situations and under pressure.

Environment: PowerBuilder 9.0, Oracle, Sybase, Borland Stat Team, Toad 9.0, Windows XP.

Sr. PowerBuilder/Oracle Consultant

Confidential

Responsibilities:

• Actively involved in create new functionalities, provide production support, creating executables and deployment of executables on different servers and on Citrix Server.
• Involved in migration of database from Oracle 9i to Oracle 10g.
• Optimized the sql scripts and codes for migration to Oracle 10g.
• Involved in migration of application from PowerBuilder 8 to PowerBuilder 11.
• Involved in PFC integration to existing ADE Advanced Development Enhancements architecture.
• Used PFC objects to create base windows like master window, master tab window, parent-child window, modal window, search window etc.
• Using PFC I have developed Excel like Filters, Resize Functionality, User Save Preferences, Enhanced Calendar Features which show movies and holidays on Calendar, Customized right click menu, Add to Favorites, Sort functionality etc.
• Design and develop new windows like Release Master, Distribution Plan Updates, Contact master, Contact Role Mass Change, E-Holoover Suspense Error handling, Contact/Release/Theatre/Circuit prompts etc.
• Exposure to Informatica Developer for Profiling and Data Analysis required.
• Load Informatica Powercenter to build ETL mappings, sessions and workflows.
• Added email functionality with SMTP and MAPI.
• Optimize the existing Stored Procedures, Packages, Functions, Triggers, View and Materialized Views.
• Involved with Business Analyst in requirement gathering and creating functional specifications, Technical specifications.
• Actively involved in user acceptance testing and system integration testing and generate test cases for users.

Environment: PowerBuilder 8/11.2, PFC, MS Visual Source Safe, Oracle 9i/10g, SQL Navigator Toad 9.0, Oracle SQL Plus, UNIX AIX Version 5.3 , Informatica 8, Windows XP.