Business Data Analyst – Business Intelligence Analyst

PROFESSIONAL PROFILE SUMMARY

3+ years of Professional experience in Finance, marketing, IT industries with strong business acumen for e-commerce market reporting requirements, Financial sales and budget data analysis etc.

Highly motivated and result driven data analysis with experience in working closely with clients to understand business needs, Functional needs and Reporting Needs. Strong in communication skills, leadership skills and problem solving skills.

Have Strong experience in writing SQL queries and scripts for tracking data exceptions and presenting the results to the business team.

Have worked in developments of Business intelligence predictive models and statistics for predicting future impact on businesses.

Have Internship experience in data Visualizations including designing various key reporting dashboards using Looker, Tableau.

Very strong experience in Daily reporting needs of Executives for tracking variations in performance and risk indicators, dashboards for assisting the business decisions.

Skills

Data Analysis and Reporting: SQL server tools (SSIS, SSAS, SSRS), Tableau, BI Looker, SAS Miner, Google Analytics, R studio

Programming and Scripting Languages: SQL, R, Java script, C#

Databases: Microsoft SQL Server, MS Access

Platform: Microsoft Windows (95, 98, 2000, 2007, XP)

Project Management: Microsoft Project (MS), Microsoft Office, MS Access

PROFESSIONAL BACKGROUND

Natural Health Trends Global Corp, Rolling Hills, CA

Business Data Analyst July 2016 – August 2016

I worked closely with IT and marketing teams to manage and keep track of customer feedbacks on daily basis for making business decisions on Product promotions during on/off seasons.

Responsibilities:

Managed enterprise level SQL server database with ETL tasks and data validations using SSIS and C# scripting with Regex expressions

Designed and Managed NHTC website pages as per global requests using Word-press and HTML

Supported IT team with development of Reports including product revenue charts, profit margin, cost of goods sold and acquisition per online user comparison graphs, total sales report using Google analytics and MS Excel Lookups, Pivots, INDEX-MATCH formulas, Basic Macros for tracking performances through all the departments to assist critical business decisions. Applied visualization on these reports using Calculated measures and cascaded quick Filters in Tableau and BI Looker to present these reports at an executive level

Used SQL window functions, stored procedures for managing SQL server database with daily data loading needs with strong query optimizations

Daily Reporting tasks to track down relationships between Key performance indicators for e-commerce business based on customer behavioral and shopping pattern

Gathered business requirements through interviews, surveys with Hong Kong clients

Dun and Bradstreet, Malibu, CA

Data-works Internship February 2016 – April 2016

Main project involved credit check on customers based on their business history with Dun and Bradstreet, Analysis of Customer details like psychographics, demographics etc.

Responsibilities:

Daily analysis of data to validate business rules and to identify missing credit records from database

Stronger developments and scripting using C# for data validations on external feed source files containing financial invoice and payment data, customer psychographic and demographic data

Helped Business intelligence team in various analytical projects involving customer credit score predictions, customer risk segmentations using linear regression models in R studio.

Managed enterprise level SQL server data warehouse with data extraction, load tasks using SSIS and designed various staging schemas for data transformations.

Sun Up Financial LLC, Irving, TX

Analytics Internship September 2015 - December 2015

Main tasks consisted of managing and analyzing the payment invoice data and creating dashboards showing customer satisfaction levels, Total budget charts etc.

Responsibilities:

Collected and merged data from various external sources with focus on analysis of financial transactions and tracking of payment invoices.

Performed tasks of data cleaning, data mining on structured data obtained in flat files, csv files and unstructured data obtained through loan systems, Scanned images of payment invoices etc.

Used basic MS Excel macros for comparing invoice files to generate reports of missing invoices for each year.

Was actively involved in daily finance meetings with chief financial officer, portfolio officers to manage org charts, Agile project management, discussions on financial performance indicators.

Infosys Technologies Ltd, Pune, India

Systems Engineer October 2011 - July 2014

I was involved in Finacle CRM department with support projects for launching and troubleshooting finacle application for the banks in Asia and Africa to successfully manage their business processes and financial needs.

Responsibilities:

Actively delivered projects with UI development tasks, front-end and backend database mapping tasks, sql server database design tasks using Finacle CRM tool

Managed Finacle application design and testing /troubleshooting using Resource files (XML), stylesheets (XSL), CSS, SQL, Java Script etc.

Designed SQL server database with respect to Finacle application attributes and helped administration team for migration of database to higher versions

Developed customer loan milestone reports for tracking down the performance and success rates of each secured and unsecured loan approval business process step.

Involved in activities of CIF creations, CIF modifications, Approvals, Deduplication checks, Minor customer conversions using Finacle business objects

Worked as a database expert and IT Support person at Client locations

ACADEMIC BACKGROUND

The University of Texas at Dallas, Usa Graduation: May 2016

Master of Sciences – Information Technology Management

Fr. Agnel’s Institute of Technology, India Graduation: May 2011

Bachelor of Engineering – Electronics and Telecommunications

Coursework:

Business Intelligence and Data warehousing

Database management using SQL server

Introduction to Google analytics Reporting for KPI’s

Introduction to ETL and Scripting

Software Project Management

Project work:

Business Intelligence Project

Objective: Prediction of Rental Bikes for Capital Bikeshare In Washington DC

Dataset: Kaggle Data Science Community

Skills: Linear Regression Model Statistics in Rstudio/SAS miner

Business Data Warehousing Project

Objective: Designing a Data warehouse using Healthcare data

Dataset: Online information from practice fusion networks

Skills: Data validations, Data mining using SQL server tools

Contact this candidate