Data Analyst Resume
3.00/5 (Submit Your Rating)
Columbus, OH
SUMMARY
- A motivated and proactive individual with a wide range of IT noledge and expertise gathered over the span of 5+ years in fields such as healthcare, Financial, and Banking domain.
- Able to learn unfamiliar material and techniques quickly, exhibit great attention to detail, execute under aggressive deadlines, and adapt quickly to changing circumstances and systems to maintain strategic vision of the organization and link it with everyday work.
- Very passionate about projects and able to carry out tasks that are time sensitive in an efficient manner to guarantee the growth and success of the organization.
- A wonderful team player who values collaboration and communication, eager and possesses a very strong work ethic and can relate and work efficiently with diverse groups.
TECHNICAL SKILLS
Databases: MS SQL Server, MySQL, Oracle SQL Developer, Azure SQL Databases, Snowflake
ETL/Other Tools: SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant
Programming/ Querying language: SQL, PL/SQL, TSQL, Python
Business Intelligence Tools: Tableau, PowerBI, SSRS
PROFESSIONAL EXPERIENCE
Confidential - Columbus, OH
Data Analyst
Responsibilities:
- Wrote complex SQL queries in database to analyze and manipulate data.
- Wrote SAS programs to perform ad-hoc analysis and data manipulation.
- Checked for invalid/out of range data.
- Worked with end users, business, and IT users to understand, elicit, and analyze reporting requirements.
- Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
- Created report schedules, data connections, projects, groups in Tableau server.
- Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
- Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
- Performed Tableau type conversion functions when connected to relational and SAP BW data sources.
- Created incremental refreshes for data sources on Tableau server.
- Transferred data from database as well as MS Excel into SAS for analysis and used filters based on the analysis.
- Used data to Import/Export Wizard as well as data Programming techniques to extract data from Excel.
- Compared data across various data sets and analyzed dimensions of data.
Confidential - Tampa, FL
Data Analyst / Tableau Developer
Responsibilities:
- Created Views and Database Triggers, Stored Procedures and Functions using SQL such that information entered by a certain WM can make appropriate changes to the respective tables.
- Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
- Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.
- Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server
- Involved in extensive data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.
- Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
- Experienced in Data mapping, Data transformation between sources to target data models.
- Analyzed reporting requirements and develop various Dashboards.
- Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, and SQL Server.
- Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
- Experience in creating Filters, quick filters, table calculations, calculated measures, and parameters.
- Responsible for developing, analyzing, and reporting key risk indicator and key performance indicator metrics that enable management to make timely and TEMPeffective decisions related to threats, risks, and control requirements.
- Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
- Used statistical techniques such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design, etc. to solve business problems.
