Sri Sailam Bashamani Email & Phone Number

Austin, Texas, United States

• Business intelligence experience in analytical techniques including segmentation, data mining, cleaning data and creating process for existing dashboards.• SQL object development and automation• Creating reports using Snowflake, Tableau and Power BI Paginated dashboards• Experience engaging technical and non-technical stakeholders• Migrating the existing reports from SQL Server to Power BI (Snowflake cloud DB).• Used Power BI custom visuals like power KPI, infographic… Show more • Business intelligence experience in analytical techniques including segmentation, data mining, cleaning data and creating process for existing dashboards.• SQL object development and automation• Creating reports using Snowflake, Tableau and Power BI Paginated dashboards• Experience engaging technical and non-technical stakeholders• Migrating the existing reports from SQL Server to Power BI (Snowflake cloud DB).• Used Power BI custom visuals like power KPI, infographic designer to make the visuals look better. • Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports. Environment: Microsoft Power BI, Tableau, Snowflake, Visual Studio, Azure Data bricks, Azure Data Studio, Power Query, Power BI Service, DAX, Microsoft Azure, SQL, SSRS & MS Excel Show less

Hyderabad, Telangana, India

• Published many reports like doctor-wise performance, centre-wise new doctors hired, and incentive flash.• Part of FP&A team hold responsibility of P&L MIS on revenue reports and collect data from accounts team.• Created various dashboards in Power BI desktop using table, matrix, bar, card, gauge, and slicer visualizations.• Prepared P&L support data in Power BI to get data faster and refresh monthly reports.• Worked with Quality and Assurance team on Consumable, Implant cost… Show more • Published many reports like doctor-wise performance, centre-wise new doctors hired, and incentive flash.• Part of FP&A team hold responsibility of P&L MIS on revenue reports and collect data from accounts team.• Created various dashboards in Power BI desktop using table, matrix, bar, card, gauge, and slicer visualizations.• Prepared P&L support data in Power BI to get data faster and refresh monthly reports.• Worked with Quality and Assurance team on Consumable, Implant cost cutting exercises. • Automated monthly Balanced Scorecard, Footfall and Revenue tracking, reducing manual effort and improving reporting accuracy. Developed and presented key metrics (OT Utilization, Bed Occupancy, Net Promoter Score, Complaints, ALOS, ARPOB, etc.) to the Board.• Transformed unstructured data into structured data, creating Doctor-wise and Surgery-wise views and queries in SQL. Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.• Created various drill through, parameterized, tabular reports and matrix reports using SSRS and created subscriptions for users. Have experience in using the bookmarks and sync slicers and buttons extensively to develop the best user experience.• Designed and developed operational reports using MS Power BI Desktop for various regional managers and also created calculated measures and columns with DAX.• Deploy and Configure Power BI dataset for Sales and Finance team, implement incremental refresh on Power BI dataset.• Configured Gateway in the Power BI service and Implemented Data security (Row-level security) on Dataset.• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using SQL.Environment: Microsoft Power BI, Tableau, Power Query, Power BI Service, Snowflake, DAX, Microsoft Azure, SQL, SSRS, T-SQL, MS Access & MS Excel Show less

Hyderabad, Telangana, India

• Analyzing customer’s minutes of usage, revenue & decrement details with huge data.• Tracking billing data, collection, CAF new activations, CPC (Calls per customer), FTR (First time resolution), • Churn retention & bad debt from CSD department• Generating voluntary, involuntary churn, pendency reports published across the team.• Preparing PPT on cost, collection, bad debt for MD & business head reviews GSM & RWLN separately. • Automated daily collection SMS data… Show more • Analyzing customer’s minutes of usage, revenue & decrement details with huge data.• Tracking billing data, collection, CAF new activations, CPC (Calls per customer), FTR (First time resolution), • Churn retention & bad debt from CSD department• Generating voluntary, involuntary churn, pendency reports published across the team.• Preparing PPT on cost, collection, bad debt for MD & business head reviews GSM & RWLN separately. • Automated daily collection SMS data preparation with multiple logics.• Bill cycle wise monitoring the usage of the high value customer’s month on month.• Co-ordination with various sub functions viz. finance, SCM, Service delivery for end-to-end control over operations.• Processing of Live CDR and data usage files and designing file operation process for mediation.• PREPAID: - Timely publishing of activation dashboard & daily recharge tracker.• Monitoring DREC - Daily revenue earning customers, Gross to DREC and updating DREC daily dumps in database of SQL Server.• Scheduled and maintained nightly and weekly loads of data by creating and scheduling the respective jobs.• Created stored procedures and SQL queries to pull data into power pivot model. Environment: SSMS, SSIS, SSRS, T-SQL, MS Access & MS Excel Show less

Hyderabad, Telangana, India

