SUMMARY

• Over 9 years of hands on experience in the software industry with the know-how of the
• complete product cycle through requirements, design, development, testing,
• documentation and delivery.
• Extensive knowledge of the telecom domain and business processes.
• Experience in writing Packages, Stored Procedures, Functions, and Database Triggers using SQL and PL/SQL in oracle.
• Worked on the data and functional modeling phases of the database design, by defining the data entities and their attributes, classifying the relationships among the objects and drafting the general data entity hierarchy. Implemented the business rules that govern the data integrity using Indexes, Stored Procedures and Triggers.
• Expertise in using Oracle 9i/10g database and PL/SQL programming to develop stored procedures, packages and advanced features like Function Overloading, Dynamic SQL, Query Optimizer, Nested Loops.
• Experienced in tuning of complex SQL statements using oracle Hints, Explain plans and Trace Sessions and in partitioning of tables and indexes.
• Experienced in performance tuning using Explain plan .
• Extensively used Oracle Collections and Bulk techniques.
• Strong programming and debugging skills in PL/SQL, SQL, Pro C, UNIX Shell Scripting, Perl Scripting.
• Experience with the design, management and maintenance of complex SQL and Oracle Server
• Databases.
• Development experience with Java, C, C .
• Good knowledge of C programming especially for Oracle Pro C .
• Experience with tools such as PL/SQL Developer, TOAD, ERWIN.
• Experience in Migration and Data Conversion
• Excellent Analytical, communication and interpersonal skills, with the ability to manage
• Responsibilities individually or as part of a team environment
• Ability to quickly learn programming languages and other applications/software.
• Ability to work in fast paced environment.
• Have worked in both development and maintenance projects.
• Brain Bench Certified in PL/SQL, Java, UNIX, C/C .

TECHNICAL SKILLS

Operating Systems : UNIX, Solaris 9.0,Windows 98/NT/2000, MS-DOS

Languages : PL/SQL, SQL, C, C , core Java, Plex-C, ASA Ericsson Proprietary

Databases/RDBMS : Oracle 10g.9i.8i, Informatica Powercenter 7.1

Scripting Languages : Java Script, Unix Shell Programming, Tcl Tk

Web Related : HTML,XML

Web Servers : Weblogic 7.1

Concepts :

• Mobile Communications, GSM, COM,
• Telecom fundamentals, Switch Technology,
• Socket programming, Interprocess Communication

Tools : Rational Clear Quest, ClearCase 6.0, VSS,PL/SQL Developer, Toad

PVCS, CVS, PureCov, Purify, Eclipse

Experience :

Confidential

Data Analyst Developer

Responsibilities:

• Involved in requirement gathering, functional specifications and also frequent interaction with end users.
• Key Member in designing of the architecture of the LOVN application
• Created business logic in PL/SQL Stored procedures.
• Used ERWIN as the data model tool to design Logical and Physical data, Objects define relationships, implement business rules as constraints for normalization / de-normalization of entities.
• Provided technical training to Oracle users.
• Created and modified Oracle Schema objects like Tables, Indexes.
• Worked on creating interfaces between other systems using PL/SQL procs and created load programs to load data from flat files with necessary business validations using Pro C.
• Used Materialized Views for query rewrite for reporting, and Execute immediate to execute dynamic SQL.
• Used Bulk collect, Forall to process large volume of data
• Generated Triggers for data integrity, Created views to resolve complex queries.
• Designed/ created Oracle database objects, Roles/ Privileges and schemas.
• Used SQL Loader to load data from CSV files to Oracle database.
• Wrote PL/SQL procedure, functions, Triggers to maintain data integrity.
• Worked on creating batch programs using Perl and Shell.
• Developed Oracle JOBS for executing the Stored Packages.
• Responsible for production support and mentored developers on issues pertaining to PL/SQL.
• Written korn shell scripts to develop batch pl/sql scripts to be run as Control-M jobs.
• Configuration Management using PVCS. Creation of SMR's and DCR's for DBA.

