Experienced Data Engineer and Business Intelligence Analyst with a demonstrated history of working in the information technology and services industry. Skilled in Business Intelligence Tools, SQL, ETL, Data Modeling, SAS E-miner, Data Warehousing, Python, Visualization tools like Tableau, QlikView, PowerBI, and SAP Lumira. Strong information technology professional with a Master of Science - MS focused in Business Intelligence and Data Mining from The University of Texas at Dallas.
-
Experience
• Built Qlik sense dashboard with custom visualizations, advance analytics extensions to analyze how Lennox dealers effectively use CAP and marketing funds programs. Wrote SQL scripts to fetch multidimensional data from HANA, Oracle and Azure datalake. Generated QVDs to optimize data loading time by 50%.
• Built AI model for sentiment analysis, key-phrase extraction, entity correlation and identification with Microsoft Cognitive Services APIs and Natural Language Processing (NLP). Customized Azure API to transcribe voice data into text data. Used power queries to build Power BI dashboard for effective marketing and sales decisions.
• Performed Migration of all the Qlik applications from Oracle database to HANA. Developed BODS workflows to create virtualized tables on BW HANA. Built HANA views to improve application performance and data security.
• Performed Exploratory Data Analysis using Python Pandas, NumPy and Sci-kit learn from internal/external data sources to gather, synthesize and analyze relevant data and draw conclusions to identify relevant business trends and patterns
• Developed business dashboards, storylines using SAP Lumira designer with adaptive and scalable layouts to assist managerial decision making and learn customer buying patterns.
• Built ETL workflows to feed data into SAP system from non-SAP system to blend from various sources such as flat files and Oracle with destination format with Informatica PowerCenter.
• Used Power Query, Power Pivot, DAX Queries, Power BI Query Editor for data processing, staging, interpretation and feeding to dashboards in Power BI
• Proficient in managing SQL database tables and have utilized SQL queries to optimize query performance by using constraints, Indexes, joins and sub queries. Reduced query processing time in production environment.
• Developed interactive dashboard in Tableau with data blending from various sources to provide drill-down and drill-through capabilities, Local and Global filters, LODs and Calculated Fields for metrics.
• Utilized SAS and SQL extensively for collecting, validating and analyzing the raw data received from the client. Developed Reconciliation application for data management to generate input files of data and performed visualization with Tableau.
• Monitored ETL processes on Informatica Workflow monitor to support existing workflows and solved tickets to ensure production is always up and running.
-
Projects
• Built pipelines for a prediction model to predict player’s rank with insights from historical data. Performed data gathering, cleaning and analysis with help of python using various packages like Seaborn, NumPy, Pandas and developed predictive models such as Logistic Regression, SVM, Gradient Boosting and KNN
• Forecasted and analyzed housing sales price by constructing hypothesis, build regression model in SAS by performing analysis on various input factors and dataset. Made use of Linear Regression and Neural Network models to perform analysis and compare outcomes.
• Designed a business process model to introduce smart vending machines using BPMN and OOA&D methodology. Business model which uses IoT to re-order sales materials through machine to machine communication without any human involvement.