We provide IT Staff Augmentation Services!

Sr. Pl/sql Developer Resume

5.00/5 (Submit Your Rating)

SUMMARY:

I am an experienced leader with broad analysis, testing and reporting skills; practised in clarifying business requirements, analysis, testing and dealt with processes to improve business productivity and reduce operating cost. I have strong interpersonal skills, negotiation, facilitating discussion and negotiation with stakeholders. I have work on bespoke, individual projects and/or multinational projects spanning the globe and costing billions of pounds.

TECHNICAL DEVELOPMENT AND SUPPORT KEY SKILLS:

Software Development: Waterfall, Agile Scrum

Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008/2012 , MS Access

Programming Languages: SQL, PL/SQL, T - SQL, UNIX Shell, VBA, VB 6.0, JAVA, C/C++/C#

Web programming: PHP, Java script, CSS, JSP, ASP, ASP.NET, HTML/XHTML/DHTML

Operating Systems: Windows NT, Windows 2000, MS-DOS, Linux, UNIX AIX/HP-UX

Oracle: APEX, SQL Developer, SQL*Plus, SQL Loader, Toad for Oracle, OBIEE suite

SQL Server: SQL Server Management Studio, Business Intelligence Development Studio

ETL: Informatica, SQL Server Integration Services (SSIS) 2008

Reporting: SQL Server Reporting Services (SSRS) 2008, Hyperion, Crystal Report, SAP Business Objects

SAP: ISU, ABAP, BADIs, SAP Procedure/OOP, Functions/Methods .

Siebel: Siebel eEnergy v6.3, EIM

Data Quality: Experian QAS

Data Modelling Methodologies: ER Diagrams,, Physical and Logical design

Data Modelling Applications: MS Visio, Rational Rose, Erwin

Development Testing: Unit testing, Integration testing, System testing

Technical Documentation: Data Profiling, Data Modelling, Data Mapping, Data DictionaryETL Test Case, Requirements Specification, Technical Specification

Data warehouse: OLAP, data marts, cubes

Planning and Costing: Primavera 8.1 Client, Primavera API 7.0, Primavera 8.0 +

Project Management: PRINCE2, Agile Scrum

Modelling Methodologies: UML v2.0 (Use Case and Activity Diagrams)

Agile Project Mgt. Tools: Mingle

Project Planning Applications: MS Project

Business Process Modelling App: MS Visio, Rational Rose

Office Applications: MS Word, MS Excel, MS PowerPoint

Functional Testing: UAT, Performance testing

Business Analysis: Requirement Gathering, Business Process Reengineering, Gap- Analysis, Change Management, Workshop facilitation and deliveryEnd user training

EXPERIENCE:

Confidential

Sr. PL/SQL Developer

Environment: ETL, Excel/VBA, SQL/T SQL, PL-SQL, SSIS, UNIX, OBIEE 10g/11g, RPD, BIP, Tableau, Oracle Reports and Form 11g, ODI 11g, APEX 5, Informatica, Oracle SOA Suite, Jaspersoft, PowerBI, Web Services Integration, SQL Developer, SQL Modellar, Toad for Oracle, UNIX Shell Scripting

Responsibilities:

  • Business Analysis to define the end-to-end process of ETL, Design, Project Plan.
  • Gather business requirements to have the clear business rules to transform the data, develop Reports, Dashboard etc.
  • Developed test scripts for the Unit, System testing, and later stage worked closely with Tester to make sure BIP/OBIEE Reports, Dashboard and KPI meets business need.
  • ETL functions to load the legacy data and then transform and load the data into the new system EPPM using various APIs and SQL*Loader.
  • Data analysis and data cleansing using PL/SQL and VBA. (Developed Business rules for external contractor to perform xls based cleansing for legacy data).
  • SSIS package developed to spit out FLAT FILE on to network location with the help of COBRA (COST) team.
  • Oracle SOA integration with P6, APeX and COBAR for robust access and lower TCO.
  • PL/SQL and UNIX script developed to read N/W location to process FLAT FIELS based on Confidential reporting cycle.
  • Develop Data Mapping, Data Modeling, and Documentation.
  • DWH design using hybrid methodology, COST, RISK and Contract management data marts developed based on business requirement.
  • Dynamic PL/SQL script to create Dimensions and Facts and populate DWH (with code optimization).
  • 21 MI reports developed using Oracle 11g BI Publisher.
  • RPD Design and Development for OBIEE reporting, which would be later used by Confidential IT for reporting.
  • Custom Build DWH integration with ODS and P6 (R8.3) integration to populate dimension and Facts.
  • Involved in other small-scale reporting on Data migration from contractor DB to NG DB data anomalies reporting.
  • I was involved in various forms of testing e.g. regression, load, unit and UAT.
  • Visualization, reports and KPI on Data lakes using Tableau.
  • ODI 11g were heavily used to run the ELT jobs - later on upgraded to ODI 12c
  • Data Lake Design, development and testing using Informatica with Tableau used for Visualization
  • APEX Application development which helped Capital Delivery a work flow forms using Java script, CSS, HTML, PL/SQL AJEX etc
  • APEX Change Control Web Integration with ODI to pump data into the DWH
  • Developed Risk/RDL reports, Dashboard via Jaspersoft.
  • Connections with different data sources SQL Server, Oracle in Jaspersoft to create flat files feed for EDW.
  • Optimized SQL and Japersoft reports when running reports and data output.
  • Integrated RESTful Webservices via OBIEE and BIP to expose data seamlessly to NG mobile users in agile way.
  • Java application built to roll up cost from lower level of cost to higher level via P6 API.
  • Physical Data modelling in SQL developer for EDW and Data Marts.

