• Designed and build an interface that extracts pricing data from Nortel networks web based repository and dynamically generate reports for analysis by Marketing division of Nortel Networks. The abilities for ad-hoc query and keeping track of changes in database are also built into the PRISM datawarehouse.
• Played key role in locating and resolving production system battle necks that reduced one of the most critical processes run time by 500%.
• Automated the PRISM support system to make it easy for the users to run queries.
• Worked with business analysts to develop and implement appropriate business solutions.
• Involved in Database administration of the PRISM database including database authentication, database sizing, performance tuning, logical backup & recovery, creating segments/tablespaces etc.
• Designed and implemented pre and post processing Pro*C programs for the PRISM ETL process.
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers) using Pl/Sql for PRISM on various schemas.
• Created multiple Korn Shell wrappers to automate PRISM benchmarking batch processes to run on cron.
• Trained end users on PRISM architecture and Interface.
• Environment : Oracle 7.3/8.1.6, OEM, Pro*C, Unix Shell Scripts, Pl/Sql 2.2, Sql*Loader, Pvcs, Sql*analyzer, Toad, Clips, C, Sql*Report Writer 2.5, Sql*Forms 4.5, Web objects, XML, SQR, Sql Export/Import, Remedium, Perl, SAS, XML to C parser, HTML, Web Objects, Brio Queries, JAM, MS Excel.

• Designed, developed and supported the membership system which was the backbone for the 24x7 enterprise TIMSS software.
• Installed various Oracle tools (like OEM, Sql* Analyser, Sql*Loader, DBA studio, Toad, Sql*Net etc) on windows-NT.
• Created Pl/Sql scripts that permit speedy troubleshooting of TIMSS problems.
• Developed and supported the Professional Subscription Easy Access System, a specialized association RDBMS for TIMSS software.
• Administered the database by resizing the rollback/temporary segments and tablespaces to handle the high volume of incoming data.
• Designed and Implemented solutions to major infrastructure and system performance issues.
• Performed user requirements analysis and developed data models.
• Developed numerous forms, reports and utilities using Oracle forms 4.5, Pro*C, C, Awk, Sed.
• Wrote several Korn Shell Scripts for auditing TIMSS database.
• Designed and implemented a query builder, which allows a DBA/developer to create, test and save queries through the browser using Cold Fusion.
• Designed and build different stored database packages, procedures, functions and triggers for TIMSS, using pl/sql code.
• Worked as a QA/QC for the TIMSS software.
• Modified various existing Pro*C reports and Pl/Sql code.
• Invloved in the data validation of data loaded into TIMSS tables using Sql*Loader.
• Designed and developed various SQR reports.
• Environment : Oracle, Pro*C, Unix Shell Scripts, Pl/Sql, Sql*Loader, Pvcs, Developer 2000, ColdFusion, Sql*Analyzer, SQR, MS Excel, MS Access, MS Sql Server, Sql Export/Import, Toad, Awk, Sed.

• Designed and developed different reports for TRS using Pro*C and SQR.
• Build several Unix Shell wrappers for Pro*C programs to schedule them on Cron.
• Wrote different C programs for general C library of taxation module.
• Extensively used Pvcs for version control and analyzed the work requests from DOL.
• Extensive interaction with the team members and users.
• Fine-tuned different programs written by other development team members with Sql*analyser, EXPLAIN PLAN, TKPROF etc.
• Wrote different C programs to replace the existing Pl/Sql code for some applications to make the jobs run faster.
• Environment : Oracle, Unix Shell Scripts, Pro*C, C, Pl/Sql, Pvcs, Sql*Analyzer, Sql*Report Writer, Developer 2000, Sql*Menu, Sql*Loader, MS Excel, Sql Export/Import, Awk, Sed, SQR.

• Designed and created a database for EDI audit.
• Designed and coded a number of Shell Scripts to handle the EDI Gentran translator for different EDI transactions.
• Wrote number of Shell Scripts (Korn Shell) to handshake E-Commerce tools like Gentran translator, ESS order management system etc.
• Designed and coded different Scripts to load EDI audit database from the ESS database using Sql*Loader .
• Worked as a backup Unix system administrator for EDI project for three months.
• Designed and created different database objects (Packages, Procedures, Functions) for different EDI transactions at Advantis, Gentran and ESS.
• Extensively interacted with the team members and users.
• Trained end users on systems and applications.
• Involved in the Unix standards committee for code walk thru of other developers programs.
• Wrote technical documentation and help system for EDI auditing.
• Environment :Unix Shell Scripts, Pro*C, C, Oracle, Pl/Sql, Sql*Loader, Awk, Sed, Sql*Analyzer, Oracle CASE tools like Generator and Designer, Gentran, Advantis, ESS.

