Experience

Onward Technologies Limited

• India
• Software Development
• 700 & Above Employee

• MSBI Developer

  • Aug 2022 - Present

  Developed and deployed quality T-SQL queries, stored procedures, views, functions, triggers and jobs • Designed and populated specific tables, databases for collection, tracking and reporting of data • Built SSIS packages to extract, transform and load data to data warehouse • Created and automated SSRS reports • Modified and maintained oracle procedures using SQL • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temp tables to support Power BI and SSRS reports. • Developedcustomer reports using PowerBI • Developed multiple Power BI reports and Dashboards based on different sources databases (DB2, Oracle, Azure SQL, Tableau), flat file and Share Point • Developed complex calculated measures using Data Analysis Expression Language (DAX) Show less



CaprusIT

• Software Development
• 100 - 200 Employee

• SQL Developer

  • May 2019 - Jun 2021

  • Worked with Data Providers to capture and integrate industry research data in internal Research Reporting. • Investigated and resolved data questions/inquiries from the field and internal partners. Creates solutions to data issues in a timely manner. • Monitor and execute needed weekly quality control checks for accurate and timely processing of data warehouse updates. Validates information to ensure it conforms to specification and within defined thresholds. • Worked on Moving data from On-premises to Azure cloud using PowerShell. • Analyze raw data, draw conclusions & develop recommendations writing SQL scripts to manipulate data for data loads and extracts. • Develop Business and Sales reports using PowerBI • Applied SQL Profiler/DTA to attain query optimization and data tuning results. • Generated ad-hoc, parameterized, drill down, and drill through reports utilizing SSRS. • Written expressions to hide sensitive data at report level in SSRS. • Created cache refresh plans for frequently used reports in Report Manager. • Delivered reports on daily, weekly, and monthly basis utilizing subscriptions in SSRS Show less



Wells Fargo

• United States
• Financial Services
• 700 & Above Employee

• Business Intelligence Analyst

  • May 2017 - May 2019

  • Used Python Programming to clean, verify, process and extract data. • Collected data from various sources using Python and loaded data into Pandas Data frame to detect outliers and imputing missing values. • Used packages like Pandas, NumPy, Matplotlib, Seaborn to extract and clean data, plot graphs and export to excel file for analysis. • Worked with the Business users to understand the requirements, layout, and look and feel of the Visualizations to be developed and documented. • Developed and published Tableau Dashboard son Tableau Server using Data Blending, Custom Extract Query, Live Data Sources and consolidated multiple Tableau workbooks into single workbook. • Used LOD (Level of Detail) expressions and complex aggregations at different dimensional levels to provide deeper insights into the available data in order to meet the requirements. • Developed Tableau reports utilizing Data Blending, multi-level hierarchy, Table Calculations, Parameters, Filters, Graphs and Actions. Show less