SUMMARY

• Overall 15+ years of IT experience as developer and Architect in Confidential Products.
• Expertise in Confidential (SQL, PL/SQL and DBA Activities) and having experience on UNIX SHELL scripting.
• Thorough experience on software development methodology, Quality and Process. Worked in various projects adhering to phases of software development life cycle, which includes system study, analysis, design, development, testing and implementation.
• Experience in Data Migrations and DBA Activities.
• Experience in controlling the User Privileges and monitoring the Security and Audit issues.
• Experience in Programming Tasks - Stored Procedures, Triggers and cursers Using PL/SQL.
• Experience in the performance Tuning, Error Handling and generating the Reports.
• Experience on the Informatica Data Transformation and data extraction for the reports.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills wif clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Confidential supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Confidential Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience wif Confidential Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Confidential performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience in the Project Management methodologies, Project delivery, People management and project inventory and accounting.

TECHNICAL SKILLS

Oracle Tools: SQL Developer, SQL *Plus, SQL*Loader, TOAD

ETL tools: Informatica power center 9.0/8.x

Databases: Oracle 11g/10g/9i, MS Access, SQL Server

Tools: Quality Center, Jira, MS Office

Languages: PL/SQL, Shell scripting

Operating Systems: UNIX/LINUX, Sun Solaris, WINDOWS NT/XP

Middleware: Oracle Identity and Access Manager OIM

PROFESSIONAL EXPERIENCE

Confidential, Buffalo NY

Senior Oracle PL/SQL Developer

Responsibilities:

• Requirement Gathering, Effort Estimation and Analysis impact.
• Work wif the team of analysts, developers, BA and drive delivery of Solutions.
• Driving Project deliverables to completion from a Technical/Functional perspective.
• Create SQL query and PL/SQL Procedures, Triggers, and Functions necessary for maintenance of the databases.
• Development and Unit Testing.
• Tuning of queries for better performance.
• UAT (User Analysis Testing) / Support.
• Co-ordinate wif the support teams for roll-out, create necessary document for the production migration.
• Support of defect/Bug fixes and issues reported.
• Develop UNIX shell scripts in Batch Job and job scheduling.

Confidential, Minneapolis MN

PL/SQL / ETL Developer

Responsibilities:

• Requirement Gathering, Effort Estimation and Analysis impact.
• Work wif the team of analysts, developers, QA and drive delivery of ETL Solutions.
• Driving Project deliverables to completion from a Technical/Functional perspective.
• Create SQL query and PL/SQL Procedures, Triggers, and Functions necessary for maintenance of the databases.
• Created database objects like Tables, Synonyms, indexes and Views.
• Data modeling and Technical Design.
• Development and Unit Testing.
• Tuning of queries for better performance.
• System and Integration testing.
• UAT (User Analysis Testing) / Support.
• Co-ordinate wif the support teams for roll-out, create necessary document for the production migration.
• Support of defect/Bug fixes and issues reported.
• Develop UNIX shell scripts in Batch Job and maestro job scheduling.

Confidential, Charlotte NC

Senior Data Consultant

Responsibilities:

• Involved in analyzing the businessand functional requirements of the Project.
• Manage all aspects of data analysis activities like writing testing scripts, test cases based on the Requirement document.
• Scheduled Autosys jobs to execute the ETL/SQL jobs using the AUTOSYSchedulers.
• Run Daily and monthly Regression process and validate the data, Raise the defects if any for dev Team.
• Generation of various reports to compare the CRS/NRA/Mars system data wif Prod and QA.
• Wrote unit/integration test cases and done the unit testing/ Integration testing to achieve the functionality.
• Extensive hands on experience using Confidential 10g, Confidential 9i, Sybase and SQL Server databases and several of its tools.

Confidential, Atlanta GA

Architect/Senior DB Developer

Responsibilities:

