SUMMARY:

• Overall 15 years of IT experience as Project manager and Architect in Oracle Products.
• Provides leadership in the establishment and development of project base line budgets resource allocation and schedules in individual and group situations
• Experience in developing the packages Procedures function triggers using SQL and PLSQL
• Experience in creating large partitioned table using the range partition technics.
• Working experience in the Dynamic SQL Collections external tables
• Working experience with the oracle supplied packages Records and tables. Loaded the data into tables using the SQL Loader.
• Experience in creating shell scripts for invoking SQL scripts and scheduling them using Crontab.
• Experience in controlling the User Privileges and monitoring the Security and Audit issues.
• Experience in the Project Management methodologies Project delivery People management and project inventory and accounting.
• Experience in driving implementation of best agile practices: dynamic team collaboration informative metrics lean development continuous improvement
• Worked with Scrum teams to create/update stories and communicate them to the scrum masters.
• Actively contribute to the continuous improvement of project framework and to the successful organizational transition to Agile

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Tech Lead/OnSite Project Manager

Responsibilities:

• The Project Manager develop and maintains a thorough knowledge of business processes supported by software systems
• Requirement Gathering Effort Estimation and Analysis impact.
• Driving Project deliverables to completion from a Technical/Functional perspective.
• Tuning of queries for better performance.
• Manages outsourced work consultants vendors and relationships
• Proactively identifies and tracks project risk and develops mitigation plans to manage risk
• Vendor connectivity testing and fixes
• Document reviews and sign offs

Confidential, Charlotte NC

Sr. Oracle Tech Lead

Responsibilities:

• Requirement Gathering Effort Estimation and Analysis impact.
• Work with 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.

Confidential, Buffalo NY

Tech Lead Plsql Developer

Responsibilities:

• Develop implement and manage team metrics evaluate team metrics and make recommendations to teams and management for improvements
• Work with program manager to manage support or create project budgets
• Work with Product Management to understand the priority features and fixes and cascade this information to Developers
• Requirement Gathering Effort Estimation and Analysis impact.
• Work with 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.
• Coordinate with the support teams for rollout 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

Project Team Lead / Sr.Developer

Responsibilities:

• Requirement Gathering Effort Estimation and Analysis impact.Work with 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.

Confidential, Charlotte NC

Senior Data Consultant

Responsibilities:

• Involved in analyzing the business and 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 with Prod and QA.
• Wrote unit/integration test cases and done the unit testing/ Integration testing to achieve the functionality.
• Extensive hands on experience using Oracle 10g Oracle 9i Sybase and SQL Server databases and several of its tools.

Confidential, Atlanta GA

Sr. Manager to Projects / Delivery Lead

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 SQLTRACE 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 oracle 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.

Confidential, Atlanta GA

Senior Database Developer

Responsibilities:

• Gathered 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 with 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 with 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 Oracle forms reports generating up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.

Environment: Oracle 10g Linux E 2.4 TOAD 7.6

Confidential, CA

Senior Database Developer

Responsibilities:

• Resolved the daily production issues on Oracle 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 Oracle users. Incorrect and orphan Identity data scrubbed and/or corrected prior to launch of automated provisioning application implementation.
• Road mapped 5year Identity and Access Management architecture and work streams for presentation

Environment: Oracle 10g Linux E 2.4 TOAD 7.6

Confidential

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.SHOWDOCUMENT.
• Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.

Environment: Oracle 10g Linux E 2.4 TOAD 7.6 SQL developer

Confidential

Programmer Analyst

Responsibilities:

• Debugging PL/SQL Procedures Functions and Unix Shell Scripts.
• Maintaining Oracle 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 SQLPlus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with 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.

Environment: Oracle 10g Linux E 2.4 TOAD 7.6 SQL developer SQL Loader

Confidential

Programmer Analyst

Responsibilities:

• Gathered 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.

Environment: Oracle 10g Linux E 2.4 TOAD 7.6 SQL developer SQL Loader

Confidential

Consultant

Responsibilities:

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

Environment: Oracle 10g Linux E 2.4 TOAD 7.6 SQL developer SQL Loader Informatica