SUMMARY

• A technology lead wit 8+ years of experience in database analysis, design, application development, implementation and production support activities in a Client/Server environment with a core competency in Oracle 11g/10g/9i, Forms, Reports and support experience in Unix and Windows.
• Experience in all phases of Software Development Life Cycle (SDLC),AGILE/SCRUM including analysis, design, development, testing, documentation, implementation and maintenance
• Expert in teh development of PL/SQL Procedures, Functions, Triggers and Packages in PL/SQL to implement business logic.
• Proficiency in data warehousing techniques for Data Profiling, Change Data Capture, Data Cleansing, Dimension phenomenon, surrogate key assignment.
• Proficient in Data analysis, Data modeling, Database design, Data migration, and Business intelligence solutions.
• Expert noledge in dimensional modeling, Star Schema modeling, Snowflake modeling, fact and dimension table design, physical and logical Data modeling using Erwin 3.5, Toad Data Modeler.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques, and Indexes
• Experience in using Composite Data Types in Oracle.
• Expertise in working with Oracle 11g/10g/9i, TOAD, SQL Navigator, SQL * Loader, Forms 10g/9i/6i and Reports 10g/9i/6i/ for both development and customizations as per client specifications.
• Knowledge in Tableau Desktop 8.3
• Knowledge in schema structure design and involved in estimation and optimization of data storage Experience in utilizing Oracle tools and methods like teh use of External Tables, Pipelined functions.
• Experience in migration and conversion from Flat Files/MS Access/SQL - Server to Oracle using Oracle SQL* Loader
• Experience in Tuning SQL statements using EXPLAIN PLAN and TKPROF to optimize teh performance of teh batch processes.
• Well-versed in using tools like SQL*Plus, SQL Developer and TOAD.
• Expertise in using JIRA, SMS, TCMS for project tracking, teams planning and also reviewing and commenting teh code base.
• Involved in review and gap analysis of Functional Requirement documents. Creation of Technical Documents and related Test Case Document.
• Expertise in fixing software bugs and problems quickly and TEMPeffectively.
• Refine conceptual systems design requirements into teh technical design Involved in review and Gap Analysis of Functional Requirement documents. Creation of Technical Documents and related Test Case Document.
• Great learning skills to adapt teh rapid changing technologies and implementing teh same at work.
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.
• Knowledge on Informatica 8.6, BI Publisher, DAC, OLAP. OLTP, XML, Oracle Argus, SSRS and OBIEE.
• Experience with ETL involving large amount of data, in particular XML parsing and loading into Oracle, Oracle XML Packages.
• Followed Agile and Scrum development methodologies in delivering teh deliverables.

TECHNICAL SKILLS

Oracle: Oracle 11g/10g/9i/8i, Oracle Developer 2000, SQL*Plus, SQL*Loader, TOAD 7.0Developer 2000,Oracle Tkprof & Trace

Databases: Oracle, MS Access 2000, SQL*Plus, SQL*Loader, TOAD, Developer 2000,OLTP,OLAP

Reporting Tools: TOAD, SQL Navigator, PL SQL, OBIEE,SSRS, Tableau 8.3

Languages: PL /SQL, SQL, SQL*Plus

Programming/Others: SQL, PL/SQL, Unix Shell Scripting, SQL*Loader, SQL*Plus, Pro*C, C, HTML 4.0

Others Tools: ODBC, OLAP, TCP/IP, MS Office 97/98/2000 and Dream Weaver, JIRA, SMS, Remedy

Domain Knowledge: Retail, Telecom, Pharma, Manufacturing, Supply Chain Management, Real EstateInsurance, Education, Banking

PROFESSIONAL EXPERIENCE

Confidential, FL

Sr. Oracle Developer

Responsibilities:

• Gathering functional requirements for CHASE CRTS Applications and prepared Technical design documents.
• Writing PL/SQL Scripts for CRTS PAD,CRTS LYNX,CRTS CREM and other applications.
• Involved in data modeling using ERWIN and CASE tools.
• Tuning queries for CBBI applications.
• Preparing RCA,CCDs for all CRTS applications.
• Using External tables to load data from multiple sources.
• Developed test plans and performed Unit tests and involved in SIT with QA team.
• Working with other teams and Clients to gather teh requirements.
• Worked on ETL Transformations.
• Working as Business Analyst cum Developer.

Environment: Oracle 10g/11g, Informatica, SQL Server, Unix, COGNOS, Windows, Toad, JIRA, Erwin

Confidential, Stamford CT

Tech Lead/Project Lead

Responsibilities:

• Gathering teh functional requirements from users and converting them into Technical requirements.
• Migrating data from Siebel to Oracle Database.
• Creating database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL.
• Extracted data from OLTP Database and loaded data into OLAP DB’s using PL/SQL scripts(ETL Methodology).
• Level 2 & Level 3 production support for this project. Supported teh system round teh clock
• Responsible for identifying teh cause and resolving teh issues. Debug and fix any issues that arise during teh course of any day
• Carry out teh month end load, and extractions processes. Communicate with other teams and business users to notify about teh newly loaded files and taking care of teh issues surface during this process
• Implement teh necessary code optimizations and develop/automate processes to reduce errors in file loads
• Mapped data from Siebel to Oracle by creating a similar data model
• Using SQL* Loader and export/import mechanism for data migration for bulk upload.
• Perform Unit testing in development environment and had a close interactions with system test and user acceptance team to complete technical and functional testing.
• Working as a coordinator between teh onsite and offshore teams.
• Preparing RCA, TDD, FDD documents.
• Providing teh on-call support 24*7 to resolve RTS issues (Ready to Serve).

