pinaki bhattachaya (data analyst)

10
PINAKI BHATTACHARYA PINAKI BHATTACHARYA Orchid Valley, Flat No – 4H, Sardar Para, Kaikhali, Kolkata-52 EXPERIENCE: 11.2 Years on Data Ware Housing, PL/SQL, ORACLE 9i/10g/11g, OBIEE, Telecom-BI [email protected] Mob: +91 8017707786(India) / +974 30571727 (Qatar) SUMMARY ( 11 yrs 2 month ) : I have worked on banking and telecom domain and done all of my development work on Data warehousing, OBIEE, Oracle PL/SQL and Microsoft product. Functional experience like Telecom BSS (BI), Retail Banking, Trading Technical Skill (oracle 10g/11g, pl/sql, Data Warehousing, OBIEE, ETL). PRESENT STATUS : Working as a Tech Lead at Tech Mahindra. Currently at Onsite (Vodafone Qatar, Qatar). STRENGTH : Data Warehousing, OBIEE, ETL, PL/SQL, Oracle 9i/10g, Configuration Management ACHIEVEMENT : “Best Performer of the Year 2006” at Datavision Software Pvt Ltd. “Pat on The Back” at Tech Mahindra EXPERIENCE : Garnet Software Pvt Ltd, Pune – Jan, 2005 to Jun, 2006. Datavision Software Sol Pvt Ltd, Pune – Jul, 2006 to Jun, 2007. I-Flex Solutions Ltd, Pune – Jun, 2007 to Oct, 2007. HSBC GLT, Pune – Nov, 2007 to Nov, 2009. Tech Mahindra, Kolkata – Nov, 2009 to till date Total 3.5 yrs at Onsite (Bahrain, Qatar, Bangladesh) Skills Languages PL/SQL Software Packages Microsoft Office, Visual Basic 6.0 1 of 10

Upload: pinaki-bhattacharya

Post on 09-Jan-2017

145 views

Category:

Data & Analytics


2 download

TRANSCRIPT

Page 1: Pinaki bhattachaya (Data Analyst)

P I N A K I B H A T T A C H A R Y APINAKI BHATTACHARYAOrchid Valley, Flat No – 4H,Sardar Para, Kaikhali, Kolkata-52

EXPERIENCE: 11.2 Years on Data Ware Housing, PL/SQL, ORACLE 9i/10g/11g, OBIEE, Telecom-BI

[email protected] Mob: +91 8017707786(India) / +974 30571727 (Qatar)

SUMMARY ( 11 yrs 2 month ) : I have worked on banking and telecom domain and done all of my development work on Data

warehousing, OBIEE, Oracle PL/SQL and Microsoft product. Functional experience like Telecom BSS (BI), Retail Banking, Trading Technical Skill (oracle 10g/11g, pl/sql, Data Warehousing, OBIEE, ETL).

PRESENT STATUS : Working as a Tech Lead at Tech Mahindra. Currently at Onsite (Vodafone Qatar, Qatar).

STRENGTH : Data Warehousing, OBIEE, ETL, PL/SQL, Oracle 9i/10g, Configuration Management

ACHIEVEMENT : “Best Performer of the Year 2006” at Datavision Software Pvt Ltd. “Pat on The Back” at Tech Mahindra

EXPERIENCE : Garnet Software Pvt Ltd, Pune – Jan, 2005 to Jun, 2006. Datavision Software Sol Pvt Ltd, Pune – Jul, 2006 to Jun, 2007. I-Flex Solutions Ltd, Pune – Jun, 2007 to Oct, 2007. HSBC GLT, Pune – Nov, 2007 to Nov, 2009. Tech Mahindra, Kolkata – Nov, 2009 to till date

Total 3.5 yrs at Onsite (Bahrain, Qatar, Bangladesh)

SkillsLanguages PL/SQLSoftware Packages Microsoft Office, Visual Basic 6.0Databases Oracle 8i/9i/10g, MySQLOperating Systems WIN 98, WIN 2000, Windows XP, UnixTools TOAD, PL/SQL Developer, OBIEE 10g/11g

Educational Profile

Master of Computer Application (MCA) from RCCIIT, Kolkata under West Bengal University of Technology in 2004.

B.Sc (H) in Mathematics from Vidyasagar University, West Bengal in 2000.

DIPLOMA COURSE: Diploma in Information Technology Application (DITA) from State Youth Center under Govt. of West Bengal in 2000-2001.

CERTIFICATION: NSE’s Certification in Financial Markets (NCFM). Brainbench Certification on Data WareHousing, Oracle PL/SQL.

1 of 7

Page 2: Pinaki bhattachaya (Data Analyst)

P I N A K I B H A T T A C H A R Y AJob/Profile Experience

