SUMMARY:

• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.
• 7+ years of IT experience in Analysis, Design, Modeling, Development, Testing and Implementation of D Confidential Warehousing Business Applications as well OLTP application.
• 4+ Years of D Confidential warehousing experience. Design and developed medium to complex size d Confidential warehousing project for Cisco.
• Successfully handled a team of 15+ associate in Onsite/Offshore model.5+ years of abroad experience (USA + Uruguay) worked closely with Client and as Client.
• Experience in requirement gathering and requirement management in cross functional projects
• Expertise in business and systems documentation, use case analysis and change management
• In - depth experience in functional testing and end user
• Persuasive and professional communication skills
• Proven technical leadership and Deliverable management as Delivery owner
• Creative person with ability to extrapolate essential information with a rapid learning curve
• Extensive cross national and cross cultural experience with good people skills
• Excellent skills in designing and development of applications using Oracle 10g/9i/8i, SQL, PL/SQL Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.
• XML processing through Oracle PL-SQL.
• Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle d Confidential base issues.
• Developed the automated Job to monitor the application performance.
• Excellent SQL skills, experience writing complex queries and working with d Confidential base objects like tables, views, sequences, synonyms.
• Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
• Experience in Bulk D Confidential loading using Oracle utilities namely SQL Loader and External Tables.
• Expertise with D Confidential Migration, D Confidential Mapping or Table mapping, D Confidential loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
• Good knowledge of D Confidential Modeling using ETL tools, OLAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Expert in developing reports using OBIEE and BO.
• Worked on repository creation of OBIEE.
• Has expertise in ETL tools like OWB and Informatica
• Expertise in Edition enable features and near Zero downtime d Confidential bases
• In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational d Confidential base environment using SQL, PL/SQL using d Confidential base tools like Toad, PL-SQL Developer.

TECHNICAL SKILLS:

Programming Languages: C, C++,Java, SQL, and PL/SQL,Visual Basic 6.0

Databases: Oracle 11g/10g/9i/8i, SQL Server. Advanced Oracle queuing technique (Cisco D Confidential Bus). Oracle Apps Pricing Module.

BI Tools: Siebel Analytics, Business Objects

ETL Tools: Oracle warehouse builder, Informatica

Operating Systems: Solaris, UNIX, Linux, Windows 95, NT, 2000, XP

Scheduling tool: Dollar Universe

Front end Tool: Toad,PL-SQL Developer

WORK EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Analysis of business requirements and functional specifications documents
• Creation of Technical design document.
• Manage traceability between requirements, use cases and test cases
• Code review, TSD reviews and test plan reviews.
• End 2 End performances tuning of the Application.
• Drive towards usage of more reusable component and Scalable component creation.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.
• Work closely with the testing team for preparation and execution of UAT plans.
• Assignment Matrix as necessary
• Manage resources to ensure delivery within planned timeframes
• Prepare user manuals, presentations and provide end user

Environment: Oracle 11g, perl, Toad, UNix Scheduling tool,Erwin, SVN

Confidential

Sr. Oracle Developer

Responsibilities:

• Creation of Technical design document.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.
• Creation d Confidential base scheduler jobs, Stored procedures, triggers and packages to transact d Confidential
• Created D Confidential base tables and performed DDL, DML and DCL commands.
• Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Act as the liaison between the business users and the technical team (onsite and offshore)
• Manage traceability between requirements, use cases and test cases
• Perform GAP analysis and D Confidential modeling
• Work closely with the testing team for preparation and execution of UAT plans.
• End 2 End performances tuning of the Application.

Environment: Oracle 10g,11 g, Oracle APPs, Golden gate, Java, Toad, Dollar Universe Scheduling tool,PVCS,WINCVS

Confidential

Oracle Developer

Responsibilities:

• Analysis of business requirements and functional specifications documents
• Creation of Technical design document.
• Act as the liaison between the business users and the technical team (onsite and offshore)
• Manage traceability between requirements, use cases and test cases
• Perform GAP analysis and D Confidential modeling
• Work closely with the testing team for preparation and execution of UAT plans.
• Prepare user manuals, presentations and provide end user
• End 2 End performances tuning of the Application.
• To do the code review, developed the reusable component.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 9i, Java, Toad, DBMS profilers.

Confidential

Reports Developer

Responsibilities:

• Developed the repository for attach rate and combined with existing business model of MBR DIRECT.
• Developed the attach rate reports in MBR Direct application which are accessible to CA team by creating the admin groups for CA team.
• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through dollar U Jobs.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.
• Tuned PL/SQL Packages and Procedure to manipulate large no of d Confidential using collections like nested tables and arrays.
• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, Indexes.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.

Environment: Oracle 9i, Siebel Analytics, Toad,DBMS profilers.

Confidential

Reports Developer

Responsibilities:

• While Toad, use of index based on scalability and cardinality for the table d Confidential and query structure .
• Coding & Debugging using tools like PL/sql developer, Toad
• Created Siebel Analytics repositories and reports.
• Documented the unit test cases and their status in unit test case document.
• Versioning of code using version tool PVCS.
• Deployment of the code using specific tool like Kintana .

Environment: Oracle 9i, Siebel Analytics, Java,Toad,DBMS profilers.

Confidential

ETL developer

Responsibilities:

• Created the OWB Mapping Documents.
• Prepared and reviewed the OWB Mapping documnets with Onsite Team
• Prepared of the Unit testing d Confidential requirements
• Created OWB mappings and Deploying them stage environment in Oracle Warehouse Builder
• Defect fixing and closing defects HP Quality Centre.
• Interacting with Onsite Lead and giving daily status of the project
• Creating and maintaining Project related documentation.

Environment: Oracle 9i, Oracle Warehouse Builder, Siebel Analytics Toad.