PROFESSIONAL SUMMARY:

• 9 years of experience as Oracle PL/SQL Developer in Oracle 11g, 10g, 9i & 8i versions and IT experience in Software Development/Maintenance & Support Projects
• 4 years of experience in handling multiple projects
• Experienced in Requirements Gathering and Preparing Use Cases
• Comprehensive and in depth experience using the System Development Life Cycle(SDLC)
• Expertise in working with Projects in Agile Methodology
• Developed tasks for SCRUM sprint meetings in Agile Methodology
• Good exposure to Development, Testing, Production Support, Debugging, Implementation and Documentation
• Expertise in handling Production Support projects
• Technical areas of experience related to PL/SQL, UNIX, PERL & Shell Scripting
• Experienced in complete life cycle Implementation of PL/SQL Development
• Extensively worked with SQL statements optimization, assisting in developing and writing appropriate QA procedures, Cursors, Stored Procedures, Triggers, Functions, Packages, Query Optimization & SQL Tuning
• Performance tuning and optimization using Explain Plan, SQL*Trace, TKPROF and Oracle Optimizer hints
• Experienced in PL/SQL Performance Tuning using Bulk Collections and other optimization techniques
• Expertise in Data Integration of data from various data sources like SQL Server, Oracle, Flat Files, and XML files and Data Migration
• Experienced in working with high availability and scalability databases
• Experienced in importing data from SQL Server and Flat files to Oracle DB using SQL Loader
• Creating Users, Roles and Profiles, Privilege management with role - based security
• Maintenance of user accounts and privileges to maintain database security
• Experienced in performing basic Oracle DBA activities like importing and exporting schemas between databases
• Experienced in performing Oracle DBA monitoring activities
• Expertise in Data Warehousing and ETL concepts
• Good Exposure to Informatica Transformation concepts
• Strong Team Building & Leadership capability and excellent Mentoring Skills
• A self-motivated, responsible and reliable team player with a set of strong technical skills
• Strong conceptual, business, analytical skills and innovative problem solving abilities
• Good communication, interpersonal and problem solving skills

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/2003, UNIX, Red Hat Linux 9

Databases: Oracle 8i/9i/10g/11g/12c, MS-Access, SQL Server, MongoDB

Database Tools: Import/Export, SQL*Plus, SQL loader, Explain plan & TKPROF, T-SQL, TOAD, Data Pump

Languages: SQL, PL/SQL, HTML, XML

Scripting: Cron scheduling, Vi Editor, Shell, Perl Scripting

ETL Tools: Informatica 7.0/8.5/9.0

Analytical Tools: Lavastorm BRE

Reporting Tools: webFocus

Version Control Tools: IBM Rational Clear Case, Dimensions

Service Desk Tools: HP Service Desk, BMC - Remedy, Rally

SCM Tools: I2/JDA SCM Tool

PROFESSIONAL SUMMARY:

Confidential, Pittsburgh, PA

Sr. Technical Analyst

Responsibilities:

• Estimate, plan, execute and monitor Projects
• Weekly status calls with the Business team and Management team
• Maintain multiple projects
• Gather requirements for change requests with the Business team and create design documents
• Prioritize the work as per Management team and deliver the results in timely manner
• Track and Mitigate risks in the project
• Provide User Access to Business End Users to the Front end tools after getting the required approvals
• Change data in Production Database after getting the Director’s approval for the proposed change
• Create PL/SQL packages for implementing Change Requests for adding new functionality to the application
• Create Informatica worflows (7.0 for Flat Roll/9.0 for Tubular implementations) for implementing business logic
• Worked on Sessions & workflows for variety of loads starting from Source to Target
• Created Parameter Files to override session properties for source directory, Bad file Directory, Source, Target & created Mapplet parameters for Mapplets
• Create Perl & Shell scripts for automating the business logic
• Create ABPP (Agile Business Process Platform) workflows which sequences the execution of Oracle Packages, Informatica workflows, Perl and Shell scripts as per the business logic
• Deploy the code across the environments to main code consistency and update the same in Clear Case for version control
• Create Test Cases for verification and validation of the Change Requests

ENVIRONMENT: Oracle PL/SQL, Informatica, ABPP, UNIX, Shell & Perl Scripting

Confidential

Technical Lead

Responsibilities:

