Manasa Rani

Experienced Data Analyst with a passion for uncovering actionable insights from complex datasets. I have a proven track record of leveraging analytical skills to drive data-driven decision-making and improve business performance. With expertise in data manipulation, statistical analysis, and data visualization, I excel in extracting meaningful insights and presenting them in a clear and concise manner.

With a strong analytical mindset and a continuous learning approach, I am dedicated to transforming data into actionable insights that drive business success. Let's connect to explore how my skills and experience can add value to your organization's data analysis initiatives.

• Around 5+ years of experience in Software Design, Database Design, Development, Integration Implementation and Maintenance of Business Intelligence and the related Database Platforms. 
• As a Data Analyst responsible for Data Modeling, Enterprise Data Management, Data Presentation, Visualization, Optimization, Risk assessment, predictive analysis, advance Data Analysis, Business Research and Quantitative Analysis. 
• Experience in SQL 2017/ 2016/2014/2012 /2008 R2 with an emphasis on design, development, automation, tuning, optimization, Performance and Security. 
• Experience in analyzing business user requirements, analyzed data and designed software solutions in Tableau Desktop based on the requirements. 
• Experience in converting Legacy Reports to Tableau dashboards connecting to SQL server. 
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server. 
• Expertise in Microsoft Integration Services like SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks). 
• Proficient in SQL Server Integration Services like Package creation, Check Points Implementation, Dynamic Configuring of package, Logging, Custom script writing, Package deployment using Manifest, Implementing Transactions, and Package encryption.
• Explore data in a variety of ways and across multiple visualizations using Power BI. 
• Expertise in creating reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. 
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service. 
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance. 
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps). 
• Extensive experience in SQL Server 2016/2012/2008 Business Intelligence tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS). 
• Experience working on Tableau (Desktop, Server, Reader), creating various Reports and Dashboards using different functionalities. 
• Proficiency in working with various Python IDE like PyCharm and Visual Studio Code. 
• Well-Versed in using various packages python-like ggplot2, Pandas, NumPy, SciPy, Matplotlib. 
• Understanding of Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau, Microsoft Excel and Power BI. 
• Proficient in using R for the predictive modelling and data visualization by using MySQL database and text files as source.
• Developed automated workflows and scripts using scripting languages (e.g., Python) to streamline data processing, analysis, and reporting tasks, reducing manual effort and increasing operational efficiency.
• Experience in Tableau Desktop, Power BI for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, 
• Extensive experience in creating complex SSIS packages, creating jobs, Alerts, and schedule SSIS Packages using SQL Agent, migrating the data from different legacy system to SQL using SSIS. 
• Proficient in Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data). 
• Handled various types of encryption and decryptions in SQL as per client requirements to secure data. 
• Experienced in migrating Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and expert in Creating, Configuring and Fine-tuning ETL workflows in SSIS. 
• Hands on in Designing, maintaining, and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing using SSAS. 
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports.

BTECH IN Electronics and Communication engineering