SATYA NARAYANA GOLLA Data Analyst

Location: Garner, NC • Phone: 631-***-**** • Email: ad3g5b@r.postjobfree.com SUMMARY:

Data Analyst with 4+ years of hands-on experience in comprehensive Data Analysis. Proficient in agile and waterfall methodologies, adept at documenting Business Requirements, Functional Specifications, and Business Process Flow. Skilled in Python programming (NumPy, Pandas, SciPy, and Matplotlib) and experienced in Data Analytics, Reporting, and Visualization using tools like Tableau and Microsoft Excel. Expertise includes GAP analysis, Requirements Traceability Matrix, Data Mapping & Modeling, and SQL. Proactive problem solver with strong interpersonal and team-working skills. Seeking to leverage these skills and experience in a challenging Data Analyst role. SKILLS:

Data Techniques: Data Profiling, Data Ingestion, Data Integration, Data Analysis, Data Modeling, Data Mining, Data Migration, ETL, Talend Data Integration, Data Cleaning, Data Visualization, Data Warehouse, Data Extraction Data Related Skills: MySQL, SQL Server, Oracle and MongoDB Languages: Python, Stata, SAS, R and SQL

Libraries: Pandas, NumPy, SciPy, SciKit-Learn, Matplotlib and Tensorflow Data Visualization: Tableau, Power BI, Excel, Pivot tables and MS Office Other Tools & soft skills: Git, GitHub, Price & Market Analysis, Time Management, Customer Support, Leadership and Support/ Resistance Trading

Environment: SDLC, Agile, Scrum, Windows and Mac OS PROFESSIONAL WORK EXPERIENCE:

Company: LatentView Analytics, Remote, US 01/2023 – Present Role: Data Analyst

● Utilize advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

● Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation.

● Gather requirements from customers and involve in various phases of the sprint planning.

● Liaise with the customers and the internal teams to resolve data exceptions and related issues.

● Document instruction manuals for Customers.

● Train customers and internal teams on the product and the business process.

● Determine business impact level for data quality issues, root cause for data quality errors and make recommendations for solutions in the ETL process.

● Perform risk analysis on product migration.

● Evaluate data models / reports in the ETL process for quality, accuracy and make well-reasoned recommendations backed up by strong data visualizations to support the business team.

● Traceability and mapping of requirements to acceptance testing, develop test plan.

● Write simple and advanced SQL queries, and stored procedure, functions for ad-hoc reports for senior managers and customers.

Company: Avenir Technology, India 01/2018 – 12/2020 Role: Data Analyst

● Design, Implement & maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions & Triggers, Constraints, Indexes, Schemas, Functions, Views, Defaults and complex T-SQL queries including T-SQL Bulk Insert and Bulk Copy Program.

● Creating Tableau dashboard reports, working with developers, creating business intelligence reports and visualizations.

● Strong knowledge on Tableau Develop, Design and Support Interactive Tableau dashboards.

● Performed the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

● Involved in the team that migrate the data from Teradata and SQL Server to snowflake.

● Experience in writing Teradata SQL Scripts for loading data to a hierarchical data model.

● Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.

● Created Metadata, created Data Lineage and overall Data Quality Management. Performed data validation by utilizing Python.

● Forecast of spare parts to plan inventory for a marketing client using time series model.

● Perform data manipulation, development and validation of data models using R, and SQL.

● Worked with data-sets of varying degrees of size and complexity including both structured and unstructured data.

● Participated in all phases of Data mining, Data cleaning, Data collection, developing models, Validation, Visualization and Performed Gap analysis.

● Data wrangling to clean, transform and reshape the data utilizing Numpy and Pandas library.

● Contribute to data mining architectures, modeling standards, reporting & data analysis methodologies.

● Conduct research and make recommendations on data mining products, services, protocols, and standards in support of procurement and development efforts.

● Worked with different data science teams & provided respective data as required on an ad-hoc request basis.

EDUCATION:

Masters of Science; Business Analytics Jan 2021 - Dec 2022 The University of Texas at Arlington, TX, USA

Bachelor Electronics and Communication Engineering Aug 2014 - Jun 2019 Amrita School of Engineering, India

Contact this candidate