• Create Use case documents for the functional requirements for the Change Request
• Setup Sprint calls with the End User for Change Requests
• Weekly calls with the Business and the Management for maintaining Change Requests
• Daily status calls with the end users during the Requirement Gathering phase to mitigate risks
• Bring new projects by identifying areas of improvements during discussions with Management team and Business Users
• Help Developers in translating requirements during coding
• Deploy Code across all environments and upload the code in Dimensions tool for version control
• Gather requirements from End Users and SME’s regarding the Change Request and create High Level and Low Design documents
• Create PL/SQL Packages which contains Cursors, Exceptions, Procedures and Functions to load the daily, weekly and monthly data into the database table.
• Performance tune End user SQL queries using Explain plan with TKPROF and Oracle Optimizer hints
• Performance tune DML statements for fetching and loading data into the Oracle database tables using Bulk Binds logic
• Create Range Partitions based on load date and maintain List/Range sub-partitions for different Circuit ID’s for Vendors
• Create DML Triggers for updating the audit tables for DML activities on the master tables
• Create Views for Master tables and Materialized views from DWH tables for End User Queries
• Load data from Flat files from Legacy Mainframe Applications using SQL Loader scripts
• Responsible for creating users, granting roles and privilege management
• Perform SQL Testing for verifying proper loading of data in the DWH tables
• Create adhoc PL/SQL blocks for User requirements
• Resolve the database issues of the users whenever in need of
• Provide Data Integration Support by integrating data from all the different systems using the Lavastorm Business Rule Editor(Lavastorm BRE) and load the data in DWH tables
• Perform Data Integration activity, Data Quality Management and Data Analysis activities using Lavastorm BRE Analytical Tool
• Create Revenue reports for end users using webFocus reporting tool
• Created POC for the migration of Lavastorm BRE graphs to Informatica PowerCenter 9.X
• Create Unit Test cases for verification and validation for the Change Request
• Created automation scripts in Shell & PERL Scripting
• Create comprehensive documents of the changes made for the end users

ENVIRONMENT: Oracle 11g, Agile, SQL, PL/SQL, Lavastorm BRE, Informatica, UNIX & Shell Scripting

Confidential

Oracle DBA & Developer

Responsibilities:

• Provide the Project Playbooks and the Component Release Notes (CRN’s) for new projects and Change Requests
• Provide Environments for new projects
• Deliver the components using the Clearcase tool
• Create PL/SQL code for implementing the application logic
• Ensuring security of the database by creating profiles for each user and monitored the user sessions.
• Reporting and resolving all serious Oracle alert log messages
• Responsible for enhancements depends on the client’s functionality.
• Interaction with Development Team in fine tuning the SQL and PL/SQL code.
• Resolve the database issues of the users whenever in need of.
• Created SQL scripts for static data, views, and synonyms
• Provide Performance Tuning Support to the Client Sql queries

ENVIRONMENT: Oracle 11g, SQL, PL/SQL, UNIX & Shell Scripting

Confidential

Senior Software Engineer

Responsibilities:

• Creating database objects and worked on implementation of the objects.
• Created the required PL/SQL package for the Migration of XML data to Oracle tables
• Created stored procedures, functions, triggers and packages.
• Involved in the end-user training activities.
• Took part in the Unit testing of the Project
• Took part in defect fixing during the Integration Testing Phase of the Project

ENVIRONMENT: Oracle 11g, SQL, PL/SQL, UNIX & Shell Scripting

Confidential

Senior Software Engineer

Responsibilities:

• Created data flow diagrams and Pseudo codes for the proposed data migration plan
• Took part in the Analysis and Design phase of the Project and created the Source to Target Matrix document
• Analyzed the existing Legacy code and proposed changes for the data migration
• Created Informatica workflows for data migration and integration from Wyeth Compound and Structure Information database to Pfizer database
• Involved in importing Src/Tgt from respective DB and created mappings, and reusable transformations using Informatica PowerCenter tool
• Involved in the Unit testing to check the data consistency
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization
• Transformations like Expression, Router, Joiner, Lookup, Update Strategy, and Sequence Generator were mainly used
• Created Oracle PL/SQL packages to implement the data migration from Pfizer to Wyeth system
• Performed extensive data profiling to cleanse the unfit data from the migration process
• Created and performed Unit test scripts in the Staging environment

ENVIRONMENT: Oracle 10g, SQL, PL/SQL, Informatica 8.5, UNIX & Shell Scripting

Confidential

Senior Software Engineer

Responsibilities:

• Developed Procedures and Packages to validate Business Rules
• Developed queries for data analysis for the above mentioned applications
• Maintained Oracle 9i databases for the above mentioned applications
• Implement EDI setups in Gentran Translation Server and web Methods XML gateway
• Proactively monitor the data flow for all the applications to make sure everything is running smoothly
• Monitor all the health-check alerts and the connectors for connectivity issues
• Identify and resolve EDI translation errors using the EDI maps
• Worked with Technology Partners in developing and implementing AS2 certificate for the Cyclone and web Methods gateways
• Worked in conjunction with geographically separate teams all over the world
• Trained HP Business Users and Technology Partners in using the application interfaces with the aid of video & PowerPoint presentations

ENVIRONMENT: Oracle 9i, SQL, PL/SQL, EDI, WebMethods, XML, Gentran, UNIX & Shell Scripting

Confidential

Software Developer

Responsibilities:

• Gather requirements and prepared functional requirements and technical specification documents
• Develop PL/SQL code for the Application logic
• Implement the connection between the Oracle 8i database and the front-end Clarion application
• Develop and designed GUI screens to output the results
• Create test cases and test plans from the functional requirement documents. Performed unit testing and user acceptance testing

ENVIRONMENT: Oracle 8i, SQL, PL/SQL