Professional Snapshot

• A dynamic professional with nearly 13 years of extensive experience in Software Development Life Cycle and Database Administration.
• Experience as Senior PowerBuilder Developer / Data Analyst.
• Expertise in handling SDLC projects within the time & cost parameters.
• Proficient in database administration involving installation, configuration, tuning and migration of databases along with database design and management.
• Experience in the software testing of applications including client / sever and web enabled applications.
• Adept in end-to-end development of software products from requirement analysis to system study, designing, coding, testing, de- bugging, documentation and implementation.
• In depth knowledge and experience in client/server programming using Power builder with oracle database.
• Good Knowledge and experience in developing applications using Power builder Foundation Class Framework
• Adept in designing logical and physical data models using HOW & Power designer.
• Possess in depth knowledge in application development, data modelling, database design and basic data warehousing. Have experience in handling basic database administration.
• Good Domain knowledge in FOREX Treasury & Pharmaceuticals manufacturing.
• Proficient in developing stored procedures, Functions, Packages and DB Triggers
• Conversant with OEM (Oracle Enterprise Manager), SQL*Net, SQL* Loader, SQL Navigator, TOAD, Export & Import.
• Work exposure on Cold Backup, Hot backup and Recovery. Have a decent Knowledge in RMAN, RAC & Data Guard.
• An effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organizational abilities.

Training: Attended training in Oracle 9i & Sun Java 2.0 Programming.

Areas of Expertise

TECHNICAL

Oracle : Database creation and maintenance, Performance Tuning using various utilities, backup
and recovery
atabases : Oracle (7.x, 8.0.x, 8i, 9i, 10g), Sybase 11.0, Ms SQL Server, FoxPro & Dbase
Hardware : IBM PC IBM RS 6000Compatible & Sun Solaris
OS & Networks: Solaris 11.0, Sco-Unix, Windows NT, Windows XP/ 95 & MS-DOS
Languages : PL/SQL, PowerBuilder (6.0, 6.5, 7.0, 9.0), C, Java & SQLJ
Software : SQL*PLUS, Power Designer, HOW, MS Office & Case Tools

FUNCTIONAL

Software Development Life Cycle (SDLC) Management

• Interacting with the users for system study, requirements gathering, analysis, implementation and testing of the system. Structural designing & coding of solution for developing new applications.
• Handling software development systems in the organization and getting involved in the design and development of various projects.
• Participating in the complete range of project activities, starting from conceptualization, testing and maintenance of the project.

Software Programming

• Interacting with the client for system study, requirements gathering, analysis and scoping.
• Process setup and monitoring for the development. Reviewing code, debugging and troubleshooting the application.
• Managing smooth implementation and testing of the application at client location.

Database Administration

• Managing database administration related functions involving in installation, configuration, up grading and patching of Oracle server software and hardware.
• Handling disaster recovery management. Database / SQL tuning, performance monitoring and troubleshooting.
• Resolving database start up problems and database re-organisation.
• Working with materialised views & database links.
• Managing Tablespaces & Datafiles.
• Controlling & monitoring user access to the database.
• Using export/import utilities for data export/import to a central repository in the organisation.
• Maintaining availability of database by designing backup and recovery strategies.
• Handling database administration related functions assisting installation and configuration of Oracle server software and hardware.
• Administering Recovery, SQL Loader and user security systems.
• Supporting in designing backup strategy & ensuring scheduled / unscheduled backups as per the backup plan.
• Assisting in Database / SQL tuning, performance monitoring and troubleshooting.
• Controlling migration of programs, database changes, reference data changes and menu changes through the development life cycle.

Team Management

• Directing, leading and motivating workforce; imparting continuous on job training for accomplishing greater operational effectiveness/ efficiency.
• Working on succession planning of the workforce, rendering technical guidance to the staff, shift management activities, appraising the member's performance & providing feedback.
• Resolving interpersonal issues & working towards a harmonious work environment.

Work Experience

