Developer Project

**** ****** ******, *** ** MUKTA PAUL 818-***-****

North Hollywood, CA 91607 ***********@*****.**.**

EXPERIENCE SUMMARY

More than 10 (8 years in BI & 2 years in software development) years of experience in Software, Telecom and IT industries with extensive end to end expertise in BI domain of & with complete Software Engineering life cycle experience and had been working in one of the largest Data Warehouse (40+ TB) in Asia for last 6 years. Apart from technological “Know How” of Planning and designing for data integration and preparation for large scale data warehouses, also has expertise on BI Dashboard/reports implementation using OBIEE which was delivered out of the box & also expressed passion in efficiency gain achieving 99% operational time reduction through database process optimization .Introduced open source BI tool in GPIT completely boosted by self-learning through R&D and also made foot prints on analytical model development. Became OCA (Oracle Certified Associate) and achieved ITIL® Foundation Certificate in IT Service Management. Led many critical projects in multiple business domains and was successful team leader. Also, had been proven as great people developer by the resource development plans, quality trainings and resource engagement. Played key role in designing, developing and executing numerous campaigns, product and service development. Recently worked as Software Engineering Team Lead (service level 9) in Accenture and also contributed significantly in organizational standardization i.e. CMMI, ISO, CDP (Client Data Protection ) .

EXPERTIES :

Tool : Oracle Business Intelligence Enterprise Edison ( OBIEE 10g/11g), BI Publisher 10g, Pentaho BI (CE), ODM 10g/11g, Discoverer, Oracle Developer6i, Oracle Report Builder 6i.

Language : SQL & PL/SQL, pgSQL, Unix Shell scripting.

Database : ORACLE 10g/11g, My SQL, MSSQL Server, PostgreSQL.

OS : Unix/Windows.

Architecture : Data Modeling, Performance optimization, Multidimensional schema Design

Soft Skill : Customer Requirement Development,Customer Negotiation,, People Development, Building BI Delivery Strategy, Time Management, and Problem solving skills, Delivery Risk Management

RESPONSIBILITIES PERFORMED :

BI Solution Design and Development.

End to End BI Dashboard and Report implementation using OBIEE / BI Publishers/ Discoverer / Pentaho CE.

Data Modeling, Process Automation and Improvement using PLSQL.

Campaign Model Implementation and Pre & Post campaign analysis using SQL/PLSQL

Data Mining and Analytical Model Development Support.

New BI Technology Research and Implementation.

Regular ETL Operation and Maintenance.

Business Intelligence Project Management /Build Management.

Support to Organizational Standardization, business effectiveness and continuity which includes ensuring practices of CMMI, ISO, Client Data Protection and building IT Strategy.

Leading team and Building BI delivery Strategy

Resource development through class room training and on job training with appropriate skill sets

Human Resources Management System and Attendance Management System Development using Oracle Developer 6i and Report Builder 6i.

SIGNIFICANT EXPERIENCE

Software Engineering – Team Lead Accenture Apr 2010-Jan2016

Project : Performance Monitoring Tool for Radio Planning:

Tool is used to monitor performance of GSM network from whole network level up to BTS level and vice versa for Grameenphone Ltd (www.grameenphone.com

). This tool helps the radio planners to take action by showing alert about cells/BTS which are in alarming conditions.

Platform : Oracle 11g DB, OBIEE 10g, Unix Shell.

Role :OBIEE Lead Developer and Delivery Manager.

Special Achievement (If Any): Introduces highly robust and flexible features which offer client more dynamism (new experience for the client from existing OBIEE reports and dashboards ) to analyze KPI performance from whole network to granular level and vice versa .Implemented OBIEE features beyond conventional use to make more interactive and user friendly (i.e. option of customization by the users on the fly).

Project : SNW (Social Networking Model) Process Revamp:

This SNW Model identifies most influential mobile subscribers in a communicating mobile subscriber groups i.e. leaving the operator will influence other subscribers of that group to leave. It used to take more than 5 days to run the operation of single instance of the SNW Model. Goal of revamping process of SNW model was to reduce operational time.

Platform : Oracle 11g DB.

Role : Lead Architect and developer.

Special Achievement (If Any): Gained efficiency with 99% operational time reduction (reduces from 5 days to 5 hours) of SNW (Social Networking Model) by remodeling the process using PLSQL.

Project : Handset Based Analysis portal

Tool assists user to analyze current cell phone market penetration based on handset and handset usage pattern for client, Grameenphone Ltd (www.grameenphone.com ). Data Mart, dashboard and reports implementation was in scope.

Platform : Oracle 11g DB, OBIEE 10g, Linux.

Role : OBIEE Lead developer and Delivery Manager

Special Achievement (If Any): 100% UAT success in one go as well as assisted users to incorporate more reports into the dashboard which helped client to get more visibility on subscribers behavior as well as helped client to design effective campaign modality .

Project : NERM (Network Equipment Repository Management)

Reporting Solution implementation for managing Telecom network equipment inventory for Grameenphone Ltd (www.grameenphone.com). This tool helps to understand current status of the inventory, service request implementation status, request overdue status, analysis on performance of equipment implementation in whole country /region/cluster etc.

Platform : Oracle 11g DB, Oracle BI Publisher 10g.

Role : Lead Developer and Delivery Manager

Special Achievement (If Any): Along with successful project delivery made changes on client’s negative perception to positive towards the delivery team. There was communication gap within client’s internal organization and resulted negative perception towards to delivery team. Initiative to have discussion with the key members of client side about the root problem and preparing delivery plan with them as well as delivered as expected changed the perception completely of the client and made him happy .

Project : Auto Object Purging Process Development