• Involved as a core member in the design of CATS, a mission critical OLTP and DSS system for Citibank orbital services, during which interacted with most of the users of security services division of Citibank, N.A.
• Designed and developed number of database objects using Pl/Sql 2.2.
• Designed and developed CATS order entry follow up system using the GUI tools VB and FoxPro.
• Developed batch programs in Pro*C and wrote Scripts to run them on Unix Cron Scheduler.
• Designed and developed number of screens using Sql*Forms 3.0.
• Extensively used Sql*Loader for loading data into tables.
• Worked as a Unix system administrator for CATS.
• Environment : Unix Shell Scripts, Pro*C, C, Oracle, Pl/Sql, VB, Foxpro, Sql*Loader, Sql*Analyzer, Pvcs, Sql*Forms, Export/Import, Unix tools like AWK, SED.

• Designed and developed programs to interact with OASIS and BASIS databases of Citibank, Singapore using C, Pro*C, Unix Shell Scripts.
• Wrote different database objects for OCS.
• Designed and performed Oracle benchmarks for achieving optimal database performance for the OLTP system of Citibank.
• Developed batch programs for DSS in Pro*C and Scripts to run them using Cron scheduler.
• Designed and developed number of screens using Sql*Forms.
• Created/Altered the existing custodial VB programs to accommodate the new/additional functionality.
• Wrote different reports and batch programs in Pro*C.
• Extensively used Sql*Loader for loading data into tables.
• Wrote custom support modules for upgrade implementation using Pl/Sql, Unix Shell Scripts and Pro*C.
• Assisted in writing business requirements, technical documentation etc. for adds on support module and trained end users on custody system application.
• Trained staff on Custody business operations of Citibank.
• Played a crucial role in the OCS support cycle.
• Extensively interacted with end users and team members.
• Worked for the Corporate Action and objection modules.
• Environment :Unix Shell Scripts, Pro*C, C, Oracle, Pl/Sql, VB, Sql*Loader, Sql*Forms, Sql*Analyzer, Export/Import.

• Involved in the design of Proofing module, a core module of FMS.
• Involved in the ETL process to map data from multiple operating systems including IBM/DB2, DEC/Oracle, NT/SQL Server and flat files into FMS database.
• Involved in the coding of the mailing functions for Magma, a mail generating system of Citibank, used for their internal purpose.
• Coordinated with the users and team members.
• Involved in the supporting team of FMS.
• Worked for the testing and QA of FMS.
• Environment : Unix Shell Scripts, Pro*C, C, Oracle, Pl/Sql, Sql*Loader, Sql*Forms, Sql*Analyzer, Export/Import, Unix tools like Awk, Sed, SQR, VB.

• Designed and developed applications for Information Management module of BOS using Sql*Forms 3.0.
• Used import/export utilities and Sql*Loader extensively.
• Developed several stored procedures and functions for BOS backup module.
• Used to interact with share brokers to do the changes in the code according to their requirements.
• Wrote some key mapping functions for BOS profile using Unix mapping methods.
• Coded several on-line applications using Sql*Forms and Pl/Sql.
• Performed unit and system testing for different modules.
• Extensively used Korn Shell Scripts for doing manipulations of the flat files, given by the share brokers.
• Wrote Pro*C programs to handshake data with other projects.
• Developed few reports using Sql*Report Writer.
• Played a crucial role in the BOS support team.
• Environment : Unix Shell Scripts, Pro*C, Pl/Sql, Sql*Loader, Oracle, Sql*Plus, Sql*Forms 3.0, VB 4.0, MS Excel, C.

Education

• M.S. Engineering in Electronics and Communication, Birla Institute of Technology, India, 1996.
• B.S. Engineering in Electronics and Communication, Nagarjuna University, India, 1992.
• Certified Member of IETE (Institution of Electronics and Telecommunication Engineers, India).