SUMMARY:

• Around Eight years of experience in IT including six plus years’ experience application development; this includes design, development and implementation of projects as Oracle PL/SQL developer and SQL Server developer.
• Experienced in tools such as SQL *Developer, TOAD, WRQ REFLECTION FTP CLIENT and Putty.
• Experienced in tools such as Data Flux Power Studio 8.2.1.
• Exhaustive experience in writing PL/SQL scripts for database entities like Tables, Procedures, Functions, Packages, Triggers, Sequences and Indexes.
• Well versed in using Views, Synonyms, Indexes, Hints, Joins and Sub - queries.
• Experience in writing UNIX shell scripts to automate batch processes.
• Proficient in SQL query tuning to improve performance.
• Experience in Design Module like Master Data Management (MDM) .
• Experience in MDMimplementations in multi-org/multi-currency scenarios.
• Experience in Web Design, development and implementation of Internet/Intranet applications using C#, VB.NET, ASP.NET, ASP, HTML, JavaScript, CSS and XML.
• Skilled in writing unit test cases.
• In depth experience in all phases of SDLC: Requirements Gathering, Analysis, Design, Development, Testing, Implementation (Production) and Maintenance Support(Post Production)
• A Self-starter with strong planning, organizing and controlling skills. Consistently manage time and multiple tasks to meet deadlines, established objectives and quality performance standards.
• Able to work independently as well as in a team effectively.

TECHNICAL SKILLS:

Database Technologies: Oracle 8i/9i/10g/11.5g MS-SQL Server 2008/2005/2000

Languages: PL/SQL, SQL, Unix shell script and Java, C++

Development Tools: Oracle Enterprise Manager, TOAD 9.6.1a, Oracle SQL Developer, SQL *Plus, SQL *Loader, Erwin 7.3, Oracle Data Modeler, Query Analyzer,Data Flux Power Studio 8.2.1

Application/Web Services: .Net Frame work, Web Logic

Operating Systems: UNIX, Solaris, Red Hat Linux, Windows NT/2000, Windows 98/XP

PROFESSIONAL EXPERIENCE:

Confidential, Pea pack, NJ

Sr. Oracle Developer

Responsibilities:

• Worked in close Interaction with developer, Business Analyst and Project Manager and regional leads of both Zoetis and Confidential teams.
• Understanding functional specifications and developing creative solutions to meet business requirements.
• Optimized the existing procedures and SQL statements for the better performance using CURSORS, SQLSTATEMENTS AND VALIDATIONS and etc. to tune SQL queries.
• Performed ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer/product Data Set into MDM that was coming from various source systems.
• Extracted various reports using Data flux Power Studio.
• Defined and configured schema, staging tables and landing tables, base objects foreign-key Relationships, look up systemsand tables, packages, query groups and queries/custom queries.
• Defined and developed Oracle packages, procedures andfunctions.
• Involved in different types of testing after procedure developed.
• Involved in the database design of using the staging tables to load the data into each application.
• Involved in writing data migration script and creating backup scripts for each release.
• Developed UNIX shell scripts to automate batch processes to load data to production tables.
• Database optimization using indexes and normalization principles to increase the efficiency of data manipulation and extraction.
• Pre-Migration testing and validation of all data elements been converted
• Performed initial data migration, subsequent delta migrations and validated the data been converted.
• Involved in refreshing test environment with production data after each release to make way for testing the locations going live the next release.
• Creating all test data (with templates provides by regional leads) and process in test environment for other teams to start testing and make changes as and when required.
• Involved in data validation process in data validation environment before the data is processed in production.
• Involved in intensive data migration, data validation and report generation on the go-live day.
• Involved in hypercare support.

Environment: Oracle 11.5g, TOAD 11.5, Windows 2000, RedHat Linux 5.11

Confidential, Jersey City, NJ

OracleDeveloper/ Data Analyst

Responsibilities:

• Worked in close Interaction with developer, Business Analyst and Project Manager.
• Understanding functional specifications and developing creative solutions to meet business requirements.
• Optimized the existing procedures and SQL statements for the better performance using EXPLAIN PLAN, HINTS, SQL TRACE and etc. to tune SQL queries.
• Performed ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer/product Data Set into MDM that was coming from various source systems.
• The interfaces were developed to be able to connect to multiple databases like SQL server and oracle.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systemsand tables, packages, query groups and queries/custom queries.
• Defined and coding Oracle packages, procedures andfunctions.
• Involved in the database design of using the staging tables to load the data into each application.
• Involved in preparing roll back scripts and developing roll back plans.
• Database optimization using indexes and normalization principles to increase the efficiency of data manipulation and extraction.

Environment: Oracle 10g, TOAD 7.5 / 8.0, SQL Navigator 5.5, Windows 2000.

Confidential

Programmer/System Analyst

Responsibilities:

• Involved in the design of the database Access
• Creating tables inserting data’s according to requirement.
• Involved in job card deception.
• Involved in DML, DDL operations of RDBMS.
• Involved Proper exception handling,
• This editor can be used with any database for a given driver for the database. This tool was developed for Oracle database using the Oracle Type IV driver.

Environment: Windows, Oracle and Visual Basic 6.0, SQL Server 6.5

Confidential

Programmer/System Analyst

Responsibilities:

• Involved in the design of the database Access
• Involved in design and developing different kind of modules.
• Involved in maintain the database.
• Involved in testing the different kinds of parts
• Excellent team player with problem-solving and trouble-shooting capabilities.

Environment: Windows, Visual Basic 6.0, Oracle, and Visual basic.