Business Intelligence Power Bi
Resume:
Robin Ying
***********@*****.***
https://www.linkedin.com/in/robin-ying-bb34b54b/
Summary:
Master’s degree in MIS (Management of Information System)
** ***** ** **** ********, report, data modeling and MS SQL Server database administration (DBA) experience, MS Azure cloud
10 years Business Intelligence (BI) experience (data ETL, mapping, package configuration and migration, analysis service and reporting) using MS SQL server SSIS, SSAS, SSRS, Power BI, Visual Basic, APIs
Power BI Proficiency: Administration, Report server installation and configuration, Report Service, Report Builder, Power Query, DAX, API, Visualization, Publication
Solid SQL Developer and DBA skills: Server upgrading, data modeling and database design, create tables, views, function, index, constraints, write stored procedure and complex query, performance tuning, using CTE, variables, dynamic SQL, cursor, trigger, XML
NOSQL: Graph database and Neo4j, Cypher query language, Big data, Hadoop, MapReduce
Expertise on MS Office Suite: Excel (Pivot Tables, VLOOKUPs, Models, VBA), Word, Outlook, OneNote and PowerPoint
Knowledge of data analysis languages: PowerShell (cmdlets, functions, variables, parameters, exception handling and automated scripting), Python, R
Trained in project management using SDLC, Agile/Scrum, O-O and UML etc.
Professional experience of MS SQL Database server, virtual machine VMware and Window Server installation and configuration
Knowledge of PL/SQL Oracle Database and DBA: user account setup, system privileges, database security
Full knowledge of finance: accounting principles, billing, AP, AR, GL and collection
Highly collaborative team player with advanced verbal, written communication, and interpersonal skills
Proven ability to prioritize and complete multiple tasks, capacity to approach problems effectively and creatively
Self-motivated quick learner and hard worker. Willing to take responsibility
Superior analytical skills to think through complex, multidimensional problems and propose solutions
Work History
Global Support Services, Elite Technology New York, NY Oct. 2024 – Present
Senior System Support Analyst
Responsibilities:
Provided expert-level support for ERP systems Elite 3E, assisting global users with issue resolution
Investigated on prem SQL database utilizing remote connection, reviewed SQL logs, window events and identified issues
Managed Azure SQL Databases, analyzed cloud SQL logs and end-to-end transactions using AppInsight in Azure DevOps to identify and resolve performance issues
Leveraged browser developer tools to test the business process and collect HAR files for troubleshooting
Identified software defects, bugs, and system performance issues. Conducted high-quality searches in knowledge bases, hotfixes, and instance work orders
Utilized SQL for complex data extraction and transformation, feeding clean datasets into Power BI and Excel for analytics and forecasting
Collaborated effectively with stakeholders, ensuring 100% customer satisfaction through proactive communication and problem-solving
Maintained and updated documentation, work protocols, and instructional manuals to enhance efficiency and knowledge sharing
IT Department, Cole Schotz P.C., Hackensack, NJ May 2024 – July 2024
SQL/Business intelligence Application Engineer
Responsibilities:
Administered application - Foundation for Marketing Dept. Updated ETL scripts to only import changed data from Prod SQL database to application server to improve application performance
Responded to ERP systems Elite 3E tickets, solving user business troubleshooting requests
Monitored the application - viDesktop for HR and troubleshot the issues emerged
Designed and maintained robust data models to support system reporting needs using SQL and Power BI, ensuring data integrity and performance optimization
Reviewed and updated the technical documentation used by team and users
Technology Support Group, Kramer Levin Naftalis & Frankel LLP, NY, NY Jan. 2023 – Apr. 2024
SQL/Power BI Analyst
Responsibilities:
Oversaw, monitored, tracked, and reported the performance and capacity of business system to ensure the health and stability of the solutions owned. Provided recommendations to tech lead for enhancements and new capabilities
As point person, conducted routine systems ticket response, solving technical issues, follow-up of users’ feedbacks
Performed data extraction, transformation, loading (ETL), analysis, and troubleshooting using BI tool Intapp Integration Builder and complex SQL queries, etc.
Developed and delivered enhanced business reports using SSRS, Power BI Report Builder for various administration, finance and marketing departments and deployed to Power BI development and production report servers
Created advanced Power BI dashboards and automated reports, integrating data from SQL databases for business insights
Wrote complex SQL scripts to read data from production SQL database to create business KPI notifications for various stakeholders
System production web server load-balancing certificate creation, renewal, application binding and configuration
Created system architecture and process documentations for use by team and users
Had routine working reports and regular MS Teams meetings with management to present work progress and provide planning, roadmap, patching, testing, QA, and remediation etc. suggestions
District Council 37, Manhattan, NY Feb. 2016 – Dec. 2022
Database Analyst/DBA
Responsibilities:
Database management. patching, Data Modeling, Database backup, restoration, data loading, mirroring setup, table/view creation, PK/FK, index, and default constrain setup
Routine database monitor, maintenance, permission control, troubleshooting to ensure data integrity and consistency
Administrated Microsoft Dynamics GP application for user permission, access privilege, and security settings
Various environment (i.e., Development, Test and Production) data migration, testing, and store procedure deployment
Created DBCC plus cursor batch file to re-size database files to optimize available disk space
Established database security and permission procedures. Maintained records/documentations of programs
Applied best practices in data modeling to support scalable BI solutions, leveraging Power BI, SQL, and Excel for enterprise reporting
Compassionate Care Hospice, Parsippany, NJ May. 2015 – Jan. 2016
Sr. SQL/Business Intelligence Developer
Responsibilities:
Designed, built and data ETL of a company major Data Warehouse
2006 version SAP B1 ERP system financial module Meta data research, documentation, and data analysis
Wrote complex SQL queries, stored procedures to extract data from SAP server and create comprehensive business reports using Power BI
Performed routine maintenance and update of company master data stores as well as data QA
Built interactive Power BI visualizations using well-structured data models to enable strategic decision-making
PharmLogic Analytics LLC, Hoboken, NJ July. 2014 – April 2015
SQL/Business Intelligence Developer
Responsibilities:
Fully responsible for company’s data migration from various sources (Sftp, .txt or .xls files sent by e-mails) into database using ETL tools (BCP, Bulk insert and data import/export Wizard) and SSIS packages. Dealt with rich data. Troubleshot technical issues, optimized package process, and improved ETL efficiency
Designed SSIS packages and setup scheduled jobs to automatically update database tables on daily basis
Wrote complex SQL queries and stored procedures to extract and edit data from database according to business logic to make comprehensive and precise reports daily and monthly
Performed verification and QC of reports from various sources. Designed QC reports using screenshots or Excel spreadsheets. Deployed the QC reports to SharePoint server
Education and certificates:
Elite 3E System Certifications, Elite Technology
Elite 3E IDE Certifications, Elite Technology
Elite 3E Cloud Certifications, Elite Technology
M.S., Management of Information System (MIS), City College of New York, CUNY, New York, NY
B.S, M.S., Bioinformatics and Engineering, Fudan University, P.R. China
Certified Specialist in SQL Server DBA, Learning Tree International, Herndon, VA, USA
Certificate, Microsoft SQL Server Business Intelligence (MSBI). USA Database Training, LLC. Silicon Valley, CA, USA
Contact this candidate