Environment: Oracle 10G/11G, Shell Script, PL/SQL Developer, ERWIN, Toad, PVCS, and CVS

Confidential

Oracle Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and
• Interaction with the client
• Implementation of the business requirements.
• Creating table schema using ERWIN
• Written Oracle database triggers for auditing the jobs and maintain data integrity.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Production Support for Service Center Tickets, Code Tickets and Analysis, coding Testing
• and Implementation of Project Enhancements.
• Created, debugged, and modified stored procedures, triggers, tables, views, user-defined
• functions etc
• Interacting with the users and troubleshooting the problems involved with the development of
• stored procedures, triggers and with the privileges.
• Involved in Writing Backend Procedures, Functions Packages in PL/SQL.
• Worked on system-defined packages like DBMS JOB for scheduling the jobs.
• Used Materialized Views for query rewrite for reporting, and Execute immediate to execute dynamic SQL.
• Used Bulk collect, Forall to process large volume of data.
• Data migration and conversion done utilizing Oracle utilities: SQL Loader, Export/Import.
• Extensively used SQL Loader to load Data from flat files to Database tables in Oracle.
• Developed pl/sql packages to pass the data to downstream systems for look up against the
• downstream systems reference tables.
• Involved in performance tuning and optimization.
• Extensively used Joins in Interaction with backend database using PL/SQL.
• Written UNIX shell scripts in K-Shell for automatic notification of status of daily cron jobs.
• Written korn shell scripts to develop batch pl/sql scripts to be run as Control-M jobs.
• Configuration Management using PVCS. Creation of SMR's and DCR's for DBA.
• Providing production support as needed offering timely, instantly sound problem resolution.

Environment: Oracle 9i/10G, Shell Script, PL/SQL Developer, Toad, ERWIN, PVCS, and CVS

Confidential

Oracle Developer

Responsibilities:

• Onsite Co-ordinater
• Migration of RADIS GUI from PowerBuilder 6.5 to 11.0
• Coding in PL/SQL for the backend changes and upgradation from Oracle 9i to 10g
• Writing complex SQL queries and PL/SQL procedures and functions to extract data from
• various source tables.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Environment setup
• Coding in Proc C for the backend
• Makefiles to compile .pc files into object files and executables.
• Shell scripts which execute batch SQL scripts to be set up as jobs in Control-M.
• Shell scripts to load data files into database using ftp commands and SQL-Loader
• Resolving of the Production tickets.
• Writing shell scripts to execute Proc C executables
• Deploying the new changes in production

Environment: Oracle 9i, Shell Script, PowerBuilder 6.5, 11.0, Proc C, PL/SQL Developer, Putty,

Confidential

Oracle/Java Developer Onsite Co-coordinator

Responsibilities:

• Understanding the system and create documentation
• Onsite co-coordinator
• Migration of IROSS GUI from PowerBuilder 6.5 to 11.0
• Coding in Java
• Building of the jar files and deploying builds in test environment.
• Write build scripts in ANT
• Environment setup
• Configuring and Creating domain in weblogic server
• Deploy the applications in weblogic 7.1
• Code changes for backend for Upgradation from Oracle 9i to 10g
• Writing PL/SQL code using the technical and functional specifications generated SQL and
• PL/SQL scripts to install create and drop database objects including: tables, views, primary
• keys, indexes, constraints, packages, sequences, grants and synonyms.
• Unit Testing of the application
• Reviewing of the code changes done by offshore team.

Environment: Oracle 9i, Java, J2EE, Shell Script, Weblogic 7.1, PowerBuilder 6.5, 11.0, PL/SQL

Developer, Eclipse, Ant

Confidential

Oracle Developer

Responsibilities:

