EXPERIENCE SUMMARY

• More than 9 years of experience in the IT industry out of 6 years in Telecom domain.
• Over 2 years' experience in AT T ACSI DTI Data Transformation Integration project as designer/developer in Oracle 11g, Oracle Golden Gate 10.4 Informatica 9.1.
• Very Strong experience in ETL/Oracle environment as an Analyst / Developer using most of the Oracle related tools under UNIX and Windows environments.
• Extensive and proven experience using Oracle 8i/9i/10g, 11g, SQL, PL/SQL, SQL Plus, SQL Loader.
• Very strong in Client/Server Architecture, Relational Databases RDBMS , Data Modeling and Design and build the Data Warehouse, Data marts.
• Extensive experience in writing Oracle PL/SQL Packages, Functions, Procedures, Triggers SQL LOADER to implement the business logic.
• Good experience in writing shell scripts to automate and schedule jobs.
• Good working experience in Reports, Oracle Forms and RDBMS Concepts
• Experience working on Onsite/Offshore Model
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Strong problem solving technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining Test scripts.
• Expertise in Unit Testing, Integration, Functional, System, Performance, Load, Regression Testing and Validation Testing.
• Strong Coding and debugging skills. Self-motivated team player with good communication skills.
• Done analysis, designing, development, enhancement testing of applications.
• Functional experience includes telecom Middlewear, OSS VoIP Performance Monitoring system, Service assurance service activation, CRM, Bar-coding solutions, Civil Management, Asset Management, Financial Applications, Defense I-card Management, Inventory system.
• Having interpersonal skills and leadership abilities

TECHNICAL SUMMARY

WORK EXPERIENCE

Confidential

• Developed PLSQL Packages/Procedures/Functions for massaging the data as per business requirement.
• Involved in gathering elements from different data marts to consolidate in to single data mart.
• The Project Confidential Health is a reporting solutions for targeting and tracking impactful consumers and physician promotions with client Everyday Health. This project mainly deliver the functions like profiling targeting, Promotion monitoring, Patient matching reporting process, ROI, Benchmarking. Responsibilities:
• Analyze Business and Technical Requirements.
• Prepare application design with detail impact specifying impact on data flow, change in business logic of Shell Scripts, Oracle Pl/sql, performance/testing consideration, change in data volume dependency.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Created Shell Scripts to automate batch jobs.
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.
• Rebuilding the Indexes for performance of SQL Queries.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Involved in Developing and handling the PL/SQL Packages, Procedures and functions.
• Involved in tuning SQL queries by using EXPLAIN PLAN.
• Development, test specification creation and unit testing for various changes.
• Review design, code, and unit test cases.
• Used PVCS for code versioning.
• Used cybermation for job scheduling.
• Participate in mock deployment of every release, help to prepare release plan, identify the dependencies.

Environment: Oracle 11g, Linux, PVCS, Cybermation, TOAD, QC.

Confidential

DTI Team provides architecting, design, and development services for receiving batch and near real-time data feeds from a variety of data sources, performing required data transformation and aggregation and replicating the integrated data to the various operational data stores in the data fabric layers of the enterprise Objectives are to provide real-time, lowest latency, highest quality transformed and integrated data from various data sources to the data fabric layers of the enterprise using best of breed technologies and design. Responsibilities:

• Environment: Informatica 9.1, Oracle 11g, GoldenGate 10.4, Solaris, SVN, SWM, TOAD, QC.
• Coordinate with offshore for deliverables.
• Support Production Support team for production issues.
• Participate in mock deployment of every release, help to prepare release plan, identify the dependencies.
• Review design, code, and unit test cases.
• Development, test specification creation and unit testing for various changes.
• Involved in database upgrade impact on application.
• Involved in tuning SQL queries by using EXPLAIN PLAN.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Rebuilding the Indexes for performance of SQL Queries.
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans.
• Created Shell Scripts to automate batch jobs.
• Developed Oracle Golden Gate extract, pump, and replicat to implement the business logic transformation for near real time data.
• Developed Informatica mappings to move batch data from flat files to oracle tables.
• Developed PLSQL Packages/Procedures/Functions for massaging the data as per business requirement.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Prepare application design with detail impact specifying impact on data flow, change in business logic of Informatica, Oracle Pl/sql, oracle goldengate, performance/testing consideration, change in data volume dependency.
• Involved in gathering elements from different data marts to consolidate in to single data mart.
• Analyze Business and Technical Requirements.
• Confidential

