Adaptable Data Analyst skilled in recording, interpreting and analyzing data in a fast-paced environment. Advanced proficiency in all aspects of Excel. Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.
Ability to grasp new concepts quickly and efficiently.
Expert in Sql coding
Proficient in Microsoft Excel
Excellent problem-solving abilities
Excellent communication skills
Java programming OCPJP Certified
Junior Data Analyst, 04/2015 to 10/2016 Target – Minneapolis, MN
Roles and Responsibilities:
Responsible for gathering requirements from Business Analysts and
Operational Analysts and identifying the data sources required for the
requests. Designed and developed various SQL scripts as part of automation
of manual monthly reporting to third party consumer.
Worked on data profiling, data analysis and validating the reports
sent to third party.
Designed and developed Ad-hoc reports as per business analyst,
operation analyst, and project manager data requests.
Extracted, Analyzed and Presented Data in a Graphical Format using Microsoft Excel, such
a way that helped project manager to make Business Decisions
Proficient in importing/exporting large amounts of data from Excel files
to Teradata and vice versa.
Macro to create Weekly reports.
Used Joins like Inner Join, Outer join while creating tables from
Worked on Data Verifications and Validations to evaluate the data
generated according to the requirements is appropriate and consistent.
Experienced in using OLAP functions like sum, count, csum and etc.
Proficient in working on Set, Multiset, Derived, Volatile
Designed and developed weekly, monthly reports related to the
marketing and financial departments using Teradata SQL.
Experience in Power Point Presentation (Financial Data, Charts).
Expertise in generating graphs using MS Excel Pivot tables. Extracted data from existing data source, Developing and executing
departmental reports for performance and
response purposes by using SQL, MS Excel.