Home

Bala Anoop Reddy - Sr Data Analyst

[email protected]

Location: Morrisville, North Carolina, USA

Relocation: Yes

Visa: H1B

Professional Summary: Data Analyst with 9+ years of experience in Data Analysis, Machine Learning, Data mining with large data sets of Structured and Unstructured data, Data Acquisition, Data Validation, Predictive Modeling, and Data Visualization. Good knowledge and experience in Software Development Life Cycle (SDLC) and its phase s requirement gathering, Analysis, Design, Implementing, Deployment, and Maintenance. Experience in Data Analysis, Data Validation, Data Modeling, Data mapping, Data Verification, Data loading, and Data mining through understanding various Requirements, analyses, and Designs. Highly skilled in using visualization tools like Tableau, ggplot2, dash, and flask for creating dashboards. Adept in statistical programming languages like R and Python. experience in the Alteryx platform, and involved in data preparation, data blending, and the creation of data models, and data sets using Alteryx. Offloading historical data to Redshift spectrum using Matillion, Python and AWS glue. Working in distributed computing. Expert in Adobe Analytics, Adobe Dynamic Tag Manager Defined stakeholders, established workflow processes, defined Roles and Responsibilities, provided training and support, maintained and managed data reporting, and created a user toolkit. Experiencein Data Extraction, Data Management, Data Cleansing, Data Profiling, Data Consolidation, and, Data Quality for various business data feeds. Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports Deployed reports on the web using Crystal publishing wizard and scheduled reports using e-Portfolio and Crystal management console Worked on the data architecture framework implementation for Informatica ETL environment. Worked with AWS Cloud platform and its features which include EC2, VPC, RDS, EBS, S3, CloudWatch, Cloud Trail, and Quick Sight. CloudFormation and Autoscaling etc. Sound experience in programming in SQL Server 2000/2005, SSIS 2012/2008r2 Used AWS command line client and management console to interact with AWS resources and APIs, JSON. Experience on Cloud Databases and Data warehouses (SQL Azure and Confidential Redshift/RDS). Experienced in creating Data Flow Diagrams, Use Cases, Use Case Diagrams, Activity diagrams, Entity Relationship Diagrams, Data Mapping, and Data Integration. Created roles and access level privileges and taken care of Snowflake Admin Activity end to end. Converted 230 views queries from SQL server snowflake compatibility. Experienced in creating Data Flow Understanding the client s business problems and analyzing the data by using appropriate Statistical models to generate insights. Excellent technical skills consistently outperformed schedules and acquired interpersonal and communication skills. Hands-on experience with Snowflake utilities, Snow SQL, Snow Pipe, Big Data model techniques using Python. Technical Skills: Programming Languages SQL, Python (NumPy, scikit-learn, Pandas, Matplotlib, etc.), R, HTML, CSS, JSON Machine Learning Linear Regression, Logistic Regression, Decision Tree, KNN, K-Means, Principal Component Analysis (PCA) etc. Databases Oracle, MS SQL Server 2012/2014/2016, MySQL, PostgreSQL Cloud Platform AWS (Redshift, S3, EC2, etc.) Operating systems Windows 7 or more, Windows Server 2008/2012, UNIX, LINUX, IOS Analytical Tools Jupiter Notebook, Excel. Visualization Tools Tableau, Qlik Sense, Qlik View, Power BI, SAS Viya RPA Automation Anywhere Project Management Tools Smartsheet, MS Office (Word, Excel, PowerPoint, Access, Outlook), MS Project Keywords: business intelligence sthree active directory rlang microsoft