Swetha Veeranna

• Working as Senior consultant for NCS from February 2018 to till date. worked for many clients and involved in various projects. Have worked on different role as Data Analyst Reporting Analyst, BI support, Business Analyst, Technical BA, Data Analyst, Applications Analyst during NCS tenure.

• Working as Reporting analyst for finance application which involved creating monthly variance reports, Capex and Opex reports on weekly basis. and supporting inhouse projects for data analysis and business analysis. Created visually appealing dashboards that effectively communicated key metrics to stakeholders.
• Automated repetitive tasks, freeing up time for more strategic initiatives and reducing manual errors in reporting

Worked as a Reporting analyst, Business analyst and in support of sales. Melbourne waters had their existing report platform in Tableau, and they wanted to move the entire reporting set to Power BI. The role involved in creating the existing reports from Tableau in Power BI and documenting the changes. Involved in couple of data integration and documenting the changes,

• Streamlined report generation process for improved efficiency and faster delivery.
• Prepared monthly ad hoc reporting in alignment with client needs. Collaborated with cross-functional teams to gather requirements and design comprehensive reporting solutions.
• Skills utilized: Data Analysis, Reporting Analysis, and project management., Power BI, Tableau, JIRA, SharePoint

• Worked as a data analyst for Alice project. responsibilities were Interacting with pricing specialist to understand their products and cost models inclusive of price and discounts for each product. Creating table schema to build a product reference data and finalising the schema. Creating a product catalogue for products like Data & IP, Adaptive mobility, Fixed voice and unified comms. Working out the bundle and unbundles cost for adaptive networks (Data & IP) for term wise. Working on creating SIPP codes and CNR code (Customer Negotiation rate) for the product catalogue. Creating and automating the final Alice product catalogue for Pricing specialists to update their future products and costing on their respective products.
• Improved decision-making processes with accurate data analysis and visualization techniques. Creating EPICS and User stories in JIRA, Managing and updating the JIRA Board The work was applauded by Stakeholder and the determination to achieve the goal in limited time was also recognised by the Client.
• Produced monthly reports using advanced Excel spreadsheet functions.

• As a reporting analyst role involved in Interacting with the loyalty business team to understand their reporting requirement. Interacting with BI team to understand about the BDH data and available data sources. Creating mock-up dashboards to showcase to business to finalize the report requirement. Design and generate reports like Bakery and clerk performance of loyalty transaction, Top 20 products performance in relation to loyalty performance and engagement. Streamlined report generation process for improved efficiency and faster delivery.
• Trained team members on the use of reporting tools, increasing overall productivity within the department.
• Skills utilized: Data Analysis, Project analysis, Project Management, SQL server, SISENSE BI, MS Excel, JIRA

• As a Data analyst the role involved in facilitating the Business Workshops for Business Requirement clarification with SO’S/SPO’S, Understanding and designing the Current TCM workflow. Requirement gathering of all source data from the SME’S and to work out on mapping rules. Writing SQL scripts to extracts data from different sources to calculate the percentage for different applications like IBM Model cost, People cost, Vendor cost which involves direct allocation cost and indirect allocation cost.
• Collaborated with IT to ensure data security measures were in place, safeguarding sensitive information. Created dashboards to monitor and track key performance indicators.
• Skills utilized: Data Analysis, Project analysis, Project Management, SQL server 2017, Power BI, MS Excel

• As a Technical BA involved in Working on the Business/Technical pack to implement ALEX tool across various business teams (Retail, GBS, Networks, B2B and B2C)
• Liaising with different business unit across Telstra to understand the case studies for data mapping rules and for the technical specification to create new reports.
• Managed stakeholder expectations by providing clear updates on project progress, risks, and mitigations.
• Conducted thorough requirement gathering sessions to ensure accurate understanding of client needs and priorities.

• As a Technical BA/Testing analyst involved in working on the SAD, IACS document to build by identifying project milestones, phases, and elements
• To the new API Interface
• Facilitating the Business Workshops for Business Requirement clarification with stakeholder and source SME’s.
• Gathered feedback from end-users to identify areas for system enhancements or adjustments to better align with evolving business requirements.