• Generating and Maintaining MIS reports - sales, profitability, dashboards & targets.• Identification of new or unseen business opportunities: Evaluating advertisers on other newspapers.• Accountable for preparing targets, Incentives vertical wise monthly. • Playing a key role in monitoring targets vs. achievement of BCCL branch-wise.• Administered TAM data for Ad revenue analysis for print reach profile• Leading, training & monitoring the performance of team members to… Show more • Generating and Maintaining MIS reports - sales, profitability, dashboards & targets.• Identification of new or unseen business opportunities: Evaluating advertisers on other newspapers.• Accountable for preparing targets, Incentives vertical wise monthly. • Playing a key role in monitoring targets vs. achievement of BCCL branch-wise.• Administered TAM data for Ad revenue analysis for print reach profile• Leading, training & monitoring the performance of team members to ensure efficiency in sales operations and meeting of individual & group targets.Environment: Power BI, SQL Server, SSIS, SSRS, MS Access & MS Excel Show less

India

• Preparing unique reports to submit to TRAI like QoS-Quality of service on complaints.• Parameters Complaints/000 sub, billing related errors, DND complaints and checking the performance towards the benchmark given by TRAI.• Analyzing different SR’s, publishing errors, and giving suggestions to control error in process. Working closely with RA team.• Doing different analysis on complaints tracker, repeats, VAS activations, Data activations, re-opened SR’s and waiver… Show more • Preparing unique reports to submit to TRAI like QoS-Quality of service on complaints.• Parameters Complaints/000 sub, billing related errors, DND complaints and checking the performance towards the benchmark given by TRAI.• Analyzing different SR’s, publishing errors, and giving suggestions to control error in process. Working closely with RA team.• Doing different analysis on complaints tracker, repeats, VAS activations, Data activations, re-opened SR’s and waiver postings.• Monitoring CSAT scores for the circle on a daily basis and provide inputs to all the support functions.• Publishing daily reports Complaints/request/Enquiries dashboards, CSAT% dashboard, TAT dashboard & Repeat analysis dashboard.• Additional responsibility handling Bulk prepaid provisioning and marketing promotions through SMSC by validating scripts.• Preparing Presentations for CS-Reviews & VOC (Voice of customer issues) with Business Head – CEO Monthly • Responsible for managing the bill logistics section in the Credit and Collections department.• Allocation to collection agencies and driving collection performances.• Scheduling the communication to customers on bill delivery by preparing billing dump as per bill cycle Environment: SSRS, MS Access & MS Excel Show less

Hyderabad, Telangana, India

• PREPAID: - Timely publishing of activation dashboard & daily recharge tracker.• Daily dashboards zone wise gross revenue, tertiary, high value products 111,301 & 999 growth comparisons. • Monitoring DREC - Daily revenue earning customers, gross to DREC and updating DREC daily dumps in database of SQL Server.• Responsible for communication to segmented customers to achieve an average of 40 % repeat purchase.• VAS: Vas recharges tracking & data unique users and charges, volume… Show more • PREPAID: - Timely publishing of activation dashboard & daily recharge tracker.• Daily dashboards zone wise gross revenue, tertiary, high value products 111,301 & 999 growth comparisons. • Monitoring DREC - Daily revenue earning customers, gross to DREC and updating DREC daily dumps in database of SQL Server.• Responsible for communication to segmented customers to achieve an average of 40 % repeat purchase.• VAS: Vas recharges tracking & data unique users and charges, volume tracking, helping vas team to run their promotions by providing timely & accurate data basis and the segmented criteria provided.• Segmented campaign data preparation & SMS scheduling for unique users, high usage, FTD, MTD revenues generated bucket wise for each vertical.Environment – MS Access, AOL, BI and DB2, MS SQL Server, MS-Excel. Show less

Hyderabad, Telangana, India

• Preparation of reports for review purpose with the help of tools such as MS Access, AOL, BI and DB2.• Analyzing customer’s minutes of usage, revenue & decrement details with huge data.• Customer Lifecycle Management from the time of on board (New activation to churn).• Understanding the customer pain areas, deliver the strategy for overcoming the pain points and ensure customer retention.• Maintaining interaction with the Team Leaders and Sales Executives regarding the Airtel… Show more • Preparation of reports for review purpose with the help of tools such as MS Access, AOL, BI and DB2.• Analyzing customer’s minutes of usage, revenue & decrement details with huge data.• Customer Lifecycle Management from the time of on board (New activation to churn).• Understanding the customer pain areas, deliver the strategy for overcoming the pain points and ensure customer retention.• Maintaining interaction with the Team Leaders and Sales Executives regarding the Airtel Postpaid Sales.• Tracking on activations, incentives & targets of Airtel Postpaid Sales Executive wise.• Validating the documentation & activating by doing data entry of Airtel Postpaid New Activations at HOEnvironment – MS Access, AOL, BI and DB2, MS SQL Server, MS-Excel. Show less

Master Of Business Administration - Mba, Marketing

Bachelor’S Degree (B.Com)