Company : Tech Mahindra

Project Name : Vodafone QatarClient : Vodafone QatarPlatform : WindowsSoftware : Oracle 11gTool : Hyperion, OBIEEJob Title : BI Analytics Expert (at Onsite)

Project Description : Vodafone Qatar part of one of the world’s largest telecommunications Group, the Vodafone Group, is the holder of the Second Public Mobile and Fixed Telecommunications Networks and Services License in the State of Qatar. BI captured various upstream system data and stored into data warehousing system using Wherescape tool and generates the report using Hyperion and PL/SQL. BI does analytics for finance, marketing, sales and others team and shared some analytical statistics which help them to grow up their business.

Responsibilities : Business Analyst

Report Design

Developed PL/SQL Code

************************************

Project Name : SurflineClient : Surfline Communications,GhanaPlatform : Windows, UNIXSoftware : Oracle 11gTool : OBIEE,InformaticaJob Title : Tech Lead (at Offshore)

Project Description : Surfline is a Ghanaian-owned telecommunications network providing super-fast and reliable 4G LTE services. The BI implementation is required to capture data from various source systems like BRM, CRM, Network etc. and presenting analytical reports to business. Business Intelligence is the major platform to improve responsiveness, accessibility of service, monitoring of service and better performance to enhance customer satisfaction.

Responsibilities : Business Analyst of BI Telecom

Prepared design specification

Designing and developed the PL/SQL Code, ETL process

************************************

2 of 7

Page 3: Pinaki bhattachaya (Data Analyst)

P I N A K I B H A T T A C H A R Y A

Project Name : STC BahrainClient : STC-VIVA, BahrainPlatform : Windows, UNIXSoftware : Oracle 11gTool : OBIEE, PDWJob Title : Business Analyst of BI (at Onsite)

Project Description : STC-VIVA changed their BI tool from OBIEE to PDW (Microsoft BI tool). Due to change of this tool, they need to ensure data and business scenario should remain same during migration. All major KPIs’ should be shown same figure as existing tool published.

Responsibilities : Business Analyst of BI Telecom Shared the business knowledge to Microsoft Business Matrix verification Ensured proper business logic made

************************************

Project Name : RobiClient : Robi, BangladeshPlatform : Windows, UNIXSoftware : Oracle 11g Tool : OBIEE 11gJob Title : Business Analyst (Onsite and Offshore)

Project Description : Robi LMS Reporting system is based on input data from Siebel LMS. This system is generating loyalty customer reports, transaction details, redemption detail, transfer details, etc. Using OBIEE 11g reporting tool, business users are able to decide their loyalty program trends, progress, etc.

Responsibilities : Requirement gatherings at Onsite as Business Analyst Prepared design specification Designing the PL/SQL Code/ETL process

************************************Project Name : STC BahrainClient : STC-VIVA, BahrainPlatform : Windows, UNIXSoftware : Oracle 11gTool : OBIEEJob Title : Tech Lead (OBIEE Developer/Designer at Onsite)

Project Description : STC-VIVA BI architecture comprises of Six Layers. It consists of Source Layer, ETL Layer, Data Warehouse Layer, Service Layer, Presentation Layer and User Layer. It received daily/weekly/monthly data feeds from different source systems like BRM, CRM, OSM, etc. Using ETL Layer, it populates the data into BI system with help of Data Warehouse Layer. Major dashboards are like customer segmentation, raffle, SLA reports, customer base, market share, revenue, add-on and many more. All dashboards were developed using OBIEE.

3 of 7

Page 4: Pinaki bhattachaya (Data Analyst)

P I N A K I B H A T T A C H A R Y AResponsibilities :

rpd and catalog maintenance, new report design using OBIEE 10g Day to day client interaction and requirement gathering Developing, designing the PL/SQL Code/ETL process, OWB mapping Writing tuned Stored Procedures, Functions and Packages using Oracle 11g. Database maintenance activity and production support

************************************Project Name : EIMClient : O2 Germany.Platform : Windows, UNIXSoftware : Oracle 10g, ClearCase, ClearQuestJob Title : Sr Technical Associate

Project Description : EIM is an application which pays commissions to the dealers (partners) of the o2 Germany based on the various conditions that are defined and planned in an EIM system. The main part of the commissioning architecture is Enterprise Incentive Management system (EIM). It will take over all kinds of commissioning relevant functionality which includes the maintenance of commission plans and rules, calculation of commissions and triggering of commission payout in the finance systems. EIM will also offer an approval workflow for approval relevant actions such as manual data import, payments, etc. The commissioning system is based on the Merced ICM software delivered by Merced Systems.The customizations to the product implementation principally the “Pre-processor”, “Credit Memo” are not a part of the Merced ICM “Off the Shelf” product and are propriety to O2.The changes to and maintenance of this part is therefore the responsibility of O2. O2 has access to the code and any changes that need to be made to this functionality is being handled by O2 and in turn by TechMahindra going forward.

