6 years of experience in SQL development, Reporting, Database Design, Development and Implementation of Client-Server Applications & Business Intelligence/Reporting applications using SQL Server, Business Objects and Tableau. Hands on experience with Tableau desktop 8/9/10.1 and 10.3, Tableau server and Tableau Reader. Extensive experience working with Tableau Software as a dashboard developer. Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading. Hands on experience with Business Objects 4.1 Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles. Highly experienced in whole cycle of DTS/SQL server integration services (SSIS Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Sets, Groups, Calculations and Maps etc., Experience in creating visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables. Expertise in generating reports using SQL Server Reporting Services, Ad hoc Reposts, Crystal Reports, and MS Excel spreadsheets and Power Pivot. Expert in designing Enterprise reports using SQL Server Reporting Services, generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS. Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
6 years of experience in SQL development, Reporting, Database Design, Development and Implementation of Client-Server Applications & Business Intelligence/Reporting applications using SQL Server, Business Objects and Tableau. Hands on experience with Tableau desktop 8/9/10.1 and 10.3, Tableau server and Tableau Reader. Extensive experience working with Tableau Software as a dashboard developer. Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading. Hands on experience with Business Objects 4.1 Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles. Highly experienced in whole cycle of DTS/SQL server integration services (SSIS Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Sets, Groups, Calculations and Maps etc., Experience in creating visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables. Expertise in generating reports using SQL Server Reporting Services, Ad hoc Reposts, Crystal Reports, and MS Excel spreadsheets and Power Pivot. Expert in designing Enterprise reports using SQL Server Reporting Services, generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS. Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
- Created SQL stored procedures and PL/SQL scripts to optimize performance for financial and operational data extraction.
- Developed data pipelines in Google Cloud Platform (GCP) using Airflow operators to automate Extract, Transform, Load (ETL) processes.
- Built interactive Tableau dashboards to visualize complex financial data and identify performance improvement opportunities.
- Implemented row-level security and data blending techniques to ensure secure and accurate reporting across multiple business units.
- Collaborated with cross-functional teams to deliver healthcare solution implementations aligned with stakeholder expectations.
- Utilized Python and Excel to streamline data analysis, creating executive-level reports for business result tracking.
- Developed scalable data processing workflows using Azure Databricks and Apache Spark for real-time analytics.
- Analyzed business systems to identify inefficiencies and gathered requirements from stakeholders for service functionality improvements.
- Contributed to high-performance software solutions using Python and object-oriented design principles.
- Built data integration pipelines using Azure Data Factory and AWS services like S3 and Lambda for efficient storage.
- Conducted rigorous testing of service solutions to ensure reliability and performance met quality standards.
- Supported global teams in migration projects by aligning solution designs with regional requirements and diverse geographical needs.
- Developed machine learning models in Python for customer segmentation and demand forecasting to support strategic goals.
- Wrote Python scripts using Pandas and NumPy to automate data workflows and improve operational efficiency.
- Integrated SAP data sources to provide unified business insights and streamlined reporting processes.
- Applied advanced SQL and scripting techniques to optimize data analysis for evolving business needs.
- Collaborated with cross-functional teams to define data quality requirements and provide analytical support.
- Presented data-driven findings and recommendations to senior management to inform decision-making processes.
- Extracted sales transaction data from SAP ERP using SQL queries to gather insights on orders and customer behavior.
- Automated data integration from AWS S3 and Azure Blob Storage using Python scripts to maintain data consistency.
- Performed exploratory data analysis (EDA) using Pandas to identify trends and seasonal patterns in product performance.
- Built dynamic financial reports and dashboards in Tableau and Power BI to track sales metrics over time.
- Implemented predictive analytics into sales dashboards to automate the evaluation of product performance.
- Validated data accuracy across multiple sources to support reliable business intelligence reporting.