MANOPSITA REDDY
Toronto,ON
Summary
OBJECTIVE: Database professional with 4+ years of experience leading in technology and banking services. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Skilled at using Business Intelligence (BI) and data analytics, statistical analysis and data visualization tools. Seeking to contribute analytical skills and expertise in a dynamic data-centric role. Worked with various business owners to identify best use of technology to drive intelligent business decisions to reduce costs and increase revenue.
Overview
6
6
years of professional experience
Work History
Data Analyst
Global Relay
04.2022 - Current
- Assisted in data collection and data interpretation for business intelligence purposes and conducted data validation and quality assurance to enhance accuracy in reporting
- Data analysis and data migration by transferring them using SSIS packages
- Experience with logical and physical data modelling and database design using Erwin
- Worked on setting up High availability and Disaster Recovery solutions like Geo-replication
- Experience in Analyze, design, and build Modern data solutions using Azure PaaS service to support visualization of data
- Understand current Production state of application and determine the impact of new implementation on existing business processes
- Removed Security Vulnerabilities from Multiples Machines on both On Premise and Azure by consistently applying patches and hot fixes
- Conducted Exploratory data analysis (EDA) on huge data sets to identify patterns, trends, and any anomalies
- Developed and Implemented data cleaning process which resulted in enhancing data accuracy and reliability
- Performed statistical analysis to extract meaningful insights and present it to stakeholders
- Extract Transform and Load data from Sources Systems to Azure Data Storage services using combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics
- Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing data in In Azure Databricks
- Experience in publishing Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
- Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards
- Developed Spark applications using Py-spark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming data to uncover insights into customer usage patterns
- Expert in creating simple and parameterized reports and complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS
- Experience in writing expressions in SSRS and Expert in fine tuning reports
- Created many Drills through and Drill Down reports using SSRS
- Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
- Capable of forming and maintaining positive and productive working relationships in internal/external and team environments
- Built models for Azure platforms using Python and Py-Spark for model development and Visualization.
Data Analyst
HDFC Capital
04.2018 - 09.2020
- Involved in Technical and Business decisions for Business requirement, Interaction with Business Analysts, Client team, and Development team through Agile Kanban process
- Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics
- Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing data in In Azure Databricks
- Writing Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), create and maintain records
- Strong experience in designing and implementing ETL packages using SSIS for integrating data using OLE DB connection from heterogeneous sources
- Created Complex ETL Packages using SSIS which upsets data from staging table to database tables
- Experience in creating reports from scratch using Power BI and Tableau
- Designed and implemented ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012/2014/2016
- Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and controlling and granting database access and Migrating On premise databases to Azure Data Lake store using Azure Data factory
- Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2008 Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity
- Built ad-hoc reports using SQL Server Reporting Services (SSRS)
- Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
Education
Post-Graduate Diploma - Computer Application Development
Conestoga College
Waterloo, ON04.2022
Post-Graduate Diploma - Big Data Solutions and Architecture
Conestoga College
Waterloo, ON04.2021
Bachelors in Technology - Computer Science
Mallareddy Engineering College
Telangana, India05.2018
Skills
- TECHNICAL SKILLS
- Programming Languages:
- Python, R
- Data Analysis Tools: SQL, Excel, Jupyter Notebooks
- Data Visualization: Tableau, Power BI, Matplotlib, Seaborn
- Statistical Analysis:
- Hypothesis testing, Regression Analysis, Clustering
- Database Management: MySQL, SQLite
- Machine Learning: Scikit-learn, TensorFlow
- Data Cleaning: Pandas, NumPy
- Version Control: Git
- Project Management: Jira
- SKILLS
- Strong analytical and problem-solving skills
- Team player and excellent communication skills
- Attention to detail and data accuracy
- Problem solving, Adaptable and result oriented
- Ease to learn new technologies
- HRJ#032b4c5b-96e6-4746-b03a-36092104100b
References
REFERENCES
Available upon request.
Timeline
Data Analyst
Global Relay
04.2022 - Current
Data Analyst
HDFC Capital
04.2018 - 09.2020
Post-Graduate Diploma - Computer Application Development
Conestoga College
Post-Graduate Diploma - Big Data Solutions and Architecture
Conestoga College
Bachelors in Technology - Computer Science
Mallareddy Engineering College
Similar Profiles
James MedinaJames Medina
Chef at Global RelayChef at Global Relay
MICHAEL YOUMANSMICHAEL YOUMANS
Group Product Manager at Global RelayGroup Product Manager at Global Relay
Manopsite ReddyManopsite Reddy
Data Management Analyst at Global RelayData Management Analyst at Global Relay
Angelica AbuqueAngelica Abuque
Home Childcare Provider at BRADLEY MAZDAHome Childcare Provider at BRADLEY MAZDA
Shana KhoshnawShana Khoshnaw
Tutor at Toronto District School BoardTutor at Toronto District School Board