Environment: Oracle 10g/11g, SQL Developer, Quality Center, SVN, Informatica, Cognos, TFS, RemedyOracle Argus, ArisG

Confidential, Washington D.C

Senior Oracle Developer

Responsibilities:

• Meeting with end user, collecting requirements and converting into technical specification.
• Designing Database using Sybase Power Designer and Erwin for applications.
• Create detailed documentation for user approval.
• Create and modified data migration scripts/Pull Scripts.
• Loaded data from Existing database schema to new schema using Oracle Packages.
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Triggers and Packages.
• Writing database triggers for automatic updating teh tables and views.
• Create User Schemas, tables, indexes, sequences, views, directories.
• Verify, validate data using SQL queries.
• Modified existing Code according to teh requirements.
• Day to day production support.
• Troubleshoot and debug system and/or data errors.
• Tuned SQL queries using Tkprof utility to improve performance.
• Involved in Testing, Integration System test, Implementation (test with users).
• Converted data from legacy system to Oracle 10g using PL/SQL programs.
• Responsible for creating complex views.
• Use VSS and SVN for source control.
• Involved in migrating MS-Access systems to Oracle Database.

Environment: Oracle 11g/10g, Windows XP, VSS, SQL *Loader, JIRA, TOAD, Erwin, QC

Confidential, Scottsdale (AZ)

Technical Consultant

Responsibilities:

• Develop Stored Procedures, Functions, Views, Cursors, Packages and Exceptions.
• Configure teh server with product installation and batch set up.
• Troubleshoot teh issues related to SCPO.
• Manage data conversion from flat files to Oracle using Oracle SQL* Loader.
• Modify Oracle PL/SQL Procedures and Functions as per teh client requirements.
• Scrutinize SQL statements using “Explain Plan” to improve teh performance.
• Preparing Functional specification documents.
• Understand teh technical & functional specifications designing, developing,
• Testing, troubleshooting and debugging of teh applications.
• Monitor teh scheduled jobs using AS400.
• Handle SCPO and EP tickets as per teh request from client.
• Provide timely response to all client requests, including on-call support (L2) outside Normal business hours.

Environment: Oracle 11g/10g, AS400, Windows, SQL *Loader, TOAD, Unix

Confidential, Greater Chicago (IL)

Senior Oracle PL SQL Developer

Responsibilities:

• Verify, validate data using SQL queries and create text according to teh requirements.
• Modified existing Code according to teh requirements.
• Load teh created text in to teh normalized tables using PL/SQL Store Procedures, Functions and Packages.
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Ref Cursors Triggers and Packages.
• Troubleshoot and debug system and/or data errors.
• Tuned SQL queries using Tkprof utility to improve performance.
• Involved in Testing, Integration System test, Implementation.
• Source and target system Analysis.
• Co-ordinate/Discuss with Onsite team and leads for requirement clarification.
• Implement PL/SQL jobs as per teh client requirements.

Environment: Oracle 11g, Datastage, Autosys, Abinitio, Cognos, Remedy tool.

Confidential, Greater Chicago (IL)

Senior Oracle Developer

Responsibilities:

• Loading data from flat files into Oracle 10g database using SQL*loader
• Verify, validate data using SQL queries
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Ref Cursors Triggers and Packages.
• Troubleshoot and debug system and/or data errors.
• Create User Schemas, tables, indexes, sequences, views, directories.
• Create detailed documentation for user approval.
• Modified existing Code according to teh requirements.
• Involved in Testing, Integration System test, Implementation.
• Involved in development of SVI reports and share it with teh Orbit team.

Environment: Oracle 10g, Windows OS, Informatica 8.6, SQL Developer

Confidential

Oracle PL SQL Developer

Responsibilities:

• Create detailed documentation for Data conversion and migration.
• Loading large data into teh Oracle database objects. Importing/Exporting data from/to different databases using utilities like SQL*Loader and Import/Export.
• Wrote fine-tuned SQL queries to Migrate and Convert teh data.
• Verify, validate data before and after migration/Conversion according to teh requirements.
• Modified existing Code according to teh requirements.
• Wrote Oracle database triggers, stored procedures, stored functions, and stored packages to perform various automated tasks to performed for better performance Used different joins, sub-query, nested query in SQL query, for reporting purpose.
• Wrote database triggers for automatic updating teh tables and views.
• Troubleshoot and debug system and/or data errors.
• Tuned SQL queries using Tkprof utility to improve performance.
• Involved in Testing, Integration System test, Implementation.

Environment: ODS, Oracle 10g, SQL Navigator, UNIX, PeopleSoft, Abinitio, Sql Loader

Confidential

Oracle PL SQL Developer

Responsibilities:

• Created and modified data migration scripts/Pull Scripts.
• Loading data from flat files into Oracle 9i database using SQL*loader and Unix script
• Verify, validate data using SQL queries
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Triggers and Packages.
• Write UNIX scripts to upload data from text files (and control files) to teh database using sqlloader.
• Create detailed documentation for user approval.
• Modified existing Code according to teh requirements.
• Add new functionality for fetching multiple records (for different dates) based on business logic.
• Involved in Testing, Integration System test, Implementation.
• Provide timely response to all client requests, including on-call support outside Normal business hours.
• Understand teh overall Confidential and Oracle RMS application.
• Key off-shore personal for noledge transfer, interface for Client team for RMS application.

Environment: Oracle RMS, Oracle Retek API, Message Queue, Oracle 10g/9i,TOAD, Unix, Pro*C,SMS ticketing tool