Confidential, USAAug\'09 - Till Date
Client:Confidential, NYDuration: Current
Role:Senior PowerBuilder Developer / Data Analyst
Environment:Hp-Unix, Windows XP, Power Builder 6.5/9.0, Sybase 12.5.3, Oracle 9.2.0.4.0/10g, Sqlplus,
iSqlplus, PL/Sql, Sql Loader & Rapid SQL
Accountabilities

• Studying the impact of conversion of current application developed using PFC Framework in PowerBuilder to JAVA.
• Analysing and fixing flaws if any in the current application which tracks the bottling service schedule.
• Studying the impact analysis due to application enhancement and data impact analysis due to changing business requirements. Ensuring the implementation of core logic using procedures & triggers at database level.
• Validating and manipulating data to ensure data integrity.
• Handling data process and output generation using Unix Shell Script.
• Managing Ad Hoc querying and reporting strong PL/SQL (Procedures, Functions and Packages), SQL, SQL*Plus (DML, DDL) & SQL*Loader.
• Performing test stored procedures for various inputs and boundary values to be released into production. Presenting unit testing of procedures.
• Supervising troubleshoot complex SQL queries for fetching multiple data sets from schema tables. Working on performance problems such as response times with queries in application development.
• Enhancing the data handling process and reports along with ETL team.
• Providing database support to application developers on the project team.
• Handling data related issues and performance improvement.
• Working with team members to maintain a consistent environment in development and QA.
• Report generation as per User requirements.

Confidential, Chicago, USA Oct'06 - Apr'09

Client : Confidential, NY Duration: Apr'07 - Jan'09
Role : Senior PowerBuilder Developer / Data Analyst
Environment : Hp-Unix, Windows XP, Power Builder 6.5/9.0, Sybase 12.5.3, Oracle 9.2.0.4.0/10g, Sqlplus,
iSqlplus, PL/Sql, Sql Loader & Rapid SQL

Accountabilities

• Studying the impact of conversion of current application developed using PFC Framework in PowerBuilder to JAVA.
• Analysing and fixing flaws if any in the current application which tracks the bottling service schedule.
• Studying the impact analysis due to application enhancement and data impact analysis due to changing business requirements. Ensuring the implementation of core logic using procedures & triggers at database level.
• Validating and manipulating data to ensure data integrity.
• Handling data process and output generation using Unix Shell Script.
• Managing Ad Hoc querying and reporting strong PL/SQL (Procedures, Functions and Packages), SQL, SQL*Plus (DML, DDL) & SQL*Loader.
• Performing test stored procedures for various inputs and boundary values to be released into production. Presenting unit testing of procedures.
• Supervising troubleshoot complex SQL queries for fetching multiple data sets from schema tables. Working on performance problems such as response times with queries in application development.
• Enhancing the data handling process and reports along with ETL team.
• Providing database support to application developers on the project team.
• Handling data related issues and performance improvement.
• Working with team members to maintain a consistent environment in development and QA.
• Report generation as per User requirements.

Client : Confidential, Milwaukee, Wisconsin

Duration: Dec'06-Jan'07
Role : Senior PowerBuilder Developer
Environment : AIX, Windows XP, Power Builder 7.0.3, Sybase 11.0, Oracle 9.2.0.6.0/10g, Sqlplus, iSqlplus,
PL/Sql, Sql Loader, Erwin 4.1.4, C, Entera (Middleware), Informatica 1.3, Nxtera 5.5, Unicentre,
VisionControl, StarTeam and VBA

Accountabilities

• Gathering user requirement and performing gap study.
• Conducting extensive application programming using PowerBuilder wrapped with C, Entera and UNIX shell scripting layers. Version Management using Star Team and PVCS.
• Operating high level analysis to study the impact of redesigning the existing application software.
• Optimising SQL queries using tools like: Unicenter's Sqlstation.
• Managing microsoft excel templates using VBA programming.

Confidential, Mumbai Jun'02-Nov'05