Role: Sr. PL/SQL Developer/ Solution Designer

Responsibility:

• Installation, Creation and support of Oracle 10g database environments.
• Involved in the maintenance and enhancement of the application.
• Maintaining Logical and Physical structure of the database.
• Creating tablespaces, tables, views, scripts for automatic operations of the database activities.
• Coded various stored procedures, packages and triggers to incorporate business logic into the application.
• Used the technical document to design the database tables.
• Data conversion from flat file to intermediate tables using SQL Loader
• Created control files for SQL Loader.
• Gather Database and User Level Statistics and Analyze Overall System Performance.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
• Develop UNIX shell scripts to administer the system.
• Extensively worked with Dynamic SQL, Composite data types Global Temporary Tables.
• Responsible for purging and archiving the production databases.
• Used UTL JOB to automate the PL/SQL procedures and packages.
• Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures functions.

Environment: Oracle 10g, Solaris, CVS, TOAD, HP-QC.

Confidential

Role: Sr. PL/SQL Developer/ Solution Designer

Responsibility:

• Involved in the requirement gathering session from the clients for certain ongoing enhancement in the product.
• Involved in Oracle database modifications with regard to Procedures, Views.
• Extensively involved in writing PL/SQL Stored Procedures, Functions and Packages to meet the business requirements.
• Extensively used Informatica to Transform and migrate data based on business requirements.
• Created Functions for duty calculations and validation of the inputs.
• Developed and executed SQL Loader scripts to load data in the custom tables.
• Created custom Forms using Forms 9i to capture customer related data and Reports using Reports 9i.
• Created Custom Reports like Customer information report, Payment performance report, sales order report and rebate calculation report using Reports 9i.
• Involved in creating database objects Tables, Indexes, Sequences and Constraints as per the business requirement.
• Developed UNIX shell scripts for automated daily load processes by setting cron jobs.
• Developed Unix Shell Scripts for batch processing of the Reports, which were also scheduled to run Weekly, Monthly or Bi-Monthly.
• Responsible for performance fine-tuning of queries using TKPROF, EXPLAIN PLAN.
• Involved in creating complex views that require complex joins.
• Extensive use of SVN for version controlling and source code management.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Involved in Data migration using SQL Loader from flat files in to data base tables
• Prepare impact assessment, functional point assessment sign-off.
• Walkthrough the impact assessment to Development team.
• Clarify any queries of development team provide design support during development.

Environment: Oracle, PL/SQL, Unix, Forms 9i Reports 9i, SQL Plus, SQL Loader, TOAD, TKPROF, EXPLAIN PLAN, UNIX Shell Scripting, Informatica Power Center, SVN, HP-QC

Confidential

Responsibility:

• Develop backend modules procedures, functions and triggers meeting business requirements using SQL and PL/SQL
• Designing and building of business reports.
• Modified the existing procedures and functions implementing best techniques to improve the performance of the query.
• Designed and developed multiple drilled down and drill through reports to integrate summary and detail data.
• Formatted the reports using the Global variables and expressions.
• Created Filtered reports using report parameters, stored procedures cascading parameters.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Scheduling and running jobs in the background, and taking regular backups of the systems and recover data during failures.
• Involved in the extraction of data from different sources like flat files, excel and legacy databases
• Design and develop mappings with required transformations and load the data into the warehouse server for analysis using Informatica Power Center.
• Writing test cases for the code analysis and bug issues before deployment on to the production server
• Investigating and solving payment, registration, customer and business related backend issues
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL Plus, SQL Loader.
• Wrote Database Triggers, Stored Procedures using PL/SQL.
• Developing the Querying and Reporting process and data extraction.
• Worked on Shell Programming to invoke and schedule the PL/SQL Packages.
• Used the Built-In features in Oracle 8i such as Built-In Procedures and Functions to develop the application.
• Defined and Used Cursors wherever applicable to process the data from the query.
• Fine-tuned the queries using various performance tuning features in Oracle such as using Optimizer hints.

