We provide IT Staff Augmentation Services!

Product Owner Resume

Redmond, WA

SUMMARY:

  • 12 years of proven skills in the Information Technology, with extensive experience in Oracle 9i/10g/11gR2, PL/SQL, SQL performance tuning, AWS S3, Informatica, Cognos Data Manager, Oracle Warehouse Builder, OBIEE, Oracle BI Publisher Reporting, Cognos Reporting, Data modeling (Dimensional & Relational) and Threat Modeling.
  • Handled bulk data loading (1.5 billons) using Partitioning of tables and advance features like FORALL, SAVE EXCEPTION.
  • Proficient in advance features for PL/SQL programming like using Records, Collections, Bulk Bind, Ref. Cursors and Dynamic SQL.
  • Created ETL package by using PL/SQL Functions, Procedures, Packages, Triggers and Materialized View Log.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Gather Statistics and Table partitioning.
  • Experience in developing various Unix Shell Scripts.
  • Certified in Oracle Certified Associate and IBM Cognos 8 BI Metadata Model Developer.
  • Strong understanding of Data warehouse, ETL/ELT, Data modeling ( Relational, Dimensional, Star and Snowflake Schema ), Normalization, Physical & Logical data model, SCD implementation, Data analysis, KPIs.
  • Experience in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Experience in Dimensional modeling (Star Schema) of the Data warehouse and used ERStudio to design the dimensions, facts and reverse engineering.
  • Experience in interacting with business users, analyzing client business processes, creating B usiness R equirement D ocument, Functional Specification Document, Technical Specification Document and arranging Training Session for business users in Waterfall and Agile methodology.
  • Experience in creating Feature and right sized user stories, story pointing using Agile methodology.
  • Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
  • Experience in Preparation of UAT protocol, DEV/ QA/UAT/ Regression test script for any deployment.
  • My experience on HR, Finance, HealthCare, Consumer, Telecommunication, General Insurance domain, also gives me the confidence to explore and build new innovative solution for the business.

TECHNICAL SKILLS:

  • Informatica 8.1
  • OWB 9.2
  • Cognos Data Manager 8
  • Big data
  • Hadoop
  • Dimension Modeling
  • Tableau
  • Oracle BI Publisher
  • OBIEE
  • Cognos Report
  • Oracle Reports
  • Oracle 8i/9i/10gR2/11g
  • SQL Server 2000/2005/2014
  • PL/SQL
  • SQL
  • Oracle Forms
  • Oracle Reports
  • SAP - MM
  • ERStudio
  • CranSoft cCust Application
  • IBM Change Control Log
  • Mercury Quality Center 9.0

PROJECT DETAILS:

Confidential, Redmond, WA

Product Owner

Responsibilities:

  • Designed the ETL flow of new Statutory feed for Confidential Balance Sheet data.
  • Designed new report using Confidential MSRA (Statutory Balance Sheet) for Confidential Balance Sheet data.
  • Designed the ETL flow to integrate LinkedIn data.
  • Re- Designed the Trial Balance and Statutory Balance Sheet reports to introduce a new field which will help Business to distinguish Confidential and LinkedIn data.
  • Lead and supervised onshore delivery team to provide technical guidance and solutions to peer technical teams.
  • Modified the existing Store Procedures of ETLs to integrate LinkedIn data and Confidential ’s Balance Sheet data.
  • Modified the Confidential MSRA’s backend Store Procedures to integrate new filter conditions in the reporting layer.
  • Worked on POC - Created Database Objects such as Tables, Views and Synonyms to provide data access while taking the backup/restore.
  • Performed troubleshooting and root cause analysis on Production Issues.
  • Reverse Engineering to generate data model using ERStudio.
  • Analyzed business requirements, As-IS and TO-BE analysis and functional impact and changes and created the Business Requirement Document.
  • Created Feature and right sized user stories using Agile methodology.
  • Defined functional specifications and acceptance criteria (Created using Gherkin Spec Flow) for each user story.
  • Performing Grooming and JED sessions to explain user stories and design approach with team.
  • Sprint planning and effort estimation on user stories to deliver business requirement.
  • Designing Threat model for current application.
  • Updating data model in Confidential Visio diagram.
  • Automated testing performed using Confidential ’s WebInspect for application portal.
  • Driving UAT and training sessions with business users.
  • Coordinate SOX team to get approval for each release.

Operating System: Windows 2010

Technology: SQL Server 2014, Confidential MSRA, Confidential Visio, Confidential Project Plan,

Confidential

Data Engineer

Responsibilities:

  • Created Unix shell scripting to generate the parameter files based on Country to run the Informatica maps.
  • Created parameterized (session) Informatica mapping to generate multiple CSV files for different countries to generate Account Payable Register, Account Receivable Register and Journal Book.
  • Created Unix shell scripts to upload the generated CSV files to Confidential S3 buckets based on countries.
  • Created new way to design/integrate AP and AR business modules to deliver IT Spesometro using Informatica mapping, based upon volume, ledger and company code.
  • Created scheduling of Unix shell scripts and Informatica maps by Confidential ’s DJS.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Implemented Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • SQL tuning to improve the performance of the existing SQL queries using EXPLAIN PLAN, HINTS DBMS STATS.GATHER SCHEMA STATS and also worked extensively on Indexes.
  • Responsible for implementation of end to end project solutions for Inventory Register.
  • OBIEE installation on new Unix server and RPD deployment.
  • Created PDF reports based upon volume of data, ledger and company code for statutory reporting, using BI publisher.
  • AWS S3 Bucket creation, assigning user to role and uploading files to S3 from unix box.
  • Performed scrum master role.

