Experience

Rockefeller Philanthropy Advisors

• United States
• Non-profit Organizations
• 1 - 100 Employee

• Business Intelligence Lead

  • Sep 2022 - Present

  New York, United States



Philip Morris International

• Switzerland
• Tobacco Manufacturing
• 700 & Above Employee

• Business Intelligence Developer

  • Aug 2021 - Sep 2022

  • Testing, implementing and documenting BI systems, • Evaluating existing data-collecting and analytics systems • Build predictive models • Analyze big data to discover trends and patterns • Translate business needs into technical specifications • Ensure we use accurate and secure methods to extract data • Establish procedures for data sharing with internal and external stakeholders • Use data visualization techniques to present information • Data Analysis on Power… Show more • Testing, implementing and documenting BI systems, • Evaluating existing data-collecting and analytics systems • Build predictive models • Analyze big data to discover trends and patterns • Translate business needs into technical specifications • Ensure we use accurate and secure methods to extract data • Establish procedures for data sharing with internal and external stakeholders • Use data visualization techniques to present information • Data Analysis on Power BI • Experienced Scrum Team as a Developer • Building parameterized dynamic reports with hierarchical drill down, and drill through reports using SSRS or Power BI reporting tools, tell a story with data. • Creating dashboards, Tabular, Matrix reports, Charts and graphs as per the customer requirements. • Developing and loading the staging databases from heterogeneous sources to staging the target tables and applying different transformations in between. • Designing SSIS packages using several transformations to perform data profiling, data cleansing and data transformation. • Utilizing SSIS transformations such as lookup, derived column, data conversions, conditional split, SQL task, script task, send mail task etc. and analyzing the data to implement incremental/delta load using a merge statement. • Experience with Tableau reporting tools and the full Microsoft BI Suite (SSMS, T-SQL, SSIS, SSAS, SSRS). • Scrum software development experience including requirement gathering, analysis, design, development, testing and implementation of various medium and large-scale client/server applications in a structured development environment • Experienced Daily Meetings, Sprint Planings, Agile Software Development in Scrum team. Show less



Smartiks Technology Solutions

• Türkiye
• Information Technology & Services
• 1 - 100 Employee

• DWH & Business Intelligence Consultant

  • Jul 2021 - Aug 2022



Akkim Sealants & Adhesives

• Türkiye
• Building Materials
• 100 - 200 Employee

• Business Intelligence & Data Management Specialist

  • Sep 2019 - Aug 2021

  • Strategically design and implement BI software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing and rolling out BI solutions to end users • Develop reports and dashboards on SQL servers. • Prepare test cases and plans and perform tests on systems • Design and fabricate various SQL Server Integration packages and prepare appropriate reports for data collection • Administer design of… Show more • Strategically design and implement BI software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing and rolling out BI solutions to end users • Develop reports and dashboards on SQL servers. • Prepare test cases and plans and perform tests on systems • Design and fabricate various SQL Server Integration packages and prepare appropriate reports for data collection • Administer design of Business Intelligence projects and develop dashboards and operations for reports • Analyze business requirements and assist in appropriate configuration for all solution architecture. • Supervise implementation of all new software tools and systems. • Monitor monthly release cycle and perform unit tests for Quality Assurance. • Developed advanced SQL queries and Stored Procs to generate data reports by digging into database details to ensure appropriate data filters are applied based on the business requirements. • Performed SQL query performance tuning by creating indexes, setting transaction levels and changing query structures with CASE statements, CTE's and VIEW's. • Built SSIS ETL process to migrate data from multiple data sources (SQL Server, Excel, Flat Files) to destination database server data warehouse. • Collaborated with the business and technical staff to develop requirements document and ETL design specifications. • Created complex SSIS packages with error handling capabilities using various data flow task transformations (conditional split, data conversion, look up, merge), tasks (execute SQL, data flow, script, send mail tasks) and containers (sequence container, for loop, for each loop container) etc. • Built data warehouse with Star and Snowflake Schemas to generate OLAP data cubes to analyze via SSAS with data modelling best practices. Show less