Environment: Oracle 8i, PL/sql, Unix, Informatica.

Confidential

Role: Sr. Oracle Developer

Responsibility:

• Involved as a part of team in designing the logical physical model for database tables.
• Used SQL Loader to load huge test data from various sources in PL-SQL.
• Generated SQL scripts and deployed database including installation.
• Schedule Backup Strategy full weekly database backups, daily differential hourly log Backups.
• Developed procedures to create ad-hoc reports to be displayed in GUI.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL Plus, SQL Loader.
• Developed forms using Forms 6i based on business requirements.
• Wrote Database Triggers, Stored Procedures using PL/SQL.

Environment: Oracle pl/Sql, Solaris, Perl.

Confidential

Role: PL/SQL Developer

Responsibility:

• Involved as a part of team in designing the logical physical model for database tables.
• Generated SQL scripts and deployed database including installation.
• Designed module wise Oracle 9i database structure and its implementation on the client server
• Developed tables, views, stored procedures, functions, and user-defined data types
• Created table structures along with the triggers, indexes like bitmap and function based indexes
• Maintained the data integrity and security using constraints and database triggers
• Involved in programming database triggers for automatically updating the tables and views
• Implemented table partitioning and sub-partitioning to improve performance and data management
• Responsible for tuning the application with the help of team members.
• Improved the query performance using better joins and hints appropriately
• Developed packages, procedures and functions for complex reports
• Used SQL Loader for loading the data into the tables from files
• Developed batch programs using UNIX shell scripts

Environment: Oracle Pl/sql, HP-Unix, Citrix, Brio Reporting

Confidential

Oracle PL/SQL Developer

Responsibility:

• Extraction of data from different flat files into Oracle Database using SQL Loader.
• Gather Business rules from the end users that are to be incorporated into the system.
• Wrote PL/SQL Procedures, Functions and Triggers for insert, update, and delete transactions.
• Changed existing logic within the packages for optimum Performance.
• Tested the original and optimized codes thoroughly for failures before exporting to other environments.
• Created Shell Scripts for Regular backup, instance start and shutdown
• Involved in successfully upgrade of database from Oracle 8i to 9i.

Environment: Oracle 8i, 9i, Pl/sql, Visual Basic-6.

Confidential

Role : Oracle Database developer

Responsibility:

• Analysis, Design, Development, Testing and Maintenance.
• Applied Database Tuning and Optimization, Normalization in the new database design.
• Proposed SQL Tuning within applications for optimized database access.
• Audit programs in PL/SQL for Data consistence check and validation.
• Involved in writing Queries and performance tuning of Oracle database, checking the most expensive queries.
• Database Code Optimization using EXPLAIN PLAN.

Environment: Oracle 8i, PL/SQL, Visual Basic 6.0, Crystal Report 8.x

Confidential

Role: Oracle Developer

Responsibility:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Conducted focus group to determine what data elements are needed in Oracle.
• Involved in Designing and Modeling of the database using Erwin.
• Created entities and attributes in Logical Design. Followed proper naming conventions in Physical Design.
• Created Tables, Views, and Synonyms, Indexes, Sequence, Users and assigned privileges in development environment.
• Data from Flat Files been uploaded into Oracle Tables using SQL Loader.

Environment: Oracle 8i, PL/SQL, Visual Basic 6.0, and Crystal Report 8.x