Data Developer

Javed Akhtar

Phone – 425-***-**** email: ***********@*****.***

Summary

Over 15 years of IT experience in analysis, design, development,

implementation and testing of Data Warehouse/Data Mart Design, ETL, OLTP, BI, Client/Server applications.

Experience in Oracle SQL and PL/SQL (ETL stored procedures/packages) including all database objects:

Experience in Tuning the application using Explain plan and SQL Trace to

optimize the cost and for higher efficiency.

Strong experience in Data Modeling using Dimensional, Star and Snow Flake Schema.

Strong knowledge of IT SDLC, both traditional waterfall and agile methodology/concepts

Languages/Tools

BI Tools

Informatica PowerCenter8.1/9, Oracle BI Discoverer 9, Oracle BI publisher, informatica data explorer. Teradata BTEQ, TOAD, SQL Navigator, SQL Loader, Putty

Database Systems

Oracle 7 to 11g, SQL Server2008, Teradata, MySQL, Oracle EBS

System Design

Erwin, Bpwin, Database Designer 2000

Language

SQL, PL/SQL, Perl, Transact SQL,Unix Shell, Pro*C, PL/SQL

IDE Environments

Developer 2000, Visual basic 3.0/5.0

GUI Report Development

Oracle Forms/Reports/PLSQL

SQL*Reportwriter1.1Business Objects b4.0

Oracle Reports Version 2.5 to 6i

Middleware /Other

Toad, Sql Navigator, Teradata SQL Assistant, AWS/Cloud.

ERP

Oracle EBS

Domain Knowledge:

Telecommunications

(Verizon, T-Mobile, Powertel/SoneraZed)

Manufacturing

(Boeing, Starbucks and BF Goodrich/ATS Aerospace)

Insurance

Education

BS Tech ( 4 year Degree - Electronic Engineering ) AMU, India.

Positions Held

6 years at T-Mobile, Bellevue WA July 2010 till Aug 2016

BI System Analyst Role(4-1/2 yr)/Functional Analyst(1-1/2 yr) –

Reviewing the BI reporting requirements ( BI RRD) and the Fact qualifier matrix to understand the BI requirements and identify the data sources needed for the project.

To perform BI impact analysis of incoming projects on Data Warehouse using Teradata tools, digging through source to target mappings/workflows, staging tables, Erwin data model, ETL, perl.

Experience in maintenance related issues e.g; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

worked on informatica Mapplets, Transformations, Source and Target definitions, mappings using Informatica 8/9.1.0.

Reverse engineer Business Objects XI reports, PL/SQL code, writing SQLs and make changes as per BI requirements.

Worked on data acquisition for several projects into Hadoop data lake (HDP 2.0)

Create Source System Analysis document when a new data source is identified. It involved data mining, data analysis of multiple source systems.

Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Working with Telecom Billing system(AMDOCS/Ericsson) for Revenue(FP&A) reporting.

Reverse engineer Business Objects XI reports for impact analysis.

Worked on the following projects at TMOBILE

IMEI tracking/Blocking

Xmine/Engineering/Usage

Samson AMDOCs upgrades

Product Catalog/WPC

EPC (Amdocs Product Catalog)

PHP - premium handset protection

Device Lifecycle

Using following technology

Informatica Power center, Perl ETL, Unix Shell Script, Teradata, Oracle ihub, SQL Assistant, Toad Data modeler.

Boeing Aerospace, Bellevue WA ( April 2010 - July 2010)

Sr. Oracle Developer (Agile Environment):

Migrated data from legacy system to new database(11g) for a Aerospace data gathering system.

Translated the TSQL procedure, function and views into Oracle's PL/SQL Packages, Procedure, Function and Views.

Fine tune code in PL/SQL Stored procedure made changes to data models(Logical/Physical)

Converted Oracle Forms/Reports UI interface from version 6i to 10g.

Aviation Technical Services, Everett WA (5 years) July-2004 till Dec 2009

Oracle Developer/Functional Analyst on Oracle 11.5.10 Applications.

Task included the following:

Designed and developed an extract (ETL) program from Oracle EBS/ERP for the corporate office where access to Inventory/Purchasing/Finance module data etc was provided as part of our BI solution which included parts usage history and several other performance indicators.

Write new stored procedures and triggers using PL/SQL to support data conversion from MS Access to Oracle applications.

Documented Reporting requirements and design/develop end user reports using Oracle Reports 6i, XML/BI Publisher and calculated KPIs/metrics by writing complex formulas.

Worked on external data exchange interface between auto time (labor management system) and Oracle applications.

Provide Oracle Applications Functional/Technical Support/ Maintain and write new Unix shell scripts and PRO*C programs.

Research & resolve production issues.

Seattle City Light, Seattle WA Mar2003 – july2004

BI Developer/Analyst

Requirements gathering, Design and development of analytics from transactional data with BI functionality(Data Warehouse/Data Marts using Materialized views) using BI Toolsets such as Oracle BI Discoverer Data sheets, BI publisher.

Integrated Oracle BI publisher to use Discoverer data sheets to produce and schedule report to business.

Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc) and then loaded the data into ODS/Staging areas by performing different kinds of transformations using SSIS packages

Starbucks Coffee

March 2001 to August 2002

Sr Oracle Consultant

Created/Modified Design specification and develop GUI Interface for Oracle Application 11.5.8

Created and modified 26 complex supply chain reports using Reports 6.0

Used SqlLoader/ Oracle PL/SQL Packages for data loading into staging and performing validation before loading data from existing legacy system.

Integrated custom Oracle Forms 6i and Reports 6i. Also created PL/SQL stored procedure in Oracle Applications 11i to implement new requirements and custom reporting.

Sonera Zed Telecom July 2000 to Jan 2001

BI Report Developer

Worked as a Business System Analyst/Developer to create web based Billing dashboard using Oracle Billing and Revenue Management (Portal Infranet) as a data source.

Completed the technical specification documentation for several BI reports (customer/billing/revenue)

Project Technologies

Premier Lease and Loan Services

March 2000 to July 2000

Sr Oracle Consultant

Worked as a Business System Analyst/Developer to create Data warehousing requirements and run the data conversion from Legacy to Oracle.

Produced workflow documentation of the Migration project, which was used to migrate clients Legacy system (APIP) to Client-server (QIPS) application data

Performed data profiling, data cleansing, and data validation before loading into the new database.

Created and modified several UNIX shell Scripts, conversion scripts, ETL/Packages using pl/sql, T-SQL(SSIS).

Verizon Wireless, Seattle, WA

(3 years) March 1997 to March 2000

Oracle Lead Developer

Acted as the Technical Lead for the fortification project for CTS(Commission tracking system) using Developer 2000 forms 4.5, Reports 2.5 and Pro*C

Converted old commission logic (Pro*C code libraries) to PL/sql Stored procedures.

Worked with business on several reports around dealer Commission data.

Certifications/Training

UML Classes in Company Training.

Project Management Training/Six sigma (TQM) training

Oracle Applications E-business suite

Coursera Training certification on Data Science, Redshift, R, Python.

OBIEE Training

Contact this candidate