BHAVNA THAKKAR

Naperville, IL ***** ● 630-***-**** ● addzvb@r.postjobfree.com

● Linked in: Bhavna_Thakkar, ● skype ID: live:cid.37d0109b9aa17215 ● US Citizen

BI Reporting Analyst

Experienced (8+ years) BI Reporting Analyst professional with a background across a wide variety of industries including Metals, Healthcare, Insurance and Banking. Known and recognized for working collaboratively across all levels and with all constituencies to understand and solve problems through effective use of systems and technology. Proven success in delivering Reports within specified time frames. Self-starter and quick learner with excellent Reporting Skills, analysis, communication and multi-tasking skills along with ability to work effectively in a fast-paced team environment.

TECHNICAL SKILLS

Report writing, Scheduling, testing using Excel, Access, SQL, Cognos, Power BI, Sales Force (CRM)

Requirements specification gathering and documents

Exceptional abilities in AD-HOC reporting, data analysis, problem-solving, troubleshooting and organizational skills.

Heavy reports Creation using BI Tools Like Access, Excel, Visio, SQL, Cognos, Power BI

Experience creating G Suite tools Gmail, Drive, Sheets

MS Office with Excel V-Lookup, Pivot table, Charts, Formulas, Macros, Dashboards

Security Implementation at different levels in Cognos Connection

Databases: SQL, Access, Excel Advanced Microsoft Office skills

Knowledge of T-SQL, JAVA, JCL

PROFESSIONAL EXPERIENCE

TURANO BREAD COMPANY, Berwyn, IL 01/2020 – 03/2020

POWER BI DEVELOPER

Developed new dashboards, Matrix, KPIs, for Daily weekly, Monthly and Historical Sales data.

Developed custom dashboards & visuals using specific data like previously created SSRS Reports.

Created Date Dims, calculations using new measure, Dax formulas, SQL queries using and ETL using Power Query M.

Performed excellent analytic solution and translated data into meaningful visualizations.

Implemented row level security on Product data.

Imported data thru different data sources, Write SQL queries to connect to data source.

Worked on SSRS Reports and moved SSRS reports in Power BI Reports.

Worked with data engineers to identity and understand source data system & business requirements for solutions delivery.

Work with data team to understand system requirements, producing both business process and technical documentation, and translating into data solutions. Design, development, and test Power BI solutions.

Created a Gateway in Power BI, Publish the report using Gateway, set up the row level security per group or users according to their Roles.

BHAVNA THAKKAR Page 2

RYERSON INC, Lisle, IL 10/2014 –8/2019

Metal processor and distributor, offering more than 65,000 varieties of stainless, aluminum, carbon and alloys in all shapes and sizes, which can be configured to exact customer specifications.

Report Developer and Analysis

Designed, created and maintained TM1 applications (cubes, dimensions, rules and processes) used by analytic staff.

Provided new TM1 Report Views as needed using TM1 and Excel

Analyzed data with Excel and Power BI

Developed & supported the standard/ad hoc reports against TM1 using Cognos, Excel, Power BI, reporting tools.

Accountable for creating new Cognos reports using TM1 data and Query and maintaining updated reports.

Performed Manual testing for Cognos and Excel old and new reports and update.

Created Dashboard using Power BI for FP&A, GM, ISO, OSR

BLUE CROSS BLUE SHIELD OF ILLINOIS, Naperville, IL 6/2013 – 9/2014

Large Healthcare Insurance provider.

Business Intelligent Analyst:

Extracted information from Data warehouse using SQL and prepared Ad hoc and various types of reports as per client requests.

Technology utilized: ODS Database, Vantage software system (VAS, VMS) and Cognos Reporting Studio (10.2 version)

Developed & supported the standard/ad hoc reports against TM1 using Cognos tools.

Created Excel reports using Conditional statements, Calculation and Formulas, V lookups, Power Pivot and Power Query.

CITI GROUP, Elk Grove Village, IL 11/2010 – 5/2013

BI Analyst

Extracted information from database using SQL for Ad hoc, weekly and monthly marketing reports and created Reports using Access, Excel, SAS applications.

Manipulated data extracted from the database with Excel pivot tables and lookups.

Developed monthly and weekly reports for Home Depot portfolio.

Prepared trend reports for Home Depot in order to find spending patterns for specific area codes.

Prepared Trend reports for Home Depot Stores for Commercial clients and their parent-child accounts actives.

ARTHUR J. GALLAGHER & CO., Itasca, IL 10/2007 – 10/2010

U.S. based global insurance brokerage and risk management services firm.

Reporting Analyst

Collected information from end users and design, develop and deploy reports.

Created and maintained key monthly reports and charts/graphs to measure client’s efficiency and cost savings on Worker’s Comp insurance premium, claim and payments-related issues.

Utilized Crystal report software, Tandem, SQL, Cognos, Access and Excel application tools and created Daily, Weekly, Monthly and Yearly Financial, KPI, Trending reports.

Created tables, views, forms using Access and SQL.

BHAVNA THAKKAR Page 3

MENLO LOGISTICS, Aurora IL 4/2007 – 9/2010

Global Supply Chain and logistics management company.

Reporting Analyst

Created and maintained weekly, monthly Logistics reports and charts/graphs to measure client’s efficiency and cost savings on shipping cost by Utilized Crystal report software, Access and Excel application tools.

TRANSACT FUTURES INC, Chicago IL 5/2005 – 12/2006

A Futures Commission Merchant (FCM) that provides access to global electronic futures markets.

Help Desk Support

Supported client’s proprietary financial trading software system. Provided real-time support to a group of 500 users on company’s multiple financial trading software applications.

KELLY SERVICES, Chicago, IL 3/2002 – 4/2005

Reporting Analyst

Downloaded daily ad hoc reports from FTP system, converted them to Excel and Access database files, inserted additional information and prepared new data for uploading into the customer’s system.

Worked on Oracle Service Contracts module and utilized knowledge of the software implementation lifecycle.

Responsible for troubleshooting errors on service contract conversion files selected for migration from legacy system to Oracle.

EDUCATION

Bachelor's in Computer Information Systems

DeVry Institute of Technology, Addison IL

Bachelor's in Business Administration, Finance and Accounting

Gujarat University, Ahmedabad, India

Contact this candidate