Confidential

Data Migration Specialist

Environment: ETL, Excel/VBA, SQL/T SQL, PL-SQL, SSIS and SSRS, SSAS, SOAP/Webservices Integration

Responsibilities:

  • SSIS package developed with embedded C#/ CLR functions to read a network location and import data into production- it also makes sure only cleanse data is loaded into production i.e. correct UK format phone, email address and assign to correct campaigns. Package has DB level configuration with HTML emails (using T-SQL procedure) to send email on each successfully data load.
  • Developed Regular expression in C# which later deploy through SQL Assembler to perform data cleansing.
  • Various C# classes developed for cleansing i.e. Postcode, email, phone number.
  • Developed SSIS/T-SQL to take import feeds form Access and then T-SQL to logically suppress existing customer to improve productivity.
  • Developed various procedure/function to perform physical deletion for duplicate customer to improve SSP productivity and reduce the wait call time.
  • Logical suppression of existing records based on business model I.e.not SME, restricted sectors, duplicate records.
  • Procedure developed to convert NTEXT to XML and the split XML data into columns to analyse data i.e. data sources, territorial Sales managers.
  • Developed forecast model using t-SQL and SSRS.
  • Developed various KPI reports using SSRS/Report Builder 3.0.
  • DWH solution developed to handle growing BI needs.
  • Cleanse Legacy DB using PL/SQL for various existing KPI and migration.
  • I was lead on in the quality assurance stage of software development and deployment - conduct automated and manual tests to ensure the ETL is fit for purpose
  • Integrated 3 rd Part Webservices feed via SSIS to pump data into the DWH

Confidential

Data Migration Specialist

Environment: Oracle (SQL/PL-SQL)11g, ETL, UNIX, VBA/Excel, Mercury/HP QC, Java, OBIEE/BIP 10g, ODI 10g, Informatics, OoD

Responsibilities:

  • Business Analysis to define the end to end process of cost and schedule data.
  • Gather the business requirements to have the clear business rules to transform the data.
  • Data analysis to perform the data cleansing using PL/SQL and VBA.
  • Develop SQL*Loader to load the legacy data on to the staging area.
  • Develop PL/SQL code to transform the legacy data using PL/SQL and Unix
  • Develop test scripts for the Unit and System testing.
  • ETL functions to load the legacy data and then transform and load the data into the new system EPPM using various APIs and SQL*Loader.
  • Developed the system and unit test scripts in Mercury/HP QC.
  • Database design for dev and test environment for data staging to perform development, transformation and testing.
  • Loading the data from various sources into the test and dev environment for transformation and loading into ERP (EPPM/Primavera 6) using Java.
  • Design and construction of archival solution with front end tool as excel with integrated VBA/SQL.
  • Modified existing Data migration java standalone application code to meet the business requirement to move the data from the staging area on to EPPM (Primavera 6)
  • Developed Loader in Java to migrate the data from staging Oracle Staging area to P6 (EPPM) using primavera java APIs.
  • RTF/excel reports for OBIEE 10g

Confidential

Data Developer

Environment: Oracle (SQL/PL-SQL), T-SQL, Java, XML, ETL, UNIX, SSIS, ABAP, SSAS, Incident Management, SSRS, VBA/Excel, Informatics Power Centre

