Software Engineer Project

ADEEL MUNAWAR

**** ***** *** ****** ( Fairfield, Iowa 52557

541-***-**** ( acedow@r.postjobfree.com (

https://www.linkedin.com/in/adeelmunawar

ETL DEVELOPER / DATABASE DEVELOPER

Dynamic software engineer with over 2 years of in-depth experience in ETL,

database, Oracle, and SQL development. Highly skilled at managing huge

amounts of data and organizing information into useful and relevant

segments. Adept database designer, using analytical skills to create ETL

and BI domains. Demonstrated success controlling large-scale control files,

entering critical data in accordance with source file, and maintaining

information integrity. Strong team collaborator, promoting alignment and

cooperation to consistently achieve far-reaching objectives. Possess basic

knowledge of MapReduce technology and Hadoop framework.

Extract, Transform, Load (ETL) Processes ( Oracle Development ( Data Mining

Functions

Web-Based Applications ( Technical Documentation ( Control File Management

( Dynamic SQL

Problem Solving ( Goal-Oriented Approach ( Teamwork ( Collaboration (

Effective Communications

Data Warehouse Development Lifecycle ( Business Intelligence ( Online

Analytical Processing (OLAP)

Languages: Java, C / C++, SQL, T-SQL, PL / SQL

Web Technologies & Frameworks: Hadoop, J2EE, Servlets, JSP, EJB, HTML,

JavaScript, CSS

Databases: Oracle 10g, SQL Server 2008, Microsoft Access, MySQL, Big Data,

Teradata

Tools: Oracle APEX 4.0, Toad for Oracle, Oracle Golden Gate, Informatica.

Oracle Endeca, PL/SQL developer, SQL Loader, SSIS, SSRS, Netbeans, Eclipse,

Visual Studio, J developer, MS Project, MS Office

Platforms: Windows 98/XP/7/8, LINUX

Software Development Methodologies: Waterfall, Iterative, RAD, Agile

Design Pattern: Factory, Singleton, MVC

CERTIFICATIONS

Microsoft SQL Server 2008: Business Intelligence Development & Maintenance,

Database Development

PROFESSIONAL EXPERIENCE

CAREER NOTE: Completed on-campus studies and currently taking distance

education courses to complete a Master's Degree in Computer Science

(Available for full-time, W-2 employment).

INFORMATION ARCHITECTS, Islamabad, Pakistan ( 2011-2013

IT company providing solutions for information intensive clients

Software Engineer

Oversaw package development using SQL and PL / SQL database languages.

Contributed as key member of ETL team. Implemented new code and built

improved systems. Conducted testing and troubleshooting, identifying issues

and designing effective resolution strategies. Implemented iterative

methodology to develop tools and web-based applications. Managed large

amounts of data and performed in-depth analysis for database design.

Selected Achievements:

. Developed packages using PL / SQL to manage various CBS sources, and used

PL / SQL terminologies like associative arrays, dynamic SQL, procedures,

functions, and analytical SQL.

. Facilitated client data population across various reference tables by

designing and implementing solutions using Oracle APEX 4.0 tool (RRDM).

. Integrated various new sources by gathering and reading client control

files, reading control files, making tables, and creating database

entries.

. Software development using Java technologies.

ADEEL MUNAWAR ( Page 2 541-***-**** ( acedow@r.postjobfree.com

INFORMATION ARCHITECTS, Software Engineer, continued:

Tools:

. Utilized various languages, including SQL, PL / SQL, as well as web

technologies, such as HTML, JavaScript, and CSS in achieving goals.

. Built databases using Oracle 10g and Oracle APEX, and tools such as Toad

for Oracle, while working on both platforms XP and UNIX.

Awards:

. Earned 67% salary increase based on exceptional performance.

PROFESSIONAL PROJECTS

Projects completed at Information Architects include:

Roshan Enterprise Data warehouse Project (RED):

The aim of this project was to provide a complete Data warehouse &

business intelligence solutions for the better support to management and

financial decisions. The Project consisted of three main modules,

Financial, Commercial, and Technology. This project was one of the first

implementation of Oracle EDW architecture in SAGE region.

As an active member of ETL development team, I developed different ETL

processes using PL/SQL. There packages perform the three main functions

during every batch run:

. Extract the data from staging tables,

. Apply the data transformation according to rules developed by client

. And load the processed data into the data warehouse

We used Pipelined Table Functions of PL / SQL for efficient memory usage

and make the ETL process faster.

Batch monitoring and File handling were my added responsibilities.

Roshan Reference Data Managment Project (RRDM):

The aim of this project was to provide a web based user friendly

interface to populate various reference tables of data warehouse.

Requested solution was designed and developed using Oracle APEX 4.0 tool.

Being the only member of team I was responsible to provide end to end

solution and my achievements were:

. Project scope analysis

. Designing of proposed solution

. Development of proposed solution using APEX 4.0

. Testing of the application

. Deployment of application on production server

. Conduct training sessions with client to train the end users

. Provided the maintenance services after deployment

Application had many modules comprising of forms to carry out various DML

operations on the data. HTML and Javascript were used as front end

languages, while SQL and PL / SQL were used as a back end languages to

query the data from database.

RED & RBI Migration on M9000 Server

The purpose of this project was to move the data form old DWH and BI

servers to M9000 server. I successfully accomplished following tasks

during this project.

. Assisted DBA in data servers management

. Developed SQL scripts for data extraction and data loading from old

servers to new server.

. Used Oracle Golden Gate for data migration.

RED Upgrade to Oracle11g

The purpose of this project was to upgrade the client site servers from

oracle 10g to oracle 11g.

As a member of the team, I performed the following tasks:

. Assisted DBA in data servers management

. Analysis of control files of many different telecom sources

. Newly added sources integration into the batch process

. Loading of data files into staging table through SQL Loader

Java Web application for Data Management

Our client required the replacement of oracle forms by a java web

application to populate the OLTP database tables. Our team implemented

the application using J2EE technologies like JSP, JSF, Spring MVC,

Hibernate, Servlets.

Java application for file searching and loading

This application was designed and developed to replace the manual data

files loading into the batch run for data warehouse. Java core

technologies were used to develop required solution.

EDUCATION

Master's Degree in Computer Science

(In progress via distance education; expected completion June 2016)

Maharishi University of Management, Fairfield, Iowa

Coursework:

Fundamental Programming Practices ( Modern Programming Practices

Project Management ( Parallel Programming ( Big Data

Master of Computer Science Degree

International Islamic University, Islamabad, Pakistan

Coursework:

Database Technologies ( Database Systems ( Data Structures & Algorithms

Analysis of Algorithms ( System Programming ( Object Oriented

Paradigm,

Advanced Computer Programing (Java) ( Artificial Intelligence

Software Engineering ( Discrete Mathematics ( Software Project

Master of Science Degree in Electronics

University of Peshawar, Peshawar, Pakistan

STUDENT PROJECTS

Projects completed at Maharishi University of Management include:

. Crystal Ball: Demonstrated MapReduce technique for finding total online

customer purchases. Utilized Hadoop framework.

. GPA Calculation: Role base GPA calculating system developed for

enterprise-wide usage. Collaborated with 5 team members in designing and

implementing database, including tables and procedures using SQL Server

2008. Utilized MVC design pattern and iterative methodology. Performed

tests and corrected defects to ensure functionality.

Projects completed at International Islamic University include:

. Human Resources System: Conducted extensive system development for J2EE

web application. Empowered company by enabling resume collection, online

testing, and candidate tracking for those who qualified for position.

Enabled employee data maintenance.

Contact this candidate