OBJECTIVE

• An experienced detail - oriented, goal-driven, self-motivated individual with successful record of s in the business and IT industry. Major strengths include strong leadership, excellent communication skills, strong team player, embrace new challenges and eagerness to learn new things. Proven expertise in accounting rules and regulations, accounting procedures, financial investigation backed with an extensive knowledge of SQL, TSQL, Data visualization tools Power BI & Tableau and Python.

SUMMARY

• Over 2+ years of professional experience in building Data Analytics and Business Intelligence infrastructure and solutions which led to increased efficiency in business operations.
• Closely worked with different management levels from Product, Technology, Finance and Marketing Teams to understand the business requirements and analysis needs.
• Attended daily standup meetings to discuss the tasks at hand and weekly meetings to manage performance.
• Knowledge of various business rules and regulations.
• Experienced in writing complex T-SQL queries: stored procedures, derived tables, CTEs, views, sub-queries, and multiple joins etc.
• Performed Data Analysis and Data Validation by writing complex SQL queries.
• Proficient in main Business Intelligence technologies such as Tableau and Power BI for creating dynamic dashboards and reports for various business functions.
• Good Understanding of Visualization Techniques by creating summary and detailed reports Using Drill Down and Drill Through techniques.
• Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Bins, and Parameters etc. for summarizing and analyzing key analytics findings.
• Proficient in design and development of various dashboards, reports on Power BI Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement.
• Expertise in designing and developing filter driven interactive Dashboards, trend based KPIs, summary and detail reports featuring parameters, sorting, expressions, drill down and drill through, etc.
• Extensive knowledge on Extract, Transfer and Load (ETL) process using MS SQL Server Integration Services (SSIS) for Data migration and Data Warehousing projects along with good project management skills.
• Well-knowledge how to pull data by using SQL Server and SSIS from database automatically.
• Skillful with MS SQL Server Reporting Services (SSRS), Power BI and Tableau in developing reports for summarizing and analyzing key analytics findings.
• Designed and built summary and detail reports with drill down and drill through features using DAX and T-SQL.
• Great Leadership qualities and excellent communication skills. Can work independently or within a team, self-motivated, determined, optimistic, and willing to learn new technology. Ability to stay calm in stressful situations and adapt to new surroundings quickly.
• Well experienced in Microsoft office, Quick Books, Peachtree and bookkeeping as well as other applications such as AS400, IProcurement, Telerev, CARS, ECARS, Oracle, Citrix, iPayable, Hyperion and more.
• Great knowledge in TicketTech, Skidata, WPS, TIBA, DataPark and Amano equipment’s.

TECHNICAL SKILLS

Data Analytics: Data Cleaning, Visualization and Normalization

Reporting Tools: Power Bi and Tableau

Languages: SQL, TSQL and Basic Python

IDE: SQL Developer, SQL Server Management Studio, Jupyter

Python: Pandas, NumPy, Matplotlib, Seaborne

Databases: MySQL, SQL Server, Oracle

ETL: SQL Server Integrated Services (SSIS)

Operating System: Windows and MacOS

Repository System: GitHub

Cloud Technologies: AWS

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential

Responsibilities:

• Supported management team with reports generation and analysis using reporting and visualization on Power BI.
• Worked with Management teams from various departments to create departmental KPI reports for marketing, finance, product etc. to translate numbers and facts to inform strategic business decisions.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Power BI by analyzing sales figures & financial figures.
• Created Customer Dive Dashboards to analyze buying patterns of the customers which helped the marketing department to retain the existing customers and bring in new customers to the platform.
• Created a Psychic Deep Dive Dashboard for the Product department to help manage psychic performance and increase productivity.
• Created customer churn analysis report and used predictive analysis techniques to predict customers who may drop out and created flags for the marketing department to send them offers to retain them.
• Deeply analyzed customer satisfaction data to help improve customer satisfaction.
• Created Financial Reports highlighting areas of Sales growth, Sales Trends, Direct Expenses and Profitability to help the finance department take informed decisions.
• Used Power BI features to build and configure Hierarchical dimensions, Measure, Calculated Columns, KPI, Filter and Aggregations.
• Created and developed Power BI visualizations for the Key Performance Indicator (KPIs) and trend analysis.
• Generate joins and sub-queries for intricate queries involving multiple tables and fields.
• Expertise in data storage structures, data mining and data cleansing.
• Established Logical and Physical database models to design source to target process
• Created Logical/physical Data Model in Power designer and have worked on loading the tables in the Oracle based Data Warehouse
• Used Common Table Expressions (CTE’s), Constraints, and Complex queries to fetch the data from different servers.
• Created frameworks and processes for data security to keep customers and payments data secure and confidential.
• Attended the project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads.

Environment: MySQL, MySQL Workbench, SQL Server, SSMS, SSIS, Azure, Oracle, Power BI, Jupyter Hub, Slack

Profolio Manager

Confidential

Responsibilities:

• Oversaw the garage management for high profile buildings under the Lincoln Property Company and Brookfield Properties.
• Take charge of client's projects and ensure the project is done within timely manner and on budget.
• Developed successful relationship with Tenants to ensure all their parking needs are met and make parking a pleasant experience in our facilities.
• Sourced, developed and managed relationships with external suppliers to ensure cost-effective and timely delivery of services to support sales and marketing programs.
• Followed up with sales teams on behalf of the clients by acquiring updates on equipment, installation and paintings for the property.
• Review financial statements and provide Monthly Management reports to clients analyzing on actual revenue performance and compare with budgeted projections.
• Prepare and submit yearly budget plans to client as well as create Quarterly presentations to detail YTD financial results and provide new opportunities for the coming year to clients.
• Manage a team of 30 at my current portfolio and managed over 50 employees overall under Confidential +.
• Produced information books and financial data, carried out background research findings on parking-based companies prior to senior managers with potential clients.

Environment: Microsoft Office, QuickBooks, IProcurement, Telerev, CARS and ECARS, Citrix, iPayable, Hyperion, TicketTech, Skidata,WPS, TIBA, Amano, DataPark.