• Worked closely with the leadership team to gather & analyze business needs, and translated them into the proper technical requirement. Defined business requirements and analyzed the possible technical solutions.• Perform structured and creative analysis of web portals to identify opportunities to enhance client satisfaction, work flow efficiency and overall effectiveness.

Architect and deploy analytics solutions that help bring visibility and predictability to business stakeholders. • Gathered business requirements and delivered business analytics based solutions using structured/unstructured business data to help achieve measurable business outcomes for clients.• Effectively analyzed the data and deliver the intelligence and insights using BI tools Tableau that enables smarter decision making, actions and outcomes.  • Developed key business insights from analytics and presented to clients weekly.• Provide data visualization services that allows clients to unlock the power of their data.• Manage business requirements and scope in an ongoing and fluid environment. • Participate in planning sessions with key stakeholders to understand requirements for data driven analytical solutions.• Research & identify business critical data from the underlying data sources (Google Analytics, SQL) and perform analytics.

Online platform for property buyers & sellers to locate properties of interest in Mumbai and suburbs,Launched in April 2015. . • Technical lead on real estate BI project.• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS).• Developed SQL queries to extract property details within large data warehouse and identified the common buying trends.• Created dashboards using Tableau dashboard and prepared user stories about customer behaviors to deliver actionable insights.• Extensively used pivot tables, V lookup and complex SQL queries for real estate data analysis.• Prepared ETL mapping document for the data models developed, which encompasses server name, database name, accounts, tables, and direction of data flow, column mapping, transformations, sequences, Data dictionary and Metadata.• Formulized go-to-market strategy to capture the local market by 7% in 3 months.• Increased property listing by 42% within 2 months by creating the strategic partnership with property brokers.• Developed a model with the help of multivariate regression analysis to estimate the price of the home in Mumbai.

Well-known in the construction industry for good quality homes. 110 employees. Led 10-person team. Managed project costs, scheduling, deliveries and customer communication for two large-scale construction projects totaling 100,000sf. • Performed SWOT analysis of Mumbai real estate and identified middle-income target market.• Used Tableau to create visual interactive dashboards using calculations, parameters and workbooks for strategic business decision making. • Developed SQL queries to extract property details within large data warehouse and identified the common buying trends.• Evaluated opportunities for growth using qualitative research, resulting in two new projects worth $1.5M. • Developed business strategy for B2B marketing, resulting 6% market penetration. • Streamlined communication on projects decreasing project costs by 14%. • Introduced electronic filing system reducing man-hours by 80%. • Defined & architected ETL framework for Data Warehouse & Real estate Business Intelligence Application.• Prepared ETL mapping document for the data models developed, which encompasses server name, database name, accounts, tables, and direction of data flow, column mapping, transformations, sequences, Data dictionary and Metadata.• Developed a pricing model using multiple regression analysis to determine base price of the home• Conducted due diligence on over 100 proposals and selected vendors.

Canadian multinational IT, systems integration, outsourcing, and solutions company. Revenue: C$10.5 billion.Software Engineer- (Business Intelligence Analyst/ Business Analyst) for UK-based Equity Insurance Group, seventh largest auto insurer worldwide.• Mentored 4 teams on multiple deliveries.• Developed critical project matrix dashboards on key KPIs across 4 modules for executive consumption. • Collaborated with clients for requirement analysis, feasibility analysis, prepared requirement specifications,functional specifications, use case specifications and development estimates.• Conducted root cause analysis and defect prevention weekly meetings, resulting in 40% defect reduction and 65% increase in system stability.• Identified and automated manual tasks reducing man-hours by 20%. • Participated in designing and development of software using software development life cycle (SDLC) & agile scrum framework.• Strong understanding of incident management and change management.• Created BI reports to provide insight to client on claims and policy data for strategic decisions. • Developed BI models and reports using SSIS.• Defined & architected ETL framework for Data Warehouse & Business Intelligence Application.• Extensive knowledge of Dimensional modelling, Star & Snowflake schema designs.• Good exposure on control flow level items, data flow transformations and event handlers.• Expert in package configuration, logging and deployment on various environments.• Investigated and fixed recurring incidents to improve system efficiency and to reduce incident queue 20/week. • Monitored unit and system testing, conducted UAT and verified performance & reliability.• In-depth understanding of business process flows, managing multiple stakeholders, • Monitored the project deliverables to the clients, achieved full rating on customer satisfaction survey.