Naya Teja Kadamati

Total 10+ years of IT experience with Technical and Functional experience in Reporting and Business Intelligence (BI), Data Analysis, Testing and Documentation.

Experience in creating reports, dashboards for Daily/Weekly/Monthly and Quarterly MIS reporting to Ensure the timeliness, accuracy, and completeness of the reporting.

Experience in creating reports, dashboards, datasets in Power BI desktop using various visualizations, themes, wallpapers, filters etc. Developed VBA code to extract data from a webpage to match the data in excel.

Experience in publishing the reports on to Power BI service and work in multiple workspaces.

Experience in creating measures and writing DAX code to achieve business requirements in Power BI desktop tool. Prepare presentation in PowerPoint & Dashboard as per the requirement of management. Ownership of automating the sub project data using VBA and Hands on SQL.

Having hands on experience in handling Use Cases, Functional Specification, Knowledge Transfers and Business Analysis. Ownership of UAT Testing for business operations team. Performing business analysis on the technical and functional parts of the process and develop artifacts, approaches and analysis.

Process Analyst – True Capture, Reporting/Sales Analyst at Nextracker (A Flex Company) (2021-07 – Present)

• To measure current progress toward corporate sales targets and set future targets that are reasonable.
• Creating reports in MS Power BI desktop tool from different sources (Excel, Flat files, Salesforce.com)
• Responsible for developing and delivering complex financial reports.
• Supporting regular quarterly and yearly budgeting processes.
• Prepare presentations and report analysis on financials forecasts, attach rates.
• Automating the pre-defined manual excel Reports using VBA Macros.
• Created a Google Web Scrapping tools in excel which fetches the Google Maps address details to excel for no of sites.
• Automated manual MS Excel tasks using macros which boost in productivity.
• Created search bar with the ability to search universally across all fields and show all relevant details in Power BI.
• Dashboard for insight into the sales cycle and highlight general KPIs to measure success.

Senior Analyst, IVY Comptech at IVY Comptech (2019-02 – 2021-07)

Client: Entain plc (formerly GVC Holdings)

• Meeting with business users to gather clarification and/or requirements for the reports.
• Creating Data Model, Transformation in Power BI Desktop.
• Creating reports in MS Power BI desktop tool from different sources (Excel, Flat files, SQL Server)
• Using Query Editor, DAX calculations to clean and transform data in Power BI desktop.
• Creating measures using advanced DAX calculations to achieve business goal.
• Publishing the Reports on to Power BI Service.
• Scheduling of Power BI dataset, report and dashboards in Power BI Service.
• Implemented row level security in Power BI desktop.
• Used a composite model for self-service dataset (Direct Query and Import).
• Planning the data refresh schedule for the self-service Power BI dataset as fact and dim tables were in different storage mode.
• Performance tuning of the reports as they have strict requirement for time of report run.
• Ongoing enhancement of Metrics to mitigate money laundering risks

Subject Matter Expert - Tech Mahindra at Tech Mahindra (2015-08 – 2019-02)

Client: Cisco Systems – CR Operations

• Meeting with business users to gather clarification and/or requirements for the reports.
• Collaborated with MIS team members in the development and organization of information systems
• Analysed all Operational Metrics including: - MIS data utilized for Operational Reporting -Ongoing review of actual productivity and forecast modelling - All relevant Operations reporting
• Developed, tested, and implemented disaster recovery plan for management of company's information systems
• Prepared, managed, and distributed documentation of security procedures and suggestions for upgrades and improvements
• Collaborated with department heads developing personnel training templates

Associate Analyst, Tech Mahindra at Tech Mahindra (2015-08 – 2019-02)

Client: Cisco Systems - MDM

• Conducted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.
• Served as the initial contact person for all Business support queries
• Work with business analyst groups to ascertain their database reporting needs
• Developed Power BI reports and dashboard from multiple data sources using data blending
• Perform data loads and routine updates on an ongoing basis.
• Delivered database deployment through the whole system lifecycle
• Have developed and automated the Process in the Project using Visual Basics
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Resourceful at maintaining relationship with clients to achieve quality product and service norms by resolving their service-related critical issues
• Over 3 years of experience in developing and maintaining application knowledge on Excel VBA and Power BI.
• Ownership of automating the sub project data using VBA.
• Having hands on experience in handling Use Cases, Functional Specification, Knowledge Transfers and Business Analysis.
• Ownership of UAT Testing for business operations team.

Bachelor of Technology – JNTUK University – MPTB College (2011 – 2014)

Diploma – Andhra University – D.S Raju College (2008 – 2011)