Responsibilities:

  • Working on delivering operational and strategic project change through data jobs and ad-hoc reports on various systems as raised by the business using Oracle, UNIX, SQL Server and ABAP.
  • Dimension and data modelling using Erwin or MS visio.
  • Tweak and fix the existing code written in JAVA/J2EE.
  • Develop MI reports using Excel, VBA and SSRS.
  • Custom VBA forms created to help automate the population of spreadsheets and provide data validation and the application of business rules.
  • Upgrade/tweak the existing VBA code; so, the code can handle the next release i.e. excel 2010.
  • Automate the existing report using VBA and linked to various data sources i.e. Access/SQL Server 2008.
  • Work on Incidents/ adhoc fixes using various tools e.g. Unix, Oracle, SAP front end, SAP ABAP etc
  • Actively participate in ETL activities using SSIS packages from SAP and Oracle Siebel.
  • Migrate data from Siebel CRM to SAP-ISU, SAP CRM in order help simplify their customer acquisitions process and enhance the quality of service given to their customers.
  • Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc
  • Developed dashboard and reporting suite for internal and external stakeholder using SSRS.
  • Automate existing reporting suites using SSRS and job schedule to produce KPI’s in timely manner.
  • Investigating source data and understanding existing code and logic used/called to identify errors and enable robust solution design.
  • Provide data solutions for comparison and matching both within and across core systems and data marts.
  • Data profiling of customer and product data to provide metrics on data quality/health and understand risks and challenges for project data work streams using SQL, T-SQL.
  • Assist in the ongoing enhancement of a central Data warehouse solution that will support dashboard reporting and drill down.
  • Responsibility for project deliverables using either Agile or Prince related delivery mechanisms, including participating in project control forums such as Scrums, progress meetings, RAID analysis etc.
  • Trigger data refresh across core reporting/analysis databases to provide working datasets for further analysis and fixes to the wider data team.
  • Data cleansing, root cause analysis on core systems using SQL/PL-SQL, UNIX and ABAP.
  • Develop ABAP code to cleanse data in ISU and CRM.
  • Data Migration from various using tool i.e. SQL*Loader, Unix scripts, SSIS, CTL files etc.
  • Unit testing and functional testing of the code before moving the code from Dev Environment to Production with an evidence of resolution document for business cases.

Confidential

Sr. PL/SQL Developer

Environment: Oracle (SQL/PL-SQL), Crystal report, Hyperion 9BI+, Excel/VBA, UNIX, ETL, Data Warehouse

Responsibilities:

  • Analysing and reporting for domestic customers with various attributes i.e. deceased profiles, reading trends, PARMS etc.
  • Analyzed and reported on the performance of settlement in particular, looking at trends and factors affecting performance to mitigate the risks.
  • Actively perform MI and works with operational business to implement changes with positively impact percentage performance for retail business.
  • Provide expertise in the design, development, analysis and delivery of reports and data fixes.
  • Handled ad-hoc requests to provide KPI in timely manner to mitigate the risks for internal and external stakeholders.
  • Examine the enhancement of business functions and processes, and design solutions, using formal analysis and design methods and documentation.
  • Proactively identify developments that will lead to process enhancements within the Data Quality teams and wider Retail business.
  • Managed all aspects of bulk data fixes using SQL, PL-SQL, and UNIX.
  • Developed reports using Hyperion and OBIEE suite to monitor the readings and settlement KPI
  • Have been involved in major Data warehousing projects as Siebel Analytics Developer , OBIEE Developer , OBIEE Administrator, Report writer, Discoverer developer with very large database.
  • Played pivotal role for the meter installation and special read project where plan was to compare the Data Collector metering details with MOP and other MOP data and where possible bulk fix B-Smart and ICE using fuzzy logic. The project itself was a huge success as it helped to aligned Metering details (D0149/D0150) flows using PL/SQL and shell scripting through our gateway which helped to improve the settlement performance and improve the DC normal and special reads.
  • Analyzed the data across various systems to find out the reason of data developed plan to bulk align the data which help to align the Eon reads across multiple systems and improved the data quality and health which ultimately leads to improve the NPS and reduce the settlement charges. This solution leads four Confidential license above par and lead to save around £1.6 million.
  • Proposed the solution of automating the various reporting suite for retail management which would help to make correct and timely decision. Reporting suite was developed using PL-SQL with embedded XML and HTML which helped management to underpin various process.
  • Analyzed and developed automated solution which helped business to improve the business sector with correct billing cycle and area.

We'd love your feedback!