• Over 5 years of functional experience in developing Client/Server & Web applications using ORACLE 8i/9i. • Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures, functions, and triggers using Oracle PL/SQL tool. • Experience in database performance tuning and query optimization, data integrity and statistics. • Working experience in the installation and configuration of Oracle 9i/10g. • Experience in designing Logical and Physical data models using ERWIN, DT Studio and ETL tools. • Experience in designing and maintains of Oracle6i Forms & Reports. • Good knowledge in database management systems (DBMS). • Extensive experience in working with the TOAD tool. • Comfortable working with SQL Server 2000/2005- Query Analyzer, SQL Profiler. • Experience in creating reports using Business Objects. • Proven experience in system analysis and developing business rules document based on user's requirement. • Excellent experience in RDBMS with over of skills in DB2 and ORACLE • Experienced in mentoring team members on development and getting things done on time. • Good knowledge of software development life cycle (SDLC). • Strong analytical and problem solving skills with ability to work within team environment and independently when needed. • Possess excellent oral / written communication and interpersonal skills. • Good ability to quickly grasp and master new concepts and technologies.
Technical Skills:
• RDBMS/Databases : Oracle 8i/9i/10g, MySQL, SQL Server 2000/2005 • Operating Systems : MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX • Data Modeling and ETL tools : ERWIN, TOAD tool and DT Studio. • Reporting tools: Business Objects, BO- XI and Oracle6i Forms & Reports. • Languages : C, Java, SQL, PL/SQL, T-SQL • Packages : MS Office, Visual Basic • Web technologies : HTML, VB-Script
Education:
• Bachelor's degree in Computer Science and Engineering (Madras university).
Professional Experience:
T-Mobile Wireless, Bellevue, WA (Nov 2005 -- Till Date) Database Developer
Description: T-mobile is a national provider of wireless voice, messaging and data services capable of reaching millions people where they live, work and play.
Responsibilities: • Responsible for the installation, configuration and maintenance of Oracle 9i database on different platforms. • Participated in the development of Oracle 9i database, which would store information on the payroll and personal information of the employees. • Involved in upgrading the database Oracle8i to Oracle9i. • Migrated Oracle8i Data Transformation Services objects to Oracle9i environment. • Data migration and conversion done utilizing Oracle utilities: SQL*Loader, Export/Import. • Designed and maintained user interfaces utilizing Oracle6i Forms & Reports. • Involved in extracting large volumes of data from different data sources, performing transformations and loading that data into another data sources. • Created tables, tablespaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD tool. • Developed necessary data access programs using JDBC and DataExpress and developed the web pages using HTML and Java Scripting. • Developed the logical data model and physical data model for the DB2 database. • Wrote Various Shell scripts for DBA's in automating their daily Tasks. • Providing production support as needed offering timely, instantly sound problem resolution. • Create maintain and tracking of end users business issues. • Developed, modified, and optimized complex queries for data retrieval and modification. • Managed the backup and recovery of the database and Legacy Data mapping with Oracle system. • Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges. • Experienced in setting up Oracle9i and database configuration parameters.