* Partnered with business stakeholders to define data analytics and reporting needs * Extracted, transformed, and loaded data using C#, SQL, Azure Data Factory, and DataBricks * Developed and maintained Power BI dashboards and reports * Led product requirement refinement and execution in an Agile environment * Documented, monitored, and updated tasks in Azure DevOps • Partnered with business stakeholders to define data analytics and reporting needs. • Lead end to end ETL development using Python, SQL, Azure Data Factory, and DataBricks to deliver event level data to stakeholders • Developed interactive Power BI visualizations, resulting in expedited decision-making processes for 30 warehouse operations. • Spearheaded initiative to utilize Microsoft Loop as the team's primary collaborative tool.

Gathered stakeholder requirements in virtual whiteboard sessions to determine the business needs and the most impactful use of available dataCoordinated with data architect, engineer, and developers and security administrators to deliver custom Power BI report applicationCleaned and processed data using Python in Azure Databricks, SQL in Synapse, and -M /PowerQuery and DAX for Excel and PowerBIEnsured all code and reporting logic was synchronized with data team by utilizing Azure DevOps and Git RepositoriesAdjusted reports, code and relevant documentation as business needs evolved.Developed company-wide reports that were critical to high-stakes decisions, client retention, and day-to-day decisions.Generated ad-hoc reports ranging from summarized data extracts in excel to detailed interactive PowerBI reports while communicating shifting priorities with team, management, and stakeholders.

Collaborated with stakeholders to establish scope of data projects and act as liaison between SMEs, data and analytics teamsDeveloped Power BI dashboards utilizing DAX and PowerQuery in order to provide data-driven insights for projects ranging from enterprise resource planning, material quantity counts, estimations and forecasting, and data quality assuranceWrote queries in Python, SQL and CosmosDB to allow for efficient extractions in Power BIReverse engineered existing Tableau and Excel dashboards to be utilized in Power BIDeveloped complex data transformations across multiple sources in Python for the purposes of cleaning and comparing data from different stages of engineering projectsDesigned, tested and implemented various data processing automation tasks in Power Automate, Python, and Azure Data Factory based on the scale and needs of the customerRoutinely wrote, collaborated and maintained accurate documentation of stakeholder requests, current processes, planned processes and user guides

Provide strategic, analytical, and technical support for business intelligence activities for primarily marketing departmentFunction as an intermediary between the marketing, finance, and executive stakeholders and the technical community working with IT project teamsDraft alternate solutions and design processes and systems which includes user impact considerations, cost and benefit analysis, and processing specificationsCritically evaluate information gathered from multiple sources, reconcile conflicts, abstract up from low-level information to a general understanding, and work with stakeholders to uncover unmet business needsPerforms ongoing monitoring and refinement of reports

Development of key internal integrations and systems by turning business processes into technical documentation for the development team’s implementation.Documented as-is end-to-end data warehousing architecture for lead acquisition and distributionDesigned, tested, implemented, and lead support for company's direct mail and web lead resource management system, in addition to processing new leads in bulk quantities and configuring system to accept ingestions of different formatsAdministratrate changes in KingStar's Five9 account for inbound, outbound and reporting calls as business needs require, as well as troubleshoot any system errors.Utilize BI tool Tableau to analyze inventory, costs, usage, and performance of leads and their respective sources.represent large amounts of data relevant to business needs in an elegant and concise manner Gathered requirements from a variety of key stakeholders to create multiple Tableau data sources for purposes including but not limited to finance, inventory management, employee performance, and vendor performanceCommunicate requirements and management's changing priorities to overseas developer teamOversee new employee onboarding to ensure assigned equipment is configured correctly and is in working orderInstall and maintain conferencing system for the entire companyRun basic SQL queries to extract needed data as management and analytic team requiresRegularly met with stakeholders from all departments on shifting KPIs, project statuses and deliverables

Co-Leader for OTRS ticketing system design and implementation projectDocumented database architecture in Visio for product ownerAttended weekly sprint meetings and met with SCRUM team on a regular basis to gage strengths, weaknesses, and availability in order to further develop OTRS ticketing systemLead team to import customer database into a backend system by identifying skillset of other members of NOC and other departments and executed through MySQLAnalyzed customers comments and concerns to build customer interface section of OTRS ticketing system, customized streamlined view of their ticketing data in miscellaneous graphs and charts Generated a variety of reports for manager using Excel and Crystal Reports upon request Maintained communication with engineering team in order to keep up to date with software changes that would affect media presentation and distribution to other sites, in addition to ensuring future software updates would go in line with OTRS development

Provide technical and troubleshooting support through e-mail and phone calls and determine if on site assistance is necessary and/or cost effectiveRemotely maintain and upgrade multiple servers simultaneously through SSH Instruct new hires on best practices and operating proceduresAssisted in maintaining Amdocs ticketing system by creating custom reports utilizing SQL language JDE Oracle database systemPrioritized hundreds of tickets to be dispatched, updated, or diagnosed on a daily basis efficiently in a fast paced environment with minimal to zero supervisionEnforced project deadlines and schedules by coordinating schedules and utilizing the strengths and weaknesses of project team Consulted by supervisor of managed services to document and analyze work flow patterns in order to improve speed and ease of use of Amdocs ticketing and dispatching system Elected by peers to work with supervisors and other elected employees of differing levels to discuss improvements to dated and obsolete processes

Designed an SQL server database to meet Alliance's specifications that hundreds of users could track services provided to new and recent immigrants including community services and monetary assistance.Identified optimal hardware and server needs for implementation of the database.Tested the database to ensure proper functionality and provided the client with a demonstration using Microsoft Access.

Collaborated with a team of 2-4 consultants to provide face-to-face consultations to clients creating, modifying, or expanding their business.Advised clients on IT needs by identifying solutions and effectively communicating the status on the systems development life cycle.Assisted a wide range of industries including personal training, spiritual healing, personal services and green energy.Designed and implemented new website layouts utilizing CSS, as well as made changes to client websites using Javascript.Implemented best SEO practices to make web content for web crawlers to access, as well as registered websites with Google and Yahoo maps to better index the websites.Independently updated and fixed 2 websites for both a personal training and a shoe shining business. Researched and presented web 2.0 and search engine optimization trends for the convenience of fellow interns and their clients.