SUMMARY

• Over 19+ years of IT work experience and 16 years of experience in covering all stages of Data Integration, Data Warehouse/ETL and Business Intelligence.
• Experience leading the analysis, design, development & implementation of logical and physical data models; data conversion, integration, and loading processes; data management and governance; and data quality assurance processes.
• Experience in implementing Data Security using Oracle ACL, VPD and Wallet manager.
• Experience in developing dimension and Normalization models.
• Experience in data profiling.
• Experience in Oracle 12c, SQL Server 2016, PostgreSQL 9.5, PL/SQL, BI Publisher and Tableau.
• Experience in Data Warehouse and data marts development working with Data Migration, Data Conversion.
• Expert in writing Oracle Stored Procedures, Functions, Database Triggers, Packages, Materialized Views, Oracle Collection, Object Types and Partitions.
• Experience in application performance and tuning (PL/SQL) using TKProf, DBMS PROFILER.
• Experience in Oracle Advance Queuing. Supported application that is integrated with MQ - Series.
• Experience in Oracle XML DB and JSON data format.
• Experience in developing complex applications using Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i
• Experience in developing scripts using UNIX Shell.
• Experience in Oracle Discoverer (3.1).
• Knowledge in Business Objects and SAS.
• Knowledge in Tableau.
• Enforcing security by creating roles, granting system and object privileges on the tables.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix Shell Scripting

Databases: Oracle12c/11g/10g/9i/8i, SQL Server 2016, PostgreSQL 9.5

BI Tools: OBIEE 11/10, OBIEE Administration, OBIEE Reports development, OBIEE Repository (RPD) development, BI Publisher, Tableau

ETL: Informatica 9.x/8.x/7.x/6.x.

Application Tools: PL/SQL, Oracle Advance Queuing MQ-Series, Oracle Discoverer (3.1), Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i, SQL*Loader

Middleware: Oracle Web Application Server

Operating System: Unix Sun Solaris (Server 2.5), Compaq UNIX (True64),Windows NT, Win95/98/NT/XP/Thin Client, MS-DOS 6.0. VMS/VAX

Others: TOAD, Erwin.

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Database Developer, Data Analyst

Responsibilities:

• Develop and document data requirements and design specifications in the form of data models, data mappings and data quality metrics. Map out structure and organization of the relevant data for the company or project
• Meet with business stakeholders to determine data needs and identify where data exists that can satisfy the needs.
• Develop and execute plan for acquiring the data.
• Partner with enterprise BI team to leverage existing (or in development) data infrastructure and reports.
• Develop data quality matrices and ensure quality of data in various databases.
• Developed Data Quality reports on source data systems. Determining data quality of source systems and worked with users and business analysts.
• Designed and developed ETL solutions and aid the reporting process across the enterprise.
• Developed Start Schema modeling, dimensions, facts on OLAP databases Gas, Power, Transmission(OATI Tag), Meters(smart grid digital meters), Prices(index, forward market prices), credit, accounting, PI (plant information), Dispatch, Incident, Assets, Oracle Financial, ET application tracker systems.
• Designed OBIEE dash boards/reports for OBIEE analytics developers on OBIEE subject areas.
• Developed complex Oracle PL/SQL Packages, procedures, functions, database triggers, Oracle Collection and Object Types.
• Identifying problems in existing SQL queries and PL/SQL packages, procedures, functions and identifying performance issues using Explain Plan and TKprof and improve performance of SQL queries.
• Developing data cleaning scripts using PL/SQL
• Involved in design and development of (OLAP) data warehouse and data marts by working with various teams across the organization stakeholders.
• Designed the data warehouse(OLAP) for Nucleus(OLTP) application(designed data marts for Gas, Power, Transmission(OATI Tag), Meters(smart grid digital meters), Prices(index, forward market prices), credit, accounting)
• Designed data warehouse and data marts for Customer Care & Billing (Mainframes system), PI (plant information), Dispatch, Incident, Assets, Oracle Financial, ET application tracker systems.
• Documenting user requirements, applications, creating test scripts.

Environment: Informatica 9.x/8.x/7.x/6.x, OBIEE 11/10, Oracle112c/1g/10g/9i/8i, SQL Server 2016, PostgreSQL 9.5, PL/SQL, UNIX, TOAD.

Confidential

Data Analyst, ETL Developer

Responsibilities:

• Collect the requirements from users and develop design document and coordinate with offshore to develop, maintain and enhance.
• Involved in support, maintaining, enhancing and developing existing data warehouse (data marts) and ETL for ADMIN/LIMS.
• Anticipate the end-to-end scope of analytical need of the client and design valuable BI and ETL solutions accordingly
• Extract the data from ADMIN/LIMS to staging area thru flat files and Tables.
• Extract/Transform/Load using Informatica with Flat Files, XML, Oracle, SQL Server, Mainframes.
• Upload the data from staging area into target database.
• Developed Oracle stored procedures, packages, functions for generic values instead of using the sequence generator transformations.
• Involved in supporting the project and resolve production issues.
• Use the best practices of business intelligence to design the analytical solutions.
• Designed and developed the OBIEE Metadata Repository (.rpd) using BI Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Designed the Security management for users, groups and web-groups using the various authentication systems Database and Database table authentication using Session Variable features, as well as Dashboard / Report-level security. Created iBots and Delivers to send Alert messages to subscribed users.
• Prepare documentation for all data and reporting development
• Used PL/SQL tables and records extensively and wrote database packages, and database triggers using PL/SQL
• Developing data cleaning scripts using PL/SQL.
• Identifying problems in existing SQL queries and PL/SQL code using Explain Plan and performance tuning on reports and forms applications for better response.
• Planning work schedule to meet deadlines for releases of ADMIN/LIMS

Environment: Informatica 9.x/8.x/7.x/6.x, OBIEE 10, Oracle9i/8i, Oracle BI Publisher, PL/SQL, UNIX, Oracle Forms9i/6i, Reports9i/6i, TOAD.

Confidential

Oracle Developer

Responsibilities:

• Understanding of the functionality of the Stock Exchange Clearing & Settlement System.
• Requirement Analysis of Equity Billing module, Payments, Financial Accounting and Professional Clearing Member Billing Modules.
• Identification of the areas to be fully pameterised in the billing module (brokerage Calculation) of Clearing and Settlement system.
• Developed application codes in PL/SQL and stored them in functions, stored procedures and database packages for easy maintainability and called them from the Forms libraries and database triggers.
• Design of the ER Diagrams, data models in Oracle Designer 6i for the development in Payments and Financial Accounting Module of the Back office system.
• User administration and User Privilege Setup
• Space / Memory Management.
• Unit testing for Billing, Payments and Financial Accounting Modules.
• Preparation of the test cases for unit testing and system testing of back office system.
• Preparation of system test plans and System testing for back office system for the complete functionality.

Environment: Unix Sun Solaris (Server 2.5), Compaq UNIX (True64), Windows NT, Win95, MS-DOS 6.0, Oracle 8i/8.0, Oracle Developer 2000 (Oracle forms 6i/5.0/4.5, Reports 6i/5.0/4.5), MQ-Series, Oracle Designer 2000 & Designer 6i, PL/SQL, Unix Shell script, TOAD, VSS