• Developed PL/SQL procedures, functions and packages for processing business logic in the database.
• Procedures and packages being called by using the Shell Scripts, which was written in UNIX.
• Scheduled batch jobs to execute the DB jobs using the DB schedulers.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively used hints to direct the optimizer to choose an optimum query execution plan.
• Created database objects like tables, views, materialized views, procedures and packages using Confidential tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Using Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Wrote unit/integration test cases and done the unit testing/ Integration testing to achieve the functionality.
• Architected and implemented enterprise and business segment OIM solutions
• Extensive hands on experience using Confidential 10g, Confidential 9i, Sybase and SQL Server databases and several of its tools.

Confidential, Atlanta GA

Senior Database Developer

Responsibilities:

• Gatheird the requirements from the various stakeholders across the Confidential .
• Performed the data analysis and Business requirements and rules
• Prepared the Technical specification documents and flow diagrams
• Involved in the functional requirement specification and preparation of supporting documents
• Developed PL/SQL procedures, functions and packages for processing business logic in the database.
• Prepared the Unit Test Cases and coordinated wif the QA team to test the test cases.
• Developed advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning wif implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Performed Query Optimization, Performance Tuning and provided DBA solutions in complete System Development Life Cycle.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Designed and developed Confidential forms & reports generating up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.

Environment: Confidential 10g, Linux E 2.4, TOAD 7.6

Confidential, Redwood Shore, CA

Senior Database Developer

Responsibilities:

• Resolved the daily production issues on Confidential, PL/SQL and LDAP (working on tickets).
• Involved in bug fixes of the application on Priority.
• Responsible for project planning and managing a full lifecycle APS implementation of Identity Matching (Discovery through Production) using Initiate Master Data Service as subscriber data warehouse and identity matching engine.
• Developed Solution Architecture pertaining to overall Enterprise and Business Architectural models.
• Responsible for planning and managing a technical team consisting of 8 resources in identification and remediation of incorrect SSO data for all the Confidential users. Incorrect and orphan Identity data scrubbed and/or corrected prior to launch of automated provisioning application implementation.
• Road mapped 5-year Identity and Access Management architecture and work streams for presentation
• Implemented Confidential Identity, Access, Identity Federation and Role Manager (previously Bridgestream) in a Proof of concept environment.
• Integrated Confidential software FW products wif customers’ target applications. Demonstrated & supported product functionality for customer evaluation.
• Performed Query Optimization, Performance Tuning and provided DBA solutions in complete System Development Life Cycle.

Environment: Confidential 10g, Linux E 2.4, TOAD 7.6

Confidential, Redwood Shores, CA

Oracle Developer

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting using Parallel Queries, Java stored procedure, HTP Package and WEB.SHOW DOCUMENT.
• Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning wif implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Performed Query Optimization, Performance Tuning and provided DBA solutions in complete System Development Life Cycle.

Environment: Confidential 10g, Linux E 2.4, TOAD 7.6, SQL developer

Confidential, Redwood Shores, CA

Programmer Analyst

Responsibilities:

• Debugging PL/SQL Procedures, Functions and Unix Shell Scripts.
• Maintaining Confidential Business flows of the application.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along wif PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Confidential Hints, for Rule based optimization.
• Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
• Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Confidential 10g, Linux E 2.4, TOAD 7.6, SQL developer, SQL* Loader

Confidential, Redwood Shores, CA

Programmer Analyst

Responsibilities:

• Gatheird information required for this project.
• Developed and maintained project plans and milestone deliverables.
• Delivered test strategies across multiple businesses streams and implemented these strategies.
• Coding PL/SQL Procedures, Functions, and Packages UNIX Shell Scripts whenever required.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Maintaining Confidential business flows of the application.
• Tested each and every possibilities of the System on TEST and STAGE Instances. Delivered the Project on time to the customer

Environment: Confidential 10g, Linux E 2.4, TOAD 7.6, SQL developer, SQL* Loader

Confidential, Richmond, VA

Consultant

Responsibilities:

• Debugging and Fixing PL/SQL scripts, Unix batch jobs and INFORMATICA sessions. Writing procedures and packages.

Environment: Confidential 10g, Linux E 2.4, TOAD 7.6, SQL developer, SQL* Loader, Informatica