1) 5.4 years of Experience in Data Analytics, Report Generation, Maintenance of Business Report Processes and Data Verification's and expert in excel
2) Extensive SQL experience in querying and data extraction
3) Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point.
4) Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
5) Wrote several Teradata SQL Queries using Teradata SQL Assistant for Adhoc Data Pull request.
6) Used Joins like Inner Joins, Outer joins while creating tables from multiple tables
7) Created pivot tables in Excel by getting data from Teradata
8) Create profiles for loyalty member who hold the Sears membership card and write insights after analyzing profile
9) Manage and update report orientation and structures with the use of advanced Excel functions including Sumifs and V-Lookups
10) Analyze information like Summary Statistics, BU shopping, Segmentation, Trips, Demographics that easily fulfill the requirements related to a particular member or group of members