SUMMARY:

• Over Thirteen (13) years of professional experience in Information Technology in design, development, implementation, maintenance, documentation and administration in various domains like Telecom, Construction, Retail and Investment/Financial industries.
• My technological forte is Client/Server Windows applications on Oracle SQL, PL/SQL, Power Builder and Informatica. Oracle Associate OCA (DBA and Developer Track).
• Extensive practical knowledge in each phase of SDLC.
• Outstanding in preparing Technical documents and process related documents including High level design (HLD), Low Level Design (LLD), Unit test plans (UTP) and documenting results etc.
• Supported, monitored and tuned Informatica ETL processes at all phases.
• Experienced in Developing Oracle Packages, Procedures, and scripts on large databases.
• Oracle Certified Associate OCA (DBA and Developer Track).
• Expertise in writing Functions, Triggers, Query optimization and Performance Tuning.
• Experienced in Developing Oracle Packages, Procedures, and scripts on large databases (Daily partition of 1 GB).
• Extensively worked with developing forms and reports using Oracle Report 6.0/6i.
• Worked on Datastage and ETL tools.
• Experienced in implementing business rules by creating robust mappings, mapplets, and reusable transformations using Informatica PowerCenter.
• Exposure to Dimensional Models using Star Schema and Snow Flake Schema and created Physical and Logical Data Models.
• Experienced in the complete data warehouse development life cycle including design, development, testing, implementation, and support
• Extensively used, very strong experience, highly skilled in using the PowerBuilder object: the Data Window control.
• Experienced using Sybase PowerBuilder (5, 8, 11) features such as PFC, Dynamic data windows, MDI, User Objects, .NET.
• Experienced in using OOPS (Inheritance, Encapsulation, and Polymorphism)
• Extensively worked GUI applications and screens, designed the GUI and coded the GUI. Also involved in project GUI specs, design and prototype.
• Supported JQuery and EXTjs extensively.
• Generated PowerBuilder Reports (8, 11) and Crystal reports.
• Extensively used QUEST Tools (TOAD, Navigator), and SQL*PLUS.
• Strong Knowledge on Software Models, Software Analysis, Design, Requirements and Implementation.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.

TECHNICAL SKILLS:

Database: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g.

Operating Systems: Windows 95/98/2000/XP and NT

.Technologies: Oracle, Power Builder 5, 8, 11, 12ETL Informatica PowerCenter 9.6.1/8.x/7.x Tools and Utilities PL/SQL, SQL*Plus, SQL * Loader, Stored Procedures, Triggers, Oracle Forms and Reports 6i, UNIX Shell Scripting, Toad, Putty, MS - VSS, Crystal Reports 9.0,.NET,Jquery,EXTjs,Quality Center, SERENA Dimensions, Autosys, WCC, ACC.

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, OH

Technical Lead / Senior Developer

Responsibilities:

• Leading Team strength of 9 members (7 offshore and 2 onshore). Scheduling calls, explaining Business requests and assigning tasks and clearing doubts while coding and following up until delivery.
• Preparing the Impact Analysis document and High-level design for the requirements
• Participate in scrum calls, requirement calls, point and sprint stories for a particular release.
• Plan and assess velocity of team and 5 apps for regular quarterly release and monthly point releases.
• Developing code/software as per the approved design documents using Power Builder 11 and Oracle 10g.
• Translation of Business processes into through ETL Mappings for the enchantment of the project.
• Parsed high-level design specification to ETL coding/Mappings.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Wrote Oracle Stored Procedures, functions, Triggers using optimising techniques to reduce load on database.
• Responsible for performance tuning of PL/SQL packages and SQL queries.
• Worked closely with DBA’s if any issues in PRODUCTION.
• Developed and maintained complex mappings.
• Extensively used hints like PARALLEL, NO USE MERGE, ROWID, FULL etc.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Use Data windows where ever necessary and features such as PFC, Dynamic data windows, MDI and User Objects.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Always used explain plan to check the cost and load of the newly introduced queries.
• Extensively used SQL Loader for loading tables.
• Provided numerous adhoc revenue related reports and yearly reports to clients.
• Performing Configuration Management by Checking-in the latest code in source control tool ~ Serena Dimensions.
• Setting up environment for testing by creating batch files to launch application and automatically point them to corresponding test environment.
• Carrying out Quality Assurance activities for all deliverables, so that code and test results are delivered without any defect.
• Tracking defects in CA Agile, update defect notes, descriptions, Estimated Fix dates and update it to right status at each level like RFT, Reject etc.
• Work on Production tickets and resolving them.
• Making sure the code backward compatibility so that the changes can be rolled back with ease if needed.
• Support Test teams clarifying on invalid defects
• Provide Tier 2 Prod support.

Confidential, Richfield, OH

Database Developer

Responsibilities:

