𝙏𝙚𝙘𝙝𝙣𝙤𝙡𝙤𝙜𝙮:✪ Visualization: Tableau, MicroStrategy, Excel✪ Processing: Informatica, Bash Shell Scripting(UNIX)✪ Language: SQL, Python✪ Database: Teradata, Oracle𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 & 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧:📌 Leading the design & development of comprehensive Business Intelligence and Analytics dashboards and reports using Tableau and MicroStrategy📌 Transforming data into information, insights, and actionable business decisions📌 Carrying out business analysis to empower stakeholders with hidden meaning of information📌 Analyzing and monitoring segment wise customer activities and behavior, acquisition quality, Customer lifecycle, performance & competitors activity📌 Performing business performance analysis for marketing insights relevant to Product, Sales, Service, Network Quality & Customer Experience Management📌 Writing different kinds of Excel Macros and interpret them using Excel VBA𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠:📌 Leading the development of Teradata-based data models and data mart. Developing scripts for automated process using SQL, Bash & INFORMATICA📌 Architecting and executing data pipelines within Teradata using INFORMATICA, optimizing data flow and processing efficiency📌 Handling incident management and administration of MicroStrategy (MSTR), user management, audit compliance, and information security protocols📌 Contributing to AI/ML-based data science prediction model architectures📌 Generates Daily/Weekly/Monthly reports based on Usage, Revenue, Recharge, Network, Location, RGA, RGB, GA/Churn, Reactivation𝐓𝐞𝐚𝐦 𝐌𝐚𝐧𝐚𝐠𝐦𝐞𝐧𝐭📌 Collaborate with stakeholders to address new requirements and resolve daily operational issues📌 Take full ownership of dashboards and reports, guiding team members as needed📌 Address audit-related concerns and guide team about information security & compliance matters📌 Manage incidents and ensure timely updates to dashboards and reports after resolution

Business Analysis Responsibilities:- Create regular reports (Daily/Weekly/Monthly) on important metrics using MSTR, Tableau & Excel to track progress and help make smart choices.- Study different metrics like Usage, Revenue, Network Quality, Churn, and Data Usage to understand how well the business is doing.- Look deeply into the data to find patterns and trends that can help make better decisions for business growth.- Keep an eye on customer activities, how we gain customers, revenue, RGB Activities.- Develop efficient methods for storing and retrieving data within Teradata databases.- Streamline data access for report generation by optimizing tables, views, and SQL procedures.- Automate routine tasks through script writing to enhance operational efficiency within the Teradata environment.- Collaborate with various teams to ensure accuracy and relevance of data presented in MSTR dashboards.- Transform raw data stored in Teradata tables into actionable insights showcased through user-friendly MSTR dashboards.- Leading end-to-end IT project and infrastructure delivery process.- Supporting budgeting and forecasting process of sales operational targets.- Maintaining data governance principles, security, privacy, audit, and risk control metrics.

📌 Provides Managed service support for the Billing system to Banglalink Digital Communications Limited📌 Ensuring complete end to end support of BSS operations, Billing, Provisioning, payment web services (SOAP, REST)📌 Acting as a Single Point of Contact ("SPOC") to L1 (1st level monitoring team) to handle trouble tickets for problems reported by customers📌 Perform the second level of analysis and troubleshooting, escalate unresolved problems to Level 3 (R&D), track progress of trouble tickets (TT) resolution, and ensure restoration and resolution within SLA.📌 Incident ticket handling and resolve the issue as per the SLA.📌 Automation scripts for regular tasks using shell script and python. Create and manage database automation using shell script📌 Carrying emergency on-call 24/7 for customer network’s fault resolution.📌 Resolve all postpaid related issues raised by the Customer service team📌 Do Bill Run, Fetching and Printing activity, generate 100k pdf for the stakeholders every month.📌 Coordinate & engage with vendors, partners for new solution development and continuous improvement of the business process.📌 Take part in assessing the proposed solution technically, follow up the development activities as per the agreed plan.📌 Study, analyze and propose new development needs for new products & services.📌 Raise operational problems, queries & concerns at Vendor interface through information-request/problem-report as per maintenance agreement.📌 Ensuring KPI and SLA.📌 Coordinating with Revenue Assurance & Fraud Prevention📌 Working experience on Unix/Windows Server and Virtual Machine.📌 Database support maintenance.📌Technology I have used here:✪ Back-end: Python & Shell Script✪ Server OS: CentOS✪ Web-server/framework: Nginx, Apache, Django✪ API: SOAP, REST✪ Databases: Maria DB, Cassandra DB, OpenEdge ABL(OpenEdge Advanced Business Language)✪ Message broker: KAFKA, RabbitMQ✪ Container orchestration: Mesos, Marathon, Zookeeper

📌 Source data processing engine development for dump data processing daily wise. 📌 Design Dashboard for Operational People using web(PHP,HTML,CSS,BOOTSTRAP)📌 Risk Analysis, Control Design & Development over Telecom Revenue Stream📌 Provide support to cross-functional stakeholders📌 Per day almost 100 million data processed using shell script and oracle database📌 Working with the team members for DBSS 0.6 project and give support for source data validation📌 Perform UAT, API testing to find bugs and report problems in JIRA📌 Automate the regular task using shell scripts and PHP. Create and manage database automation using shell script, procedures, and jobs📌 Perform testing and create problem tickets for vendors in MITO & JIRA📌 Create scripts for the auto-mail trigger to vendors and team members.📌 Perform various types of analysis to identify and investigate different types of fraudulent activities of retailers/distributors.📌 Ensure no revenue leakage in the billing system for both voice & SMS and reconcile monthly invoices.📌 Designed and implemented stored procedures other application database code objects.📌 Working with different stakeholders within the organization to develop and identify new business modalities, business plans, controls, and trends.📌 Reconciliation of CDR within various systems like MSC, Mediation, Postpaid/Prepaid platforms, Interconnection, etc. to check the correct amount of data transferring and thereby confirm no missing data📌 Technology I have used here:✪ Scripting Language: PHP & Shell Script ✪ Server OS: CentOS✪ Framework: Bootstrap & Laravel(Simple task)✪ Web Servers: Apache✪ API: SOAP, REST✪ Databases: ORACLE & MYSQL

📌 Create scalable software platforms and applications, and efficient networking solutions that are unit tested, code reviewed and checked regularly for continuous integration📌 Plan and execute full software development life cycles (SDLC) for each assigned project, adhering to company standards and expectations📌 Integrate third-party services using APIs into applications.📌 Worked with developers to design algorithms and flowcharts📌 Collaborated with development, QA, and staff to develop Online ticket products.📌 Developed web application project using JAVA programming language, object-oriented software.📌 Performed testing on software to uncover bugs and troubleshoot issues before application launches.📌 Wrote clean, clear, and structured code in Spring, JQuery, Thymeleaf various projects.📌 Technology I have used here:✪ Scripting Language: JAVA✪ Server OS: Ubuntu✪ Framework: Bootstrap, Spring, JQuery, Thymeleaf ✪ Web Servers: Tomcat✪ Databases: Postgresql

- Created website layout and user interface using HTML and CSS practices.- Used programming capabilities in PHP, SQL and Jquery and other libraries as needed.- Working on minor bug fixes.