Responsibilities : Build & Configuration To Develop the PL/SQL Code based on technical design document Wrote and tuned Stored Procedures, Functions and Packages. Database maintenance and performance tuning

Company : HSBC GLT, Pune

Project Name : DataWare Housing and ReportingClient : HSBC Bank, UK.Platform : Windows, UNIXSoftware : Oracle 10gJob Title : Senior Software Engineer

Project Description : This project handles data ware house requirements for reporting Purpose of bank's historical data related to Global Banking and Markets (A division of Investment Banking and Foreign Currency Trades).

Responsibilities :

Supporting the application. Wrote and tuned Stored Procedures, Functions and Packages. Made the changes as per client demands and whenever any bug is fixed. Hardcore pl/sql programming.

Company : I-Flex Solutions, Pune

4 of 7

Page 5: Pinaki bhattachaya (Data Analyst)

P I N A K I B H A T T A C H A R Y A

Project Name : FLEXCUBE (FCRCANARA)Client : CANARA BANKPlatform : WindowsSoftware : Oracle9i/10G, XML, VC++, VB6.0Job Title : Associate Consultant

Project Description : The new TD product was designed for Canara Bank under Flexcube through which customer can get back the annuity amount periodic basis. This is reducing principal balance. This product can also attach the loan a/c.

Responsibilities :

Requirement analysis

Coding and Development.

5 of 7

Page 6: Pinaki bhattachaya (Data Analyst)

P I N A K I B H A T T A C H A R Y ACompany : Datavision Software Solution Pvt Ltd, Pune Project Name : DATAMATEClient : SCOPlatform : Windows 2000 and SCO-UNIXSoftware : MySQL, Oracle 9i/10gJob Title : Sr. Oracle Consultant

Project Description : DataMate is a complete banking solution. It is a new generation, web-based, centralized core-banking system. It addresses the retail, corporate and trade finance requirements and is based on the latest open standards. The system is banker friendly and allows you to define your own products.

Responsibilities :

Migration Oracle to MySQL. Oracle and MySQL Procedure, Function, Trigger creation. MySQL database administration. Report preparation on Oracle and MySQL Database.

Company : GARNET S/W PVT. LTD., Pune

Project Name : TUFMAN (Textile Upgradation Fund ManagementClient : State Bank Of India, Commercial Branch, Mumbai and Other Associates

Bank Of State Bank GroupPlatform : Windows XPSoftware : VB 6.0, SQL Server2000, Crystal Report7Job Title : Software Developer

Project Description : This software has two parts one is Branch Level and another is NDO Level... Behind making this software, the main goal was upgrade the machinery, which are used at Textile mills, Jute Industry or Spinning mills. Central Govt. wants to upgrade their quality of product to compare with rest of the world’s product. And another reason is to remove the accident and save the time. So, all textile, jute or spinning company need loan to buy or change their machinery. And they demand loan to bank. Responsibilities :

Requirement analysis Database design & Coding Client interaction and training.

Project Name : TARA (Total Automation & Regional Administration)Client : State Bank Of Indore, Zonal Office, MumbaiPlatform : Windows 2000Software : VB 6.0, Oracle9i, PL/SQL, Crystal Report7Job Title : Software Developer

Project Description : This product was design for office automation. The whole project consists of six modules. The product maintains employee attendances, leaves calculation, payroll, Inward Outward Mail Applications, fixed assets maintain, bill & transaction of the office, employee details and etc. Responsibilities :

Database design & Coding

Project Name : MIS (Management Information System)Client : State Bank Of India, Global Link Service, MumbaiPlatform : Windows XPSoftware : VB 6.0, C++, Oracle9i, PL/SQL, Crystal Report7

6 of 7

Page 7: Pinaki bhattachaya (Data Analyst)

P I N A K I B H A T T A C H A R Y AJob Title : Software Developer

Project Description : MIS Utility is provided which help to take future decision. MIS includes reports like Statistical Reports, Graphical Reports, Analytical reports, etc on Bills and Cheques. Responsibilities :

Database design & Coding

Personal ProfileName Pinaki BhattacharyaDate of Birth 26th Oct, 1978Permanent Address “Orchid Valley”, Flat No – 4H, Sardar Para, Kaikhali, Kolkata - 56Contact No. 8017707786E-mail [email protected]

Extra Curricular Activities and Hobbies

Social Secretary of Midnapore College Chatra Union 98-99. Listening to music and play SU-DOKU & games. To play Cricket, Badminton and Playing Cards.

(Pinaki Bhattacharya)

7 of 7