• Involved in complex product design and implementation activities which may require extensive research and data analysis.
• Design, implementation and maintenance of complex data publishing systems.
• Performs complex bug verification.
• Responsible for Release testing and support for assigned products.
• Collaborated with Business analysts for requirements gathering, analysis, ETL design and development for extracting data from the heterogeneous source systems.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Research defects and develops solutions to the problems; conducts unit testing and integration testing for functionality and performance.
• Work with design leads and DBAs during design, construction, testing and implementation of publishing services.
• Research and understand the business and technical requirements for a publishing process/system, including target environment and performance criteria.
• Suggest technical approaches to management on projects
• Performing data analysis and then writing functions, procedures, and packages using Oracle PL/SQL.
• Experience on working on Oracle Virtual Box
• Learn Snap-on internal tools like JET, LET, Postgress, Subsetup, SQLSERVER, Prosynch and work on enhancements in Agile methodologies.

Confidential, Boston, MA

Database Developer

Responsibilities:

• Single Point of contact for 11g Database Upgrade.
• Fine Tune Queries in Scripts, Procedures and batches in Oracle 10g and 11g.
• Applied Explain Plan, gather/collecting statistics etc techniques to improve performance of several Autosys jobs.
• Identify the data or code issue and provide quick solutions.
• Created several nightly scripts using JIL’s, Shell scripts, anonymous blocks and packages.
• Making sure the code backward compatibility so that the changes can be rolled back with ease if needed.
• Active participation in decommissioning Legacy applications.
• Work closely with QA and engineering teams to help them test and deploy database bug fixes and enhancements.
• Work closely with other shared services teams including DBA, Market Data Services, UNIX, database engineering and production services to maintain the database environment and resolve issues.
• Use Informatica 9.1 to monitor session logs and jobs.
• Ability to communicate effectively with various stakeholders within AAT as well as partner groups within FIMT to help resolving the problems in quick and timely manner.
• Monitoring nightly and daily batch jobs.
• Perform development tasks including creating Oracle stored procedures, functions, triggers and adhoc scripts.
• Create Autosys Job Information Language scripts
• Design UNIX shell scripts and new utilities as needed in support of projects
• Escalate issues appropriately to make business aware as and when established SLAs cannot be met.
• As a member of the Database Operations team, work closely with an offshore operations team in India.
• Expertise in data analysis and problem resolution.
• new team members in all the above technologies.
• Performing Installs in several teams like FPP, QPM and PM.

Confidential, Dublin, OH

Technical Lead / Sr. Oracle Developer

Responsibilities:

• Coordinating with clients on resource related issues, new intakes and any resource cuts.
• Collecting business process requirements and documentation of requirements
• Consolidating requirements from Business and Analysts and maintaining them in Caliber.
• Leading Team strength of 17 members (12 offshore and 5 onshore). Scheduling calls, explaining Business requests and assigning tasks and clearing doubts while coding and following up until delivery.
• Preparing the Impact Analysis document and High-level design for the requirements
• Preparing High level and Low Level Design documents using SDP (Software Development Plan)
• Developing code/software as per the approved design documents using Power Builder 11 and Oracle 10g.
• Wrote Oracle Stored Procedures, functions, Triggers using optimising techniques to reduce load on database.
• Responsible for performance tuning of PL/SQL packages and SQL queries.
• Worked closely with DBA’s if any issues in PRODUCTION.
• Developed and maintained complex Informatica mappings.
• Extensively used hints like PARALLEL, NO USE MERGE, ROWID, FULL etc.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Use Data windows where ever necessary and features such as PFC, Dynamic data windows, MDI and User Objects.
• Perform unit testing at various levels of the ETL.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Function as backup on-call programmer for nightly ETL load.
• Informatica administration functions on Performance Tuning.
• Always used explain plan to check the cost and load of the newly introduced queries.
• Extensively used SQL Loader for loading tables.
• Provided numerous adhoc revenue related reports and yearly reports to clients.
• Performing Configuration Management by Checking-in the latest code in source control tool ~ Serena Dimensions.
• Strong understanding on Normalisation/ Data modelling
• Worked on Upgrading Oracle 10g to 11g.
• Review of code and relevant documentation like HLD, LLD, Test Plan documentations.
• Setting up environment for testing by creating batch files to launch application and automatically point them to corresponding test environment.
• Carrying out integrated testing within the application and also in between the applications using Citrix Client Server.
• Carrying out Quality Assurance activities for all deliverables, so that code and test results are delivered without any defect.
• Tracking defects in Quality Center, update defect notes, descriptions, Estimated Fix dates and update it to right status at each level like RFT, Reject etc.
• Work on Production tickets and resolving them.
• Making sure the code backward compatibility so that the changes can be rolled back with ease if needed.
• Perform code walk through to check on the code standards and check for the completeness of the code.

