SUMMARY

• 9 years of extensive IT global delivery model experience involving Business analysis, design and development, testing and Production support for data intensive back end applications and Data warehousing/Business intelligence projects
• Extensive experience in developing Solutions using Oracle PL/SQL Packages, Procedures, Functions, Triggers, Views and manipulate complex data in Oracle Databases
• Excellent knowledge in developing UNIX Shell Scripts for process automation
• Extensive experience with SQL*Loader((Conventional, Direct Path Loads), custom PL/SQL for batch processing
• Excellent skills in gathering and analysing business needs and converting them into technical solutions
• Experience in advancedPL/SQLconcepts for Bulk Operations using Bulk collect, Bulk Exception, Collection and FORALL
• Performance tuning of SQL and PL/SQL using HINTS, Explain Plan, Tkprof, Partitioning, Indexing and Join Optimization
• Performed Data Profiling and data Quality as a data analyst
• Solid Understanding of Data Warehousing Concepts
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users
• Experience in creating documentation like Source - Target Mapping (STM) documents, Run books, functional requirements and technical design documents
• Extensively worked in an Agile and Prince 2 Foundation environment
• Lead a team of 5 developers on various time critical projects for entire SDLC
• ITIL v3 Foundation Certified

TECHNICAL SKILLS

Database & Tools: Oracle 11g/10g, SQL, PL/SQL, mod PL/SQL, Oracle Reports 10g, Control-M, Crontab, SQL *Loader

Web: HTML, JavaScript, XML/XSLT, PL/SQL Web toolkit with HTP, HTF

Configuration & Testing: PVCS, CVS, VSS, PVCS Tracker, HP Quality Centre, BMC- Remedy,StarTeam2008, Rally

Modelling: UML, Visio, Toad, Erwin, Pencil (UI Mock up tool)

Others: SQL Performance Tuning, Performance Testing, UNIX Shell Scripting, Informatica 9.1,Prince 2, ITIL, Scrum(Agile)

Domain: Wealth Management, Manufacturing, Financial Services- Regulatory

PROFESSIONAL EXPERIENCE

Confidential, Oaks, Pennsylvania

Sr. Oracle PL/SQL Developer

Responsibilities:

• Understand and analyse the trust bank’s data inputs and migrate them to the Confidential platform standards
• Understand the working and functionality of the Confidential platform
• Work with BA’s to design the data mapping process from source to target
• Perform Data Cleansing, Data Analysis/Profiling on source data(de-normalised)
• Write SQL to Test source data validity for established standards
• Write PL/SQL Packages comprising complex SQL for Source to staging and then to target table mapping
• Extensively Use Joins, Analytic functions, Aggregate functions, Correlated sub queries, Sub Query Factoring to develop solutions
• Use SQL*Loader for ad-hoc data loads received from customer
• Use control-M for Scheduling delta loads and executing SQL test scripts
• Write complex SQL queries using Joins, Analytic function, aggregate functions to test the PL/SQL programs as there is no UI available for testing
• Use SQL queries to filter and manipulate data in Performance Testing
• Extensively Performance tune the Queries Looking at creating optimal joins, using Hints, WITH Clauses
• Perform Defect analysis and fix the issues raised by end users
• Reverse engineer to standardize some of the PL/SQL Code into Informatica
• Work in a fast agile(Scrum) environment for data migration ETL development

Confidential, Holland, MI

Oracle PL/SQL Developer

Responsibilities:

• Work with Business system analyst (BSA) to understand and gather the requirements
• Document Business Requirements into detailed functional and technical specifications and test cases
• Create/Modify database objects like Tables, Indexes, Sequences and Views to meet the expanding business requirements.
• Involve in design, development and modification of PL/SQL stored procedures, functions, packages and triggers
• Write complex SQL queries using joins, sub queries and correlated sub queries
• Loading of the data from flat files into staging tables using SQL* Loader
• Involve in Database Tuning to improve application performance using Explain Plan, TKPROF and SQL trace
• Batch processing using Unix shell scripting
• Write Pl/SQL interface programs to generate custom data reports as Flat files
• Performance testing and performance tuning
• Work closely with the test team and manage User Acceptance Testing(UAT)
• Involve in Documentation, Warranty and Post Production Support

Confidential

PL/SQL Developer

Responsibilities:

• Create Technical Specification document according to Functional Specification document
• Develop PL/SQL interfaces to internal and external systems involving critical data as per business rules and sensitivity
• Involved in investigating the production issues by using the SQL scripts to fetch the data
• Create complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins, Sub Queries to implement business rules
• Extract data from flat files and oracle database, apply business logic to load them in the central oracle database
• Ensure standardization, data quality(de-duplication) and data correctness
• Modify existing report enhancements using Oracle Reports 10g
• Use SQL queries to filter and manipulate data in Performance Testing
• Provide extensive UAT support for the core PL/SQL components and the UI which is also written using mod PL/SQL web interface
• Created DB links for connecting to remote databases
• Maintain change documentation, interact with business users
• Modify and extensively test all the data critical PL/SQL interfaces from the system
• Create Unix shell scripts to call PL/SQL programs for new interfaces to the system
• Additional responsibilities as ITIL Change and Release Manager for the application
• Ensure SLA Compliance for Production issues

Confidential

PL/SQL Developer

Responsibilities:

• Understand the core application and customised application of the Lawson Professional services module that involved timesheet management, budget management, employee On -boarding and dashboards written using custom HTML and oracle PL/SQL
• Develop various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL
• Create DB links for connecting to remote databases
• Develop SQL queries for application testing
• Fix bugs reported by the customer and as well as part of the internal findings within the specified timeframe
• Create and maintain Unit test plans and reports
• Suggest and develop enhancements to the existing system
• Create and maintain documentation of all changes to the system