• As a data analyst was responsible for facilitating the Business Workshops for Business Requirement clarification with stakeholder and source SME’s, Writing SQL scripts to manipulate data for data loads and extracts
• Analysing raw data to test and define transformation rules, Responsible for loading, extracting and validation of client data into data labs.
• Conducted ad-hoc analysis to address urgent business questions, facilitating rapid response to market changes.
• Analyzed data to identify root causes of problems and recommend corrective actions.

• As a data analyst Involved in supporting of Daily data ingestion and server administration processes for the Prepaid Commission Solution
• Writing SQL scripts to manipulate data for data loads and extracts
• Analysing raw data for data Ingestion using SSIS package
• Daily check of overnight database and file movement activity in batch logs
• Running the packages for data ingestion in weekly basis and monitoring the daily batch execution using SSIS.

• As a Data analyst/Finance system specialist was involved in facilitating the business Workshops for Business Requirement clarification with stakeholder and Source SME
• Writing SQL scripts to manipulate data for data loads and extracts
• Analysing raw data, Responsible for loading, extracting and validation of client data into data labs
• Provide permanent solutions for reporting problems on the data
• Verify the requirement specification.
• Evaluated existing systems for improvement opportunities, resulting in increased performance and reduced costs.
• Conducted gap analyses between current state systems/processes and future state goals in order to formulate action plans aimed at bridging identified discrepancies.

• As an Finance system specialist was Involved in supporting of various data analysis and data extraction of employee’s timesheet data and managing it on weekly basis
• Designed and developed graphical reports for Employee time sheet using Tableau.
• Provided exceptional support services to internal stakeholders by resolving technical issues quickly and accurately.
• Analyzed large volumes of raw data to identify trends, patterns, and insights that informed strategic planning initiatives.

• As a Data analyst Performing the data analysis of HR reporting and creating HR analytical reports using Qlik view and Tableau
• Engaged in weekly extraction of WASP data from SAP server and uploading the same data to reporting server for the report generation
• Produced monthly reports using advanced Excel spreadsheet functions.
• Improved decision-making processes with accurate data analysis and visualization techniques.
• Conducted comprehensive data analysis to support strategic planning, leading to more informed decision-making.

• As a Reporting analyst Involved in supporting of data extraction of employee’s timesheet data and managing it on weekly basis
• Created invoicing and SLA reports for PMO meeting and for weekly or monthly invoicing
• Designed and developed graphical reports for Employee time sheet using Tableau.

• As a Reporting analyst Involved in data migration activities, was responsible for data extraction from one data source to other data source using ETL tools
• Liaising with all the account managers and CFO for the requirement gathering/progress monitoring and project update
• Created financial reports using Power BI and Tableau for all the customer and carriers to access their daily and weekly transactional reports for business purpose or any decision making.
• Used statistical methods to analyze data and generate useful business reports.

• Involved in various roles and projects, performed various tasks in data migration activities and solely planned and deployed E2E packages from E2E test server to production server using SSIS packages
• Providing support and maintaining E2E application ensuring that the data is uploaded in to the E2E server from the Reporting Data Warehouse (RDW), Providing technical support to key applications within finance and revenue division
• Responsible for rolling over all financial applications
• Successfully completed the deployment of the E2E reporting packages from test sever to production with minimal supervision and assistance and was applauded by the stakeholder and the client
• Also, was successfully completed all the applications rollover from 2014-2015 to 2015-2016 on time.

• As a Senior consultant, was involved in providing technical solution to the payroll systems and installations of the payroll application and E2E application to the Client server and managing the servers
• Maintaining security and data integrity of the database
• Scheduling the daily Jobs.
• Developed innovative strategies to address complex business challenges, resulting in increased profitability for clients.
• Built strong relationships with clients through consistent communication and proactive problem-solving efforts.

• As a BI analyst involved in data migration from SQL server 2000 to SQL server 2008.
• Implemented effective change management strategies during technology transitions, minimizing disruptions to regular operations while maximizing user satisfaction levels.
• Provided crucial input during system migration projects, ensuring seamless integration of new BI tools into existing infrastructure without compromising data integrity or functionality.