Confidential, Dublin, OH

Sr. Oracle Developer

Responsibilities:

• Coordinating with clients on resource related issues, new intakes and any resource cuts.
• Collecting business process requirements and documentation of requirements
• Consolidating requirements from Business and Analysts and maintaining them in Caliber.
• Leading Team strength of 4 members (3 offshore and 1 onshore).
• Preparing High level and Low Level Design documents and maintain them in Qshare.
• Developing code as per the approved design documents using Oracle 10g.
• Wrote Oracle Stored Procedures, functions, Triggers.
• Used hints extensively
• Migrated Database from 8i to 9i for several applications within Ordering.
• Working on Performance tuning in each phase in development.
• Extensively used BULK COLLECT feature to load cursor values and reduce overall script run time.
• Expertise in developing forms using Oracle Forms 6.0/6i.
• Responsible for creating and managing new reports using Oracle reports 6i.
• Supported projects and enhanced .NET application - Swoes.
• Setting up environment for testing using batch jobs.
• Created Shell scripts to generate few reports sent to Directors and Managers.
• Extensively worked on JQuery and Extjs while building interactive web apps.
• Review of code and relevant documentation following Software development plan.
• Unit test plan executions were performed on the entire team’s performance and tasks.
• Documentation of Test Results and uploading it to Qshare.
• Communicating with the client on a day to day basis.
• Performing Configuration Management using PVCS - Serena Dimensions.
• Carrying out Quality Assurance activities for all deliverables, so that code and test results are delivered without any defect/Minimal defects.
• Working on Production tickets and resolving them on time.

Confidential

Sr. Oracle Developer

Responsibilities:

• Single point of contact for this project.
• Understanding Requirements from existing application teams prepare new requirements for new application and maintain them in Qshare.
• Requirement Validation using client specific tool and getting confirmed by Client Lead.
• Worked on Data mapping for conversion from legacy applications.
• Writing Functional specifications for the approved requirements
• Writing Technical Specifications for the approved Reports.
• Performing Gap Analysis between existing and new requirements.
• Writing Stored Procedures to generate reports using Oracle 8i.
• Tuning the existing queries.
• Re-writing / performance tuning existing packages and procedures.
• Extensively used SQL Loader and Toad.
• Created PL/SQL functions, procedures and triggers on Oracle 8i.
• Designing and developing Reports using Crystal Reports 11.0.
• Extensive package debugging and customizing
• Developed Reports for the user interface; a data load using PL/SQL and SQL*Loader; cron jobs calling UNIX scripts.
• Tuned many long running Oracle concurrent programs by enabling trace, checking explain and execution plans.

Confidential

Oracle Developer

Responsibilities:

• Worked closely with senior DBA to understand the business and technical requirements.
• Performed complex SQL query tuning, index reorganization on Oracle 8i.
• Involved in documenting the entire system architecture and data flow.
• Requirements gathering and feasibility study.
• Part of IT team for entire TTSL Prepaid team.
• Design and development monthly revenue Journals for all prepaid customers of Tata teleservices all over India state wise, circle wise, sales unit wise, product wise to tally ledger balances.
• Tuned these Journal scripts from days to 2.5 hrs per cycle.
• Automated all these Journal scripts and these journals are sent as reports every month.
• Worked on TTSL Walky switch fix Project where all customers are tied to a single switch as per TRAI regulations.
• Developed and automated huge number of adhoc reports for clients.
• Client interaction for future needs and Implementing pre-emptive measures
• Train and guide team members.
• Gained End to End Prepaid OSS/BSS Knowledge
• Received client appreciation for Designing and Developing AIS within a short span of time
• Proposed and Implemented system critical solutions
• Took the responsibility of PPS development and completed the same within the committed timelines by Leading PPS development.
• Got appreciations from director appreciations for proactive proposals on automating and generating shell scripts.
• Extensively used BULK COLLECT feature to load cursor values and reduce overall script run time.
• Got s on SQL ANSI, PL/SQL and C from world’s largest program Brain bench.

Confidential

.NET and SQL Server Developer

Responsibilities:

• Design and Development of GUI Forms in Visual Basic.NET
• Worked extensively on generating crystal reports and fixing any issues and making any changes client requests.
• Developed a complex screen consists of eight grids with three levels of hierarchy.
• Performed Configuration Management using - Visual source safe.
• Performed unit Testing and Debugging the code.
• Fixing of Bugs of Other Screens during Development phase.
• Writing Test Cases for unit test.
• Involved in business layer code for the developed screen.
• Establishing DB connection from SQL Server2000.
• Maintaining relationship among three tiers - Presentation layer, Business Layer and DB layer.
• The objective of the Revenue Model is to calculate Revenue for Forecasts and maintained
• Involved in fixing all types of bugs including high severity issues.
• Tuning queries in DB layer - SQL Server 2000.