BANU RAJADURAI

Senior So*ware Engineer

Mobile: +1-860-***-****

Email: adrr07@r.postjobfree.com

Summary

Experienced & Result-oriented SoluPon Architect/Data ScienPst having 5 years of experience in architecPng, developing and execuPng data driven soluPons such as DWH’s, Data Lakes, ETL pipelines, Data science. Professional Skills

• Involved with enPre SDLC of data driven projects for telecom clients i.e., understand and analyze the Business Requirements by interacPng with business users, Project Planning, HLD DocumentaPon, Module design, Development, TesPng, Deployment & product training to client.

• Designed highly scalable and reliable ETL & ELT data pipelines for various telecom data sources with different data formats.

• Created star & snow flake schema based Data models for telecom data analyPcs soluPon. Upgraded Enterprise DWH systems to Data Lake soluPon to cater the needs of various types of end users.

• Conducted POC’s to evaluate different OLAP databases such as VerPca, MemSQL, PostgreSQL to make the soluPon affordable to clients.

• Sound knowledge and experience in managing VerPca analyPcs database (Improving queries response Pmes by fine tuning VerPca storage structures, InstallaPon, Rolling Upgrades, Backup & restore etc.) Technical Skills

• Programming Languages : Python, Perl, SQL and PLSQL, Unix Shell ScripPng, Java

• Databases : VerPca, MySQL, Oracle, MemSQL

• Data IntegraPon Tools (ETL) : Talend

• Web Frameworks : Flask

• Python libraries : Pandas, Numpy

Work History

Tayana So7ware Solu9ons, Bangalore (2012 – 2017)

ETL Developer

• TDA (Telecom Data Analy9cs)

Clients:

a) CWS Seychelles b) Tashi Cell Bhutan c) MT MauriPus d) Dhiraagu Maldives e) Bhutan Telecom Telecom Data AnalyPcs plajorm is a complete end to End Modernized Data warehouse (DWH)/Data Lake, Business Intelligence (BI) & AnalyPcs soluPon. It enables the Telecom operators to consolidate business related data from mulPple data sources into single consolidated data warehouse/data lake, stores detailed level of data to be able to support different type of analysis & empowers the different business users with access to the relevant data for their analysis.

Role & Responsibili9es:

Understanding the data from different data sources. DocumentaPon of Source to target Mapping Document, Input File Formats, DDL's for Staging and Final Tables.

Design & development to high performance & scalable ETL Dataflow for the data sources such as Mobile Voice, SMS, Data, Fixed line, Broadband & IPTV.

Collaborated with Business Users to understand their reporPng needs from the available data.

Designed data model which consist of fact tables, dimension tables & Aggregates/rollup/KPI tables.

Designed Meta data capture module which is very much essenPal for any data analyPcs project.

Introduced ELT Approach to transform data quickly inside a staging database.

Developed Revenue assurance module for various data sources to help the operator to idenPfy revenue leakages.

Skill Set:

Perl, Python, VerPca MPP database, In-house ELT built in Perl and Python, Talend.

• ASN Decoding of MSC and Roaming Call Detail Records Design & Develop Personalized Modules to decode all encoded Call records, Extract data from decoded XML files and create CSV Files.

Roles & Responsibili9es:

Decode the Encoded Files

Understand the data in XML, Consolidate MulPple records for unique call and create comma separated file and load into raw and Fact tables

• Legal Event Tracker

Legal Event Tracker is used to track the calls records of the subscriber who is under Mobile Switching Center. Using tracker one can trace details of a subscriber Incoming Calls, Outgoing Calls, Incoming SMS, Outgoing SMS and Forward calls.

Role & Responsibili9es:

Design and Implement GUI using Perl CGI as per requirement of client.

Based on requested subscriber mobile number, generate incoming, outgoing call and SMS record details for requested date range and upload the zip file having excel spreadsheet to the web server.

• Loyalty Card Management

Loyalty card management is a system used to grade the subscriber as PlaPnum (High), Gold (medium), Silver

(low). Grade of the subscriber will be linked with the conversion factor for loyalty point redempPon and loyalty point credit.

Role & Responsibili9es:

Generate the Prepaid and Postpaid data feed to the LCM system from the TDA as per LCM team requirement.

• Web Push No9fica9on

Client: Bhutan Telecom & MT MauriPus

Worked on Web Push NoPficaPon which uses Google Cloud Messaging plajorm (for chrome) to send NoPficaPons for mobile subscribers. Mobile Data user data usage is monitored to send noPficaPon if data usage exceeds their threshold usage.

Roles & Responsibili9es:

Designed push API and NoPficaPon API on top of Service Worker API, Push Manager

Designed Tables, web pages for the applicaPon

Deployed Model to producPon as an API which is developed by using flask web framework.

Wrioen detailed documentaPon for each of the above acPviPes and shared with client. Online Courses (2020-2022)

• Completed various SQL, PL/SQL, Perl and Python courses in Udemy and Pluralsight topics include

Regular Expressions in Perl and Python.

Perl DBI.

OOPS Concepts in Perl and Python.

Perl Arrays & Lists.

Perl File Handling concept.

Usage of various Python FuncPons.

Python Numpy.

Preparing myself for Oracle OCA cerPficaPon (Oracle Database 12c). Reason for Career Gap (2017-NOW):

• I was not able to work because of H4 Dependent VISA . Educa9on

Bachelor of Technology in Electronics and CommunicaPon (2008 to 2012) from Vidya Vardhaka College of Engineering, Mysore, India.

Contact this candidate