Michael Anese Email & Phone Number

Punta Gorda, Fl, Us

Punta Gorda, Florida, United States

Orchestrated end-to-end pipelines to extract, transform, and load data into delta tables using Fabric Notebooks, PySpark, and Dataflows.Implemented medallion Lakehouse patterns with parameterized pipelines to ensure quality, timeliness, and accuracy of data while simplifying management and knowledge transfer needed for operation.Led teams of Business Intelligence developers and Data Engineers to create a data environment conducive to semantic modeling and data analysis.

United States

Served as both Power BI developer and architect, leading projects across a range of industries, including steel, microchip, textile, and floor covering manufacturing. Created standardized templates for things such as best practices related to Power BI source control management, style guides, and report design, as well as testing and handoff documentation. Established myself as one of the leading subject matter experts related to semantic model design and complex DAX development, becoming a mentor for other developers on the team. Provided leadership support to troubled projects by partnering with client business leads to identify inefficiencies and implement processes to address them.

Responsible for gathering and converting user requirements into software solutions.Launched the company’s first Power BI/data cube solution in response to the ever-changing landscape defined by Covid often bringing daily reporting needs to a fully automated state.Used Microsoft Power Query to extract data from a variety of external sources (SQL, Snowflake, Azure, Sharepoint) and modify into required format for model to be built on.Built Power BI and SSAS models from scratch including ETL, Tabular Modeling, DAX, and Visualizations.Frequently communicated with Executives and Managers from a variety of departments to determine business needs and educate our end-users on how to consume BI reports and models.Projects range from daily operational metrics available for all end users to our CEO dashboard helping the company’s leaders gain better insight into how these metrics impact financials.Involved in planning, defining, and designing data base requirements to allow models to function properly and efficiently.Implemented dataflows to better leverage limited Power BI service server resources.Utilized Power BI Live and OLAP cubes to create many different reports based on the same underlying model and business logic to promote uniformity of analytics across the organization.Promoted “Analyze in Excel” features from Power BI service to our analysts allowing for greater self-service of data while staying true to agreed upon business rules and definitions.Performed Power BI Administrative tasks such as managing Gateway and user permissions.Established broader access to Power BI through embedded capabilities on the company intranet.Translated business requirements into technical design specifications.

Germantown, Maryland, United States

Was responsible for working alongside our CTO to implement high priority projects spanning multiple departments.Established the company’s intranet housing core materials from each department as well as practical functionality including but not limited to forms, trackers, SSO links and file sharing.Created technical design specs and managed offshore vendors to for development of an automated workflow to alert all critical systems of new hires and terminated users to be commissioned/decommissioned in a timely and effective manner.Automated PBC (Productivity Based Compensation) contracts utilizing Process Robot and Mail Merge for the dynamic placement of clauses and figures.Refurbished and deployed 35 desktop PCs to be decommissioned to accommodate the urgent need to work from home brought about by Covid.

Hudson, Ohio, United States

Responsible for developing and maintaining automated data pipelines using Process Robot.Frequently worked alongside hospital I.T. staff in creating throughput extracts to be uploaded to SFTP for processing.Used ETL methodologies to acquire, transform, and ultimately deliver data to our SQL databases and proprietary data visualization platforms in a uniform manner.Developed Python executables using Pandas where necessary to extend the built-in functionality of the Process Robot automation software.Build error handling, logging, and notification systems to catch possible pipeline issues and remedy in a timely manner.

Hudson, Ohio, United States

Specialized in creating analytics using Excel and Power Pivot to better improve business and operational procedures.Frequently met with Vice Presidents and hospital directors to better pinpoint reporting needs in the field.Created and maintained our DSO (Dynamic Staffing Optimization) models to staff hospitals more appropriately while balancing cost.Established the template for an Executive MOR (Monthly Operations Report) using a multitude of data sources to provide leadership transparency into daily operations.Streamlined payroll processes by enabling dynamic templates to ingest and transform raw data into the necessary format to be loaded into ADP.