As Associate Project Manager at MAQ Software, I work in an agile environment providing SQL based Business Intelligence solutions to our clients. A common workflow in our projects was to run an ETL on our client's data, stage it in a Data Warehouse, and process that data into an SSAS Cube to be surfaced in a Power BI report. My primary role was to discuss with clients their BI needs and then work with a team of developers to implement all requirements.• Implementation and delivery of Data… Show more As Associate Project Manager at MAQ Software, I work in an agile environment providing SQL based Business Intelligence solutions to our clients. A common workflow in our projects was to run an ETL on our client's data, stage it in a Data Warehouse, and process that data into an SSAS Cube to be surfaced in a Power BI report. My primary role was to discuss with clients their BI needs and then work with a team of developers to implement all requirements.• Implementation and delivery of Data Analytics Visualization solutions o Sourcing variety of data points from On Premise and Azure data bases, third party databases using SSISo Creation of multidimensional cube using SSAS using Relational database concepts and writing DAX queries for Calculated measures in cubeo Performance tuning of databases and SSAS cube solutiono Developed two Power BI dashboard using Direct Query Connection from Cubeo Creating Power BI Apps, Power BI Gateway to facilitate dashboard access to end userso Creating and maintaining app workspaces o Support and maintenance of dashboards as per change requests by end users• Experience in doing data analysis with Ro Data cleansing, data filtering, generating statistical indicators in Ro Data sorting in Ro Finding patterns in data using BoxPlot, Ggplot, finding skewness and Kurtosis Show less

Worked as Operations Intern to study the FBA Inbound process in detail, identify bottlenecks in the current process and establish a Click to Stow (CTS) metric for perfect FBA Inbound Operations.

• Worked for 3 years as ETL Consultant for variety of Telecom projects• 3 years of professional experience in Oracle PL/SQL, scripting (SQL Server) and writing efficient SQL queries, SQL query tuning and database schema design• Hands On experience in PL/SQL, Unix shell scripting, Informatica• Expert with Microsoft BI suite - SSIS, SSAS, SSRS• Expert in performance tuning of SQL databases, writing complex SQL queries and troubleshooting• Exposure to client… Show more • Worked for 3 years as ETL Consultant for variety of Telecom projects• 3 years of professional experience in Oracle PL/SQL, scripting (SQL Server) and writing efficient SQL queries, SQL query tuning and database schema design• Hands On experience in PL/SQL, Unix shell scripting, Informatica• Expert with Microsoft BI suite - SSIS, SSAS, SSRS• Expert in performance tuning of SQL databases, writing complex SQL queries and troubleshooting• Exposure to client interaction, requirement gathering and proposing solutions to data migration issues• Coordinate with Business on specifying rules required to cleanse, standardize existing legacy Master data to meet universal standards• Data validation and reconciliation, Involved in Functional and Performance Testing, resolution of P0 defects within SLA ( Production support)• Automation and simplification of complex ETL Process for optimal utilization of Time and resources. Show less