VANDANA RAI
Solution Architect
Summary
Have experience focused on development and deployment of BI and DWH applications. Seeking a challenging job that utilize and further sharpen my skills, and where I can express my thoughts and ideas for the growth of the company and to meet customer demands. Profile: Brings 13 plus years of experience with expertise in Business Intelligence, Data Warehousing. Proven track record as a data architect, designing and implementing robust data architectures that enable efficient data management, integration, and analysis across diverse systems and platforms Experienced in Capturing business requirements and translating into a complete data platform technical specification Experienced in implementing comprehensive data architectures that adhere to data governance principles and regulatory requirements, ensuring data accuracy, security, and privacy throughout the data lifecycle. Experience of handling, mining, modelling, analysis on various KPI’s. Expertise in data modelling that exploits patterns found in historical and transactional data to identify risks and opportunities in business. Broad array of technical expertise; well-versed in industry best practices and emerging trends. Ability to work with cross-functional teams to gather requirements, design solutions, and implement data architectures that meet business needs. Experience in Telecom and Travel with clients ranging from Fortune-10 companies to start-ups in Europe, Indonesia, Singapore, Middle East, and India. Experience in scoping, analysis, gathering requirements starting from data extraction via ETL till delivering reports in BI. Excellent communication skills and ability to explain complex technical concepts to non-technical stakeholders. Experienced in handling a team of more than 10 people. Onsite Experience in Netherlands for biggest transport network company in Europe Onsite Experience in Jakarta Indonesia for telecom company Indosat.
Overview
13
13
years of professional experience
1
1
Language
Work History
Data Architect
Ooredoo Indosat
- B2C & B2B Post-paid Business requirement Analysis & delivery Responsibilities:
- Requirement gathering, scoping and analysis of different subject areas of INDOSAT
- Creating LLD and HLD for analysis and developing purpose
- End to end responsible for analysis, developing and delivering the Billing subject area
- Involved in preparing the data model for different subject areas of INDOSAT
- Working withing the ETL and BI restructuring as per the client requirements
- TRANS-LINK SYSTEM BSCS
Data Analyst and Product Integration Expert
Trans-Link
- Opportunity Description: Implementation of BSCS Solution on Transport Domain along with the Billing of Data Cards Responsibilities:
- End to end responsible for analysis, developing and delivering the Billing subject area
- Involved in preparing the data model for different subject areas of Translink
- Working withing the ETL and BI restructuring as per the client requirements
- Responsible for the Customer workshops, meetings, solutioning, estimation and presentations
- Close interaction with Ericsson EOC team on the overall architecture proposed for Trans-Link systems
- Customer workshops related to Product Configuration and Integration with surrounding systems
- Revise estimation and solutioning based on stakeholders’ feedback after meetings
- Work with key stakeholders like SA,SSA,CSRs
Billing Consultant and Data Analyst
SINGAPORE and HYDERABAD
Hyderabad
- Implementation of BSCS Product related configurations and Data warehouse Development
- Responsibilities:
- Handled responsibility being a senior in the team by assigning business requirements (Design Documents) to the members of the team for coding
- Conducted more than one level of code reviews ensuring a bug free code is delivered to the testing team and then to the production
- Supported different levels of testing like user acceptance testing and system integration testing by giving clarifications on the queries raised by the teams or other support
- Have delivered a hundred percent bug free codes till date giving no production incidents
- Have mentored newly joined members in the team by giving them a proper training and other required support
- Have a good knowledge of delivery packages of codes through Serena dimensions
- Created generic scripts to do BSCS product Configuration in Production environment
- Defect analysis and resolution
- Preparing and analyzing configuration and testing documents
- Worked on BSCS Migration Projects
- User level Testing & Implementation of Rate Plans in BSCS iX Billing system
- Implementation, Operation & Support of Business Support System (BSS) for Telecom sector, Management of Development/Implementation/Operation/Support of Billing/Customer Care Solutions, Multi-vendor & Stake Holder Coordination
- Follow up with another module team if required.
Developer
- Operations Management, Operation optimization, Vendor Management, Internal customer management and Project Management
- Manual testing of the core functionalities for all the IT applications developed by vendors, like CDR portal, CRM (Amdocs CRM Smart Client 7.5) etc
- Handled E Recharge, First Time Activation (FTA), Prepaid product configuration, All portals and websites, Regulatory requirements, Service Delivery Platform & Value Added Services including Subscription Engine, Bulk Messaging Gateway, USSD Gateway, Integration of third party VAS services with CRM and SDP and all other prepaid applications
- Analyzed incidents which helped fine tune the system and drastic reduction in the incidents (almost 80%)
- Led MNP roll out and stabilization for organization
- Organization Port In and Port Out
Solution Architect
Ericsson India Global Services Pvt Ltd, DU Telecom
06.2016 - Current
- Translating business requirements to detailed technical & data requirements for the team to work and develop the required solutions
- Designing and implementing large-scale data solutions for DU for meeting the smooth and proficient data delivery
- Designing High level design documents working with clients to ensure both reporting and analytical solutions delivery
- Gathering the requirement from the clients and model the framework for Data
- Convert and develop the functional requirements technically and deliver to the developers for end-to-end delivery
- End to end responsible for analysis, developing and delivering the quality of data which is further used by different applications in DU, INDOSAT ECM-BSCS CBIO17
MIGRATION QA & PRODUCTION SUPPORT Location
ATOS India Private Limited
Pune
11.2014 - 05.2016
Data Analyst and Team Lead
Knot Solution Private Limited
08.2012 - 10.2014
- Implementation of E2E journey for Business requirements of Customer
- Responsibilities:
- Global engagement for analytics and business intelligence across multiple geographical locations involving CRM, Campaign, Billing and legacies
- M-Commerce is one successful unique push marketing program launched by Vodafone for sending out campaigns to customers based on their areas of interest such as Entertainment, Food & Drink, Sport, Travel, Health, Fashion & Beauty etc
- M-Commerce have successfully completed 31 CRQ request’s producing112 distinct Business Products 89.2m data Points,5.75m customers opted in for messaging campaign & 16 m customers opted in for display campaign
- Various other engagements are listed below:
- Campaign conversion analysis
- Churn analysis for Vodafone India operation
- Segment based funnel analysis
- Define Enterprise Business Intelligence and Reporting Roadmap
- Collaborate with Architecture teams (Big Data, analytics, and Data integration, and Data architecture, business intelligence) to develop and deliver BI solutions
- Multivariate analysis for assorted products across bundles
- Text analysis using big data, Mongo DB and R to provide additional model for Churn
- Developing models to forecast earnings, planning, marketing on some of the highly profitable bundles for targeted and controlled customers
- Designing DDL, an independent service to collate data from various source systems like Siebel CRM, AMDOCS and huge Call Detail Record Files
- Driving teams in developing Cognos cube models to generate summary and audit reports with slicing and dicing options on huge data dump Designing Complex data extractions and transformations.
Project
Videocon Mobile Services, Amdocs
Gurgaon
12.2009 - 07.2012
Education
Bachelor of Engineering - E&TC
Priyadarshini College of Engineering, Delhi Police Public School
SSC - undefined
Delhi Police Public School
Skills
Analytical Skillsundefined
Timeline
Solution Architect
Ericsson India Global Services Pvt Ltd, DU Telecom
06.2016 - Current
MIGRATION QA & PRODUCTION SUPPORT Location
ATOS India Private Limited
11.2014 - 05.2016
Data Analyst and Team Lead
Knot Solution Private Limited
08.2012 - 10.2014
Project
Videocon Mobile Services, Amdocs
12.2009 - 07.2012
Data Architect
Ooredoo Indosat
Data Analyst and Product Integration Expert
Trans-Link
Billing Consultant and Data Analyst
SINGAPORE and HYDERABAD
Developer
Bachelor of Engineering - E&TC
Priyadarshini College of Engineering, Delhi Police Public School
SSC - undefined
Delhi Police Public School
Similar Profiles
NASIR IQBALNASIR IQBAL
VP Head Performance Management at Indosat Ooredoo HutchisonVP Head Performance Management at Indosat Ooredoo Hutchison
Aan Sabdo SuwandokoAan Sabdo Suwandoko
SVP Service Operation & Performance Management at IOH - Indosat Ooredoo HutchisonSVP Service Operation & Performance Management at IOH - Indosat Ooredoo Hutchison
Dony SiswantaraDony Siswantara
Head of Postpaid Central Sumatra at Indosat OoredooHead of Postpaid Central Sumatra at Indosat Ooredoo
RAVI KUMAR BANDARUPALLIRAVI KUMAR BANDARUPALLI
Data Architect at Mindtree LtdData Architect at Mindtree Ltd
Yemi AyofeYemi Ayofe
Data Architect at University of YorkData Architect at University of York