Operating System: Windows 2008 and Unix

Technology: PL/SQL, SQL tuning, Oracle 11g, Informatica 8.1, OBIEE, Oracle BI Publisher, AWS S3, Confidential DJS and Unix Shell Scripting.

Confidential, Seattle, WA

Senior ETL and PL/SQL Developer

Responsibilities:

  • Customized PL/SQL package to integrate new metrics for the HR Team.
  • SQL tuning to improve the performance of the existing SQL queries using EXPLAIN PLAN, HINTS DBMS STATS.GATHER SCHEMA STATS and also worked extensively on Indexes.
  • To improve data loading performance, wrote and debugged Oracle SQL PL/SQL code i.e. Packages, Procedures, Functions, Anonymous blocks, Triggers,
  • Modified the existing PL/SQL Cursors with Ref Cursor, Created Indexes and Materialized Views to improve reporting performance.
  • Designed and developed the backend packages, procedure and functions which being used by entire Confidential HR team to analyze the performance and attrition metrics of employee.
  • Performed functional testing for the PL/SQL functions, procedures and packages.
  • Created the test scripts and complex queries to test the application and to quality assurance of the data.
  • Involved in preparing test plans, unit testing, System integration testing.

Operating System: Windows 2008 and Unix

Technology: Oracle PL/SQL, SQL Tuning, Oracle 11g and Informatica 8.1

Confidential, Milpitas, CA

Data Modeler and Senior ETL Developer

Responsibilities:

  • Created own ETL package by using PL/SQL functions, procedures, packages, triggers and Materialized View logs.
  • Implemented Type 2 SCD mappings to update slowly Changing Dimension Tables
  • To improve data loading performance, wrote and debugged Oracle SQL PL/SQL code i.e. Packages, Procedures, Functions, Anonymous blocks, Triggers,
  • SQL tuning to improve the performance of the existing SQL queries using EXPLAIN PLAN, HINTS DBMS STATS.GATHER SCHEMA STATS and also worked extensively on Indexes.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
  • Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
  • Managing scope, Requirements gathering and delivery of business requirement document, functional specification document, technical specifications and unit test script.
  • Requirement analysis for the Change Request.
  • Impact analysis on ad-hoc request from business.
  • Weekly and Monthly Status reporting to high management.
  • Coordinate with multiple IT team on infrastructure issues.
  • Design and development of Application Programming Interface (API).
  • Designed and developed the backend packages, procedure, function and triggers which being used by the entire business to analyze daily sales, order details.
  • Process improvement suggestion helped the organization to generate the report by 40% faster.

Operating System: Windows NT

Technology: Oracle PL/SQL, Oracle 10gR2, Cognos FrameWork, Data Manager and Cognos Reporting.

Confidential

Senior ETL Developer

Responsibilities:

  • Creation of Staging and Target Tables to capture the data from source tables.
  • Creation of ETL mappings to load the data from source table to staging and target table as per business logic.
  • Creation of PL/SQL packages for Application Programming Interface (API).
  • Requirement analysis for the Change Request.
  • Impact analysis on ad-hoc request from business.
  • Creation of technical specification and design of new enhancements.

Operating System: Windows XP

Technology: Oracle PL/SQL, Oracle 10gR2, Cognos FrameWork Manager and Cognos Reporting.

Confidential Senior ETL Developer

Responsibilities:

  • Creation of source and target Tables to capture the data from csv files.
  • Creation of ETL mappings to load the data from csv files to source and target table as per business logic.
  • Creation of PL/SQL packages for Application Programming Interface (API).
  • Requirement analysis for the Change Request.
  • Impact analysis on ad-hoc request from business.
  • Creation of technical specification and design of new enhancements.

Operating System: Windows XP

Technology: Oracle PL/SQL, Oracle 10gR2, Cognos Data Manager

Confidential

Data Modeler

Responsibilities:

  • Requirement analysis for the Change Request.
  • Impact analysis on ad-hoc request from business.
  • Creation of technical specification and design of new enhancements.
  • Modification of Cognos framework package to generate the a new FM package that will help to generate required cognos reports.
  • Creation of Cognos reports which helped the business to get the proper understanding of the business growth and potential.
  • SQL tuning to improve the performance of the existing code.

Operating System: Windows XP

Technology: Oracle PL/SQL, Oracle 10gR2, Cognos Data Manager

Confidential

Senior SQL Developer

Responsibilities:

  • Creation of source and target rules in Cransoft which is being used to load the data from different source systems to SAP ECC6.
  • Creating different reports by Cransoft, for data migration which shows the exact progress of the data migration status by country wise.
  • SQL tuning to improve the performance of the existing code.
  • QA/ Regression Testing in Mercury Quality Center 9.0 for Data Standard
  • Creation of CQ in IBM Change Control Log
  • UAT protocol, Test script preparation for any deployment.
  • Testing for QA, Regression Test in Mercury Quality Center 9.0

Operating System: Windows XP

Technology: Cransoft, IBM Change Control Log, Mercury Quality Center 9.0, SAP MM

Confidential BI

Senior SQL Developer

Responsibilities:

  • SQL tuning to improve the performance of the existing code.
  • Requirement analysis for the Change Request.
  • Impact analysis on ad-hoc request from business.
  • Creation of technical specification and design of new enhancements.
  • Design and development of Application Programming Interface (API).
  • Developed the backend packages, procedure, function and triggers which being used by the entire business to analyze daily sales, order details.

Operating System: Windows NT

Technology: Oracle PL/SQL, Oracle 9i.

Hire Now