Sri Rekha Kantamaneni
Bengaluru,TG
Summary
Motivated and results driven BI Operation Specialist with 7 years of experience in business needs analysis, integrating and transforming data using SSIS, data warehousing and generating reports using Power BI which contributed to the organization growth. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success. Proven track record of successfully streamlining business operations and reducing costs. Adept at analyzing data to identify trends and developing strategies to improve efficiency.
Overview
7
7
years of professional experience
Work History
BI Operation Specialist
Epiroc
11.2022 - Current
- Analyzed production workflow bottlenecks and made process improvements recommendations and implemented those which in turn decreased number of incidents by 60% monthly.
- Used TFS (Team foundation server) source control tool to check in all codes in daily basis which is integrated with Agile tool like Azure Devops.
- Provided technical documentation which helps peers for future use.
- Created stored procedure and views in MS SQL Database as part of application process and development.
- Improved processes by automating and reducing human intervention in turn avoiding human errors.
- Implemented Change deployment process to confirm that only appropriate changes have been implemented into production.
- Implemented all Audit tasks and ensured application is in compliance with organization IT standards.
- Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
- Implemented database security related events such as logging DDL and DML activities and storing in storage blobs that are created on Microsoft Azure.
- Evaluated potential risks associated with new changes, informing decision-making processes accordingly.
- Performed root-cause analysis to understand data problems and find solutions by understanding user requirements.
- Involved in analysis and implementation of migrating from existing MDX cube to Tabular cube and excel reports to Power BI reports.
- Handled all Change Requests through service management tool like Service Now.
- Collaborated with cross functional teams to identify opportunities for process improvements, driving increased operational effectiveness.
BI Analyst
Mphasis
06.2020 - 10.2022
- Analyzed and validated data using SSMS. Designed data flow, Test Cases and supported users with UAT.
- Optimized data collection methods by identifying gaps in existing databases and recommending corrective actions, improving overall data quality.
- Assisted with creating data cubes and OLAP models(snowflake schema) to improve data analysis in SQL Server Analysis Services(SSAS).
- Used multiple transformations in SQL Server Integration Services(SSIS) to meet business requirements by collecting data from various sources.
- Data was integrated from multiple sources like CSV, excel and SQL Database, transformed in Power Query and designed data modelling in Power Pivot.
- Used DAX functions, filters and various visualizations according to report needs.
- Reduced development time by creating reusable code libraries for future projects.
- Configured check points and logging for master and child packages at different levels of loading.
Business Analyst
Tata Consultancy Services
07.2015 - 10.2018
- Supported software development projects by defining clear requirements and effectively communicating them to technical teams.
- Interacted with PwC stakeholders to understand business needs and translate into requirements and project scope.
- Performed gap and SWOT analysis to identify areas of improvement.
- Worked on User Requirements Specification(URS) and Software Requirement Specification(SRS) documents.
- Streamlined project management with effective communication and collaboration across cross-functional teams.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
Education
MBA - Marketing
Alliance University
Bengaluru, India04.2015
B. Tech - Electronics & Communication
VNR VJIET
Hyderabad04.2013
Skills
- MS SQL Server T-SQL
- SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),
Power BI
- Microsoft Azure - Azure SQL Server, Azure Data Factory(ADF), Azure Data Bricks(ADB)
Certifications
- Microsoft Azure - AZ 900
- Data Engineering on Microsoft Azure by Cornerstone
Timeline
BI Operation Specialist
Epiroc
11.2022 - Current
BI Analyst
Mphasis
06.2020 - 10.2022
Business Analyst
Tata Consultancy Services
07.2015 - 10.2018
MBA - Marketing
Alliance University
B. Tech - Electronics & Communication
VNR VJIET
Similar Profiles
Mallory ScottMallory Scott
Wireline Field Engineer at EpirocWireline Field Engineer at Epiroc
Ivan Antonio OrtizIvan Antonio Ortiz
Field Service Technician at EpirocField Service Technician at Epiroc
Erik LamoureuxErik Lamoureux
Heavy Equipment Mechanic at EpirocHeavy Equipment Mechanic at Epiroc