• Designing, developing and maintaining business intelligence dashboards in Power BI
• Designing fact tables, dimensions and cubes in Power BI environment
• Writing advanced level DAX statements for cubes designing
• Building data modules in power query using M language
• Crafting and executing queries upon request for data
• Presenting information through reports and visualization
• Gathering client requirements of reports
• Building data connection using both technologies i.e. direct query and data load
• Designed multiple dashboards and reports by importing data from SQL Server, MySQL, Postgrese and Orcale.
• Integration of data from multiple sources into data warehouse using SSIS and Power Query.

• Design processes to auto collect the data from different sources including web, SEC documents and public data APIs to minimize the human effort in ETL process.
• Designed and maintained data base in MySQL to collect asset level data of north American real estate sector
• Worked on numerous analysis report to help answer client’s question through data analysis and prediction by connecting dots in raw data and transformed that raw data to predictive report.
• Qualitative and Quantitative analysis of data to provide insight of REIT industry to the client
• Prepared a module to help clients in determining the most potent properties in region.
• Worked extensively on power query and power BI for reporting dashboards
• Data audits to intact the integrity of the product
• Web scraping using python modules of Request, Beautifulsoup and Pandas.
• Bulk update of data into database through excel and csv files
• Successfully implanted automated ETL process though Ms Excel by working on Power query add-on
• Ensure all the departmental and organizational goals are met.
• Ensure that all the training needs are met for the new initiative and that people are fully
equipped to work for the betterment of product.
• Create efficiency reports on users and system to identify the improvement require.
• Advanced level reports creation to measure the user’s efficiency in line with the available systems and also making future prediction on approximate gain of efficacy in result of any enhancement in applications/system
• Supported the marketing team in their functional business projects.

Supports all aspects of process ownership & continuous process improvement for aligned content group(s), including new process roll-out and change management implementation.
• Maps critical processes, conducts shadowing and data analysis and occasionally participates in workflow to ensure that all processes for respective content group(s) are properly documented and adhere to organizational best practices.
• Partners with content team members (at all levels) to identify problems, understand root causes, write clear problem statements and quantify the value/impact of solutions; actively supports the requirements engineering process for proposed solutions.
• Participates in regular development/training opportunities related to various process disciplines & initiatives in order to become familiar with Business Process Management concepts, practices, and procedures; understands how these apply to respective content group(s).
• Communicate to product & project managers for implementation of any functionally in SNL Applications & product.
• ETL of bid data records
• Scrum team member in the capacity of UAT and UT tester.
• Point person of Change Management in my department.
• Querying out the data violators and fixes in bulk through SQL.
• Create efficiency reports on users and system to identify the improvement require.
• Advanced level reports creation to measure the user’s efficiency in line with the available systems and also making future prediction on approximate gain of efficacy in result of any enhancement in applications/system

• Internal Audit and Reconciliation of North America, South America, Asia-Pacific, Europe, Middle East and Africa Companies.
• Review financial statements (10-K, 10-Q, Financial Supplements and etc.) and analyze financial data of North American real estate sector to publish reports in a standardized format which makes data comparison convenient for clients.
• Conduct quantitative analysis of financial data to forecast revenue, identify future trends, and assess risk associated with capital expenditures, acquisitions and JV projects for REITs
• Perform moderately complex statistical, cost, and financial analysis of data reported in the various financial reports.
• Interpret financial transactions and events for users who must make economic or business decisions.
• Supporting the marketing team in their functional business projects.
• Extensive data analysis skill with using advance data analysis tools
• Prepare data and information for making regular report data analysis
• Perform data analysis for complex data and files
• Perform data manipulation
• Identified operational processes inefficiencies and recommended necessary improvements. Analyzed utilization and capacity against performance goals.
• Supported the development of investor presentations and marketing tools.
• Monitored and analyzed Key Performance Indicators (KPI) and financial ratios.
• Conducted periodic risk analysis and evaluation for Provision for Loan Loss (PLL).
• Developed financial analysis reports and presentations by applying acquired financial principles.