Kate

Led the migration of on-premises SSIS packages to Data Bricks notebooks triggered by ADF pipelines, improving efficiency by 25%.
Reduced Internal Reconciliation processing time by 300% by improving the code.
Reduced processing time of multiple applications and reports by moving them to Azure.
Developed Azure Data Warehouse solutions, enhancing data accessibility for business stakeholders.
Designed and implemented Power BI visualizations, reducing report generation time by 30%.
Managed production system support and troubleshooting, ensuring minimal downtime and high availability.
Collaborated directly with business stakeholders to learn and document the requirements, designed data mapping documents, and worked as a developer on the technical solution.
Used the following development tools: ADF pipelines, Data Bricks notebooks, Data Lakehouse, Medalion Architecture, Azure Synapse, Spark SQL DataFrames, Python, Scala, Microsoft Fabric, as well as SSIS packages, jobs and pipelines triggers and schedules, OLAP cubes, tabular models, PowerBI reports.
Designed hundreds of ETL packages and pipelines and orchestrated their daily run.

Led the migration of on-premises SSIS packages to Data Bricks notebooks triggered by ADF pipelines, improving efficiency by 25%.
Reduced Internal Reconciliation processing time by 300% by improving the code.
Reduced processing time of multiple applications and reports by moving them to Azure.
Developed Azure Data Warehouse solutions, enhancing data accessibility for business stakeholders.
Designed and implemented Power BI visualizations, reducing report generation time by 30%.
Managed production system support and troubleshooting, ensuring minimal downtime and high availability.
Collaborated directly with business stakeholders to learn and document the requirements, designed data mapping documents, and worked as a developer on the technical solution.
Used ADF pipelines, Data Bricks notebooks, Data Lakehouse, Medalion Architecture, Azure Synapse, Spark SQL DataFrames, Python, Scala, Microsoft Fabric, SSIS packages, jobs and pipelines triggers and schedules, OLAP cubes, tabular models, and PowerBI reports.
Designed hundreds of ETL packages and pipelines and orchestrated their daily run.
Migrated on premises SSIS packages into Data Bricks notebooks triggered by ADF pipelines.
Performed Azure Data Warehouse development.
Developed data migration for banking system migration (Temenos T24).
Adapted and customized Temenos Insight.
Performed data modeling and visualization with Power BI dashboards (DAX).
Worked with stakeholders to improve the end-to-end quality of data.
Orchestrated on-premises and cloud jobs, scheduling and support for more than 200 jobs.
Worked on data integration and production releases.
Worked on data integration projects with Microsoft Synapse.
Investigated calls from the business and applied fixes to BI applications in a timely manner.
Developed SSAS (OLAP and Tabular), SSRS, SSIS, and dynamic SQL.

Communicated business requirements and designed BOBJ universes for large clients, ensuring robust and scalable BI solutions.
Developed Webi and Crystal Reports, improving data visibility and decision-making capabilities for clients.
Created SSIS ETL packages for initial and delta data warehouse loads, ensuring data integrity and reliability.
Communicated user security requirements and prototyped row and column level security in BOBJ.
Communicated business requirements for BOBJ universe design with the external client.
Conducted deployment and UAT sessions with external users over the phone and in person.
Performed project scope analysis and change request work.
Designed and developed complex BOBJ universes.
Developed reports with Webi, Crystal Reports, and SSRS BI reports.
Developed row and column level security to limit access to data for groups of users.
Performed data warehouse database design including tables, stored procedures, functions, star schema, and SCD II.
Used TFS as a version control tool.
Developed SSIS and SAP Data Services ETL packages for data warehouse initial and delta load.

Gathered requirements and developed technical solutions for enterprise level data migration project.
Analyzed existing BI solutions and proposed system redesigns to enhance performance and scalability.
Gathered business requirements and wrote technical specifications for banking system data migration projects.
Developed and maintained Crystal reports and SSAS OLAP solutions, improving reporting efficiency and accuracy.

Analyzed requirements and developed documentation for new data warehouses for large financial institutions.
Designed and implemented data warehouse structures, ensuring alignment with business needs.
Developed complex SSRS reports querying data from Analysis Services cubes, providing actionable insights.
Developed SSRS 2005 reports sourcing data from Analysis Services cubes using MDX queries.
Wrote a best practices document regarding advantages and disadvantages of using SSRS with relational and multidimensional data sources.
Developed Crystal Reports.
Developed ETL with SSIS.
Migrated DTS ETL packages into SSIS.

Improved decision making processes by developing a BI solution for analysis of injuries in Healthcare.
Conducted interviews with researchers analyzing their requests for the BI solution, which facilitated analysis of statistical data in Healthcare.
Developed OLAP database using SQL Server 2000 and 2005 and ETL scripts to load the data into that database.
Developed a number of OLAP reports using SQL Analysis Services 2000 and 2005.
Analyzed the current OLTP database structure, developed ERDs, and proposed indexes and other methods to improve performance.