Clients : Confidential, Tanzania
Role : Team Lead / Senior Software Executive
Environment : Sun Solaris, Windows NT/XP, Power Builder 6.5/7.0/9.0, Sybase 11.0, Oracle 9i/10g, Oracle
Partitioning, Oracle Replication, Sqlplus, iSqlplus, PL/Sql, Sql Loader, Toad 7.6, Erwin 4.1 &
RMAN

Accountabilities

• Gathering user requirement and performing gap study.
• Handling application development and basic database administration through out all the phases of project.
• Developing applications using PFC Framework.
• Managing application version control using PVCS and other 3rd party tools and fix programming errors and debugging.
• Designing the capacity of the database server as per the application requirement. Also hardware description language using low level and high level design. Organising the data efficiently using normalisation process.
• Creating database and migrate databases to new versions. Transferring data from one database to another.
• Operating trouble shooting of Oracle and Application Errors. Re-organising the database structure and indexes for efficient management of database.
• Preparing and implementing back up strategies.
• Monitoring the database, tune for better performance.
• Performing creation of users and assigning the access level, dropping the Users, creating the user roles & profiles, enabling and disabling of access rights to the users.
• Presenting hot backup, cold backup and incremental backup as part of online transaction processing.
• Managing data using export and import tool.
• Deciding upon processes to be pushed to server level and the processes to be handled at client level.
• Uploading data from third party resources like: Excel Files & CSV Files.
• Designing using tools ER Diagram & Power Designer.

Confidential, Mumbai Sep'01-May'02

Client : Confidential, Mumbai, India
Role : Application Developer
Environment : Sun Solaris, Windows 2000, Oracle 8i, Oracle Partitioning, Oracle Replication, Hot Standby,
Sqlplus, iSqlplus, PL/Sql, Sql Loader, PowerBuilder 6.x, Toad 7.0 & HOW

Accountabilities

• Handling business analysis and requirements gathering.
• Managing all the phases of application development and basic database administration through out project implementation. Establishing database relation using ODBC and Native drivers.
• Developing PL/SQL programs, fine tune and improving the performance of the database.

Confidential, Mumbai Jun'01-Sep'01

Client : Confidential, Mumbai, India
Role : Business Analyst
Environment : Sun Solaris, Windows 2000, Oracle Partitioning, Oracle Replication, Sqlplus, iSqlplus, PL/Sql,
PowerBuilder & HOW

Accountabilities

• Handling business analysis and requirements gathering.
• Designing capacity of the database server as per the application requirement.
• Preparing low level and high level designing.
• Developing the database as per normalisation.
• Establishing database relation using ODBC and Native drivers.

Confidential, Mumbai May'97-Jun'01

Client : Confidential, Mumbai
Role : Application Developer
Environment : Power Builder 6.x, Windows NT, UNIX, Sybase 11.x & How Case Tool

Accountabilities

• Handling business analysis and requirements gathering.
• Participating in all stages of the development life cycle including requirement analysis, design, development and implementation of the system using PFC.
• Performing in application development and basic data administration tasks like: Export, Import and Session Management through out all phases of project implementation
• Creating procedures as per the application requirement for handling the process at server level. Also triggers for controlling the data movement and monitoring the un-authorised access of the data and also for audit purposes.
• Conducting tuning of SQL and PL/SQL scripts.

Confidential, Coimbatore Aug'96-Apr'97

Role : Database Developer
Environment : UNIX, C, Oracle 7.x, FoxPro, Sqlplus & PL/Sql

Accountabilities

• Handling application development.
• Developing PL/SQL programs & Basic UNIX Shell Scripting.
• Creating procedures for handling the process at server level and Triggers to control and monitor data movement.

Confidential, Coimbatore Nov'95-Jul'96

Role : IT Engineer

Accountabilities

• Performing system administrative tasks.
• Handling basic office tasks using Microsoft Excel with macros, merging of data using Microsoft word and managing data using Microsoft access.

Academia

• 2 Year Higher Diploma in Software Engineering
• B.Sc. (Mathematics)