ANITABASUKALA

DATA ANALYST

Executive Summary:

●IT experience in various phases like Data Analysis, validation, Extraction, Transformation, Loading and reporting using SQL, Python, AWS and Grafana.

●Expertise in writing large/complex SQL queries using Joins, Views, volatile tables, Sub Queries, Stored Procedures, Indexes, Constraints and OLAP functions.

●Experience in moving data from S3 bucket to Grafana using Dashboard.

●Proficient in performance analysis with SQL query tuning using Explain plan, Collect Stats

●Experience in Performing Grant, Revoke table accesses to Database Analysts, Business Analyst, Operational Analysts and Project Manager.

●Strong hands on experience in developing dash boards, stories, data visualizations and analytics using Grafana, Strong experience of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall and Agile.

●Have excellent writing skills in preparing Business Requirements Documents (BRDS)

●Designed reports and user interface to meet client distribution and use requirements

●Participated in designing Business Objects security domain, universes, reports and scheduling processes.

●Have excellent verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.

●Performed tasks of gathering, analyzing and storing information.

●Experienced with creating tables, stored procedures and queries in SQL server.

●Experienced with creating tables, stored procedures and queries in R studio.

●Experienced in Creating Pivot Tables and Performing Data analysis.

●Handled the responsibilities of analyzing and documenting business requirements.

●Experience in maintaining and developing Weekly, Monthly and Quarterly large financial reports.

●Good Knowledge on Agile Methodology and scrum process.

●Familiar with Agile methodology.

●Experience in planning, designing, and programming, testing and implementing client projects.

●Adept at strong attention to detail from requirements, design, to development and testing of the reports and dashboards, as well as data warehouse, data storage structures, data mining, and data cleansing

●Provides supports to supervisors by documenting organizational structures, internal processes and clients’ business requirements.

●Expertise in creating Queries for the application team and for the end users based on the business requirement.

●Objects creation such as Tables, Views, and User created Data Types, Stored Procedures, and Triggers.

●Experienced with visualizing data and tables in Grafana.

●Successfully engaged in multiple initiatives simultaneously.

●Experienced in ETL from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.

●Used Query Analyzer to optimize SQL queries.

●Experienced in optimizing SQL code by understanding execution plans, using SQL Profiler, DMVs, Index tuning wizard and other tools.

●Incorporated complex business logic into functions for reusability. Proficient in preparing Power Point Presentations using PowerPoint, graphs, tables and charts using MS Excel.

●Quick to learn new technologies and ability to work in tight schedules on different applications concurrently.

●Hands-on Experience in Agile Scrum Working Environment.

TECHNICAL SKILLS:

Methodologies:

Iterative, Agile, Waterfall Methods

Tools:

Grafana, AWS

Operating Systems:

Microsoft Windows 2000/XP/Vista, OS/2, Mac

Databases:

Microsoft: MS Access, SQL Server 2005/2008/2012

IBM: DB2

Language:

SQL, PL/SQL, Python, R-studio

Applications:

Office 2010/2013/Visio

EDUCATION:

University of Bridgeport, Connecticut, CT

Master of Business Administration and MS, 2019

Cumulative GPA: 3.6

School of Environment Science and Management, Nepal

Bachelor of Business Administration, 2014

Cumulative GPA: 3.4

Contact this candidate