Developed, tested, and optimized Azure Data Factory pipelines for data ingestion and transformation from multiple sourcesCollaborated with cross-functional teams to manage and maintain the enterprise data warehouse, ensuring data integrity, optimizing performance, and supporting business intelligence initiatives across the organization.Design and develop dynamic Power BI reports and dashboards, transforming complex datasets into actionable insights to support data driven decisions.Develop and implement efficient, scalable data models that optimized query performance and support advanced analytics in business intelligence platforms.Conversion of Tableau dashboards, Alteryx workflows, and in-house reporting solutions to Power BI, streamlining data visualization, enhancing reporting capabilities, and improving performance across the organization.Managed full project lifecycle from inception to completion, including requirements gathering, development, user testing, and deployment, ensuring successful delivery that met stakeholder expectations and business objectives.

Developed, maintained, and delivered an on-premise Data Warehouse for analytics and modeling teams using MS SQL Server and SSIS, ensuring optimized data workflows.Designed and managed SSIS packages for ETL processes, integrating data from multiple sources into production environments while overseeing database backup and maintenance routines.Supported cross-functional teams by providing comprehensive data integration solutions across the business.Led data integration efforts for ongoing and new projects, ensuring seamless collaboration and timely delivery.Developed complex stored procedures, views, indexes, and tables to address business needs, while conducting performance tuning to optimize database performance.Designed and implemented data modeling structures for the Data Warehouse, empowering the analytics team with efficient and reliable data architecture.Created and managed data import/export processes between multiple vendors and internal teams for predictive modeling and analysis.Monitored and maintained server capacity, database health, and transaction logs, ensuring optimal server performance and productivity.Troubleshot and resolved issues during daily data loading processes to minimize disruptions.Delivered ad hoc T-SQL scripts and reports for management teams to support decision-making and operational insights.

Developed and managed a Data Warehouse for Sales, Marketing, and Analytics teams using MS SQL Server and SSIS, streamlining data storage and accessibility for business insights.Created SSIS packages to facilitate data transfers and ETL processes from multiple sources into production environments, while managing database backup procedures.Designed and developed workflows in Alteryx for business end users, enhancing data processing efficiency.Monitored and maintained server capacity, database health, and transaction logs, ensuring optimal server performance and productivity.Developed and managed SSAS cubes and their load processes, enabling enhanced data analysis capabilities.Created and administered role-based security for multiple business partners, ensuring secure and compliant data access.Collaborated with cross-functional teams throughout the project lifecycle, from requirements gathering to successful delivery, ensuring alignment with business goals.Troubleshot and resolved errors in automated processes during QA procedures, ensuring smooth deployments and minimal disruptions.Produced ad hoc T-SQL scripts and reports for management teams, providing actionable insights for decision-making.

Developed and managed a Data Warehouse for the Decision Sciences analytics and modeling team using MS SQL Server and SSIS, supporting data-driven decision-making and efficient data workflows.Created SSIS packages for data transfers and ETL processes, integrating data from source systems to production environments and overseeing database backup procedures.Developed and maintained SSRS reports for executive management, delivering insights on lead generation, financial performance, call center operations, and payday loan metrics.Monitored and maintained server capacity, database health, and transaction logs to ensure optimal server performance and productivity.Resolved errors and challenges in automated processes and QA procedures, ensuring smooth deployments and minimizing downtime.Generated ad hoc T-SQL scripts and reports for management teams, providing actionable insights to support decision-making.

Developed and managed both scheduled and ad hoc reports using MS SQL Server and SSRS, ensuring timely and accurate data delivery.Created and managed SQL databases using MS SQL Server to support business operations and reporting needs.Provided daily and weekly reports to executive management and vendors, delivering key insights to drive decision-making.Managed vendor relationships across 14 call centers in the US and offshore, ensuring smooth operations and collaboration.Oversaw the implementation of internal support pages, from requirements gathering through to execution and deliveryIdentified opportunities to improve efficiency in processes and analysis, leading to increased productivity and optimization of business operations.