• Involved in extracting, discussing, and refining business requirements from users and
• team members.
• Implementation of the requirement.
• Designed database tables, Relationships and Views.
• Loaded data into main staging table and lookup tables through set of INSERT statements.
• Worked on PL/SQL Packages, Procedures, Objects, VARRAYS, Functions, and REF
• Cursors.
• Extraction of the CDR from SIP server to MIS Server using Shell programming
• UNIX Shell scripts and commands for file management, job automation and administration
• tasks.
• Loading of the data into tables from the MIS server using SQL Loader
• Coding in PL/SQL using Packages, Stored Procedures
• Generation of Reports at MIS website based on date input from the summary tables
• Design, Develop, Customized various Reports using PL/SQL and SQL.
• Generating web based reports using Java scripts.

Environment: Windows NT, Oracle 9i PL/SQL, JSP, Shell Script, SQL Loader, PL/SQL Developer

Confidential

C/C Developer

Responsibilities:

• Involved in implementation and coding of real BSC changes of P12 project into SEA-BSC, BT and CLE along with the client.
• Implementation of the P13 project of real BSC and BTS changes in SEA-CLE.
• Written new BSC components RHTRHR, RHLAPD using C and COM.
• Device Simulation using C and C .
• Written a new interface to access the above components using C .
• Trained people in the team at the functional and technical level in CLE.
• Prepared networks to launch the CLE setup in SEA.
• Responsible for writing test specs and testing at functional level.
• Made modifications in the GUI of SEA tool to support CLE functionality using TCL/TK.
• Written setup files using shell script and UNIX environmental variables
• Responsible for providing support and maintenance of CLE
• Implementing of future changes in real BSC in SEA CLE.

Environment: Solaris 9.0, C/C , Tcl/Tk, COM, Rational Clear Quest, ClearCase, C , Tcl/Tk, Core GSM : L1 L2 protocols,OML RSL, 3GPP standards

Confidential

C,C Developer

Responsibilities:

• Understanding the existing System Functionality.
• Requirements gathering and Documentation.
• Feasibility Check and application.
• Prepared the Impact analysis documents.
• Provided the effort estimation.
• Implementation and coding of the requirement.
• Responsible for opening, answering, solving and closing of the time critical Trouble Reports raised by Ericsson and its partners in the web tool Rational Clear Quest.
• Responsible for building and releasing Maintenance releases and Service Packs of SEA.
• Debugged the code efficiently using the debugging tools like GDB, DDD, Forte Workshop,
• Used tools Rational Purify, Purecov to detect memory leaks in the code and fix them.
• Involved in answering the queries of various Ericsson users in any part of SEA.
• Increased the quality and performance of the components and legacy issues by finding the actual root cause of the problem.
• Coding in C. C , TCL/TK.
• Solved system test bugs.
• Responsible for identifying the defects and changes needed to refine the tool.
• Worked with the various tools used by the Ericsson Testers like STNTools, MGTS, BSS tools like TSS
• Used pipes and filehandles to pass the data from the GUI and to read the data from the Core CP part of the Tool.
• Developed interfaces .idl files using COM Query Interface and library functions and C to interact with a component.
• Written MakeFiles to compile the source code
• Written shell scripts to deploy the application,
• Prepared the test cases.
• Involved in fixing the bugs during testing phase.
• Conducted Team Meeting to gather the status of TRs from Team Members .
• Analyze the technical solution proposed for a TR by the team member.
• Helped the team members to solve their TRs so that TR timeline is not crossed.
• Responsible for Code Review activities of other designer features in STE.
• Code owner for some components written in C , Tcl/TK
• Internal reviewer of IP, RS, Code in the project.
• Involved in complete like cycle of the project
• A faculty in the Training committee of the project.
• Conducted many KSS over a range of topics to build competency in the team.
• Mentor for new members in the team.

Environment: Solaris 9.0, C/C , Tcl/Tk, Plex-C, ASA, Shell programming, Socket Programming Rational Clear Quest, ClearCase, GDB, WorkShop