SUMMARY:

• 10 Years of IT experience in application development focusing on data analysis, OLTP, data warehousing, business intelligence and analytics solutions. Successfully executed multiple full lifecycle data warehouse/ business intelligence initiatives.
• 10+ Years of experience in design and development of data warehousing & OLTP applications using Oracle database on UNIX platforms and reporting tools like business objects.
• Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, design architecture, development, unit testing, systems integration and user acceptance testing
• Extensive experience in design and development of ETL programs for the data warehousing applications using popular ETL tools like Datastage, PL/SQL, SQL, External tables, SQL*Loader & related tools.
• Expertise in design and development using PL/SQL packages, procedures, triggers and functions, views and management of schema objects.
• Experience of working in large volume data warehouses. Worked with portioned tables, indexes, materialized views and analytical functions.
• Expertise in optimizing and tuning of SQL Queries and PL/SQL applications.
• Expertise in Shell Programs using Korn Shell and developing batch programs and automating them using scheduling tools
• Extensive experience in development of Business Objects reporting applications. Worked on designing and developing the BO Universes, BO/WEBI reports, Broadcast Agent and administering BO Activities/Repository.
• Strong experience of complete software development life cycle and software quality procedures and practices.
• An efficient self-starter and quick-learner with effective interpersonal and negotiation skills.

TECHNICAL SKILLS:

Operating Systems: UNIX (HP UX 10.2/11.0 ),Linux, Windows NT/2000, MS DOS

OLAP Tools: Business Objects 6.5/5.1/4.1, BO Reporter, BO Explorer, Designer, Broad Cast Agent Server

Oracle Tools: Oracle 8i/9i,10g,11g, 12c, PL/SQL, SQL *Loader.Toad, Plsql Developer, SQL Developer

ETL Tool: Data Stage 7.1.5,Informatica 8.6,SSIS

Software Tools / Languages: Java, Visual Studio 2017, C++, UNIX Shell Programming

Hardware Platforms: DEC-Alpha Server, HP UX Servers, IBM PC Compatibles

Concepts/ Methodologies: Data Warehousing design and development, Data modeling, Logical and Physical Database Design

Web Technologies: HTML 4.0,Coldfusion 5/MX, Java Script, JSP

PROFESSIONAL EXPERIENCE:

Confidential, Trevose, PA

Sr. Oracle PlSql Developer

Responsibilities:

• Working with business analysts to translate specifications into code.
• Coding of business rules.
• Developing scripts to create extract files
• Worked with Data Quality Assurance team
• Designed Testing scenarios and performed unit-testing.
• Bringing new Affinity on board to core system. Processes involve intake of data from affinities. Extracts include data validation entities as well as client reporting.
• Used PL/SQL stored procedures, packages, triggers, functions to manage data.
• Production support

Confidential, Yardley, PA

Sr. Oracle PlSql Developer

Responsibilities:

• Worked with Project Manager to understand and document project requirements.
• Analysis and Development of Data structure (tables and indexes)
• Worked with Data Quality Assurance team - Developing scripts to create data files for QA
• Designed Testing scenarios and performed testing.
• Developed SSIS packages for generating targeted data and automated process using job scheduling.

Confidential, NJ

Oracle PL/SQL Developer

Responsibilities:

• Worked with business analysts to understand the business requirement, participated in technical design and developed the technical specification.
• Developed PL/SQL Packages, Stored Procedures, Functions, Triggers and Complex SQL Queries for loading the data from data providers and applying the business rules needed according to the user requirements.
• Worked with the data modelers & data architect on the database design, participated in design reviews and created the DDLs.
• Developed the data loading routines using utilities like SQL* loader & developed the transformations using PL/SQL packages.
• Developed the UNIX Shell programs (ksh) to call the SQL loader and invoke the oracle packages and automated the jobs.
• Used Business objects to develop various master/detail, cross tab, drill down, slice and dice reports.
• Worked with the support team and the DBA team during the deployment and co-coordinated the release activities.
• Provided technical support to the users and created run books.

Environment: Oracle 10g on Linux, PL/SQL, Business Objects xi

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in different phases of Software Development Life Cycle (SDLC) like requirements gathering, preparation of technical specification documents, designing and developing reports, unit testing and UAT.
• Interacted with the Business Users to analyze the business process and gathered the requirements
• Developed PL/SQL packages, procedures and scripts to extract flat files to Database tables, load into staging tables and transformation of the tables through SQL Loader.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections. Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.

  Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.

• Unit testing and UAT
• Scheduled jobs in Broadcast agent to generate reports to meet the SLAs.
• Developed universe user documentation guide for the end users reference.

Environment: Oracle 9i, PL/SQL, Unix Shell Scripting, Business objects 5.1.3

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Business Users to understand the business requirements and contributed to the technical design document and reviewed the document with design authority.
• Identified the data mapping for loading the new feeds from the source systems and developed PL/SQL packages to load and process the data.
• Created complex reports using the multiple data providers
• Developed various reports using features like drill down, filtering,slice & dice and created master/details,cross tab reports.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Responsible for unit testing, Integration & regression testing and supported the UAT.
• Worked with the users to identifying and fixing the data issues.

Environment: Oracle 9i, PL/SQL, Unix Shell Scripting. Business objects 5.1.3

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in requirements gathering, preparation of technical specification documents, designing and developing reports.
• Worked with the business users to identify the data gaps and coordinated with the source system owners to source the required data to generate the reports.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections. Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Performed unit testing and supported the UAT
• Scheduled jobs using Broadcast agent
• Developed the documentation and support run book.

Environment: Oracle 9i, PL/SQL, Unix Shell Scripting Business objects 5.1.3,Broadcast Agent