Development of the process was to gain efficiency through Auto Object Purging in ODS database for Grameenphone Ltd (www.grameenphone.com) which was being done manually earlier and several processes used to struggle for free storage .Thus manual purging incurred operational overhead.

Platform : Oracle 11g DB, UNIX Shell.

Role : Development Lead

Special Achievement (If Any): Releases quarter Tera Byte of storage per week and removed complete manual dependency.

Project : Resource engagement and effort monitoring tool

1st reporting tool using open source BI. Tool helps to analyze resources’ current and forecasted engagement. Estimates efforts/costs of projects based on duration .

Platform : PostgreSQL, Pentaho CE.

Role : Lead Developer and Build Manager.

Special Achievement (If Any): Introduced free of cost solutions for internal use for entire delivery center. Thus cost vs. benefit was significant for the organization

Project : ODS Transfer Process Revamp

ODS Transfer process is for storing all Call Detail Records in ODS database for audit, future Analysis and data mining. Over time resource constraint occurred and it incurred operation overhead and manual intervention. Thus, current need was achieved by process optimization.

Platform : Oracle 11g.

Role : Lead Developer.

Special Achievement (If Any): Removed manual intervention, ensure data accuracy by restricting erroneous data penetration and finally established a robust architecture which eases daily operation management.

Project: Churn back Campaign Module Revamp

This process used to generate Bonus eligible subscriber’s list based on campaign modality. This process has a dependency of regular ETL process completion and any kind of delay in ETL process, operation of this process was being done manually. Revamping the process removed manual intervention and provided more required info on bonus disbursement for handling customer complains

Platform : Oracle 11g.

Role : Lead Developer.

Special Achievement (If Any): Reduction of operational overhead 99% and customer complaint by 100%.

Project: CDP Implementation

Implementation of Accenture CDP (Client Data Protection) Policy and Practices in Accenture, Bangladesh Centre which ensures client data security in software development, data conversion, testing etc. during and after completion of client project.

Platform : N/A.

Role : Conversion Service Owner who was accountable for implementing CDP for conversion in whole organization.

Special Achievement (If Any): Achieved the goal within the provided timeline.

Project: CMMI Level-3 implementation in GPIT

This project was to prepare GPIT for CMMI level-3 appraisal and during final appraisal this company was rated as CMMI level-3. Role :

Platform : N/A .

Role : Appraisal Team Member (ATM).

Special Achievement (If Any): Company was rated as CMMI level-3

Deputy Manager Telenor (Grameenphone Ltd.) Jan 2010 -Mar 2010

Project: Churn Prediction Model In Telecom: Parameter Analysis

Thesis paper to analyze most effective parameters and factors to predict churn for specific segment of subscribers.

Platform : Oracle 11g, ODM 11g.

Role : BI Analyst.

Special Achievement (If Any): Effective parameters identification that has effects on churn.

Project: Root cause of Erosion of revenue

This was an Ad-hoc analysis to find out reasons of revenue fall of Grameenphone Ltd ((www.grameenphone.com )). for specific time period. Considering several factors like customers segment, usage pattern new, offers etc.

Platform : Oracle 11g.

Role : BI developer and Analyst.

Special Achievement (If Any): Root cause identified which helped business users to take action immediately.

Executive Pacific Bangladesh Telecom Ltd (Citycell) Jan 2008 – Dec 2009

Project: Campaign Model Implementation

Different types of campaign data mart were implemented including mass and micro campaign like Usage bonus disbursement for VAS (e.g. Dost, MBOX), ARPU Enhancement, pre-paid Data Service (ZOOM) and Recharge bonus disbursement based on 1st time recharge. . Client: Pacific Bangladesh Telecom Ltd. (www.citycell.com )

Platform : Oracle 9i.

Role : Lead Developer.

Special Achievement (If Any): 1st campaign model development for business users

Project: Analytics Development

Analytical Data Mart Development for pre-post campaign analysis, subscribers’ behavior pattern/usage/cross product interest analysis, product performance analysis, new product performance predictive analysis, cross sale/up sale analysis etc. Client : Pacific Bangladesh Telecom Ltd. (www.citycell.com ).

Platform : Oracle 9i.

Role : Lead Developer.

Special Achievement (If Any): 1st Analytical data mart for business users.

System Programmer Square InformatiX Ltd. Nov 2006 – Jan 2008

Project: Human Resources Management System Revamp

Different customized ERP Modules were developed for members of Square group (www.squaregroup.com ) based on the business policy of each member. Modules are Employee Information. Transfer, Promotion, Retirement, Payroll, Attendance & Leave Management process and reports development. Client- Members of Square Group.

Platform : Oracle 9i, Developer 6i,Report Builder 6i.

Role : Developer.

Special Achievement (If Any): Successful delivery on time.

Asst. Programmer Daud IT Ltd. Aug 2005 – Oct 2006

Project: Attendance Management System

Software to manage entry exit timing of resources, over time, Leave etc. Client - The Fu-Wang Group & National Polymer Industries Ltd and The ACME Laboratories Ltd.

Platform : Oracle 9i, Developer 6i,Report Builder 6i.

Role : Developer.

Special Achievement (If Any): Successful delivery on time

CERTIFICATION:

ITIL® Foundation Certificate in IT Service Management – 2015

Oracle certified associate (OCA) - 2007

PROFESSIONAL TRAINING:

ITIL® Foundation Certificate in IT Service Management

Introduction to CMMI-Dev v1.3

Informatica

SAS Data Integrator

SAS Micro Programming

SAS Basic Programming

Oracle 9i (DBA track)

EDUCATION

Kolkata, India West Bengal University of Technology Jun 2001 – Jun 2005

Bachelor of Technology in Computer Science and Engineering. CGPA: 7.31 (Scale 10)

Contact this candidate